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?
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
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.'
User | Count |
---|---|
95 | |
48 | |
21 | |
19 | |
18 |
User | Count |
---|---|
137 | |
54 | |
42 | |
40 | |
30 |