Filter the column which has Values?

Hi Everyone,

I am working on Filter Data Table activity to get the records of the Column which has Values from Formulas.

The formula Returns TRUE or FALSE in that column and I need only TRUE records.

I have used “Contains” and “=” but No Luck. The DT is empty always.

Can any one advice the best solution please.

Regards
Vishnu

Hi Vishnu

If you are working with Boolean values, just add in TRUE without quotation marks.

Use the filter wizard, pick Keep then enter column name and pick the operation as = Enter true as the value and you’ll be all set

1 Like

Thank you so much for a very quick reply Andy.
You are absolutely correct. Now I have removed the double quotes and Its working exactly as expected.

Regards
Vishnu

Can you mark my reply as the solution for future users please? Currently yours is :slight_smile:

Glad it worked for you

Thanks to you.

Done Andy :slight_smile:

Regards
Vishnu

1 Like

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