Answered

Filtering Countrows inside Collection

(0) Share

Report

Posted on by MichalBr89

Hi, I am trying to Add additional Columns "Approved" and "Pending decision" according to items status and Client Name, I was able to get it working however the count of the items is the same all across the rows and it seems it is not filtering the Client accordingly, this is the code I am using on start... I am adding the column inside colBillings that is afterwards Grouped into another Collection colDashboard that is afterwards displayed in Table's Items property:

ClearCollect(
 colDashboard,
 GroupBy(
 AddColumns(
 colBillings,
 "Client",
 ClientName,
 "RequestorName",
 RequestedBy.DisplayName,
 "Pending",
 CountRows(
 Filter(
 colBillings,
 ClientName = ClientName,
 DocumentStatus = "Pending decision"
 )
 ),
 "Approved",
 CountRows(
 Filter(
 colBillings,
 ClientName = ThisRecord.ClientName,
 DocumentStatus = "Approved"
 )
 )
 ),
 "Client",
 "RequestorName",
 "Pending",
 "Approved",
"GroupData"
)
);

Here I would like to have the count to be filtered correctly by Client name:

Thanks a lot for your help,

BR,

Michal

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @MichalBr89 ,

When using Filter or LookUp inside AddColumns or ForAll, you need to use As operator to resolve ambiguity. Besides, it seems you would like to get entries from colBillings that are only with "Pending decision" and "Approved". If this is the case, please try below formula instead:

ClearCollect( colDashboard, AddColumns( GroupBy( AddColumns( colBillings As CB, "Client", ClientName, "RequestorName", RequestedBy.DisplayName, ), "Client", "RequestorName", "GroupData" ) As GB, "Pending", CountRows( Filter( GB.GroupData, DocumentStatus = "Pending decision" ) ), "Approved", CountRows( Filter( GB.GroupData, DocumentStatus = "Approved" ) ) ) );

Best regards,
MichalBr89 61 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni - Thank you, Sir! I have to remove 'As CB' from AddColumns(ColBillings, but afterwards it worked perfectly!