Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Lookup field in edit form to populate 1 depending on selection of the other

Posted on 20 Nov 2024 20:43:05 by 302
I have a Form (Form3) with the Lookup Fields in my list "Weekly Reports"

Services (Combobox) (DataCardValue11)
Services: Pricing (Single line of text) (DataCardValue12)

They are both from my list "Contract Pricing" 

I would like Services: Pricing (DataCardValue12) to populate based on what I choose in Services (DataCardValue11)

How can I achieve this?
Categories:
  • ronaldwalcott Profile Picture
    ronaldwalcott 660 on 22 Nov 2024 at 01:55:03
    Lookup field in edit form to populate 1 depending on selection of the other
    You can set the default value of Pricing to this
    ComboBoxName.Selected.theColumnName - the column name used for the dropdown
  • honganhuynh1 Profile Picture
    honganhuynh1 302 on 21 Nov 2024 at 14:15:07
    Lookup field in edit form to populate 1 depending on selection of the other
    Data source is Sharepoint @rondaldwalcott
  • ronaldwalcott Profile Picture
    ronaldwalcott 660 on 21 Nov 2024 at 06:11:31
    Lookup field in edit form to populate 1 depending on selection of the other
    What is the data source SharePoint or Dataverse and how is the data linked?
  • Meekou Profile Picture
    Meekou 116 on 21 Nov 2024 at 06:01:20
    Lookup field in edit form to populate 1 depending on selection of the other
    Could you share the logic for DataCardValue12 based on DataCardValue11?
    Share the demo data for your list.
    In general, if you want to fill up DataCardValue11 based on DataCardValue12? You will need to map relationship between DataCardValue11 and DataCardValue12, and then query the relationship table based on DataCardValue12, and then assign query result to DataCardValue11.
    Regards,
    Meekou
    Personal Support

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

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,051

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,793

Leaderboard