← Base Layer Books

Swap the Spreadsheet for Power Apps

A Beginner's Guide to Canvas Apps, from a SharePoint List to an App Your Team Uses on Their Phones

$12.99

Buy direct — instant PDF

Your team runs something important from a shared spreadsheet. Someone overwrites a cell, nobody can tell who has what, and the file is miserable to use on a phone. This book shows you how to replace that spreadsheet with a real app your team can use anywhere, built in Microsoft Power Apps with the work Microsoft 365 account you already have. You follow one project from start to finish: an equipment checkout app for a small team. You move the data into a SharePoint list, generate a working app from it in minutes, and then make it your own. You learn to make the gallery search, filter and sort, connect it to a form for adding and editing items, and write formulas that work like the spreadsheet cells you already know. You add buttons that check items out, extend due dates and retire old equipment, build a second screen that shows each person what they have, and make the whole app comfortable on a phone. Along the way you learn the limits that trip beginners up: delegation, which decides how much data your app can see, and the licensing rules that keep your app inside what Microsoft 365 already includes. Then you publish it, share it, and open it on phones and in Teams.
Pen name: Base Layer Creative · A Base Layer Books title, published by JK.Creative.
After purchase, you'll get an email with a download link. The direct version includes extras the Amazon edition can't carry.