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.