web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Add a record to a Shar...

Power Apps

Answered

Add a record to a SharePoint lookup column through Power Apps

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have several SharePoint lists where they all refer to different lookup-columns. However, when connecting my lists via these look-up columns in Power Apps I only get a blank cell, and not any lookup/reference value.

I have tried to use many different approaches as Patch, Collect, Lookup, Choices etc. My last try was a Patch-function.

Patch(List, Defaults(List), {Name:NameTextBox.Text, Space:SpaceTextBox.Text, LookUpColumn: LookUp(OwnerList, ID = Owner.ID)});

Can someone please help me?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Here is the syntax of Patch LookUp column:

Patch( list, Defaults(list), {Lookup:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id:Gallery1.Selected.ID, Value:Gallery1.Selected.Title} } )

On your end, you could try the LookUp column values as well:

Patch(List, Defaults(List), { Name:NameTextBox.Text, Space:SpaceTextBox.Text, LookUpColumn: LookUp(Choices(LookUpColumn), Id = Owner.ID) } );

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No

Join the conversation