Hi all,
I'm trying to patch a sharepoint list and I can't seem to get the toggle column to flip. If the record doesn't exist yet, it's creating it successfully and the toggle is flipped to true like I want.
If the record already exists and the toggle just needs flipped from false to true, it's not flipping.
My default value for the toggle is "checkintoggle".
I've confirmed that "myitem" is null when the entry doesn't exist yet, and is populated when it does.
Thanks in advance
My button's onselect is:
UpdateContext({checkintoggle:true});Set(myItem,LookUp('Registration Form', 'Full Name'=FullNameCell.Text && 'EventDate' >= DateAdd(Today(),-7)));
If(IsBlank(myItem),
Patch('Registration Form',Defaults('Registration Form'),{'Full Name':FullNameCell.Text,'E-Mail':EmailCell.Text,City:CityInput.Text,State: StateInput.Text,Title:VenueInput.Text, 'EventDate':EventDatePicker.SelectedDate,'Checked In?':checkintoggle,'CaptainEmail':varCaptain,'FromDomain': DomCell.Selected.Value}),
Patch('Registration Form',myItem,{'Full Name': FullNameCell.Text,'E-Mail':EmailCell.Text,City:CityInput.Text,State: StateInput.Text,Title:VenueInput.Text,EventDate:EventDatePicker.SelectedDate,'Checked In?':checkintoggle,'CaptainEmail':varCaptain,'FromDomain': DomCell.Selected.Value})
);UpdateContext({ShowDialog:true})
