Hi,
First poster here as I'm new to the work of Power Automate.
I have created a flow so that when a new email arrives with an attached CSV file, this file will then be moved into a SharePoint location, so far so good. This is a flow which is scheduled to run whenever a new email is received (twice a day in this case) and the file is replaced with a new updated file twice a day. The data in this file is a list of contacts in the past 12 hours and is not in a table format.
I also have a master spreadsheet, also located in Sharepoint, I want this master spreadsheet to look at the new updated CSV file and count the number of rows on the new updated CSV file that we get delivered twice a day, Ideally I would want to do a Countif function so I can include various cout criterias.
I have the below flow so far, and as you can see, I have a excel formula to count the number of rows - =COUNTA('Incidents logged in the past 12 hours.csv'!A2:A1000). This works initially and adds a new row to a table on the master spreadsheet (which is what I want) and adds the value I am after. However, when this file is updated later on in the day with a new CSV, it adds a new row in the master spreadsheet but with the old number and not the new updated figure.
I'm pretty sure I need a dynamic instead of a basic 'Counta' function, but this is where I get lost.
Is there a way I can update this flow to have a new row added every time I get a new CSV delivered and also count (with a few criterias) the new number f rows on the new spreadsheet.
As you can see I am using the new flow designer, but would it be any better in the old flow designer?
Many thanks in advance.
