Announcements
Goodnight.
I'm trying to bring the value in hours from a calculated column in SharePoint and add the hours by pulling it from a gallery.
I got the information in parts, but I don't know how to turn it into hours
Hi @Fioravanti ,SharePoint Calculated columns have significant compatibility/consistency issues when used in Power Apps and should be avoided. If you do the same calculation in a Lable in the gallery, you should be able to get the sum of that.
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.
MVP (Business Applications) Visit my blog Practical Power Apps
Good evening Warren,
Could you please explain to me how to make this configuration?
Good Morning @Fioravanti (10:45am Wed here),
Just use the same formula, but with ThisItem. in front of the field names.
ThisItem = HOUR([Quantidade de horas])+MINUTE([Quantidade de horas])/60I think I'm doing something wrong
@Fioravanti ,
It would be
Hour(ThisItem.'Quantidade de horas') + Minute(ThisItem.'Quantidade de horas')/60
This way it worked, but when entering the hours of 22:26 the number does not come out as hours
i have 22,4333333333
What result are you expecting ? If you only want two decimal places
Round( Hour(ThisItem.'Quantidade de horas') + Minute(ThisItem.'Quantidade de horas')/60; 2 )
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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 977
Valantis 664
11manish 530
