Is there a way to have a flow allow more than 10 conditions?

[LinaS1]

Hi everyone,

Simply put, I have a flow that takes information that was submitted on an MS Form and based on an answer to one of the questions, it puts the info from that form into a certain excel spreadsheet.

The only way that I have figured out how to do this is to set conditions for the flow to decide which excel file to put the file.

For example, in a condition, someone answers “X” on a question, the flow reads that variable as “yes” under the condition that is labeled “X” and puts it into the “X” spreadsheet. If the variable doesn’t match the condition, the flow reads it as “No”, and moves on to check if the answer matches “Y” and “Z” under their own conditions.

A major roadblock that I’m hitting is that flows only allow up to 10 conditions, and I need this flow to cover around 70 excel files. I was wondering if there is an expression I can input to allow it to read the data differently. Would this be a switch rather than a condition? I'm very new to this haha

Here are screenshots of what I have:

[Nived_Nambiar]

Hi @LinaS1 

In the condition screenshot you have shared you are using contains, is it necessary to use contains or equals can be used?

If equals can be used then switch would be best option 🙂

[LinaS1]

Hi Nived,

I am sure equals can be used. In that case, can switches can be used simultaneously rather than in a chain like conditions are set up?

[Nived_Nambiar]

Hi @LinaS1 

It would be good.

But just found out from another source that a switch case in power automate has limit of 25 cases, if your switch case has 25 cases, then its fine else. other way would be placing another switch case in default of another switch case 

That would be another way to give a try 

So i want to know one thing, so based on condition you need to add some data to  excel file right ?

[LinaS1]

Nived,

That sounds better than 10! I'll take it. Does the 25-switch limit apply to switches within defaults as well?

[Nived_Nambiar]

Each switch case has limit of 25 cases , I haven't tried but got information from a blog 

https://www.enjoysharepoint.com/power-automate-switch-case/#:~:text=The%20Power%20automates%20switch....

Mark the answer as solution if it helps to resolve ur query ☺️

[David_MA]

All of the other posts may be helpful, but I don't know how this is going to work unless you add a Get response details action after your trigger condition. Without it, you will not have access to the data the person submitted.

Just doing this may solve part of your issue.

Also, just stack your conditions one after the other instead of branching them. If the condition is met, do whatever you need to do in spreadsheet x under the yes side and do nothing under the no side. Then move on to the next condition and do the same thing.