Answered

Authentication for PowerApps By Email using Sharepoint list

(0) Share

Report

Posted on by Danny_Dicaprio

Hi Everyone

In My Landing screen of Power App I have a button

On select of the button :
 If(
User().Email in LookUp('Skill Info_GEC', 'Employee Email ID', 'Employee Email ID'),
Navigate('New Search Skill Screen'),
Notify("Please Create a New Account")
)

Basically, What Iam locking for is if the logged in user email is on the SharePoint list, ( Column Employee Email ID )

I want the user to navigate to a different screen or else notify them to please create a new Account

But Iam Facing an error for the look up function called "function lookup has some invalid argumnets"

Could anyone please help me to fix the issue

Categories:

Using Apps Using Formulas

All responses (3)

Answers (1)

v-yueyun-msft on at

Like (1)

Report

Re: Authentication for PowerApps By Email using Sharepoint list

Hi , @Danny_Dicaprio

Thanks for your response ! The lookup() function's second parameter need to use the expression which return true or false.

In my code is "'Employee Email ID' =User().Email"

For more information, you can refer to :
Filter, Search, and LookUp functions (contains video) - Power Platform | Microsoft Learn

Best Regards,

Yueyun Zhang
Danny_Dicaprio on at

Like (0)

Report

Re: Authentication for PowerApps By Email using Sharepoint list

@v-yueyun-msft
It worked.
Thanks a lot man!
Could you please explain why my formula didn't work?
Verified answer

v-yueyun-msft on at

Like (1)

Report
Re: Authentication for PowerApps By Email using Sharepoint list

Hi , @Danny_Dicaprio

You can try to use this code :

If( !(IsBlank( LookUp('Skill Info_GEC', 'Employee Email ID' =User().Email) ) ) , Navigate('New Search Skill Screen'), Notify("Please Create a New Account") )

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang