cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DavidGarcia1
Level: Powered On

Re: Not works the filter function

@RandyHayes 

 

I'm trying to make a normal search bar, when I type something, filter the results, and when I don't have anything written, all the orders will appear.

 

I don't know if it has something to do that is grouped or has a sub gallery

Super User
Super User

Re: Not works the filter function

@DavidGarcia1 

So, that is much different than what I understood from your messages.

In this case, set your formula to the following:

GroupBy(
    Search(OrdenesAbiertas, TextSearchBox1.Text, "ORDEN_x0020_VENTA"),
    "ORDEN_x0020_VENTA",
    "Ordendeventa"
)

This will provide what you just described.

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
DavidGarcia1
Level: Powered On

Re: Not works the filter function

@RandyHayes 

 

Apparently it works with other fields in the list such as "ESTATUS" but does not work with ORDER_x0020_VENTA, which means that the search is done in the sub gallery and not the main gallery that is where the order number is hosted

 

Every time I get closer to the solution

 

SUB.PNGorder.PNG

 

 

Super User
Super User

Re: Not works the filter function

@DavidGarcia1 

Actually, now seeing a screenshot with the ORDEN_x0020_VENTA...is that defined as a numeric column or a text column?

There is no particular "hosting" of values in main or sub galleries. It is all based on the formula and your grouping.  In this case, when using the "ESTATUS" column, you're just filtering/searching on that column in the main list OrdenesAbiertas and then grouping.  You need ORDER_x0020_VENTA to filter/search and then group.  (Remember, your Search is inside the GroupBy, so the main/sub galleries play no part).

 

So...what kind of column is ORDEN_x0020_VENTA?

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
DavidGarcia1
Level: Powered On

Re: Not works the filter function

Yes is a numeric column in a sharepoint list
NUMBER.PNG

Super User
Super User

Re: Not works the filter function

@DavidGarcia1 

Now we're getting there...

Change the formula to this:

GroupBy(
    Search(
          AddColumns(OrdenesAbiertas,
                  "txtOrden", Text(ORDEN_x0020_VENTA)
                  ), 
         TextSearchBox1.Text, "txtOrden"),
    "ORDEN_x0020_VENTA",
    "Ordendeventa"
)

We need to convert the numeric to text as the Search function only works on text columns.  The AddColumns function above gives us a valid text column to search.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

Highlighted
DavidGarcia1
Level: Powered On

Re: Not works the filter function

Yeeees, its works!!! thankyou so much Smiley Happy

 

 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 358 members 5,326 guests
Please welcome our newest community members: