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.
Solved! Go to Solution.
Hello @nikitamobile85,
Based on your requirement, may be this could help
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com
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
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
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.
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.
Hello @nikitamobile85,
Based on your requirement, may be this could help
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com
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.
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.
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.
User | Count |
---|---|
161 | |
85 | |
68 | |
63 | |
61 |
User | Count |
---|---|
212 | |
146 | |
94 | |
81 | |
67 |