Removing them is easy and we have lots of options. Conclusionsīlank rows in our data can be a nuisance. When this automation runs, it will delete any blank rows the table has. This should wrap the action in an Apply to each step to delete all the blanks. We can select our ID column as the Key Column and then add the ID field from the Filter array action. We can now use the Delete a row action to delete these blank rows.This will get us all the rows with blank cells. We can filter on the values from the List rows present in a table action and set the condition as Make is equal to blank (leave the value empty). Because we can’t filter on the blank values with Odata filters, we need to use a Filter array data operation action to do this.
The best option would also be to use the Odata filters in the Show advanced options section to filter on the blank rows, but this is currently not possible to filter on blanks. We can set up a small Flow automation to do this.
