SharePoint Update Item, if input is blank do nothing

[cbohlman]

Hello,

I am trying to write a flow that updates one Sharepoint list based on the input values of a second SharePoint list. The flow works well for the fields that require an input in the Data Entry list. However, for the optional fields that are left blank the flow is updating the Records list with a blank field as opposed to leaving it as the original value.

Is there an expression that will let tell the field to update with the new value if it exists and to do nothing if it is blank? (Other fields will need to be updated so it is only some fields that may not be updated)

[v-LilyW-msft · Accepted solution]

Hi @cbohlman 

Do you want to judge whether the input is empty? If it is empty, keep the original value, if not, replace it with the input?

You take a try to use the if() function to achieve it. I set up a flow, you can refer to below screenshots:

The following are my two lists. Flow is triggered when the item in ListA is modified. If the TestColumn in ListA has a value, update the TestColumn in ListB. Otherwise, keep the original value of ListB.

Expression:

if(empty(triggerOutputs()?['body/TestColumn']),items('Apply_to_each')?['TestColumn'],triggerOutputs()?['body/TestColumn'])

Hope the content above may help you.

Best Regards

If my reply helps, then please consider Accept it as the solution to help the other members find it more quickly.

[cbohlman]

Thank you! That expression worked! I had been struggling with getting the syntax right so I appreciate the help!