I need to populate a table with multiple columns based off the chosen start/end date and a list.
This is what I've tried, does not work.
Text(Date_2,"mm/dd/yyyy") >= Text(DatePickerFrom.SelectedDate,"mm/dd/yyyy"),
Text(Date_2,"mm/dd/yyyy") <= Text(DatePickerTo.SelectedDate,"mm/dd/yyyy"),
PowerApps is not very friendly with dates. Greater than/less than operators do not work on them. Does your data come from a SQL database?
If so, a good bet is to convert your dates into unixtime, as it is something PowerApps understands.
I had to create a view on my database where I did a bit of massaging on dates so they came out as unixtime, So I could Sort and Filter correctly in PowerApps.
If that's what you need, I can share the SQL trickery I did.
This would be the SQL fragment you should use inside a View to display a SQL date or datetime column as a unixtimestamp.
This returns an integer, which is the unixtimestamp equivalent of the date or datetime. So In PowerApps, you can use greater than/less than operators, which do not work in dates currently.
DATEDIFF_BIG(s, '1970/01/01 00:00:00', dbo.table.some_date) * 1000 AS unixtimestamp_some_date
Populated a collection with various dates, below is a picture of the two date pickers for the range, a gallery that just shows all, and the filtered gallery. Formula I used is in red. You should be able to use this to figure out yours. Good Luck! If it works mark this as a solution thanks!
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand