Reader small image

You're reading from  Microsoft 365 and SharePoint Online Cookbook - Second Edition

Product typeBook
Published inFeb 2024
PublisherPackt
ISBN-139781803243177
Edition2nd Edition
Right arrow
Authors (4):
Gaurav Mahajan
Gaurav Mahajan
author image
Gaurav Mahajan

Gaurav Mahajan is a Microsoft Technology Solutions Professional who specializes in Microsoft 365, SharePoint, and AI, with over 19 years of technical consulting experience. Gaurav has a bachelor's in engineering, is Stanford certified in machine learning, and holds a PG Diploma in management from the Indian Institute of Management. He speaks at and organizes technical events, code camps, and conferences. He is a co-chair of the M365 & SharePoint Saturday, Pittsburgh (US) annual conference.
Read more about Gaurav Mahajan

Sudeep Ghatak
Sudeep Ghatak
author image
Sudeep Ghatak

Sudeep Ghatak is a Microsoft MVP in Business Applications and a frequent contributor to the Power Automate Community forum. He works as a Principal Architect in Christchurch, New Zealand and loves designing solutions based on Office 365 and the Azure platform. He is a certified Solutions Developer (MCSD) and holds a postgraduate degree in instrumentation engineering. He is an active member of the Microsoft community and often seen speaking at user groups and conferences in New Zealand.
Read more about Sudeep Ghatak

Nate Chamberlain
Nate Chamberlain
author image
Nate Chamberlain

Nate Chamberlain is a technical content creator, solution architect, and trainer, recognized as a 5-year Microsoft MVP. With a background in business analysis and systems administration, Nate has authored seven books and manages his blog. He holds an array of certifications, including M365 Enterprise Administrator Expert and Microsoft Power Platform App Maker Associate, and is a frequent speaker at user groups and conferences.
Read more about Nate Chamberlain

Scott Brewster
Scott Brewster
author image
Scott Brewster

Scott Brewster is a Microsoft 365 Solutions Architect. He has supported numerous government clients focusing on SharePoint and Microsoft 365 since 2008. His focus is on security, administration, migration, governance, and training. Scott has been speaking at conferences and user groups since 2010 and runs the SharePoint User Group of DC.
Read more about Scott Brewster

View More author details
Right arrow

Creating a canvas app from a blank template

Power Apps has several templates that give you a head start in creating an app; however, if you want to start from scratch, you can start with a blank template. The following example demonstrates how you can create an app from scratch. The app queries data from a spreadsheet in your OneDrive for Business. This demonstration only focuses on the basics and doesn't go into detail on building a fully functional solution.

It is recommended that you start with a template that closely resembles what you are trying to build. This will save you a lot of time and effort.

In the next section, we will build an app that gets a list of cars from an Excel spreadsheet that is stored in OneDrive for Business:

Figure 14: Sample Data Source

Although we can extend this app to add/update and delete records from the spreadsheet, our intention is to just introduce the users to the concept of a screen, a control, and a data connection.

Getting ready

You need...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Microsoft 365 and SharePoint Online Cookbook - Second Edition
Published in: Feb 2024Publisher: PacktISBN-13: 9781803243177

Authors (4)

author image
Gaurav Mahajan

Gaurav Mahajan is a Microsoft Technology Solutions Professional who specializes in Microsoft 365, SharePoint, and AI, with over 19 years of technical consulting experience. Gaurav has a bachelor's in engineering, is Stanford certified in machine learning, and holds a PG Diploma in management from the Indian Institute of Management. He speaks at and organizes technical events, code camps, and conferences. He is a co-chair of the M365 & SharePoint Saturday, Pittsburgh (US) annual conference.
Read more about Gaurav Mahajan

author image
Sudeep Ghatak

Sudeep Ghatak is a Microsoft MVP in Business Applications and a frequent contributor to the Power Automate Community forum. He works as a Principal Architect in Christchurch, New Zealand and loves designing solutions based on Office 365 and the Azure platform. He is a certified Solutions Developer (MCSD) and holds a postgraduate degree in instrumentation engineering. He is an active member of the Microsoft community and often seen speaking at user groups and conferences in New Zealand.
Read more about Sudeep Ghatak

author image
Nate Chamberlain

Nate Chamberlain is a technical content creator, solution architect, and trainer, recognized as a 5-year Microsoft MVP. With a background in business analysis and systems administration, Nate has authored seven books and manages his blog. He holds an array of certifications, including M365 Enterprise Administrator Expert and Microsoft Power Platform App Maker Associate, and is a frequent speaker at user groups and conferences.
Read more about Nate Chamberlain

author image
Scott Brewster

Scott Brewster is a Microsoft 365 Solutions Architect. He has supported numerous government clients focusing on SharePoint and Microsoft 365 since 2008. His focus is on security, administration, migration, governance, and training. Scott has been speaking at conferences and user groups since 2010 and runs the SharePoint User Group of DC.
Read more about Scott Brewster