I have a problem I though Power Automate would be perfect for, but I can find any existing Flow solutions for it.
I receive many dozens of duplicate emails a day in my Outlook inbox as a result of being included on more than one distro list, and/or part of a "redirect" rule. This obviously clogs up my inbox and causes all kinds of headaches. Since I can't really control which distro lists or redirect rules I'm placed on, I was hoping there was a way to have a rule that when an email arrives, it checks my inbox and if that email already exists, it deletes the new one (or sends it to a subfolder, etc.).
Is this even theoretically possible with PA?
Please see my example below and let me know if this is what you need. Please note the single quotes in my search filter.
You could definitely come up with something that could accomplish this. The tricky part would be creating the logic that determines what defines an email as a duplicate. You can do something like:
When a new email arrives, compare against the last 50 emails or something and if the subject and first 50 characters of the body match any of those emails, delete it or move it to subfolder.
You won't be able to compare the from or to addresses if some of them are to distros or forwarded from another account. And you'll have to strip things like FWD or something like that from subject lines for forwarded emails and so forth. But it definitely could be done.
I implemented this and let it run over the weekend. It's failing in the Conditional. Doesn't like the logic expression.
This is the expression I have in the Condition:
Did I typo something?
Your expression should reference body/value rather than body. You should have selected Value rather than Body from Dynamic properties.
I fixed the expression, but now it's applying it to every email. My "If yes" action was set to move the duplicate into a sub-folder (or at least that was my intention), but since making the edit to the expression, every email is being moved into the sub-folder. Unfortunately, given the week, I haven't received any duplicates yet since making the correction - so I'm not sure yet how those are behaving.
First, turn off your Flow so that it doesn't do any damage or cause you work.
Then, please post a screen shot of the Flow.
Yeah... I've certainly done that before (caused damage and/or created a lot of clean up for myself). 😁 But minimal impact so far this time.
Here's my screen shots:
The full text of the expression is:
... and thank you for your continued help with this Scott. I just signed up for a "How to Use Flow Expressions" course on Udemy, but I'm not there yet.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.