What is the best way to quickly filter and capture filenames which are stored on sharepoint?

(1) Share

Report

Posted on by Sormick

361

Hello,

I have JPG files stored on multple subfolders on sharepoint (maximum of 2000 files stored per subfolder. A total of 50 000 JPG files stored on multiple sub-folders.

i need to find the best way to filter these files (the faster way) with the filter condition using part of filename

For instance if i have on one sub-folder 2000 files with these filenames

PORTUGAL LISBON 1

PORTUGAL LISBON 2

PORTUGAL LISBON 3

SPAIN MADRID 1

SPAIN MADRID 4

ITALY ROMA 1

ITALY ROMA 3

ITALY ROMA 4

i need to find the faster way to filter all PORTUGAL LISBON filenames and store them on a sharepoint list:

PORTUGAL LISBON 1

PORTUGAL LISBON 2

PORTUGAL LISBON 3

I have added some columns on sharepoint to add filtering options and using a formula on a power app to filter filenames

but maybe there are other faster ways to filter filenames.

Please if you have some examples cloud you help me?

Thank you

Categories:

Business Process Flows

All responses (1)

Answers (0)

Suggested answer

Nived_Nambiar 16,591 on at

Like (0)

Report

What is the best way to quickly filter and capture filenames which are stored on sharepoint?

Hi,

You have to use this filter query if you are trying in power automate

substringof('PORTUGAL LISBON',FileLeafRef)

Here FileLeafRef represent the column/attribute having file name.

Hope it helps !

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!