Help using a Sharepoint List trigger WITH a schedule / recurrence

[RyanBentham]

Hi all

So I currently have a working Flow that is triggered "when a new item is created" within my sharepoint list.

The sharepoint list contains various parameters that are passed into a flow.  

This is all fine but I also need the ability to create a recurrence.  So my sharepoint list contains a field called "recurrence?" which is true or false and then a "recurrence_freq" which is daily, weekly or monthly.    I need my new flow trigger to essentially be:  "when a new item is created in sharepoint list,  check if recurrence is required,  if not, just run once, otherwise take the value of daily, weekly or monthly"

Any help on a solution would be great?  Thanks

[Pstork1 · Accepted solution]

Unfortunately, that's not the way a Recurrence trigger works.  To do what you are describing essentially requires 4 flows.

1) The original flow you have which runs when an item is created.  Unless you want it to run the first time its created you probably want a condition that terminates the flow successfully if recurrence is set to True.

2) You need 3 flows triggered on different recurrence schedules.  One daily, one weekly on a specific day, and one monthly on a specific date.  Each of those will do a get items to filter all the items in the list where recurrence is true and the req_frequency is set to daily, weekly, or monthly. (that's why you need three separate ones.)  These flows will then do whatever process you want on all the items that fit that logic.

[RyanBentham]

@Pstork1 

Thanks for the info.  Now understood

🙂

[PowerExplorer]

@Pstork1 Please I need help if you got a min, My req is slightly different, I couldn't avoid get items , I rather use Get Item so I can email each items separately . Each Item contains different POC so even if both conditions are met I want the email goes out separately not in a batch and it seems recurrence and get item doesn't work together. Get items ship all the records meet the condition in one email but I want to get each record from SP and email SP item in a table format to the POCs entered in the list people picker. Need to use the recurrence trigger at the same i need to email each item separately. 

Any chance I can use  'When an item is created or modified ' as a trigger and  recurrence as an action  ? OR can i avoid Get items ? OR can retrieve a single record from Get items? 

Delay until  action is too much headache since i will be triggering weekly, bi weekly, monthly, quarterly ,...at exact date and time. Too much expression and calculation  . 

Thanks for the help in advance. 

[Pstork1]

Please post this as a new question.  You'll get more responses and others will be able to find the answer more easily later. AFter you post it send me a link and I will try to help.

[PowerExplorer]

https://powerusers.microsoft.com/t5/General-Power-Automate/Get-Item-action-with-recurrence-trigger/m...