Populate Combo Box Selection with Value from Another SharePoint List

(0) Share

Report

Posted on by adammparmenter

Combobox1 in the Job Leader Change Request Power App pulls from Source_JobLeaders list.

Power App.jpg

When the user clicks the submit button,

Patch() is triggered so the combo box selection and all the other fields in the form are written to Form_ChangeRequest SharePoint list.

Form Change Request.jpg

Power App closes [Exit()], which wipes out the form.

Approver clicks a button [workflow.Run()] which

contains URL for to Power App noted above and a unique parameter which passes to a variable.
Power apps uses Lookups and the variable to populate the fields in the Power App form so that the approver may review the form submitted in the example above.

Issue: I have not been able to populate the combo box with the selection made by the originator of the form. The combo box pulls from one list and writes the selection to another. I attempted a lookup/variable in the DefaultSelectedItem, but could not get it to work.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @adammparmenter,

Is this column corresponding to the ComboBox populated with another list is a LookUp column from the destination list?

Could you please how you set the Items property of this combobox?

If so,
adammparmenter 37 on at

Like
a
(0)

Report
Copy link

Link copied!

User selects from a combo box. The source of which is a column in the SharePoint list: Source_JobLeaders.
When user submits the form, all the form data, including the combo box selection is written to a different SharePoint list: Form_ChangeRequest.
When approver visits the form, I need the combo box in the form to show the selection made by the user initially, which was saved to the Form_ChangeRequest, SharePoint list.
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

HI @adammparmenter,

Could you please answer my question directly?

The column type of the mentioned column and how you set the Items property is the key to this problem.
adammparmenter 37 on at

Like
a
(0)

Report
Copy link

Link copied!
Combo Box
The combo box is in a horizontal control.
Data source (i.e. Items property): Source_JobLeaders
Fields:
Primary Text: Project Leader
SearchField: Project Leader
SharePoint List: Source_JobLeaders
Two column SharePoint list
Columns
Hidden column: Item ID
Project Leader column: Single line of text
At OnSelect for Submit button
Patch function writes from combo box selection to Form_ChangeRequest
Column Name: New Job Leader
Column Format: Single line of text
When return to form need to write back to the form such that the user selection written to Form_ChangeRequest list is visible in combo box.
Verified answer

adammparmenter 37 on at

Like
a
(0)

Report
Copy link

Link copied!

One solution I discovered is to NOT use a combo box. Instead use a DropDown list.

The dropdown set to pull from a SharePoint list. Submit button triggers the Patch() function which writes to a different SharePoint list.

When approver clicks a button or link to return to the "form", the URL passes forward an ID parameter (example: IDParam) that uniquely identifies the specific row in the SharePoint list. That param is set in a variable. For example: varRowID.

The following formula can be placed in the Default parameter of the drop down list:
Default=If(IsBlank(varRowID)," ",LookUp([SharePointList],varRowID=[Abbreviation]_IDParam, [list column]))

Also set AllowEmptySelection = true

If a user is filling out a new form, varFormID will be blank and no value will be populated by default. If varForm is NOT blank, the formula looks up the value form the SharePoint list and populates it as the Default value.

As a result, the user can see the original value selected from the dropdown and can still select a different value.

This is not suitable for every situation. If a multi-select list is required, the classic dropdown won't work, you'll have to use a combo box. In that case the work around is to populate a textbox control with the combo box selections.