Deleting Multiple rows at once on column header filter condition

[SourabhJ767]

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

[Henrik_M]

Check this out and see if you can get it working: Run SQL queries on Excel files - Power Automate | Microsoft Docs

[MichaelAnnis]

On the first "Click Yes" which I assume is to uncheck Yes, do this instead:

• If UI Element Exists %No%
  • Click UIElement %Yes%...go through the whole process
• End

This way, it will only do that if no exists; otherwise skip everything and leave it.

Best of Luck.

[SourabhJ767]

Thanks Henrik_M, SQL queries can be used on excel files to handle large data. 

[SourabhJ767]

Thanks MichaelAnnis  for your response, I am newbie to the power automate desktop could you please let me know where to use this condition "If UI Element Exists No" and which resource can be availed to achieve this.

[MichaelAnnis]

Sorry, it is "If window contains" and the drop down is "Contains UI element"