Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Filter gallery based on SharePoint group

(0) ShareShare
ReportReport
Posted on by

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:
  • WarrenBelz Profile Picture
    WarrenBelz 145,475 on at
    Re: Filter gallery based on SharePoint group

    @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.

  • aadilg Profile Picture
    aadilg on at
    Re: Filter gallery based on SharePoint group

    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

  • WarrenBelz Profile Picture
    WarrenBelz 145,475 on at
    Re: Filter gallery based on SharePoint group

    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.

  • Verified answer
    WarrenBelz Profile Picture
    WarrenBelz 145,475 on at
    Re: Filter gallery based on SharePoint group

    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.

     

     

  • aadilg Profile Picture
    aadilg on at
    Re: Filter gallery based on SharePoint group

    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..

     

  • WarrenBelz Profile Picture
    WarrenBelz 145,475 on at
    Re: Filter gallery based on SharePoint group

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard