I have teams in Forms. Is it possible to use those teams to send emails from Workflow please? Thanks.
Priya
Hi Priya,
From workflow you can use the query activity (from sql database of Forms) to retrieve emails of team members, and use them to send an email. Use the next query:
select team_id,teams.name as team,team_members.user_id,username,email from team_members, cf_users,teams where team_members.user_id= cf_users.user_id and team_members.team_id=teams.id
I hope you answer your question, Please remember to mark my response that answered your question so others know that this post has been completed.
regards,
Marco.
Hi - What if you wanted to email anyone in a specific role for a team?
SELECT cf_users.email
FROM cf_users
JOIN team_members ON team_members.user_id = cf_users.user_id
JOIN team_member_team_role_mapping ON team_member_team_role_mapping.team_member_id = team_members.id
JOIN team_roles ON team_roles.id = team_member_team_role_mapping.team_role_id
JOIN teams ON teams.id = team_roles.team_id
WHERE teams.name = @teamname
AND team_roles.name = @rolename
Thanks