Send email depends on a country list including 45 countries.

Like (0) Share

Report

Posted on 12 Apr 2024 14:51:05 by romovaro

Hello,

I have a question regarding Sending emails flows.

I have a MS Form and one of the questions is Country. IF Country is included in a list (45 countries there) then the email needs to be send to: managers@XXX.com; amanda.Garcia@XXX.com; John.schulster@XXX.com and if country is not in that list, then to amanda.Garcia@XXX.com; John.schulster@XXX.com

Tried the "switch" option "send email" for every country but I get the error "to many cases"

Flow save failed with code 'AllowedSwitchCaseLimitExceeded' and message 'The template action 'Switch' at line '1' and column '1920' is not valid: the number of cases used '45' exceeds the maximum number allowed '25'.'.

Any other option to get this result?

thanks

I have the same question (0)

All responses (5)

Answers (0)

romovaro 15 on 15 Apr 2024 at 12:16:35

Like (0)

Report

Re: Send email depends on a country list including 45 countries.

Tied also this approach but same results...something is off

Was this reply helpful? Yes No
romovaro 15 on 15 Apr 2024 at 11:37:45

Like (0)

Report

Re: Send email depends on a country list including 45 countries.

Hi Scott

sorry to bother you- Not very fluent in the Power automate yet.

Tried again. When I save it seems ok but...
Currently my flow looks like:

where Compose:

Where Compose1: Just the Function? No need to add anything else?
or Do I need to specify the Output from prev Compose?

How DO i link the Compose and Compose 1 to my form? To a "Get response Details"?

and the Condition:

thanks,

Was this reply helpful? Yes No
ScottShearer 25,236 Most Valuable Professional on 12 Apr 2024 at 16:15:33

Like (0)

Report

Re: Send email depends on a country list including 45 countries.

@romovaro

You could use a switch or a condition.

If you use a condition, the condition would be If Compose 2 is equal to -1

If yes - this means country not found

If no, the means country is found.

Th error is with you send an email action. Can you post a screen shot?

Was this reply helpful? Yes No
romovaro 15 on 12 Apr 2024 at 16:10:24

Like (0)

Report

Re: Send email depends on a country list including 45 countries.

Hello Scott and thanks for your quick reply,

I followed your steps. I assume that after the second "compose" I need to use the switch + Send email option?

If Case = -1 send email to.... and Default email to....?

When I select the "switch" option I need to provide a parameter "on".... should be Compose 1?

I get the below error:
The input parameter(s) of action 'Send_an_email_(V2)' contain an invalid reference to 'Get_response_details'. Correct to include a valid reference to 'Get_response_details' for the input parameter(s) of action 'Send_an_email_(V2)'.

Thanks

Rob

Was this reply helpful? Yes No
ScottShearer 25,236 Most Valuable Professional on 12 Apr 2024 at 15:09:19

Like (0)

Report

Re: Send email depends on a country list including 45 countries.

@romovaro

You could simple add a second switch action, but that would be a very bad idea.....

I suggest rewriting your Flow and removing the switch action.

There are a number of ways of approaching this - here is a simple way.

Add a Compose action

Populate the Compose action with a delimited list of all countries

Use a lastIndexOf() action to see if the country is listed in the Compose action.

If it isn't found, the expression will return -1

If any number other than -1 is returned, the country is in the list

See my example below. I hard coded a country - you will reference Dynamic properties

Please let me know if you need more help.

Was this reply helpful? Yes No