Power Platform Community Forum Thread Details

I'm trying to patch multiple items in a SharePoint list.
My issue is to use LookUp to find the correct items to patch.

I have a collection with the items collected that i want to patch to a lookup column.

ForAll(
ClearCollect(RelatedTicketsCol5, varSelectedTicketProblem.'Related Tickets');
Collect(RelatedTicketsCol5, DataCardValue29_1.SelectedItems),

{
 Id: DataCardValue29_1.Selected.Id,
 Value: DataCardValue29_1.Selected.Value

});

ClearCollect(RelatedTicketsCol6, ForAll(Distinct(RelatedTicketsCol5, ThisRecord),ThisRecord.Result));

My next step is to LookUp all the items I wish to Patch.
Basically I want to patch all the items in the collection RelatedTicketsCol6 with the Id and value from the the Item I'm using.

How do i lookup all the Items in the SharePoint list i tried using LookUp but i always end up with Invalid type due to collection is a table and I'm looking up a Text value.

LookUp(SharePointList, TicketID = RelatedTicketsCol6.Value, the value contains the text that equals the TicketID, but TicketID is a text field. I want to do a ForALL so i patch all items in with the same value

Categories:

Building Power Apps