Announcements
Hi,
I have to convert the text value to record as I am using patch its throwing error.
I am trying to patch these records in sharepoint site as the datatype I used for second name is lookup
Can you please help me to fix this issue.
https://www.youtube.com/watch?v=wDKuLeK9N9Q
Start Watching from 6:00
Hello @GAbraham,
Please find my blog https://microsoftcrmtechie.blogspot.com/2021/09/how-to-patch-choice-field-and-lookup-in.html
this can help you to patch Lookup and Choice Fields.
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLABlog : https://microsoftcrmtechie.blogspot.com
Hi @GAbraham ,
The issue you have with Lookup fields (I never use them for good reason, but that is another subject) is that they are a table consisting of the field and the ID of the other list looked up in the data source. You would need something like this
Patch( Test2, {Title:DataCardValue15.Selected.Title}, { 'Second Name': { Value:Label2.Text, Id: LookUp( YourLookedUpList, YourLUField = Label2.Text ).ID } } )
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.
Just checking if you got the result you were looking for on this thread. Happy to help further if not.
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 400 Most Valuable Professional
11manish 141 Super User 2026 Season 2
MS.Ragavendar 109 Super User 2026 Season 2