Answered

Get Files (properties only) multiple file types

(1) Share

Report

Posted on by MK-10101830-0

Greetings,

I've build a flow that checks for certain types of Excel files(csv, xlsx) and moves them. I'm struggling with having the "get files" property recognize both types. If I use .xlsx or .csv the flow works as designed. If I try any combination of the two, no errors, just runs without moving any of the files.

Any thoughts? Also, if it helps all files lead with a 2024*.* naming convention.

Categories:

Business Process Flows

All responses (2)

Answers (1)

Verified answer

trice602 10,944 on at

Like (1)

Report

Get Files (properties only) multiple file types

Hi,

Also confirming this picked up a .csv file that starts with 2024 also. Always glad to help!

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn
Suggested answer

trice602 10,944 on at

Like (1)

Report

Get Files (properties only) multiple file types

Hi,

I wasn't able to do this directly with a filter query expression in Get Items but I was able to successfully make it work inside two conditions. Here's my flow:

Condition 2 I am checking:

length(items('For_each')?['{FilenameWithExtension}']) greater than or equal to 4

and

substring(items('For_each')?['{FilenameWithExtension}'],0,4) contains string('2024')

Works in testing. I had one excel file that started with 2024. So the actions you want to do with those files would fall under the condition 2 true side.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn