web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Modify JSON data dynam...
Power Automate
Answered

Modify JSON data dynamically to only select specific piece of data

(0) ShareShare
ReportReport
Posted on by 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!

Categories:
I have the same question (0)
  • Verified answer
    Nived_Nambiar Profile Picture
    18,136 Super User 2025 Season 2 on at

    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.

    Nived_Nambiar_0-1718910302048.png

     

    use parse json to parse the json string received as input 

     

    Now use select action like below

    Nived_Nambiar_1-1718910349575.png

     

    Output will be like below

    Nived_Nambiar_2-1718910392760.png

     

    Thanks & Regards,

    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! 🙌

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 323 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 183 Most Valuable Professional

Last 30 days Overall leaderboard