Hello,
I have a workflow that I want to use to trigger an SMS. In the phone numbers expression box I put the following expression, but it is not working. When I check the log it says I keep getting an error saying that no number was put in the “TO” field.
SELECT(Employees[Telephone],Employees[Name]=[_THISROW].[Notify When Complete])
It works fine when I just put Employees[Telephone], but it send everyone in the Employees table a SMS. I am trying to only send an SMS to the employees that I selected in the [Notify When Complete] dropdown.
TIA.
Solved! Go to Solution.
Try this instead, then:
SELECT(Employees[Telephone], IN([Name], [_THISROW].[Notify When Complete]))
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |