cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cholopa
Helper II
Helper II

Filter a search or search a filter not working...

Hi:

 

In the browser gallary I have an entity "filter".

 

Now I want to "search" the filter entity so I only see the data I want, but when I add text to the search filed, I "loose" the filter.

 

I have try filtering the search, and search the filter, but same result with both approches...

 

Here is an exaple of what i'm tring:

 

Filter(SortByColumns(Search('entity1';TextInput1.Text;"text_1");"field_2";Descending);field_3=TRUE)

 

Any guess?

 

 

 

 

 

2 REPLIES 2
v-monli-msft
Community Support
Community Support

Hi @cholopa,

 

I cannot reproduce your issue, I used below formula and it works for my SharePoint gallery:

Filter(SortByColumns(Search(ListList, "t","Title"),"Title",If(SortDescending1, Descending, Ascending)),Currency=3)

Please check if there is anything wrong with the columns in your entity.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Mona:

 

Thx for the support.

 

The issue was that I was tring to filter an enum field.

 

Solution came from here:

 

https://powerusers.microsoft.com/t5/General-Discussion/How-to-filter-on-enumeration-field/m-p/8667#M...

 

Best regards,

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,902)