Unanswered

Determining Recipient Based on form answer

(0) Share

Report

Posted on by knowltonpeter

Hello,

I'm trying to set up a process where Power Automate takes a response from Form and makes a decision on who to send an email to. For example, if in the "country" question in MS Form someone answers "Spain" or "Mexico" the emails gets sent to the Spanish team, if they answer "France" or "Canada" it gets sent to the French team etc.

Thanks,

Peter

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hello @knowltonpeter

You can use a condition, if you just have two languages.

Use a switch statement if you have multiple languages.

Condition example - https://powerusers.microsoft.com/t5/General-Power-Automate/Using-specific-answers-in-Forms-as-conditions-in-a-flow/td-p/190305

Switch Statement - https://powerusers.microsoft.com/t5/General-Power-Automate/switch-control-with-flow-and-forms/m-p/208181/highlight/true#M22225

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
knowltonpeter 6 on at

Like (0)

Report
Copy link

Link copied!

Thanks. Is there a way to combine them (group languages) or do I have to do a separate case for each language? We have over 100+ languages.

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey @knowltonpeter

I think switch case has a limit of 25 cases ☹️. You can group them and maybe try using Multiple conditions in an single condition.

Another option would be ask user select their preferred language on the Form and then depending on the language route the Form to respective teams.

A good article would be - https://sharepointmaven.com/3-ways-to-build-multiple-conditions-in-microsoft-flow/

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
knowltonpeter 6 on at

Like (0)

Report
Copy link

Link copied!

Thank you!!

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@knowltonpeter Your Welcome. If you get a better solution please do share with the community.

Was this reply helpful? Yes No
knowltonpeter 6 on at

Like (0)

Report
Copy link

Link copied!

One last question. So there is no way for me to do an OR function in a Case? For example, Case equals French OR German

Was this reply helpful? Yes No