Run query against a dataset and power automate to Add rows to Excel

[Erika_S]

Hi,

Im trying to populate some data into a Table in Excel which is online. There is another Flow that uses that table. The Script is for clearing previous values and then populating the table with only new values from Power bi set. The Add to Excel Field expression is : 

item()?['XXXX[xxxxxx]']

I keep getting this error:

InvalidTemplate. Unable to process template language expressions for action 'Apply_to_each' at line '0' and column '0': 'The number of foreach items limit exceeded for action 'Apply_to_each': maximum '5000' and actual '59135'.'.

Any help would be very appreciated!! 😁

[PragsGiggle]

Hi, Please elaborate with screenshot and codes.

[Erika_S]

Try adding Select before trying to add rows to excel.  Excel one has to be in a Table format aswell. 

[Stake]

Its seems like you get a item limit as the Flow dont want to do the loop with more than 5000 elements. You could try to limit the query with the formula TOPN. TOPN(4999, SUMMARIZECOLUMNS('XXXXX'[XXXXX])). 

[renearide]

I'm trying to run the same flow, but I don't see any dynamic Power Bi content for me to add in Excel. Below is a print of a test I'm doing. Can you help me?

[Erika_S]

Hey, sorry, i somehow missed this. 

In Exspression try to put: items('Apply_to_each')?['Tabela Vendas[CLIENTES]'] etc. 

Let me know if that works.

all the best,

erika