Unanswered

Update a SQL row after email approval

(0) Share

Report

Posted on by Kitz

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.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Brad_Groux 4,556 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Kitz 30 on at

Like (0)

Report

Thanks for the response. I have called the GetRows() using flow for SQL Server but unable to figure out where to specify the exact row id.

Was this reply helpful? Yes No
Brad_Groux 4,556 on at

Like (0)

Report
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
When an email arrives
Get tables
Condition / Get row
Update row
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!

Was this reply helpful? Yes No