[HELP] - Symbol not concatenated to string

(1) Share

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:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@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

Was this reply helpful? Yes No