Answered

decimal number

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have sharepoint list as shown in screenshot as 37. but, When I use flow to get in my email it shows like.... 37.000000000

How to fix that? Screenshot is attached. integer 2.png

Categories:

General topics

All responses (7)

Answers (1)

Sort by

MattWeston365 1,701 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous you can use the int expression to convert it to an integer i.e. it will strip off all of the trailing 0s.

So your expression will look like:

int(<your value here>)
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@MattWeston365 I am trying but, no option to select my column from sharepoint list.
MattWeston365 1,701 on at

Like
a
(0)

Report
Copy link

Link copied!

That's strange, can you provide a screenshot of your Flow please?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@MattWeston365

Any other way?
MattWeston365 1,701 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous unfortunately I still have no idea what you have within your Flow from that screenshot, can you povide a screenshot of the overall Flow? What action are you expecting the value to come back from?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@MattWeston365 from the humidex calculation
Verified answer

MattWeston365 1,701 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ok so I think I'm slowly piecing together what you're doing.

You're getting heat/humidity information from the weather actions and then feeding those values into a SharePoint list. I'm assuming that you are then using a calculated column within SharePoint to calculate the humidex, and this is the value you're trying to pull back into Flow to use within your email. Is this correct?

So I have successfully managed to retrieve the value of the calculated column from the list, but if you're pulling it out into a variable you need to treat it as a string. Then you can transform it and use it in your email.