Data handling
2020 Converthtmltabletojson

HTML Table to JSON

💡
This page describes the actual version (published on 13th of July 2023) of our Converter. If your Flow / App was created before this date it is likely that you are using a depracated version. Click here to check out if you are using an older version.

Description

This action converts your CSV into a JSON.

The delimiters of the CSV input are recognized automatically. Possible delimiters:

  • Comma ,
  • Tab
  • Space
  • Semicolon ;
  • Pipe |

Input Arguments

Input ArgumentTypeDescriptionRequired?Advanced Option?Default
CSVString in JSON formatThe JSON code or a file containing JSON✔️✔️-
Data Includes Header?BooleanYes: All data will be shown in one table in one spreadsheet. No: Different spreadsheets. are created based on the content of the JSON input.❌✔️Yes

Response

ResponseTypeDescription
File responseObjectThe XLSX File response from the JSON
File response as stringStringThe XLSX File response from the JSON formatted as a String
The XLSX File contains tables with formatting options - no matter if you have chosen All in one table or not.

Power Automate Examples

Basic CSV with Comma delimiter

We use a simple CSV with four pets.

Simple CSV with semicolon delimiter
Pet; Identifier;First name;Last name
Dog;1000;Eats;A Lot
Cat;1001;Likes;To Scratch
Cat;1002;Furry;Kitty
Duck;1003;Dagobert;Swimmy

We have not changed the advanced options.

Picture To save it in SharePoint you need to choose JSON response as the File Content setting.

Basic CSV with Pipe | delimiter

We once again use a simple JSON with four pets.

Simple CSV with Pipe delimiter
Pet| Identifier|First name|Last name
Dog|1000|Eats|A Lot
Cat|1001|Likes|To Scratch
Cat|1002|Furry|Kitty
Duck|1003|Dagobert|Swimmy

Just to show the possibilities this time we directly enter the CSV into our action. We have not changed the advanced options.

Picture To save it in SharePoint you need to choose JSON response as the File Content setting.

CSV without headers

We once again use our simple JSON with four pets - this time with the comma delimiter.

Simple CSV with comma delimiter without headers
Dog,1000,Eats,A Lot
Cat,1001,Likes,To Scratch
Cat,1002,Furry,Kitty
Duck,1003,Dagobert,Swimmy

This time we enter the CSV once again directly into our action. We have changed the Data includes Header to No.

Picture To save it in SharePoint you need to choose JSON response as the File Content setting.

Power Apps Examples

Known Limtitations

⚠️
If you experienced other limitations please get in touch with us!

Arrays

Arrays in a JSON are not transfered to an own table in the Excel File even if All in one Table is set to No.

2010 RegularexpressionImages & (Bar)codes