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

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,635

Flow Action

Send file attachments to JIRA issues using cURL

This example shows how to send file attachments to issues in JIRA cloud.

PAG Admin

532

Flow Action

PowerToys for Power Automate for Desktop

These PowerToy shortcuts are made for Windows users for the purpose of make their computing lives better.

PAG Admin

886

Flow Action

Read Google Sheets API With Power Automate for Desktop

This example uses Invoke Web Service flow action to send a request to Google Sheets API, the response contains spreadsheet values.

PAG Admin

1,515

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,749