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 / Write field from a Sha...
Power Apps
Unanswered

Write field from a SharePoint list to a combo box that uses a different SharePoint list

(0) ShareShare
ReportReport
Posted on by 37
I am trying to write a value from a SharePoint List back to a combo box.  The combo box is already used to select data from a different list.  The example scenario is below and I've attached an illustration picture.
 
The Project Leader Request Form is based on an existing SharePoint list (Source_JobInfo).
  • User clicks the Job Number combo box which pulls data from the Source_JobInfo SharePoint list.

Source_JobInfo.jpg

  •  User select the appropriate Job Number which auto populates Job Title, Start Date, and Current Job Leader
  • User selects the New Job Leader from a combo box then clicks a Submit button.
 
On Select behavior for the Submit button
  • Data from Power App is written to SharePoint list Form_ChangeRequest
  • Power Automate approval workflow is triggered
  • Exit() is triggered which wipes the Power App form page and navigates back to Power Apps landing page.
  • Note: Power Automate updates the status field at top of the app page and on the approver rows at button of the app page.
Form Change Request.jpg

 What am I stuck on?

  • Job Support Specialist wants to return to the form in order to make a correction to the Job Number.  An Edit Button is clicked which navigates to the app and passes in a parameter into a variable, varReqNum.
  • The fields in the form are populated from the Form_ChangeRequest list using a lookup function: Example:   Lookup(Form_ChangeRequest, Request Number= varReqNum, Job Title)
  • Here is what I’m stuck on:  The lookup table does not work for the combo boxes.  I want the users previous selection (example: JN56932) to be displayed in the combo box and, if needed, a new selection made. Click a save button will rewrite to the existing record
Power App.jpg

 An important limitation is that I’m not placing any logic or dropdowns in the SharePoint list itself.  The SharePoint lists are strictly text, numbers and dates.

 
How do I write back a field from a SharePoint table to a combo box? I tried using the DefaultSelectedItems attribute to lookup the selection based on a variable, but it didn’t work.
Categories:

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

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 236 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 207 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 169

Last 30 days Overall leaderboard