Hi, can anyone help me troubleshoot this error please?
Iโm creating an action that will send a mass sms to contacts within a column. In the TO field I have the following expression: =TEXT(Sheet1[Mobile])
Iโve got a sheet with a bunch of contact details for people with the following headings; โFirst nameโ, โSurnameโ, โMobileโ, โEmailโ, โPositionโ
This works perfectly fine on Android, however when I test it on an Apple phone, only the first number gets added in.
Is this an iphone error or an error in my expression?
@Harry thanks Dinh. When I tried that, I get the following error message: โThe expression is valid but its result type โListโ is not one of the expected types: Phoneโ
@Robert_Wengritzky Hi Robert, please give us the following information:
1/ The name of the app 2/ The name of the affected action 3/ The model and OS version of the iPhone that you tested
Also, when you said that โonly the first number gets added inโ, did you mean that only the first phone number in column โMobileโ actually received the SMS?
@Harry Hi Dinh,
only the first number in the column actually gets added to the recipients section of the native iphone sms app so only the first phone number would actually receive the SMS if I sent it. This occurs only on iphone in my testing as when Iโve tested it on Android systems, every number in the โMobileโ column will get added to the recipients / get sent.
I only have access to a few iphones for testing but so far itโs happened on iphones from iphone 6 to X (on the native sms app, havenโt tried it with other sms apps yet).
Name of the app: FrankstonAnaesthesia
Name of affected action: SmsAll
Regards,
Rob
@Robert_Wengritzky Hi Robert, the โToโ field of the action expects a list of discrete phone numbers, not a single text value. Hereโs the difference:
Single text: โ111 111 1111, 222 222 2222, 333 333 3333โ
List of phone numbers: { โ111 111 1111โ, โ222 222 2222โ, โ333 333 3333โ }
Regardless of how many phone numbers are contained with the text value, to the app this text value is treated as only a single value. What you need instead is a list of multiple text values, each of which is a single phone number. To construct this list, you can try this expression:
ConsultantsData[Phone Number] + Registrars[Phone Number]
@Robert_Wengritzky Hi Robert, after consulting with my colleague, I believe actions currently do not support sending SMS to multiple phone numbers yet. The expression that you are currently using therefore can be counted as a โhackโ, i.e. it works for Android even though it is not meant to work.
However, it is possible to send multiple SMS to multiple phone numbers using workflows. With a workflow, you can manually add individual numbers, or you can use an expression that creates a list of phone numbers (similar to the one that I suggested). This means that you can create an action that will trigger a workflow to send the SMS as a workaround.
We will look into supporting multiple phone numbers for SMS actions as well in the future.
hello,
is the multiple sms action availibale already?
@Harry Ok, thank you Dinh. I will try a workflow workaround in the meantime. Thanks for the assistance!
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |