cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DuncanEddy
Frequent Visitor

Cascading Dropdown Boxes and Sharepoint!

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

 

Capture5.PNG

 

Capture.PNGSharepoint Data CardSharepoint Data CardNormal NON Sharepoint Drop down importNormal NON Sharepoint Drop down importCapture3.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions

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.

563.PNG
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.

564.PNG

 

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,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
DuncanEddy
Frequent Visitor

Can anyone assist? Do you require more information?

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.

563.PNG
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.

564.PNG

 

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,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (94,527)