Unable to filter into array via 'Search for users (V2)'

[SebastianN]

Hi,

I cannot get the search for users to pass on a specific field's information in a loop (apply to each)

I eventually want to use it to update a row in an Excel list, but after various tries I cannot get the information to be passed on into an array. I can get this to work if it's only one user, but instantly when I need it to go through a bunch of emails, it won't do what I need; to pick out the department based on the users email addresses. I have tried various ways, this is where I am at now. Anyone know how to solve this?

[ekarim2020]

Does the email column contain multiple email addresses? If so, how is each email address separated from another?

Can you post some sample Excel data?

Ellis

[SebastianN]

Hi Ellis,

The Excel file's data is in a table and contains one email per row in the "eMail" column.

The 'Search for Users (V2)' request goes through, but it's the step after that I cannot get to work...

/ Sebastian

[ekarim2020 · Accepted solution]

If you need the users department, you can easily get this using an expression:

You should be able to copy-and-paste this expressions into your flow:

outputs('Search_for_users_(V2)')?['body/value'][0]['Department']

Here is an example run, which returns the department Retail for user 

Ellis

____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.