List/Data Table Generate Tool for Power Automate Destop

Columns

Only elements that cannot be determined as numerical values are enclosed in single quotation marks.

Enclose all elements in single quotation marks.

Do not enclose all elements in single quotation marks. Empty elements are filled with zeros. *Non-numeric elements are treated as variables.If a variable does not exist, Power Automate Destop will generate an error.

Specify the target to be enclosed in single quotation marks by column number.

Treatment of the case where the Source data is a single line

List

Data table

First line

Header line.*The List setting in Treatment of the case where the Source data is a single line takes precedence. *Elements of header lines are enclosed in single quotation marks.

Data line.

Source data

Please create the data in Excel and paste it as is. Leave the last line break as it is.

Result

Paste this text into Power Automate Destop.

Home.