Email notifications to SharePoint users if a file is checked out for long time.

Question

Hi,&nbsp;I want to send SharePoint users automated email notifications if a file is left checked out for long time (say after 24 hours) and then send regular reminder till the file is checked in.I am not able to find any straight forward way to do it using alerts or workflow, please help.

jcgonzalezmartin · Answer

I think this cannot be done without development.

liza-123 · Answer

I am open to development option, can you please elaborate more on how can i do it with coding?

heiko watz · Answer

Try PowerShell with SharePoint PNP.Get all List-Items who ‘CheckoutUser’ is not empty.&nbsp;CAML:&lt;Query&gt;&nbsp;&nbsp; &lt;Where&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;IsNotNull&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;FieldRef Name='CheckoutUser' /&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/IsNotNull&gt;&nbsp;&nbsp; &lt;/Where&gt;&lt;/Query&gt;&nbsp;But there isn’t a check out date field ☹Try to use the Modified field.

Forum Discussion

Email notifications to SharePoint users if a file is checked out for long time.

Share

Resources