Power Platform Community Forum Thread Details

I am trying to add some error handling in a form I am building but having some issues.

I have two combo boxes where one filters its available items based on the selection of the other.

Names:

combobox_worktag
combobox_purchase_order_number

An issue I am having is that if the main combo box is empty, the form spits out an error since the second combo box can't filter since there's no value.

My idea was to add a cleaner error warning than what is the default so that my end users don't freak out.

In the combobox_purchase_order_number combo box, I am trying to get this to work:

If(
    IsBlank(combobox_worktag.Selected),
    Notify("Please select a worktag.", NotificationType.Error),
    Filter(
        purchase_order_table,
        worktag = combobox_worktag.Selected.worktag
    )
)

// this alone works though:
    Filter(
        purchase_order_table,
        worktag = combobox_worktag.Selected.worktag
    )

The whole thing errors out: Expected Table value

The Notify() function shows this error: Behavior function in a non-behavior property. You can't use this property to change values elsewhere in the app.

Better yet, if the error could be suppressed and not shown, that would work as well.

Categories:

Building Power Apps

Hi christian-unr

You cannot have a Notify in the same piece of code as a Filter. One is a triggered event and the other is a data set. What you could do though is have the Items of the second Combo Box

If(
   Len(combobox_worktag.Selected.worktag) > 0, 
   Filter(
      purchase_order_table,
      worktag = combobox_worktag.Selected.worktag
   )
)

and then the InputTextPlaceholder

If(
   Len(combobox_worktag.Selected.worktag) = 0,
   "Please select a worktag"
)

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee