: Fix My Excel + Power Automate Booking Tracker (Or Rebuild It If Needed)

r/forhire

Overview

Author

u/Stylistic_1

Score

5

Subreddit

r/forhire

Posted

7 months ago

Post Content

Hey, I’m working on automating a workflow using Excel and Microsoft Power Automate. I built a flow that’s supposed to update rows in a booking tracker Excel sheet based on incoming Outlook emails. The logic uses 4 key identifiers (Program Name, Date, Time, and Location), but the updates aren’t happening reliably. I think something is off with the way the flow finds and updates rows, or maybe the setup just needs to be redone from scratch. Right now, I manually update booking statuses based on emails I get through Outlook. I want the flow automated: when an email comes in matching a certain phrase or field (like PO number or booking number), it should automatically update the right row in the spreadsheet. There’s a semi-working Power Automate flow built but it’s buggy, either overwrites wrong rows or misses updates. I’m working on automating a workflow using Excel and Microsoft Power Automate.

We can do $40/hr or a flat fee, whatever you prefer. DM ME!

Here’s what I need help with:

  • Reviewing and debugging the current flow
  • Ensuring emails trigger the correct row updates
  • Handling edge cases (missing fields, duplicates, etc.)
  • Optionally improving the logic or visuals in Excel (color-coding, checkboxes, etc.)
  • Possibly refining the email-to-data matching logic

I already have the Excel file and current flow set up—just need someone experienced to take a look and help me get it working smoothly.

Tech stack:

  • Excel (Microsoft 365)
  • Microsoft Power Automate
  • Outlook (for triggers)

Post Statistics

Upvote Ratio 86.0%
Comments 4

Get Notified of New Jobs

View on Reddit
Kindly ensure you thoroughly verify the legitimacy of the post

Contact Us

Struggling with a tough assignment or facing a tight deadline? Our brilliant academic minds are available 24/7 to provide you with the expert writing guidance and personalized support you need - simply click below and scan to connect with us through our social media presence anytime.

Or you can email us at: