I have an Excel file on SharePoint and a data source that I query daily. The data from the source should be added to the Excel file if it’s not already there. There is a column called “FC Version” in the data, which is the same for all rows.
I would like the data to be appended if the “FC Version” from the source matches the one in the Excel file. However, if the “FC Version” is different, the Excel file should be completely overwritten.
I would be very grateful for your help
You can extract the key column from both the source and SharePoint Excel files, then compare them using nodes like Joiner or Reference Row Filter. Based on the comparison result (i.e., whether matching rows are found), you’ll get either a non-empty or empty table. You can then convert this into a flow variable and use a expression node to set a condition like:
Use this flow variable in the Excel Writer*node under the File selection → If file exists option. Also, make sure to select Append to sheet if exists in the writer settings.
Hello @k10shetty1,
thank you very much for your reply. I implemented it in a similar way to what you suggested, but I used an if-statement that updates or overwrites the table depending on the condition
