Academic Quarterly Routines for Email

[ellean]

I work in the University system. Every quarter I need to send out emails to faculty, staff, and students. Sometimes it is 2 weeks before the quarter ends. Other times it is the third Wednesday of September. I cannot figure out how to do this in a way that doesn't require much maintenance. I have access to an RSS feed of the academic calendar. I do know the start and end dates of each quarter, but I would prefer not to have to manually input the send dates. Another part is that the emails contain dates, months, and quarters that I would like to update to reflect the most accurate one. For instance, 2 weeks before the start of every term I send an email reminding students to turn in their paperwork and that they have a deadline in a week. In Autumn, the date is one in October, the Winter is in February, and the Spring in May. The flow would, ideally be able to put Autumn/Winter/Spring in the subject/email body in the places I need.

I can't wrap my head around a suitable algorithm so I would love any help y'all.

[Jcook]

Hello @ellean
Can you provide some more information on the RSS feed.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[ellean]

Thank you @Jcook for responding! The RSS feed is from a public calendar system called Trumba. My university uses it. This is the link to what I use: webcal://www.trumba.com/calendars/sea_acad-cal.ics

[ellean]

I figured out this flow: list the events on a calendar ->apply-to-each->if event-date is less than 14-days->send email.

My problem now is getting the email to parse right. I am trying to split the summary of the event, but every time I try to split() the dynamic event description I am told my expression is invalid. I try split(items('Apply to Each')?['summary'],"Quarter: ") but that is where I get invalid expression. When I try to use the dynamic content to replace the items() part, then I can't get that dynamic content to come up. If it is outside the split, it will show up.

I am so baffled. Can anyone help me work past this hurdle?