Share
Report
2Hi everyone,
I’m working on my first Power Automate flow, and I’ve been stuck on this for about eight weeks now. I’ve tried troubleshooting using tools like ChatGPT and Microsoft Copilot, but I keep getting led down different paths without resolving the issue, so I’m hoping to get some guidance from those with hands-on experience.
What the flow is supposed to do:
Monitor a shared mailbox for specific reimbursement-related emails
Extract and write the following fields into an Excel file:
Account number
Amount
Partial vs full reimbursement
Date/time
Save each email as a .eml file in a folder (no OCR available in our environment, so PDF conversion isn’t an option)
Important detail about the data:
About 95% of emails contain the account number inside a screenshot
Since we don’t have OCR, the flow cannot read those
Logic should be:
If a valid account number is found → write it to Excel
Account number format = 10 digits starting with 7
If not found → write “Screenshot saved” in that column
Email should always be saved as .eml regardless
The problem:
I was able to get parts of this working when I manually sent test emails
Now the flow is turned ON, but it is not consistently triggering or processing emails
It either:
Doesn’t pick up emails at all, or
Fails somewhere in the process and doesn’t complete end-to-end
Additional context:
I’m using an Excel script for parsing/writing the data
This is all happening within a shared mailbox setup
I suspect the issue could be with:
Shared mailbox trigger configuration
Email filtering logic
Or how the flow behaves outside of manual testing
At this point, I’m not sure if I’ve misconfigured the trigger, misunderstood shared mailbox behavior, or built the flow incorrectly from the start.
If anyone has experience with shared mailbox triggers, .eml handling, or Excel script integration, I’d really appreciate any direction on where to look or what to fix.
Thank you in advance 🙏
Categories:
I have the same question (0)
All responses (
Answers (
