Hello,
I have an Excel file that is updated (overwritten) every day and I want to create a flow that do a lookup between the Excel file and a Sharepoint List/SQL in order to update in Sharepoint List/SQL the rows that were modified and to insert a new row for each ID that is not in the Sharepoint List/SQL.
The File name and Table name are dynamically derived from other steps, as I could not selected them from the dropdown because the file is overwritten everyday.
I am now in the point where I need to set up the key value and this is the point where I have got stuck.
Every advice is very welcomed and appreciated.
Thank you in advance!