Form doesn't update a grid build on a data table from Read Range activity

Help Forms
,
23

@AndyMenon

We looked into it a bit more. Basically, the culprit here is the Read Range activity, which loads the DataTable with columns of type Object, which in turn is not supported.

Therefore, the solution here is to process the loaded data table variable to another one that has primitive column types.

This way you will be able to dynamically load as many columns as you want.

EDIT
Another potential workaround I found is to convert the source file to a CSV file. When I loaded a sample file using the Read CSV activity, it worked properly.

2 Likes