cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
farhan12345
New Member

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

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. 

 

farhan12345_0-1657697800274.png

 

 

farhan12345_1-1657698003774.png

 

farhan12345_2-1657698155106.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
MarconettiMarco
Super User
Super User

Hello @farhan12345 ,

you can initialize an Array variable:

MarconettiMarco_0-1657699664894.png

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

MarconettiMarco_1-1657699747022.png

 

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

 

View solution in original post

2 REPLIES 2
MarconettiMarco
Super User
Super User

Hello @farhan12345 ,

you can initialize an Array variable:

MarconettiMarco_0-1657699664894.png

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

MarconettiMarco_1-1657699747022.png

 

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
Super User
Super User

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'], ',')

 



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,317)