Answered

Duplicate collection record based on multi-select people picker

(0) Share

Report

Posted on by DMSC

Hi all,

I have a gallery of data (from a SharePoint list) and within is a checkbox. Oncheck collects that data, UnCheck removes it, etc.

However, one of the fields is multi-select person column, so obviously my collection stores all the names in the single record as it should.

My question is, is there a way to create a collection that counts the number of rows for that column, the loops through and created duplicate rows of the same data (essentially splitting the people person column into its own row for each person?)

Any help would be appreciated it. I thought it was count rows, then a sequence loop but I think I am over engineering the issue.

Cheers,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,793 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi DMSC

You have not included any code here, but if you want a count of rows in your gallery with a separate record for each item in a multi-value field
CountRows( Ungroup( GalleryName.AllItems, MultiValueFieldName ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
DMSC 65 on at

Like (0)

Report
Copy link

Link copied!

Thanks WarrenBelz

I woke up this morning and just realised something similar but you beat me to it!

Much appreciated as always!

DW

Was this reply helpful? Yes No