I am having a column sent email to department head
column datatype is enum list with ref has Employee table where the email Id is the key
I need to select two Department head in that column and sent workflow
Can anyone suggest solution
Solved! Go to Solution.
Set item seperator to space comma space first and then set a Valid_if expression:
SELECT(
Employess[KeyColumnName],
TRUE
)
In your email workflowโs TO property, you can directly refer to that ENUMLIST column as itโs a list of email values.
I am ref the employee table but i am not getting value in the column Enum list
@Gunasuriya_Ravi
Your Base Type shall be set to REF and then select the REF table.
i have given the same you told,but i am not getting the values in column
Set item seperator to space comma space first and then set a Valid_if expression:
SELECT(
Employess[KeyColumnName],
TRUE
)
thanks Leventk its working
Youโre welcome
User | Count |
---|---|
43 | |
29 | |
23 | |
21 | |
13 |