Stuck on cascading dropdown which is fetching data from collection

(1) Share

Report

Posted on by DineshK_

201

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

All responses (5)

Answers (0)

DineshK_ 201 on at

Like (1)

Report

Re: Stuck on cascading dropdown which is fetching data from collection

@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'
)
)
WarrenBelz 146,660 Most Valuable Professional on at

Like (1)

Report

Re: Stuck on cascading dropdown which is fetching data from collection

@DineshK_ ,

If it is a Choice column, you need offerType.Value
DineshK_ 201 on at

Like (1)

Report

Re: Stuck on cascading dropdown which is fetching data from collection

@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 ?
WarrenBelz 146,660 Most Valuable Professional on at

Like (1)

Report
Re: Stuck on cascading dropdown which is fetching data from collection

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
mmbr1606 12,112 Super User 2025 Season 1 on at

Like (2)

Report

Re: Stuck on cascading dropdown which is fetching data from collection

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