Answered

Problems with executing the forall and patch function at the same time

(0) Share

Report

Posted on by aaronramosr

Hi,

If some can help, Ive been having this problem while executing the forAll and path function at the same time. The problem that shows is "Patch function can not be executed at the same data source of the ForAll does"

ForAll('Master de Pedios Unimarket';Patch('Master de Pedios Unimarket';LookUp('Master de Pedios Unimarket';Soportegalleria.Selected.NumOrden=NumOrden);{Estado:Dropdown3.Selected}))

Any help?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Sutherland Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hello Aaronramosr,

You could have a try on below formula type which would solve your mentioned same data source issue.

ForAll(Datasource, Patch(Datasource, {ID: Datasource.ID}, {Column_A: Left(ReminderDates, 10), Column_B: Mid(ReminderDates, 12, 10), Column_C: Right(ReminderDates, 10)}) )

ForAll(CheckedItems,Patch(ChecklistItemsSource,LookUp(ChecklistItemsSource, Id = CheckedItems[@Id]),{Status:"Done"}))

Check following blog on bulk update records in PowerApps & ForAll and Patch for more details
https://powerapps.microsoft.com/ru-ru/blog/bulk-update-using-forall-and-patch/
https://powerusers.microsoft.com/t5/Building-Power-Apps/ForAll-and-Patch-Split-a-Column-into-three-and-patch-the/td-p/47748

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @aaronramosr ,

Yes, it isn't allowed to handle the same Data source on ForAll() function and internal Patch() function at the same time, since the Patch function will modify the Data source in each loop, resulting in a conflict between two function.

You can save the data source to collection using ClearCollect() function, and then take the collection as the Table of ForAll() function.

However, from your code, I think there is no need to use ForAll/Patch combination if you don't need to reference value from table of ForAll function. The UpdateIf function can fully achieve your need, please try this:

UpdateIf('Master de Pedios Unimarket'; NumOrden=Soportegalleria.Selected.NumOrden;{Estado:Dropdown3.Selected})

Hope this helps.

Sik

Was this reply helpful? Yes No
aaronramosr 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much, it worked perfectly

Was this reply helpful? Yes No
Pxtavern 79 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you your code

UpdateIf('Master de Pedios Unimarket'; NumOrden=Soportegalleria.Selected.NumOrden;{Estado:Dropdown3.Selected})
Did exactly what I needed

Was this reply helpful? Yes No