stop 'null' being saved to SP List

in my app, i have a list box with items, and then some controls in a gallery

the process is, select item from list, and then select control(s) from gallery and submit to SP

my issue, if i don't select an item from list, but i select control from gallery, a 'null' value gets saved to sharepoint upon Submit

here is the code to update the control

UpdateIf(colRecord254, ID=ThisItem.ID, {c1:ListBox1_1.Selected.Code});

how do i make sure that an entry doesn't get stored in the control unless the listbox item has been selected?

4 comments

Public group

A community of people who are enthusiastic about and trying to learn about Microsoft's Power Apps!

Leaderboard (30-day)

+94

+46

+36

+27

+24