Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Update multiple rows in a SharePoint library from a single text input in PowerApps

Posted on 29 Nov 2024 16:52:02 by 62

Hi All,

 

I have an app whith 3 fields, two of them are to search for record in the library (date and start time) and the 3rd for a number (text input) to update all the records found with the first two fields,

i have tried - Patch(GritDriverDetails,LookUp(GritDriverDetails,Date=DataCardValue11.SelectedDate And StartTime=DataCardValue12.Text),{ConfirmNumber:DataCardValue13.Text}) - but this only updates one record, how do i update all records with the same date and start time with one click.

 

Any help would much appreciated,

 

Thanks in advance

 

Ed

 

Image

  • edymac2 Profile Picture
    edymac2 62 on 29 Nov 2024 at 18:25:09
    Update multiple rows in a SharePoint library from a single text input in PowerApps
    Thanks Paul, that works perfectly
  • Verified answer
    Pstork1 Profile Picture
    Pstork1 63,851 on 29 Nov 2024 at 17:15:31
    Update multiple rows in a SharePoint library from a single text input in PowerApps
    Lookup() always returns the first record that ir finds. The command you are looking for is UpdateIf()
     
    The code would be something like this
     
    UpdateIf(GritDriverDetails, Date = DataCardValue11.SelectedDate and StartTime = DateCardValue12.Text, {ConfirmNumber: DateCardValue13.Text})

     
    ----------------------------------------------------------------------------------
    If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

    Paul Papanek Stork, MVP
    Blog: https://www.dontpapanic.com/blog
     

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,168

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,851

Leaderboard