Cascading Combox doesn't save the data into the sharepoint list

(0) Share

Report

Posted on by dhruvatej

Hi All,

Hope this finds you well.

Issue: Data of a cascading combo box is not populating in the list after saving.

Description: I have created a dropdown - CATEGORY ( It has Choices) and a cascading combo box - TOPIC. I have been successful in selecting the multiple items in my combo box, however I do not see the data in my form upon saving.

I have the below lists: Categories & Topics (Lookup table sharepoint list)

Topics (Column Type: Multiple lines of Text), Category (Column Type: Choice)

The below list is where I will need the data to be saved, TOPIC_EBLAST column doesn't save/show the selected multiple items upon saving in the APP. However, the TOPIC_EBLAST(Column Type: Multiple lines of text) shows the same value as CATEGORY_EBLAST (Column Type: Choice)

Dropdown formula: Choices([@'Data Form'].CATEGORY_EBLAST)

Combo Box formula: Filter('Categories & Topics',Category.Value =DataCardValue8.Selected.Value)

In Power APP: TOPIC_EBLAST is empty upon selecting mulitple items and saving

Any assistance is much appreciated.

Thank you

Categories:

Building Power Apps

All responses (11)

Answers (0)

Sort by

WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @dhruvatej ,

What is the Update of both data cards, exactly what are you want to save form and to? I assume a single choice from the drop-down to the Choice field and multiple choices from the combo box to the multi-line text field?

Also what is the Default (drop-down) and DefaultSelectedItems (Combo Box)
dhruvatej 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz,

Thank you for the quick turnaround.

Update for CATEGORY_EBLAST DROPDOWN (SINGLE CHOICE): DataCardValue8.Selected
Update for TOPIC_EBLAST COMBO BOX (MULTIPLE SELECTION): DataCardValue8.Selected.Value

Default(DROPDOWN): ThisItem.CATEGORY_EBLAST
DefaultSelectedItems(COMBO BOX) is empty as below

- I am trying to create a record in the Power App and see the record in the "Data Form" (A sharepoint List)
- Categories & Topics (Sharepoint List) I have created for cascading purpose.
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@dhruvatej

As per the expression, it only allows single selection:

Update for TOPIC_EBLAST COMBO BOX (MULTIPLE SELECTION): DataCardValue8.Selected.Value

Can you please update it to

Update for TOPIC_EBLAST COMBO BOX (MULTIPLE SELECTION): DataCardValue8.SelectedItems.Value

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
dhruvatej 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yashag2255

Thank you for responding to my post.
I have updated as suggested and see the below error

Thanks
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@dhruvatej

Can you share error details? You can hover over the red line and get the error details. Can you also confirm if the field where you are trying to patch multiple selection is defined as a multi-select field?

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
dhruvatej 10 on at

Like
a
(0)

Report
Copy link

Link copied!

@yashag2255
Please see the below error message on the extreme right of the image. Yes, the SelectMultiple is True.
dhruvatej 10 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Could you please help me on this?
WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@dhruvatej ,

Can you please explain exactly what type of control (and the output) you are trying to save to exactly what type of field (and provide the names of the controls and fields).
dhruvatej 10 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
I am trying to use a cascading combo box (for me to select multiple items) with a dropdown (only single select). When I select a choice in dropdown, I should be able to see the items of respective dropdown choice in the combo box. Select multiple items in combo box and be able to save the data into the list.

Two Data Sources:
List1:
List 1 is where I need to see the saved data after saving in the Power APP. If you see TOPIC_EBLAST column, I am able to select only single item. I am trying to save this column with Multiple items.
List 2: The below list has multiple topics for a single category, In Power App Cascading combo box is looking into this list.
WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@dhruvatej ,

So this is not confused any further - can you please list exactly the following (I don't need any pictures) for EACH of the controls: -

The type of control (combo box etc)

The Items and Name of the control

The Output of the control (ControlName.Selected.xxxx)

Whether it is single or multi-select

The Name of the field it is writing to

The Type of field it is writing to (single/multi-line text, single/multi choice etc)

The Update and Name of the Data Card the control is in.