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

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,069)