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
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."
@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.
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.
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks