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:

General Questions

All responses (2)

Answers (1)

DMSC 59 on at

Like (0)

Report

Duplicate collection record based on multi-select people picker

Thanks WarrenBelz

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

Much appreciated as always!

DW
Verified answer

WarrenBelz 143,532 on at

Like (1)

Report
Duplicate collection record based on multi-select people picker

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