Create Array from Search for user

[Prav]

Hello,

Within an apply to each I'm parsing the approver's names (Get Items from SP) to Search for users to get the email address "Mail": "me@microsoft.com").

Then my next step is to create union array but i'm getting the error message below.

InvalidTemplate. Unable to process template language expressions in action 'UnionApprovers' inputs at line '1' and column '2655': 'The template language expression 'union(variables('Approvers'),createArray(body('Search_for_Users')?['Mail']))' cannot be evaluated because property 'Mail' cannot be selected. Array elements can only be selected using an integer index. 

[RezaDorrani]

Hi @Prav 

post screenshot of flow and the error

[Prav]

[RezaDorrani]

Hi @Prav 

GetEmail which action is that in Office 365 users?

Apply to each loop - what is being looped?

[Prav]

@RezaDorrani 

Yes, Office 365.

@body('GetClaims')?['value'] loops through Get Items from SP

[RezaDorrani]

Hi @Prav 

Yes, Office 365 - But which action are you using from the Office 365 connector?

@body('GetClaims')?['value'] loops through Get Items from SP - share screenshot of entire flow

[Prav]

I'm using 

[Prav · Accepted solution]

Instead of using the name, I've saved the email addresses to SP and parse to Flow. 

Working now.