Microsoft Power Platform

Build apps.
Connect SharePoint.
Zero code needed.

Power Apps turns your SharePoint lists into fully functional business apps in minutes. Browse screens, edit forms, and automated workflows — all connected to the data your team already uses.

Connected to SharePoint ✓
Project Tracker — Canvas App
📋Projects
✅Tasks
👥Team
📊Reports
⚙️Settings
Active Projects
Website Redesign
Due Jun 30
Sarah K.
Active
Q3 Campaign
Due Jul 15
James M.
Draft
API Integration
Due Aug 1
Dev Team
Review
Why Power Apps + SharePoint

Everything your team
needs, already connected

SharePoint Online is the top data source for Power Apps — providing rich lists, document libraries, permissions, and seamless Microsoft 365 integration.

⚡
Instant App Generation
Point Power Apps at any SharePoint list and a fully functional browse/detail/edit app is scaffolded automatically — ready to customize in minutes.
🎨
Custom Forms & UI
Replace SharePoint's default new/edit forms with a branded Power Apps canvas. Drag, drop, and design layouts that match your business process.
🔄
Real-time Data Sync
Changes in the app instantly reflect in SharePoint — and vice versa. Every list item, column value, and attachment stays in sync automatically.
📱
Mobile-First
Apps run on any device — phone, tablet, or browser. Field teams capture data on mobile; managers review dashboards on desktop. No install required.
🛡️
SharePoint Permissions
Your existing SharePoint security model carries over. Site owners, members, and visitors see exactly what you intend — no extra permission setup needed.
🤖
Power Automate Flows
Trigger workflows when app data changes: send approval emails, create tasks in Planner, notify Teams channels, and more — all with no-code automations.
Interactive Builder

Build your app
step by step

Walk through the real Power Apps + SharePoint setup flow. Configure each step and see your app take shape.

1
Choose Data Source
Pick your SharePoint list
2
Select Columns
Choose fields to display
3
App Screen Type
Gallery, form, or dashboard
4
Preview & Formula
See your generated app
Choose a SharePoint List
Connect Power Apps to your SharePoint site. Select which list will power your app — each list becomes a table of records your app can read, write, and filter.
Select Columns to Display
Choose which SharePoint columns appear in your app. Each column becomes a field in your form or a column in your gallery view.
✓
Title
Single line text
✓
Status
Choice
Assigned To
Person
Due Date
Date & Time
Priority
Choice
Description
Multi-line text
Choose Your Screen Type
Power Apps generates three screen types automatically. You can keep all three or start with just the view that fits your workflow.
🗂️
Gallery View
Browse all records in a scrollable list
📝
Edit Form
Create and update individual records
📊
Dashboard
Charts and KPIs from list data
Your App is Ready!
Here's your generated canvas app connected to your SharePoint list. Below is the auto-generated Power Apps formula that connects to your data source.
🗂️ Project Tracker
Website Redesign
Assigned: Sarah K.
Active
Q3 Campaign
Assigned: James M.
Draft
API Integration
Assigned: Dev Team
Review
Generated Connection Formula
// Connect gallery to SharePoint list
Items = Filter(
'Project Tracker',
IsBlank(SearchInput.Text) ||
StartsWith(Title, SearchInput.Text)
)
How It Works

From SharePoint list
to live app in 4 steps

No servers. No deployments. No code. Just a SharePoint list and Power Apps Studio.

1
SharePoint
Create your SharePoint List
Set up a SharePoint list with the columns your process needs — text, dates, choices, people pickers. This list becomes your app's database.
Site Contents → + New → List
2
Integration
Connect Power Apps
Open your list in Microsoft Lists and click Integrate → Power Apps → Create an app. Power Apps Studio opens and generates three screens automatically.
Lists → Integrate → Power Apps → Create an app
3
Customise
Design & Customize
Use Power Apps Studio to adjust layouts, add validation logic with formulas, apply your brand colours, and add conditional formatting to fields.
OnSelect: SubmitForm(EditForm1); Back()
4
Deploy
Publish & Share
Publish the app, share it with your team, and embed it directly on a SharePoint page using the Power Apps web part. Everyone accesses it right where they work.
File → Save → Publish → Share with team
Real-World Use Cases

What teams are
building right now

HR & Leave
IT Help Desk
Operations
Project Mgmt
Human Resources
Leave Request & Approval App
Employees submit leave requests through a Power Apps form. Managers get notified via Teams, approve or reject in one click, and the SharePoint list updates automatically.
1
Employee opens app on mobile, fills Leave Request Form
2
Data saved to SharePoint Leave Requests list
3
Power Automate sends approval email to manager
4
Manager approves; list Status column updates to Approved
5
Employee receives Teams notification with decision
📅Leave Requests — SharePoint List Live Data
EmployeeTypeFromStatus
Alice M.AnnualJul 1✓ Approved
Bob K.SickJun 28⏳ Pending
Carol T.AnnualAug 5👁 Review
David R.StudyJul 20✓ Approved
IT Department
Help Desk Ticket System
Staff log IT issues from any device. Tickets are routed to the right technician, priority is set automatically based on category, and managers see a live dashboard.
1
Staff submits issue form via Power Apps on phone
2
Ticket saved to Help Desk SharePoint list with auto-ID
3
Priority auto-assigned via If() formula on Category
4
Assigned technician sees ticket in their filtered gallery
5
Resolution notes saved; Power Automate closes ticket
🎫Help Desk — Open Tickets 4 Critical
IssuePriorityTechAge
Email downCriticalTom W.2h
VPN timeoutHighLisa P.4h
Printer jamMediumUnassigned1d
Password resetLowTom W.30m
Operations
Asset Register & Check-Out
Track physical assets across locations. Staff check out equipment via a barcode scan, managers see real-time availability, and maintenance schedules are automated.
1
Asset scanned via Power Apps camera control
2
LookUp() finds matching record in SharePoint list
3
User patches Status = "Checked Out" and timestamps
4
Dashboard shows live utilisation rates per department
🖥️Asset Register 87 Assets
AssetLocationChecked ByStatus
MacBook #12HQ Floor 2Jane D.Out
Projector AConf Room—Available
iPad #07WarehouseMark S.Out
Camera KitStudio—Available
Project Management
Project & Task Tracker
Teams manage projects, milestones, and tasks all in one app backed by SharePoint lists. Gantt-style views, status rollups, and automated deadline reminders keep everyone on track.
1
PM creates project in Projects SharePoint list
2
Tasks linked via Lookup column to parent project
3
Gallery with nested Filter() shows tasks per project
4
Overdue tasks highlighted via conditional formatting
5
Power Automate sends weekly status digest to stakeholders
📊Active Projects — Status View 3 At Risk
ProjectTasksDoneHealth
Web Redesign2418🟢 On Track
ERP Migration5231🟠 At Risk
Brand Refresh1212✅ Complete
Data Warehouse3814🔴 Delayed
Formula Reference

Essential formulas for
SharePoint-connected apps

These are the most-used Power Apps functions when working with SharePoint lists. Click any formula to explore it.

Filter()
Query list records
Patch()
Create or update items
LookUp()
Find a single record
Remove()
Delete list items
SubmitForm()
Save form to SharePoint
SortByColumns()
Sort gallery items

Ready to connect your
first SharePoint list?

Sign in with your Microsoft 365 account — Power Apps is already included in most business plans. Your first app takes under 10 minutes.