You’re offline. This is a read only version of the page.
Hi friends,
I would like to update the SQL table from excel file where stored in Sharepoint. The excel file in Sharepoint will be modified as the time goes by and it will contain the existing and updated data.
I created this flow:
However, It inserts all rows in excel file to SQL tables, which has existed rows same as in excel file. It leads to duplicate data. What I want is SQL table have the same data with excel file and no redundant/duplicated data.
Could anyone please help me with this flow?
Any help is highly appreciated.
@eric-cheng Thank for asking.
Will the Excel file be modified or will it be a new Excel file uploaded to SP?
==> The excel file will be modified as the time goes by. No new excel file uploaded to SP
Will the Excel file contain existing and updated data or just new data?
==> The excel file will contain existing and updated data.
If you have any questions, please let me know
Hi @tracytran ,
Will the Excel file be modified or will it be a new Excel file uploaded to SP?
Will the Excel file contain existing and updated data or just new data?
Will you also require SQL to update all existing records based on Excel or just insert the data straight from Excel?
--------------------------------------------------------------------------
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
#1
Michael E. Gernaey
66
Super User 2025 Season 1
#2
stampcoin
65
#3
rzaneti
41
Super User 2025 Season 1
Share
Report
All responses (
Answers (
