Update SQL table from excel file at sharepoint

(0) Share

Report

Posted on by tracytran

144

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.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

eric-cheng 5,171 on at

Like (0)

Report

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

Was this reply helpful? Yes No
tracytran 144 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Verified answer

tracytran 144 on at

Like (0)

Report

Here is the flow for this issue:

Was this reply helpful? Yes No