Table Reference Question: How to Set the Ref Column to Automatically Select the Row Instead of Having Choices

I have a table with a column that references another table. See below. How can I set the reference column so that it selects the one row label automatically, without having to CLICK and PICK?

The PROFILE table with the PROFILEID has a security filter USEREMAIL()=EMAIL so that the user should only see their own profile.

Default No Selection of PROFILEID

: Screen Shot 2020-06-24 at 10.12.24 PM

CLICK AND PICK (which I want to avoid). I don’t want to select NEW or the Profile - I just want it automatically set to the user profile.

Screen Shot 2020-06-24 at 10.12.42 PM

You may wish to make your table names and table structure a bit clearer. I believe it is not exactly clear which table is parent and which one is child.

Anyhow, based on your subject and other description, please explore if following helps. Or else please repost with more details.

Please make the reference column as non editable by selecting Editable_if constraint to Off.

In the initial value of the reference column, please have an expression something like

ANY(SELECT( Parent Table Name[Key Column of the parent table], [Email column name in Parent Table]=USEREMAIL())


@Suvrutt_Gurjar thanks! This expression worked like a charm. It selected the profile in which is associated with the user from a list of other possible profiles.

Now I can HIDE the PROFILEID column knowing the correct selection will be made.

I have another filter slice question which I’ll send in another question piece. Just wanted to thank you for all your support. It’s greatly appreciated. Perhaps you would be interested to see my app when ready to deploy (for feedback purposes only)?