web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Patch doesn't like $ w...

Power Apps

Answered

Patch doesn't like $ with when formula is empty or returns zero

(0) Share

Report

Report

Posted on by Murphys110

Finally got my patch working, which updates a sharepoint list text label that contains an additional formula. Including that below.

When the result of the formula is zero, the label shows only "$" which then cannot be passed to the sharepoint list.

I'd like to retain the $ and the thousands' comma where there are numbers. Any ideas for a solution?

Would an 'if' statement work here?

Thanks for any help!

"$" & Text((Value(JanThisYear.Text)) + (Value(JanPending.Text)), "[$-en-US]###,###")

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!
"$" & Text(Max(Sum(Value(JanThisYear.Text), Value(JanPending.Text)), 0), "[$-en-US]###,0.00")

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

Updated answer, left something off

Was this reply helpful? Yes No
Murphys110 on at

Like (1)

Report
Copy link

Link copied!

Worked like a charm! Thanks SUPER USER!! 🙂

Was this reply helpful? Yes No

Join the conversation