web

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

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

Power Apps - Building 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:

General Questions

Using Apps Using Formulas

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
Re: Patch doesn't like $ with when formula is empty or returns zero

"$" & 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

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

Updated answer, left something off

Was this reply helpful? Yes No
Murphys110 on at

Like (1)

Report

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

Worked like a charm! Thanks SUPER USER!! 🙂

Was this reply helpful? Yes No

Join the conversation