Unanswered

Not Able to set Default value of custom combobox from sharepoint single line of text

(0) Share

Report

Posted on by CCJones

244

I have a solution where I am using a SharePoint list as the source for a combobox to lookup values in a form. The SharePoint lookup list has multiple columns, one being a department and another being an email address. When the user selects a specific department from the combobox, the email address associated with that department is added to an adjacent field and a notice gets sent to that email when the request is submitted. Initial submission works fine.

The problem I am having is that when I try to set the default value of the combobox control to "Parent.Default", I get an error that it is expecting a table. I am not sure what to do in order to make this work. I tried enclosing Parent.Default in square brackets and in another instance tried enclosing ThisItem.'Division / Department' in square brackets. This gets rid of the error, but then the value doesn't always show up in the form after submission.

How can I ensure that the value stored in the single line of text field from the combobox is displayed as the default when the form is opened after submission?

Thanks in advance for any help!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

CCJones 244 on at

Like (0)

Report
Copy link

Link copied!

Neither of these options have worked for me. They just come up empty in the form even though there is a value in the column. I've found that since I don't need to display any of the additional values from the lookup list in the actual combobox, it's easier to just use a dropdown instead. That gives me no errors regarding "expected a table".

Was this reply helpful? Yes No
alecolli2 75 on at

Like (0)

Report
Copy link

Link copied!
No problem, I should have guessed as you have other comboboxes!

If you are doing a lookup that returns a result, try the below syntax and see if you have any luck -

{Result: ThisItem.'Division/Department'}

Alternatively, if your ComboBox returns a "value", then try the below

{Value: ThisItem.'Division/Department'}

This has worked in forms I have used!

Was this reply helpful? Yes No
CCJones 244 on at

Like (0)

Report
Copy link

Link copied!

Sorry, I should have indicated that I was using DefaultSelectedItems and not just Default. The screenshot below shows that I get this error when using ThisItem.'Division / Department' and that I don't get the error when using [ThisItem.'Division / Department']. It's the same when using Parent.Default.

Was this reply helpful? Yes No
alecolli2 75 on at

Like (0)

Report
Copy link

Link copied!

@CCJones

With ComboBoxes the "Default" value doesn't achieve the same goal as dropdowns and text boxes. You should use the "DefaultSelectedItems" property instead.

Try with the "Parent.Default" in this property instead and see if this helps

If this answered your question, please mark it as Solved

Was this reply helpful? Yes No