How to take multiple email string inputs and use them to create an array?

[farhan12345]

Hi, 

I am trying to create a flow which takes user input from microsoft forms and puts it in an array, using this array I want to get each value within it and use it to retrieve user data from office 365 (Get user profile v2), after that its puts the user information into an excel sheet. 

The user input is from microsoft forms and is a simple text box, it will be one or more emails, hence forth I am hoping to use an array along with "apply to each" to use each email to find user data and add a new row in excel sheet. It keeps failing over and over again. 

[MarconettiMarco · Accepted solution]

Hello @farhan12345 ,

you can initialize an Array variable:

Then, add the Action "Append to array variable" in which you have to put your Forms value".

And for each, then Get User Profile.

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

BR,

Marco

[Expiscornovus]

Hi @farhan12345,

It looks like it is not splitting correctly. What expression did you use in the Compose 2 action, can you share that expression?

I assume something like below:

split(outputs('Get_response_details')?['body/r07b917815401443cbaff8986df94b668'], ',')