Unanswered

Flow to Email A weekly SharePoint Calendar Events

(0) Share

Report

Posted on by Community Power Pla...

Hello - I am working on building a flow that will generate emails of the next 8 days of events scheduled every Monday at 0700. I'd like the email to list the Event Title (possible link to the Sharepoint event page, Date, and Start time.

I've been following https://natechamberlain.com/2019/12/22/send-a-weekly-email-of-upcoming-events-with-add-to-calendar-ics-download-links-using-power-automate-flow/ but I'm stuck the Start Time converting from UTC. I can't get the Hyperlinks to activate in the Events and sorting for Date is completely wrong.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-duann-msft on at

Like (0)

Report

Hi @Anonymous

Thank you for posting.

According to your description, you are trying to get calendar event from SharePoint and sending results via email. But currently stuck the start time and hyperlinks. If any misunderstood, please kindly let me know.

I tried the article you provided and succeeded at the first time. The article is amazing and no problem at all.

Here is my flow and details for your reference:

Related expression(Please pay attention to the bolded part):
Date: formatDateTime(item()?['EventDate'],'yyyy-MM-dd')

Save: concat('<a href="https://hanxia.sharepoint.com/sites/Annas/_vti_bin/owssvr.dll?CS=109&Cmd=Display&List=%7B0D15ADF9-3F36-4AD5-8930-6B5FFA416A8E%7D&CacheControl=1&ID=',item()?['ID'],'&Using=event.ics">Add to my calendar</a>')

In the 'save' expression, we should update the link using our SharePoint URL and list ID.

You could refer this link as below:
Creating iCal (.ics) calendar item links with a workflow (Power Automate or SharePoint Designer) | NateChamberlain.com

Input of compose: replace(replace(replace(replace(replace(body('Create_HTML_table'),'<','<'),'>','>'),'&','&'),'<table>','<table border="3" bgcolor="ffffff">'),'"','"')
In original article, they lost one ‘replace’ formula by mistake.

Once completed, here is the result:

Hope the content above may help you.

Thanks
Anna

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-duann-msft Thank you.
I don't have any issue with the tutorial. I'm trying to use that as a jumping-off point. (this is my first Flow). I am able to generate the email with events for the next 8 days. Though it would appear that the email is sorting by Creation Date and not the date of the event. The 'Add to my Calendar' option works, but all the options are the same and go to an error page.
I would also like to add into the table the Start Time of the events but that is in UTC time. I'd only need to short time (9:30pm)
I'd also like the Event to be clickable to link to the actual event for more information.
I'd be open to scraping the tutorial completely and building something from scratch, but I'm a bit lost.

Was this reply helpful? Yes No