Form View Option Row key - Only edit one specific row, identified by this key

[Fabian_Weller]

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.

[Steve]

The expression needs to result in a row’s key column value.

[Fabian_Weller]

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?

[Steve]

This:

ANY(FILTER("CCS_User",UserEmail=USEREMAIL()))

should be this:

ANY(FILTER("CCS_User",[UserEmail]=USEREMAIL()))

[Fabian_Weller]

Aaaaah. Thank you

[MultiTech]

Fabian:

Show me only the row which contains the USEREMAIL().

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.