cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bgerew Advocate I
Advocate I

sharepoint caculated columns showing 13 decimal places in flow email.

I have created a powerapp that once a form is submitted thru the app, it puts the data into a SharePoint list. This list has calculated columns in. I have configured these columns to round up to 2 decimal places. In powerapps i have add the value funtion to the display fields to see only 2 decimal places. That list has the new Microsoft flow running stating that it sends and email when a new item is created. This all works great. My issue lies within the email that flow creates it is adding 11 zeros after the 2 decimal places that I have rounded to.   I see 2 decimal in SharePoint and I see 2 decimal in powerapps. I'm thinking flow is adding the 11 other zeros to the number, so I end up with 13 decimal places. Any suggestions would be wonderful! Thank you in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
bgerew Advocate I
Advocate I

Re: sharepoint caculated columns showing 13 decimal places in flow email.

I figured out a solution to this issue.  I had to wrap the calculated column formula with a text funtion:

 

example:  =TEXT([formula], "#.00")

 

Thank you for your reply.

View solution in original post

12 REPLIES 12
Highlighted
efialtes Kudo Kingpin
Kudo Kingpin

Re: sharepoint caculated columns showing 13 decimal places in flow email.

@bgerew

I think a possible workaround could apply by introducing an expression derived from 

https://msdn.microsoft.com/en-us/library/azure/mt643789.aspx

First converting number into string, then replacing the 11 zeros

It looks like such Azure Logic Apps expressions can be used in Flows, according to Stephen's response in this thread 

https://powerusers.microsoft.com/t5/Flow-Forum/XML-Parsing-Xpath/m-p/1479#U1479

Hope this helps

 

 

bgerew Advocate I
Advocate I

Re: sharepoint caculated columns showing 13 decimal places in flow email.

I figured out a solution to this issue.  I had to wrap the calculated column formula with a text funtion:

 

example:  =TEXT([formula], "#.00")

 

Thank you for your reply.

View solution in original post

adanew
New Member

Re: sharepoint caculated columns showing 13 decimal places in flow email.

Actually a small improvement to bgrew's design fixes it completely =TEXT([formula], "#,###.00")  and =TEXT([formula], "#,###") forces no decimal places and no decimal point - thanks for the clue bgrew

Mali1980
New Member

Re: sharepoint caculated columns showing 13 decimal places in flow email.

Where are you placing this text formula?

dmistry Post Prodigy
Post Prodigy

Re: sharepoint caculated columns showing 13 decimal places in flow email.

@adanew  my calculated column formula is as follows: 0.55 * [column name], how do I wrap it then , can you help please. 

RKnighton88 Helper II
Helper II

Re: sharepoint caculated columns showing 13 decimal places in flow email.

I seem to be having the same issue. I have added the formula as mentioned and I seem to be getting a Syntax Error. Just so I understand and check that I am doing this correctly (more than likely im not). This is the formula im using:

 

=TEXT([formula], "#,###")

 

So where abouts do I add the column name which is 'Contact Number'? Do you add it after the equals, before, do you include the TEXT part. I'm not a 100% sure.

enmanbj Helper I
Helper I

Re: sharepoint caculated columns showing 13 decimal places in flow email.

I am a novice at this Flow stuff.

 

I just created a flow from SharePoint to Outlook and am experiencing the same issue. 

 

My question is where do I put the =TEXT([formula], "#.00") in at?

 

Total Daily Build is the one I'm having trouble with. 

 

flow.png

Murderbot Advocate III
Advocate III

Re: sharepoint caculated columns showing 13 decimal places in flow email.

Good solutions, but syntax wants single quotes, not double.

TEXT([formula],'#,###')
Pnolan77
New Member

Re: sharepoint caculated columns showing 13 decimal places in flow email.

Hi, 

 

Can you please help me with with the text function for this formula:

=SUM([1],[10],[2],[3],[4],[5],[6],[7],[8],[9])

 

I've tried this:

=TEXT([=SUM([1],[10],[2],[3],[4],[5],[6],[7],[8],[9])],"#.0")

 

And I get "Technical Issue". 

 

Also, what type of column should it be? Single line of text or number? (I have tried both)

enmanbj Helper I
Helper I

Re: sharepoint caculated columns showing 13 decimal places in flow email.

Pnolann77,

Have you tried the integer function?

 

In Flow  my expression is:

 

int(triggerbody()?['Your column name here'])

 

In SharePoint I have a column for single line of text and the formula is something like this: 

 

=[Column Name]+[Column Name]+[Column Name]+[Column Name]

 

Is this for an automatic Flow email?

 

Hope it helps

jglose
Frequent Visitor

Re: sharepoint caculated columns showing 13 decimal places in flow email.

This seems like a possible solution to my issue. However, I also am unsure where you are "wrapping" this formula. Where did you place this TEXT formula?

Aj5
New Member

Re: sharepoint caculated columns showing 13 decimal places in flow email.

@Pnolan77  @jglose @enmanbj 

You can try to Skip the = before SUM

 

Try : =TEXT([SUM([1],[10],[2],[3],[4],[5],[6],[7],[8],[9])],"#.0")

 

I figured it out when i used it nested formulae for my requirement like this : 

=TEXT(IF(SPELL="","NA",SPELL),"#.0")

 

Note: IF formula is wrapped in TEXT 

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (6,991)