Forum Discussion

Liza-123's avatar
Liza-123
Copper Contributor
Nov 21, 2018

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

Hi,   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 a...
2010
Document Library
jcgonzalezmartin's avatar
jcgonzalezmartin
MVP
Nov 21, 2018
I think this cannot be done without development.
  • Liza-123's avatar
    Liza-123
    Copper Contributor
    Nov 21, 2018
    I am open to development option, can you please elaborate more on how can i do it with coding?
    • Heiko Watz's avatar
      Heiko Watz
      Iron Contributor
      Nov 26, 2018

      Try PowerShell with SharePoint PNP.

      Get all List-Items who ‘CheckoutUser’ is not empty.

       

      CAML:

      <Query>

         <Where>

            <IsNotNull>

               <FieldRef Name='CheckoutUser' />

            </IsNotNull>

         </Where>

      </Query>

       

      But there isn’t a check out date field ☹

      Try to use the Modified field.

Resources