Power Apps canvas - convert numeric value in a collection to an empty string

(0) Share

Report

Posted on by Cgangweg01

893 Super User 2026 Season 1

Hello -

I would like to convert the value in field Promotional Price to an empty string or blank when applying this UpdateIf statement to the collection.

I've attempted many different things but only putting a zero in the statement does anything close.

Any suggestions?

UpdateIf(ColStorePriceswithPromoDescrip,'Promotion Type'="Retail Exception",{'Promotional Price':0});
 
 

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

ronaldwalcott 3,906 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Blank is not a valid numeric value.

You could create a new column and convert the number to text or wherever you are displaying the value change the display option to something like

If(ThisItem.NumericField = 0, "", Text(ThisItem.NumericField, "[$-en-US]#,###.##"))

Was this reply helpful? Yes No
Cgangweg01 893 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply @ronaldwalcott!

I will try the new column approach. I don't know what a display option is nor how to work that into the button OnSelect statement where the clearcollect and updateif statements are.

Was this reply helpful? Yes No
Verified answer

timl 37,271 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi Cgangweg01

I assume you tried the following and it didn't work? That's interesting because Blank() should insert a NULL into the field.

If you run the following and check the collection in the collections section of the designer, what value appears against the 'Retail Exception' rows? It could be that the values are being updated to NULL in the collection but are not displayed correctly in the gallery/data table, possibly due to formula that formats the value to 2 decimal places.

UpdateIf(ColStorePriceswithPromoDescrip,'Promotion Type'="Retail Exception",{'Promotional Price':Blank()});

Was this reply helpful? Yes No
Cgangweg01 893 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you timl!

I think I tried that but must have had the syntax wrong.

Worked like a charm now!

Appreciate your help.

Was this reply helpful? Yes No