Scan Sharepoint and check for the last time it has been changed

[keremtsc]

Hello everyone,

is it possible to scan every file inside a Sharepoint and check for the last time it has been changed? If so please explain how.

I want to check that and afterward send out an Email for example and ask the Owner of the file & the person that changed last time if it is still needed. IF the file has been changed 12 months ago for the last time.

Thanks

Kerem

[happyume · Accepted solution]

You can create a recurring/schedule Flow and then Get Files from your SharePoint Document Library

To make sure you only get files which were Modified 365 days ago, use Filter query as seen in screenshot below:

Modified lt '@{addDays(utcNow(),-365)}'

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 this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[keremtsc]

Hi @happyume,

I am getting this errorcode:

The expression "ModifiedIt 2020-09-01T11:28:06.0630813Z" is not valid. Creating query failed.

[happyume]

---

@keremtsc wrote:

Hi @happyume,

I am getting this errorcode:

The expression "ModifiedIt 2020-09-01T11:28:06.0630813Z" is not valid. Creating query failed.

---

There should be a space between Modified and lt

Also, the date needs to be within single quotes

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 this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[happyume]

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 this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[keremtsc]

@happyume 

The expression "Modified It @{addDays(utcNow(),-365)}" is not valid. Creating query failed.

Sorry if I do some simple things wrong. I put it in single quotes.

[happyume]

From my original solution, please see screenshot below on how it should look:

To add the expression for addDays(), use the Dynamic content window:

Are you able to share your screenshot on how you are writing this syntax, so that we can troubleshoot it?

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 this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[happyume]

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 this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[happyume]

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 this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[keremtsc]

@happyume 

Thank you again! I see what I did wrong there.

This time though it should be right but it still gives me the error: The expression "Modified It '2020-09-01T11:48:51.4363547Z'" is not valid. Creating query failed.

[happyume]

---

@keremtsc wrote:

@happyume 

Thank you again! I see what I did wrong there.

This time though it should be right but it still gives me the error: The expression "Modified It '2020-09-01T11:48:51.4363547Z'" is not valid. Creating query failed.

---

The keyword after Modified is lt and NOT It 

Here, lt stands for less than, you have used i instead.

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 this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[happyume]

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 this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[happyume]

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 this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[happyume]

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 this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

[keremtsc]

Thanks again! (What a silly mistake by me)

I have created this with your help:

What would I have to put into the condition 1 to get this to work?