PowerApps Round, RoundUp, RoundDown, Int, and Trunc functions just like in Excel

[@jhhatcher1885]

Whoo Hoo - you've done it again. Thanks

[@juandavila4035]

Thanks for your videos. They are very useful. You are the best

[@ShanesCows]

So nice of you 🐶

[@iyengar007]

Thanks Shane. Never knew Round has so many nuances around it. On collections; can I make a request? Can you demo, how to join two SharePoint List in Gallery using collection and update them back. Easy peasy lemon squeezy for you or share some reference is fine too. Basically managing multiple Data Sources in one Gallery of Power Apps

[@sundrapillay6668]

Thanks Shane

[@ShanesCows]

Happy to help Sundra. 😀

[@SwadDashcam]

Greetings,
TRUNC is useful to convert MS date time as a number to just a date with no hours or minutes.
Thanks for the great videos

[@ShanesCows]

Thanks for sharing 😀 and you are welcome

[@rinzzrockzz]

Is it possible that , the number in the input box itself can be rounded after focus out.
Like if 99.99 is entered in textbox. It should be converted to 100 after tab or mouse out.
@Shane Young

[@kayfax672]

If anyone, like me, was looking here how to round to a bookkeeping format (two decimals, either a zero or a five as last digit), this would be it straight copied from excel: Text(Value(Round(TextInput2*2;1)/2);"#,###.00")

[@ShanesCows]

Thanks Kay! :)

[@ahtiblumkvist]

Is it possible to convert text input field leading zeros? For example, i have quantity field in a gallery, which has MaxLenght of 2 and if user enters 05, it would convert it automatically to 5?

[@ShanesCows]

Value("00005") would output 5 :) So try wrapping Value(TextInput1.Text) to get rid of those zeros.

[@droganPaul]

Really useful videos, a helpful drip feed of information! Thank you

[@ShanesCows]

Glad to help. 😀

[@InfosenEclair]

Thank you 🤗🤗

[@ShanesCows]

You are welcome 🙏