Converter by Power2Apps

Enables conversion of different data formats from one to another.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
     -   US Department of Defense (DoD)
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Contact
Name Power2Apps Support
URL https://www.power2apps.de/kontakt
Email kontakt@power2apps.de
Connector Metadata
Publisher Power2Apps P2A GmbH
Website https://www.power2apps.de
Privacy policy https://www.power2apps.de/datenschutz
Categories Content and Files;Data

Converter by Power2Apps for Power Automate convert your data easily from one format to another with Microsoft Power Automate or Azure Logic Apps solutions and with our data conversion services CSV to JSON, JSON to CSV, ...

Prerequisites

You will need a only key to use this connector and build workflows with it.

How to get credentials?

Creating a connection

The connector supports the following authentication types:

Default Parameters for creating connection. All regions Shareable

Default

Applicable: All regions

Parameters for creating connection.

This is shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs

Name Type Description Required
API Key securestring Get your API Key on https://power2apps.de/apikey True

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Add Image to Word File

Add Image to a Word file (DOCX) or create a new Word file (DOCX) with image

Add Image to Word File within Table

Add an image to a Word file (DOCX) within a table or create a new Word file (DOCX) with an image within a table

Add Image to Word File within Table [DEPRECATED]

Add an image to a Word file (DOCX) within a table or create a new Word file (DOCX) with an image within a table

Add Table to Word File

Add Table to a Word file (DOCX) or create a new Word file (DOCX) with a table

Add Text to Word File

Add a text to a Word file (DOCX) or create a new Word file (DOCX) with a text

Compress JPG Image

Compress a JPG (JPEG) image

Convert CSV data to Excel file [DEPRECATED]

Convert CSV data to Excel file

Convert CSV data to JSON [DEPRECATED]

Convert CSV data to JSON

Convert CSV to Excel File

Convert a CSV to a Excel file (XLSX)

Convert CSV to JSON

Convert a CSV to a JSON

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

Convert a document file (Word, Powerpoint, Excel, ..) to a PDF file

Convert file (DOCX, PPTX, XLSX, HTML, ...) to PDF [DEPRECATED]

Convert a document (Word, Powerpoint, Excel, ..) to a PDF file

Convert HTML or URL to JPG Image

Convert an HTML to an JPG (JPEG) Image or convert an URL containing HTML to an JPG (JPEG) Image

Convert HTML or URL to PDF

Convert an HTML to a PDF or convert an URL containing HTML to a PDF

Convert HTML Table to JSON

Convert an HTML table to a JSON or extract the first HTML table from an URL and convert it to a JSON

Convert HTML Table to JSON [DEPRECATED]

Convert an HTML table to a JSON or extract the first HTML table from an URL and convert it to a JSON

Convert Image to another Image Format

Convert an image to another format (JPEG, JPG, PNG, BMP, GIF, TIFF)

Convert JSON to CSV

Convert a JSON to a CSV

Convert JSON to CSV [DEPRECATED]

Convert a JSON to a CSV

Convert JSON to CSV [DEPRECATED]

Convert JSON to CSV

Convert JSON to Excel File

Convert a JSON to an Excel file (XLSX)

Convert JSON to Excel file [DEPRECATED]

Convert JSON to Excel file

Convert JSON to XML

Convert a JSON to an XML

Convert JSON to XML [DEPRECATED]

Convert JSON to XML

Convert JSON to YAML

Convert a JSON to a YAML

Convert XML to JSON

Convert an XML to a JSON

Convert XML to JSON [DEPRECATED]

Convert XML to JSON

Convert YAML to JSON

Convert a YAML to a JSON

Create QR or Barcode

Create a QR code or a Barcode from a string

Create Word File

Create a Word file (DOCX) with multiple text sections or add multiple text sections to a Word file (DOCX)

Extract Bookmarks from Word File

Extract all bookmarks from a Word fie (DOCX) and get them as a list

Extract Information from IBAN

Get the bank account details like account number, bank name, bank address and SWIFT code from International Bank Account Number (IBAN)

Extract Information from Image

Get the metadata information from an image (JPEG, JPG, PNG, BMP, GIF, TIFF, ...)

Extract Information from PDF

Get the metadata of a PDF

Extract results from Send HTTP request to SharePoint search

Extract results from the action 'Send HTTP request to SharePoint' search

Get File from URL

Get a file (PDF, JPG, JPEG, PNG, CSV, ...) from an URL

Insert Image to Word File

Insert Image to a Word file (DOCX)

Insert Table to Word File

Insert Table to a Word file (DOCX)

Insert Text to Word File

Insert a text to a Word file (DOCX)

Merge PDF Files

Merge two PDF files into one PDF file

Protect PDF

Protect a PDF with a password

Read QR or Barcode

Read a QR code or Barcode from an image

Regular Expression (RegEx)

Searches the specified input string for all occurrences of a specified .NET regular expression (RegEx), using the specified matching options.

Resize Image

Adjust the width and height of an image (JPEG, JPG, PNG, BMP, GIF, TIFF)

Rotate Image

Rotate an image (JPEG, JPG, PNG, BMP, GIF, TIFF) by an angle (degree) of your choice

Translate Text

Translate a word or sentence

Unprotect PDF

Remove the protection from a pdf

Add Image to Word File

Add Image to a Word file (DOCX) or create a new Word file (DOCX) with image

Parameters

Name Key Required Type Description
Existing file content
existingFileContent byte

Existing Word file to update. By default a blank Word file is used.

Image
image True byte

Image to add

Caption Text
imageText string

Text displayed next to image

Returns

Add Image to Word File within Table

Add an image to a Word file (DOCX) within a table or create a new Word file (DOCX) with an image within a table

Parameters

Name Key Required Type Description
Existing file content
existingFileContent byte

Existing Word file to update. By default a blank Word file is used.

Image
image True byte

Image to add

Description Text
imageText string

Text displayed next to image

Returns

Add Image to Word File within Table [DEPRECATED]

Add an image to a Word file (DOCX) within a table or create a new Word file (DOCX) with an image within a table

Parameters

Name Key Required Type Description
Existing file content
existingFileContent byte

Existing Word file to update. By default a blank Word file is used.

Image
image True byte

Image to add

Caption Text
imageText string

Text displayed next to image

Returns

Add Table to Word File

Add Table to a Word file (DOCX) or create a new Word file (DOCX) with a table

Parameters

Name Key Required Type Description
Existing file content
existingFileContent byte

Existing Word file to update. By default a blank Word file is used.

Table
table string

Table as json

Tabletext
tableText string

Text displayed next to table

Returns

Add Text to Word File

Add a text to a Word file (DOCX) or create a new Word file (DOCX) with a text

Parameters

Name Key Required Type Description
Existing file content
existingFileContent byte

Existing Word file to update. By default a blank Word file is used.

Type
sectionType string
Text
text string

Text

Returns

Compress JPG Image

Compress a JPG (JPEG) image

Parameters

Name Key Required Type Description
Image Quality
quality integer

The quality of the image (0-100)

File
file True byte

File

Returns

Convert CSV data to Excel file [DEPRECATED]

Convert CSV data to Excel file

Parameters

Name Key Required Type Description
CSV
CSV data True string

CSV data

Returns

Convert CSV data to JSON [DEPRECATED]

Convert CSV data to JSON

Parameters

Name Key Required Type Description
CSV
CSV data True string

CSV data

Returns

response
string

Convert CSV to Excel File

Convert a CSV to a Excel file (XLSX)

Parameters

Name Key Required Type Description
CSV has headers?
dataIncludesHeader boolean

CSV has headers?

Automatic field type detection?
autoDiscoverFieldTypes boolean

Automatic field type detection?

Number of rows for field type detection
maxScanRows integer

Number of rows for automatic field type detection. Default = 20

Remove empty rows
ignoreEmptyLine boolean

Remove empty rows

Skip a number of rows
skip integer

Skip a number of rows at beginning. Default = 0

Stop at a specific row
skipLast integer

Stop at a specific row. Default = convert all rows

Separator
delimiter string

Separator (delimiter) of the fields. Default = 'Automatic detection of separator'

Automatic quote delimiter detection?
mayHaveQuotedFields boolean

Automatic quote delimiter detection?

CSV
csv True string

CSV

Returns

Convert CSV to JSON

Convert a CSV to a JSON

Parameters

Name Key Required Type Description
CSV has headers?
dataIncludesHeader boolean

CSV has headers?

Automatic field type detection?
autoDiscoverFieldTypes boolean

Automatic field type detection?

Number of rows for field type detection
maxScanRows integer

Number of rows for automatic field type detection. Default = 20

Remove empty rows
ignoreEmptyLine boolean

Remove empty rows

Skip a number of rows
skip integer

Skip a number of rows at beginning. Default = 0

Stop at a specific row
skipLast integer

Stop at a specific row. Default = convert all rows

Separator
delimiter string

Separator (delimiter) of the fields. Default = 'Automatic detection of separator'

Automatic quote delimiter detection?
mayHaveQuotedFields boolean

Automatic quote delimiter detection?

CSV
csv True string

CSV

Returns

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

Convert a document file (Word, Powerpoint, Excel, ..) to a PDF file

Parameters

Name Key Required Type Description
Origin File Name
fileName string

Only used with 'Extract from origin file name'. E.g. 'MyFileName.docx'

Origin File Extension
fileExtension string

Origin File extension

File
file True byte

File

Returns

Convert file (DOCX, PPTX, XLSX, HTML, ...) to PDF [DEPRECATED]

Convert a document (Word, Powerpoint, Excel, ..) to a PDF file

Parameters

Name Key Required Type Description
File Name
fileName string

File name

File Extension
fileExtension string

File extension

File
file True byte

File

Returns

Convert HTML or URL to JPG Image

Convert an HTML to an JPG (JPEG) Image or convert an URL containing HTML to an JPG (JPEG) Image

Parameters

Name Key Required Type Description
HTML
html True string

HTML

Returns

Convert HTML or URL to PDF

Convert an HTML to a PDF or convert an URL containing HTML to a PDF

Parameters

Name Key Required Type Description
HTML
html True string

HTML

Returns

Convert HTML Table to JSON

Convert an HTML table to a JSON or extract the first HTML table from an URL and convert it to a JSON

Parameters

Name Key Required Type Description
HTML table
htmlTable True string

HTML table

Returns

Convert HTML Table to JSON [DEPRECATED]

Convert an HTML table to a JSON or extract the first HTML table from an URL and convert it to a JSON

Parameters

Name Key Required Type Description
HTML table
htmlTable True string

HTML table

Returns

Convert Image to another Image Format

Convert an image to another format (JPEG, JPG, PNG, BMP, GIF, TIFF)

Parameters

Name Key Required Type Description
Output format
outFormat string

Output format

File
file True byte

File

Returns

Convert JSON to CSV

Convert a JSON to a CSV

Parameters

Name Key Required Type Description
Separator
delimiter string

Separator (delimiter) of the fields. Default = ';'

JSON
json True string

JSON

Returns

Convert JSON to CSV [DEPRECATED]

Convert a JSON to a CSV

Parameters

Name Key Required Type Description
JSON
json True string

JSON

Returns

Convert JSON to CSV [DEPRECATED]

Convert JSON to CSV

Parameters

Name Key Required Type Description
JSON
JSON True string

JSON

Returns

response
string

Convert JSON to Excel File

Convert a JSON to an Excel file (XLSX)

Parameters

Name Key Required Type Description
All in one table
allInOneTable boolean

All in one table

JSON
json True string

JSON

Returns

Convert JSON to Excel file [DEPRECATED]

Convert JSON to Excel file

Parameters

Name Key Required Type Description
All in one table
AllInOneTable boolean

All in one table

JSON
JSON True string

JSON

Returns

Convert JSON to XML

Convert a JSON to an XML

Parameters

Name Key Required Type Description
JSON
json True string

JSON

Returns

Convert JSON to XML [DEPRECATED]

Convert JSON to XML

Parameters

Name Key Required Type Description
JSON
JSON True string

JSON

Returns

response
string

Convert JSON to YAML

Convert a JSON to a YAML

Parameters

Name Key Required Type Description
JSON
json True string

JSON

Returns

Convert XML to JSON

Convert an XML to a JSON

Parameters

Name Key Required Type Description
XML
xml True string

XML

Returns

Convert XML to JSON [DEPRECATED]

Convert XML to JSON

Parameters

Name Key Required Type Description
XML
XML True string

XML

Returns

response
string

Convert YAML to JSON

Convert a YAML to a JSON

Parameters

Name Key Required Type Description
YAML
yaml True string

YAML

Returns

Create QR or Barcode

Create a QR code or a Barcode from a string

Parameters

Name Key Required Type Description
Content
content True string

The content of the generated code

Width
width integer

The width in px

Height
height integer

The height in px

Code format
codeFormat string

The format of the Qr/Bar Code

Output format
outFormat string

Output format

Returns

Create Word File

Create a Word file (DOCX) with multiple text sections or add multiple text sections to a Word file (DOCX)

Parameters

Name Key Required Type Description
Existing file content
existingFileContent byte

Existing Word file to update. By default a blank Word file is used.

Type
sectionType string
Text
sectionContent string

Text

Returns

Extract Bookmarks from Word File

Extract all bookmarks from a Word fie (DOCX) and get them as a list

Parameters

Name Key Required Type Description
File
file True byte

File

Returns

Extract Information from IBAN

Get the bank account details like account number, bank name, bank address and SWIFT code from International Bank Account Number (IBAN)

Parameters

Name Key Required Type Description
IBAN
account True string

IBAN

Returns

Extract Information from Image

Get the metadata information from an image (JPEG, JPG, PNG, BMP, GIF, TIFF, ...)

Parameters

Name Key Required Type Description
File
file True byte

File

Returns

Extract Information from PDF

Get the metadata of a PDF

Parameters

Name Key Required Type Description
File
file True byte

File

Returns

Extract results from the action 'Send HTTP request to SharePoint' search

Parameters

Name Key Required Type Description
SP search result
sharepointResult True string

SharePoint search result

Returns

Get File from URL

Get a file (PDF, JPG, JPEG, PNG, CSV, ...) from an URL

Parameters

Name Key Required Type Description
URL
url True string

URL

Returns

Insert Image to Word File

Insert Image to a Word file (DOCX)

Parameters

Name Key Required Type Description
Existing file content
existingFileContent True byte

Existing Word file to insert image in

Placeholder name
placeholderName string

Placeholder name

Placeholder image
placeholderImage True byte

Placeholder image

Returns

Insert Table to Word File

Insert Table to a Word file (DOCX)

Parameters

Name Key Required Type Description
Existing file content
existingFileContent True byte

Existing Word file to insert table in

Placeholder name
placeholderName string

Placeholder name

Placeholder table
placeholderTable string

Placeholder table as json

Returns

Insert Text to Word File

Insert a text to a Word file (DOCX)

Parameters

Name Key Required Type Description
Existing file content
existingFileContent True byte

Existing Word file to insert text in

Placeholder name
placeholderName string

Placeholder name

Placeholder text
placeholderText string

Placeholder text

Returns

Merge PDF Files

Merge two PDF files into one PDF file

Parameters

Name Key Required Type Description
File 1
file1 True byte

The first file input

File 2
file2 True byte

The second file input

Returns

Protect PDF

Protect a PDF with a password

Parameters

Name Key Required Type Description
Owner Password
ownerPassword string

Protect the editing of the PDF with the owner password

User Password
userPassword string

Protect the opening of the PDF with the user password

File
file True byte

File

Returns

Read QR or Barcode

Read a QR code or Barcode from an image

Parameters

Name Key Required Type Description
File
file True byte

File

Returns

Regular Expression (RegEx)

Searches the specified input string for all occurrences of a specified .NET regular expression (RegEx), using the specified matching options.

Parameters

Name Key Required Type Description
Text to match
input True string

The string to search for a match

Regular Expression
pattern string

The .NET regular expression pattern to match

Regular expression option
option string

Select regular expression option

Returns

Body
RegExp

Resize Image

Adjust the width and height of an image (JPEG, JPG, PNG, BMP, GIF, TIFF)

Parameters

Name Key Required Type Description
Width
width double

The width of the image - empty for auto

Height
height double

The height of the image - empty for auto

Format
outFormat string

Outputformat

Resize By
resizeBy string

Resize By

File
file True byte

File

Returns

Rotate Image

Rotate an image (JPEG, JPG, PNG, BMP, GIF, TIFF) by an angle (degree) of your choice

Parameters

Name Key Required Type Description
Rotate
rotate float

Degrees the image is rotated with

Output format
outFormat string

Output format

File
file True byte

File

Returns

Translate Text

Translate a word or sentence

Parameters

Name Key Required Type Description
From
from True string

From

To
to True string

To

Translation
translation True string

Translation

Returns

Unprotect PDF

Remove the protection from a pdf

Parameters

Name Key Required Type Description
Owner Password
ownerPassword string

Owner Password

File
file True byte

File

Returns

Definitions

BankingAccountData

Name Path Type Description
Is Valid
isValid boolean

Is Valid

Is Valid SEPA Country
isSepaCountry boolean

Is Valid Single Euro Payment Areas (SEPA) Country

Country Code
countryCode string

Country Code

BBAN
bban string

Basic Bank Account Number (BBAN)

Bank Code
bankCode string

Bank Code

Branch Code
branchCode string

Branch Code

Account Number
accountNumber string

Account Number

Formatted IBAN
formattedIban string

Formatted International Bank Account Number (IBAN)

SWIFT Code
swift_code string

SWIFT Code / BIC

Bank Name
bank_name string

Bank Name

Bank City
bank_city string

Bank City

Bank ZIP
bank_zip string

Bank ZIP

Bank Address
bank_adress string

Bank Address

CodeResponse

Name Path Type Description
Code value
codeValue string

Code value

Code type
codeType string

Code type

CsvResponse

Name Path Type Description
CSV response
csv string

CSV response

FileContentResponse

Name Path Type Description
File response
fileContent

File response

FileResponse

Name Path Type Description
File response
file byte

File response

File response as string
fileContent string

File response as string

MIME type
mimeType string

MIME type

Extension
extension string

Extension

ImageMetaDataResponse

Name Path Type Description
Image format
imageFormat string

Image format

Image size
imageSize double

Image size

Width
width integer

Width

Height
height integer

Height

Orientation
orientation string

Orientation

Bits per Pixel
bits integer

Bits per Pixel

Date of recording
recordingDate string

Date of recording

Horizontal Resolution
horizontalResolution float

Horizontal Resolution

Vertical Resolution
verticalResolution float

Vertical Resolution

Has EXIF Data
hasEXIFData boolean

Has EXIF Data

EXIF Data
exifData string

EXIF Data

Has XMP Data
hasXMPData boolean

Has XMP Data

JsonResponse

Name Path Type Description
JSON response
json string

JSON response

JsonTableResponse

Name Path Type Description
JSON table response
firstTable string

JSON table response

tables
tables array of string

KeyValPair

Name Path Type Description
Key
key string

Key

Value
value string

Value

Pdf_Metadata

Name Path Type Description
Author
author string

Author

CreationDate
creationDate integer

CreationDate

Creator
creator string

Creator

ModificationDate
modificationDate integer

ModificationDate

Producer
producer string

Producer

Subject
subject string

Subject

Title
title string

Title

FileSize
fileSize integer

FileSize

PDFVersion
pdfVersion integer

PDFVersion

PageCount
pageCount integer

PageCount

Keywords
keywords string

Keywords

RegExp

Name Path Type Description
Text to match
input string

The string to search for a match

Regular Expression
pattern string

The .NET regular expression pattern to match

Regular expression option
option string

Select regular expression option

Is match?
isMatch boolean
matches
matches array of
First match
firstMatch
First match value
firstMatchValue string

SharePointSearchResultResponse

Name Path Type Description
Title
title string

Title

Link
link string

Link

TranslationResponse

Name Path Type Description
First translation response
firstTranslation string

First translation response

Translations response
translations array of string

Translations response

XmlResponse

Name Path Type Description
XML response
xml string

XML response

YamlResponse

Name Path Type Description
Yaml response
yaml string

Yaml response

string

This is the basic data type 'string'.