“Froyo Queen” Azure McFarlane mentioned in a birdie chat that she was having trouble with formatting the month value using the formatDateTime function in Power Automate cloud flows. She was attempting to only retrieve the month value without the leading 0.
The expression applied was
formatDateTime(utcNow(), 'M') but the output returned is the following:
(Problem is that standalone ‘M’ (and bunch of other letters) is not treated as a custom format at all but as one of the standard formats. – t.j.)
Solution: prepend the % character in the expression like this:
Another mystery solved! #ScoobyDoo
Cover image by congerdesign | Pixabay