Flow to identify patterns in email address

Like (0) Share

Report

Posted on 23 Apr 2021 11:39:46 by Radoslavov

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

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

I have the same question (0)

All responses (3)

Answers (1)

NorthernChuck 152 on 01 May 2021 at 11:44:39

Like (0)

Report

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,

Was this reply helpful? Yes No
Verified answer

Paulie78 8,416 Moderator on 23 Apr 2021 at 15:21:35

Like (2)

Report

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.

Was this reply helpful? Yes No
NorthernChuck 152 on 23 Apr 2021 at 12:16:50

Like (0)

Report

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.

Was this reply helpful? Yes No