Hello,
My Power Automate Flow suddenly stopped connecting to my Excel Sheets. I am creating a Flow and ran into this issue twice so far. Luckily, it resolved itself because I last saved before it broke, so after a few refreshes the error no longer appeared. Unfortunately, when the error occurred the first time, I deleted my first attempt and restarted from scratch, so I am posting here to possibly help others and save them the time. Here is the error message that suddenly appeared in all of my "Add a row into a table" actions:
Failed to retrieve dynamic inputs. Error details: 'The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code '429'. This may indicate invalid input parameters. Error response: { "statusCode": 429, "message": "Rate limit is exceeded. Try again in 6 seconds." }'
This error also suddenly added a required input to each "Add a row into a table" action, asking for an "Item" after the "Table" input. Has anyone experienced this before?
This might be related to what I am trying to accomplish. I am not sure. For context, the flow is meant to distribute Form responses into various tabs of Excel sheets for different user groups using conditions. Each "node" of my automation uses 7-8 conditions to determine which "domain" was chosen in the Form response (this goes into the corresponding tab in the Excel sheet), and many of the nodes also determine which user group the respondent comes from to choose the right Excel file. See my screenshot below, this is what the flow looks like when the error suddenly appears.
7
Share
Report
All responses (
Answers (
