@CMSGuy -
The Patch function requires three parameters (source, record, update).
One method is simply use the IF function to identify if the record exists. If the record exists, then reference the record, otherwise return Defaults.
Basic example below:
Patch(
'Your List',
If(
IsBlank(
LookUp(
'Your List',
ID = 100
)
),
Defaults('Your List'),
LookUp(
'Your List',
ID = 100
)
),
{
Title: "A1",
DateColumn: Today()
}
)
The alternative example below is virtually the same as the above, but written in a more legible structure using the With function so we can avoid using the same LookUp function twice:
With(
{
_get_record: LookUp(
'Your List',
ID = 100
)
},
Patch(
'Your List',
If(
IsBlank(_get_record),
Defaults('Your List'),
_get_record
),
{
Title: "A1",
DateColumn: Today()
}
)
)
