Hi,
I have an application in which I am storing data into SQL Datasource, I have a gallery in which I am filtering the data between the two date pickers, it was working fine before but now it's showing me error.
I am comparing my TimeSheet Table Date column with my two Date Pickers
My TimeSheet Table of SQL:
(Collection)
Any Help? I need to filter the data between the selected dates.
@RandyHayes
Solved! Go to Solution.
The main issues has to do with the date column. Per the documentation: https://docs.microsoft.com/en-us/connectors/sql/
So create another column based on the above and use the new Date column in your formula.
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
The main issues has to do with the date column. Per the documentation: https://docs.microsoft.com/en-us/connectors/sql/
So create another column based on the above and use the new Date column in your formula.
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Hello Sir @eka24 ,
What Should be the Formula for comparing? that new date column with the date pickers?
Your formula is ok. After creating the new date column in the SQL, replace Date with the new Date column
Can you put a text copy of you formula on the platform?
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Hi, @eka24
Right now I am using this code in my Gallery Items Property.
SortByColumns(If(var1 && var2,Filter('[dbo].[TimeSheet]',UserId=MyUserEmail),
Filter('[dbo].[TimeSheet]',UserId=MyUserEmail ,(Date>=DatePicker3.SelectedDate) && (Date<=DatePicker1.SelectedDate))),Date,Ascending)
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
197 | |
71 | |
48 | |
42 | |
30 |
User | Count |
---|---|
263 | |
121 | |
92 | |
87 | |
85 |