cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GhassSD
Helper III
Helper III

Power Virtual Agent- API- Change field in local SQL database

Dears,

 

Can Power Virtual Agent work with API to update some fields in local SQL database

 

Any idea

Thanks

1 REPLY 1
renatoromao
Super User
Super User

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/


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.300 students | PROMOTIONS) : English | Português

Helpful resources

Announcements
March Update

Welcome to the User Group Private Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (62,622)