Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Update values Patch

Posted on by 8

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?

  • Little Profile Picture
    Little 8 on at
    Re: Update values Patch

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

  • Verified answer
    Gochix Profile Picture
    Gochix 1,933 on at
    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!

  • Little Profile Picture
    Little 8 on at
    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

  • Gochix Profile Picture
    Gochix 1,933 on at
    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,685

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,750

Leaderboard