web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps GroupBy where values m...

Power Apps

Answered

GroupBy where values match

(0) Share

Report

Report

Posted on by bd528

109

I have a SharePoint list with the following structure

Product	Part	Complete
AAA	111	Yes
AAA	222	No
AAA	333	Yes
BBB	444	Yes
BBB	555	Yes
BBB	666	Yes

I'd like to display this in a gallery, grouped where Final is if all Completes for a Product are Yes

Product	Final
AAA	No
BBB	Yes

Is this possible? I've tried using GroupBy, but I can keep ending up with 2 Final rows for Product AAA (Final Yes & Final No)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@bd528 Try this (replace the static data with your SP List). The collection colCompleteGroupFinal will have the desired result.

ClearCollect(colCompleteGroup, GroupBy( Table({Product:"AAA", Part:"111", Complete:"Yes"}, {Product:"AAA", Part:"222", Complete:"No"}, {Product:"AAA", Part:"333", Complete:"Yes"}, {Product:"BBB", Part:"444", Complete:"Yes"}, {Product:"BBB", Part:"555", Complete:"Yes"}, {Product:"BBB", Part:"777", Complete:"Yes"}, {Product:"CCC", Part:"888", Complete:"No"}, {Product:"CCC", Part:"999", Complete:"No"}), "Product", "Complete", "CompleteGroup" ) ); ClearCollect(colCompleteGroupFinal, colCompleteGroup); ForAll(colCompleteGroup As _colCompleteGroup, If(CountRows(Filter(colCompleteGroup, Product=_colCompleteGroup.Product))>1, RemoveIf(colCompleteGroupFinal, Product=_colCompleteGroup.Product && Complete="Yes") ) )

Was this reply helpful? Yes No

Join the conversation