cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Make collection item CSV in powerapps

Hi PowerUsers,

 

I have a collection where I have two columns

1 - WorkerName

2 - WorkerNumber

 

The workerNumber column has data which I want to be converted/transformed into a comma separated value.

Example:

 

Data in collection:

Screenshot_1.png

And output needed is like : 003616,003622,003680.

 

The idea is to parse this comma separated string as a parameter to run flow.

Screenshot_2.png

And that Flow will be parsing this string as "IN" operator of SQL.

 

I have figured the flow part already, just need some assistance with generating this comma separated string.

 

Looking forward to awesome response as usual.

 

Regards,
Ali Nawaz

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

Hi @Ali_Nawaz ,

 

Use Concat() function for this:

 

UpdateContext({CSVStringGoesHere,Concat(Datasource,WorkerNumber&","})

 

Hope it helps !

View solution in original post

2 REPLIES 2
Super User II
Super User II

Hi @Ali_Nawaz ,

 

Use Concat() function for this:

 

UpdateContext({CSVStringGoesHere,Concat(Datasource,WorkerNumber&","})

 

Hope it helps !

View solution in original post

@gabibalabanThanks man it worked perfectly 🙂
I wasn't aware of this function before this.

Went a little ahead of this and trimmed the extras 🙂

Set(WorkerNumCSV, Match( Concat( ManagerHierarchyColl, WorkerNumber & ", " ), "^(?<trim>.*), $" ).trim );

 

Thanks again 😄

Best Regards,

Ali Nawaz

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (61,523)