cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Santhosh_V_26
Helper I
Helper I

Need help extracting data from a table in email and post it sharepoint list

I need to design a flow that will extract data from a Table in a email and save it into a SharePoint list. Attached the sample Table as we are getting via email.  Anyone kindly help on this.tempsnip.png

1 ACCEPTED SOLUTION

Accepted Solutions
Paulie78
Super User
Super User

Hi @Santhosh_V_26 

Check out this video I just finished to see if it helps you:

https://youtu.be/IwRKWaTnl3U

 

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

View solution in original post

15 REPLIES 15
PrasadAthalye
Super User
Super User

You can use HTML to text action to convert it to text format and then parse it using Substring function... See example below...

 

PrasadAthalye_0-1622587687877.png

 

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

Hi Prasad,

 

Below is my scenario, 

Santhosh_V_26_0-1622619074362.png

 We're getting an email for every new high priority ticket. From that I need to extract data from the table present in the email and the need to create a new item in a share point list.

 

Ex: I had already created column in the list for all the values in the first column of the table present in the email like below,

Santhosh_V_26_1-1622619394709.png

So I need help for extracting all data from the table present in the email and put it into the SharePoint list including the current progress data.

 

Looking forward for help on this scenario 🙁

Thanks.

Did you check my response above? Did you try HTML to text approach?

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

Yes, I had tried html to text but afterwards I was unable to split the things as expected ☹️

Can you send me some of the text from HTML to Text output ?

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

2021-05-12 06:49:58

ABC- High Impact Outage notification

Severity (P1/P2)

P1

Account Name

XYZ

Incident Number

INC123456432


Start Time of Incident (in IST)

2021-05-31 06:49:58

Impacted Region/Site

Yet to be determined

Service(s)/App(s) Impacted

                                     Mailhost Server Not Sending Messages from
QST

Assigned Technical Team

Messaging Collaborative Services - XYZ

Issue Description

                                     Mailhost Server Not Sending Messages from
XYZ

No of Users Impacted

Yet to be determined

Business Impact

                                     Mailhost Server Not Sending Messages from
QST

Estimated time to Resolve

Yet to be determined

 

Current Progress

User is not able to send emails from - Sender IP - 12.35.57.23 Sender email
address - abcf@drf.org

Checked Mailhost servers are working fine and issue seems to be happening from
application server end. Would suggest you to raise a Service request to get the
sender IP address (12.35.57.23) whitelisted on Mailhost servers. It appears
some connections from that address as being placed in the suspect list which
throttles the connection.

The mail is coming from a publicIP address - which we don't have these
set up to accept all the messages from.  At some point, that public Amazon IP
was listed as a suspect IP which limits the mail capabilities of the sending IP
through Mailhost. Getting IPO/Security to review the IP address and approve
white listing will avoid that throttling.

Asked user to raise a Service request to get the sender IP address whitelisted
on Mailhost servers and IPO needs to review why a public IP is attempting
to send mail - and if that is approved or not.

Keeping ticket in pending status while we discuss further with ETS to get this
P1 downgraded.

 

 

 

NOTE: Please reply to all so that my team can respond to your request when I am
off shift.

 

Regards,

Santhosh Kumar V

xyz 

ABC Company.

 

M +223983938

xyz@abc.com

 

ABC Technology India Private Limited - 9th Floor, Block-D , avcb
ABC Technology Company -- This message is transmitted to you by or on behalf of
ABC Technology Company or one of its affiliates. It is intended exclusively for
the addressee. The substance of this message, along with any attachments, may
contain proprietary, confidential or privileged information or information that
is otherwise legally exempt from disclosure. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended recipient
of this message, you are not authorized to read, print, retain, copy or
disseminate any part of this message. If you have received this message in
error, please destroy and delete all copies and notify the sender by return
e-mail. Regardless of content, this e-mail shall not operate to bind ABC
Technology Company or any of its affiliates to any order or other contract
unless pursuant to explicit written agreement or government initiative expressly
permitting the use of e-mail for such purpose.

Prasad,

 

The above is the HTML to Text Output in my scenario. I need to extract for each data like Incident number, severity etc... including the current progress. And also i need remove the remove the text after the current progress updates.

 

Thanks for time looking into this 🙂

Paulie78
Super User
Super User

Hi @Santhosh_V_26 

Check out this video I just finished to see if it helps you:

https://youtu.be/IwRKWaTnl3U

 

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

Santhosh_V_26
Helper I
Helper I

Hey Paul,

Thank you so much, Finally I got the Solution and Implemented Successfully 😊

Great news - well done!

@Paulie78 , Hope your are doing well!

 

As i have a similar kind of request with slight modification.

 

Our New scenario is need to capture the data from the table on the email body dynamically based on the no of data's .

Santhosh_V_26_0-1630682219204.png

Santhosh_V_26_1-1630684294915.png

For example, we have the data from excel as you can see in Pic1 and the same data is sent to an email, Pic2.

Then we need to capture the data from the Table and save it into the SharePoint list. But the table of the data will be dynamically changing the no of data's.

 

So Need help in regards to this! Anyone would help me on this requirement.

 

Thank you!

Hi,

 

I have done two videos on how to do this:

 

https://youtu.be/IwRKWaTnl3U

https://youtu.be/qsPdGjgI1oE

 

Both use different approaches, but either should work for you.

 

Paul

Santhosh_V_26
Helper I
Helper I

Hi @Paulie78 ,

 

But in my scenario the number of data’s differ every time dynamically. Any ways to do that?

it really depends if is the number of rows or columns that changes. Rows are easy, columns more difficult. As your target is a SharePoint list with a fixed number of columns then I guess the format of the email does not change, just the number of records, which is perfectly possible to handle.

Yes @Paulie78  you’re absolutely correct. My current scenario is that the rows only change and the column doesn’t change, its always a fixed one.

 

Could you suggest any way to achieve that?

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,182)