From the course: Power Apps: Building Data-Driven Apps with Excel

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Adding drop-down fields

Adding drop-down fields

- [Instructor] I've made some more changes to my app and it looks pretty good. But when you're working with Power apps there's a lot more you can do than just play with the appearance, things that will make the app much more useful. For instance, you may want to provide users with predetermined values for some fields by using dropdown lists or choices. This has the dual benefit of making the user's job easier and of making the integrity of your data better too. You can't do this in Excel like you normally would. At least at present Power apps cannot work with Excel tables that contain formulas or other special formatting. This means that your strategy for Power apps must be to use it as a front end collector of raw data only. The dataset will then be utilized by additional workbooks which draw on it for information. Those workbooks can have formulas so you can manipulate your information to your heart's content at that point.…

Contents