Data Field Format (Thousand separator)

[nikitamobile85]

Dear Members, 

I am using SharePoint list and custom form for approval workflow automation. I have a number type column in the list however it is not showing thousand separator when inputting to the form. Please advise how it can be enabled. 

[WarrenBelz]

Hi @nikitamobile85 ,

You can show it in a label (view only) with 

Text(YourValue,"#,###,###")

but if you want a numeric input, it cannot have non-numeric characters in it.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[rampprakash]

Hello @nikitamobile85,

You can get help from here https://masteroffice365.com/displaying-numeric-fields-as-currency-in-powerapps/

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

[nikitamobile85]

Thank you! I have tried the same and it helps in case of a form view. However I'm using HTML table which collects sharepoint list item data and later converts it to PDF. For this purposes inside the flow I'm creating a variable which pulls Sharepoint list objects, incorpoprates into html an converts to PDF. 'Amount' field is reflected without thousand separator though in the form and in the list it shows up correctly.  

[nikitamobile85]

Thank you! I have tried the same and it helps in case of a form view. However I'm using HTML table which collects sharepoint list item data and later converts it to PDF. For this purposes inside the flow I'm creating a variable which pulls Sharepoint list objects, incorpoprates into html an converts to PDF. 'Amount' field is reflected without thousand separator though in the form and in the list it shows up correctly.  

[rampprakash · Accepted solution]

Hello @nikitamobile85,

Based on your requirement, may be this could help

https://powerusers.microsoft.com/t5/Using-Flows/Format-number-with-thousands-separator-in-Flow-email...

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

[WarrenBelz]

@rampprakash ,

As I said, you can only do this in View mode - the requirement was to display when inputting on the form, which cannot be done.

[WarrenBelz]

@nikitamobile85 ,

Is your requirement still during input (as you posted) or do you want it displayed formatted in the HTML? If in the HTML, you can use the same code as I posted for the label.

[rampprakash]

Hello @WarrenBelz,

Solution got accepted based on @nikitamobile85 requirement.

[WarrenBelz]

@rampprakash ,

Clearly requirement is not as posted

I have a number type column in the list however it is not showing thousand separator when inputting to the form. 

@nikitamobile85 glad you got it sorted, but your original post suggested a different issue.