Find or Remove Item from a List where Value contains a wildcard

(0) Share

Report

Posted on by MTIncPower

I have a list of files and I need PAD to look at this list and give me the list item that matches a wildcard ("SGC").

Is there a way to do this?

I tried "Remove item from list" with the Value of anything that doesn't end in "SGC" but it didn't like the syntax.

From experimenting, I've been able to parse a list with a regex wildcard but instead of giving me the list item where it found the "SGC" match, it simply stored the matched text.

Suggestions appreciated 🙂

Categories:

Power Automate Desktop

All responses (5)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @MTIncPower
Try this:
1) 'Get files in folder' to get the list of files (%Files% as output variable)
2) 'For each' CurrentItem in Files
3) 'If' %CurrentItem% (First operand) Does Not Contain (operator) 'SGC' (Second operand) then
4) 'Remove item from list' > Remove item by Value, With value = %CurrentItem%, From list = %Files%
5) 'End' (If's end)
6) 'End' (For each's end)

At the end, %Files% will have only items with 'SGC'.
Daniel_Pa 244 on at

Like
a
(1)

Report
Copy link

Link copied!

Yasunm is right - I'll just add a screenshot for your convenience:
Riyaz_riz11 4,214 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MTIncPower ,

You can Try in this way
Try this:
Get files in folder' to get the list of files (%Files1% as output variable)
For each CurrentItem in %Files1%
If' %CurrentItem% (First operand) Does Not Contain (operator) 'SGC' (Second operand) then
Remove item from list' > Remove item by Value, With value = %CurrentItem%, From list = %Files1%
End (If's end)
End (For each's end)

At the end, %Files1% will have only items with 'SGC'.

If it works Please mark as a solution, so it will help even others also.
Regards
Ahammad Riyaz
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Are all the files in one folder to begin with? The "Get files in folder" command has a file filter.

File filter *SGC should only pull in those files. This says, it must end in SGC to be pulled in to the list.

Update: Adjain is correct...unless the file ends in .SGC, you will need the * after.
adijain Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MTIncPower You can use this directly
Note the two * before and after SGC in the file filter parameter. (*SGC*)