cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ppei Resolver I
Resolver I

How can I work around the maximum number allowed in Switch action?

My customer wants me to create a Flow to send out email notifications to each department. There are more than 25 departments, but the maximum number of CASE allowed for Switch action is 25. When I tried to save the Flow, I got the error message below. How can I get a workaround for this problem? 

 

Thank you in advance.

 

Pei

 

SwitchMaximumNumber.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: How can I work around the maximum number allowed in Switch action?

I didn't add all the switches, but this should give you the idea

screenshot.png



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

8 REPLIES 8
Dual Super User
Dual Super User

Re: How can I work around the maximum number allowed in Switch action?

@ppei 

 

Create a config list -  which has the 25 departments and the email addresses

Within Flow, do get items from this config list (list can be hosted in excel, sharepoint , sql or array within flow)

Then run a for loop within flow for the data receieved

and send emails to each dept within loop

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

ppei Resolver I
Resolver I

Re: How can I work around the maximum number allowed in Switch action?

Thank you for your fast reply. I really appreciate it. I'll try that. 

ppei Resolver I
Resolver I

Re: How can I work around the maximum number allowed in Switch action?

I used Switch action because I need to get the department from SharePoint list. For example, in case it is Finance department from the list, then the email will be sent to a person in Finance department. How can I set loop to do this?

Dual Super User
Dual Super User

Re: How can I work around the maximum number allowed in Switch action?

@ppei 

Paste screenshots of your Flow actions here

Dual Super User
Dual Super User

Re: How can I work around the maximum number allowed in Switch action?

Just split the Switch into two switches.  Handle as many departments as you can in the first switch then add a second switch on the default branch of the first switch.  Handle the rest of the departments on that switch.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
ppei Resolver I
Resolver I

Re: How can I work around the maximum number allowed in Switch action?

Great idea! Could you send me a screenshot how I can add the second switch to Default? Should I just add a new Switch action for Default?

Dual Super User
Dual Super User

Re: How can I work around the maximum number allowed in Switch action?

I didn't add all the switches, but this should give you the idea

screenshot.png



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

ppei Resolver I
Resolver I

Re: How can I work around the maximum number allowed in Switch action?

@Pstork1 Thank you for your help. It works!

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,684)