Power Platform Community Forum Thread Details

I have several flows which rely heavily on excel (business), all this time the flows are okay but not I receive the following error. Anyone can help me out please?

The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code '429'. This may indicate invalid input parameters. Error response: { "status": 429, "message": "Too many requests to Graph API. Please try again later. clientRequestId: 33fb1524-cb97-4fd8-b764-555396af6608", "error": { "message": "Too many requests to Graph API. Please try again later." }, "source": "excelonline-ea.azconn-ea-001.p.azurewebsites.net" }

Categories:

General topics

Hi Good day,

No issue with the excelonlinebusiness action right now, I used it for a flow and it worked fine,

The error message above is most likely due to a lot of concurrent and api calls based on the action.

You can do the following to possibly improve your flow

Add a Delay Action:
- Insert a Delay action in your flow, especially if it loops over multiple requests to Excel Online. Start with a delay of a few seconds (e.g., 3-5 seconds) and test if the error subsides.
- You can also set the delay to 5-10 seconds to better distribute requests over time if the flow is processing a significant number of records.
Reduce Frequency of Flow Triggers:
- If your flow triggers often (e.g., instantly or every minute), consider increasing the interval between triggers. For example, try running it every 5-10 minutes instead of every minute.
- For batch processing, try running the flow at off-peak hours if possible to avoid rate limits during high-traffic times.
Optimize Excel Data Access:
- If your flow accesses large Excel tables, optimize your requests by querying only the necessary data. For example, use filters or pagination to minimize the size of data requests, as larger data requests are more likely to hit rate limits.

Long-Term Prevention Strategies

Use Batching Techniques:
- If the flow is looping over rows in Excel (using "Apply to Each" for instance), try consolidating actions to limit the number of requests to the API. Instead of making a separate call for each item, process items in batches if possible.
Reduce Concurrent Requests:
- If you’re using multiple Excel Online actions in parallel, consider chaining them in sequence to avoid simultaneous API requests.
Error Handling and Retry Policy:
- Add a retry policy to the Excel Online action with the error to automatically retry after a delay if the 429 error occurs. In the action settings, go to Settings > Retry Policy and set it to Exponential or Fixed Interval with intervals of 5-10 seconds.
Monitor and Adjust Quotas:
- If this is a shared flow or involves multiple users, be mindful of Microsoft Graph API’s daily quotas. Adjusting user activity or grouping flows where possible can help balance the usage within allowed quotas.