Answered

search for email adresses in array

(0) Share

Report

Posted on by mc_chick

I am struggeling with searching valid mailadresses in an array which was created from a csv file. there are a lot of other content in this array and my task is to extract only the email adresses and put them into a separate array.

maybe there is a smarter solution directly for parsing the csv file? the first 5 rows are "description" > then comes the row with caption or titles and then comes the rows with the data ...

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

mc_chick 82 on at

Like (0)

Report

i have created a "clean" array with the content now - so far so good ... now on position 23 from 28 (for every entry/account) is always a mailadress ... i must catch them into a new array ... or maybe i can simply search inside the array for values with syntax "xyz@abc.de" or a valid mail adress ... but how ...

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report

Check out the first option in the article below. You would just need to create the Office Script then use that to extract all valid email addresses from your content.

How to use Regex in Power Automate (tachytelic.net)

Was this reply helpful? Yes No
mc_chick 82 on at

Like (0)

Report

unfortunatly it is not possible to use Encodian Connector - and also not possible to use an Office Script ... any other ideas? maybe i should start with csv and convert to xls or list ... i will have a try

Was this reply helpful? Yes No
Verified answer

mc_chick 82 on at

Like (0)

Report

i found a proper solution for my initial problem now (i need mailadresses which are in my array and also in an array based on a sharepoint-list (who has entered something) ... now i use "intersection" to compare the arrays - and for this i can use my array also with all the other stuff inside - it compares and matches only the values with mailadresses ... so this is solved for me 🙂

1 people found this reply helpful.

Was this reply helpful? Yes No