Unanswered

Validate ComboBox Text

(1) Share

Report

Posted on by KevinBod

Hello,
In my application, I have a combo box that is bound to a SharePoint list. It is required that the user either select one of the records from the list or enter another value manually.

The problem I am having is in the validation of this comb box. If the user selects a record, I can test the Selected property for IsBlank, however, if they enter another value manually, the Selected property remains blank, so validation fails. I do not see any property of the combo box that lets me test the actual text for validation.

Does any know how to access the actual text value of a combo box so I can validate against it?

Thank you for looking
Kevin

Categories:

General Questions

I have the same question (0)

All responses (2)

Answers (0)

Anchov 1,984 on at

Like (1)

Report

Validate ComboBox Text

When you enter text into a ComboBox, the input is retrievable through the SearchText property. To validate the input, you can check whether the Selected item is blank or if the SearchText is not empty.
However, please note that this behavior seems to apply only to classic ComboBoxes. Unfortunately, the newer ComboBox does not appear to retain the SearchText value once you click away from the field.

Example (populates text box with data validation):

If(IsBlank(ComboBox1.Selected) && IsBlank(ComboBox1.SearchText), "Error! No Items select or entered", $"Selected: {Coalesce(ComboBox1.SearchText,ComboBox1.Selected.Value)}")

Example Update Property (to update sharepoint):
Coalesce({Value: ComboBox1.SearchText},ComboBox1.Selected.Value)

Was this reply helpful? Yes No
KevinBod 37 on at

Like (0)

Report

Validate ComboBox Text

Thank you Anchov. The SearchText is what I was looking for.

Although adding the typed value to the data set would not be appropriate for this application, I appreciate you sharing the information.

Kevin

Was this reply helpful? Yes No