Answered

Filter Source to items this week

(0) Share

Report

Posted on by jamescosten

643

I have an SP list that is used for daily compliance checks. I have a label that shows the number of checks today but I cannot get the number this week to work.

Sum(Filter('Quality Daily Compliance', Date >= Now() - Weekday(Now(), StartOfWeek.Monday) && Date <= Now() - Weekday( Now(), StartOfWeek.Monday )+7), Hours)

My Today formula is this:

CountIf('Quality Daily Compliance',Text(Created,DateTimeFormat.ShortDate) = Text(Today(),DateTimeFormat.ShortDate)) but i could not get that to work with the week.

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jamescosten,

Could you please share a bit more about your need?
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @jamescosten

can you please try this instead:
Sum(Filter('Quality Daily Compliance', Date >= Now() - Weekday(Now(), StartOfWeek.Monday) + 1 && Date <= Now()), Hours)

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
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jamescosten ,

Try this

With( { _Start: Now() - Weekday( Now(), StartOfWeek.Monday ), _End: Now() - Weekday( Now(), StartOfWeek.Monday ) + 7 }, With( { _Data: Filter( 'Quality Daily Compliance', Date >= _Start && Date <= _End ) }, Sum( _Data, 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.

MVP (Business Applications) Visit my blog Practical Power Apps
jamescosten 643 on at

Like
a
(0)

Report
Copy link

Link copied!
jamescosten 643 on at

Like
a
(0)

Report
Copy link

Link copied!
Verified answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @jamescosten

try this instead:
CountRows(Filter('Quality Daily Compliance', Date >= Now() - Weekday(Now(), StartOfWeek.Monday) + 1 && Date <= Now()))

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
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jamescosten ,

I got the Hours field from your code - If Hours is a numeric field in 'Quality Daily Compliance', the code is valid (I have tested it below) assuming you are using this somewhere requiring a number/text value - is this the case ? Test below is valid and produces the expected result when used as the Text of a Label

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.

MVP (Business Applications) Visit my blog Practical Power Apps