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)