Label shows Column value based on if another column is Null.

Submitted by melinda on Mon, 06/27/2022 - 13:34

I have two save and submit options for my app.

I needed user to view if they "Updated and Submitted", "Saved only" or "Submitted"

In my gallery I added a label.

Formula in the label

If(IsBlank(ThisItem.ColumnLookingForNull), ThisItem.ColumntoDisplayifFirstColumnisNull.Value, ThisItem.ColumnLookingForNull.Value)

 

My specific formula.
If(IsBlank(ThisItem.UpdateTrips), ThisItem.oktosubmit.Value, ThisItem.UpdateTrips.Value)

Outcome:

laugh