Answered

filtering sharepoint document library to latest uploads

(0) Share

Report

Posted on by Community Power Pla...

Hey community!

I've got a few Flows under my belt, but I'm struggling getting the correct output when trying to filter a document library down to the latest uploads from the last week. What I'm trying to accomplish is very similar to this post, but my filter array output is still blank:

https://powerusers.microsoft.com/t5/Building-Flows/Weekly-email-digest-new-items-in-SPO-list/m-p/293528

I've tried all manner of changing the filter parameters and my output is blank every time.

I know I am getting an output from the Get files step, and my document library is less than the 5000 item threshold. I don't see any option to throttle the number of items returned outside the "Top Count", so I assume it is grabbing them all.

Annotation 2020-06-24 085930.jpg

Thanks for the help!! 🙂

All responses (2)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: filtering sharepoint document library to latest uploads

Thanks! Yes, that worked well. Now to get the output in an HTML format that's readable, but probably warrants another topic post. 🙂
Verified answer

ScottShearer 25,236 Most Valuable Professional on at

Like (1)

Report

Re: filtering sharepoint document library to latest uploads

@Anonymous

I suspect that your issue is your date format - it should probably be yyyy-MM-dd.

That said, a much better way to approach this is to use a Filter query in you Get files (properties only) action. See my example below. The expression that I used can be seen in the action comments. Also, note the single quotes around the expression in my query.