Power Platform Community Forum Thread Details

Im having what I never thought would be an issue. My Gallery sorts on several search criteria which are input through variables. They are set with the blocks in the image.

The OnSelect of the Region is
Set(
varS4Region, Concat(
RegionSearch.SelectedItems, Value, ", ")
)

The gallery sort is (sorry, here it comes. there might be a way to make it more efficient but this is what I know how to do)
SortByColumns(
If(
//Look at "Redlist" of outdated items that havent been updated in 700+ days
varredlist = true,
Filter(
colContacts,
//Look for the date plus all subsearch items.
And(
(DateDiff(
DateValue('Last Contact'),
Today()
) >= 700),
//Check if a subsearch item has a Match, if its Blank, move on to next subsearch item
Or(varS1Company in Company || varS1Company = Blank()),
Or(varS3City exactin Address || varS3City = Blank()),
//Turn multichoice variable into string to look in text column for comparisons, turn text column into split characters
Or(
varS4Region in Concat(
Region2, Value,
", "
) || IsBlank(varS4Region)
),
//Compare individual items in multichoice with individual items in multichoice (repeated for each multichoice variable)
Or(
Concat(
varS5County,
Value,
", "
) in Concat(
'Employer County',
Value,
","
) || IsBlank(varS5County)
),
Or(
Concat(
varS6Education,
Value,
", "
) in Concat(
'Education Required',
Value,
", "
) || IsBlank(varS6Education)
),
Or(
Concat(
varS7Offense,
Value,
", "
) in Concat(
'Offense Requirements ',
Value,
", "
) || IsBlank(varS7Offense)
),
Or(
Concat(
varS8Business,
Value,
", "
) in Concat(
Option,
Value,
", "
) || IsBlank(varS8Business)
),
Or(
Concat(
varS9Career,
Value,
", "
) in Concat(
'Career Cluster',
Value,
", "
) || IsBlank(varS9Career)
)
)
),
//Look at "Greenlist" of for items that have been created within the last 30 days
vargreenlist = true,
Filter(
colContacts,
And(
DateDiff(
DateValue(Created),
Today()
) <= 30
),
Or(varS1Company in Company || varS1Company = Blank()),
Or(varS3City exactin Address || varS3City = Blank()),
Or(
varS4Region in Concat(
Region2, Value,
", "
) || IsBlank(varS4Region)
),
Or(
Concat(
varS5County,
Value,
", "
) in Concat(
'Employer County',
Value,
", "
) || IsBlank(varS5County)
),
Or(
Concat(
varS6Education,
Value,
", "
) in Concat(
'Education Required',
Value,
", "
) || IsBlank(varS6Education)
),
Or(
Concat(
varS7Offense,
Value,
", "
) in Concat(
'Offense Requirements ',
Value,
", "
) || IsBlank(varS7Offense)
),
Or(
Concat(
varS8Business,
Value,
", "
) in Concat(
Option,
Value,
", "
) || IsBlank(varS8Business)
),
Or(
Concat(
varS9Career,
Value,
", "
) in Concat(
'Career Cluster',
Value,
", "
) || IsBlank(varS9Career)
)
),
Filter(
colContacts,
And(
Or(varS1Company in Company || varS1Company = Blank()),
Or(varS3City exactin Address || varS3City = Blank()),
Or(
varS4Region in Concat(
Region2, Value,
", "
) || IsBlank(varS4Region)
),
Or(
Concat(
varS5County,
Value,
", "
) in Concat(
'Employer County',
Value,
", "
) || IsBlank(varS5County)
),
Or(
Concat(
varS6Education,
Value,
", "
) in Concat(
'Education Required',
Value,
", "
) || IsBlank(varS6Education)
),
Or(
Concat(
varS7Offense,
Value,
", "
) in Concat(
'Offense Requirements ',
Value,
", "
) || IsBlank(varS7Offense)
),
Or(
Concat(
varS8Business,
Value,
", "
) in Concat(
Option,
Value,
", "
) || IsBlank(varS8Business)
),
Or(
Concat(
varS9Career,
Value,
", "
) in Concat(
'Career Cluster',
Value,
", "
) || IsBlank(varS9Career)
)
)
)
),
"Company",
SortOrder.Ascending
)

Every search is working, except the search for Region 1. Region 10 works, but when searching Region 1, you still only get region 10 results. There is for sure qualifying data.
The things I've tried so far are:
-Making RegionSearch a single choice only
-Update the input for region 1 to 01
-Trim and TrimEnds on both the variable and the column

probably several other things I cant remember. no matter what, region 1 or 01 never shows up properly.
heres just one screenshot of proof that there are qualifying items