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?
Hi Monique - sure thing. Odata filter for greater than or equal to is 'ge' greater than is 'gt' and less than is 'lt' In your workflow you'll want to do queries. You'll want to do a query to get items due in 30 days, then a different query to get items with a due date greater than today. So you could use the same workflow as in my clip, but add a parallel branch for the second query. get items where your-due-date lt substring-current-day - that will then get your overdue items - send an email as needed to the right people for items due in 30 days your-due-date eq substring30days (just like in the clip) I hope this helps a little bit! best of luck
Hi DML - get Future date can be from current time or a time in your list to work from - I normally use future time from the time the workflow runs and compare against a list date column - which is what is shown in this clip. Hope this helps.
Tried to follow this, had to add a calculated column to filter for items to summarize (contact person has not checked an approved box and today is on or past the due date), and now the flow doesn't recognize the field as existing.
Hi - Calculated Columns are not supported in Power Automate at this point in time. You may be able to use your odata filter to get the files you need - or run a different workflow to populate a column in your list to trigger from. Cheers
@@Richie1902 That explains it. Too bad Power Automate couldn't tell me that. I'll try to finagle the date column but it didn't like any form of the filter I put in: The expression "PlannerApproval eq 'No' and Planner_x0020_Response_x0020_Due le 2022-05-24T22:23:00.6723288Z" is not valid. Creating query failed.
audio is kinda inaudible. It's too low. Thanks!
Hi, do you have a similar video for sharepoint online?
how if all days except sunday? Thanks you.😀
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?
Hi Monique - sure thing. Odata filter for greater than or equal to is 'ge' greater than is 'gt' and less than is 'lt'
In your workflow you'll want to do queries. You'll want to do a query to get items due in 30 days, then a different query to get items with a due date greater than today.
So you could use the same workflow as in my clip, but add a parallel branch for the second query.
get items where your-due-date lt substring-current-day - that will then get your overdue items - send an email as needed to the right people
for items due in 30 days your-due-date eq substring30days (just like in the clip)
I hope this helps a little bit! best of luck
Get future date from when? The start date mentioned in recurrence or from current time when the flow triggered?
Hi DML - get Future date can be from current time or a time in your list to work from - I normally use future time from the time the workflow runs and compare against a list date column - which is what is shown in this clip. Hope this helps.
Tried to follow this, had to add a calculated column to filter for items to summarize (contact person has not checked an approved box and today is on or past the due date), and now the flow doesn't recognize the field as existing.
Hi - Calculated Columns are not supported in Power Automate at this point in time. You may be able to use your odata filter to get the files you need - or run a different workflow to populate a column in your list to trigger from. Cheers
@@Richie1902 That explains it. Too bad Power Automate couldn't tell me that. I'll try to finagle the date column but it didn't like any form of the filter I put in: The expression "PlannerApproval eq 'No' and Planner_x0020_Response_x0020_Due le 2022-05-24T22:23:00.6723288Z" is not valid. Creating query failed.
Scratch that. Got it working. I was missing the quotation marks which make no sense to me. Thank you.
How to stop sending due reminder email if status has completed ?
Hi - sorry for the delay - odata filter is your answer on your get items - use ne for not equals so SPStatusColumn ne 'Completed' hope this helps!