top of page
Wavy Abstract Background

Converter by Power 2 Apps

powerapps_red@2x.png
powerautomate_Red@2x.png
powerapps_red@2x.png
powerautomate_Red@2x.png
POWER  AUTOMATE & LOGIC APPS  (& POWER APPS)

Easily convert your data from one format to another with Power2Apps Converter for Power Automate / Logic Apps. These conversions are included:

  1. Convert JSON to CSV

  2. Convert CSV to JSON

  3. Convert CSV to Excel (XLSX)

  4. Convert file (DOCX, PPTX, XLSX, HTML, ...) to PDF

  5. Convert JSON to XML

  6. Convert XML to JSON

  7. Convert JSON to Excel

  8. Create Word (DOCX) file 

  9. Regular expression

  10. Extract Word (DOCX) bookmarks to a list

  11. Convert SharePoint search results to a list

  • Are there funding programs for digitization?
    In Germany there are different programs. Let us talk about the situation in your country.
1
Convert JSON to CSV
2
Convert CSV to JSON
3
Convert CSV to Excel (XLSX)
4
Convert File (DOCX, PPTX, XLSX, HTML, ...) to PDF
5
Convert JSON to XML
6
Convert XML to JSON
7
Convert JSON to Excel
8
Create Word (DOCX) file
9
Regular Expression
10
Extract bookmarks (Word) to a list
11
Convert SharePoint search results to a list
JSON to CSV

Dissociated Landscapes

Jun - Sep 2023

VR Headsets

Smart Home Devices 

Smart Helmets

Smartwatches

JSON to CSV

File format conversion

JSON to CSV

The 'JSON ​ to CSV' action converts a JSON file / JSON data to CSV format with comma (,) separator.

Brief overview of the parameters

  • Input 

    • JSON

      • Either directly the JSON code or a file containing JSON code

      • Example with direct JSON code:
        [{color: "red", value: "#f00" }, { color: "blue", value: "#00f" }, { color: "green", value: "#0f0" }, { color: " yellow", value: "#ff0"}] 

  • Output​​

    • CSV

      • CSV file with comma delimiter (',')​

      • Output for the above CSV input:
         

CSV to JSON
CSV to JSON

File format conversion

CSV to JSON

The 'CSV ​ to JSON' action converts a CSV file/CSV data to JSON format. The delimiters of the CSV are recognized automatically.

Brief overview of the parameters

  • Input 

    • CSV

      • Either the CSV code directly or a file containing the CSV code

      • Example with direct CSV code:
        colour,value
        red,#f00
        blue,#00f
        green,#0f0
        yellow,#ff0

Converter_CSVzuJSON_Input.JPG
  • Output​​

    • JSON

      • JSON format

      • Output for the above CSV input:
         

Converter_CSVzuJSON_Output.JPG
CSV to xlsx (Excel)
CSV to Excel (csv)

File format conversion

CSV to Excel (xlsx)

The 'CSV ​ to Excel' action converts a CSV file / CSV data to the most common Excel format xlsx. The delimiters of the CSV are recognized automatically.

Brief overview of the parameters

  • Input 

    • CSV

      • Either the CSV code directly or a file containing the CSV code

      • Example with direct CSV code:
        colour,value
        red,#f00
        blue,#00f
        green,#0f0
        yellow,#ff0

Converter_CSVzuExcel_Input.JPG
  • Output​​

    • Object

      • Excel file as an object

      • Output for the above CSV input:
         

Converter_CSVzuExcel_Output.JPG
    • The Output can then be further processed in Power Automate

File to PDF
Convert File (DOCX, PPTX, XLSX, HTML, ...) to PDF

File format conversion

Convert file to PDF

The 'Convert File (DOCX, PPTX, XLSX, HTML, ...) to PDF'-Actionconverts a file in DOCX, HTML, PPTX or XLSX format to a PDF file.

fileToPDF1.png

Brief overview of the parameters

  • Input 

  • The promotion can be used in 2 ways:

    1. Automatic recognition of the file format (File Extension)

    2. with input of the file format (the "File extension")

fileToPDF2.png
  1. Automatic recognition of the file format (File Extension)

    • File extension:File extension: With the option 'Extract from File name' the file extension is extracted from the file name.

    • File name: The file name must be entered to extract the file extension

    • Files:The file content of the file to be converted must be entered. The content of the file must match the extracted file extension from the 'File name' .

fileToPDF3.png
  • Output​​

    • PDF

      • PDF file based on the entered file​​

Further processing of the output

  • The output can then be further processed in Power Automate​ (an example  follows)

fileToPDF4.png
Convert JSON to XML

File format conversion

Convert JSON file / JSON data to XML

The 'Convert JSON to XML' action converts a JSON file / JSON data to XML format 

Brief overview of the parameters

Input

  • JSON

    •  

      Either directly the JSON code or a file containing the JSON code​

    • Example with direct JSON code:
      [{color: "red", value: "#f00" }, { color: "blue", value: "#00f" }, { color: "green", value: "#0f0" }, { color: " yellow", value: "#ff0"}]

jsonToXml1.png

Output​​

  • XML

    • XML file

    • Output for the above JSON input:
      <xml><item><color>red</color><value>#f00</value></item><item><color>blue</color><value>#00f</value></item ><item><color>green</color><value>#0f0</value></item><item><color>yellow</color><value>#ff0</value></item>< /xml>

jsonToXml2.png

Further processing of the output

  • The output can then be further processed in Power Automate​ 

  • Example with simple saving of the XML file

jsonToXml3.png
JSON to XML
Convert XML to JSON

File format conversion

Convert XML file / XML data to JSON

The 'Convert JSON to XML' action converts a JSON file / JSON data to XML format 

Brief overview of the parameters

input

  • XML

    •  

      Either directly the XML code or a file containing XML code​

    • Example with direct JSON code:
      <xml><item><color>red</color><value>#f00</value></item><item><color>blue</color><value>#00f</value></item ><item><color>green</color><value>#0f0</value></item><item><color>yellow</color><value>#ff0</value></item>< /xml>

xmlToJson1.png

Output​​

  • JSON

    • JSON file

    • Output for the above XML input:
      [{"color": "red","value": "#f00"},{"color": "blue","value": "#00f"},{   "color": "green","value": "#0f0"},  { "color": "yellow","value": " #ff0"}]

xmlToJson2.png

Further processing of the output

  • The output can then be processed in Power Automate​

  • Example of going through the JSON file per item (color).

xmlToJson3.png
XML to JSON
Convert JSON data to Excel file

File format conversion

Convert JSON data to Excel file

The 'Convert JSON to Excel' action converts a JSON file / JSON data into an Excel file. The data will be saved either in a single or multiple tables depending on the settings.

Brief overview of the parameters

Input

  • All in one table

    • "Yes": The data will be displayed in one table.

    • "No": Depending on the structure of the JSON object the data will be divided into different tables.  Each of these will be stored in individual sheets.

  • JSON data:

    • Either directly the JSON code 
      Example with direct JSON code:
      [{color: "red", value: "#f00" }, {color: "blue", value: "#00f" }, {color: "green", value: "#0f0" }, {color: "yellow", value: "#ff0"}]

Converter action JSON to Excel
  • or enter the file content of a JSON file (from Sharepoint action "Get file content").
JSON2Excel_Action_2.PNG

Output​​

  • File content in a standard tabular format

JSON2Excel_Action_3.PNG

Further processing of the output

  • The output can subsequently be used as the content of a new file for the Sharepoint action "Create File".

  • Note that the correct file type (.xlsx) must be specified along with the file name for the sharepoint action.

JSON2Excel_Action_4.PNG
JSON to Excel
Extract docx bookmarks
Extract Word (docx) bookmarks

Metadata extraction from a Word file

Extract Bookmarks  from a Word file (docx)

The 'Extract Word (docx) bookmarks ' action extracts the bookmarks from a Word document and outputs them as a list.

To do this, we consider a Word document with bookmarks (accessible in Word under "Insert -> Bookmarks").

WordWithBookmarks.JPG

Brief overview of the parameters

  • Input 

    • docx

      • An action such as "Retrieve file content" or "Retrieve file content via path" is suitable for calling the Word file.

      • Example of Word file above: ​ ​

Input_bookmark_converter.png
  • output
    • Liste​
      • One entry with "key" and "value" per bookmark​
Converter_GetWordBookmarks1.JPG
Individual Converter
Connecting Dots
Connecting Dots

You have a wish for another converter?

If you need a file conversion that is not currently integrated, please contact us.

We would be happy to talk to you about the extent to which we can include this in our converter or how we can provide this for you.

bottom of page