News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps [HELP] - Symbol not co...

Power Apps - Building Power Apps

Answered

[HELP] - Symbol not concatenated to string

(1) Share

Report

Report

Posted on by YamiteKudasai

195

Hi Everyone,

Good day!

I have a variable contain number named varRndB1BSIRow and I want it to concatenate with "$" symbol.
However nothing happens using my code below:

" $ " & Text(varRndB1BSIRow, "[$-en-US]###,###,###")

I also tried :

Text(varRndB1BSIRow, "[$-en-US]$###,###,###")

Still doesn't work.
But in some areas it's working. can you help and explain why?

Categories:

General Questions

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

poweractivate 11,078 on at

Like (0)

Report
Re: [HELP] - Symbol not concatenated to string

@YamiteKudasai
Try this

If( IsBlank(varRndB1BSIRow) || IsBlank(Text(varRndB1BSIRow)), Notify("It is blank", NotificationType.Error), "$" & Text(varRndB1BSIRow, "[$-en-US]###,###,###") )

If you see "it is blank" red message at the top, then it's because of the variable being blank sometimes.
You may want to check on the variable and see why it is sometimes blank, by exiting preview mode and then mousing over the varRndB1BsIRow in the formula bar once you get the red message.

See if it helps @YamiteKudasai