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

Like (0) Share

Report

Posted on 3 Aug 2023 21:34:09 by jessicadduffey

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:

(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):

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

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!

Categories:

Business Process Flows

All responses (2)

Answers (1)

jessicadduffey on 04 Aug 2023 at 19:00:30

Like (0)

Report

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:
Now I'm running into another issue - presumably because of the filter array, another key part is now missing (highlighted in the screenshot below):
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 on 04 Aug 2023 at 02:46:40

Like (0)

Report

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

Hi @jessicadduffey ,

I made a sample for you without parsejson.

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

Best Regards,

Wearsky