News and Announcements icon

Power Platform CommunityForums Power Automate - General Discussion Migrate from on premis...

Power Automate - General Discussion

Unanswered

Migrate from on premises SQL to various Sharepoint online lists

Like (0) Share

Report

Report

Posted on 26 May 2020 06:35:05 by Community Power Pla...

Hi,

We have planned to to shift our projects from on-prem hosting to PowerApps(SPO lists as datasource).

How can we move all data from local SQL databases to SPO lists?

All responses Img

All responses (1)

Answers Img

Answers (0)

abm abm 32,464 Most Valuable Professional on 26 May 2020 at 23:56:54

Like (0)

Report

Re: Migrate from on premises SQL to various Sharepoint online lists

Hi @Anonymous

Microsoft Power Automate supports on-premise data connections.

https://docs.microsoft.com/en-us/power-automate/gateway-reference

Once installed and configured the connection you can access your on-premise SQL server using action step Get Rows (SQL) for retrieving the records.

]

To create the records in SharePoint list use Crate Item action step.

Thanks

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Leaderboard > Power Automate - General Discussion

#1

stampcoin 23

#2

Pstork1 20 Most Valuable Professional

#3

Gprior 19

Overall leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans