Hi,
I have app which uses the user phone to send an SMS.
When the sms is populated the number fields populates with a decimal and several zeros.
The field the app is looking up from SharePoint does not have decimal in it, it is a whole number filed.
I have applied a fix to the app using the "#" format in the app as the app was originally showing decimal places.
Is there anyway to remove the decimal and zeros that follow in the sms.
See screenshot attached
Solved! Go to Solution.
Thank you for the suggestion, however it keeps show as an error in the code
The code without your addition is:
I suggest you create a collection OnVisible of the screen:
Thanks, works perfectly
Also found another way to fix it to, as the data is pulling form a SharePoint list i also changed the formula of the SharePoint list to
=TEXT([Column 1]-[Column 2],"#")
which also works and removes the need for the additional formula in PowerApps, thank you tho
Try
Left (Textbox1.Text, Find (".", Textbox1.Text)-1)
Replace Textbox1 with yours
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Thank you for the suggestion, however it keeps show as an error in the code
The code without your addition is:
I suggest you create a collection OnVisible of the screen:
Thanks, works perfectly
Also found another way to fix it to, as the data is pulling form a SharePoint list i also changed the formula of the SharePoint list to
=TEXT([Column 1]-[Column 2],"#")
which also works and removes the need for the additional formula in PowerApps, thank you tho