web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / PowerApps bulk/group S...
Power Apps
Answered

PowerApps bulk/group SMS issue

(0) ShareShare
ReportReport
Posted on by michaelWu 43

Our users want to do send message to multiple phone number. I tried to use "Launch(sms:xxxxxxxxx,xxxxxxxxxx...)" function, but it can only send to the first number.  

Any one know how to do bulk SMS in PowerApps? Any help will be apprciated.

Categories:
Building Power Apps
I have the same question (0)
  • Verified answer
    ThatAPIGuy Profile Picture
    ThatAPIGuy 925 on at

    @michaelWu

     

    if all your users are iOS users , try this -

     

    Launch("sms:/open?addresses=xxxxxxxxx,xxxxxxxxxx")

     

    I am not sure if this would work on android or not.

  • michaelWu Profile Picture
    michaelWu 43 on at

    Thank you so much, vivekb! It works very well!  I just want to add that the phone number can not contain space, otherwise it will show "+" on the message screen.

     

    Thank you so much again!

  • leyburn19 Profile Picture
    leyburn19 2,157 on at

    I sort of get this working but at the end of the addresses I always get an addtional called Friend.  How do I stop that?

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi, 

    thnx for the tip.

    Is there someway to retrieve the phone numbers from a table or collection and "insert" them after "...adresses="?

    Rather than hard coding the numbers i n the code.

     

    Regards

  • leyburn19 Profile Picture
    leyburn19 2,157 on at

    Use the concat().  in the below example I set a string variable with all the mobile numbers I listed in a collection.  The collecion is filetered on a particular group of mobiles.  You could replace the collection with and source.  The only issue you get is there is a "," at the end of the variable.  So you can remove that with the left().  I then simply put the Variable in the Launch string

     

    Set(sms1a,Concat(Filter(mlista,Gp2=Dropdown1_1.Selected.Value),Mob1a &","))

     

    sms1a = new variable

    mlista = collection - can be a datasource

    Gp2 = Column in collection with a group name

    Mob1a = Coloum in Collection with the mobile numbers

  • ThatAPIGuy Profile Picture
    ThatAPIGuy 925 on at

    @Anonymous

     

    Yes, you can!

     

    You need to use the concat function. Something like -

     

    .. address="&Concat(TableName, NumberColumnName,","))

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    @ThatAPIGuy, @leyburn19

     

    I've tried to create a collection and then use the concat function.

    ClearCollect(Samling1;Kontakter) ;; Launch("sms:/open?address="&Concat(Samling1;Telnr;","))

     

    This works fine with email but I can't get it to work with text messages.

    The app opens "messages" on my iphone but I only get the first number in the column. And I get the same result if I go to the datasource directly.

    When i test the app in a browser it works. I can read all the phone numbers i the adress bar of the browser. But on my iPhone it doesn't

     

     

    Samling1 is the collection I create

    Kontakter is the datasource

    Telnr is the column with the phone numbers

    Note that I have to use ";" instead of "," in the code due to language differences

     

  • leyburn19 Profile Picture
    leyburn19 2,157 on at
    Spoiler (Highlight to read)
    Try
    ClearCollect(Samling1;Kontakter) ;; Launch("sms:/open?address="&Concat(Samling1;Telnr & ","))

    I assume the use of ; instead of , relates to the country version for the App
    TryClearCollect(Samling1;Kontakter) ;; Launch("sms:/open?address="&Concat(Samling1;Telnr & ","))I assume the use of ; instead of , relates to the country version for the App
  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Tried it and it didn't work. Smiley Indifferent

    It's like the phone doesn't get the whole string.

    Could it be iOS related?

     

    And you are right it's the country version

  • leyburn19 Profile Picture
    leyburn19 2,157 on at

    Can I suggest you simplfy by putting the numbers into a text variable first and then using the variable in teh launch.  That is how I do it

     

    Set(SMSvar,Concat(.....)); Launch(SMS....)

     

    By doing this you aslo can now view teh variable to see what it contained

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

News and Announcements

Welcome to the Power Platform Communities

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

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 305 Most Valuable Professional

#2
11manish Profile Picture

11manish 212

#3
Valantis Profile Picture

Valantis 167

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans