Skip to content

Suresh-rsa/Parking-Management-System

Repository files navigation

Parking Management — Power Platform (Dataverse • Power Apps • Power Automate • Power BI)

About

This is my end-to-end Parking Management solution built on the Microsoft Power Platform.
It demonstrates a realistic workflow to manage Vehicles, Parking Requests, and Parking Inspections with automation and analytics.

What is this project?

A complete, importable Solution (Dataverse, Model-Driven App, Canvas App, Power Automate) plus a Power BI report for insights.
New users can import the Solution, connect the Power BI file, and start exploring within minutes.

▶️ **Demo Video (10 min):https://youtu.be/aOdI1M42ZOI 📄 **Challenge Brief (PDF): Document uploded in the file section

Requirements

  • Power Platform environment with permission to import a Solution (Dataverse enabled).
  • Power BI Desktop to open/refresh ParkingReview.pbix.
  • (If email notifications are used) an authenticated Outlook/Email connector during import.

What I Built

  • Single Power Platform Solution (everything packaged here):
    • Dataverse tables: Vehicles, Parking Requests, Parking Inspections (+ forms, views incl. “Today” views).
    • Model-Driven App for operations.
    • Canvas App (tablet) with Home, Review (Today), New Inspection, New Vehicle using modern controls.
    • Power Automate flow(s) for notifications.
  • Power BI report (ParkingReview.pbix) with pages:
    • Home, Filters, Parking Review
    • Measures: Total Inspections, Total Requests (valid), % Inspections with valid requests
    • Bar chart split (Valid vs Not), matrix by vehicle, details table with link back to an inspection.

Repository Layout

├─ solution/ # All Power Platform assets packaged as one Solution │ └─ ParkingManagement_Unmanaged.zip ├─ powerbi/ │ └─ ParkingReview.pbix # Power BI report (not part of Solution) ├─ docs/ │ └─ Parking Challenge Instructions v2.3.pdf └─ README.md

How to Run (Step-by-Step)

1) Import the Solution

  1. Power Platform → SolutionsImport
  2. Select solution/ParkingManagement_.zip
  3. During import, map Connection References (e.g., email) and any Environment Variables if prompted
  4. Wait for the import to complete successfully

2) Turn On the Flow(s)

  1. Open Power Automate, find the parking flow(s)
  2. Turn on the flow(s)
  3. Fix connector sign-ins if needed (Outlook/Dataverse)
  4. Create a sample Parking Request to test notifications

3) Open & Use the Apps

  • Model-Driven App: manage Vehicles, Requests, Inspections; verify “Today” views
  • Canvas App (tablet):
    1. Open the app
    2. Create a New Vehicle (if needed)
    3. Create a New Inspection
    4. Use the Review screen to see today’s inspections

4) Open the Power BI Report

  1. Launch Power BI Desktop and open powerbi/ParkingReview.pbix
  2. Go to File → Options and settings → Data source settings
  3. Select the Dataverse source → Edit Permissions (or Clear Permissions then Edit) → Sign in with your org account
  4. If prompted for an environment, select your Dataverse environment; then Close
  5. Click Refresh to load data and review pages (Home → Filters → Parking Review)

Troubleshooting

  • Import errors: usually a missing connection reference; re-map during import.
  • Flow not running: ensure it’s On, connectors are authenticated, and create a new Parking Request to trigger.
  • Power BI refresh fails: re-authenticate to Dataverse in Data source settings; confirm table/column names match your environment.
  • No “Today” data: check system date/time; ensure sample/request dates align with “today”.

Contact

Maintainer: Suresh-rsa · Email: [email protected]

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published