Answered

Teams to SMS Flow

(0) Share

Report

Posted on by chrisgreeson

I have a flow that is triggered When a new channel message is added in Teams and is to send a SMS text message via the Twilio action to all users listed in a table. Unfortunately this only sent to about half of our users yesterday.

The flow is:

When a new channel message is added >> List rows present in a table >> Apply to Each [Send Text Message (SMS)]

The flow status shows Failed even though it sent to 256/493 users.

Unfortunately the error details are not very detailed.

Status: Failed

Error: Action 'Send_Text_Message_(SMS)' failed

Error Details: The 'To' number is not a valid phone number.

Is there any way to test this flow to verify it would send to all of our users...... without sending a text message to all of the users?

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

ChristianAbata 8,953 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

hi @chrisgreeson please allow concurrency control

Was this reply helpful? Yes No
chrisgreeson 16 on at

Like (1)

Report
Copy link

Link copied!

Thank you for that suggestion @ChristianAbata . The setting was off and I turned it on, and set it to 50. We tried the flow again and unfortunately the message still only sent to 256 users. We did however get a different error this time which was:

The message From/To pair violates a blacklist rule.

For now, I'm going to try and create a second spreadsheet with the other 243 users and have the message send to them after sending to the first group. Not an ideal solution, but I will let you all know how it goes either way.

Was this reply helpful? Yes No
chrisgreeson 16 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately, even after separating the users into two different spreadsheets and creating an additional List rows present in a table and Apply to each, I'm still having the same issue.
I did just notice that the table in the first spreadsheet was still approximately 495 rows still and it only had 253 users in it. The first Apply to Each action still showed 256 actions with the last 3 saying "A 'To' phone number is required". I have since adjusted it down to the last user so we'll see if that helps next time its run.
I am concerned that the second "set" of actions didn't run at all.
I haven't changed the 'Apply to each' should run after: check boxes since I don't want multiple messages sent to the same users, but I could be mistaken on how that works.

We will try again tomorrow with the adjusted table size, but if anyone has any suggestions I'm all ears.

Was this reply helpful? Yes No
Verified answer

chrisgreeson 16 on at

Like (0)

Report
Copy link

Link copied!

I ended up finding the answer here: https://powerusers.microsoft.com/t5/Building-Flows/256-rows-limit/m-p/268617/highlight/true#M27279

Thank you @v-bacao-msft !

Was this reply helpful? Yes No