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.