Answered

Can Power Automate transfer data from SP Online List to a SQL database?

(0) Share

Report

Posted on by JulieBird

I was under the impression this was possible, and I found a MS Document suggesting it could. But no matter I search for on Yout Tube, I can not find a single video showing how to do this.

We use a lot of SharePoint Online Lists as a datasource, but our 'SQL Guru' at work is finding iot impossible to pull the data into our data warehouse (SQL database) ... any tips or pointers?

Huge thanks, I have been googleing for over 4 hours now 😞

Julie

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

HI,

No worries, I dont know if this is a one time thing or not? Or if you want to use it on a schedule, as that would change things

1. create a manual trigger
2. Get items (from whatever list you want)
3. Apply to each (on the dynamic value property of step 2)
4. Use the SQL Connector to see if the record already exists
4a. Yes, update it using the connector
4b. No, create it(add it) using the connector

Also if you wanted to do it for all yours lists

1. create a manual trigger
2. Get Lists
3. Apply to each (loop through lists)
4. Get items (from loop of lists)
5. Apply to each (on the dynamic value property of step 4)
6. Use the SQL Connector to see if the record already exists
6a. Yes, update it using the connector
4b. No, create it(add it) using the connector

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
JulieBird 55 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Michael,

Many thanks for your answer! Thats the first bit of positive news I've had yet (even on my FB groups, they are saying to use an intermediatory solution such as exporting to a csv first, but I had hoped we could do it directly 🙂

You mention that if this wasn't a one off thing then it would be slightly different approach ? This would be an ongoing daily update so I am guessing would need a scheduled flow, but in what other way would the abiove be different in that scenarion?

Thanks 🙂

Was this reply helpful? Yes No
Verified answer

Michael E. Gernaey 53,963 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @JulieBird

Actually that is the only difference, since I already mentioned in my steps to check if its there and update and if not create it new.

If you could please mark my response as Resolved I and put a thumbs up I would appreciate it.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No