Flow | Power Automate Gallery

Using multiple OR conditions in a IF statement (2)

Second approach, using a list and looping items.

Folder.GetFiles Folder: $'''C:\\YOUR_FILE_PATH''' FileFilter: $'''*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> Files
Variables.CreateNewList List=> DoNotDeleteList
Variables.AddItemToList Item: $'''ABC-1234''' List: DoNotDeleteList NewList=> DoNotDeleteList
Variables.AddItemToList Item: $'''ABC-1235''' List: DoNotDeleteList NewList=> DoNotDeleteList
LOOP FOREACH CurrentItem IN Files
    Text.RegexParseForFirstOccurrence Text: CurrentItem TextToFind: $'''\\w{3}-\\d{4}.*\\.pdf''' StartingPosition: 0 IgnoreCase: False OccurrencePosition=> Position Match=> Match
    SET counter TO 0
    LOOP FOREACH ListItem IN DoNotDeleteList
        IF NotStartsWith(Match, ListItem, False) THEN
            Variables.IncreaseVariable Value: counter IncrementValue: 1 IncreasedValue=> counter
        END
    END
    IF counter = DoNotDeleteList.Count THEN
        File.Delete Files: CurrentItem
    END
END

See first approach:
https://power.automate.gallery/ayaJ8dEvPosX

References

[1]https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Need-to-comapare-multiple-conditions-in-the-If-loop-in-Power/td-p/755028

Author

PAG Admin

Also See These Flows

Flow Action

Find Text From Images Using Google Vision AI and OCR

This walkthrough shows all the steps it takes to analyze text from images with Optical Character Recognition (OCR) using Power Automate Desktop.

PAG Admin

696

Flow Action

Use Power Automate Desktop as a Web Scraper for Excel

Update existing Excel spreadsheet with information pulled from any webpage.

PAG Admin

882

Flow Action

Making Microsoft Dataverse OAuth 2.0 Queries Using PAD

This example shows how to retrieve top 3 accounts from your Dataverse / Dynamics 365 environment using Power Automate Desktop.

PAG Admin

1,681

Flow Action

Using Bootstrap 5 Components With JavaScript

Code snippets to help building web page automation with JavaScript.

PAG Admin

365

Flow Action

Write to Google Sheets API Using OAuth 2.0 Power Automate for Desktop

Write cell values to spreadsheets. Includes basic logic for handling refresh tokens for repetitive tasks.

PAG Admin

2,886