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.
Provided as-is, without warranty of any kind. Review and test each pattern in a non-production environment before deploying it to live automations. See our Terms.
Problem this solves
No native datatable filter in PAD; users loop through every row manually.
Usage Notes
- 1.Set varFilterColumn to the exact column header name.
- 2.Set varFilterValue to the value to match.
- 3.The output is varFilteredData - the original is never modified.
- 4.For numeric comparisons, use the PowerShell fallback.
- 5.Chain multiple filter calls for AND conditions.
Requirements
- Power Automate Desktop 2.30+
- Variables: varSourceData (DataTable), varFilterColumn (Text), varFilterValue (Text), varFilteredData (DataTable)