Announcements
I have an excel spreadsheet with dates in Column 1 and a value in Column 2. I am trying to have the PowerApp look at Column1 and where column 1 = Today(), provide me with the value in column 2. I have tried the following
Can anyone tell me what I am doing wrong?........I am getting no values back at all and have been stuck on this for a while. Any guidance into helping me find my answer would be greatly appreciated.
Depending on how column A is formatted you should check exactly what values are being brought into Powerapps. Powerapps interprets all date values as full Date & Time values. So one of the common problems with date comparisons of '=' is that you aren't just comparing the date you are comparing the date and time, and the time is rarely identical. The common fix is to translate the date and time into a Text field and compare that to a text field with the date generated on Now().
You are right....a label is showing the date and time......figured that out just about an hour ago. Messing with the translations to a date field, but having an issue there too. Did not try and use the Now() function...Any guidance on a close formula? I will send you a giant cookie!
Use the text formula to format the datetime as just a date only string. do the same for Today(). Like this
Text(Today(),DateTimeFormat.ShortDate)
Do the same for the field you are bringing in and then you can compare them as equal strings.
Thank you sooo much....I will try that direction!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 358 Most Valuable Professional
11manish 214 Super User 2026 Season 2
Mohsin Ali 185
