Set a different expiration date for files FOR sharepoint

%3CLINGO-SUB%20id%3D%22lingo-sub-1604193%22%20slang%3D%22en-US%22%3ESet%20a%20different%20expiration%20date%20for%20files%20FOR%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604193%22%20slang%3D%22en-US%22%3E%3CP%3EHI%3C%2FP%3E%3CP%3EI%20have%20a%20document%20library%3CBR%20%2F%3EI%20want%20to%20set%20different%20expiration%20date%20for%20files%3C%2FP%3E%3CP%3ESend%20an%20alert%20to%20the%20e-mail%20when%20this%20date%20is%20reached%3C%2FP%3E%3CP%3ETHANKS%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1604424%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20a%20different%20expiration%20date%20for%20files%20FOR%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604424%22%20slang%3D%22en-US%22%3EWhat%20do%20you%20mean%20by%20expiration%3F%20Do%20you%20mean%20retention%20of%20documents%3F%20Or%20sharing%20of%20documents%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1604471%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20a%20different%20expiration%20date%20for%20files%20FOR%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604471%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3B%26nbsp%3BI%20don't%20mean%20that%2C%20but%20I%20do%20mean%3CBR%20%2F%3EFor%20example%2C%20I%20have%20a%20commercial%20registration%20certificate%20that%20expires%20after%206%20months%2C%20for%20example%3CBR%20%2F%3EI%20want%20to%20set%20a%20date%20and%20get%20an%20email%20alert%20when%20that%20date%20comes%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1604483%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20a%20different%20expiration%20date%20for%20files%20FOR%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604483%22%20slang%3D%22en-US%22%3EYou%20can%20look%20into%20retention%20and%20disposition%20of%20content%2C%20but%20that's%20pretty%20complex%20and%20requires%20labeling%20of%20all%20documents%20etc.%20%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20it%20sounds%20like%20you%20need%20to%20setup%20tasks%20or%20something%20based%20on%20that%20document.%20In%20this%20case%20I%20would%20have%20a%20library%20with%20a%20follow%20up%20metadata%20column%20and%20then%20create%20a%20flow%20using%20power%20automate%20that%20runs%20on%20a%20daily%20schedule%20and%20e-mail%20or%20create%20a%20task%20or%20whatever%20other%20action%20when%20that%20date%20matches%20the%20date%20you%20set%20in%20that%20column%20for%20the%20file.%20%3CBR%20%2F%3E%3CBR%20%2F%3ELaura%20Rogers%20and%20Shane%20Young%20have%20some%20good%20content%20on%20Youtube%20for%20learning%20flow%20etc.%20if%20you%20want%20to%20look%20into%20going%20down%20that%20route.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1604495%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20a%20different%20expiration%20date%20for%20files%20FOR%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604495%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767174%22%20target%3D%22_blank%22%3E%40MOHAMED_FAYYAD%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20would%20be%20similar%20to%20this%2C%20but%20instead%20of%20%22Created%22%20It%20would%20be%20a%20custom%20date%20column%20on%20your%20library%20like%20%22Expires%20on%22%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22schedflow.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F213770i668E33E950E42A70%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22schedflow.PNG%22%20alt%3D%22schedflow.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1604499%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20a%20different%20expiration%20date%20for%20files%20FOR%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604499%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3BExactly%20what%20I%20want%3CBR%20%2F%3EThat%20I%20receive%20an%20email%20on%20these%20dates%20on%20Outlook%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.JPG%22%20style%3D%22width%3A%20955px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F213771i3F83D9655F478E9B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Capture.JPG%22%20alt%3D%22Capture.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1604510%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20a%20different%20expiration%20date%20for%20files%20FOR%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604510%22%20slang%3D%22en-US%22%3EYeah%20you%20would%20want%20to%20setup%20a%20flow%20similar%20to%20my%20example%20above.%20%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20set%20a%20manual%20reminder%20using%20the%20built%20in%20reminder%20flow%20they%20have%20in%20libraries%20now%20under%20%22Automate%22%20when%20you%20select%20an%20item%2C%20you%20can%20specify%20to%20give%20you%20an%20alert%20on%20that%20date%2C%20but%20you%20have%20to%20do%20it%20for%20each%20item.%20I'd%20prefer%20the%20flow%20personally%20since%20you%20can%20setup%20your%20own%20rules%20and%20own%20custom%20e-mail%20etc.%20based%20on%20the%20match.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1604521%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20a%20different%20expiration%20date%20for%20files%20FOR%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604521%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%2C%20I%20don't%20know%20how%20to%20do%20the%20flow%20that%20you%20did%3CBR%20%2F%3EIs%20there%20a%20video%20or%20something%20like%20this%3F%20Take%20steps%20to%20implement%20that%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1604523%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20a%20different%20expiration%20date%20for%20files%20FOR%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604523%22%20slang%3D%22en-US%22%3ELaura%20Rogers%20%2F%20Shane%20Young%2C%20search%20youtube%2C%20there%20is%20tons%20of%20content%20how%20to%20do%20flows.%20Here%20is%20the%20first%20search%20result%20of%20something%20pretty%20similar%2C%20it's%20an%20older%20post%20and%20the%20%22apply%20to%20all%22%20is%20generated%20for%20you%20automatically%20but%20same%20holds%20true.%20%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.sharepointsiren.com%2F2018%2F03%2Fusing-flow-to-send-email-reminder-from-sharepoint-data%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.sharepointsiren.com%2F2018%2F03%2Fusing-flow-to-send-email-reminder-from-sharepoint-data%2F%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

HI

I have a document library
I want to set different expiration date for files

Send an alert to the e-mail when this date is reached

THANKS

8 Replies
What do you mean by expiration? Do you mean retention of documents? Or sharing of documents?

@Chris Webb  I don't mean that, but I do mean
For example, I have a commercial registration certificate that expires after 6 months, for example
I want to set a date and get an email alert when that date comes

You can look into retention and disposition of content, but that's pretty complex and requires labeling of all documents etc.

But it sounds like you need to setup tasks or something based on that document. In this case I would have a library with a follow up metadata column and then create a flow using power automate that runs on a daily schedule and e-mail or create a task or whatever other action when that date matches the date you set in that column for the file.

Laura Rogers and Shane Young have some good content on Youtube for learning flow etc. if you want to look into going down that route.

@MOHAMED_FAYYAD 

It would be similar to this, but instead of "Created" It would be a custom date column on your library like "Expires on" 

 

schedflow.PNG

@Chris Webb Exactly what I want
That I receive an email on these dates on OutlookCapture.JPG

Yeah you would want to setup a flow similar to my example above.

You can set a manual reminder using the built in reminder flow they have in libraries now under "Automate" when you select an item, you can specify to give you an alert on that date, but you have to do it for each item. I'd prefer the flow personally since you can setup your own rules and own custom e-mail etc. based on the match.

@Chris Webb  

Unfortunately, I don't know how to do the flow that you did
Is there a video or something like this? Take steps to implement that

Laura Rogers / Shane Young, search youtube, there is tons of content how to do flows. Here is the first search result of something pretty similar, it's an older post and the "apply to all" is generated for you automatically but same holds true.
https://www.sharepointsiren.com/2018/03/using-flow-to-send-email-reminder-from-sharepoint-data/