cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ElMeSaFeR
Helper IV
Helper IV

view Gallery Items based on some users

Hi, 

 

I have a Gallery list Items depending on user creator because SharePoint list settings enabled this feature 

 

SPAdvancedSettings.PNG

 

 

so it should be any user see only the items he/she created, and I can't set this setting through PowerApps DispalyMode because users can access SharePoint list direct!

 

now I have some user - employees admins - they need to list all items from PowerApps direct.

 

there are some topics talking about this - Filter gallery based on a user - but it's not worked with me 

 

please I need a help to find a solution for this issue because most of my project depending on this point 

 

Thanks

 

2 REPLIES 2
v-monli-msft
Community Support
Community Support

Hi @ElMeSaFeR,

 

This permission setting on SharePoint list will also work for PowerApps. You do not need to add any additional settings. When you share this app with UserA, and he open this app from his PowerApps site, PowerApps will prompt for credential of SharePoint connection. After he logs in with his SharePoint account, app will only show the items that he could access with this list (which are the items that are created by himself). 

 

If you want some users to see all items from PowerApps, then you will have to change the first setting to Read all items in SharePoint site. And then in the app, you could Filter the Gallery with formula like below:

If(User().Email="xxxx" or User().Email="xxxx",ListName,Filter(ListName, Author.Email=User().Email))

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-monli-msft

 

 Changing the list settings to "Read All Items" is must but is not enough, I checked before writing this post, but yesterday I made some changes in site permission levels and add the approver user "Approve Items " permission - plus also as you advise me for "Read All Items" - so, now users can see all items!

 now I can add Filters in PowerApps for specific approvers to see the items per conditions.

 

until now I think my inquiry is solved.

 

Thanks,

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,919)