cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
M_Whitenight
Advocate IV
Advocate IV

Use App Owner for the visible

Is it possible to use the app owners to set the visible property instead of using Or(User().email="1st owner's email", User().email="2nd owner's email", User().email="3rd owner's email").

 

I was hoping to be able to use something like Owner so that if someone is listed as an owner the fields hidden from the regular user are displayed. 

3 REPLIES 3
Maxwell123
Helper II
Helper II

I would try to upload an excel file with two Column The first put "Full Name" and have the second name it something like "Privilege"

I.E Below for now we will call this table reference.

 

Full Name Privilege 
John DoeOwner
Jane DoeUser
  

 

Whatever fields you need hidden you can set the visible property to something like this. 

 

If(IsBlank(Lookup(Reference,Filename=User.()FullName,Privilege),If(Privilege="Owner",true,false),false)

 

The idea is that the code checks the current username of whoever is signed in and matches it with the table and then checks to see if they are an owner or not. 

 

The good thing about an excel spreadsheet is its static and can be uploaded right to the app so it does not need to take time to check a Sharepoint list.

 

Let me know if this is along the lines of what your looking for and if you need help with the formula let me know. 

Thanks. Your suggestion will work but I was hoping there was something directly in PowerApps so I wouldn't need to maintain two list, permissions in PowerApps and an excel spreadsheet.

Thanks Maxwell123 for your suggestion. I was hoping to have something directly in PowerApps so I didn't need to maintain two lists, the owners in PowerApps and a list in excel, if owners changed due to people leaving and coming into departments. I submitted an idea to have App.Owners added as a feature.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,224)