web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / In a SharePoint list, ...
Power Apps
Answered

In a SharePoint list, how do I auto populate a form field value based on a dropdown selection of another form field in the same SharePoint list?

(0) ShareShare
ReportReport
Posted on by

I am not very familiar with Power Apps at all so I need some serious help.  I created a SharePoint list for a deliverable checklist and would like for some of the fields to auto-populate based on dropdown selections.  For example: For each new entry, when someone chooses a deliverable from the dropdown in the deliverable column, I want the deployment gate column to auto-populate that filed value with the gate option and the responsible column to auto-populate that field with the group that is responsible. So far I have 3 columns. 

Column1 - Deliverable (dropdown of 20 different options that could have the same deployment gate and owners)

Column2 - Deployment gate : STAGE or PROD (can be dropdown options or single line text)

Column3 - Responsible (dropdown of 5-10 different options for owners)

 

If Column1= Architecture diagram, then

Column2 auto-populates STAGE

Column3 auto-populates Dev Architecture

 

If Column1= BCPDR Test, then

Column2 auto-populates PROD

Column3 auto-populates Ops Support

 

If Column1= Roadmap, then 

Column2=STAGE

Column3= Product Management

 

Any help you can provide will be greatly appreciated.  Please also list exactly which field and or areas in where this should be done in Power Apps.    

 

Thanks in advance! 

Regards

Categories:
  • Verified answer
    v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @SChestnut ,

     

    You could create a relationship table in sp list.

    vxiaochenmsft_0-1647311329863.png

    vxiaochenmsft_1-1647311344799.png

    vxiaochenmsft_2-1647311355862.png

    vxiaochenmsft_3-1647311366815.png

    vxiaochenmsft_4-1647311379863.png

    vxiaochenmsft_5-1647311390050.png

     

    Best Regards,

    Wearsky

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 393 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 278 Most Valuable Professional

Last 30 days Overall leaderboard