cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filter gallery items according to group membership

Hi everyone,

 

I have a question regarding the filtering of items in a gallery in PowerApps. The gallery show list items from a SharePoint list. This list is connected to a FLOW for an approval process that sends each item for approval to an Office365 Group.

I want to filter the items in the gallery in such a way, that each member of the Office365 Group will see his/her items submitted for approval. 

Can anyone tell me how to do that?

 

Thanks in advance

Dorothee

4 REPLIES 4
mdevaney
Super User III
Super User III

@Anonymous

Do you have the name of the person within a Column in your SharePoint list?  The person must be in a People column.  If you do, here's an example:

 

Lets say our SharePoint list is called ApprovalsList and the column having a person is 'Approver'.  You can create a gallery in PowerApps to show only the items needing approval by the logged-in user by putting this code in the Items property

 

Filter(ApprovalsList, Approver.Email = User().Email)

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Anonymous
Not applicable

@mdevaney No, the name of the person is not in the list. The person is member of an Office365 Group triggered throughout a flow connected to the list.

@Anonymous
Then you’ll have to explain the problem to be solved in greater detail. Which rows from your list should be shown based on values in specific columns?
Anonymous
Not applicable

Well, I have a list, that is filled through Power Apps and linked to a three-phases workflow. 
The items in the list are displayed in a gallery in PowerApps showing all items submitted for approval through PowerApps.

 

In the last step of the Workflow there is a Office365 Group of users approving/ rejecting an item.

 

I want to build a gallery where everyone in this group sees his/her items submitted for approval.

Therefor I need to get the membership of this particular Office365 group for any user of the Power App.

 

 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (63,085)