When new file created delete old rows and copy over new ones
I have a power app that i am trying to automate the upload of data to.
There is a backing excel sheet to the app that holds the data. What i am hoping to do is that when a file with the latest data comes out, this can be dropped into a designated folder. Then in power automate a flow that says, when a file is created in this folder, delete the current rows on the backing excel sheet to the app, and copy over the rows from the new file that has just been uploaded.
I am struggling to create a flow that works, is this possible?