Answered

Filter gallery based on SharePoint group

(0) Share

Report

Posted on by aadilg

Hi friends, Is it possible to filter a gallery based on a user membership of a sharepoint group? E.g. Tasks are allocated to Team 1 (SPO group). Users who log in to the app should only see tasks allocated to Team 1.. Is this possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

WarrenBelz 153,717 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @aadil-gl ,

You might have a look at the Office365Groups connector - note this not SharePoint groups (there is no way of finding them in Power Apps), but if security-enabled, they can be used to control access in both SharePoint and Power Apps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
aadilg on at

Like (0)

Report
Copy link

Link copied!

Thank you @WarrenBelz, will have a look at this. We're currently trying to use permissions to control items within the app as well, seems they may be a way this might work with O365 Groups..

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,717 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Thanks @aadil-gl ,'

We control all SharePoint and PowerApps permissions with Security-Enabled groups - here is a good document on the subject.

The added advantage is that users can be added/removed simultaneously from multiple SharePoint and Power Apps permissions with one entry in the Group.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 153,717 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @aadil-gl ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
aadilg on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz,
Thank you kindly for your reply, it has been quite useful as we have decided to rather implement O365 to solve our problem statement.

I would however like to inquire, is there a way that the connector allows PowerApps to read all the groups a user is part off? Essentially when a user logs into the app he should see all tasks allocated to the group his in since he is apart of the group.

So user 1 will see all tasks allocated to team 1 since he is apart of team 1.

Thanks again

Was this reply helpful? Yes No
WarrenBelz 153,717 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@aadil-gl ,

I am not aware of a way you can find the group of a user - it is currently on the Ideas Forum - you might like to vote for it.

You could however easily do this with a reference list and do a LookUp at App OnStart.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No