Rows Added Power Query

[krixtsup3r]

Hi Guys, I have a dataset that I get from an API which updates an excel file. I used a power automate in doing this and what it does is that it will get the data from a server then update the entire excel file so it will be a new fresh data. 

My question is that, is there a way for me to get how many rows were added? I'm thinking of incremental refresh, but how will it work if the file is a new one? Maybe a quick summary like below:

Datetime	Total Rows	Rows Added
8/17/2021 7:00	490,132	0
8/17/2021 8:00	495,794	5,662
8/17/2021 9:00	504,498	8,704
8/17/2021 10:00	507,498	3,000
8/17/2021 11:00	509,830	2,332
8/17/2021 12:00	512,617	2,787

[mahoneypat · Accepted solution]

You could create a separate Excel file to store that info, and then add an action to your flow to update that Excel with the DateTime and count of rows in the http array (if I understand your Flow correctly).  You could also read in that Excel to get the sum of rows from previous refreshes to get the total rows.

Pat

[krixtsup3r]

Hi @mahoneypat , that is a great idea! so basically what my flow will do is:
1. Count the rows of existing file

2. Update the separate file and logged in the # of rows 

3. Run the Update file sequence

Did I get that right? I only know a few basics in flow, if you have a template or resource link to do that I would appreciate it but I will do googling for it. Thank you! 🙂

**I'll close this later today and might want to fish for more suggestions. 🙂

[mahoneypat]

Sorry I don't have a template to share, but it seems like you have a good plan.

Pat