Want to automatically fill form fields in Power Apps using data from a SharePoint list?
In this Power Apps tutorial, you'll learn how to connect a Canvas App with a SharePoint list, create a customer-selection dropdown, and automatically populate related fields such as Name, City, and Phone Number. The video walks through the complete setup, from preparing the SharePoint customer data to testing the autofill functionality in Power Apps.
In this Power Apps Canvas App tutorial, you'll learn:
✔ How to create and prepare a SharePoint list for customer data
✔ How to connect a SharePoint list with Power Apps
✔ How to add a Dropdown control to a Canvas App
✔ How to display unique Email values using the Distinct() function
✔ How to use the Dropdown Selected.Value property
✔ How to use LookUp() to find the selected customer's record
✔ How to store the selected record in a variable using Set()
✔ How to autofill the Name field from SharePoint data
✔ How to autofill the City field from SharePoint data
✔ How to autofill the Phone Number field from SharePoint data
✔ How to test the complete autofill functionality in Power Apps
If you're searching for a Power Apps autofill form tutorial or want to learn how to retrieve related SharePoint list data based on a selected value, this step-by-step guide will help you build a simple and practical customer data autofill solution.
This video includes:
power apps autofill form, autofill fields in power apps, power apps sharepoint list, power apps dropdown, power apps lookup function, power apps lookup, power apps set function, power apps distinct function, power apps canvas app, power apps sharepoint, power apps customer data, power apps tutorial, power platform tutorial, microsoft power apps, power apps for beginners
Timestamps:
00:00-00:20 – Introduction
00:21-1:34 –SharePoint Customer Data list
1:35-2:20 – Connect the SharePoint list to Power Apps
2:21-2:47 – Add the Dropdown control
2:48-3:02 – Add Text Input
3:03-3:30 – Add Text Label
3:31-3:50 – Update Labels
3:51-7:30 – Demo
🔥 Power Apps makes it easy to automatically retrieve related information from SharePoint when a user selects a record. In this tutorial, the Dropdown control displays unique customer Email values, while the LookUp() function finds the matching SharePoint record. The selected record is stored in a variable and its Name, City, and Phone Number values are used to automatically populate the corresponding fields.
This approach is useful for customer forms, employee forms, contact management, service requests, registration forms, sales applications, and other Power Platform solutions where users need to select a record and automatically populate related information.
👉 LIKE 👍 | COMMENT 💬 | SUBSCRIBE 🔔
for more Power Apps tutorials, Canvas App guides, Power Platform tips, and low-code development tutorials!
#powerapps #microsoftpowerapps #powerplatform #powerappstutorial
#canvasapps #sharepoint
#powerappslookup #powerplatformtutorial #lowcode