There are probably many ways you can do this, but in line with what you are suggesting, you can do the following; on your screen's OnVisible Event property, create a collection with the values you want to have:
ClearCollect(myCollectionXYZ,
Table(
{FilterValue: true, Display: "No Error", Order: 1},
{FilterValue: true, Display: Blank(), Order: 0},
{FilterValue: false, Display: Blank(), Order: 0}
)
)This will create a collection table that looks like this:
FilterValue | Display | CustomSortOrder
true | No Error | 1
true | Blank() | 0
false | Blank() | 0
In the (presumed) combobox DataCardValue26, change its "Item" property to:
SortByColumn(
Filter(myCollectionXYZ, FilterValue=DataCardValue3.Value),
CustomSortOrder, Ascecnding
)
Be sure that in DataCardValue26's Advanced Properties tab, you change the DisplayFields to ["Display"] to reflect the column name in the collection. And then you have to update DataCard26's Update property. The value in this property will get plugged into its assigned SharePoint column-cell. So if you want the selected item from DataCardValue26, you will have to update the Update property to (without quotes) "DataCardValue26.Selected.Display". So now, whatever is selected, the Display column of the myCollectionXYZ collection will be submitted.
The names I have chosen are for example-sake; you can change the column names to however you'd like.
