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.
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
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.
Can you mark my reply as the solution for future users please? Currently yours is
Glad it worked for you
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.