Value connected to cascading list is not shown when I submit my record

[beysinguzel]

Hello, 

I have an issue regarding the cascading list is not working properly when I submit the form. As you can see in the below images, whenever I select my field and click the submit button, I can not see in my list view and then when I click to edit my form, I can not the selected values in the field

  

[Amik]

@beysinguzel -

1. Is Cascading List-LEAN & Plymouth a separate SharePoint list?
2. What do you have in the Update and Default properties of the Product Part Number DataCard?

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

[beysinguzel]

Hi @Amik ,

Yes they are seperate SharePoint list. Below I can share the default and Update properties of the product part number card?

[Amik]

@beysinguzel - what is the field type for Product Part Number in SharePoint? Is it a Choice field? If yes, is it a single select or a multi-select field?

[beysinguzel]

@Amik  - Its Choice field and multi select field

[Amik · Accepted solution]

Hi @beysinguzel .

As I understand it based on your responses.

You have a SharePoint List (List 1) with two multi-select Choice fields. Product Name and Product Part Number. These Choice fields are represented as Combo Boxes in your App.

You have another SharePoint List (List 2) which displays each Product Name and it’s associated Product Part Number.

In your App, if a user selects a Product Name, or multiple Product Names, the Product Part Number should only display the associated Product Part Numbers based on SharePoint List 2.

The above is working for you, but you’re having issues submitting the selected Choices in the Product Part Number Combo Box to List 1.

Keep the Default and Update properties of the DataCard as they are, but change the Items property of your Product Part Number Combo Box to :

Distinct(
    Filter(
        'Cascading List-LEAB & Plymouth',
        'Product Name' in Concat(
            DataCardValue11.SelectedItems,
            Value,
            ""
        )
    ),
    'Product Part Number' //the name of your product part number field in Cascading List-LEAB
)

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

[beysinguzel]

Thank you so much Imran-Ami Khan!

You saved my time much more than expected, The issue is fixed now

Have a lovely day,