Conditional Excel update based on column
Hello, I need help with a workflow.
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