Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Parsing JSON after Filter Array - Key Value not showing in dynamic content

(0) ShareShare
ReportReport
Posted on by

Good afternoon everyone - 

I am building a flow (triggered manually) that: 

1. Gets items from Sharepoint based on date created

2. Uses a filter array to filter these items for a certain parameter (in this case, BLEND = true)

3. Pulls those items into a CSV table and creates a document on Sharepoint

 

Here is a snapshot of the flow:

jessicadduffey_0-1691097985777.png

(yes, I realize I could have performed the filter array step in Get Items - I tried - the only way I could get the filtering correct is through a filter array)

I'm running into an issue mapping the values for the CSV table.  You'll notice that the first header is called BLEND chapters.  After searching through the values list multiple times, I cannot find the correct value to populate.  Here is the specific value I'm looking for from the JSON (it's highlighted):

jessicadduffey_1-1691098141152.png

 

I've tried plugging in all of these from my dynamic content - none of them return the value I'm looking for:

jessicadduffey_2-1691098202826.png

The closest I can get to something I'm looking for is this: [{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":11,"Value":"St. Louis"}]...but I would much rather only the value pull into the csv table (in this case, St. Louis).

This is the only thing that is standing in the way of me finishing this flow and crossing this item off of my list.  Does anyone have any suggestions on what I could do?  Please be specific - I am somewhat of a new user.  Happy to send any additional information needed - just ask. Thank you!

  • jessicadduffey Profile Picture
    on at
    Re: Parsing JSON after Filter Array - Key Value not showing in dynamic content

    @v-xiaochen-msft , that worked well - thank you!  Here is my amended flow for reference:

    jessicadduffey_1-1691175491982.pngjessicadduffey_2-1691175518675.png

    Now I'm running into another issue - presumably because of the filter array, another key part is now missing (highlighted in the screenshot below):

    jessicadduffey_0-1691174627025.png

    I cannot append this to the array variable in the same manner as the other two items because this is a string.

     

    Do you have any suggestions on how to fix this?

     

    I'm assuming that after all of the steps are completed, I need to parse the JSON (to get the dynamic content back) and then Create a CSV table?

     

    Thank you for all of your help thus far!

     

  • Verified answer
    v-xiaochen-msft Profile Picture
    on at
    Re: Parsing JSON after Filter Array - Key Value not showing in dynamic content

    Hi @jessicadduffey ,

     

    I made a sample for you without parsejson.

    vxiaochenmsft_0-1691117027489.png

    vxiaochenmsft_1-1691117050636.png

    vxiaochenmsft_3-1691117115790.png

    vxiaochenmsft_4-1691117157183.png

    {
    "Title":"@{items('Apply_to_each')?['Title']}",
    "TestLookupValue":"@{body('Join')}"
    }

     

    vxiaochenmsft_5-1691117194319.png

     

    Best Regards,

    Wearsky

     

     

     

     

     

     

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >