cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
michaelWu
Helper I
Helper I

PowerApps bulk/group SMS issue

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.

1 ACCEPTED SOLUTION

Accepted Solutions

@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.


Vivek Bavishi aka That API Guy
PowerApps and Flow MVP
Blog | Twitter | YouTube | Community Profile | GitHub



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

11 REPLIES 11

@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.


Vivek Bavishi aka That API Guy
PowerApps and Flow MVP
Blog | Twitter | YouTube | Community Profile | GitHub



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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!

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?

Anonymous
Not applicable

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

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

@Anonymous

 

Yes, you can!

 

You need to use the concat function. Something like -

 

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


Vivek Bavishi aka That API Guy
PowerApps and Flow MVP
Blog | Twitter | YouTube | Community Profile | GitHub



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

@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

 

Spoiler
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
Anonymous
Not applicable

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

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,571)