Forum Discussion
Assign an email adress on an option in MS Form
In your form you will need the choice question for the selection of the draftsman to show their email addresses. That way the flow can pick up that selected email address and use that in the send an email action. If you've just asked the user to select a name then the flow won't be able to associate that to an email address.
If you really don't want to display email addresses as the options in the draftsman question but just the name, then the workaround would be to add a switch control in your flow which is a type of condition that looks at just one answer, the name of the draftsman. In case the answer to the switch is John then set a variable to be John, email address, if it's Carol then set the variable to Carol's email address. Then use the output of the variable in Planner and the email.
Your flow will also need the Office 365 Users connector so that it can get the email address, first name etc of the Salesman who completed the form (you don't need to ask for that in the form).
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
Thank you Rob. I will try your suggestions, though, I don't know where to start 😅, but I'll try. I hope you can give me some insights or steps to take on how to make it possible, but for the meantime, i'll try top experiment and figure this out. Hope you can help me along the way. Thank you