Get files (Properties only) Filter query multiple file types

(0) Share

Report

Posted on by sachk1

258

Hi ,

In the Get files (Properties only) action need to filter the multiple file types like pdf, doc, xls, xlsx, ppt? Currently through my expression i able to get one file type successfully.

Is there any suggestion do this ?

Thanks

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi @sachk1

use or condition like below for filter query

substringof('.xlsx',FileLeafRef) or substringof('.pdf',FileLeafRef) or substringof('.ppt',FileLeafRef)

add more extensions as per the need using or condition.

Hope it helps !

Mark it as solution if it resolves your query !

Was this reply helpful? Yes No
PaulClifford-Jo 6 on at

Like (0)

Report
Copy link

Link copied!

There is a more direct and slightly easier way. Filter your library query with:

File_x0020_Type eq 'bak'

As recommended by anton-khrit here.

Was this reply helpful? Yes No
power_ap 46 on at

Like (0)

Report
Copy link

Link copied!

Thanks it worked, my question is where do I find MS technical documents that has a list of the properties such as 'FileLeafRef, FSObjType', etc.?

Was this reply helpful? Yes No