Automation SMS

[nishat786]

Hello, I have a trouble having sending Automation SMS.

So I have a 2 tables, one is employee with below column

1-Employee name (Type Name)

2-Employee Email(Type ID)

3-Employee Phone(Type Phone)

4-Employee Shift (Type  enumlist) Option to select Morning, Evening or both

5-Employee Shift_Week_Days (Type  enumlist) Option to select (Mon-Fri)

And other is the Employee job shift schedule to filter daily list for the days with the below column

1-Employee Email ID (Type REF to Employee Email)

2-Shift_schedule (Type  enumlist)

3-Shift_Week_Days (Type  enumlist)

4-Phone (Type Phone)

For the employee job shift schedule I have created a slice (Employee job shift schedule Slice) to filter a data based on the below selection

2-[Shift_schedule] (Type  enumlist) 3-[Shift_Week_Days] (Type  enumlist) with this slice formula below

 And(IN([Shift_schedule],SPLIT(employee[Employee Shift],","),

     IN([Shift_Week_Days],SPLIT(employee[Employee Shift_Week_Days],",")

)

Slice works fine it gives me data exactly how I wants it but the one i created a automation to send a SMS. The automation list for the phone number shows blank it does not pick up split data in the automation Process formula i have used this below

Employee job shift schedule Slice[Phone]

[Joseph_Seddik]

4-Phone (Type Phone)

---

What is the formula you use here?

[nishat786]

In the Automation I used 

Employee job shift schedule Slice[Phone]

[Joseph_Seddik]

What is the formula of the Phone column itself? how do you populate it?

[nishat786]

Any(Select(Employee Email[Phone],[_thisrow].[Employee Email ID]=[Employee Email Id]))

[Joseph_Seddik]

Would you please show both your tables and their columns from the AppSheet Editor? 

[nishat786 · Accepted solution]

Sorry can't take screen shot from my phone. I will post tables and their columns from the AppSheet Editor once i get to my laptop.

[nishat786]

Here is my columns Pictures