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!
Solved! Go to Solution.
Did you try the following?
{
"Title": "@item()?['Title']",
"Client": "@item()?['Client']?['Value']"
}
Proud to be a Flownaut!
Did you try the following?
{
"Title": "@item()?['Title']",
"Client": "@item()?['Client']?['Value']"
}
Proud to be a Flownaut!
The filter array is actually within a loop over an array of email addresses. So, I think @item would refer to the email address array. I need to refer dynamically to the filter array fields.
Sigh, my fault. I didn't realize that item() has a local scope. Thanks!
Nevermind! Glad it helped
BR
Proud to be a Flownaut!
User | Count |
---|---|
67 | |
52 | |
48 | |
30 | |
19 |
User | Count |
---|---|
26 | |
23 | |
23 | |
23 | |
22 |