Power Platform Community Forum Thread Details

How to get certain text from a text block and insert into Excel table

I'm trying to parse an email to an Excel table and I'm having a heck of a time with this.

The email is one of those forms with name, address, phone, etc. Unfortunately this form when emailed isn't in a nice easy format. It's just a big ball of text.

So instead of something nice like:

Name: name

Address: address

Phone: phone

Here is what I have to parse and what I need to pull:

Name John DoeAddress 1234 State Rd
CityName, IN 12345
Map It
[https://us-east-2.protection.sophos.com?d=google.com&u=aHR0cHM6Ly9tYXBzLmdvb2dsZS5jb20vbWFwcz9xPTQyMjMrUGluZXMrUmQrUGFkdWNhaCUyQytLWSs0MjAwMQ==&i=NjIxNjk0MTY0Njg5MTcwZjM1MDQ4NTlj&t=Qzg3QXVnWGVGSkhOMlZvVVUzbVdVYjY4M3c2aFVSemIrbTBialFlbzlYMD0=&h=5bf5d12746274218ac6405001d549d1d&s=AVNPUEhUT0NFTkNSWVBUSVYdezzyoxQHANtG2Vn0DLx0dNf3R4EDjq4IiQdsOGBY9A]Phone 4105559874Email JohnDoe@gmail.comCurrent
Internet Provider ComcastWhen does your contract with your current internet
provider end? July 2025

These all go into an Excel table which is the easy part.

I have the email connector working as well as HTML to text action.

I'm having a real hard time understanding the syntax and how this split function works even after reading about 100 blogs on it. Still isn't clicking for me at all.

Any ideas?

Categories:

Business Process Flows

Quick Links