Skip to main content
Power Automate
    • Connectors
    • Templates
    • Digital process automation
    • Robotic process automation
    • Business process automation
    • Process advisor
    • AI Builder
  • Pricing
  • Partners
    • Blog
    • Documentation
    • Roadmap
    • Self-paced learning
    • Webinar
    • Business process and workflow automation topics
    • Overview
    • Issues
    • Give feedback
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • User groups
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Microsoft Power Automate Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power Automate
    • General Power Automate Discussion
    • Using Connectors
    • Building Flows
    • Using Flows
    • Power Automate Desktop
    • Process Advisor
    • AI Builder
    • Power Automate Mobile App
    • Translation Quality Feedback
    • Connector Development
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Galleries
    • Community Connections & How-To Videos
    • Webinars and Video Gallery
    • Power Automate Cookbook
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Community Engagement
    • Community AMA
    • Community Blog
    • Power Automate Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power Automate Community
    • Galleries
    • Power Automate Cookbook
    • HTML Table to CSV or Pipe delimited text file

    HTML Table to CSV or Pipe delimited text file

    12-09-2020 02:24 AM

    nmk
    Resolver I
    2734 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    nmk
    nmk Resolver I
    Resolver I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    HTML Table to CSV or Pipe delimited text file

    ‎12-09-2020 02:24 AM

    This Power Automate Flow shows how to convert HTML tables into a machine-friendly format such as pipe-delimited file or csv. The delimiter character can easily be changed. I have presented the concept in a simple manual trigger on a hard-coded Html content (which itself doesn't contain standard HTML - just to show how bad it can get). This flow can be extended further to get the Html file content from SharePoint, OneDrive or Email content. The idea was to keep things simple so everyone can understand.

    The trick is to only use '
    Html to text' action to remove all the Html in order to avoid heavy parsing of the string.

     

    The output file content can be viewed in a table by going to CSV Viewer (if you want to validate it).

     

     

     

     

     

     

     

    HTMLTabletoCSVfile_20201209102209.zip
    29 KB
    Labels:
    • Labels:
    • Automated flows
    • Button flows
    Message 1 of 2
    2,734 Views
    0 Kudos
    Reply
    • All posts
    • Previous Topic
    • Next Topic
    colmdonnelly
    colmdonnelly
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎10-22-2021 02:01 AM

    Hi! Looking to use a process like this within an automated email processing flow. I'd like to have a look and deconstruct it, but when importing the flow, it's requiring a content conversion connector:

     

    colmdonnelly_0-1634893073684.png

    Can I ask what you're using for this, or if there's a custom connector needed? In typically Microsoft fashion, the information on the import page is about as useful as a chocolate fireguard.

     

    Cheers

     

    Message 2 of 2
    1,489 Views
    0 Kudos
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Automate
    • Power Virtual Agents

    • Sign up free
    • Sign in

    Browse

    • Templates
    • Connectors
    • Partners

    Downloads

    • Mobile
    • Gateway

    Learn

    • Documentation
    • Learn
    • Support
    • Community
    • Give feedback
    • Blog
    • Pricing

    • © 2022 Microsoft
    • Contact us
    • Trademarks
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Terms & conditions