Announcements
I have used Combo Box ,That is the lookup field .
On the on change I have I'm collecting all the records into the collection
I want patch the lookup value into Sharepoint
Patch(TopFindings,Defaults(TopFindings),{Title:"",'Finding Test':testCol})
Hi @Anonymous ,
That is because Lookup columns (not the best idea to use with Power Apps unless you really need them to interact directly with SharePoint) are a complex field type containing the ID of the item being looked up in the other list. You also seem to be trying to Patch a collection into the field. What is testCol?
test Col is the collection On the on change function I'm saving the data into the collection
@Anonymous In Sharepoint what type has the field "Findling Test" ? Is this a Text field or a lookup column?
@Anonymous just recognized that it must be a lookup. In order to Patch a lookup column you must pass a record in this format
{
Id:1,
Value: ""
}
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 325 Most Valuable Professional
11manish 165
MS.Ragavendar 88 Super User 2026 Season 1