Hi,
I have a Gallery list Items depending on user creator because SharePoint list settings enabled this feature
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
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
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,
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
257 | |
122 | |
86 | |
73 | |
72 |