Behavior actions based on user role

I am having a hard time setting Editable_If permissions based on user role in my app. Hopefully someone can lead me to the correct formula. 

I am making a real estate app and I am trying to restrict an Edit behavior only to admin AND the user that published the property listing in the app. I think my issue stems from the "Listing Agent" label in the property profile is a REF_Row to my Agents table where the agent's name, email, etc is listed.

Using the expression =IN(USEREMAIL(), SELECT(Agents[Email], [role]="Admin")) allowed me to only have admins edit the property listings, but I am missing the ability to have the user who is the "Listing Agent" also be able to edit their property post. 

Any suggestions?

0 6 154
6 REPLIES 6
Top Labels in this Space