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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / to create a flow to se...
Power Automate
Unanswered

to create a flow to send out weekly timesheet to another list

(0) ShareShare
ReportReport
Posted on by

How can one create a flow that when a an individual has completed with submitting their day to day timesheet that by the end  of the week all their entries from the start of the week to the end will be collected as one and automatically send that full weeks entry to another list on SharePoint which will automatically send an email approval to their manager. 

Categories:
I have the same question (0)
  • ChristianAbata Profile Picture
    8,951 Most Valuable Professional on at
    Re: to create a flow to send out weekly timesheet to another list

    @Anonymous  what kind of services are you thinking to use. Maeby SmartSheet or Excel? I don't understant that part.

  • Community Power Platform Member Profile Picture
    on at
    Re: to create a flow to send out weekly timesheet to another list

    @ChristianAbataThe service I'm using is SharePoint?

  • v-alzhan-msft Profile Picture
    on at
    Re: to create a flow to send out weekly timesheet to another list

    Hi @Anonymous ,

     

    Could you please explain more details about the day to day timesheet the user would submit every week?

     

    If the timesheet that you mentioned are sharepoint list A, the user would add items to the list A every day, and your requirement is add those items from list A to a list B every week, also send an approval email at the same time, please let me know and I would provide the steps to create the flow.

     

    Best Regards,

    Alice

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Community Power Platform Member Profile Picture
    on at
    Re: to create a flow to send out weekly timesheet to another list

    Yes that's exactly what I'm trying to do, basically each day they'll put in activities they've done for the day, this is done everyday and then by the end of the week their entries would be taken to another list for approvals and this is done every week.

  • Verified answer
    v-alzhan-msft Profile Picture
    on at
    Re: to create a flow to send out weekly timesheet to another list

    Hi @Anonymous ,

     

    Please refer to screenshot below to create the flow:

    3.png

    2.png

     

     

    Expression1:

    formatDateTime(items('Apply_to_each')?['Created'],'yyyy-MM-ddTHH:mm:ssZ')

     

    Expression2:

    formatDateTime(utcNow(),'yyyy-MM-ddTHH:mm:ssZ')

     

    Expression3:

    formatDateTime(items('Apply_to_each')?['Created'],'yyyy-MM-ddTHH:mm:ssZ')

     

    Expression4:

    formatDateTime(addDays(utcNow(),-7),'yyyy-MM-ddTHH:mm:ssZ')

     

    Best regards,

    Alice       

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Community Power Platform Member Profile Picture
    on at
    Re: to create a flow to send out weekly timesheet to another list

    As I understand you want to do something like time worksheet made of 3 sub-processes:

    1. Collecting data daily from person.

    2. Sending weekly to manager.

    3. Waiting for approval.

     

    If i'm right you need to decide how you want to collect data? Manually collect data or make flow with button trigger where person will insert data? Or maybe you have export from sort of application? Or API?

     

    Second one you need to create recurring every 7 days flow which takes data from sp list and sends to manager approval. I was using docusign for that for more important documents.

     

    I would like to add 3rd part of 2nd flow when item is approved or not send e-mail with status.

     

    @Anonymous here is link which explains more than one post:

    https://docs.microsoft.com/en-us/power-automate/run-scheduled-tasks

    PS.

    You can also make something different.1st flow: If people update data only one time in the week you can make a flow which is recurring one time in the week. Next send e-mail with "please update data till Friday(or anything)", 2nd flow: someone is filling form of that data, next is sending to approve. Triggered from form. Also you can make a flow which checks that someone filled data or not and sends notification to manager, employee etc.

  • Community Power Platform Member Profile Picture
    on at
    Re: to create a flow to send out weekly timesheet to another list

    The post was very helpful, thank you!

  • Community Power Platform Member Profile Picture
    on at
    Re: to create a flow to send out weekly timesheet to another list

    I just tried it on an test sites and it worked, thank you so much!!!

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

Quick Links

Forum hierarchy changes are complete!

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

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard