I want to delete multiple rows simultaneously from the excel on basis of column header filter, I have a column header with name "Presence Across Globe" which has two possible values "Yes" or "No" and the filter is applied on the column.
I want to delete all the rows at one go where the value of the column is "No" so for eg if I have overall 10 rows in my excel and 4 rows are there with "Presence Across Globe" as "No" then I will delete all the 4 rows simultaneously at one go and the excel should have only 6 rows remaining.
I am using UI elements to click the filter on column header and selecting only "No" records deleting them and re-selecting the "Yes" once the deletion is done, but this approach will fail if there is no records with "No" as the value of column header and it will delete the rows with "Yes" as well, I want to know if there is a possibility where I can go and check if the filter has "No" option as available and will delete the rows only if "No" is present in the filter itself.
I do not want to use Loop for deleting one by one.
Below is my power automate flow and excel
