Hello!
I am working in a flow triggered by MS Forms. The flow has an Excel spreadsheet linked that contains many tables. The flow will 'Add a row' in one of the tables, and then 'Get a row' as some columns have formulas whose calculated values will be used later on the flow. The chosen table will be determined by one of the parameters from MS Forms.
I have designed the flow using a Switch , with each condition including 'Add a row' and 'Get a row' to each of the tables. My problem is that this doesn't seem to be working as the flow gets stuck in the 'Add a row' step, taking 15 min to process it and eventually failing due to connection failure with the spreadsheet. I assume this is because there are too many switch conditions?
Is there a simpler way to choose a table to 'add a row' and 'get a row' than Switch?
Thank you!
1,005
