Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Flow to identify patterns in email address

(0) ShareShare
ReportReport
Posted on by 817

Hi All,

 

I have the following idea and i'm not sure how to start it.

In our company we allow people to dowlonad a tria for our product after registering on the site, however i found (manually by accident) that there are a lot of abusive reocrds created, almost same name (with changed alphabet and/or number) and same domaina:

 

for example

 

someone1@test.com

someone2@test.com

someone3@test.com

someone4@test.com

someone1a@test.com

someone1b@test.com

 

and etc.

 

I want to build a flow to be able to idenfity such paterns or at least to get the total number of records having the same domain name (not that particular one, but in general.

 

For example Select all Accounts where part the Email address is the same, i know said that way sounds idiotic 😄 but i hope you got my point what i'm trying to achive. Having that list will allows us to block this domain to register, and i know that there will be many more to come, so this will be a cat-mouse ongoing game.

 

Any suggestions are welcomed

 

Thanks and regards

Kiril

 

  • NorthernChuck Profile Picture
    152 on at
    Re: Flow to identify patterns in email address

    Agreed -> but now we are into a design thread with a data validation topic 🙂 Thanks for sharing the link btw.

    Cheers, 

  • Verified answer
    Paulie78 Profile Picture
    8,416 Super User 2025 Season 1 on at
    Re: Flow to identify patterns in email address

    Regex isn't supported in Power Automate - but I did write up a way of performing regex on my blog:

    How to use Regular Expressions in Power Automate 

    A regular expression would help you validate a valid email pattern, but I don't think it would help much in this case (because they are valid email patterns). You could certainly use a regex to capture every email from a particular domain (such as test.com). But really it would be better to use something on the website to stop the fictional entries in the first place.

  • NorthernChuck Profile Picture
    152 on at
    Re: Flow to identify patterns in email address

    Regular Expressions (regex) is best suited for these types of matches and I'm not sure if PowerAutomate supports that kinds of search/replace. 
    It is not impossible to accomplish in Power Automate though, you'll just have to go about it a little differently. Your first step is connecting to your data. Get that done first!
    Once you are connected to your data, then you need to put it somewhere for parsing. Once it is in that "somewhere", then you can begin parsing. Just start simple like group all the domains together and count the rows. If greater than 'x' send email alert. Build up from there. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1