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!
@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!
Hi @jessicadduffey ,
I made a sample for you without parsejson.
{
"Title":"@{items('Apply_to_each')?['Title']}",
"TestLookupValue":"@{body('Join')}"
}
Best Regards,
Wearsky
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1