Unanswered

On premise MS Sql server to sharepoint online

(0) Share

Report

Posted on by kozakjanos

Can i pass my data to sharepoint online list from ms sql database with create ms sql record event?
My issue the next: i have a on premise ms sql database and i'd like to insert my data to sharepoint online list too, when a new record created in my selected table.
i installed the onpremise data connector, but i do not see any action able to do this.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

telu Microsoft Employee on at

Like (0)

Report

Hi kozakjanos,

Currently we don't sql trigger right now, so I think some workarounds might be use recurrence trigger to check whether there are new records inserted into the db.
Thanks

Was this reply helpful? Yes No
kozakjanos 2 on at

Like (0)

Report

Hi,

thx. The response, I've tried this solutions too, but when the workflow finished, all record insert into my SharePoint list again and again.
whatever i'd like track the changes that only the new record insert my sharepoint list not the all.
do you have any idea?

Was this reply helpful? Yes No
telu Microsoft Employee on at

Like (0)

Report

Hi kozakjanos,

My idea is using a extra backup table, every time when the 2 tables have difference, use sql to calculate the different and get the newly inserted rows, send them to the sharepoint and insert them into the backup tables. We might have the trigger of when new rows inserted into sql to replace this workaround.

Thanks

Was this reply helpful? Yes No