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 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
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.
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
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()
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
Hi @MOHD78 :