Roundtable Events Solution

Liaison Creative + Marketing provides Lunch and Learn Events where its experts discuss a topic.  The Events are open to everyone, and this Solution provides a way for people to find and register for an Event.

The solution has a Power App that provides the interface to Event info which is stored in SharePoint lists. The list of Events can be filtered or the Event titles and descriptions can be searched.  Clicking on an Event shows details about the presentation and a Register button.

Clicking the Register button calls a Power Automate Flow and passes in the user info and Event ID.  The Flow get the user’s name and email address from a Corporate database then writes all of this info to a SharePoint List. Adding this to the list triggers another Flow.

This 3rd Flow pulls the Event ID and Attendee info from the trigger, gets Event info from the Events List, then grabs the Event’s ics file from a SharePoint library. Finally, an Outlook email with the ics file attached is generated then sent to the Attendee.