Answered

Display Modified SharePoint Files in Gallery

(0) Share

Report

Posted on by PVLove

299

Hello All,
I'm creating a Gallery that will display a SharePoint document library subfolder and the files that have been modified within the past 7-days. I was able to display the files in the subfolder with this formula:

Filter(Documents, IsFolder = false && StartsWith('Folder path', "Shared Documents/Estimating")

However, I'm not sure what formula to add to display the modified files. I've tried the following and the gallery is blank and nothing is displayed. Your help is sincerely appreciated!

Filter(Documents, IsFolder = false && StartsWith('Folder path', "Shared Documents/Estimating"), Modified >= DateAdd(Today(), -7, Days))

Filter(Documents, IsFolder = false && StartsWith('Folder path', "Shared Documents/Estimating") || (Modified > DateAdd(Today(),-7,Days)))

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @PVLove ,

Apart from none of that being Delegable (so it will not work as your Library grows, this should work

Filter( Documents, !IsFolder && StartsWith( 'Folder path', "Shared Documents/Estimating" ) && Modified >= DateAdd( Today(), -7, Days ) )

however you could try this

With( { wLib: Sort( Documents, Modified, Descending ) }, Filter( wLib, !IsFolder && StartsWith( 'Folder path', "Shared Documents/Estimating" ) && Modified >= DateAdd( Today(), -7, Days ) ) )

which would use the newest 500-2000 (depending on your settings) in the filter at the bottom. You would also not get any Delegation warnings.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
PVLove 299 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz, thank you so very much. The second formula worked like a charm!
Patti

Was this reply helpful? Yes No