Answered

Update table from SQL Procedure

(0) Share

Report

Posted on by iskguy

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:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

AhmedSalih 6,678 Moderator on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No