Answered

Update values Patch

(0) Share

Report

Posted on by Little

Hi! I am trying to update a sharepoint list that has several lines for the same title, but it only updates the first one. I have also managed to update everything, but in this case if there are several lines it takes several minutes to complete. How can I do in less time?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Gochix 1,937 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Please paste your code in here and we can have a look how to improve your speed.
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!
Little 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry!here is the code

ClearCollect('LISTADO5',Filter('LISTADO',Title = SelectFile)); ForAll('LISTADO5',UpdateIf('LISTADO',Title=SelectFile,{RAZON:DROPRAZON.Selected.Title, COMENTARIO:TEXTCOMMENT.Text}))

this work, but takes long time
Verified answer

Gochix 1,937 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
I would simplify your code to:
Patch('LISTADO', ForAll( Filter('LISTADO',Title = SelectFile), { ID:ID, RAZON:DROPRAZON.Selected.Title, COMENTARIO:TEXTCOMMENT.Text } ) )
UpdateIf would cost you a bit of performance. Using ForAll correctly will reduce the wait time.
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!
Little 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much! Now is super fast!!!