Share
Report
34Dear 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!
All responses (
Answers (
