cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
michaelWu
Level: Powered On

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
Super User
Super User

Re: PowerApps bulk/group SMS issue

@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
Super User
Super User

Re: PowerApps bulk/group SMS issue

@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

Highlighted
michaelWu
Level: Powered On

Re: PowerApps bulk/group SMS issue

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
Level 10

Re: PowerApps bulk/group SMS issue

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

Re: PowerApps bulk/group SMS issue

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
Level 10

Re: PowerApps bulk/group SMS issue

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

Super User
Super User

Re: PowerApps bulk/group SMS issue

@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

Re: PowerApps bulk/group SMS issue

@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
Level 10

Re: PowerApps bulk/group SMS issue

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

Re: PowerApps bulk/group SMS issue

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
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,723)