Stuck on cascading dropdown which is fetching data from collection

(1) Share

Report

Posted on by DineshK_

207

Hi Experts,

I am working on a scenario like 3 dropdowns in landing page which should interact each other based on the data in sharepoint list.

Earlier it was 2 dropdown (text type columns) and it was working fine , now i am adding another dropdown Offer type which is choices type column. So I am Stuck on this dropdown task which is fetching data from collection.

Data Source : SharePoint List

Collection :

ClearCollect

(

offertype,

{Value:"All"}

);

Collect(

offertype,

Sort(Distinct(Choices('Delivery Updates'.'Offer Type'),Value),Value,SortOrder.Ascending)

);

Dropdown :

If(

Dropdown1_1.SelectedText.Value = "All" Or IsBlank(Dropdown1_1.SelectedText),

offertype,

Filter(

offertype,

Value in (Filter('Delivery Updates','Portfolio Head'=Dropdown1_1.SelectedText.Value

)

.'Offer Type') Or Value = "All"

)

Issue :

Offer Type column is a choice type column , so i am suspecting this logic in the formula.

Please help to achieve this.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

hey @DineshK_

this video:

How to create Cascading (Dependent) Dropdowns in Power Apps (youtube.com)

helped me a lot when i began with cascading drop downs.

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
WarrenBelz 155,415 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @DineshK_ ,

Firstly you can make the collection a bit more efficient

ClearCollect( offertype, ["All"], Sort( Distinct( Choices('Delivery Updates'.'Offer Type'), Value ), Value, SortOrder.Ascending ) );

but the main issue here is the name of the field in offertype that you are trying to filter with (replace YourFieldName below)

With( { _Data: Filter( 'Delivery Updates', 'Portfolio Head' = Dropdown1_1.SelectedText.Value ) }, Filter( offertype, Dropdown1_1.Selected.Value = "All" || Len(Dropdown1_1.Selected.Value) = 0 || YourFieldName in _Data.'Offer Type' ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
DineshK_ 207 on at

Like (1)

Report
Copy link

Link copied!

@WarrenBelz Thanks for your solution 🙂
I can see the below error still on the dropdown fx .

Collection :
I think it may be related to choice type column in Offer Type ?

Was this reply helpful? Yes No
WarrenBelz 155,415 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@DineshK_ ,

If it is a Choice column, you need offerType.Value

Was this reply helpful? Yes No
DineshK_ 207 on at

Like (1)

Report
Copy link

Link copied!

@WarrenBelz In which line pls ?

With(
{
_Data:
Filter(
'Delivery Updates',
'Portfolio Head' = Dropdown1_1.SelectedText.Value
)
},
Filter(
offertype,
Dropdown1_1.Selected.Value = "All" ||
Len(Dropdown1_1.Selected.Value) = 0 ||
offertype in _Data.'Offer Type'
)
)

Was this reply helpful? Yes No