I am using the SharePoint "Get items" action and then a "Filter array" action to get a subset of that list (note: I cannot use the OData filter in my flow). I then want to use the "Select" action to get a few of the columns, which I will then feed into an HTML table. I'll then include that an email.
I'm getting hung up on the "Select" action and hopefully it is just a syntax issue.
The output from the "Filter array" action looks like:
{
"@odata.etag": "\"2\"",
"ItemInternalId": "904",
"ID": 904,
"Title": "Some title here",
"Client": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 11,
"Value": "ABC"
},
... more fields ...
}In my "Select" action, I thought something like the below would work, but it's not. Can someone help me with the syntax?
{
"Title":"@body('Filter_array')?['Title']",
"Client":"@body('Filter_array')?['Client']?['Value']"
}Thanks!
