Microsoft Power Automate Developer

We are sourcing on behalf of a client that is building a scalable integration architecture for an enterprise end-user. This is a contract engagement for an experienced Microsoft Power Automate Developer who can design, build, and document a production-grade automated data flow connecting Microsoft 365 tools to a third-party project management platform via API. The right candidate brings both technical depth and the communication skills to collaborate with a cross-functional team throughout design, build, and handoff.

What You Will Be Building

You will be the primary developer responsible for creating an end-to-end automated workflow that connects a Microsoft Forms intake process to an external project tracking environment. The flow must handle structured data capture, field parsing, hierarchical row creation, file handling, notifications, and third-party scheduling integration — all within a secure, cross-account architecture.

Key Deliverables

• Design and document the full integration architecture including data flow diagrams, connector authentication approach, and error handling logic
• Build and configure the Power Automate flow trigger from Microsoft Forms on new response submission — no polling required
• Develop the response retrieval and field-parsing logic to extract all submitted values, including repeating field sections such as multiple phone numbers, contacts, and carrier data
• Map and transform parsed form fields to the exact column structure required by the destination project tracking platform, including precise dropdown value matching between systems
• Build the row insertion logic that creates a parent row per form submission in the primary project tracker sheet
• Develop the child row loop that iterates over each submitted phone number and writes a corresponding child row — including number type, carrier, and PIN data — into a secondary porting tracker sheet
• Configure the OneDrive and SharePoint file upload logic to save bill documents and LOA files into a structured folder hierarchy organized by brand code and site name
• Build and configure Outlook and Microsoft Teams notification actions — including a confirmation email to the Practice Manager and an internal project team alert summarizing the submission
• Integrate Calendly link delivery via automated email to the Practice Manager following submission, aligned with project management team availability
• Evaluate and recommend the appropriate cross-account authentication method (shared sheet via service account, dedicated API token, or OAuth2 app registration) and implement accordingly
• Deliver clean, commented flow documentation and a handoff package suitable for internal IT administration

Required Qualifications

• 3 or more years of hands-on Microsoft Power Automate development,
  Power Apps, and Power BI
  in a production environment
• Demonstrated experience building multi-step flows that span Microsoft Forms, SharePoint, OneDrive, Outlook, and Teams
• Proficiency with HTTP connectors and REST API authentication methods including API token and OAuth2
• Experience building parent-child data structures and working with loop/iteration logic within Power Automate
• Strong field mapping and data transformation skills, including handling repeating sections and enforcing exact value matching across platform schemas
• Ability to design and implement structured folder creation and file upload routines in SharePoint and OneDrive
• Familiarity with cross-account data access patterns and service account configuration
• Ability to produce clear technical documentation and architecture diagrams
• Experience with workflow automation, business process analysis, and creating custom integrations
• Understanding of APIs, SQL, and cloud computing platforms like Azure
• Strong problem-solving skills and attention to detail
• Collaboration skills for working with cross-functional teams and stakeholders
• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience)
• Prior experience with telecom processes or IoT systems is a plus
• Familiarity with secure networking concepts and data protection practices

Preferred Qualifications

• Prior experience integrating Power Automate with third-party project management or work management platforms via API
• Familiarity with Calendly API or scheduling tool integrations
• Experience building integrations for multi-site operations or onboarding workflows at scale
• Microsoft Power Platform certifications

Engagement Details

• Type: Contract / 1099
• Rate: Up to $75 / hour, commensurate with experience
• Location: Remote
• Duration: Project-based with potential for extended engagement based on performance and scope expansion
• Start: As soon as the right candidate is identified

To Apply - PLEASE READ, you will not be considered if you do not follow these instructions -

Submit your resume and a brief summary of a comparable integration you have built — what systems were connected, your role in the design, and how you handled authentication and error logic. Portfolio links or flow documentation samples are strongly encouraged.

Company Description

Trinity Network Solutions is a trusted technology Advisor and partner of cutting-edge telecom solutions, offering connectivity, collaboration, and spend optimization services tailored to meet diverse business needs. With decades of expertise and partnerships with over 400 carriers and 1,000 products, we deliver scalable, innovative solutions to ensure competitiveness in a dynamic market. Our end-to-end support—from contract negotiations to implementation—ensures a seamless experience. Dedicated to optimization and cost efficiency, we empower organizations through secure networks, modern communication tools, and IoT implementations.