Unable to PATCH to multiple Lookup columns in SharePoint

(0) Share

Report

Posted on by Data_Enthusiast

383

Hi Power Apps Community,

I am trying to Patch one item from Power Apps to SharePoint. However, the SharePoint List which I am Patching to has 2 Lookup fields and one field which is a 'Person' type.

I am using the following, but have been unsuccessful so far.

Patch('SPLIST',
 Defaults('SPLIST'),
 {
 Field1:Office365Users.MyProfileV2().displayName,
 'Field2': 
 {ID:ID,
 Value: dropwdown.Selected.'Title',
 '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
 },
 'Field3': 
 {Id:ID,
 Value: dropdown.Selected.ID,
 '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
 }
 }
 )

These are the errors I am picking up:

I would appreciate any assistance.

Thank you in advance.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Data_Enthusiast ,

Here is your formula:
Patch('SPLIST', Defaults('SPLIST'), { Field1: {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims:"i:0#.f|membership|" & User().Email, Department:"", DisplayName: User().FullName, Email: User().Email, JobTitle:"", Picture:"" }, 'Field2': {Id:ID, Value: dropwdown.Selected.'Title', '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference" }, 'Field3': {Id:ID, Value: dropdown.Selected.ID, '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference" } } )
Hope it works and helps !
Data_Enthusiast 383 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @gabibalaban
Thank you for the response.
I tried the code provided, but receive the following error messages:
I tried to replace the 'ID' value with a numerical value, but still received the same error message.
Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Data_Enthusiast

Sorry for my rushed answer,

your error came from this 2 data... you need to identify the correct Id from list where lookup column is taken the data. The two Id and Value has to be identical with the one from where lookup column is taken the data.
Data_Enthusiast 383 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @gabibalaban
No problem at all. Thank you! This helped me identify the issue 🙂