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!
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
39 | |
36 | |
34 | |
31 | |
27 |
User | Count |
---|---|
44 | |
36 | |
33 | |
24 | |
22 |