Unanswered

Sharepoint List Patch Lookup Columns

(0) Share

Report

Posted on by cbmarsh

I am trying to update a record to a Sharepoint List that contains only Lookup Columns (using it as a relationship table):

Patch(CorpsGroupMembers,
Defaults(CorpsGroupMembers),
{GroupID: LookUp(CorpsGroups, ID = glrGroupList.Selected.ID).ID,
MemberID: LookUp(CorpsDirectoryList, ID = drpSpareMemberList.Selected.ID).ID
}
)

Individually, each Lookup works in a text field to see results, but I can't get it to work as a Patch statement.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @cbmarsh ,

If GroupID is a lookup column (do not allow multiple selections) , the formula should be:

GroupID: {Id:LookUp(CorpsGroups, ID = glrGroupList.Selected.ID).ID}

Best Regards,

Bof

Was this reply helpful? Yes No
cbmarsh 10 on at

Like
a
(0)

Report
Copy link

Link copied!

I changed the list to only have one lookup column, MemberID. I amended the Patch to this:

Patch(CorpsGroupMembers,
Defaults(CorpsGroupMembers),
{GroupID: 1,
MemberID: {MemberID::LookUp(CorpsDirectoryList, MemberID = drpSpareMemberList.Selected.ID).ID}
}
)

I get this:
The Type of this argument 'FullName' does not match the expected type 'Record'. Found type 'Error'.

I presume this is the MemberID Lookup column, as that is the only complex column.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @cbmarsh ,

Please try:

Patch( CorpsGroupMembers, Defaults(CorpsGroupMembers), { GroupID: 1, MemberID:{Id:LookUp(CorpsDirectoryList, MemberID = drpSpareMemberList.Selected.ID).ID} } )

In addition , there is no such an argument named 'FullName' in the formula you mentioned.

Best Regards,

Bof

Was this reply helpful? Yes No
cbmarsh 10 on at

Like
a
(0)

Report
Copy link

Link copied!

FullName is a list column.

Was this reply helpful? Yes No
cbmarsh 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. I have done as asked. However, I still get errors. "The Function 'Patch' has some errors." "Invalid argument type. Expecting a Record value, but of a different schema." "Missing column. Your formula is missing a column 'Value' with a type of 'Text'."
The Sharepoint List 'CorpsGroupMembers' is defined as:
GroupID (number, no decimal places)
MemberID (Lookup - Column ID from Sharepoint List CorpsDirectoryList.)
This Lookup in this list returns columns:
MemberID:Mobile
MemberID:Phone Number
MemberID: Email
MemberID: FullName
MemberID:FulAddress

When updating the list, I only have to enter the GroupID and Lookup the MemberID and the rest populate automagically.

Having 'GroupID: 1,' is just an example of a GroupID.

Was this reply helpful? Yes No