Hi,
I have created a flow which apply my AI Model ( Text Classification) to predict a result. It takes around 16 mins and show status as "succeed". However, when I open my data and I can only find 257 rows ( out of 6.7K rows) generate the prediction. Any idea why it will be stopped at certain run?
Status in Power Automate:
Flow Image:
Solved! Go to Solution.
Problem is solved by attached solution.
https://powerusers.microsoft.com/t5/Building-Flows/256-rows-limit/m-p/268617#M27279
Are only the first 257 records processed or some random records in your table?
If the former, did you check that your Excel table properly include the whole records (record after 258 may be outside the table)
If the later, did you apply some filtering or max retrieve option on the "List rows present in a table"?
If you open the last run execution and click on the "Apply to each", how many loop count do you see?
Thank you for your reply. My bad, I have a typo before. It should have 256 record instead of 257.
I would like to follow up your comment below. Thank you for your help and support.
1. the records processed are based on the sequence of the rows within the files.
2. Reviewed and confirmed the tables ( 6k rows) are within the table
3. I have reviewed the set up and I do not apply any filter "list rows present in a table" or " Update a row"
4. It shows 256.
More Comment for "Are only the first 257 records processed or some random records in your table?"
I did several trial and every time, it only runs 256 records.
Problem is solved by attached solution.
https://powerusers.microsoft.com/t5/Building-Flows/256-rows-limit/m-p/268617#M27279