Microsoft Power Automate

Convert Json To Excel

Convert Json To Excel.

Parameters

File ContentByte, Required

The content of the input file

File NameString, Required

Name of the file

First RowInteger

Row position from where it should start

First Column

Column position from where it should start

Worksheet NameString

Name of the new worksheet in excel. If empty, it will be set as Sheet1

Convert Number and DataBoolean

Whether to convert number and date automatically

Date FormatString

Format for date and time string. check for formats here -

https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings

Number FormatString

Format for numbers. check for formats here -

https://learn.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings

Ignore Null ValuesBoolean

Ignore Null Values in json property values

Set title to boldBoolean

Set title to bold

Wraps Title Text

Wraps title for longer text

Output

Output file content from the PDF4me Connect

File ContentBinary