PowerApps Project Task Tracker

PowerApps + SharePoint + Power Automate – Issue Log & Document Workflow App

Project Description:

I need to build an Issue Log & Document Workflow App in Microsoft PowerApps, connected to SharePoint/OneDrive lists.

Key Features Required:
1. Home Screen (Dashboard):
• Display all studies created.
• Option to create a new study.
• Ability to drill down: Study → Country → Site.
2. Study → Country → Site Navigation:
• From home → select a study → view/add countries → within a country, view sites/issues.
3. File Handling:
• Upload Excel files (per country).
• Assign files with a timeline.
• Assignee can download assigned Excel, upload reviewed Excel, and send back.
• Reviewer can review and either close the issue/country or re-assign back with comments.
4. Status & Workflow:
• Open → In Progress → Resolved/Closed.
• Ability to reopen issues if needed.
5. Reminders & Notifications:
• Notifications when a new file is assigned.
• Automatic reminders if timeline is missed.
• Notifications when a reviewed file is uploaded.
6. Additional Requirements:
• Timeline highlighting (e.g., red if overdue).
• Role-based visibility (only see assigned studies/countries).
• Activity history tracking.

Tech Stack:
• Microsoft PowerApps
• SharePoint Lists / OneDrive for document storage
• Power Automate (for reminders & notifications)

Deliverables:
• Fully working PowerApps solution with SharePoint backend.
• Documentation of setup.
• Short handover session to explain workflows.

Timeline:
• Draft working version within 1 week.
• Full version with automation & reminders within 2–3 weeks.