How to enable filtering on advanced lookup

(0) Share

Report

Posted on by MartonVilmanyi

How can I enable the filtering on a lookup view?

I have 2 related tables, where I need to assign transport vehicles to orders that match specific criterias.

The user needs to be able to find a "white" "bus" from "a given partner" that has "at least x seats" and add to the "vehicle" column in the offers table.

I added a lookup column to the vehicles table and added the lookup to the form. When I chose "advanced lookup" I only see "sort", no filter, at any column.

The search bar doesn't give any result other than the primary colum and even there only if the column starts with the input text. I can find bus with license place ABC-123 with the text "abc", but not when I type "123".

The filter works fine in the vehicles table alone. What do I need to do be able to filter the lookup view? If not possible, what is the best practice for this use case?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Kristian_Cole 195 on at

Like (0)

Report
Good morning, you will need to develop a custom filter on the lookup:

addCustomFilter (Client API reference) in model-driven apps - Power Apps | Microsoft Learn

for example:

<filter type="and"> <condition attribute="colour" operator="eq" value="White" /> <condition attribute="vehicleType" operator="eq" value="Bus" /> <condition attribute="typer" operator="eq" value="A Given Partner" /> <condition attribute="seatAmount" operator="eq" value="3" /> </filter>

Was this reply helpful? Yes No
MartonVilmanyi 34 on at

Like (1)

Report

Hi,
Maybe I dont't understand correctly, but this looks like it adds a static filter. I would like to achieve the same filtering functionality that exists in the table views, in the advanced lookup view.
thanks
vm

Was this reply helpful? Yes No
Kristian_Cole 195 on at

Like (1)

Report

Right I see, in your solution under the views section there is a view which has a suffix of 'lookup', this view is the lookup drop down items that you see on searching for a record when setting a lookup.

Example above, you can set the view to what your query requires but it cant be dynamic unless you code it.

Was this reply helpful? Yes No
MartonVilmanyi 34 on at

Like (0)

Report

I didn't think that this is such a complex task.
Can I do it on the way around?
Place the "vehicle" as table grid on the "jobs" form, select a vehicle record and with a flow(?) add it to the current "job" record?

Was this reply helpful? Yes No
Kristian_Cole 195 on at

Like (0)

Report

Using flow is an option but the lookup view is probably less leg work for you and doesn't involve adding sub grids/creating a flow. It is more maintenance for you down the line.

Was this reply helpful? Yes No
MartonVilmanyi 34 on at

Like (0)

Report

Is there maybe some tutorial for this and can I make it global? Like add the filter option to all columns in all lookup views? I found tons of material for pre-filtering lookup views, but not for this.

Was this reply helpful? Yes No