web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Distinct split of colu...
Power Apps
Unanswered

Distinct split of column values into collection

(0) ShareShare
ReportReport
Posted on by

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:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard