Cascading Dropdown custom card from a lookup column

[MOHD78]

I have two lists. One is called Purchase Request. the other is called Description List.

The main list is the purchase request. and I have a lookup column called model-description. I created a cascading dropdown custom card. so when I select the model description it should auto-populate 3 other fields on my customs form. the pother field or data card called NS, PART#, PRICE.

I used the distinct formula and it did work fine with the auto-populated info. but when submitting the form using a button. none of these fields are saved on the SharePoint list. 

when tried to check the value of the card. there was no card value in any of the fields that I have created as dropdowns. because the text field didn't work with cascading.

Please help

[v-bofeng-msft]

Hi @MOHD78 :

Can you provide detailed settings for your app?
What are the data types of these three fields(NS, PART#, PRICE.)? How are the three data cards set up now?

In addition, if you want to update the lookup column, the value should be in a specific format:

If the lookup column do not allow multiple selections:

LookUp(Choices(SPList.LookupColumn),Value="SearchText")

If the lookup column do allow multiple selections:

Filter(Choices(SPList.LookupColumn),Value="SearchText")

Best Regards,

Bof

[MOHD78]

The price is Currency, NS single line, part# single line too. I added a dropdown from the input.

Distinct('Part Lookup', 'Description')

Distinct(Filter('Part Lookup', 'Description'=Dropdown3.Selected.Result),NS)

Distinct(Filter('Part Lookup', 'Description' = Dropdown3.Selected.Result),'Part')

Distinct(Filter('Part Lookup', 'Description' = Dropdown3.Selected.Result),'Price')

All the formula worked find when I implemented. the problem that the data not saved when I submit the form. When you check the SP List, It will includes all the field on the app without the 4 field above.

The button formula are 

SubmitForm('Purchase Request');Exit()

[v-bofeng-msft · Accepted solution]

Hi @MOHD78 :
Could you please tell me:

Have you check the datacard's Update property?(The value submitted by SubmitForm is actually the value in the datacard Update property)

Best Regards,

Bof 

[MOHD78]

So I have updated the three fields with the update control and it did work for the NS, PART#, PRICE. and it did save the information on SPO. but the main dropdown which is the description didn't save or show anything on SPO. I mean when I tried to Update the with( dropdown3.selectedtext.value) it didn't work. I did dropdown.selectedtext and didn't save the field that it should be the Main field that when I chose should auto populate the other fields.

Is there anything I need to update. or change. Also when trying to edit the form in SPO. I have the second screen should open. but it still open with the initial screen which is I don't need to edit the form with it.

[MOHD78]

@v-bofeng-msft Thank you for your instruction. I still have one thing on the dropdown.

the model-description update control. not saving the data yet and it does give an error formula when trying to update it.

Dropdown3.SelectedText

when I add Dropdown3.SelectedText.result or Dropdown3.SelectedText.value it gave an error 

and do not forget this is the main lookup dropdown field I have. so when I choose this field it should populate the other fields which is it does do that but without saving the Model-Description selected on SPO.

Thanks for the help in advance