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:
