I have a flow 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. Where do I need to specify the row Id in my PowerApps application so I can Update Row? I'm using "Id" as a primary column in SQL server.
The SQL connector has many known issues and limitations, so the first step is to insure that your PowerApp and Flow do not encroach on those issues and limitations.
With that said, the SQL connector does have an Update row action, so you should be able to get your desired result. Before you add the Update row action, you may first need to perform a Get rows action, which should give you the built-in parameters to call the proper row Id.
Unfortuantely, I do not have a SQL server available to me so I can't mock up a demo. If this doesn't work for you, please reply with an expanded screenshot of your Flow for further review.
See the following line from my previous post: Before you add the Update row action, you may first need to perform a Get rows action, which should give you the built-in parameters to call the proper row Id.
Please review the Actions documentation for the SQL connector. You must use the Get row which should give you access to the Row id string Unique identifier, so they can use the Id key.
You'll need to use a logical expression condition to do some basic logic to match your email to your row. I'm guessing you're using some kind of unique name or number system for the records.
Basic Flow Steps
I may be able to provide more assistance if you post the a detailed screenshot of your flow, but as I am describing it should work.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. THANKS!
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks