web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Add One Row To a Colle...

Power Apps

Answered

Add One Row To a Collection For Each Unique Field Value

(0) Share

Report

Report

Posted on by Dpalmer

68

Hello,

Thanks in advance for any help.

I have a collection with some rows that have the same value in them. I want to add one row to the collection for each unique value in a particular column. Here's a before and after of what I'm looking to do:

So for each unique "Date" value, add a row that has a "Y" in the BlankRow field and the date in the date field.

Any help would be greatly appreciated,

Thank you!
David

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Dpalmer ,

Please try this:

ClearCollect(Col,{BlankRow:"N",Date:"3/15/2023",Description:"Trip 1",Other:"ABC"},{BlankRow:"N",Date:"3/15/2023",Description:"Trip 2",Other:"DEF"},{BlankRow:"N",Date:"3/15/2023",Description:"Trip 3",Other:"GHI"},{BlankRow:"N",Date:"3/20/2023",Description:"Trip 4",Other:"JKL"},{BlankRow:"N",Date:"3/20/2023",Description:"Trip 5",Other:"MNO"},{BlankRow:"N",Date:"3/22/2023",Description:"Trip 6",Other:"PQR"})
ForAll(GroupBy(Col,"Date","temp"),Collect(Col,{BlankRow:"Y",Date:ThisRecord.Date}))

Best Regards,

Wearsky

Join the conversation