I attach an image using the filter function and another one without using it, I need you to do the search based on the sales order (Number in red)
Solved! Go to Solution.
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.
Consider changing your formula to the following:
GroupBy( Filter(OrdenesAbiertas, ORDEN_x0020_VENTA = TextSearchBox1.Text), "ORDEN_x0020_VENTA", "Ordendeventa" )
Alternately, for searching, you can use the following as well:
GroupBy( Search(OrdenesAbiertas, TextSearchBox1.Text, ORDEN_x0020_VENTA), "ORDEN_x0020_VENTA", "Ordendeventa" )
I hope this is helpful for you.
This is the result.
The main screen has a gallery and a sub gallery, the search must be done from the main gallery which is where the order number comes from.
Yes, so that formula should work for you. Are you having any particular issues with it?
If you want to filter based on items in the subgallery, then just change the field in your filter statement.
Try this then:
GroupBy( Filter(OrdenesAbiertas, If(IsBlank(TextSearchBox1.Text), false, ORDEN_x0020_VENTA=TextSearchBox1.Text ), ), "ORDEN_x0020_VENTA", "Ordendeventa" )
Sorry...extra comma in the formula I posted...this is the corrected one:
GroupBy( Filter(OrdenesAbiertas, If(IsBlank(TextSearchBox1.Text), false, ORDEN_x0020_VENTA=TextSearchBox1.Text ) ), "ORDEN_x0020_VENTA", "Ordendeventa" )
No problem...let's get it working for you.
So, this formula you have now will:
1) Show nothing if the text input is blank
2) Show order for anything that exactly matches the ORDEN_x0020_VENTA column. Note: it must match exactly in order to see any results.
That is what I had infered from your messages that you wanted - if not, let's revisit.
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.