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]))
Try this instead:
SELECT(Employees[Telephone],[Name]=[_THISROW].[Notify When Complete])
I did initially try that but kept getting the error below in the expression window.
Cannot compare Name with List in ([Name] = [TaskID].[Notify When Complete])
Never tried it though because of that error. I will give it a shot to see what happens.
Is Name an EnumList? And/or is Notify When Complete?
[Name] is โnameโ type and [Notify When Complete] is an โenumlistโ
Try this instead, then:
SELECT(Employees[Telephone], IN([Name], [_THISROW].[Notify When Complete]))
Got it, problem solved. I would have never figured that one out. Very nice Steve. Hope you had a good holiday. Thank you much
Got this error
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |