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


Accepted Solutions

The best way to achieve your goal is to build the formula piece by piece.  Start with the Items property 

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

Filter(colPedidos;PedidoRealizado=Radio3.Selected.Result)  // you probably need to change the name of Radio3 to the Radio# of your control.  

If that works, then add the datepicker part

Filter(colPedidos;PedidoRealizado=Radio3.Selected.Result && Text(Fecha; ShortDate)=Text(Datepicker1.SelectedDate; ShortDate))

Then add the Search(

Search(Filter(colPedidos;PedidoRealizado=Radio3.Selected.Result && Text(Fecha, ShortDate)=Text(Datepicker1.SelectedDate; ShortDate)), Textinput1.Text; "vendedor")

And if that works, then add the Sort(

Sort(Search(Filter(colPedidos;PedidoRealizado=Radio3.Selected.Result && Text(Fecha, ShortDate)=Text(Datepicker1.SelectedDate; ShortDate)), Textinput1.Text; "vendedor");PedidoDiario;Descending)

If you want to eat an elephant, you cannot do it all at once, you must eat it piece by piece.


*Also, you may want to use a Gallery control with the items aligned side to side like in the datatable instead of using the datatable control. Sometimes it is easier to work with a Gallery than a datatable.  

View solution in original post


I think we are very close now.  First, lets fix the Radio control.  You must have one of the "false" entries in your list that probably has a space after it so it is being read as a different value.  Check the data in the list for that if you can find it and fix it.  Then, set the Default property of the radio control as "true".   

Then, just for a test, set the formula regarding the DatePicker as <= rather than = to see if all the data fills the data table. 

Finally, make sure the Text property of the TextInput control is "".  Make the Hint property of that control "Find Order".  

Hopefully then, your table will fill with data. Let me know if you still have a problem. 

Putting me on.gif


View solution in original post

Super User
Super User

Hi @Anonymous 

You could try a datatable control instead of a gallery and filter the Items property for Today()

Not applicable

hi @Drrickryp 
Yes, It's the solution I am looking for.

But I don't know how to filter them by Today.

Could you advise me ?



Sure, Filter(yourdatasource, 'Initio De Sortido' = Today()) . FYI its a good idea to name columns in a database table or SharePoint list without spaces; it's called camel case,  so initioDeSortido would be a camel case for that column  'Initio De Sortido' 


Not applicable


Thanks, I already changed in my database using the camel case style.

I apply the formula that you share, however it makes an error.

The expression "iniciodeSurtido" is not valid. Creating query failed.


As a doubt, I would like to filter it by date "Fecha". btw, makes the same error.



Not applicable

I already created the data table, next to it I have an editing gallery.
Above I have 3 options that I would like to use.
  1. The button, when you click on it, brings all the "no" from the yes / no column.
  2. Date picker that filters the data table by the selected day.
  3. Order finder.

Could you support me that these filters work pls. 





Test this instead: Filter(Pedidos; Text(Fecha;ShortDate)=Text(Today();ShortDate))

Not applicable



It seems to work because it does not mark me error, however it does not show any information and the warning by delegation appears.

Actually i have 2,255 rows...



I think we are getting closer.  try Filter(Perdidos; Text(Fecha; ShortDate) = Text(Datepicker1.SelectedDate; ShortDate)

If this works, the next step will be to create a collection and set up the Search based on the controls above your datatable.

Not applicable


Yes, i think we're close. 
The warning, again is for delegation.


Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

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 (2,026)