Unanswered

Dataverse data retrieve through PAD SQL Actions

(0) Share

Report

Posted on by Niraj466

Hey team,

Is it possible to retrieve the dataverse table data through PAD SQL actions? If yes, what should be the connection string parameters like server name and database used?

Is there any other was get the dataverse data /

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

kinuasa 795 Most Valuable Professional on at

Like (1)

Report
Hi,
You may need to use a third-party ODBC driver, such as the Microsoft Dataverse ODBC Driver (CData).

Microsoft Dataverse ODBC Driver - CData Software
https://www.cdata.com/drivers/dataverse/odbc/

Alternatively, you may be able to retrieve data by calling the API with an 'Invoke Web Service' action.

Query data using the Web API (Microsoft Dataverse) - Power Apps
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/query-data-web-api?WT.mc_id=M365-MVP-4029057

Regards,
kinuasa

Was this reply helpful? Yes No
Niraj466 73 on at

Like (1)

Report

Thank you @kinuasa . Query data using the Web API helps here. We can use $select and $filter syntax to retrieve the data from dataverse table.

Was this reply helpful? Yes No