Skip to main content
Community site session details

Community site session details

Session Id : Gckk42BCDCnS3BGlxNvEZk
Power Automate - Building Flows
Unanswered

Extract domain names from email body

Like (0) ShareShare
ReportReport
Posted on 7 Dec 2022 09:13:25 by 2

Hi all!

 

today I'm working on a project where I get a piece of text from an email body and save it in a SharePoint list, but the piece of text varies every email from 1 to infinite, the pieces of text contain website domains or ip addresses.

 

 

in the attachments is a example of the email we are receiving and the flow im using, in this example we have 9 bulletpoints that contain domainnames, (These vary every email from 1 to infinite) in the flow im using right now im using an array to define the domainname rows, for example: site 1 = 49, site 2 = 51, site 3 = 53. The flow above works, but only if the email contains 9 bulletpoints, but I'm trying to find a easier way where power Automate automatically chooses/picks the domain names/ips, and used these in the rest of the flow.

 

What I'm trying to accomplish here is that power automate automatically sees how many dots there are and use these to make the array and post it to SharePoint (with the domain name behind the text aswell).

 

I have been searching on forums for a long time and couldn't find anything.

If any extra info is needed please tell me!

Thanks in advance,

  • CU29070722-0 Profile Picture
    2 on 07 Dec 2022 at 12:15:30
    Re: Extract domain names from email body

    Hi!

    i tried something else and i forgot what i put into the Split Body Text, but now im trying something else, in the attachments is the flow I'm using now, and the email we are receiving

     

  • PowerAppsWizard Profile Picture
    388 on 07 Dec 2022 at 12:05:39
    Re: Extract domain names from email body

    Hi

    Could you share an example email body, so I can try to play with it?

    Could you post the code of those blocks as well?

     

    PowerAppsWizard_0-1670414666901.png

     

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

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!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete