cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Need help with setting up reminders for a SharePoint list

Hello, everyone. What I am currently trying to do is automate a compliance calendar using a SharePoint list. What I want to accomplish is, every day at 6 am the Flow will start and check whether an item is 60 days out from the due date, if so, send a reminder to the responsible user with a link the SharePoint list item along with the name of the item. Another user helped me start the Flow but it's not working as intended. The step where it is not working as intended is when it checks to see if the LinkToItem string is not equal to null. If yes it sends an email with a link to item and item name, if no do nothing. It does send an email to the right user with the link to the item whose due date is 60 days out with the name of the item as well. It is also, however, sending an email to the other users with the name of the item and no link that is due for the correct user. Can anyone help me troubleshoot this?

Expression reference: 

union(variables('ResponsibleUser'),variables('ResponsibleUser'))
addDays(utcNow(),60,'yyyy-MM-dd')

 

Image references:Overview of FLOWOverview of FLOW

part1.pngpart 2.pngThis is where the problem is. The condition is true when it should be false and is sending emails to users whose item is not due.This is where the problem is. The condition is true when it should be false and is sending emails to users whose item is not due.

test listtest list

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver III
Resolver III

Re: Need help with setting up reminders for a SharePoint list

Hi @--EKM,

I set up a flow which I think duplicates yours entirely and get exactly the same result. Not quite sure why the condition for LinkToItem not equal to null isn't triggering how you would expect, however just changing to

length(variables('LinkToItem'))

is greater than zero on that condition then gave me the expected results

VariableLength.png

Let me know how you get on with that, if it doesn't work I will have to see what I have managed to make different between our flows.

View solution in original post

3 REPLIES 3
Highlighted
Resolver III
Resolver III

Re: Need help with setting up reminders for a SharePoint list

Hi @--EKM,

I set up a flow which I think duplicates yours entirely and get exactly the same result. Not quite sure why the condition for LinkToItem not equal to null isn't triggering how you would expect, however just changing to

length(variables('LinkToItem'))

is greater than zero on that condition then gave me the expected results

VariableLength.png

Let me know how you get on with that, if it doesn't work I will have to see what I have managed to make different between our flows.

View solution in original post

Highlighted
Frequent Visitor

Re: Need help with setting up reminders for a SharePoint list

Thank you for that work around! What I ended up doing was using an ODATA filter query all the way in the beginning to just grab items that were 60days out from the due date and just storing the responsible users email,link to item and name of item in their own string variables. I think this method is a bit more efficient instead of grabbing all items and then checking the due date. Thanks!

 

-E

Highlighted
Responsive Resident
Responsive Resident

Re: Need help with setting up reminders for a SharePoint list


@--EKM wrote:

Thank you for that work around! What I ended up doing was using an ODATA filter query all the way in the beginning to just grab items that were 60days out from the due date and just storing the responsible users email,link to item and name of item in their own string variables. I think this method is a bit more efficient instead of grabbing all items and then checking the due date. Thanks!

 

-E


Could you please pass on how you did this? what was the odata filter query you used?

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (5,518)