Problem with Combo box in Edit Form - not displaying value from selected record I want to edit

(0) Share

Report

Posted on by MZ-18110459-0

My two questions are included in blue below

I have a screen that has 2 sections:

Top Section

Gallery where user selects a record and can click on an edit icon per record

Bottom Section

A form where a user can edit that selected record or edit an existing record.

Adding a record works well.

I am having a problem with the combo box not loading the selection made in the gallery. The other fields on the form including text and toggle load the information, but the combo box is not.

Here is what I have set up:

Edit Icon per row on the Gallery

On Select
- Set(NewSectorSpecificRecord, false);
- Set(varSectorSpecific,ThisItem);
- ResetForm(frmAddSectorSpecific);EditForm(frmAddSectorSpecific);

Form under the gallery
Item Property - varSectorSpecific
Datasource property for the form is List-1
What should the Defaultmode property be set as?
	If(NewSectorSpecificRecord = true,FormMode.New,FormMode.Edit)

	
Combo box in the form
Is not displaying the field relating to the record selected in the gallery.
DefaultSelectedItems property of the Combo box
	Distinct(Filter(List-2,ID=ThisItem.CreditTypeID),Title)
I'm looking up the Title from List-2 for the selected item. The field in List-1 is CreditTypeID and this number is the ID from List-2 ie it simulates a relationship.

	
Items property of the combo box is List-2
Why is the Credit Type combo box blank? It seems to be loading the options to be selected from the lookup, but I want the actual value selected from the gallery above to be in this field when the edit button is clicked.
Thank you for any advice.
 

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (1)

ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

Distinct returns a column called value. What is the primary text of your combobox?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,127 Most Valuable Professional on at

Like (0)

Report
Hi @MZ-18110459-0

Firstly, you need to get away from a Variable being the Item of your Form (query directly to the data source)
LookUp( 'List-1', ID = varSectorSpecific.ID )

DefaultMode does not really matter - you should be calling the mode as you need it - NewForm(YourFormName), EditForm(YourFormName), ViewForm(YourFormName)

The code you have posted looks more like the Items of the Combo Box
Distinct( Filter( List-2, ID = ThisItem.CreditTypeID ), Title )

DefaultSelectedItems will depend on what type of field you are reading from / writing to - I am going to take a guess here it is a Lookup column so it would be something like
{Value: ThisItem.YourLookupFieldName.Value}

Also the Update of the Data Card should then be
{ Value: ComboBoxName.Selected.Value, Id: LookUp( 'List-2', Title = ComboBoxName.Selected.Value ).ID }

An observation (if my guess is correct) - SharePoint Lookup columns are mostly unnecessary with Power Apps and have the potential to cause you unwanted and unneeded complexity and restrictions - I have never used them. It is generally a better idea to get the required field items directly from the second list (you are doing this anyway) with Power Apps and write back to a Text column.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
MZ-18110459-0 45 on at

Like (0)

Report

Thank you, some really good pointers here.

I will change the variable referencing.

In the end, I changed the combo box to a drop down list. I also changed the drop down list Items property to

Distinct(List-2,Title)

and it worked a treat.

Thank you so very much, the responses and support are really strengthening my knowledge and refining my approach to solutions. Its making a big difference - thank you.

Was this reply helpful? Yes No