Power Automate Sharepoint modified not working

[apla]

Hello,

I have a Flow that is triggered by a modification of an Excel file on Sharepoint. Once triggered, a SQL procedure is supposed to execute to delete all of the contents of a SQL table. The flow then lists the Excel rows present in a table and is supposed to push all the data to the SQL table. 

There are two problems--one is that the latest modification doesn't get uploaded to the table while previous modifications do:

If I make two modifications, the one before the last shows up but not the latest. 
For example, in the screenshot below if I made two changes to the last name initial of B to c and u to v:

When I check the SQL table, only the first change is shown and not the latest:

The second issue is that sometimes there are duplicated rows showing all the versions of the rows which I suspect could be due to versioning issues. Versioning is turned on for the folder.

I would appreciate any help on this. Thank you.

[eric-cheng]

Hi @apla ,

With your first issue, is the flow not triggering at all or does it error?--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[apla]

Hello, the flow is triggering but it doesn't show the latest modification. For example, if I change data in a column for one row in the Excel sheet, it will not show up in the SQL table until I make another edit in another row (and then that last edit will not show up).