weekly commitments

(0) Share

Report

Posted on by AndiRodi

133

Hello everyone,

i'm working about a system which shoulde show me the percentage of availability (free / busy) of a user with reference to a specific week (e.g. week 32).

there is a MS Graph call to do it?

can someone suggest me how can i achieve my objective?

many thanks,

Andi

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hi @AndiRodi , @WarrenBelz have a cool answer to your prob or part of it.

week numbers can be found using this from him:

RoundDown( (RoundUp( Today() - Date( Year(Today() - Weekday(Today() - 1) + 4), 1, 3 ), 0 ) + Weekday( Date( Year(Today() - Weekday(Today() - 1) + 4), 1, 3 ) ) + 5) / 7, 0 )

I use it often and it works like a charm.

Hope it helps
AndiRodi 133 on at

Like
a
(1)

Report
Copy link

Link copied!

I will test it now.

Many many thanks... you are to far, but you deserve a BIG BEER! 🙂
AndiRodi 133 on at

Like
a
(0)

Report
Copy link

Link copied!

It works very well.

Just another question please:
- once i get the number of week, how can i set as a stratDateTime the first day of the "selected" week and as a endDateTime the last day of the selected week?

thanks,
Andi