Comparing dates using Lookup function / String was not recognized as a valid DateTime.

(0) Share

Report

Posted on by Lorem1960

379

I want to compare dates, I have a date that is entered in a form in my canvas application against dates that are listed in a sharepoint list named OREHolidays.

I have put the following formula in a text label to test this out

If(IsBlank(LookUp(OREHolidays,DateHoliday=DateValue(DataCardValueDateOT.SelectedDate),DateHoliday)),
"No Holiday" ,"Holiday"));

But I am getting the error below:

Anyone has any idea what I am doing wrong here? Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report
@Lorem1960

Please consider changing your Formula to the following:

If(!LookUp(OREHolidays, DateHoliday = DataCardValueDateOT.SelectedDate, true), "No ") & "Holiday"

I hope this is helpful for you.

Was this reply helpful? Yes No