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.