Unanswered

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

(0) Share

Report

Posted on by 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:

All responses (6)

Answers (0)

David_MA 10,617 Super User 2025 Season 1 on at

Like (0)

Report

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

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.
Nived_Nambiar 17,503 Super User 2025 Season 1 on at

Like (0)

Report

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

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%20case,harder%20to%20debug%20the%20flow.

Mark the answer as solution if it helps to resolve ur query ☺️
LinaS1 11 on at

Like (0)

Report

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

Nived,

That sounds better than 10! I'll take it. Does the 25-switch limit apply to switches within defaults as well?
Nived_Nambiar 17,503 Super User 2025 Season 1 on at

Like (2)

Report

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

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 11 on at

Like (0)

Report

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

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 17,503 Super User 2025 Season 1 on at

Like (1)

Report

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

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 🙂