I have a couple of flows that will send out emails for approvals, but I am running into a slight problem. The flow will send the email, with the response, but I need to update the corresponding SQL record with the response. Is this possible? The initiating app is a PowerApp, and the flow is set to run after the patch statement is executed.
Solved! Go to Solution.
How is your flow triggered?
Please try to use the action Update row to update an existing row in a table. Note, a primary key is required when using Update row action.
If your flow is triggered by a PowerApps button, you could specify the required Row id and Id from PowerApps, then update the email response to the table.
If you are using SQL Azure Database table, you could consider using triggers in the SQL connector, so that your flow could be triggered when an item is created, then update the corresponding item with the email response.
Please take a try with it on your side.
The following docs for your reference:
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Many congratulations to the Season 1 2021 Flownaut Crew!
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.