Combo Boxes

[Iamglt]

Hi,

I have three Combo boxes out of 6 on my form that when the form opens, the required '*' asterisk is there even though the Combo boxes are populated with values from the SharePoint record.

One Combo-box gets its vales from a SharePoint Person or Group field.

The other two combo boxes are setup so that the secondary combo-box filters it values based on the selection made in the primary combo-box.  These two combo boxes retrieve their vales from a small external SharePoint list, and populate the fields in the main SharePoint list when the form is submitted.

I'm confused as to why some combo boxes seem to recognize they have values and others do not.  Can anyone advise why this would be happening?

Any help is always greatly appreciated.

Cheers,

G.

[v-jefferni]

Hi @Iamglt ,

Could you please share more details? Which combo boxes could not recognize that they have values? What columns types are the columns of the "primary" and "secondary" combo box in each SP list?

I made a test on my end, with a LookUp column look up to text column and a Choices column base on choices column value corresponding to the selected item in LookUp combo box, both are set to required. Everything works fine.

Please share more details about all combo boxes and columns you referred.

Best regards,

Community Support Team _ Jeffer Ni

[Iamglt]

Hi v-jeffern,

Thanks for your reply:

The following screen shot is a visual of what is happening:

This is a record that has already been created, and when in Edit mode, I have to reselect the On-boarding approval manager field, division and business unit fields even though they are already populated from SharePoint.

I have two SharePoint lists, the main list (called onboarding) is where all of the fields on this page save to.  I then have a separate list that populates Division and Business unit combo boxes.  The Business Unit combo box entries are filtered depending on what is selected in the Division field.  The On boarding approval manager is connected to a people and groups and all three fields save back to the onboarding SharePoint list.

The code for the Division list is:

With(
   {wList: NewEmployeeDivisionBusUnitList},
   Sort(
      Distinct(
         wList,
         DropDownDivisionList
      ),
      Result
   )
)

And the code for the Business Unit list is:

 With(
   {
      wNew:
      Sort(
         NewEmployeeDivisionBusUnitList,
         ID,
         Descending
      )
   },
Sort(
    Filter(wNew,
            DropDownDivisionList = ComboBox3.Selected.Result
        ),
        ThisItem.Division
    ).DropDownBusinessUnitList
)

The dfaultselecteditems for each of the fields is:

Onboarding Apporval manager:

{Value:ThisItem.OnBoardingApproval}

Division:

{Value:ThisItem.OnBoardingApproval}

Business Unit:

{Value:ThisItem.BusinessUnit}

Both the Division. Business Unit and onboarding approval manager all write back to text fields.  The Onboarding approval manager populates it combo box from the Office365 connector.

Please let me know if you need any further info.

Cheers,

G. 

Please let 

[v-jefferni · Accepted solution]

Hi @Iamglt ,

Firstly, as you mentioned that Onboarding approval manager is a Text column while the Combo box items is populated with O365Users, if you would like to display the selected user in the Combo box by default, you will need to set DefaultSelectedItems to:

LookUp(FormulaInItemsOfCombobox, DisplayName = ThisItem.DisplayName)

Replace DisplayName with the field name that you submit to the list.

Speaking of the other two combo boxes, similar to above, you need to find a record from the table that is the Items of the combo box, not a single line record like {value: ...}. 

So on your end, Items of Division combo box:

Sort(
      Distinct(
         NewEmployeeDivisionBusUnitList,
         DropDownDivisionList
      ),
      Result
)

DefaultSelectedItems of Division combo box:

LookUp(
       Distinct(
         NewEmployeeDivisionBusUnitList,
         DropDownDivisionList
       ),
       Result = ThisItem.Division
)

DefaultSelectedItems of Business Unit combo box:

LookUp(NewEmployeeDivisionBusUnitList,
       DropDownBusinessUnit= ThisItem.BusinessUnit
)

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[Iamglt]

Thankyou - worked perfectly.  I will study this solution you gave me so I understand it for future reference.

Again, thanks.

[Iamglt]

Hi v-Jefferni,

Hope you can still help me out here, when I implemented the following the DefaultSelectedItems for the Onboarding approval manager:

LookUp(FormulaInItemsOfCombobox, DisplayName = ThisItem.DisplayName)

Inserting the Formula in the Items of ComboBox, the above line becomes:

LookUp(Office365Users.SearchUser({searchTerm:ComboBox3.SearchText}), DisplayName = ThisItem.OnBoardingApproval)

So changing defaultSelectedItems of the Onboarding Approval Combobox from (this line loads the field value from sharepoint, but the required '*' still stays:

{Value:ThisItem.OnBoardingApproval}

to:

LookUp(Office365Users.SearchUser({searchTerm:ComboBox3.SearchText}), DisplayName = ThisItem.OnBoardingApproval)

This now makes the required asterisk disappear, however the saved value in the SharePoint does not load back into the field when I selected a record already created from the gallery.  The Combobox name is Combobox3.

Any ideas on how I can fix this?

Cheers,

G.

[v-jefferni · Accepted solution]

Hi @Iamglt ,

DefaultSelectedItems property of a ComboBox refers to the items (coming from Items property of the ComboBox) default selected when the Control appears, such as Edit Form load or New Form opens. 

Another thing is the Update property of the Data Card. The function is to define what would be update to the data source. As you would like to submit selected manager's display name into SP list Text column, it should be set to:

ComboBox3.Selected.DisplayName

Please have a check.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[Iamglt]

Thankyou for you help - it now works.

Cheers,

G.