
Top 5 Microsoft Copilot examples in 2026
Five practical Microsoft 365 Copilot examples for everyday work, from analysing data in Excel and creating PowerPoint content to better prompting and building custom Copilot agents.
6 November 2026
News
Learn how to create forms in Power Apps Canvas apps with this step-by-step guide by Jay Wellings. Discover the key components, best practices, and tips for connecting to data sources like SharePoint, Excel, and Dataverse.

It’s always good to set your stall out early – and lets get the awkward part out of the way first – PowerApps is a bit of an overloaded term as this encompasses Canvas apps, Model Driven Apps and Power Pages which can at time get confusing – as such for the purposes of this article we are going to be focusing on Forms in Canvas Apps.
The general principles should stand for whichever flavour of PowerApp you are using, but your implementation will most likely differ.
PowerApps Canvas apps are akin to a blank sheet of paper within the Power Platform. As the developer, you (mostly) have complete control over the user interface, user experience, and business logic.
You can interact with many different data sources and APIs, build apps that are responsive and even introduce bugs if you’re really good! As such providing a comprehensive set of tools to create solutions quickly and efficiently, leveraging low-code benefits for rapid application development.
A form is a user interface component that has been a core aspect of software design long before the internet age.
According to Wikipedia, its described as: “The user interacts with the application by selecting one of a number of possible values, and by entering text into the fields that accept it.”
In practise a form is a container that hold elements that a user interacts with some Canvas App examples being:
Text Input: For entering single-line text.
Text Box: For entering multi-line text.
Dropdown: For selecting one option from a list.
Combo Box: For selecting one or multiple options with a search capability.
Date Picker: For selecting a date from a calendar view.
Toggle: For switching between two states (e.g., on/off).
Slider: For selecting a value within a range.
Radio Button: For selecting one option from a set.
Checkbox: For selecting multiple options independently.
Button: For submitting or performing actions.
Label: For displaying static text or dynamic data.

Simply put two action – user interaction and data input, – these 2 things are the glue that holds the majority of day to day applications together.
Pre-requisites
You will require a Datasource to connect to.


Browse to https://make.powerapps.com/ Click “Start with an app template” > Click “From SharePoint” On the “Create an app” page select your sample site > select the "pet_data" list > click create (fig 4) This will create a 3 page Canvas App. In here, you have two examples of forms - these can be seen in the image below: Step 1 - This is the gallery view of the pet data. This component will launch you into the forms to view each record details. The on the “OnSelect” action of the this component will navigate you to the “DetailsScreen1”- described in step 2. Step 2 - We have an example of a “Detail Form” this displays the fields from the selected record in a read-only form. These types are forms are used to easily display data in an none editable way. The key properties to understand are: Data source - This identifies where the data shown in the form, in our case this is configured to use the "pet_data" from SharePoint (Step 4). Item - This points to the selected record from the gallery so the form knows which record to display to the user (Under the advanced tab). Fields - These are the fields shown on the form - you can modify what is used on the form by clicking “edit fields” - here you have the option to Add, remove and reorder the fields on the form (Step 5). Layout options & Style options - there are options quickly modify the layout of the form (Step 6) and Step 8 gives you the options to alter the background colour, form size, position and add border colours and thickness.Step 3 - This is an example of “Edit Form” that based on how this is set up will allow you to either edit existing data in a Datasource or add new records to the Datasource. The properties that are outlined above also apply to the “Edit Form” However the "Edit Form" has a unique value called “Default Mode” this has the options: Edit - This vis to be used when the form is used to modify existing data New - This is to be used when the form is adding new data to your data source. View - This is used to switch the form into a read only mode.The default mode is a property that can be modified on the fly dependent on you use case. A good example of this would be: The user needs to add a new record > set form “new” mode. As the user submits the form switch the form to read only to prevent modification of form during save > set form “View” mode Once the data has been saved, reload the data into the app and allow the data to be editable > set the form to “Edit” mode All of the above covers 3 different use cases all while using the same form!To persist the data from an editable or new form you need to implement the SubmitForm function in the OnSelect property of a Button control. In our example this is the “tick” icon to the left for step 4.
Now that you have a foundational understanding of creating forms in Power Apps Canvas apps here are some next steps to help you continue your learning journey:
“We work with organisations across many sectors of different shapes and sizes from 10 to 100,000 employees.”
Contact our team today!



Five practical Microsoft 365 Copilot examples for everyday work, from analysing data in Excel and creating PowerPoint content to better prompting and building custom Copilot agents.
6 November 2026

25 November 2026 · 11:00 · Online

Explore Valto's four-stage AI Maturity Model and what UK search data reveals about the shift from AI curiosity to implementation, governance and real value.
28 October 2026