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?

I have the same question (0)

All responses (4)

Answers (1)

Gochix 1,933 Moderator on at

Like (0)

Report

Re: Update values Patch

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!

Was this reply helpful? Yes No
Little 8 on at

Like (0)

Report

Re: Update values Patch

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

Was this reply helpful? Yes No
Verified answer

Gochix 1,933 Moderator on at

Like (0)

Report
Re: Update values Patch

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!

Was this reply helpful? Yes No
Little 8 on at

Like (0)

Report

Re: Update values Patch

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

Was this reply helpful? Yes No