Unanswered

Using a Form to Update a Row in SQL only when the submitted data is not null

(0) Share

Report

Posted on by unfeomateo

I have a Microsoft Form that I need to use to update a row in SQL. Not every question needs to be filled out so some questions will be blank. I only want the questions that are filled out to overwrite the data in SQL. Right now with a basic Update Row step any question that is left blank will update SQL to null.

Is there a dynamic way I can only update SQL when a question is not null. Right now all I can think of is a bunch of condition steps with multiple Update Row steps for each question on the form.

I have been looking for a while and I am not any further along

Thanks so much.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

Is it possible to write a Stored Procedure and accept all values? Then within a stored procedure, decide based on the parameters when to execute update statement vs when not? You can use Execute Store Procedure action..

Was this reply helpful? Yes No
unfeomateo 37 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the idea. I was hoping I could do this in Power Automate. I can run this by my DBA's but its not something I can do on my own.

Thanks again.

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

Using Power Automate, you will have to include those conditions. That is why I recommended this approach.

Was this reply helpful? Yes No