SharePoint Site & List
Stand up a SharePoint team site and a Tasks list with the columns Lab 4's approval flow will read from and write back to.
Exercises
01
Exercise 1 — Create the SharePoint list
Task 1.1 — Create a SharePoint site
- In
https://make.powerapps.com, open the App launcher (top-left) and select SharePoint. - Close the welcome dialog if it appears, then select + Create site.
- Choose Team site → Standard team template → Use template.
- Name the site
Power Automate, select Next → Create site → Finish.
- On the new site, select + New → List → Blank list, name it
Tasks, select Create.
Add these columns via + Add column, saving after each:
| Name | Type | Notes |
|---|---|---|
| Description | Multiple lines of text | — |
| Owner Name | Single line of text | — |
| Deadline | Date and time | — |
| Approval Status | Choice | New / Approved / Declined, default New |
Copy the site's base URL now (e.g.
https://m365x99999999.sharepoint.com/sites/PowerAutomate/) — you'll paste it into flow triggers in Labs 4 and 6.02
Exercise 2 — Seed the list with data
Add three items with + New — Owner Name is MOD Administrator on all three:
| Title | Description | Deadline | Status |
|---|---|---|---|
| Contact Jon | Call or email | Yesterday | Declined |
| Create Quote | No discount | Today | Approved |
| Visit Jim | First visit | Tomorrow | New |