Unanswered

Use DatePicker to Lookup Data in Excel

(0) Share

Report

Posted on by zw2348

Hello,

I'm trying to do something that I believe is quite easy, but I'm not having luck. I want to use the Date Picker to look up based on the date a column in excel.

I'm getting "Incompatible types for comparison. These types can't be compared: DateTime, Control."

My current formula - LookUp(SortTimes_2,Column1=DatePicker1,'Bulk Truck')

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report
try this:

LookUp(SortTimes_2, Column1 = DatePicker1.SelectedDate, 'Bulk Truck')

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
zw2348 91 on at

Like (0)

Report

Got closer.. but I think I'm at a stop until MS Fixes the bug.. I got this error.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @zw2348,

I think you have referred to a wrong column name...

In your excel table, it is BulkTruck without any space, so, could you please try:

LookUp(SortTimes_2,Column1=DatePicker1,BulkTruck)

Or, please check this thread for details:

Solved: Search data from excel by selecting date in a date... - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No