Showing results for 
Search instead for 
Did you mean: 
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?



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,


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.
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!

Helper IV
Helper IV

I will give that a try. Thank you!!

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

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