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]

Hi @Mike_Gzz 

The spelling of datepicker is wrong in your formula.  Put a button on the screen and set its OnSelect property to 

Collect(
    colasc;
    Sort(
        Pedidos;
        ID;
        Ascending
    )
);;
Collect(
    coldsc;
    Sort(
        Pedidos;
        ID;
        Descending
    )
);;
Collect(
    colPedidos;
    colasc;
    Filter(
        coldsc;
        Not(ID in colasc.ID)
    )
)

The formula first collects 2000 rows from Perdido sorted Ascending, then collects 2000 rows sorted descending, then creates a third collection that combines the two but eliminates duplicates. 

This will create a collection of all of your rows called colPedidos that you can use in your formula in place of your SharePoint list and it won't cause a delegation problem. 

[Mike_Gzz]

@Drrickryp 

WOW looks great!

I did it exactly you said:

The error is: An operation was expected. We expect an operator, such as +, *, or &, at this point in the formula.

[Drrickryp]

due to the language difference, I didn't have the ;; originally separating the functions.  I redid it.  Once you obtain the collection, you can use the full range of PowerApps functions on it without delegation issues.  Next we can filter it down to just the items you want to see using your controls. 

[Mike_Gzz]

okok
I replaced all the semicolons, same mistake

[Drrickryp]

not all of them, just the ones separating the collections. Please forgive me, I am not used to your syntax. I normally program in English.

[Mike_Gzz]

That has been a big problem for me, but I don't know how to change to English.

Excuse me, I'm not a programmer, I'm actually HR.
I already changed all the ";" by "," and I got no response.
Again leave the ";" and same result.
Finally I see that you place double ";;" I also did it but it marks the same error

i feel lost and ashamed

[Drrickryp]

I see my error, I am missing a ; after Pedidos in the first two collections. Lets take it step by step until we get it right.  does

Collect(colasc;Sort(Pedidos;ID;Ascending))

 work without an error?  If so, we will chain in the next one

Collect(colasc;Sort(Pedidos;ID;Ascending));;Collect(coldesc;Sort(Pedidos;ID;Descending))

and finally I hope it got this right

Collect(colasc;Sort(Pedidos;ID;Ascending));;
Collect(coldsc;Sort(Pedidos;ID;Descending));;
Collect(colPedidos;colasc;Filter(coldsc;Not(ID in colasc.ID)))

Please don't be angry with me.

[Mike_Gzz]

@Drrickryp 

Master! ! ! ! ! ! ! ! ! ! ! ! ! 

Yes! It worked!
all three collections were created.

What, how can i angry with you. 

you deserve the nobel prize for perseverance

[Drrickryp]

Good Morning @Mike_Gzz 

Ok then!  Lets put that formula to work in your data table but first there are some questions I have that must be answered.  Before answering the questions, put the Items property of the data table as colPedidos.  Then note the names of the columns because these will be necessary in designing the query.  Consider that after filtering the data table, will you want to sort it?  Which fields are involved in the sort and in which direction are they sorted (Ascending vs. Descending)? There can be one or more for sorting.
Your three controls are a button for a Yes/No field, a datepicker for the "Fecha" field and a Textbox control for the "Title" field. We will need the exact column name for the Yes/No field.  The next question is how to design the filtering query for colPedidos.  When using multiple controls, the question is whether you want an And vs Or between the fields that are being queried. In your case, I suspect that you want it to be "And" and to have each field limit the items in the data table.  Is that correct?

[Mike_Gzz]

@Drrickryp  Good afternoon, continuing with this mission haha.

I already placed colPedidos in items and it worked correctly. (Doubt, whenever starts the app, should click on this button?).

The names of the columns are:

Surtidor_Columna1 (Choice Column)

FindeSurtido_Columna1 (Date and time)

IniciodeSurtido_Columna1 (Date and time)

Empresa_Columna1 (Choice column)

PedidoRealizado_Columna1 (Yes/no column)

RutaChofer_Columna1 (Choice column)

EvaluacionSurtidor_Columna1 (Number column)

Factura_Columna1 (Single line of text)

Importe_Columna1 (currency column)

Restriccion_Columna1 (single line of text)

Municipio_Columna1 (single line of text)

Fecha_Columna1 (date and time)

Vendedor_Columna1 (choice column)

PedidoDiario_Columna1 (Number)

PedidoConsecutivo_Columna1 (Title)

The sort would be mainly by date (today), then by PedidoDiario from less to more.

The name of the yes / no column is PedidoRealizado.

By last, I also think that I'm looking for "and"