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
Solved! Go to Solution.
I didn't add all the switches, but this should give you the idea
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
Thank you for your fast reply. I really appreciate it. I'll try that.
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?
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.
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?
I didn't add all the switches, but this should give you the idea
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
21 | |
18 | |
11 | |
11 | |
9 |
User | Count |
---|---|
31 | |
27 | |
25 | |
21 | |
11 |