
Announcements
Dears,
Can Power Virtual Agent work with API to update some fields in local SQL database
Any idea
Thanks
Hi @GhassSD ,
Power Virtual Agents no, but you can connect your PVA with Power Automate workflow to update SQL local database.
Basically you will use the Data Gateway to connect your SQL local and inside the Power Automate, you will connect with the Data Gateway.
https://docs.microsoft.com/en-us/power-automate/gateway-reference
https://flow.microsoft.com/en-us/connectors/shared_sql/sql-server/