Filter combobox based on a lookup value

[alexy1111]

Hello,

We are trying to filter combobox based on a lookup value. The main table is called payments (the table of the combobox) the lookup field is called 'Customer' we want to filter the combobox based on customer's guid:

Filter('payments',Customer = GUID("54d22ce7-ab8d-e911-a824-000d3a47cc75"))

But we constantly get an error that these are different types of values

powerapps incompatible type. these types cannot be compared: record, guid

Anyone have an idea what the problem is?

Note: The environments are not in English and the table names are in another language, could it be that this is the problem?

[alexy1111]

HI @Prakash4691 

Okay. First of all I'm sure it's the name of the field, But since this is a LOOKUP field do I have to write the field after the dot or choose from the list it gives? (Because when I pot a dot  after the lookup I do not get a list of fields within the LOOKUP table)

I also tried to make another combination:

The name of the table that contains the Lookup.The unique identification field in the table

[Prakash4691]

@alexy1111 ,

It's better to pick from list so we can avoid mistakes.

It has to be fieldname.tablename

Regards,

Prakash

[Prakash4691]

@alexy1111 ,

It's better to pick from list so we can avoid mistakes.

It has to be fieldname.tablename

Regards,

Prakash

[alexy1111]

Hi @Prakash4691 ,

Like I said before, after I select the field and make a dot he does not let me choose from the lookup anything

[alexy1111]

I really do not understand why it is so complicated. What's the point of complicating this if you want to do it LOW CODE. All I want to do is filter records according to a fixed GUID, work of a few minutes in code as of today almost 3 days in POWER APPS 😂 😂 😂

[Prakash4691]

@alexy1111 ,

Is that customer lookup field present in payment table?

I hope field data type is lookup and not customer.

 While selecting customer you have to select field name and not table name. If you select table that will highlight in different color.

So it has to be, Filter('payments',Customerfield.uniqueid(tablename)= GUID("54d22ce7-ab8d-e911-a824-000d3a47cc75"))

Regards,

Prakash

[alexy1111]

HI @Prakash4691 ,

This is a customer type field (not a standard lookup), I'm not sure what you mean by uniqueid (Customerfield.uniqueid(tablename)) but if I understood correctly I get the same error

Another very important thing, once I select Customerfield and do a point I do not get any entries

Another version Same error😅

[Prakash4691 · Accepted solution]

@alexy1111 

Ok. So it is a polymorphic lookup.

Follow below link,

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-references

Customer can be either contact or account. Try to check with AsType.

Ex : AsType( ThisItem.'Company Name', Contacts ).'Full Name'

Regards,

Prakash

[Prakash4691 · Accepted solution]

@alexy1111 ,

Polymorphic lookup of customer type can be either account or contact.

Before formula, add respective tables as datasource in the app. Attached screenshot for your reference.

Try below formulas,

In combobox to display only accounts in items property, use : Filter('Test 2S', AsType(customer, Accounts).Account = GUID("2342"))

To display contacts use : Filter('Test 2S', AsType(customer, Contacts).Contact = GUID("2342"))

customer is a field, Accounts/Contacts are table.

I hope it resolves your issue. If yes, kindly give kudo and accept it as solution.

Regards,

Prakash