web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Problem adressing past...

Power Apps

Answered

Problem adressing past days tasks...

(0) Share

Report

Report

Posted on by servaesj

5

Hello,

I'm making an app where teams can see the task they have to complete based on a sharepoint list with tasks. If they push the button they see the tasks based on a 'date' column that's compared with the 'isToday()' function. This works fine, showing todays taks.

The problem is with teams that work at night. At 12PM the 'isToday()' function will show the tasks of next day.

I tried to come up with a solution based on declaring a variable that is set(varTimeDrag ; DateAdd(Now();-8;Hours)) . I would integrate this in the formula instead of 'isToday' but I can't seem to find out how.

This is the current formula to retrieve todays tasks :

Filter(lstOpdrachtenTODO;UitvPloeg.Value=varHuidigePloeg;IsToday(DatumOpdracht))

'DatumOpdracht' is a sharepoint column 'date and time' without recording time.

Anyone any idea??

Thanks

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @servaesj ,
I cannot test this, but does the below work for you?
Filter( lstOpdrachtenTODO; UitvPloeg.Value=varHuidigePloeg && IsToday( DateAdd( DatumOpdracht; -8; Hours ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
servaesj 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank You Warren!

It worked for me!

I just had to delete the minus!

Join the conversation