cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Eranm
Level: Powered On

Email table to CSV

Hi,

 

I'm trying to build a flow that will convert email table to CSV file.

I have a filter when new email arrive, it's an HTML email, the next step is extracting the table from the email body.

up to here everything is working ok.

The next step i want to add is to convert the extracted HTML to csv file.

How can i accomplish that?

 

Eran

4 REPLIES 4
trand86
Level: Powered On

Re: Email table to CSV

Hey there, how are you extracting the table from the email?

Eranm
Level: Powered On

Re: Email table to CSV

Hi,

 

Using substring and indexOf.

 

trand86
Level: Powered On

Re: Email table to CSV

Tried to do something similar myself with html to text conversion, but the original emails I want to be able to collect data from have some extremely basic html in them, so the text doesn't get converted properly.

 

Could you achieve your query by taking the values you get from your email and initializing them as variables? Then with the create CSV table action, create your custom headers but then choose your variables as the values for them... so that they'll always follow your code?

Eranm
Level: Powered On

Re: Email table to CSV

The values form my email is the email body, which is HTML, after i extract exactly the table code its still HTML,

which is string.

Can you add an example of what you meant?

 

 

 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 52 members 4,655 guests
Please welcome our newest community members: