Skip to main content

Notifications

Community site session details

Community site session details

Session Id : ctUb7NeXxwcciUfWi7k5GE
Power Automate - Building Flows
Answered

Convert Float to Integer Ms Flow in addDays Expression

Like (1) ShareShare
ReportReport
Posted on 13 Aug 2020 11:14:30 by 153

I have column in SharePoint list with type data Number.

6.png

 

I want convert from float to integer, because showing error message at my flow:

4.png

 

 

 

 

Please Check My Flow:

7.png5.png

 

How to convert from type data Number to Float (base on to error message). Because I want create calculated Planned Due Date = addDays(utcNow() + estimated sailing in duration. Thanks

  • Verified answer
    v-litu-msft Profile Picture
    on 14 Aug 2020 at 05:24:01
    Re: Convert Float to Integer Ms Flow in addDays Expression

    Hi @krfajar,

     

    Does your Float number contain decimal places? If not, you could put the int() function into the second parameter of addDays() function:

    addDays(utcNow(),int(variables('Float')),'yyyy-MM-dd')

    Annotation 2020-08-14 094958.jpg

     

    If it contains, you should remove the decimal part, for example:

    first(split(string(variables('Float')),'.'))
    addDays(utcNow(),int(outputs('Compose_2')),'yyyy-MM-dd')

    Annotation 2020-08-14 132214.jpg

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • krfajar Profile Picture
    153 on 13 Aug 2020 at 18:44:49
    Re: Convert Float to Integer Ms Flow in addDays Expression

    Hi @

     

     

     

     

     

     
  • ChristianAbata Profile Picture
    8,947 Most Valuable Professional on 13 Aug 2020 at 11:56:00
    Re: Convert Float to Integer Ms Flow in addDays Expression

    hi @krfajar please add int() and inside it your current expression like int('Here your current expression')

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 67

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 66 Super User 2025 Season 1

#3
rzaneti Profile Picture

rzaneti 41 Super User 2025 Season 1

Overall leaderboard
Loading started