Filter Edit Form Lookup field.

(0) Share

Report

Posted on by tjalui

145

Hi,

I have a PowerApp, Data source is CDS.

In the App, there is an EditForm. On creation of new record i want to filter a Lookup field(combo box).

The formula I used

Sort(Filter(Products, Status in "Active"), Name)

There are more then 5000 records of Product Entity so it is showing Delegation warning.

Any guidance is appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

WarrenBelz 156,051 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @tjalui ,
Firstly, the In filter is not delegable, so will not work on your data set size.
If however you are looking for a matching record string, you can use
Sort( Filter( Products, StartsWith(Status, "Active") ), Name )
Please let me know if you require further explanation on this.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
tjalui 145 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

As you suggested, I used the formula but I am still getting an error.
Below is the Screenshot of the error.

Please do guide me regarding the same as it is an urgent requirement.

Was this reply helpful? Yes No
WarrenBelz 156,051 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @tjalui ,
The syntax is correct - what type of field is Status and where are you getting the value from?
Can you also give me the complete code of the Filter.

Was this reply helpful? Yes No
Verified answer

GarethPrisk 2,828 on at

Like
a
(1)

Report
Copy link

Link copied!
Since this is CDS, you have a few options.
If this is a custom Product entity
Option 1: Create a filtered View, or use Default Active View
Filter([@Products],'Products (Views)'.'Active Products')
Set Items for that Combo Box equal to above
(Assuming entity name, and default view name is same)
Option 2: Filter using the Status (statecode) value
Filter([@Products],Status = 'Status (Products)'.Active)
Set Items for that Combo Box equal to above
(Assuming entity name, and status field/values are default)
If this is the OOB Product entity (assumes D365CE)
Same as above, but you'll have OOB Active Views and additional statecode values to consider

Additionally, given the amount of records, I would set the IsSearchable property of the Combo Box to true, and set appropriate search columns.

Was this reply helpful? Yes No
tjalui 145 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @GarethPrisk

This works perferctly fine.

Was this reply helpful? Yes No