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.
Continue your learning in our online communities.
Features releasing from October 2019 through March 2020
Coming to a city near you
Fill out a quick form to claim your user group badge now!
Connect, share, and learn with your peers year-round
Register by September 5 to save $200