Good Afternoon!
I am writing below formula to make search my gallery items , currently i am using startwith() for the building, campus, unit, and floor but for the floor, since our facility has 1-15 floors, the Startswith() function for the floor is pulling 1st,10th,11th,12th,13th,14th, and 15th floor. Is there an alternative function i can use for the floor instead of Startwith()? Or perhaps delegate this exact floor for the search?
SortByColumns(
Filter([@'Physician Workstation and Technology Rounding'], StartsWith(Campus.Value, ddCampus.Selected.Value)
,StartsWith(Building.Value, ddBuildings.Selected.Result),StartsWith(Unit.Value, ddUnit.Selected.Result),StartsWith(Flr.Value, ddFlr.Selected.Result)), "Rounding_x0020_Date", If(SortDescending1, Descending, Ascending)
)
hoping to choose exactly floor 1 or floor 10 and so on for the search
