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
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Users online (8,378)