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

PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (2,921)