Hi @faheemsd55
Another approach using Linq query to filter out empty rows 🙂
See below
Assume i have a datatable like below
Now use Run .Net script action to run .net script which runs linq query
1. Select language as vb.net
2. in reference, select the folder which has required dll packages
Refer this article to get an idea on how to specify references: https://www.linkedin.com/pulse/how-run-net-script-action-empowers-data-table-power-automate-bysani/
3. in parameters section, try this as shown below
4. In script section , write below script:
dt2= dt1.AsEnumerable().Where(Function(row) Not String.Join("",row.ItemArray()).Equals("")).CopyToDataTable()
Output result would be :
Hope it helps !
