Hi!
Each day, a new excel file is saved in a sharepoint library. Each row in this file has a unique identifier (Reference Number), and potentially has updated information within the row (part numbers, costs..). The file also has new rows that were not in the previous day's file.
I am trying to build a flow that grabs the daily new excel file and updates existing items in my sharepoint list or creates new items if they do not already exist.
I am starting with the "When a file is created in a folder" SharePoint trigger to begin. I have watched a few videos to know I will want to use an If yes/no condition to either add or update rows, pending on if they exist of not. However, I am getting stuck on being able to correctly identify/using the automate nomenclature to use the daily created excel file to update or create new rows since it doesn't actually exist yet (as in, it is a new file daily with the same column names and table name). I am not able to grab the dynamic data to grab the excel columns for updates to the sharepoint list, nor am I able to use the logic test of comparing the reference numbers since I cannot grab the reference number dynamic tag.
I would appreciate any help/support!
