Showing results for 
Search instead for 
Did you mean: 
Not applicable

Improve user experience

Hi, I have an application that is used by various areas. Mainly sales and warehouse.

I have a sharepoint list that is used for ordering. Sellers create a new order and this must be filled in the warehouse and marked as finished (as well as the start and end time it was made).

We currently use a shared Excel in Teams and we can all see and edit it. But I need it in SharePoint to connect to powerBI and to standardize the information.

I want to make the display of orders simple for the warehouse, perhaps that only the orders of the day will be shown and that they have not been made.

Or something more dynamic than what I currently have (A gallery):

View ModeView Mode


Edit ModeEdit Mode



Ok, copy the formula in the OnSelect of the button and put it in the OnVisible property of the screen.  Then you won't need the button.  Please post a screenshot of the data table that shows the columns you want to filter.  You may need to reorder them so they are all visible.   Also change Collect() to ClearCollect() in the formula.  This will make sure that your data is always the most current when the screen is displayed. 

Not applicable


Yes, you're right.

I don't need the button anymore.


I share the screen that you request. In the first column I have the date (Fecha), then the order per day (PedidoDiario) and then the consecutive order (Title). 

Perfect, then we can create your formula.  I will try to get you started by looking at the screenshot for an app that I set up to match yours. I used a radio control instead of a button for the status.  PowerApps formulas are executed from the inside out.  So the first formula Filters the collection by Order Status and Shipped date.  Then it searches the results by the shipname and finally, it sorts the list by the Order Number in Descending order.  I have something to do for a couple of hours but I'll get back to you if you run into problems with your app.Annotation 2020-05-28 132921.jpg

Not applicable

Hi @Drrickryp 

The formula already located it in the items of the table with a couple of changes in the syntax and changing the origins.

But I get error of Invalid argument type DataTable1.Items
The Ratio connects it to the Yes / no column, but it brings me multiple values. Basically it should only be true and false, but it brings me each one and not the count.


The actual formula is:

Sort(Search(Filter(colPedidos;PedidoRealizado=Radio3.Selected.Result && Fecha<=DatePicker1.SelectedDate);TextInput1.Text;"nwind_shipname");PedidoDiario;Descending)



Good Morning @Anonymous 

For the Radio control use Distinct(colPedidos;PedidoRealizado) as the items property.  This will produce a single column table with only unique values for PedidoRealizado.  The name of the column will be "Result".  Then you will use that in the  formula for your datatable. 

Not applicable

Also, you will need to replace "nwind_shipname" in your formula with the name of the column that you are using to search.  That was the column for the customer in my database.

Not applicable

The ratio already works.

Now in the formula I get the error that the name is not valid.

My Doubt is: in your formula you use DatePicker1.SelectedDate.
If I change the DatePicker1. By "Fecha" which is my date column, there it does not mark me error but it tells me that the .SelectedDate is not valid.


You may need to format your date column to match the datepicker's format.  Try Text(Fecha,ShortDate)=Text(DatePicker1.SelectedDate,ShortDate) in the formula

Not applicable

Before = is fine. The following tells me that the Text function has invalid arguments, that the name is not valid and the identifier is not recognized



Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

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