view Gallery Items based on some users

(0) Share

Report

Posted on by Sharif Alhennawy

157

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

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

v-monli-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Sharif Alhennawy 157 on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No