Answered

date lookup issue

(0) Share

Report

Posted on by daniels471

hi , I'm having trouble again with a different formula now

LookUp('week list','startdate (calc)'=DateAdd(Today(),1-Weekday(Today(),StartOfWeek.Monday),Days),week)

I want to have it so it gets the week number ( which is listed in the column "week" in the SP list " Week List"

the "start date (calc)" column does include the time as i read this can cause issues

there are no errors ,it just simply provides no output

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

rebeccas 2,591 on at

Like (0)

Report
Copy link

Link copied!

Is your column 'startdate (calc)' an actually calculated column or a date/time column?

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@daniels471

If the column you are comparing has a time, then you will need to provide the exact match to the time as well.

You current formula is focused on the date without time.

If you want to compare equal types on both side of the equals, then consider this formula:

LookUp( 'week list', Text('startdate (calc)', ShortDate) = Text(DateAdd(Today(),1-Weekday(Today(),StartOfWeek.Monday),Days), ShortDate), week )

This will convert both sides to a shortdate text format and then they will compare properly.

Note: this is not a delegable operation and will produce a warning as such. If record limits are not a concern, you can ignore it.

I hope this is helpful for you.

Was this reply helpful? Yes No
daniels471 78 on at

Like (1)

Report
Copy link

Link copied!

that worked , along with the fact that i actually had the wrong start date in my share point list so of course it never was going to match

Was this reply helpful? Yes No