Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

How to use Dataverse to create a rota management system

Hi all, I am new to power platform but have been referring to it a lot the past week for r&d, and found it with some invaluable advice!

I am currently undertaking some customizations that integrates with multiple Microsoft 365 services and the use case scenario it is to create a theatre ticketing system and the theatre has multiple theatres across geographical locations. A theatre movie hall can store up to 20, 40, 50 viewers. Potential number of viewers (500) are already known. Also, every theatre can have multiple movie halls and a single movie hall can at one-point show one movie and dependent on movie length value which is between 2hours to 3hours.

Though once the box office comes out with a movie listings for each month there is a person who is A theatre manager that manages a single movie hall out of many in the city and makes a rota of which move playing at what time as well as keeps track of movie rating for each movies so that the best-selling movie goes to the biggest movie hall. 

The core functionality to include: campaign (phonecall - this runs when there is a new box office movie release and each viewers are contacted if there is affirmation from the viewer to see the movie a ticket is considered sold to the viewer), rota management system (triggered when a box office release movie listings comes out) - Rota process is e.g. 40 movies out in different dates of the month/next month and Movie 1 runs on movie hall 1 and Movie 2 will run on movie hall 2 between x time.

I have a question and it is how do I go about structuring the delivery of this solution i.e. creating a dataverse table for each related entities - any tips on where to start?

Thanks in advance for anyone's guide/help.


Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (2,000)