I am attempting to create a filter on a gallery. There is a PIckupDate calendar picker, Ther is a ReturnDate calendar picker, and a VehicleType dropdown. The PickupDate hits a Sharepoint List that has dates in it, and the Returndate hits the same list. VehicleType will hit another list that is in the same site. When I filter by type I can get the type of vehicle to show in the gallery by using Filter(MD2018_Vehicle_Info,Vehicle_x0020_Type = TypeDropdown.Selected.Value).
But when I try and filter the dates I get Invalid Argument Type. Expecting a number value. I think it has something to do with the way the date coulums are formated (I have them set as date time).
Does anyone know how to format dates so that PowerApps will see the date as a number value?


Report
All responses (
Answers (