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:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ShwetaBuddhadev,

Do you need any further help on this issue?

Regards,

Michael

Was this reply helpful? Yes No