Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

Update table from SQL Procedure

(0) ShareShare
ReportReport
Posted on by 402

What do you think would be the best way to update a table in DataVerse from the result set of a SQL server stored procedure?  I have made a power automate to get a JSON file where I probably could create a csv to save into a share and then have a scheduled dataflow from DataVerse run?  Or is there a good way to take the Result set and update / create the rows in the Dataverse table?  

 

I have been manually running the procedure, copying the results out to a csv, then having the dataflow run and do its thing.  I just want to fully automate this process.

 

Thanks for the suggestions

Categories:
  • Drew Poggemann Profile Picture
    Drew Poggemann 9,278 on at
    Re: Update table from SQL Procedure

    Hi @iskguy ,

     

    Have you thought about using Power Automate with the SQL Connector?  https://docs.microsoft.com/en-us/connectors/sql/ Some limitations exist around the output of stored procedures but hopefully these don't hinder you.  You can then take the information from your stored proc results and utilize the Dataverse connector to add / update / delete etc. rows.  

  • Verified answer
    AhmedSalih Profile Picture
    AhmedSalih 6,678 on at
    Re: Update table from SQL Procedure

    @iskguy, I have done something similar with the SQL Views, if you can create a view from that Stored Procedure, you can then use Dataflowas to load the data from the view into a Dataverse table. Remember that you will treat the SQL view as a Table when you are configuring the data flow.

     

     

    Regards,
    Ahmed
    If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accepting it as the Solution to help other members of the community find it more.

     

     

     

     

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics