Flow Output Date Formatting

[enswitzer]

I have a flow that creates a table (below) and sends it in an e-mail each week. However, I can't seem to get the formatting right on dates and numbers. How can I show the "Months Pushed Out" as only whole numbers, and the date at the top in YYYY-MM-DD format instead of with time?

[fchopo]

Hello @enswitzer 

For the "Months Pushed Out" expression, you should use the following expression:

int(first(split(string(item()?['MonthsPushedOut']),'.')))

Which converts the number to a string, get the number before the "." and converts it to integer.

And for the date at the top (I suppose it is written in the email) you should use:

formatDateTime(your_date,'yyyy-MM-dd')

Hope it helps!

Ferran

[enswitzer]

Seemingly no matter what I do  - this Months one fails and gives me this Error:

Unable to process template language expressions in action 'Set_variable' inputs at line '1' and column '23678': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'