Unanswered

Identify the week from dates

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

IN MY SHAREPOINT MS LIST THERE ARE TWO COLUMN"DATE" AND "WEEK". MY REQUIREMENT IS I NEED TO FIND WHICH WEEK THE DATE FALLS. EG- IF 13/02/2024 FALLS IN 3RD WEEK, IN MY WEEK COLUMN THE TEXT MUST BE WEEK 3. SIMILARLY, IF THE DATE FALLS ON 2ND WEEK IT MUST BE WEEK 2.

HERE DATE 1 TO 3 OF FEB IS CONSIDERED WEEK 1 AND DATE 25 TO 29 CONSIDERED WEEK 5.
IS THERE ANY SOLUTION TO ACHIEVE THIS ... ANY WAY BY CREATING CALCULATED COLUMN IN LIST? OR THROUGH POWER AUTOMATE FLOW OR BY POWER APPS?

Categories:

Using connectors

All responses (3)

Answers (0)

Sort by

CFernandes 8,504 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous- You mentioned Power Apps -

Can you try the below

Round((Day(Now())/ 7)+1,0)

Also try - add(div(add(dayOfMonth(utcNow()), 6), 7), 1) in PowerAutomate. I have not thoroughly tested it.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

THANKS FOR YOUR RESPONSE, BUT IF WE LOOK AT DECEMBER 2025 6TH DAY WHICH IS 1ST WEEK SAT , BUT BASED ON YOUR POWER APPS CODE IT SHOWS 2ND WEEK
CFernandes 8,504 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous - Arrr I knew there will be edge cases 😐 From the top of my head I don't have an idea but will try to spend more time later, to find a possible solution.