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!
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.
How do you edit the flow so the people responsible for updating the document only receive the notification email? Also, how do I make sure that the email doesn't come every day but only about 30 days or a few days before the expiration date?
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.
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?
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 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))
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!
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
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.
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.
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?
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?
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
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)
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!!
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))
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.
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!
Quick question, can't seem to find the "add column" in my sharepoint. How do I fix this? Thank you for answering.
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.
How do you edit the flow so the people responsible for updating the document only receive the notification email? Also, how do I make sure that the email doesn't come every day but only about 30 days or a few days before the expiration date?
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.
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?
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 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))
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!
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
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.'.
I am getting the same error, did you figure out the solution?
@@Tcrompton3 Not yet T.T maybe coz the updates and the vid is a year later maybe that's why. Didn't know that power automate will be a pain T.T
@@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
@@Tcrompton3 hmmmm thanks for this I'll try it. Kinda weird but my columns are all field out.
@@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.
Can you please advice how to configure Not to send a Email if there is no documents to be expired?
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.
The short answer is yes, that should be doable. You’d just have to reference that column in the To field of the send mail.
@@fctech8211 hi, did someone manage to do that?
I am curious as I have a list with a lot of documents with different document owners
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?
I am having trouble with it attaching the document name any suggestions?
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 receive the email but is not appearing the numbers below the column duedate, does someone know what can be ? it just appear in blank
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
@@bernadettepaterson6867 Hi Bernadette. Did you work out what was going wrong? I'm having the same problem :(
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)
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!!
Did you ever figure this out? I'm getting the same error.
I keep getting an error on "Filter array" could you assist please
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))
Very helpful. Thank you.
Thanks for watching!
Great video!
Nice video, can i aks you something? could you make a video with an expiration date on a sharepoint list?
Sure thing! I actually may already have a video like that. th-cam.com/video/ylyMwHiRioM/w-d-xo.html
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"??
I'll test that and get back to you here.
@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.