Troubleshooting Integration with Microsoft Flow| Microsoft Docs

You can use your Business Central data as part of a workflow in Microsoft Flow.

If you are creating a Microsoft Flow using the Business Central connector, you may receive an error message stating that the requsted URL is too long after creating the flow, such as the following: RequestUriTooLong.

Cause

For a flow to trigger, it looks for changes in your data. When determining if your data has changed, the connectors compare the cached data to the new data requested from the source.

If the data request creates a URL that is too long, it will fail. Common causes may include:

• Generally, any source table with over 250 rows
• Source tables containing multiple thousands of records

Workaround

Follow these steps as a workaround.

1. Choose to edit the flow that is failing.
2. Expand the Show advanced options on the flow trigger.
3. In the Skip Count field, enter the number of records to skip.
   For example, if the table that you are using as a data source has 4,000 records, enter 4,000 as the number of records to skip.
4. Update your flow.

See Also

Using Business Central in an Automated Workflow
Getting Started
Importing Business Data from Other Finance Systems
Managing Users and Permissions
Setting Up Business Central
Finance

© 2019 Microsoft. All rights reserved.