Hi,
So, is the ask for us to build it? I am not sure what the ask is, but we don't just build peoples stuff generally, we are free volunteers not paid consultants.
With no offense meant, people are just doing what you are doing, putting requirements in like we get paid. please don't disrespect our time like that. You literally have no questions, no work done, nothing.
Here are some thoughts to be generous
1. Put your files in SharePoint or OneDrive
2. Create a new Automated Flow
--That triggers when a file is updated or created. This way you can put the Monthly file in the same place and it will trigger the flow
3. Make sure that your Master Excel and the Incoming monthly have a Table defined around the data
Or
You will need to use the Create Table action to add a Table to the Incoming file each time. The master file should be easy as you only have one of those so just make sure its there before you save it.
4. Use the List rows in a Table action to retrieve all the rows in the monthly file
5. add an apply to each to loop through the Output from step 4, where it will return an array of data rows, or it will return a blank/empty array
6. inside the Apply to each
--Do a List Rows in a Table, against the Master, but use a Filter, leveraging the ODATA Filter, to try to see if an existing row already exists or not
----Add a Condition
------In the condition on the left use the length expression to check the length of the Dynamic values or body/value output from your List Rows against the master file.
-------in the single use is equal to
-------on the right say 1
This will tell you IF you found a row or not.
In the Yes Side, meaning you found a row, you can now do an update to it with the data from the Outer List rows against the monthly file
or
In the No side (it didn't find out), do an Add a row into a table action for Excel and pass in the data (again) from the Out List Rows against the monthly file
And done
Thats it.
Please go try to build that then please come back if you have further questions.
