Power Automate is a powerful tool to eliminate repetitive tasks. In this guide, we’ll build a simple but practical flow:
✅ Create a weekly folder in SharePoint
✅ Send a reminder email with the current week
Arabic Video : https://youtu.be/WIrxf8aysTk
Step 1: Set the Weekly Trigger
Our weekly Cut-Off Date (COD) is Thursday, but I start the process on Wednesday to generate an early progress draft and catch any gaps before COD.
Add a Recurrence trigger and configure it to run every Wednesday at a fixed time in your timezone. This guarantees the flow kicks off automatically each week and gives you a full day to validate inputs before the official cut-off.
Recommended settings:
Frequency: Week
On these days: Wednesday
Time zone: (select your project’s time zone)
At these hours/minutes: e.g., 08:00 (set a consistent time)
📸 Screenshot – Recurrence action setup
Step 2: Capture and Format the Date
We run the flow on Wednesday but need a date label for Thursday (COD). So we:
capture the run time,
add +1 day, and
store a clean date string to reuse in folder names and emails.
2.1 Current time
Add Current time → captures the exact timestamp when the flow starts.
2.2 Add to time
Add Add to time
Base time: Current time
Interval:
1Time unit:
Day
This shifts the date to Thursday.
2.3 Initialize variable (date)
Add Initialize variable
Name:
dateType:
StringValue: click Expression (fx) and paste:
This outputs a clean string like 20250919 → perfect for folder names and paths.
Step 3: Create the Weekly Folder in SharePoint
Use Create new folder action:
Site Address: your SharePoint site
Library: Documents
Folder Path: e.g.,
Project Controls/WeeklyReports/@{variables('date')}
📸 Screenshot – Create new folder action
Tip — Send the reminder email on a parallel branch
After Initialize variable (date), add a Parallel branch:
Left branch: SharePoint actions (Create weekly folder → optional Create archive).
Right branch: Email actions (Initialize
email-date→ Send an email).
Why?
If the folder step fails (permissions, name already exists, path typo), the email still goes out.
Your Document Control (DC) / team receives the reminder regardless of storage issues.
Faster overall run time since both branches execute concurrently.
Step 4: Send Weekly Reminder Email
Finally, add Send an email (V2).
Subject: include the week date →
Request for PMC Weekly Progress Dashboard - @{variables('email-date')}Body: include your reminder message.
For the email-date variable, we used a readable format:
📸 Screenshot – Send email with dynamic subject and body
