From the course: Power Apps: Building Data-Driven Apps with Excel
Join today to access over 25,500 courses taught by industry experts.
Autopopulating field values
From the course: Power Apps: Building Data-Driven Apps with Excel
Autopopulating field values
- [Instructor] In our app, I've got an employee ID number field which I don't want the employee playing with. Not only do I not want them to be able to change it, I also want it to automatically increase for new records. I want new employees to be one more than the last highest employee number. So how do I do this? The first step is actually back in Excel. You'll want to sort the employee number numerically by the ID field. This will make things much easier in the app. Now, back in the app, let's start by unlocking the data card for the employee ID number. Select the card and in the right hand panel select the advanced tab, then click to unlock changes. Now we'll protect the field from editing. In the edit screen, click on the data value for the employee ID card. Now select the property display mode in the formula bar and change the value to view. You'll see that the edit screen changes right away. However, there's a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.