Microsoft 365 SharePoint, Power Apps & Power Automate Solution Architect

I am looking for an experienced Microsoft 365 Solution Architect to design and build a reusable workflow management framework using SharePoint Online, Microsoft Lists, Power Apps, and Power Automate. This is not a simple SharePoint list or Power Automate flow. I am looking for someone who understands data architecture, business process automation, and scalable Microsoft 365 solutions. Project Goal Develop a modular framework that can: * Manage organizational requests * Assign work to one or multiple departments * Track each assignment independently * Route requests automatically based on request type * Collect and organize supporting documentation * Provide dashboards and reporting * Be expanded with new request types and workflows without redesigning the application The framework should be designed for long-term growth. Core Components Request Management Create a request management solution that supports: * Dynamic request forms * Multiple request types * Document uploads * Status tracking * Approval routing * Automatic request numbering Task Management Develop a task management framework capable of: * Creating one task assigned to multiple departments or users * Tracking progress independently for each assignment * Rolling assignment progress into an overall task status * Managing due dates and overdue work * Supporting recurring and one-time tasks Workflow Automation Using Power Automate, develop reusable workflows that: * Generate unique IDs * Create assignments automatically * Route requests based on request type * Update statuses automatically * Flag overdue tasks * Notify users * Support document routing * Minimize duplicate data Power Apps Develop dynamic forms that display fields based on the selected request type and enforce required information before submission. Reporting Design list views and reporting structures that support operational dashboards and future Power BI integration. Deliverables * SharePoint List architecture * Power Apps * Power Automate workflows * JSON column formatting (where appropriate) * Solution architecture diagram * Data model * Deployment documentation * Configuration guide * Exportable solution components Development Requirements Development must be completed in your own Microsoft 365 environment using sample data. No production Microsoft 365 access will be provided. No confidential information will be shared. The final solution must be deployable into another Microsoft 365 tenant. Required Experience Please apply only if you have experience designing complete Microsoft 365 business applications using: * SharePoint Online * Microsoft Lists * Power Apps * Power Automate Please include examples of similar solutions you have designed. Before Development Begins The selected freelancer will first produce: * A proposed solution architecture * A data model showing relationships between requests, tasks, assignments, and supporting lists * An implementation roadmap Development will begin after the architecture is reviewed and approved. Definition of Success The final deliverable should be a production-ready Microsoft 365 framework that can be deployed into another Microsoft 365 tenant with minimal modification. The architecture should be modular, scalable, and easy to maintain. I expect well-documented list relationships, reusable Power Automate flows, configurable Power Apps forms, and a solution that can support additional request types, departments, and workflows without major redesign. When you apply, please start your proposal with the words “Workflow Architect” so I know you’ve read the entire project description. Also include a brief explanation of how you would design a system where one task can be assigned to multiple departments while tracking each department’s progress independently.