I have an excel file with 524 records. When getting the records to insert in an sql database I'm just getting 256 limit. I have set the top count to 500, 524, 600 without success. Here is my flow configuration
Could please you check around what is going on?.
Solved! Go to Solution.
check this post
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Depending on your needs, you can use the Static Data connector to bring in up to 15000 records from an Excel file in a few seconds. The resulting table will be read only though.
Hi @RezaDorrani ,
That's it this option was off in the settings. I thought it was enought to set the top count value and didn't imagine this option existed. Now I can get the 524 as expected.
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications