Hi @v-xida-msft and @faustocapellanj,
im attaching the flow configuration and results, hope it will be more clear, sorry for the very long reply...
configuration screenshots:
1. in the Select action idefined the Owner
2. Compose expression: union(body('Select'),body('Select'))
3. filter expression: first(variables('OwnerArray'))?['ItOwner']
4. in the second select i defined two fields as test
Owner expression: @item()?['Owner']
Status expression: @item()?['Status']
5. Send an email:
To expression: first(body('Filter_array'))?['Mail']
Subject expression: Open AIs formatDateTime(utcNow(),'dd/MM/yyyy')
6. Compose expression: skip(variables('OwnerArray'),1)
results screenshots:
1. as you can see on the Select Output the owner is exist, dosen't it mean it was retrieved correctly from the excel?
2. Filter results are as expected filtering only the items from excel with the first owner from the array
3. in the select it gives the error
im attaching again the two options i tried to populate in the select and the corresponding error messages:
1.
"Owner":"@body('Filter_Owner')?['Owner']?['Value']"i got following error:
InvalidTemplate. The execution of template action 'Select_2' failed: The evaluation of 'query' action 'where' expression '{ "Owner": "@body('Filter_array')['Owner']", "Status": "@body('Filter_array')['Status']" }' failed: 'The template language expression 'body('Filter_array')['Owner']' cannot be evaluated because property 'Owner' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.
2.
"Owner":"@item()?['Owner']?['Value']
but it also not working, getting the following error:
InvalidTemplate. The execution of template action 'Select_2' failed: The evaluation of 'query' action 'where' expression '{ "Owner": "@item()['Owner ']['Value']", "Status": "@item()['Status']['Value']" }' failed: 'The template language expression 'item()['Owner ']['Value']' cannot be evaluated because property 'Owner ' doesn't exist, available properties are '@odata.etag, ItemInternalId, Risk ID, Area, Team Res_x002e_, Owner, Mail, Status, Description, Severity (1-5), Probability (1-5), Rating (S x P), Mitigation, Contingency, Comments, __PowerAppsId__'. Please see https://aka.ms/logicexpressions for usage details.'.
if something is not clear in my request i will be happy to farther elaborate.
thanks in advance
Eyal
