Filter data table - column type is unsupported

Feedback Studio Web
,
1

I have a very basic project:

  1. A “Read Range (O365) activity” and set it up so that the excel file is a variable.
  2. A “Filter Data Table” activity on the above range and configure it as follows:

Column name: Column1
Condition: is empty

So now, your automation should look like this:

image
image1228×1156 69.9 KB

Issues:

  1. When I click Configure Filter again, the column name is lost
  2. It throws a design-time error that “column type is unsupported”

Note: This used to work just fine a few months back

1 Like
2

Hello Bogdan

Can you share an image of the filter applied and also any additional properties.

Regards,
Soren

4

Hi @bogdan1

I was able to make it work like this:

It looks like the Office 365 Read Range activity uses a custom DataTable type with extra meta data, and simply providing the column name as text is not enough.

Instead, one must use the meta data of the DT variable produced by this activity and point the Filter Data Table activity to the correct column within this meta data. And then it works :slight_smile:

EDIT
Actually, this is clearly a bug. It works with just the column name if you use the expression editor to insert it, rather than typing it directly:

We will fix it.

6

Thanks! Writing the column name in the advanced editor worked fine.

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.