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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Checking logged in use...
Power Apps
Unanswered

Checking logged in user is present in a sharepoint list and show pages accordingly.

(0) ShareShare
ReportReport
Posted on by 24

Hello,

I am trying to restrict logged in user to view some screens or options.

I have a SharePoint list

Screenshot 2022-03-28 225501.png

Here you can see a column name UserPrincipalName.

Now I want to check if the logged-in user is present in UserPrincipalName and the IsGlobalAdmin value of the respective user is "Yes". Then the user can see the respective screens and options in powerapps.

 

I have tried this in the App OnStart function but it is not working.

ArpanBala_0-1648489554134.png

 

Categories:
I have the same question (0)
  • Verified answer
    EdViegas Profile Picture
    436 on at

    why not try

     

    If(
     LookUp(
     'User Table',
     UserPrincipalName = User().Email
     ).IsGlobalAdmin = "Yes",
     Set(varIsGlobalAdmin, true),
     Set(varIsGlobalAdmin, false)
    );

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard