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!