Okay, been trying a few different solutions I've found on the boards but nothing seems to work. My app is pulling data from an Azure SQL database with a "date" data type. I have entered data using a DatePicker in PowerApps. I am trying to do a simple filter of said data based on a date chosen from a DatePicker. Essentially it is the same DatePicker used to enter the data I want to use to retrieve stored data. I have the Date time zone of the DatePicker set to Local.
When I use a simple label with the code DatePicker1.SelectedDate I see the correct date. When I use a filter on a Gallery for example using the formula:
Filter('[dbo].[GSP_DailyPrices]', Load_Date = DatePicker1.SelectedDate)
I get a blank gallery, no errors, no warnings. Not sure what I'm doing wrong here.
Appreciate the help.
Solved! Go to Solution.
Changing both dates to text with specifying format can solve the issue.
DataCardValue 7 --> for attendance_date--> SQL
Thank you johnsonjohn! this worked great.
Thanks - not too performant, bit it works for now
It's staggering that the product team cannot do a simple data comparison or allow casting to a date. ALL the befits of rapid development get completely wiped out by wasting hours trying to figure out junk like this
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.