power-automate

Power Automate Foreach 501 items limit


I am trying to loop through parsed json elements to write data to a variable, that will be sent as a CSV. Unfortunately, the loops stop looping at 501 items :

enter image description here


enter image description here

Others flows are doing the same thing sucessfully, having less than 500 item !

From what i seen online, the loop have a 5k elements limits. Why would it stop at 501 items precisely each time ?

Thank you !


Solution

  • Thanks to the suggestion of @Sam Nseir Problem was not on the loop itself but on the dataset request. Since i used a DAX request from a table visual in Power BI desktop, i did not noticed that it included a TOPN 501 limitation.

    Corrected request allow to take 5000 elements look like this :

        VAR __DS0PrimaryWindowed = 
        TOPN(
            5000,
            __DS0Core,
    

    That way everything worked fine !

    Thank you !