Hi all, another beginner question:
Before patching a new record to Dataverse, I need to know if there already exists a record with the same values. In my case, I need to check if a Check-In record with certain properties already exists.
I'll probably need to start with something like this:
If(IsEmpty(Filter('Check-Ins',
But now I need to check 4 columns for certain values. 3 of those are a lookup and the 4th is a choice field. I know how to patch these, but can't seem to figure out how to check for the values. Here's how I patch them:
Patch('Check-ins',
{
'Check-in type': 'Check-in type'.'Event check-in',
'Event registration': LookUp(Gebeurtenisregistraties, QRCodeScanner_1.Value = 'Registration ID'),
Location: LookUp(Venues, ComboBox3.Selected.Name = Name),
Event: LookUp(Gebeurtenissen, Event = LookUp(Gebeurtenisregistraties, QRCodeScanner_1.Value = 'Registration ID').Event.Event)
}
)
I thought I could check the value replacing the ":" with a "=" but that doesn't work. Eg this one:
Location = LookUp(Venues, ComboBox3.Selected.Name = Name)
Throws a compatibility error: "These types can't be compared: Record, Record"
Can someone point me in the right direction for this? Many thanks!
