cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Charliemacdmv
Helper IV
Helper IV

Error message for cascading Dropdowns with Null value

Hey all,

 

I have Cascading dropdowns. Obviously, the dependent dropdowns are blank until the previous one is selected. My app throws up this error every time I use it. The app works perfectly fine. Any way to remove this error?

Charliemacdmv_0-1637074231326.png

 

5 REPLIES 5
BCLS776
Super User
Super User

To address this error, add a way to handle the situation where the first dropdown has no selection. This can be done either through a Default property, or using an If() statement on the second dropdown to control what happens when there is no selection on the first one.

 

Hope that helps,

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
sgtsnacks
Helper I
Helper I

Hi Charliemacdmv,

 

Can you share how you're defining/populating the items of your child Drop Down menus? Are you running any error handling like IsBlankOrError()?

This is what i have for one of the cascading... 

Filter(CauseResolution,LOB= LOBdd.Selected.Result).Cause

I don't have an IsBlank or Error.

Hi @Charliemacdmv 

 

I see you have LOBdd.Selected.Result - are you using a distinct function to define the items in your drop down? - If so, your app is having to work harder to surface those items in the dropdown, which could be causing a sequencing issue.

 

If this is the case, can you try creating a collection to compile your drop down items OnVisible of that screen and bind that collection to the items property of your dropdown.

 

I'm assuming this is SharePoint and I'm sure you are aware that distinct and clearcollect are not delegable so this will only work properly in the long term if your item count does not grow beyond your delegation limit.

 

Hope this all makes sense / is relevant to your case - Good Luck!

Charliemacdmv
Helper IV
Helper IV

I will give that a try. Thank you!!

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,260)