Overcoming Microsoft Power Automate’s limit while importing more than 256 rows from Microsoft Excel Table

When importing a table from Microsoft Excel within Power Automate, only 256 rows are imported by default even if the “Top Count” is used.

To overcome this, access the context menu for that particular step as show below and set the “Threshold” under “Pagination” settings.

Click the context menu “…” and click on “Settings”.
Type in the “Threshold” value.
Click on “Show advanced options” and type in the “Top Count” which should be less than the “Threshold” value set in the above steps.

Do make sure the “Threshold” value is not set too high or greater than 5000

Microsoft Online Services SLA

Sometimes as an architect for Microsoft services, we might be queried by the customer to understand the service level agreements by Microsoft.

Where to find the information?

The following URL provides the document which has SLA details for each online service Microsoft provides.

https://www.microsoftvolumelicensing.com/DocumentSearch.aspx?Mode=3&DocumentTypeId=37

How to search?

The documents are categorised based on language and each document has the SLA defined for all the services in one single document. All we have to do is search based on the language and view/download the document.

Once inside the document, view the table of contents and click on the appropriate service. Don’t forget to view the general terms, which explains a few important things before visiting the appropriate service.