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.
Data in collection:
And output needed is like : 003616,003622,003680.
The idea is to parse this comma separated string as a parameter to run flow.
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.
Solved! Go to Solution.
@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 😄
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.