Power Platform Community Forum Thread Details

Hi,

I have this syntax where I created UpdateContext from a SharePoint list called MasterList to use it in my combobox in another list called DetailList. I created also a collection hoping that I can patch it.

LookUp('Master List', ID = DataCardValue70.Selected.Value);
UpdateContext(
 {
 PrimaryInspectionName: LookUp('Master List', ID = DataCardValue70.Selected.Value).'Primary Inspection Name',
 SecondaryInspectionName: LookUp('Master List', ID = DataCardValue70.Selected.Value). 'Secondary Inspection Name'
 }
);
ClearCollect(collectInspector,[PrimaryInspectionName,SecondaryInspectionName])

But this is creating an error.

 Inspector:ForAll (DataCardValue40.SelectedItems, 
 {
 '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", 
 Value:collectInspector.Value 
 }
 ),

Can someone help me how to do the Patch? Thank you 🙂

Regards,

May

Categories:

Building Power Apps

@mayarnaldo

It is hard to tell the complete context of what you are doing and how. But, after reading through and imagining your scenario, I would suggest the following:

1) Set the Items property of your DataCardValue40 to the following:

With({record: LookUp('Master List', ID = DataCardValue70.Selected.Value)},

 Table(
 {Value: record.'Primary Inspection Name',
 '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser"},
 {Value: record.'Secondary Inspection Name',
 '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser"}
 )
)

I assume that your Inspector columns is a Multi-Select Choice column in your list. If so, then the following in your Patch should give you what you want:

Patch(....
...,

 Inspector: DataCardValue40.SelectedItems,

...
)

However, I would question why a Patch when it appears that you are using an EditForm which has a SubmitForm function.

I hope this is helpful for you.

Community site session details

Patch Collection

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates