cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
statuko
Regular Visitor

Combobox not showing value in Form Edit

Hello,

 

Challenge

I have a SharePoint with a custom Form. The form requires a 'Resident Full Name'. To avoid our staff entering the same individual but with different spelling, I made the 'Resident Full Name' a combo box that pulls the previously entered 'Resident Full Name' for suggestion. The suggestion function works.

However, when I choose to edit the item from the SharePoint list, the Combobox doesn't pull the data I previously save when filling out the form. It shows empty.

Error

Screenshot_6.pngScreenshot_7.png

The value "asdasdfdg" isn't showing in 'Resident Full Name'.

 

The Current Setup

The Form

Screenshot_4.png

 

Resident Name card Tree

Screenshot_5.png

'Update' propriety of 'ResidentName_DataCard1'

If(
IsBlank(ComboBox1.Selected.ResidentName), 
ComboBox1.SearchText,
ComboBox1.Selected.ResidentName
)

'Items' property of 'ComboBox1'

Screenshot_8.png

 

Please let me know if there is any other value I should share.

 

Looking forward to understand what I did wrong.

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Combobox not showing value in Form Edit

Hi @statuko 

The Default selection should be from combobox Items, so the most versatile way is to Lookup from Combo box Item.

Please modify the DefaultSelectedItems property as below:

 

 

LookUp([@'Post-Fall Reports'].ResidentName, ResidentName=ThisItem.ResidentName)

 

 

Hope this helps.

Sik

 

View solution in original post

8 REPLIES 8
WarrenBelz Community Champion
Community Champion

Re: Combobox not showing value in Form Edit

HI @statuko ,

 

Make the DefaultSelectedItems of the ComboBox Parent.Default

 

Please click Accept as solution 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 Thumbs Up.

statuko
Regular Visitor

Re: Combobox not showing value in Form Edit

Hi @WarrenBelz ,

 

Thank you for the reply.

Unfortunately that did not solve it. The form is behaving the same, but I get the red X beside the Combobox when DefaultSelectedItems is set to Parent.Default

WarrenBelz Community Champion
Community Champion

Re: Combobox not showing value in Form Edit

OK @statuko ,

By your image, ComboBox1 is in ResidentName_DataCard1  - you should not get an error on Parent.Default as it is simply taking the Default value of the card. A bit strange, but try ThisItem.ResidentName.

Also turn off the Allow Multiple Selections (Set SelectMultiple to false).

 

Please click Accept as solution 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 Thumbs Up.

statuko
Regular Visitor

Re: Combobox not showing value in Form Edit

Hi @WarrenBelz,

 

Thank you for the fast replies!

I have tried those settings but without success. Still the same behavior.

However I figured out that my team member who originally created the SharePoint list and the form in fact used the 'Title' column from SharePoint and renamed it as 'ResidentName'. I'm unsure if this could be the source of the strange behavior.

 

Screenshot_2.png

 

Thanks.

WarrenBelz Community Champion
Community Champion

Re: Combobox not showing value in Form Edit

Hi @statuko ,

Absolutely - now that I see the error.

Should be ThisItem.Title

 

Please click Accept as solution 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 Thumbs Up.

Community Support
Community Support

Re: Combobox not showing value in Form Edit

Hi @statuko 

The Default selection should be from combobox Items, so the most versatile way is to Lookup from Combo box Item.

Please modify the DefaultSelectedItems property as below:

 

 

LookUp([@'Post-Fall Reports'].ResidentName, ResidentName=ThisItem.ResidentName)

 

 

Hope this helps.

Sik

 

View solution in original post

statuko
Regular Visitor

Re: Combobox not showing value in Form Edit

@v-siky-msft That worked! Thank you for your help!

statuko
Regular Visitor

Re: Combobox not showing value in Form Edit

Hi @WarrenBelz,

I tried it, unfortunately it didn't work. I was still getting the error in PowerApps, but I I still gave it a try and the form wouldn't populate.

Can't thank you enough for the fast replies and suggestions!

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (9,324)