web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Format Number without ...

Power Automate - Building Flows

Answered

Format Number without Rounding Up

(1) Share

Report

Report

Posted on by LauraGrimes123

60

Hi All

I am using a flow to update peoples ages in a sharepoint list based on their date of birth. The flow is working out their ages fine with decimal places, however I need to save these down to the list as a whole number but when I use any format number rules it rounds any with a decimal over 5 to the number above (as is the standard) but I need it to not do this as if someone is 21.6 years old they are still 21 and not 22

Thanks

Laura

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Chriddle 8,319 Super User 2025 Season 2 on at

Like (0)

Report
Re: Format Number without Rounding Up

Just substract 0.5 from the number:

formatNumber(sub(item(), 0.5), '#')

Was this reply helpful? Yes No
abm abm 32,585 Most Valuable Professional on at

Like (0)

Report

Re: Format Number without Rounding Up

Hi @LauraGrimes123

What formula you applying to get the decimal format? Can't you workout from the Current Year minus Date of Birth which will give you the age? For this you need to use expression like below.

sub(formatDateTime(utcNow(), 'yyyy'),formatDateTime('DateOfBirthColumnHere','yyyy'))

Thanks

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 691 Super User 2025 Season 2

#2

Tomac 431 Moderator

#3

developerAJ 266

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans