I struggled with this a little bit myself, and I know it's one of those questions that people come up against often. The desire to take Collection data and pass it to Flow as a fully formed JSON array that can be easily worked with in Flow. I came up with the below solution which works really well for me, so I thought I'd provide it in case anyone else needs it 🙂
I have a Gallery collection which has checkboxes. I want to add each checked item to a JSON array prior to passing it to FLOW. Below is my formula for this:
"{" & Mid(Concat(groupStores, ",""" & store_id & """"),2,5000) & "}"
Which produces the following:
{ "228", "721", "328", "658", "655", "415", "427" }
Adding or removing from the string correctly re-builds the string with the right quotes and commas etc. Hopefully this helps someone else who needs to do this 🙂
Solved! Go to Solution.
Thanks for sharing @JamesM! This a great tip that help out future users. Have a great day.
@Anonymous
Hello,
We also use it 🙂
To avoid the mid function you can use the following instead
"{"&Concat(groupStores,""""&store_id&"""",",")&"}"
Also you can set the column names
"{"&Concat(groupStores,"""store_id"":"&""""&store_id&"""",",")&"}"
You can send a table with as many columns as you want from powerapps to flow 🙂
"["&Concat(groupStores,"{""store_id"":"&""""&store_id&"""}",",")&"]"
Thanks for sharing @JamesM! This a great tip that help out future users. Have a great day.
@Anonymous
Just in case anyone is searching through this forum, this solution has been superseded by the JSON function
https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-json
Correct @johnnyshield , the new JSON function works like a charm.
See below video if anyone hasn't used it yet.
Dawid van Heerden
Follow on Twitter: @davestechtips
Subscribe to YouTube: https://www.youtube.com/davestechtips?sub_confirmation=1
User | Count |
---|---|
196 | |
124 | |
88 | |
48 | |
41 |
User | Count |
---|---|
280 | |
163 | |
138 | |
81 | |
76 |