Answered

Skipping Empty Fields in Forms

Like (0) Share

Report

Posted on 26 May 2022 18:33:25 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

All responses (5)

Answers (1)

Verified answer

v-yujincui-msft on 02 Jun 2022 at 07:03:44

Like (1)

Report
Re: Skipping Empty Fields in Forms

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
Community Power Pla... on 01 Jun 2022 at 16:36:59

Like (0)

Report

Re: Skipping Empty Fields in Forms

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'] )
beerad on 27 May 2022 at 12:22:49

Like (0)

Report

Re: Skipping Empty Fields in Forms

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
Community Power Pla... on 26 May 2022 at 19:45:54

Like (0)

Report

Re: Skipping Empty Fields in Forms

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
beerad on 26 May 2022 at 19:40:25

Like (0)

Report
Re: Skipping Empty Fields in Forms

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