web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Modern Table Number Co...
Power Apps
Suggested Answer

Modern Table Number Column data isn't same format in Sharepoint List.

(1) ShareShare
ReportReport
Posted on by 1

I'm facing an issue where the Modern Table in PowerApps isn't displaying the data exactly as from the associated SharePoint list. 

This is the Modern Table:

 

This is some of data from the Sharepoint List connected to the Table

As you can see, the Value is Number, 

I was expecting the modern table to have comma and decimals.

I adjusted also the fieldType to "$" and "n" but still same.

 

as per checking on the table.

 

its a number type, 

is there any way i can format it to have a comma for thousands and decimals

 

for those wondering why shouldnt i just

change it before it is created (it came from API, so i cant); or

update it (it contains few thousands and changes everyday, it might take a while to update everything);

use calculated column (i tried, it doesnt show in modern table)

Categories:
I have the same question (0)
  • Suggested answer
    MS.Ragavendar Profile Picture
    7,073 Super User 2026 Season 1 on at
     
    I followed the Reza tutorial and its working for me .
     
     
    Sample Data
     
    ClearCollect(sampleCollection,[{Name:"SR",ID:1,No:10000},{Name:"YK",ID:2,No:100000}])
     
    Unlock the field
     
     
     
    Save the app & Refresh the Data Source 
     
    Its working fine for me
     
     
     
     
     
    🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.
    Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.
    ❤️ Please consider giving it a Like, If the approach was useful in other ways.
  • MS.Ragavendar Profile Picture
    7,073 Super User 2026 Season 1 on at
     
    Did the suggestion work you ?
     
     
    🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.
    Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.
    ❤️ Please consider giving it a Like, If the approach was useful in other ways.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 899

#2
Valantis Profile Picture

Valantis 571

#3
11manish Profile Picture

11manish 499

Last 30 days Overall leaderboard