Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Cascading Dropdown custom card from a lookup column

(0) ShareShare
ReportReport
Posted on by 56

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

 

 

 

  • MOHD78 Profile Picture
    MOHD78 56 on at
    Re: Cascading Dropdown custom card from a lookup column

    @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

     

  • MOHD78 Profile Picture
    MOHD78 56 on at
    Re: Cascading Dropdown custom card from a lookup column

    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.

     

     

  • Verified answer
    Re: Cascading Dropdown custom card from a lookup column

    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)

    vbofengmsft_0-1646013177560.png

    Best Regards,

    Bof 

  • MOHD78 Profile Picture
    MOHD78 56 on at
    Re: Cascading Dropdown custom card from a lookup column

    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()

     

  • Re: Cascading Dropdown custom card from a lookup column

    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 :

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard