Forum Discussion
Robbo1327
Oct 20, 2023Copper Contributor
Help with Lists Rules and sending emails to Responsible People
Hello Brains Trust, I have created a List to track some disposable curtains for work. I have got all the automation working fine. But when the status changes to Due Soon or Overdue the rule I ha...
Rob_Elliott
Oct 20, 2023Silver Contributor
Robbo1327 rather than using list rules in SharePoint I always do this with a flow in Power Automate which can check when the status column only has changed and will send an email to one or more people with whatever subject line and body content you specify. And it can go to different people depending on, for example, what the status is. You can include dynamic content in the subject line and body, links, company logo etc. It's a more flexible, better approach in my opinion than rules.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)