web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Patch Gallery where fi...
Power Apps
Answered

Patch Gallery where field is blank

(0) ShareShare
ReportReport
Posted on by 725

Hi Everyone, I have a gallery which has already filtered to show the records where the PalletNumber column is blank, but I would like to patch all those records the same number from a text input, I have tried Forall , but seem to be getting myself more confused.

 

Thank you

Categories:
I have the same question (0)
  • Verified answer
    timl Profile Picture
    36,393 Super User 2025 Season 2 on at

    Hi @Corissandageri 

    I would suggest that you look at the UpdateIf function.

    https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-update-updateif

    The syntax for this function looks like this:

    UpdateIf(YourDataSource,
     IsBlank(PalletNumber),
     {FieldToPatch:txtYourInputTextbox.Text} 
    )

     

  • R Bakker Profile Picture
    725 on at

    Wow, so simple, and yes I will look into UpdateIf. Thank you

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard