Answered

Filter Gallery by Unique Person name after Multi-filters

(0) Share

Report

Posted on by AnasAllahim

I’m working to build an approval panel where I have an approval list in SharePoint. As output, I made a Gallery to read the approvals for the request. The issue here is that each approver has more than one approval for the same request because of the return of the request from other approvers.

In the following ss of the SharePoint list:

And here is an example of the output gallery:

The filter of the gallery is as follows:

 Sort(
 Filter(
 Filter(
 Approvals,
 Parent_ID = varRecord.ID
 ),
 "SpecificWord" in Title
 ),
 Created,
 SortOrder.Ascending
 )

I’m trying to avoid repeating the approver's name here. So, for each box in the gallery, only one unique name.

I spend days trying to use filter/distinct/first in many ways without success.

Your support is much appreciated.

Thank you,

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-mingkz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @AnasAllahim,
Do you want to display the approver's unique name in gallery?
You can use the following expression.

Sort( GroupBy( Filter( Approvals, Parent_ID = varRecord.ID, "SpecificWord" in Title ),"{Approver}","col" ), Created, SortOrder.Ascending )

Best Regards,
Kyrie

Was this reply helpful? Yes No
AnasAllahim 18 on at

Like (0)

Report
Copy link

Link copied!
Thank you @v-mingkz-msft

There are two issues here. The first one is the app doesn't recognize the approver as follows:
The settings of the SP field are as follows:

The other issue is that even if I replace the approver field with another one like this code
GroupBy( Filter( Approvals, Parent_ID = varRecord.ID, "Dir" in Title ),"Completed","col" )
it gives only one field

Thank you

Was this reply helpful? Yes No
AnasAllahim 18 on at

Like (0)

Report
Copy link

Link copied!

Your support is highly appreciated

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @AnasAllahim, thank you for your message.

Approver will most likely be a person column - which GroupBy does not accept as a parameter type. The workaround would be adding a column displaying the person's name and grouping by that newly created column:

GroupBy( AddColumns( Sort( Filter( Filter( Approvals, Parent_ID = varRecord.ID ), "SpecificWord" in Title ), Created, SortOrder.Ascending ), "ApproverName", Approver.DisplayName ), "ApproverName", "GroupedApprovals" )

Since 'in' is a non-delegable operator for SharePoint I would advise to keep the nested filter structure.

All grouped records and their column are accessible via GroupedApprovals. For columns that are similar across the approvals use First(GroupedApprovals).ColumnName

Should you want to concatenate column values use: Concat(GroupedApprovals, ColumnName, ", ")

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
AnasAllahim 18 on at

Like (0)

Report
Copy link

Link copied!

@LaurensM Thank you very much.

Work like a charm.

Was this reply helpful? Yes No