cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kitz
Helper I
Helper I

Update a SQL row after email approval

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.

3 REPLIES 3
Brad_Groux
Super User II
Super User II

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.

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.

 

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

  1. When an email arrives
  2. Get tables
  3. Condition / Get row 
  4. 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!

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public 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

Users online (57,616)