Power Platform Community Forum Thread Details

Hi, there is a way to connect with PDA to the Dataverse that is not through paid connectors such as:

https://www.cdata.com/kb/tech/dataverse-odbc-power-automate.rst#:~:text=Open%20Microsoft%20Power%20Automate%2C%20add,results%20to%20a%20CSV%20document.

Categories:

Power Automate Desktop

@paronchi
Have you considered using the Dataverse Web API to get the records you need? A GET request can retrieve a whole table or be filtered only return the records you need.
https://docs.microsoft.com/en-us/powerapps/developer/data-platform/webapi/query-data-web-api

You can invoke a web service in Power Automate Desktop (found in the HTTP group). If you follow the documentation in the previous link it would appear you can get result you need.
https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/web#invokewebservicebase

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."