web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Authentication for Pow...
Power Apps
Answered

Authentication for PowerApps By Email using Sharepoint list

(0) ShareShare
ReportReport
Posted on by

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"

Danny_Dicaprio_0-1707891789293.png

 

 

Could anyone please help me to fix the issue 

Categories:
  • Verified answer
    v-yueyun-msft Profile Picture
    Microsoft Employee on at

    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

  • Danny_Dicaprio Profile Picture
    on at

    @v-yueyun-msft 

    It worked. 

    Thanks a lot man!

    Could you please explain why my formula didn't work?

  • v-yueyun-msft Profile Picture
    Microsoft Employee on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 236 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 188 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 130

Last 30 days Overall leaderboard