Announcements
Hello All,
I get the below error in my flow.
Did anyone struggle with a similar issue?
Thanks
Hi @Dana123 ,
The int function requires sting as the input parameter, could you please share the whole expression in the Compose operator?
Best regards,
Please use formatDateTime() instead of int() for this expression.
addDays('1899-12-30',formatDateTime(items('Apply_to_each')?['Request received on (DD/MM/YYYY)']),'dd-MMM-yyyy')
Are you trying to get the difference in days between 1899-12-30 and your Request Received date? Or are you trying to do something else?
addDays function takes in an initial date that you want to add days to; the number of days you want to add; and the date format.
I am trying to use the date from this column
Request received on (DD/MM/YYYY)
in the email (otherwise, Power Automate treats it as a 5-digit code).
It seems you are using Excel as data source. If so, date values will be saved as numbers in the table. You can use this number for addDays function directly.
formatDateTime(addDays('1899-12-30',items('Apply_to_each')?['Request received on (DD/MM/YYYY)']),'dd-MM-yyyy')
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
trice602 239 Super User 2026 Season 1
David_MA 177 Super User 2026 Season 1
Kalathiya 97 Super User 2026 Season 1
