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?
For the "Months Pushed Out" expression, you should use the following expression:
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:
Hope it helps!
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.'