Hello, the following code returns an error:
The SQL data line from SSMS is below:
I've tried different ways to represent the date in the formula. Not a single method works. The following thread represents the same issue from 2016 with multiple people in months following having the same issue:
Why doesn't this work?
No, this is entirely isolated to a testing screen.
Based on what I'm finding elsewhere in the community, PowerApps doesn't support the ability to use the < and > operators when using ClearCollect(Filter()) in reference datetime fields in a SQL server. The issue existed in 2016 from previous posts and there have been many comments since then up through mid 2019 that indicate the issue hasn't been addressed.
Ah, I see. I did a test on my end and I got the same result. Here's how I got around it.
Collect the table, then filter it.
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.
Unfortunately that isn't going to work. I need these instructions to be delegable. I'll be filtering through thousands of records over time.
Keep in mind your rows may get cut off depending on the size of your table and your row limit. You can sort the sql table if you need the newest records, since you're dealing with datetime.
Yes that would be an option.
I'm already using Automate to get around the fact that the "In" operator isn't delegable. I'd like to avoid having to use so many interfaces. I may just add a field to the SQL table that is in date format and filter using the = operator.
Not the most elegant solution, but it'll work.
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!