cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to send multiple text messages with Twilio

 

Hello All, 

 

I would like to send multiple text messages with Twilio.

Currently I can only put one phone number under ( to phone number).

I tried to put a comma, semicolon, and others but I am not successful. 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: How to send multiple text messages with Twilio

Flow.PNG                                                                                                So this is how I was able to send multiple text messages.

Using Excel Online or Google Sheets. With Excel Online you need to add a Microsoft Flow add-in. In Excel click on Insert/Office Add in. Create a table in Excel with 2 columns Name and Number. In Flow: add your trigger, Excel (List Rows Present in Table), then Twilio action. This will create the (Apply to each) with the Twilio inside. Put the column Number for: TO PHONE NUMBER. Insert name column to add in the names. This will send a text to the Name associated to the number. 

 

Hope this helps someone. 

 

 

I got the idea from this link:  https://www.howtoexcel.org/microsoft-flow/sending-sms-text-messages/

 

View solution in original post

4 REPLIES 4
Community Support
Community Support

Re: How to send multiple text messages with Twilio

Hi @Anonymous ,

 

Are you using Twilio action Send Text Message (SMS)?

 

It seems that currently only one phone number is supported. If you would like to put multiple phone numbers in the To Phone Number field, please feel free submit a request at here:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

I will suggest other customers who have the same request vote your idea as well.

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
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: How to send multiple text messages with Twilio

Flow.PNG                                                                                                So this is how I was able to send multiple text messages.

Using Excel Online or Google Sheets. With Excel Online you need to add a Microsoft Flow add-in. In Excel click on Insert/Office Add in. Create a table in Excel with 2 columns Name and Number. In Flow: add your trigger, Excel (List Rows Present in Table), then Twilio action. This will create the (Apply to each) with the Twilio inside. Put the column Number for: TO PHONE NUMBER. Insert name column to add in the names. This will send a text to the Name associated to the number. 

 

Hope this helps someone. 

 

 

I got the idea from this link:  https://www.howtoexcel.org/microsoft-flow/sending-sms-text-messages/

 

View solution in original post

Community Support
Community Support

Re: How to send multiple text messages with Twilio

Hi @Anonymous ,

 

Thanks for updating and sharing.

It will be helpful for other customers as well.

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
larrybolton
New Member

Re: How to send multiple text messages with Twilio

Here's another method that doesn't require an Excel connection.

  • Create an array type variable.
    1306 array.png
  • Pass each of the 'To:' phone numbers into the array using the 'Append to array variable' action. This can either be done one at a time or in a loop if the numbers are stored in a list.
    1309 array.png
  • Use an 'Apply to each' action to loop with the '
     
    Send Text Message (SMS) action.
    1312 array.png

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (5,845)