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):
Solved! Go to Solution.
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.
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.
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'
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.
Could you support me that these filters work pls.
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.
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.