Hi there, i Have a file which i am counting rows from . Lets say its "Week1". I want to update another file lets say its "Rows Counted", in the next free row/cell in a column called "totals". This happens every week so i need a formula or expression to help me look for the next free row every week. This is what my flow looks like so far
1. Manual Trigger
2. List rows present in a table (Location, Library, file, table of file "Week1.xlsx")
3. Compose (Input - length(body('List_rows_present_in_a_table')?['value']))
4. List rows present in a table 2 (Location, Library, file, table of file "Rows Counted.xlsx")
5. Apply to each (Output - Value of List rows present in a table 2)
6. Update a row (Location, Library, file, table of file Rows Counted.xlsx), Key column is the ID column of my excel file, i don't know what the key value would be, and the column "totals" has the output of the composed output
What do i need to add because this does not work
