cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joshieboy
Helper V
Helper V

Create filters with Text fields from SharePoint

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)

2 REPLIES 2
BCBuizer
Super User
Super User

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? 

 

 



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.
joshieboy
Helper V
Helper V

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.  

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,394)