Answered

Combo Box Result Not Showing on Edit

(0) Share

Report

Posted on by theBrianL

Hi. I have a Combo Box that I created on a Data Card to replace a People field with a dropdown. It shows the dropdown and updates the SP List backend like expected, but when I click on the item in Power Apps to edit, the value that was selected in the Combo Box is blank. I'm using the same form for New and Edit. I added Parent.Default and also tried [Parent.Default] on the DefaultSelectedItems property.
I tried adding another combo box in a people picker data card and it's doing the same thing. What am I missing?

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (1)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Hi @theBrianL On the DefaultSelectedItems property, try:

LookUp('YOUR_SP_LIST', 'YOUR CURRENT RECORD ID' = ThisItem.SP_RECORD_ID, 'YOUR_PEOPLE_FIELD')

-----------------------------------------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
theBrianL on at

Like (0)

Report

I tried this and it's still showing blank. LookUp(Marketing,ID=ThisItem.ID,FMM). Did I do this part right?
I noticed that when I change the Items property to Choices([@MarketingCostShare].FMM) it shows up, but that messes up the whole dropdown. So I don't know if I need an if statement in that field to show Choices([@MarketingCostShare].FMM) only when form is in Edit Mode, otherwise show Sort(FMMList,FMMDisplayName,SortOrder.Ascending)?

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

I have to ask: are you sure the "Update" property of the DataCard is referencing the new field? (assume you're using SubmitForm to save the form)

Was this reply helpful? Yes No
theBrianL on at

Like (0)

Report

This is what I have in the Update field: ComboBox3.Selected.FMM. And when I submit the form it updates the field "FMM".

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

What is the Items property of this Combo Box?

Also, given a form automatically creates a people picker combo box for your people field, there must be a specific reason you're creating another one with the same functionality?

I also assume all of the other data cards are not blank?

Was this reply helpful? Yes No
theBrianL on at

Like (0)

Report

This is the Items Property: Sort(FMMList,FMMDisplayName,SortOrder.Ascending). If I change the Items property to Choices([@MarketingCostShare].FMM) it shows up, but that messes up the whole dropdown.

Yes, I'm using the combo box to select names from another SP List to update the People Field, in order to limit the number of selections. The combo box reference a field called FMMDisplayName, which is a text field. All of the other fields are not blank. Just two combo boxes that do the same function are blank.

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

Well, I wish I started with that question first. A Choices data type returns a TABLE of values. In case of a Person column, it not only returns a TABLE but also a record with different fields in the record. The record will have a pattern which looks like:

      {
         Claims: ,
         Email: ,
         DisplayName:"",
         JobTitle:"",
         Picture:""
      }

A People column will not accept type Text type as an acceptable value. But according to your notes, you have managed to update the People column with a single line Text field. How?

Was this reply helpful? Yes No
theBrianL on at

Like (0)

Report

The single line of Text field that the combo box references are the exact typed names of people i.e. the Display Names. So when it populates the name in the people of the other SP list column it works. That's the only way I could figure out how to make a dropdown for People. I made this work on another App but it had separate screens for edit and new, but it seems there would be a way to just reference that SP Item in a field.

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

That still would not work because as mentioned, when you update a People field it is expecting a type Record and not type Text. Even if that Text value looks the same as the field being displayed (in your case the Display Name) it would still not work.

There must be something else you're doing which is allowing you to update the People field with the value of the dropdown.

Are you using a Patch statement or a SubmitForm?

Was this reply helpful? Yes No
theBrianL on at

Like (0)

Report

After the users fill out the form, they hit the submit button and the On Select is set to SubmitForm(EditFMM).
It's no worries, I may just revert back to using the people picker without the dropdown and have it set to a SP Group. I just like the ease of a dropdown. Thx for all the dialogue. If you think of any ideas to make a limited dropdown people picker, please let me know.

Was this reply helpful? Yes No