cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Send an Email - Sharepoint Calculated Field Decimal Places

Hi

We have a flow for staff to request annual leave.

In the sharepoint list is the start date, end date, and a calculated field for days used.

sharepoint.PNG

When it goes through Power Automate Flow and uses "Send an email" to say to staff its been approved and X days have been taken out of the entitlement it comes out as 5.00000000

 

decimal.PNG

 

Any ideas please? Many thanks

1 REPLY 1
Highlighted
Dual Super User II
Dual Super User II

Hi @karldenton 

 

Use expression to convert the data type.

 

example:

 

int(your dynamic column value)

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (8,180)