Microsoft 365 / SharePoint + Power Automate Expert Needed

Required: We are a small company looking for a high-level Microsoft 365 / SharePoint / Power Automate expert to build a structured operational system. This is a real-world dispatch / transport workflow, not a basic setup. 🔧 PROJECT OVERVIEW We need to build: A controlled job template (Word / WhatsApp / Email) A central Address Master database (SharePoint) Power Automate flows for automation Smart logic for: Dates Times Vehicle selection Multi-stop jobs Verified location data 👉 A full detailed specification is attached — please read it carefully before applying ✅ CORE REQUIREMENTS (SUMMARY) The system must include: 1️⃣ Structured Template Dropdown fields and prompts (no free typing mistakes) Clean, consistent output for drivers Fixed wording controlled centrally 2️⃣ Date & Time Logic Collection Date = default today, formatted: Mon 20th Jan '26 Delivery Date = default ASAP Collection Time: Fixed time (e.g. 09:00hrs) OR time window (e.g. 09:00 – 10:00) Default = current time rounded to nearest 30 mins Delivery Time = default ASAP with override options 3️⃣ Vehicle Selection + Logic Must support structured selection: Vehicle Type (van → artic) Body Type Tail lift / equipment 👉 NOT one dropdown — separate structured fields 🚨 IMPORTANT (CORE LOGIC) If fields are left blank, system MUST apply defaults based on vehicle: Weight → auto “TBC (Max Weight Xkg)” Item(s) → auto pallet capacity per vehicle Dimensions → auto max vehicle dims 4️⃣ Address Master System (SharePoint) Must: Save addresses (no retyping) Store: Full address Contacts Special instructions Google Maps What3Words Allow 1–3 images per address 📍 Location Logic New address → UNVERIFIED + auto map link Verified site → exact pinned link + verified status Output must clearly show: VERIFIED ✅ or UNVERIFIED ⚠️ (approximate only) 5️⃣ Multi-Stop Jobs Multiple collections ✅ Multiple deliveries ✅ “Add another stop” functionality 6️⃣ Power Automate Flows You will build: Flow 1: Address save/upsert Flow 2: Location verification logic Flow 3: Template generator 7️⃣ Excel Integration (Preferred) Read from Daily Job Sheet Auto-save addresses ✅ DELIVERABLES SharePoint Address Master system Clean Power Automate flows (structured, not messy) Controlled template Fully working logic (as per spec) Brief handover ⚠️ STRICT REQUIREMENTS Only apply if you: ✅ Have strong experience with: SharePoint Lists (advanced structure) Power Automate (conditions, expressions, logic) Real workflow automation ✅ Understand: Data reuse + system design Operational workflows (not just theory) ❌ DO NOT APPLY IF: You only know basic Power Automate You rely on templates without understanding logic You cannot handle duplicates / edge cases ✅ TO APPLY Include: Example of similar system built Answer: How would you prevent duplicate address entries? Confirm: Have you used SharePoint Get Items + filter query? 👉 Start your proposal with: GPS Build – Address System