You’re offline. This is a read only version of the page.
93
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?
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.'
Hello @enswitzer
For the "Months Pushed Out" expression, you should use the following expression:
Share
Report
All responses (
Answers (
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
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
