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 / Sharepoint and Canvas App
Power Apps
Answered

Sharepoint and Canvas App

(0) ShareShare
ReportReport
Posted on by 6

Hi guys,

I build a canvas app using sharepoint list as the data source. The app is working ok, however one on the columns is not giving me what I require from it. The column's data type is number. When I enter a decimal number, I do not see the out come as a decimal in the canvas app but a whole number. I have gone into the sharepoint list to provide me with at least one decimal place figure, but this is not happening. What might I have done wrong?Canvas app.jpg

 

Categories:
  • ANB Profile Picture
    7,252 Super User 2026 Season 1 on at

    Hi @KwesiOc Try this on the control where you want to show that value in decimal within gallery:

     

    Text(ThisItem.ColumnName, "0.0")

     

    -----------------------------------------------------------------------------------------------------------------------------

    I hope this helps.

    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.👍

    Thanks,
    ANB


  • Jeremy79Hill Profile Picture
    25 on at

    Please provide the code for OnSelect of "Update" and "Create" as well as the Text value for the gallery Engine CC field.  

     

    Also, have you refreshed the SharePoint data source since you update the SharePoint List?

  • Loconam Profile Picture
    42 on at

    I think it would be good to apply decimals in the text function.

    Text(ThisItem.columnname,"#.#")
  • KwesiOc Profile Picture
    6 on at

    Hi guys, 

    Thanks for taking time to help but I seem to be at a lost. as to where to append the suggested solution. I have included the patch function to this message. Is this what you are referring to?Decimal issue.jpg

  • ANB Profile Picture
    7,252 Super User 2026 Season 1 on at

    @KwesiOc You need to have on below highlighted control's Text property.

    ANB_0-1712420030629.png

    -----------------------------------------------------------------------------------------------------------------------------

    I hope this helps.

    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.👍

    Thanks,
    ANB


  • Verified answer
    timl Profile Picture
    37,420 Super User 2026 Season 2 on at

    Hi @KwesiOc 

    After you modified the column in your Sharepoint list to provide at least one decimal place figure, did you refresh your CarInfo data source in Power Apps? This step is needed for the change to apply in Power Apps.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 248 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 192 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 135

Last 30 days Overall leaderboard