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

Text field currency formatting whilst linking to SharePoint List.

I'm building an app that links to a SharePoint list. When the app was built from the list I lost the formatting on a lot of my fields (percentage fields and currency fields). I unlocked the data cards and editted the text to keep inherting from parent but also include formatting using:

 

"£" & Text(Parent.Default, "0.00")

 

For every field this worked, but I have one field where it got the currency format but has way too many decimal places. In the SharePoint list it is validated to only have 2 decimal places and I specified in the text field to only hold 2 decimal places. Does anyone know what might be causing this? The only difference I can see between this field and the other fields is that this is a minus value (it has to be minus as it is net financial impact).

 

Screenshot below for reference to field and text code.

 

Thanks in advance

Capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Text field currency formatting whilst linking to SharePoint List.

@Jamiehopper1 

My thought is the field in Sharepoint is storing the value as Text already.  Give this code a try, it will convert the field to a number and then re-convert to Text in the correct format.

 

"£" & Text(Value(Parent.Default), "0.00")

 

---
Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

View solution in original post

3 REPLIES 3
Highlighted
Super User
Super User

Re: Text field currency formatting whilst linking to SharePoint List.

@Jamiehopper1 

My thought is the field in Sharepoint is storing the value as Text already.  Give this code a try, it will convert the field to a number and then re-convert to Text in the correct format.

 

"£" & Text(Value(Parent.Default), "0.00")

 

---
Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

View solution in original post

Highlighted
Frequent Visitor

Re: Text field currency formatting whilst linking to SharePoint List.

Solved! Thanks very much

Highlighted
Super User
Super User

Re: Text field currency formatting whilst linking to SharePoint List.

@Jamiehopper1 

No problem.  Always happy to get someone unstuck so they can continue building!

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,138)