web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
Sign Up for Ask a Community Pro Today!
Share your business problems and get Power Platform leaders' perspectives!
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Split SharePoint start...
Power Automate
Unanswered

Split SharePoint start and end datetime in week and use in table

(0) ShareShare
ReportReport
Posted on by Pratik117 Microsoft Employee

Hi Team,

 

I want to use SharePoint start and end time for the month of suppose Dec in this format 

In Sharepoint i have Start Time and End Time in UTC format and i am using select to get it from values :

Pratik117_0-1636954302059.png

How can i achieve this in below table ? 

# of events

Dec (week) Sun-Sat  

1

1st – 4th

2

5th – 11th

3

12th – 18h

7

19th – 25th

7

26th – 31st

Categories:
General topics
I have the same question (0)
  • Hardesh15 Profile Picture
    Hardesh15 7,087 Super User 2024 Season 1 on at

    @Pratik117  Please take help from this-

    https://www.gopenly.in/spo-how-to-calculate-week-number-from-date-column/

     

    You can achieve this first via calculated column (when you have week number) then via flow you can design format.

    Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

  • Pratik117 Profile Picture
    Pratik117 Microsoft Employee on at

    Perfect thanks Hardesh, but is there any way i can directly include in flow as we need to send daily report about the change and changing in SharePoint will let us go through again long channel for approval process and bit complex here. Thanks for your prompt response here.

  • mahoneypat Profile Picture
    mahoneypat 1,720 on at

    Have you considered using Power BI instead?  This analysis would be much easier, and you could use a subscribe to your report (or a paginated report) to get the automated daily update.

     

    Pat

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Sign Up for Ask a Community Pro Today!
Share your business problems and get Power Platform leaders' perspectives!

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 176 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 96 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans