Is there any documentation how to use the Row key in a Form?
Or does anyone have used this?
I want to use it for something like:
Show me only the row which contains the USEREMAIL().
But I donโt get it working.
The expression needs to result in a rowโs key column value.
I was using the expression
FILTER("CCS_User",UserEmail=USEREMAIL())
And it didnโt work, because FILTER() returns a LIST of keys.
Then I tried
ANY(FILTER("CCS_User",UserEmail=USEREMAIL()))
But this also didnโt work.
Finally I had success with
ANY(SELECT(CCS_User[Key] , [UserEmail]=USEREMAIL()))
Am I missing something, or is this a bug?
This:
ANY(FILTER("CCS_User",UserEmail=USEREMAIL()))
should be this:
ANY(FILTER("CCS_User",[UserEmail]=USEREMAIL()))
Aaaaah. Thank you
lookup(useremail(), Table, Column_Containing_Email, Column_You_Want_Data_From)
In this case the column you want data from is whatever column youโve marked as the Key for the table youโre opening.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |