Power Automate using Eventbrite, Excel, OneDrive and Dynamics 365-A Success Story

The fun part of this success story is it driven from a need from our team at A BC Consulting Group. Next week in San Antonio, Texas, we will be hosting the first annual BC Bash- an all BC celebration for the community. Several of my sponsor friends have partnered with our group to both sponsor the party and give out free drink tickets to the registered attendees.

Here is our challenge and how we solved it with Eventbrite, the Power Platform and later Dynamics 365.

Challenge: Attendees are registered on Eventbrite but they must be registered to pick up tickets at the sponsor booths in the expo hall at Summit NA. Our company owns the Eventbrite account and cannot share the credentials for the other sponsors. We needed a way to share the attendees list and make sure that we mark which attendees have picked up drink tickets, so the list we needed to share needed to be both interactive, refreshed often and able to be edited by external users to our organization.

Solution: I researched if Power Automate had a Eventbrite connector and was so happy to find out that they in fact did have a connector already available.

Step One: Create an Excel File with headers and columns and make it a table. Then save it as a file in OneDrive.

Step Two: Create the flow and use the connector step- when an order is changed. Heads up: when we first ran the flow- it synced all orders for the event.

Eventbrite connector name: When an order changes (V2)

Then compose to get the individual email addresses

Then populate the Excel file by adding a new record to a table

Step Three: Test the flow and watch it populate the Excel spreadsheet.

Step Four: Since the file is shared with our Sponsors using a online Excel file, all teams can see the file and edit it to mark drink tickets as a Yes, when they are picked up.

Step Five: Post event, we can then create the same flow and send the data to the Dataverse tables so that they sync to Dynamics 365 for our marketing list post-event. How cool!

Thanks to my amazing team member and Power Platform guru Kyle Hikalea for the help on this one. The fun part is that it only took us 10 minutes to solution and build this!

Hope it helps someone else get inspired to use Power Automate!

Shannon