Need help with setting up reminders for a SharePoint list

[--EKM]

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 FLOW

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 list

[jwhite · Accepted solution]

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

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.

[--EKM]

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

[shaneOZ]

---

@--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?