Improve user experience

[Mike_Gzz]

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 Mode

Edit Mode

[Drrickryp]

@Mike_Gzz 

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. 

[Mike_Gzz]

@Drrickryp 

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). 

[Drrickryp]

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.

[Mike_Gzz]

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)

[Drrickryp]

Good Morning @Mike_Gzz 

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. 

[Mike_Gzz]

Oh yes, i just watch it from here. Thats now is ok. 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-radio

[Drrickryp]

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.

[Mike_Gzz]

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.

[Drrickryp]

@Mike_Gzz 

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

[Mike_Gzz]

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