Announcements
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?
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
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?
I think it would be good to apply decimals in the text function.
Text(ThisItem.columnname,"#.#")
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?
@KwesiOc You need to have on below highlighted control's Text property.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 248 Super User 2026 Season 2
WarrenBelz 192 Most Valuable Professional
Mohsin Ali 135