Power Platform Community Forum Thread Details

My table data was retrieving from Webpage, it would increase up to 5000~10000+ rows.

Is data table in PAD has limitation in size/column number/row number?

Can data table column contains special characters(e.g. "@#$%^&<>?" )?

Categories:

Hi,jlkuiu7

The Data Table feature in Power Automate Desktop has some limitations on the number of rows and columns that can be used. The maximum number of rows that can be added to a Data Table is not specified in the official documentation However, the maximum number of columns allowed in a dataset, across all tables in the dataset, is 16,000 columns.

Yes, special characters can be included in a Data Table in Power Automate Desktop However, it is important to note that the Data Table can only store data of simple data types such as texts and numbers Therefore, if you are working with special characters, it is recommended to use a text data type for the column that will contain the special characters.