Hello Friends, I have a list of names and emails, and I have a FORM, when this FORM is summited a flow starts to create a task in PLANNER (this flow is already running) the only trouble is because when the flow try to assign any person to the task, the flow reject this (the reason is because the name in the flow isn't equal to the credentials in the PLANNER, so what I need to do is, set in a "CONDITION" or in "VARIABLE" the email for the person, the name of the person will be available after the response look:
In the table bellow we have John 1, and I know John 1 email is "john1@gmail.com", how in the flow can I create a condition or a loop to test all these names and find the email.. "IF ( Email Response = " Nome " , " Email " )" in the excel I can use Index or VLOOOKUP to do this, but i need to do this inside the flow action.
Nome Email
John 1 john1@gmail.com
John 2 john2@gmail.com
John 3 john3@gmail.com
John 4 john4@gmail.com
John 5 john5@gmail.com
John 6 john6@gmail.com
John 7 john7@gmail.com
John 8 john8@gmail.com
John 9 john9@gmail.com

Report
All responses (
Answers (