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 |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |