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,
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
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?
Tomac
986
Moderator
stampcoin
699
Super User 2025 Season 2
Riyaz_riz11
577
Super User 2025 Season 2