LookUp Function incompatible types for comparison: Text, Record

(0) Share

Report

Posted on by nwilson98

Hello,

I am trying to create a form that populates data into other fields when one field is input. The table is called PDR and pulls from an excel query. ComboBox2 has a data source to the PDR table where "Material" is the DisplayFields and SearchFields. I want the corresponding data from the ComboBox2 selection to populate into other fields. For this example, I'm trying to populate the "Ord Number" with the below function.

LookUp(PDR,Material = ComboBox2.Selected,'Ord Number')

This is returning the incompatible types error. These types can't be compared: Text, Record. Any help or guidance for a resolution to this error is appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report
@nwilson98

Selected is a record. So you cannot compare a record to text.

Please consider changing your Formula to the following:

LookUp(PDR, Material = ComboBox2.Selected.Material, 'Ord Number')

I hope this is helpful for you.

Was this reply helpful? Yes No