Datatable Filter

Filters a PAD datatable by column value. Outputs a new filtered datatable without modifying the source.

Sign in or create a free account to copy this script.

Problem this solves

No native datatable filter in PAD; users loop through every row manually.

Usage Notes

  1. 1.Set varFilterColumn to the exact column header name.
  2. 2.Set varFilterValue to the value to match.
  3. 3.The output is varFilteredData - the original is never modified.
  4. 4.For numeric comparisons, use the PowerShell fallback.
  5. 5.Chain multiple filter calls for AND conditions.

Requirements

  • Power Automate Desktop 2.30+
  • Variables: varSourceData (DataTable), varFilterColumn (Text), varFilterValue (Text), varFilteredData (DataTable)