Update Dataverse Field only if the value is not blank

[powerbug]

Hi,

I have a Power Apps form which then passes a collection of values to a flow.

The flow Updates the record in the following step and for other restrictions around requirements I have to pass values to the update like this. 

What expression can I use to ensure it doesn't pass any value when, for example, then when the value for 'or' is blank it will not update the original/repeat field?

[MarconettiMarco]

Hello @powerbug ,

in a step before you could add a "Compose" action and provide the "empty" expression:

empty('<your_value>')

If the output is equal to true, don't update the row, if it's false update the row.

Please let me know if the issue is fixed.

If I have answered your question, please mark my post as Solved.

If you like my response, please give it a Thumbs Up.

I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.

My blog site about Power Automate: https://powerautomatejoy.com/

BR,

Marco

[powerbug]

unfortunately this doesn't solve my problem as this applies to all the values, how can I if/else them all? that would mean having 20 different update row actions if I have 20 values on that form

I simply will update one row with a set of values and I don't want to update if value is empty

[EnricoKnapp]

I have the same challenge here. I only want to update all present values to my dataverse table. All values that were left blank should not be updated in the dataverse table to prevent data from being overridden by null values. Right now I only see the option to have all my fields handled separately in a update item action that will be skipped if the value was left blank in the form but that is not very sexy to read in the workflow. Is there no better way?