02 - Prepare Your Training Workspace: Copy-paste
Hover over a grey box and click the copy icon in its top-right corner. Anything marked text is typed or pasted straight into a field.
Folder names (text, section 2.1)
Main folder:
Power Automate Training
Subfolders:
Attachments
Reports
Workbook name (text, section 2.2)
TrainingRegister
Excel headers and sample rows (section 2.2)
Click cell A1 in Sheet1, then paste. Each value lands in its own column: the headers fill row 1 and the six fictional rows fill rows 2 to 7.
The sample dates may already be in the past on your class day. After pasting, change the SessionDate values as described in step 4 of section 2.2 (at least two Registered rows within the next 14 days, one Completed row, and one row more than 14 days away). If the dates paste left-aligned, retype them in your local date format.
TrainingID ParticipantName Email CourseTitle SessionDate Status
TR-001 Aisha Rahman learner1@example.com Power Automate Basics 9/21/2026 Registered
TR-002 Daniel Lee learner2@example.com Excel Reporting 9/22/2026 Registered
TR-003 Mei Chen learner3@example.com Microsoft Forms 9/23/2026 Completed
TR-004 Ravi Kumar learner4@example.com Teams Collaboration 9/24/2026 Registered
TR-005 Sofia Martinez learner5@example.com Approval Workflows 9/28/2026 Registered
TR-006 Noah Williams learner6@example.com Cloud Flow Essentials 10/5/2026 Completed
Table name (text, section 2.2)
tblTraining
Test email subject (text, section 2.3)
[PA TRAINING] Attachment test
Test email body (text, section 2.3)
Training attachment test.