Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
May 7th | Register Today: Understanding Agents- Introductory Session
🌸May 8th | You're Invited: Community Spring Festival Awards Celebration🌸
May 14th | Power Platform Community AMA: Power Apps Edition
News and Announcements icon
Community site session details

Community site session details

Session Id : ZhvngB6etoIRyo+XIBuWIr
Power Platform Community / Forums / 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) ShareShare
ReportReport
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?

  • abm abm Profile Picture
    abm abm 32,464 Most Valuable Professional on 26 May 2020 at 23:56:54
    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. 

     

    image.png ]

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

     

    image.png

     

    Thanks

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!
May 7th | Register Today: Understanding Agents- Introductory Session
🌸May 8th | You're Invited: Community Spring Festival Awards Celebration🌸
May 14th | Power Platform Community AMA: Power Apps Edition

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

#1
ankit_singhal Profile Picture

ankit_singhal 7 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 4 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 2 Super User 2025 Season 1

Overall leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans