displaying overdue in powerapps

(0) Share

Report

Posted on by KDAI

172

I am trying to display overdue items with completing equals no.

this is my code

ClearCollect(
collrequestsoverdue,
Filter(
'mylist',
('Due Date' > (DateAdd(
Today(),
1,
Days
)) && Completed = "no")
)
);

first i get delegation warning and the result is not correct. it doesn't display correct number of overdue items.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@KDAI

Too many parentheses.

ClearCollect( collrequestsoverdue, Filter( 'mylist', 'Due Date' > DateAdd(Today(),1) && Completed = "no" ) );

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@KDAI

Too many parentheses.

ClearCollect( collrequestsoverdue, Filter( 'mylist', 'Due Date' > DateAdd(Today(),1) && Completed = "no" ) );

Was this reply helpful? Yes No
KDAI 172 on at

Like
a
(0)

Report
Copy link

Link copied!

not working same result, I have 5 overdue items it displays 3 and the three are all not overdue. all of the items have dude dates higher than 9/6/2022, i needed the items with due date 9/5/2022 or earlier not working.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@KDAI

So you want items due before tomorrow?

ClearCollect( collrequestsoverdue, Filter( 'mylist', 'Due Date' < DateAdd(Today(),1) && Completed = "no" ) )

Was this reply helpful? Yes No
KDAI 172 on at

Like
a
(0)

Report
Copy link

Link copied!

i want items that are overdue, that were supposed to be completed before today but not completed

Was this reply helpful? Yes No
KDAI 172 on at

Like
a
(0)

Report
Copy link

Link copied!

this one seems working ClearCollect(
collrequestsoverdue,
Filter(
mylist,
(DateDiff(
'Due Date',
Today()
) > 0 && Completed = "no")
)
);

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@KDAI

For items due before yesterday, so would

'Due Date' < DateAdd(Today(),-1)

Was this reply helpful? Yes No