Help with IF Condition for File Name Filtering in Power Automate Desktop

(1) Share

Report

Posted on by unni1-

Hi All,

I'm having trouble getting the IF condition to work in Power Automate Desktop. Attached the Flow Screenshot FYR .

Goal:

I want to check if a file in my Downloads folder contains both:

A specific keyword: "InvoiceReconcileLogistics"
Today's date in the format yyyyMMdd (e.g., 20250707)

If the file name matches both conditions (e.g., "InvoiceReconcileLogistics 20250707.xlsx"), I want to move it to a folder on to my Desktop folder called "Logistics" from Download Folder
I've tried using the If CurrentListItem.Name Contains ${FileName} and CurrentListItem.Name Contains ${CurrentDate} conditions, but it doesn't seem to trigger correctly. I've confirmed that the CurrentDate variable is being set in the yyyyMMdd format.

Question:
Is there something I may be missing in the way I’m structuring the condition? Is it better to use a single combined string or a different approach?

Any guidance or tips would be greatly appreciated!

Thanks in advance!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

stampcoin 5,146 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@unni1- Hi,

Your flow looks good,

Ensure no extra spaces exist when setting variables.

Use logging or display messages to debug the exact values at runtime.

Always verify the downloaded filenames match your expected format exactly.

Maybe try to combine keyword and date into one string explicitly,

for example ExpectedFileName = ${FileName} ${CurrentDate}.

pseudocode：

1. Get current date and time (CurrentDateTime) 2. Convert datetime to text (yyyyMMdd → FormattedCurrentDate) 3. Set variable CurrentDate = FormattedCurrentDate 4. Set variable FileName = "InvoiceReconcileLogistics" 5. Set variable ExpectedFileName = "${FileName} ${CurrentDate}" 6. Get files from Downloads folder (*.xlsx) into DownloadFiles 7. For each CurrentListItem in DownloadFiles: - If CurrentListItem.Name Contains ${ExpectedFileName}: - Move file to "Logistics" folder on Desktop

Was this reply helpful? Yes No
Verified answer

VishnuReddy1997 2,656 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @unni1-,

Please find the solution.

Script :

DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateAndTime CurrentDateTime=> CurrentDateTime Text.ConvertDateTimeToText.FromCustomDateTime DateTime: CurrentDateTime CustomFormat: $'''yyyyMMdd''' Result=> FormattedDate Folder.GetFiles Folder: $'''C:\\Users\\HP\\OneDrive\\Desktop\\1992''' FileFilter: $'''*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> FilesList LOOP FOREACH CurrentItem IN FilesList IF (Contains(CurrentItem.Name, 'InvoiceReconcileLogistics') AND Contains(CurrentItem.Name, FormattedDate)) = $'''True''' THEN Display.ShowMessageDialog.ShowMessage Message: $'''yes''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed ELSE Display.ShowMessageDialog.ShowMessage Message: $'''NO''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed END END

Regards,

Vishnu Reddy

Was this reply helpful? Yes No