How do I my Numbers to have , comma formatted on them. All are text fields in SharePoint.

@Woodall, Sarah C You can use < <your SharePoint variable> > since your context is HTML markup. It should render as < > respectively. Use a dynamic fx in your logic app with the formatNumber() function; https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#formatnumber . formatNumber(<your SharePoint value>, "C")

How to get commas - Microsoft Q&A

Accepted answer

Ryan Hill 28,631 Reputation points Microsoft Employee

2024-08-28T19:30:00.4866667+00:00

@Woodall, Sarah C

~~You can use < <your SharePoint variable> > since your context is HTML markup. It should render as < > respectively.~~

Use a dynamic fx in your logic app with the formatNumber() function; https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#formatnumber.

formatNumber(<your SharePoint value>, "C")
Please sign in to rate this answer.
Woodall, Sarah C 20 Reputation points

2024-08-28T19:54:38.4533333+00:00

Ryan Hill

Sorry I should have said that better. I am needing a , on the number. I am not sure why put <>

Ryan Hill 28,631 Reputation points Microsoft Employee

2024-08-29T15:24:23.4266667+00:00

@Woodall, Sarah C gotcha, I updated my answer.

Woodall, Sarah C 20 Reputation points

2024-08-29T17:54:34.2566667+00:00

Ryan Hill

Now this is what it shows in my email

formatNumber( <148596, '0,0.00', 'en-us')>

Here is what i have in PowerAutomate

Ryan Hill 28,631 Reputation points Microsoft Employee

2024-08-29T23:27:56.0266667+00:00

No, you need to use to a dynamic function expression that will execute formatNumber with SharePoint input value as the first parameter and "C" as the second parameter. Instead of selecting the SharePoint output parameters, you'll select Function to select formatNumber and your SharePoint output parameter from dynamic content. When you insert, it will be replaced with something similar to what you see in the Inputs text field.

Ryan Hill 28,631 Reputation points Microsoft Employee

2024-09-03T13:03:10.3333333+00:00

@Woodall, Sarah C, just circling back to see if you were still having issues with formatting. Feel free to comment with any follow up questions. If you found the updated answer help, please accept the answer to benefit the broader community.

Yanli Jiang - MSFT 26,761 Reputation points Microsoft Vendor

2024-09-12T05:45:11.6933333+00:00

Thanks for your sharing! So great!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to get commas

0 additional answers

Your answer