Unanswered

Flow Output Date Formatting

(0) Share

Report

Posted on by 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?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
enswitzer 93 on at

Like (0)

Report
Copy link

Link copied!

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.'

Was this reply helpful? Yes No