Distinct split of column values into collection

(0) Share

Report

Posted on by nemo1

Hi all,

I have a sharepoint list which collects ongoing project data. One of the fields contains the email of all personnel assigned to that project. A person may be assigned to more than one project

I can get it to split using the solution by @RandyHayes (https://powerusers.microsoft.com/t5/Building-Power-Apps/Multiple-column-split-into-rows/td-p/715847) but not sure how to make this into a distinct list

Many thanks

Clear(colActiveAssignedToMaster);
ForAll(
 spl_ProjectList,
 With(
 {
 wAllAssignedEmail: Split(
 AssignedToEmail,
 ";"
 )
 },
 With(
 {statCount: CountRows(wAllAssignedEmail)},
 ForAll(
 Sequence(Max(statCount)),
 Collect(
 colActiveAssignedToMaster,
 {
 V: Text(Value) & "/" & Text(statCount),
 Assigned: If(Value>statCount, "", Last(FirstN(wAllAssignedEmail,Value)).Value)})))))

Categories:

Building Power Apps

I have the same question (0)