web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Set the lookup value u...

Power Apps

Answered

Set the lookup value using patch

(0) Share

Report

Report

Posted on by Sajarac

3,276

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.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

KrishnaV 5,023 on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Sajarac 3,276 on at

Like (0)

Report
Copy link

Link copied!

WOW!!!!!

That was super fast!!!

Was this reply helpful? Yes No

Join the conversation