Look up column issue while patching

[yougan]

I am trying to give column name called "class" which is employee list

this class column comes from list called class. 

But while patching I get the error though I have given correct details in the formulae. Please help what is wrong here. I have attached screenshots

and to recognize look up column in patching do we need to give IDS? is it mandatory?  

[Coopedup]

The attachments will not open...maybe try cut/pasting them again!

[yougan]

[Jitendra_jangid]

Class appears to be a lookup column. Update it like below

 {Class:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                        Id:1,
                        Value:"Class1"}
              }

[Drrickryp]

Heh, another reason not to use SharePoint lookup columns.

[WarrenBelz]

@yougan ,

Just adding to adding to @Drrickryp 's comments, unless you want your users to use SharePoint directly in a Datasheet bulk edit, there is absolutely no reason to have Lookup columns and they will cause you a whole heap of completely unnecessary complication and limitations (Delegation and Filters in particular). Shane Young @Shanescows has made a good video on this.

Apart from this, @Jitendra_jangid 's code below is correct if you want to "hard code" values, but I assume you are wanting to get the value dynamically when a user chooses an item? Also note Id and not ID is used here.

{
   Class:
   {
      '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
      Id:1,
      Value:"Class1"}
   }
}

In case, you need to get the Id of the actual item of the value chosen as it is actually the Id that is being patched primarily - it is the ID of the item in the other list you have looked up.

[yougan]

Hi All,

Thank you all. Noted. 

I am not clear on how to declare this look up, I tried to add class column and its value as per your suggestion, but coming up with below warning/error message. Please help

and one more note I am trying to give manager in patch function. Manager is people picker column giving below error message though I gave all correct values

[WarrenBelz · Accepted solution]

@yougan ,

Looking first at the syntax, you have an extra bracket before Class

It should be

Patch(
   Employee, 
   Defaults(Employee), 
   {
      Title : "666", 
      Favoritecolor : {Value : "Orange"},
      Class:
      {
         '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
         Id:1,
         Value:"Classl"
      }
   }
)

but that is not the real issue if you are going to be selecting Class from a drop-down or such and then Patching the result back to the SharePoint Lookup column. In its simplest form, if you had a dropdown (I will call it ddClass below) with the Items

Choices([@Employee].Class)

which is the way Power Apps would create it, then your Class part of the Patch would be

Class:
{
   '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
   Id:ddClass.Selected.Id,
   Value:ddClass.Selected.Value
}

If however you have sourced the Items differently, then it gets more complex getting the correct Id to Patch back.

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.