I am trying to automate a process within my business and would like to see if this would even be possible in the way that I have envisioned.

One of the things my team handles. Is our businesses domain estate. Our domains have a listed "Business owner" from inside the business. Every month we need to reach out to those business owners where a domain is coming up for expiry to ascertain if the respective domain is to be renewed or not.

I have setup a SharePoint list, key fields being the domain, expiry date, 60 days from expiry and 30 days from expiry.

I was looking to run a few daily workflows that check on the 60 days and 30 days column and send an email to the business owner to attain renewal status (Renew yes/no).

One of the things is, we have multiple domains with the same business owner. So I would like to try and refrain from sending a person multiple emails per domain and try and collate all domains expiring around the same time in to one email.

So, I would like to try and loop through my list, locate the domains expiring within 60 days take all the domains with the same business owner and email that person at once, listing each domain in the email.

I don't know if I have used the correct process. But at the moment, I have the following:

Stage 1

If CurrentItem: 60 Days remaining equals Today

Loop: 1

The content of this loop will run repeatedly while: CurrentItem:Email Group equals Group 1

(i have gone through my list and added Group 1, 2, 3, etc.. where we have domains listed against the same business owner. So, all domains by Joe Blogs has Group 1, all domains by John Doe are Group 2, etc..)

Build Domains Dictionary (Output to Variable: Domains)

Then Build Expiry Dictionary (Output to Variable: Expiry)

Then Email CurrentItem: Business Owner Email Address

I will then do another loop for Email Group equals Group 2, then Group 3, etc..

The point where I am stuck, is trying to build the email and ensure that I list each domain and the expiry date in an eligible way. Rather than just listing the string of domains as a string and then the expiry dates as a string, with no real correlation between what domain has which expiry date.

Any input would be appreciated!

Thanks for taking the time to read all this!


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.