web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to check if a reco...
Power Apps
Answered

How to check if a record exists in Dataverse while using lookups and choice field?

(1) ShareShare
ReportReport
Posted on by 159

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!

 

 

 

Categories:
I have the same question (0)
  • KeithAtherton Profile Picture
    3,709 Most Valuable Professional on at

    Hi @JDG__,

     

    Does intellisense allow you to check for other fields, such as ID? For example:

    LookUp(Venues, ComboBox3.Selected.Name.ID = Name.ID)


    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.
    Connect with me online.

  • Verified answer
    JDG Profile Picture
    159 on at

    I managed to get it working. The main challenge was finding the correct syntax for the choice field:

     

    'Check-in type' = [@'Check-in type'].'Event check-in', 

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 534

#2
WarrenBelz Profile Picture

WarrenBelz 416 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 306

Last 30 days Overall leaderboard