You need to be looking at my threads below:
The latter will be important for you if you are to get the right data for your expiry if it is a leap year.
I hope to post some replies to the above posts in the next 24 hours so if you can wait till after the weekend we maybe able to have solution soon.
Thank you very much for your support.
I have seen those documents. I need to dig. I am not looking 365 days.
In fact, we have 50 suppliers, each of them has 10 documents with different expiry dates.
Each documents have different validity : 12 months, 18 months, 36 months, Or Else.
I have from existing data : 500 documents. Like I explained : XXX - XXX DD.MM.YYYY
Each of them start with Supplier Name -> I would like to trigger a from table with Name and Email Address
Each of them have Document Name in middle
Each of them have Expiry Date on it -> I would like to trigger Send an email to Supplier with the name of the document on the day of the Expiry date.
My set up is I have all documents on Sharepoint. I don't know where to pull out that.
I need tool to decompose the Documents name (end with Date).
Apply Time check on Date.
I was thinking also to break our documents codification and use Sharepoint Column or Meta.
First of all I highly suggest you to use columns in SharePoint. Such thing is better to work with than name of file. Also if you have documents in word format such metadata - columns can be used within word. So you can for example have one template document that you will use in future and if you fill metadat inside it it will be published to columns in your SharePoint document library where are such columns available.
Next thig is easy a there is a lot of examples within this community, just create scheduled Flow that will run each day and check dates of files and then do proper action.
There is also comming to SharePoint Online for Flow this reminder option that is super easy to setup and can be modified - https://techcommunity.microsoft.com/t5/Microsoft-SharePoint-Blog/It-s-time-for-reminders-in-SharePoi...
To sum up, you mean extracting the expiration date contained in the file, and then checking whether the document has expired every day. If it expires, you want to send the email notification to the supplier.
I agree with @vecerpa's suggestion that you can try it as he said.
In addition, I have a method here to achieve your needs, you could follow the steps below to configure your Flow.
At present, the information provided by you can obtain the corresponding Email address from the Excel table according to the supplier name, and then extract the expiration date from the File name.
Please take a try.
I created a separated box for dates.
The flow is including also box which don’t have dates.
I have also a folder : Old, for Older documents to be put in. It is also including the Older files.
Library -> documents + folder olds (documents inside.
I created a Column Status : old (folder) / new (root). But not helping
Can you help ?
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!