Create filters with Text fields from SharePoint

[joshieboy]

Hello,

I created several filters on a data table which pulls values from a Google sheet into a SharePoint list.  The filters worked really well as the supporting fields in SharePoint were set to dropdown.  However, the flow which I used gave errors and I had to change the dropdown fields in SharePoint back to text fields for the flow to run.  Below is my formula on the Items property of the data table for when they were dropdowns but I am not sure how to change the formula to correlate with the text fields now and still get the filtered results.  Any assistance appreciated.

SortByColumns(Search(Filter(Registrants,IsBlank(Operator_Combo_1.Selected) || Operator_Combo_1.Selected.Value ="All"

|| 'Operator working for'.Value=Operator_Combo_1.Selected.Value, IsBlank(Plea_Passport_Combo_1.Selected) || 'PLEA Passport'.Value = Plea_Passport_Combo_1.Selected.Value, IsBlank(Criminal_Record_Combo_1.Selected) || 'Criminal Records'.Value = Criminal_Record_Combo_1.Selected.Value),Search_Registrants.Text,"FirstName", "LastName"),"Created",Descending)

[BCBuizer]

Hi @joshieboy ,

Perhaps it is an option for you to use the Distinct function to populate the three comboboxes (Operator_Combo_1, Plea_Passport_Combo_1, Criminal_Record_Combo_1) and not having to change your filter? 

[joshieboy]

Hello @BCBuizer - thank you for the feedback.  Can you guide me as to how that will look in the formula?  I am not clear as to how to include it above.  Thanks.