Hi guys,
I have an app for our manufacturing areas. to input their daily metrics. There is a screen i need help with, i have a datepicker and a gallery. The gallery shows all of our 12 areas by the date picker.
This was working fine until we got to the 500 limit. At the moment i have increased this to 2000 but i would like to find a work around before we reach 2000.
I have another screen which uses dropdowns to filter between manufacturing area and month, then it has a gallery with the list of dates in that month, user can select the date and another gallery displays the metrics. The way i got around the delegation on this screen was to create a collection each time the user selected a different manufacturing area.
OnChange= ClearCollect(colAreaMonth,Filter(MetricsAllAreas,Mnfg_Area.Value=Dropdown1.SelectedText.Value)) - this works perfectly. So i wanted to do similair with this screen.
My issue with the datepicker screen is, when i try to do a similair collection it doesnt like it.
I tried this OnChange=ClearCollect(colAllDailyMetrics, Filter(MetricsAllAreas, Date=DatePicker1.SelectedDate))
but i get the error - The requested operation is invalid. Server response: The expression "Date eq 2019-10-02" is not valid.
I can get it to sort of work by using a label with the Text=Text(DatePicker1.SelectedDate, "[$-en-US]dd mmmm yyyy") and then in my gallery i have Filter(MetricsAllAreas, Date=DateLabel.Text)
But i then get a warning to say Incompatible type. We can't evaluate your formula because the values being compared in the forumla arent the same type.
The left value is a date type and the right value is a text type.
Any ideas? 🙂
