Add st, nd, rd and th (ordinal) suffix to a number in Power Automate

Sometimes you need to create an ordinal number for use in an email or similar situation. Power Apps does not have any support for this type of number formatting but it can be created quite easily with an expression.

The rules are as follows:

• st is used for numbers ending in 1.
• nd is used for numbers ending in 2
• rd is used for numbers ending in 3
• all other numbers end in th except…
• Numbers ending in 11, 12, or 13 use th.

In Power Automate you can generate an ordinal number with the following expression:

if(endsWith(string(outputs('NumbeToConvert')),'12'),formatNumber(outputs('NumbeToConvert'), '#th'),
if(endsWith(string(outputs('NumbeToConvert')),'13'),formatNumber(outputs('NumbeToConvert'), '#th'),
if(endsWith(string(outputs('NumbeToConvert')),'1'),formatNumber(outputs('NumbeToConvert'), '#st'),
if(endsWith(string(outputs('NumbeToConvert')),'2'),formatNumber(outputs('NumbeToConvert'), '#nd'),
if(endsWith(string(outputs('NumbeToConvert')),'3'),formatNumber(outputs('NumbeToConvert'), '#rd'),
formatNumber(outputs('NumbeToConvert'), '#th')))))))

Where outputs(‘NumbeToConvert’) is the value you want to replace. An example flow using the above:

The result is obviously 102nd:

The flow simply uses the endswith function to determine the correct ordinal reference.

Hope this helps.