You’re offline. This is a read only version of the page.
Announcements
34
Dear Community,
I would appreciate some help with building my flow. I created a form in Power Apps which I use as input for my Power Automate flow. The input is from a collection, and from what I have found the best way to send this to a power automate flow is through a JSON format.
In my flow, I get my data delivered in the following format:
[{"crf80_costobjectlocalbudgetowner":"CSP"},{"crf80_costobjectlocalbudgetowner":"DMC - B&W"},{"crf80_costobjectlocalbudgetowner":"DMC - NUT"},{"crf80_costobjectlocalbudgetowner":"Europe charges"}]
So, in this example there are four lines of data, but that could also be more ore less, and the content after :"[{"crf80_costobjectlocalbudgetowner":" changes.
I would like to clean this data so that I am only left with, in this case CSP, DMC - B&W, DMC - NUT, and Europe charges. But again, the number of lines of input and the content after the first half of the line can change. Does anyone know how I can create a dynamic flow which cleans/filters my data in this way? Thanks!
Hi @jeroen1290
Try this approach
Assume above trigger output json response
[{"crf80_costobjectlocalbudgetowner":"CSP"},{"crf80_costobjectlocalbudgetowner":"DMC - B&W"},{"crf80_costobjectlocalbudgetowner":"DMC - NUT"},{"crf80_costobjectlocalbudgetowner":"Europe charges"}]
see the next steps of it.
use parse json to parse the json string received as input
Now use select action like below
Output will be like below
Nived N 🚀
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
Share
Report
All responses (
Answers (
