Answered

Patch value to all items in SharePoint

(0) Share

Report

Posted on by steve_hendy

388

I have this formula which takes ages to run on 600 items. I want to update all items in the SharePoint list with the same value. I understand this can be done with one call to SharePoint by patching in one go. What is the correct way to do this?

ForAll( ShowColumns( BMSlibrary, "ID", "Issue" ), Patch( BMS, ThisRecord, {Issue: Value(TextInput1.Text)} ) )

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Akser 1,546 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @steve_hendy,

Is BMSlibrary is a local collection of the data source BMS?

Patch(BMS, ShowColumns(BMSlibrary, "ID", "Issue"), {Issue: Value(TextInput1.Text)})

Was this reply helpful? Yes No
steve_hendy 388 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, it is. I will try this soon and let you know if it works.

Was this reply helpful? Yes No
Verified answer

Akser 1,546 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
If you want t update all records, this should also work (not sure if Patch or UpdateIf is quicker - give it a try):
UpdateIf(BMS, true, {Issue: Value(TextInput1.Text)})

Was this reply helpful? Yes No
steve_hendy 388 on at

Like
a
(0)

Report
Copy link

Link copied!

this did not work, maybe because it was a SharePoint library (I said list).

Was this reply helpful? Yes No
steve_hendy 388 on at

Like
a
(0)

Report
Copy link

Link copied!

This worked, Thank you.

Was this reply helpful? Yes No
Akser 1,546 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
What about this one?
ClearCollect( MyPatchCollection, AddColumns( ShowColumns( BMSlibrary, "ID" ), "Issue", Value(TextInput1.Text) ) ); Patch(BMS, MyPatchCollection)
If it does work, then you can compare the performance of UpdateIf vs Patch 😉

Was this reply helpful? Yes No