Update multiple sharepoint list items with Patch

(0) Share

Report

Posted on by Lijo

Hello,

Based on below article I tried to update few records in my sharepoint list, however I received error message "Incompatible types for comparison. These types can't be compared: Text, Table".

Create or update bulk records in Power Apps - Power Apps | Microsoft Learn

My temporary collection was based created based on Defaults from sharepoint list, so I also tried to update it by below code:

Patch( 'SharePoint List', TempCollection)

I would appreciate any advices about this.

My code:

 ForAll(
 Filter(TempCollection, 'Serial Number' <>Blank()),
 Patch(
 'SharePoint List',
 LookUp('SharePoint List','Tool Serial Number'=TempCollection[@'Serial Number']),
 {
 Status: {Value:"In Service"}
 }
 )
 );

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Lijo,

If the collection and SharePoint list completely matches column-wise, the first function should work. However, bulk patching can also be done with ForAll statements and is required when the collection does not 100% match the SP list.

In your case the following adjustments to your ForAll should work:
ForAll( Filter(TempCollection, 'Serial Number' <> Blank()) As Main, Patch( 'SharePoint List', LookUp('SharePoint List','Tool Serial Number' = Main.'Tool Serial Number', { Status: {Value:"In Service"} } ) );

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!