Patch blank

(0) Share

Report

Posted on by R Bakker

725

Hi Everyone

I have a dropdown in a gallery patching on change. It patches both the value of the dropdown and true/false to another, but I would also like it to patch blank to another column if dropdown selection is blank.

Patch(
 Sanford_Pallet_Serial_Number_Record,
 ThisItem,
 {
 SNDumped: !IsBlank(DropdownReason.Selected) && DropdownReason.Selected.Value <> "",
 DumpedSNReason: DropdownReason.Selected.Value
 }
)

Dropdown is hardcoded with the following.

["","Label Damage","Production Sample","Over Print","Part Box"]

So if I choose "" from my dropdown, I would like it to do what it currently does plus patch "" to the Palletnumber column.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Corissandageri :

Please try:

Step1:turn on the 'Formula-level error management' feature

Step2:try this code:

Patch( Sanford_Pallet_Serial_Number_Record, ThisItem, { SNDumped: !IsBlank(DropdownReason.Selected) && DropdownReason.Selected.Value <> "", DumpedSNReason: DropdownReason.Selected.Value, Palletnumber:If(DropdownReason.Selected.Value = "",Blank()) } )

Best Regards,

Bof

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!

Thanks Bof
This works well, but what is Formula level error management?

Was this reply helpful? Yes No