Collection for number values incl. "All" option for drop-down
I would like to know how to create a collection for a drop-down against a number value column that contains an “All” option.
Location ID - Choice
Unit number - number
Previously, the unit number column in the SPO list was a single line text field. However, we encountered issues of users entering data incorrectly and also were not able to sort the values, so changed the column to a number value. The below code was allowing an “All” option to be selectable when the column was a single line text field.
'Location ID Combobox'.Selected.Result="All" && 'Unit number Combobox'.Selected.Result="All",
'Location ID Combobox'.Selected.Result="All",
Filter(ListName,'Unit number'='Unit number Combobox'.Selected.Result),
'Unit number Combobox'.Selected.Result="All",
Filter(ListName,Location.Value='Location ID Combobox'.Selected.Result),
Filter(ListName,'Unit number'='Unit number Combobox'.Selected.Result && 'Location ID Combobox'.Selected.Result)