cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ffox
Frequent Visitor

Formula Text currency format

Hi,

 

New to Power Apps. Building from a SP List I can get a PApp showing -

 

PA1.PNG

 

You can see from the formula bar that I've tried to configure the field to display currency, but it fails to display. What am I missing?

 

Thanks in advance

 

Chris

1 ACCEPTED SOLUTION

Accepted Solutions
ffox
Frequent Visitor

Issue Resolved: The field I was attempting to format as currency was a calculated field in the SP list. This does not work.

 

I changed the PApps field to recalculate the original SP List values and format the result as currency - it now works.

 

Chris

View solution in original post

5 REPLIES 5
ffox
Frequent Visitor

Issue Resolved: The field I was attempting to format as currency was a calculated field in the SP list. This does not work.

 

I changed the PApps field to recalculate the original SP List values and format the result as currency - it now works.

 

Chris

View solution in original post

Anonymous
Not applicable

Hi Chris

 

I have the same issue, could you explain to me exactly how you solved it please? What do you mean by recalculating?

ffox
Frequent Visitor

Hi Michelle,

 

If you look at the snapshot I placed in the opening post you'll see that I have a calculated field in the SharePoint List called Net. The value is the product of the SP list fields Rate * Units.

 

Power apps does not handle SP list calculated fields well. All I did was change the PA field formula as shown below -

 

PA2.PNG 

 

It will then format correctly.

 

Hope this helps

 

Chris

If I understand you correctly, this may also work (and is a bit simpler/more robust):

Text(Value(Net),"[$-en-US]$00.00")

as it appears the calculated field (Net) is returned as a string. The Value function turns that into a number.

(My change to en-US/$ is only because I can't easily type a pound sign)

ffox
Frequent Visitor

Thanks Andy,

 

I'll try that next time and report the result.

 

Chris

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (75,720)