Lesson 1 of 45 min read
The brief: an expense tracker
What you are building and the data behind it.
You will build a small but complete app: staff submit an expense, see a running list of their submissions, and open any item for detail. It is deliberately ordinary — the point is to practise the moves you will repeat on your own problem statement.
The data source
A SharePoint list named Expenses is provided. It has the columns your app will bind to:
- Title (single line of text) — a short description.
- Amount (number) — the claim value.
- Category (choice) — Travel, Meals, Equipment, Other.
- Status (choice) — Pending, Approved, Rejected.
- SubmittedOn (date) — defaults to today.
Tip
Connect once: Data → Add data → SharePoint → pick the site → select the Expenses list. Every control then binds to this single source.