cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

How can email content into an excel spreadsheet

Hi all,

I'm trying to pass a email content into an excel spreadsheet. This content a table with data.
I'd need to catch the table content and insert into a excel file placed in my Sharepoint.
How can I do this? I have seen solutions running the oposite process (get info from sharepoint and sent to a table) but, for me, it is not valid.
Thanks in advance.
Best regards.

 

4 REPLIES 4
Highlighted
Dual Super User III
Dual Super User III

Hi!

Can you share an example of your email body and the content you need to extract? Either AI Builder or WDL functions should to the work, I guess

Thanx!

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted

Hi again,

Thank you @efialttes for your quickest reply. The structure of the table is the following. The number of the rows varies depending of certain events.  I have tried to convert html to text but I don't know how to continue...

 

IDNAMESTART DATEEND DATESTATUS
1NAME101/01/202031/01/2020Completed
2NAME201/01/202031/01/2020Pending

 

I could use the flow to find, between the body content certain parts but not recursive files...

Thanks!

Highlighted
Dual Super User III
Dual Super User III

Hi

Unless 'AI builder' can do its magic here, I am afraid there is no option but to identify <table> HTML tags and extract HTML table from email body. This last process is a pain in the ass, also no success guarantee.

Did you already discarded 'AI builder'? If so, I would suggest to share the email body in HTML format. Working with Outlook, right?

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted

Hi!

I'm going to prove with AI. If I get the solution I'll post it!

Thank you for your support.

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (8,997)