Unanswered

Can Power Automate Desktop execute Microsoft Dataverse?

(0) Share

Report

Posted on by mickuj

Hello,

I am interested in integrating Power Automate Desktop with Microsoft Dataverse.
Specifically, I would like to understand how to utilize the "Execute SQL statement" action to extract data from Microsoft Dataverse (<env>.crm3.dynamics.com)

Thank you for your assistance.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Srini007 3,471 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @mickuj

I believe it's not possible to Execute SQL Statement action, because to use this action it requires a SQL connection & SQL Tables

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,

Srini

Was this reply helpful? Yes No
mickuj 4 on at

Like (0)

Report
Copy link

Link copied!

Hi @Srini007

I can get an SQL connection using Microsoft SQL Server Management Studio.
Please see below.

Best,
Michal

Was this reply helpful? Yes No
Srini007 3,471 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @mickuj

If you have the SQL Connection and you have the Queries to execute then

YES you can use Execute SQL Statement action

Check below documentation for your reference

https://learn.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/database

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,

Srini

Was this reply helpful? Yes No
mickuj 4 on at

Like (0)

Report
Copy link

Link copied!

Hi @Srini007

The thing is that when connecting by SQL SMS I use Azure Active Directory - Universal with MFA.
I don't see this option in PAD.

Best,
Michal

Was this reply helpful? Yes No
Srini007 3,471 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @mickuj

Yeah, Currently the Azure Directory is not supported in the SQL Connection Action

One way you can look is probably you need to write a C# code using Run .NET script

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,

Srini

Was this reply helpful? Yes No
Gauravg 6 on at

Like (0)

Report
Copy link

Link copied!

Yes, use REST API from dataverse
https://spgaurav.blogspot.com/2024/04/dataverse-d365-rest-web-api-using.html?m=1

Was this reply helpful? Yes No