cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MiteshGovan
Helper V
Helper V

Combo box cascading not showing items

Hi

 

I trust that you are well. I am currently experiencing an issue where I am using a cascading dropdown with a combo box but the list is blank. The first part with the dropdown works. But the combo box doesn't appear from what is selected from the dropdown. 

 

Sort(Distinct('Stationery Master',Title),Result)

MiteshGovan_1-1620308703955.png

 

The below formula works on a dropdown and list box but it doesn't work on combo box. I want the combo box so that I can select multiple items.

 

Filter('Stationery Master',Title=Dropdown4.Selected.Result).ID

MiteshGovan_0-1620308619293.png

 

Could you please assist me?

 

Kind Regards,

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi @MiteshGovan

Based on the issue that you mentioned, do you want to filter the Combo Box based on the Dropdown selected?

Could you please share a bit more about the scenario?

Actually, you only need to do a fine-tuning with your formula.

ForAll(Filter('Stationery Master',Title=Dropdown4.Selected.Result).ID,ID)

Please check if it could solve your problem.

Regards,

Qi

View solution in original post

5 REPLIES 5
eka24
Super User III
Super User III

Hi @MiteshGovan 

Remove the ID:

Filter('Stationery Master',Title=Dropdown4.Selected.Result)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Hi 

 

I need the ID thought for that specific column. I have tried the below but it isn't working.

 

MiteshGovan_0-1620309546925.png

 

If you need the ID, Change the the first code on the dropdown to:

Sort(Distinct('Stationery Master',ID),Result)

Then the combobox would be:

Filter('Stationery Master',ID=Dropdown4.Selected.Result)

 

However if you want to be able to select the Title in the Dropdown, then replace the Dropdown with another Combobox

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Hi 

 

I would like to see title column thereafter i would like to see the ID column

 

v-qiaqi-msft
Community Support
Community Support

Hi @MiteshGovan

Based on the issue that you mentioned, do you want to filter the Combo Box based on the Dropdown selected?

Could you please share a bit more about the scenario?

Actually, you only need to do a fine-tuning with your formula.

ForAll(Filter('Stationery Master',Title=Dropdown4.Selected.Result).ID,ID)

Please check if it could solve your problem.

Regards,

Qi

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (14,049)