Answered

Skipping Empty Fields in Forms

(0) Share

Report

Posted on by Community Power Pla...

I have created a flow triggered by a Microsoft Forms being filled out and submitted, however I am struggling to figure out how to skip fields in Forms if they are empty. Currently when the form is submitted, the empty field will empty out that part of the SharePoint List. Below is what I currently have.

The result of updating 1 field and leaving the other 5 blank

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

beerad on at

Like (0)

Report
Maybe I am misunderstanding what you are trying to accomplish, but should the flow be:
Form being submitted as the trigger
Get the response ID from the form
Create an Item on the Sharepoint list

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Sorry I just realized I was not clear in the original post. The current form is to update an existing row in a SharePoint list.

So I have that, the issue is that lets say for for all 6 contacts on the form (1-3 Day and 1-3 Night), all of them stay the same but for 2nd Day Time Contact. If the form only contains information to update 2nd Day time, the flow I have (using Update Item) is currently rewriting the other 5 contacts as blank however, I would like for them to stay unchanged

Was this reply helpful? Yes No
beerad on at

Like (0)

Report

Ah. The post below may help

https://powerusers.microsoft.com/t5/General-Power-Automate/change-null-to-blank-for-choice-values/m-p/153530#M15623

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I tried using that If formula by calling the fields, but it states expression is invalid. Is there something I did wrong in the expression? I tried it 2 different ways

if(outputs('Get_response_details')?['body/rc434835e962341e086d37fddae50d2e6'] <> "", outputs('Get_response_details')?['body/rc434835e962341e086d37fddae50d2e6'], outputs('Get_items')?['body/value'] )

if(outputs('Get_response_details')?['body/rc434835e962341e086d37fddae50d2e6'] <> "", outputs('Get_response_details')?['body/rc434835e962341e086d37fddae50d2e6'], outputs('Get_items')?['1st Day Time Contact'] )

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (1)

Report
Hi @Anonymous ,

As the post provided by @BradWest says, you could try to use the empty() function in the expression.
if(empty(outputs('Get_response_details')?['body/rc434835e962341e086d37fddae50d2e6']),items('Apply_to_each')?['1st Day Time Contact'],outputs('Get_response_details')?['body/rc434835e962341e086d37fddae50d2e6'])
Result Screenshot:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No