Great video, one question, what to do when the expiration date is a column type calculated? I have the column creation date + months(expected life) = expiration date
Thanks for the video. One question. Is it possible make the Outlook "To" field dynamic so that it emails the respective document owners, instead of just the one same person every time? If so, how would you do that?
Hi I have done this and it seems to work ok, what i did was added a dynamic content Owner/Email in the to field and this seemed to work, i have an issue were it is showing all my documents in the body of the email and not just the expired documents
Hi. Great video. You hard coded the recipient into the 'To' field for the email. How would this be configured to be sent dynamically to the document creator or perhaps based on another column such as document owner. Thanks
Hi, This works great, however, now it sends an email everyday even if there are no expired items. How do i add a Condition that it will only send an email if there are any expired items. Thank!
Thank you so much, this video was very helpful. I am trying to get the same table of items, but when a new order is placed ie 3 items ordered and all items are linked by an order ID. I would like the automatic email when a new share point item is created, but I was unable to make it a nice table list. Do you have a video on this?
Great video! I used your example for document expiration notification. It works well on all documents that were uploaded initially, but it doesn’t see the new documents. What could be the problem? Thanks!
How can i add a timer for an uploaded file reminder the uploader to return or download the file within a certain amount of time? My technicians occasionally download system program files, make changes and then forget to return the files to our server. The next technicians goes to the site but doesn't have the latest revision. Thank you.
Great video. I have a question, I want to create a flow for documents which are about to expire in 15 days and I got the error "The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@less(item()?['ExpirationDate'], addDays(utcNow(), 15, 'yyyy-MM-dd'))' failed: 'The template language function 'less' expects two parameter of matching types. The function was invoked with values of type 'Null' and 'String' that do not match.' Can you help me out here pls
FC Tech, you suck at "supporting your followers." We have all asked the question regarding the Filter array erroring out. Well, everyone, I found the fix. Click on "Edit in advanced mode" option and paste this in: @less(if(empty(item()?['Expirationdate']), 'No expiration date', item()?['Expirationdate']), adddays(utcnow('yyyy-MM-dd'), 1))
Hello. Great video. I got a question. Is there a way to send email notifications only when there is actually an ''Expired'' document? Now it sends emails everyday as scheduled, with blanks list of documents, even when there is no expired document. Thanks.
Super helpful video here! Thank you for sharing. I've built the flow (thanks to your help!), but I'm receiving the same email +10 times (one for each doc that has expired). Is there a way to fix this, so as only to receive one email?
Why doesn't my Query Work. It throws an Error. This the Error Thansk! The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@less(item()?['Next_x0020_Review_x0020_Date'], addDays(utcNow(), 10, 'yyyy-MM-dd'))' failed: 'The template language function 'less' expects two parameter of matching types. The function was invoked with values of type 'Null' and 'String' that do not match.'.
@@keyblade5916 I was able to figure out the answer. It is returning that because there are entries that have nothing in the field (so blank) And it can't process those which is why it's returning a null value. So what you need to do is put in the exclusion "{column name} ne null" And it will filter out all the null values
@@keyblade5916 this error occurs even if there are folders, it expects folders to have them filled out. Put that "... Ne null" in the filter query field.
Thanks for the video. When I run the flow it returns all the documents in my library, not just the expired ones. My date format is dd-mm-yyyy as I am in NZ. I tried to change the filter array to addDays(utcNow(), 0, 'dd-MM-yyyy') but it didn't make any difference. Any suggestions on how to fix this? Thank you.
Great video. I also recieved my email. But my table with the values/fields do not display. So the output from the select step do not show in my email. What am i doing wrong.
I had the same issue, then realized per these codes the table will only show up if there is a document expiring today. Once there is a document expiring today you should see the table
@@bernadettepaterson6867 I had the same issue, then realized per these codes the table will only show up if there is a document expiring today. Once there is a document expiring today you should see the table
what if the "expirationDate" column is calculated field. I dont' think that would be accepted in "query" field of "get file items". How would you take care of that
Can you send the email notification to the document owner? So if you have a column in the library that identifies the user/owner of a specific file and want to send the email notification to not your email address but send it to the user that is identified as the owner in the library list? This could be different people, pending on what document is up for renewal/expiry.
Is there a workaround if the Expiration Date actually a calculated column? (I get error: type ‘Calculated’ cannot be used in the query filter expression)
How do you create green notifications on a document or folder that has had edits and/or uploads like sharepoint 2010. It is very difficult to keep up with the notifications when my document library has a lot of content. How do i create a notification on the file?
I tryed to do step by step of the video and this error appears: The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@less(item()?['Fechavencimiento'], addDays(utcNow(), 0, 'yyyy-MM-dd'))' failed: 'The template language function 'less' expects two parameter of matching types. The function was invoked with values of type 'Null' and 'String' that do not match.'. Any idea of how to solve it?? Thank you!!
Let me know if that's close to what you're looking for. It's regarding Microsoft Lists instead of a SharePoint List, but the concept is exactly the same. If you're looking for something more specific, let me know.
@@fctech8211 i didn´t see that video, that was what i looking for, so much, i am very greatful. i only have a question, if i want to trigger an early email to the expiration date, you add it on the formula "utcnow(), 30"??
@claudio2021 Instead of using - formatDateTime(utcNow(), 'yyyy-MM-dd') - try addDays(utcNow(),5,'yyyy-MM-dd') where 5 equals the number of days in the future past today's date.
FC Tech, you suck at "supporting your followers." We have all asked the question regarding the Filter array erroring out. Well, everyone, I found the fix. Click on "Edit in advanced mode" option and paste this in: @less(if(empty(item()?['Expirationdate']), 'No expiration date', item()?['Expirationdate']), adddays(utcnow('yyyy-MM-dd'), 1))
