Hello Peter, Many thanks for the tutorial. You mentioned that you have another demo for the other ways to add links in to the body. Could you please share the link of that your TH-cam video? Thanks again!
Sir, in my list ,there are 2 items with similar expiry date. However there is only 1 item found by query and trigger the reminder email.. Can you help?
This video was very very helpful, everything is working for me. however i may have messed up somewhere! when I select the counterpart option to select the company name in the metadata all i can select is a number, this does link to the correct counterpart but i have to have a seperate list for reference. have i done something wrong? thanks again
Suppose I have set two reminders on a single day in a sharepoint calendar. One is under category birthday and another under category meeting. Using Microsoft Flow, I want to send email only if the calendar category is birthday for that day. I do not want any mail if category is meeting or anything else. How do I do it? Can you please make a video on that?
Hello Peter, I have one more query. By setting up the expression, the email will only be sent one the same day, when there are 7 days left for the contract renewal. What if, we want to send the email everyday starting from 7th days before, until the due date is reached?
5 ปีที่แล้ว +1
They you would have to change the condition, so that it catches those items that are within that window.
Hello peter 1 question if I put mail thing in loop then it is sending many mails to respected person depending upon rows in sharepoing list. Any clue how we can send only 1 mail to person to review
Can I get some help. I'm trying to have it filter items that are due in 30 days or past due. I'm still get items due more than 30 days. I'm not sure what the ODATA filter should be?
ปีที่แล้ว +1
I have done a few other videos regarding time and flows. Please check them out, it is free. I also sell consulting services if you have the budget.
Hi Peter, thank you very much for you tutorial this is really helpful ! I succeeded to create reminders but my point is that, all the contracts don't have the same notice period, and I can't find a way to add a variable in the calculation of the date of the reminder depending on that notice of termination period.... would you have any idea ? The notice of termination is a specific column of my sharepoint, but can't be included in the "adddays" expression as a variable like "notice of termination in days + 7" to give enough time to review the contract.... thanks for your help !
Hi Thanks for this - However my flow is only returning 1 record ( I have used the filter to send email reminders for 90 days renewal warnings), its only emailing 1 record and forgetting the others. Any ideas guys?
I have used this and now want to take it the next step. if I want to email a manager all their renewals coming up say in the next 30 days (so they have a high level view of what renewals are due that month) what formula do I use?
I am delighted that you found use for this video. I don't have that formula ready. Would be happy to figure it out for you, but I would have to charge you for my work. For more information, please refer to: www.kalmstrom.com/Services or email us at sales@kalmstrom.com
Dear Peter, i want to use SharePoint's SendEmail API to send the email(no-reply email address) notification. i've created and test flow successfuly running but i didn't receive those email. Can you assist me please?
@@kalmstrom Hi, more question. i try to add action for condition before send an email, but there found an error on Apply to each../ can you help suggestion?
@@user-dy8pe1lg3z Yes, I would be delighted to help. Here is a description of my minimum support package: www.kalmstrom.com/Services/4-hours-sessions.htm
Can you assist if conditions are the following: 1. The created date is more than 5 days 2. and The status of the existing item is still "Pending" Action will be: email the owner of the item in the list Hope you can help.
Yes, we can certainly assist. We are happy to offer you a support package where we can solve this issue and others. For more information see our website or email sales@kalmstrom.com
Hi, how can I do this but with a calculated column (Items have different times) When I try it gives me an error telling me It is not possible with calculated columns type.
Thanks so much. I spent many days working with Flow to no avail. You covered the filter query better than anyone I've seen yet.
Thank you so much, I had trouble getting this done, but your video made it so much easier.
I am glad I was able to help :-)
Thanks a lot. I was trying to get this done for months now and you explained it very well on how to filter the query.
That is the tricky part :-)
@@kalmstrom if I have to filter for all renewals 90 days from today, I believe I will have make it +90 is that correct
instead of "eq" what is the string for greater than?
@@dexterinc
Yes, that sounds correct to me.
@@kalmstrom I tried 90 in the formatdatetime I'm not getting any output . Instead of "eq" what would the string for greater than?
Super...you have helped me solve one of my problems for the month....easy and quick guide
I am glad to hear that my demo helped you to solve your problem :-)
Hello Peter, Many thanks for the tutorial. You mentioned that you have another demo for the other ways to add links in to the body. Could you please share the link of that your TH-cam video? Thanks again!
Just what I have been looking for. Thanks
Glad you liked it :-)
Hi Peter, Thank you very much for this helpful totorial, I would like to know did you upload this word document? With all fields?
Please review this article and see the video that comes before this one:
www.kalmstrom.com/Tips/SharePoint-Flows/Flow-Contract-Reminder.htm
@ Thank you now it works
IT'S WORKED !! THANKS SIRR
Glad to hear it 🙂
Is this using Sharepoint or Sharepoint Online which comes with Microsoft 365 business (completely online/on cloud)? thanks
This is using SharePoint online and Flow, which has since been renamed to Power Automate - all part of Office 365 online cloud.
Hi Peter excellent, thanks. If I want to compare the Renewal Date with the Date of Today do I need that format date option ?
Yes, working with dates is tricky but formatting the date is the key.
Peter Kalmström ok, thanks Peter, but what format do I need to use ?
@@Fimpiekijke
That would be an excellent topic for another video and article.
Sir, in my list ,there are 2 items with similar expiry date. However there is only 1 item found by query and trigger the reminder email.. Can you help?
Thank you that helped, I spend few weeks figuring out doing this. I wasn't successful either
Glad it helped :-)
This video was very very helpful, everything is working for me. however i may have messed up somewhere! when I select the counterpart option to select the company name in the metadata all i can select is a number, this does link to the correct counterpart but i have to have a seperate list for reference. have i done something wrong? thanks again
I am glad you liked it :-)
Most likely your lookup column is set to pick the ID column, instead of the Title.
@@kalmstrom it was exactly that! thank you so much!
@@jason84woods
Been there, done that :-)
If i have a calculated Column for Renewal Expiry Date, I cannot run from the Flow. So how do i create the query base on the Create date?
Suppose I have set two reminders on a single day in a sharepoint calendar. One is under category birthday and another under category meeting. Using Microsoft Flow, I want to send email only if the calendar category is birthday for that day. I do not want any mail if category is meeting or anything else. How do I do it? Can you please make a video on that?
You did it very well
Glad you liked it 🙂
Hello Peter,
I have one more query. By setting up the expression, the email will only be sent one the same day, when there are 7 days left for the contract renewal. What if, we want to send the email everyday starting from 7th days before, until the due date is reached?
They you would have to change the condition, so that it catches those items that are within that window.
Hello peter 1 question if I put mail thing in loop then it is sending many mails to respected person depending upon rows in sharepoing list. Any clue how we can send only 1 mail to person to review
I would add another column which contains a yes/no value indicating if the review request has been sent or not.
Fantastic demo 👏👏
Thank you!
Hi, is it possibile to apply to a calculated column?
No, I don't think that calculated column's are supported.
@ ok, thank you...I need to find another way...
Can I get some help. I'm trying to have it filter items that are due in 30 days or past due. I'm still get items due more than 30 days. I'm not sure what the ODATA filter should be?
I have done a few other videos regarding time and flows. Please check them out, it is free.
I also sell consulting services if you have the budget.
Question. I need to send an email when Modified + 90 = Today. How do I do that? Thanks.
You would have to create a calculation like the one in the video but based on the modified date column and the 90 days.
Good luck!
@UCmvDtpuLRD9mvRzMCFM9M9ASounds like a good start.
We offer consultancy services described here:
www.kalmstrom.com/Services/4-hours-sessions.htm
@@kalmstrom Thanks. Any reason why it works to send email but but only return one record for approval
I turned on the Concurrency Control on Apply to each and it worked.
Hi Peter, thank you very much for you tutorial this is really helpful ! I succeeded to create reminders but my point is that, all the contracts don't have the same notice period, and I can't find a way to add a variable in the calculation of the date of the reminder depending on that notice of termination period.... would you have any idea ? The notice of termination is a specific column of my sharepoint, but can't be included in the "adddays" expression as a variable like "notice of termination in days + 7" to give enough time to review the contract.... thanks for your help !
Hi Thanks for this - However my flow is only returning 1 record ( I have used the filter to send email reminders for 90 days renewal warnings), its only emailing 1 record and forgetting the others. Any ideas guys?
Hi. Is time zoon important if we are in regional offices? Please help.
i have a doubt.... utcnow, 7 means email will be sent 7 days before renewal due date?
Yes, that is the business rule that I implement in this flow.
I have used this and now want to take it the next step. if I want to email a manager all their renewals coming up say in the next 30 days (so they have a high level view of what renewals are due that month) what formula do I use?
I am delighted that you found use for this video. I don't have that formula ready. Would be happy to figure it out for you, but I would have to charge you for my work. For more information, please refer to: www.kalmstrom.com/Services or email us at sales@kalmstrom.com
Dear Peter, i want to use SharePoint's SendEmail API to send the email(no-reply email address) notification. i've created and test flow successfuly running but i didn't receive those email. Can you assist me please?
As your teaching, i just change from 'Send an email' to 'Send an HTTP request to SharePoint'
@@user-dy8pe1lg3z
Sounds like a good idea, but I have not tested that myself. Good luck!
@@kalmstrom Hi, more question. i try to add action for condition before send an email, but there found an error on Apply to each../ can you help suggestion?
@@user-dy8pe1lg3z
Yes, I would be delighted to help. Here is a description of my minimum support package:
www.kalmstrom.com/Services/4-hours-sessions.htm
Is there a way that while using "Click here" the link takes us to the particular line item instead of taking directly to the document
Hi .. how mush do you charge
Could this also work with a list so you could import contract expory dates to a list via an excel file?
Yes, it could no doubt work with any data.
Hi. I made the same flow but it is not running!! When I test the flow it is ok! Please help.
Me too.
Can you assist if conditions are the following:
1. The created date is more than 5 days
2. and The status of the existing item is still "Pending"
Action will be: email the owner of the item in the list
Hope you can help.
Yes, we can certainly assist. We are happy to offer you a support package where we can solve this issue and others. For more information see our website or email sales@kalmstrom.com
Hi , can you help me?
I have an excel file. Can we make it send an email when we have a task overdue day in this file?
Sure, I am a consultant so of course I can help you :-)
Here is my minimum project description:
www.kalmstrom.com/Services/4-hours-sessions.htm
Awesome
Very glad you liked it :-)
crack
I take that as a compliment :-)
Unfortunately this didnt help
Hi, how can I do this but with a calculated column (Items have different times) When I try it gives me an error telling me It is not possible with calculated columns type.