Get Files (Properties Only) ODATA Filter to filter files that match criteria on a separate SharePoint List

[Mdemarici123]

Hi All, 

I am having trouble building a summary email flow that gets files based on values in a separate list.

Context: my organization uploads files to SharePoint which are tagged with a 'document type' and also a category ID that we created. What I want to do is grab files that are within a given document type and also match against a list of certain category IDs that are contained in a SharePoint List.

Lets say I want to send a weekly file summary for files uploaded with IDs that are in the Red Category in the past week, I would have a Red Category ID SharePoint List like this...

Red Category ID's (SharePoint List)

Title Type

1       Red

2       Red

3       Red

4       Red

How can I filter ODATA or Filter the Array on the Get Files (Properties Only) to only get files that match the document type and also match a category ID from a separate SP List? I am using get files and get items then trying to use a filter array step but nothing i am doing seems to filter it the way I need. 

Thanks!

[v-LilyW-msft]

Hi @Mdemarici123 

Are the ‘document type’ and ‘category ID’ columns in your library?

Does the ‘category ID’ match the Title in the Red Category ID's (SharePoint List)?

Could you please provide the screenshots of the Flow configuration?

Best Regards.

[Mdemarici123]

Hi There @v-LilyW-msft, 

Thank you for taking the time to respond. Yes, both Category ID and Document type are in the library and Category ID is supposed to match the 'title' in the Red list. 

I am trying to see if there is an ODATA filter that I can put into the 'get files (properties only) action that will check the gathered files and match the ones with the same Category IDs that are obtained in the get items action above.

Everything I have tried has not worked and I just wanted to see if there is is something I am not thinking about.

[v-LilyW-msft · Accepted solution]

Hi @Mdemarici123 

This is my test list.

Assume I have a library like below, I set up a flow to filter out items whose created date is last week, type is red and categoryID exists in the list. Then send an email.

You can refer below screenshots to see if it helps.

Flow in details:

I set to run flow once every Monday.

Set a variable .

Get the date of previous Monday.

Get the date of previous Sunday.

Add get items action to obtain the item whose type is Red.

After flow runs,I will receive an email like this:

Hope the content above may help you.

Best Regards

[Mdemarici123]

@v-LilyW-msft Thank you so much for taking the time to walk me through this, it worked perfectly!