Formulas in PowerApps

[__Bansari]

Hey,

I am creating one Canvas App.

Field:- Notify User - user can select multiple user - store data in SQL with semicolon (abc@gmail.com; xyz@gmail.com)

Need to retrieve that field on dashboard and check if current login user email in Notify User List. How can I achieve this ?

Thanks in advance!

[BCBuizer]

Hi @__Bansari ,

I'm not familiar with using SQL as a datasource, so please use the below as inspiration.

This is a condition that uses the Split() function to create a table of notify users and checks if the current User().Email is in there. It returns a boolean.

User().Email in Split('Notify User',";")

[BCBuizer]

Hi @__Bansari 

Did you have any joy finding the solution for your issue? If so, please mark the solution for other users to benefit.