cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

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

40 REPLIES 40

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

@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). 
10.png

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

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)

11.png

 

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. 

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.

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.

@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

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

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (9,358)