Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Set the lookup value using patch

(0) ShareShare
ReportReport
Posted on by 3,251

Hello,

 

I have two tables and having hard time trying to figure out the relationship.

 

I need to be able using my form to save an item that is linked with the other table like MS access or EDIT.

 

Picture1.png

Categories:
  • Sajarac Profile Picture
    Sajarac 3,251 on at
    Re: Set the lookup value using patch

    WOW!!!!!

     

    That was super fast!!!

     

     

  • Verified answer
    KrishnaV Profile Picture
    KrishnaV 5,023 on at
    Re: Set the lookup value using patch

    Hi @sajarac ,

     

    Please try the below:

    Patch(
     'Order List',
     Defaults('Order List'),
     {
     Title: TextInput16.Text,
     ItemID: {
     '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
     Id: LookUp(
     'Master List',
     Title = Dropdown6.Selected.Title,
     ID
     ),
     Value: Dropdown6.Selected.Title
     }
     }
    )


    I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

    Regards,
    Krishna
    If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

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,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard