Solved: Filter combobox based on a lookup value

alexy1111 · ‎08-30-2021

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?

Prakash4691 · ‎08-31-2021

@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

View solution in original post

Prakash4691 · ‎09-01-2021

@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

View solution in original post

rampprakash · ‎08-30-2021

Hi @alexy1111,

You can try below code

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

alexy1111 · ‎08-30-2021

HI @rampprakash ,

the same error

Prakash4691 · ‎08-30-2021

@alexy1111 ,

Is lookup value will remain constant? Because you have provided guid as a static value and not dynamic?

If it is remains static, go to main entity and create new view with filter condition for customer. In canvas app, remove formula from combo box, it will ask for datasource, select your entity and view(which created above).

I hope there is relationship exist between payment and customer entity/table.

If it answers your question, kindly give kudo and accept it as solution.

Regards,

Prakash

alexy1111 · ‎08-30-2021

No, the lookup value will NOT remain constant, In the future it will be based on dynamic value.

But for testing purposes we need to use a GUID

Prakash4691 · ‎08-30-2021

@alexy1111 ,

Try below,

For static : Filter('Test 2S', 'Test 1'.'Test 1' = GUID("332"))

For dynamic : Filter('Test 2S', 'Test 1'.'Test 1' = BrowseGallery1.Selected.'Test 1')

Test 2 is main entity and Test 1 is lookup available in Test 2.

If it answers your question, kindly give kudo and accept it as solution.

Regards,

Prakash

alexy1111 · ‎08-31-2021

Hi @Prakash4691

Nothing works. Do not understand why MICROSOFT made it so complicated 😅 Suddenly the LOW CODE starts to cost more than "only code"

Anyway now there is a new error:

Please can anyone help?

Prakash4691 · ‎08-31-2021

@alexy1111 ,

It works perfectly fine for me.

Could you please post the formula?

Regards,

Prakash

alexy1111 · ‎08-31-2021

HI @Prakash4691

I added the formula in the comment below

Unfortunately it is in a foreign language

Prakash4691 · ‎08-31-2021

@alexy1111 ,

In error part, are you getting that field in intellisense?

Hover over the error if you see, Name is not valid. The identifier is not recognized. Then you are referring wrong field. Attached screenshot for your reference.

Refer correct field, the error goes off.

Regards,

Prakash