Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

Autopopulate dropdowns, but not in a form

Hi everyone

The app I am working on is to log incident reports, which currently consists of about 15 dropdowns, a few text fields and a date picker. I would like to use the same fields to enter a new incident and also amend existing ones. So I would use a combobox to choose a previous incident which would autopopulate all the dropdowns and text fields that could then be amended.


Thank you

Dual Super User
Dual Super User



What is the data source for this app?

15 drop downs, where is the data coming from for these drop downs?


Depending on the details you provide, you can auto populate values. 


Filter(), LookUp() functions will be helpful to isolate the required values.



Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.


Hi, For now it is a One Drive Excel spreadsheet.

I would like to use these same fields to enter a new report or edit an existing one, I was going to use a toggle to switch modes. However my current problem is making the fields populate using ComboBox1_1 to choose which report to edit. The layout is very messy at the moment, but i am just trying to sort the mechanics of it all.

Screenshot 2020-09-03 13.20.16.png

Screenshot 2020-09-03 13.22.34.png

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (30,657)