Converting a Decimal Value into Whole Number Using Power Automate

Converting a Decimal Value into Whole Number Using Power Automate

When working with Power Automate, you may receive decimal values from Excel, SharePoint, Dataverse, APIs, or calculations. In many situations, business requirements demand whole numbers instead of decimal values.

Power Automate provides several built-in expressions that can convert decimal values into whole numbers based on your specific requirements.

Why Convert Decimals to Whole Numbers?

• Generate cleaner reports
• Store integer values in systems
• Calculate quantities and counts
• Improve data consistency
• Meet business validation requirements

Using the int() Function

The int() function removes the decimal portion and returns only the integer value.

int(123.99)

Output:

Using the round() Function

The round() function rounds the number to the nearest whole number.

round(123.75,0)

Output:

Using the floor() Function

The floor() function always rounds down to the nearest whole number.

floor(123.99)

Output:

Using the ceiling() Function

The ceiling() function always rounds up to the nearest whole number.

ceiling(123.01)

Output:

Common Use Cases

• Invoice calculations
• Sales quantity processing
• Excel data transformations
• SharePoint list updates
• Dataverse numeric field updates
• Business reporting automation

Best Practices

• Understand business rounding requirements.
• Test conversion logic before deployment.
• Use round() for standard rounding scenarios.
• Use floor() and ceiling() for directional rounding.
• Document conversion logic in complex workflows.

Key Takeaways

• Power Automate provides multiple methods for decimal conversion.
• int() removes the decimal portion.
• round() rounds to the nearest whole number.
• floor() always rounds down.
• ceiling() always rounds up.
• Select the method that aligns with your business rules.