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 / SMS Feature and Number...
Power Apps
Answered

SMS Feature and Number Field with Decimal

(0) ShareShare
ReportReport
Posted on by 39

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 

Screenshot_20200808_093504.jpg
Screenshot_20200808_093651.jpg
Categories:
  • eka24 Profile Picture
    20,925 on at

    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.

  • Verified answer
    AzJackson Profile Picture
    39 on at

    Thank you for the suggestion, however it keeps show as an error in the code

     

    The code without your addition is:

    Launch("SMS:"& PhoneNumber,"body",   ................................ (various other look ups for the sms  message, using the below format)
    & "Total Mileage: " & BrowseGallery.Selected.'# Miles Travelled' & " ")
  • Verified answer
    eka24 Profile Picture
    20,925 on at

    I suggest you create a collection OnVisible of the screen:

    ClearCollect(MyTableCol,AddColumns( Datasource,"MilesTravelled",
    Left ('# Miles Travelled', Find (".",'# Miles Travelled')-1)));
     
    Put the collection on the browse Gallery: MyTableCol  
    Also change one of the labels inside the Gallery to: ThisItem.MilesTravelled
     
    Finally alter your Launch formula to :
    Launch("SMS:"& PhoneNumber,"body",   ................................ (various other look ups for the sms  message, using the below format)
    & "Total Mileage: " & BrowseGallery.Selected.MilesTravelled & " ")
     
    ------------

    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.
     
  • Verified answer
    A-HJ Profile Picture
    20 on at

    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

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 220 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 189 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 139

Last 30 days Overall leaderboard