Patch doesnt work on Lookup column

(0) Share

Report

Posted on by lcasey233

Can anyone tell me why the following code doesnt work?

I have a lookup column in SharePoint Called CaseNo
I am simply trying to patch the number 184299 into a new record
The code runs without error, but there is no data placed in the new records lookup field

Patch(
SDF_Schedule,
Defaults(SDF_Schedule),
{CaseNo:
{Id: 184299,
Value: 184299,
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"},Title:184299
}
)

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

mdevaney 29,989 Moderator on at

Like (0)

Report
@Larry_Casey
My 1st idea is: can you please try patching without Title? I don't believe Title is available in a LookUp column.

Patch( SDF_Schedule, Defaults(SDF_Schedule), {CaseNo: { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"} Id: 184299, Value: 184299 } })

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
lcasey233 85 on at

Like (0)

Report
Hello,

Title is a required field in the list. I removed teh requirement for Title and the code does nothing. It does not update the Lookup field.

I used your exact code and nothing gets inserted to the table. What could be causing this?

Patch( SDF_Schedule, Defaults(SDF_Schedule), {CaseNo: { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"} Id: 184299, Value: 184299 } })

Was this reply helpful? Yes No
lcasey233 85 on at

Like (0)

Report

This must be another Power BI outage!! Man, I wish MS could keep these things running properly. There is no reason why this code shouldn't work.

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Larry_Casey

Can you try to update the expression to:

Patch(
SDF_Schedule,
Defaults(SDF_Schedule),
{CaseNo: LookUp(Choices(SDF_Schedule.CaseNo),ID = 184299)}
)

Also. if the title field is still marked as required, then the formula should be:

Patch(
SDF_Schedule,
Defaults(SDF_Schedule),
{

Title: "Value for Title Column",

CaseNo: LookUp(Choices(SDF_Schedule.CaseNo),Id = 184299)}
)

If 184299 is the value of the lookup record then you should use Value instead of Id.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
lcasey233 85 on at

Like (0)

Report

None of this works, Nothing at all gets inserted. I removed the Title requirement and even then it just doesnt work.

This is really annoying as this should be as simple as 123

Was this reply helpful? Yes No
lcasey233 85 on at

Like (1)

Report

Ok ,

here is what worked, I needed to use value = rather than ID =.

But I still dont understand why Microsoft puts out wrong information. No where in their documentation do they tell you to patch using Lookup. Thanks so much for the help though, You must be a really advanced programmer!

Patch(
SDF_Schedule,
Defaults(SDF_Schedule),
{CaseNo: LookUp(Choices(SDF_Schedule.CaseNo),Value = TextInput2.Text)}
)

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (1)

Report

@Larry_Casey
I'm glad you were able to find the answer. My code was tested in a basic proof of concept app so I'm not sure why it did not work on your end, but ultimately, I'm just happy you found the answer.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Larry_Casey

Glad that you were able to resolved. Not an advanced programmer as such. Just some good practice on the Power Platform 🙂

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
lcasey233 85 on at

Like (0)

Report

But the code you gave me is not referenced anywhere on the web. This is the very first web page in the entire world that you provided code that works , but is not documented anywhere.

Its like there is some sort of secret society with special privledges to information that is not given to the general public.

Everywhere and everyone in the entire world has advised to Use :
'@odata.type':"#Microsoft.Azure.Connectors.Sharepoint.SPListExpandedReference"

But you provided a whole new method and so you must be super , super advanced or have access to information others dont.

I really truly appreciate the help. Its just so mind boggling why Power Apps requires so much "Secret" knowledge to use.

Was this reply helpful? Yes No
alrezac on at

Like (0)

Report

Hi,

It looks like you got your issue resolved on patch functions. I just wanted to add in here with a little bit more information if you would like to learn more about them.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No