Answered

Prefiltered lookup drop down box

(0) Share

Report

Posted on by ShwetaBuddhadev

Hey there,

I got stuck at a point where I have to preload one lookup drop down box as per its previous respective another lookup drop down box.

As per my situation, I'm using normal entity common data service structure, where I need to have Product name filtered as per its specific Brand name.

I've two lookup drop downs in my EditForm name 1. Brand

2. Product

I first have to choose Brand and than as per its selection I want my Product lookup drop down to be flooded with only those products , which belongs to that entered specific brand.

Please suggest me some verified solution .

Thanks.

Categories:

Solution Explorer

Capture.PNG

All responses (2)

Answers (1)

v-micsh-msft on at

Like (0)

Report

Re: Prefiltered lookup drop down box

Hi @ShwetaBuddhadev,

Do you need any further help on this issue?

Regards,

Michael
Verified answer

v-micsh-msft on at

Like (0)

Report
Re: Prefiltered lookup drop down box

Hi @ShwetaBuddhadev,

Assuming the Product has it own entity named as Product,

And the Lookup Field within the Current entity is named as ProductA, then the formula under the Combo Box of the Product items property should be:

Filter(Choices(Current.ProductA), value in filter(Product, BrandField=BrandControl.Selected.Value).Product)

If the formula above is hard to understand, then please provide some more details about the entity relationship, I will then modify the formula to match the name.

Regards,

Michael