Array syntax for Select action

[jesheehy]

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!

[efialttes · Accepted solution]

Did you try the following?

{

"Title": "@item()?['Title']",

"Client": "@item()?['Client']?['Value']"

}

[jesheehy]

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.

[jesheehy]

Sigh, my fault. I didn't realize that item() has a local scope. Thanks!

[efialttes]

Nevermind! Glad it helped

BR