Cascading Dropdown Boxes and Sharepoint!

[DuncanEddy]

Hey,

I cannot get my SharePoint data card to show the output of the cascading drop down. The share point data card does pull the data through because the output's dropdown gets larger and smaller when I click through the different fleet categories.

When I test the code with a normal(NON-Sharepoint) dropdown/combo/list box it works fine.

I have narrowed it down to:

The share point data cards do not have "Value" in them but the normal default ones do. (Picture will explain). Only reason I think this is because the normal drop down behaves the exact same way as the share point drop down until I put the "Value" in.

After all of this I was happy but my normal drop down does not upload back onto the share point list

Sharepoint Data CardNormal NON Sharepoint Drop down import

[DuncanEddy]

Can anyone assist? Do you require more information?

[v-yutliu-msft · Accepted solution]

Hi @DuncanEddy ,

Do you mean that the combo box of machine model could not display value correctly?

Could you tell me:

1)the data type of fleet category field?

2)the data type of machine model?

3)the Items of fleet category combo box?

4)whether this form is used to create new item or edit an existing record?

Firstly, what you are talking about should be listbox and combo box.

These two kinds of controls are different.

To set listbox's which field to display, you should set its Value property.

To set combo box's which field to display, you should click "edit", then set its primary text and searchfield.

The primary text is the field to display, the searchfield is the field to search.

Secondly, how to set the combo box?

This is related to the fields data type. I will wait for your reply.

Based on the formula that you provide, the combo box's DefaultSelectedItems should be set to :  ThisItem.

Choose machine model as the primary text of the combo box.

Best regards,