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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (6,012)