Answered

Patch Gallery where field is blank

(0) Share

Report

Posted on by R Bakker

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:

Using Apps Using Formulas

All responses (2)

Answers (1)

R Bakker 725 on at

Like (0)

Report

Re: Patch Gallery where field is blank

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

timl 34,933 Super User 2025 Season 1 on at

Like (2)

Report
Re: Patch Gallery where field is blank

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} )