Prepopulate combobox with text item from sharepoint list

[TomSkelton]

I am trying to prepopulate an edit form with the data that is stored in a sharepoint list.

I have the patch form working correctly for a new form.

But when i have the edit form open some items prepopulate, some don't.

One field i'm having issues with is a job title field which is pulling information from another list based on the department value.

The items setting for this is:

Filter('Job Descriptions - Job Codes', Department = DataCardValue14_1.Selected.Value)

The item is stored in the sharepoint list as a text item when a new form is created.

How can i make this so that when the edit form is selected that the stored text item is shown in this combo box rather than blank?

I also have a similar issue with a location field box.

[Amik]

@TomSkelton - if you want the ComboBox to return a record, it is important that the Items property of your ComboBox control and the DefaultSelectedItems property share the same table schema.

Try applying the below to the DefaultSelectedItems property of the ComboBox control:

LookUp(
    Filter(
        'Job Descriptions - Job Codes',
        Department = DataCardValue14_1.Selected.Value
    ),
    'Job Title' = Parent.Default
)

For Single Line Text data types, an alternate option is to simply force a Value to be displayed:

{Value: Parent.Default}

[TomSkelton]

Hi Imran-Ami,

I've entered this, but this still doesn't load the selected item in the dropdown box.

How i have this configured is on a new form the user selects the department and then the available job titles appear that are in that department. There is then a hidden text input field that copies the selected item and that is what is populated in the sharepoint list which is a text column.

What i want is that if this form is rejected it allows the user to edit that form and load the form with what was submitted. I've entered the provided code into the Items and DefaultSelectedItems but this still doesn't load the selected job title in the combo box, nor does it then show the other available items when hitting the drop down.

[mmbr1606 · Accepted solution]

hey @TomSkelton 

can u try this:

DefaultSelectedItems: LookUp('Job Descriptions - Job Codes', JobTitle = Parent.Default)

Items: Filter('Job Descriptions - Job Codes', Department = DataCardValue14_1.Selected.Value)

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.



Greetings

[TomSkelton]

Please see the screenshots below, this isn't working for some reason.

On clicking edit pencilDisplay Form

[TomSkelton]

sorted it:

LookUp('Job Descriptions - Job Codes', 'Job Title' = Parent.Default

[TomSkelton]

i'm also trying to do the same for the Location option:

items: ["Belgium", "Czech Republic", "France", "Germany", "Hungary", "Italy", "Netherlands", "Poland", "Spain", "United Kingdom", "United States", "Other"]

this again is populating a text box in the sharepoint list, if Other is selected a text input is shown for free text to be added. 

What would be the best way to manage this?