Dropdown value show based on another drop down

(0) Share

Report

Posted on by oyepanky

563

I created an application in this 2 dropdown value
1. Nominal bore (DropdownCanvas1_5)

2. Length (MM) (DropdownCanvas1)
As per the screenshot, I have selected nominal bore 150 - but in the 150 option length is available only 280 but here it shows all lengths 280 & 390,
But I want to show only the Nominal bore selected based value of how many lengths are available in this nominal bore

(DropdownCanvas1_5) Formula use - Distinct('Price Data Of Bellow','NominalBore')
(DropdownCanvas1) Formula use - Distinct('Price Data Of Bellow','Length(mm)')

Length (MM)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Farhanftp 79 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you describe how there two columns are related? May be in table to get a better understanding?

Was this reply helpful? Yes No
oyepanky 563 on at

Like
a
(0)

Report
Copy link

Link copied!

These my Sharepoint sheet columns
and in Powerapps I’m using distinct formulas for drop-down value show

Was this reply helpful? Yes No
Ntulikid 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Hope this will help
on items property of Length(MM) drop down

Distinct(
Filter(
'Price Data Of Bellow',
NominalBore = DropdownCanvas1_5.Selected.Value
),
Length(mm)
)

Was this reply helpful? Yes No