Answered

Combo box Not Saving to SharePoint From Several Other Lists

(0) Share

Report

Posted on by KHenderson

I have form that has a combo box that looks up names and employee numbers (fills another card). It will save to the sharepoint list but when in edit mode the fields are blank. I have 3 fields like this.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @KHenderson ,

Which type column do you use to store the ComboBox Selected value? Text column or Choice type column or Person type column?Could you please share a bit more about the formula you typed within the Items property of the ComboBox?

1. If you use Normal Text type column to store the ComboBox Selected value:

Set the Update property of the Data card which contains the ComboBox to following:

ComboBox1.Selected.ColumnName

Set the DefaultSelectedItems property of the ComboBox to following:

{ ColumnName: ThisItem.SPListTextColumn }

Note: The ColumnName represents the column you used as Display value within the ComboBox.

2. If you use Choice type column to store the ComboBox Selected value:

Set the Update property of the Data card which contains the ComboBox to following:

{ Value: ComboBox1.Selected.ColumnName }

Set the DefaultSelectedItems property of the ComboBox to following:

{ ColumnName: ThisItem.SPListChoiceColumn.Value }

Note: The ColumnName represents the column you used as Display value within the ComboBox.

3. If you use Person type column to store the ComboBox Selected value:

Set the Update property of the Data card which contains the ComboBox to following:

{ Claims: "i:0#.f|membership|" & Lower(LookUp(Office365Users.SearchUser(), DisplayName = ComboBox1.Selected.ColumnName, Mail)), DisplayName: ComboBox1.Selected.ColumnName, Email: LookUp(Office365Users.SearchUser(), DisplayName = ComboBox1.Selected.ColumnName, Mail), Department: "", JobTitle:"", Picture:"" }

Set the DefaultSelectedItems property of the ComboBox to following:

{ ColumnName: ThisItem.SPListPersonColumn.DisplayName }

Note: The ColumnName represents the column you used as Display value within the ComboBox.

Please consider take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
KHenderson 14 on at

Like (0)

Report
Copy link

Link copied!

Greetings,
Thank you for the help I think I am almost there. I would like to store/save my ComboBox Selected values Text(columns) and Number(columns). My Combobox items property is connected to a SharePoint collection(Lists are independent of Office 365).
I am trying to get datacard11=John Doe, datacard12=1 to save and be able to save in edit mode. The second value is not keeping its value it is blank in the edit mode.

SharePoint List/Collection
FullName EmployeeID
John Doe 1
Jim Bob 2
Ect…

*This works for a single selection but I am trying to get the name to one Card and the number in another Card(From SharePoint List).
Worked
update:ComboBox1.Selected.ColumnName
DefaultSelectedItems: {
ColumnName: ThisItem.SPListTextColumn
}

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @KHenderson ,

Could you please share a screenshot about your Edit form?

Do you mean that the two ComboBox Items property connect to same SP Collection/List?

Could you please share more details about the formula typed within the Items property of the second ComboBox?

I have made a test on my side, please consider take a try with the following workaround:

Set the Items property of the first ComboBox to following:

Distinct('SP Collection', FullName)

set the Result as display value within the ComboBox.

Set the DefaultSelectedItems property of the ComboBox to following:

{ Result: ThisItem.FullNameColumn }

Set the Update property of the Data card (DataCard11) which contains the first ComboBox to following:

FirstComboBox.Selected.Result

Set the Items property of the second ComboBox to following:

Distinct('SP Collection', EmployeeID)

Set the DefaultSelectedItems property of the ComboBox to following:

If( EditForm1.Mode = FormMode.New, { Result: LookUp('SP Collection', FullName = FirstComboBox.Selected.Result, EmployeeID) }, { Result: ThisItem.EmployeeIDColumn } )

Set the Update property of the Data card (DataCard12) which contains second ComboBox to following:

SecondComboBox.Selected.Result

Please consider take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No