cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent 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
Highlighted
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
Highlighted
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.

Highlighted
Frequent 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

Highlighted
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.

Highlighted
Frequent 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.

Highlighted
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.

Highlighted
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

Highlighted
Frequent Visitor

Re: Combobox not showing value in Form Edit

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

Highlighted
Frequent 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
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (10,751)