Unanswered

Need to filter Get Items by using a Date Column that is a year ago, less 14 days

(0) Share

Report

Posted on by vikkimiddleton2

I really need HELP, spent a lot of time on this and keep ending up deleting everything and starting again!

Basically, I have a SP List for Contractor Inductions, these inductions are only valid for 12 months so I need to notify the user in another column (Originator) with a list of Items due to expire in the next 2 weeks (14days). This will run twice a week.

The following columns I am using for the flow and/or causing problems:

SP List Columns

Date of Induction (Date Column)
Induction Expiry Date (Calculated - based on Date of Induction +1 year)
Status Column (Calculated - "Active" if Induction Expiry Date is more than 14 days away, "Expiring Soon" if Induction Expiry Date is within the next 14 days & "Inactive" if Induction Expiry Date has lapsed)
Originator (Name or Person Column)

Now to make my life super easy, it would be great to be able to filter the Get Items action in Automate with the above Status column, BUT as Power Automate does NOT like calculated fields this does not work.

I have tried so many different ways to get the outcome I desire but nothing works. Latest flow was as follows, this is without any filters.

Please Please Please help me!

Thanks

Vikki

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-yetonggu-msft on at

Like (0)

Report
Hi @vikkimiddleton2 ,

You can use the Filter array to filter records with Status equal to "Expiring Soon".

Please check this test:

My SharePoint List:

My Flow Overall Preview:

My Flow Configuration Parameters:

item()?['Originator_x002e_/Email'] union(body('Select'),body('Select'))

item()?['Originator_x002e_/Email'] item()?['Title'] item()?['Status/Value'] item()?['DateofInduction'] item()?['Originator_x002e_/DisplayName']

My Outlook Inbox:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
vikkimiddleton2 2 on at

Like (0)

Report

Thank you so much for your quick response but still no joy - however this time the flow worked but I did not receive any email with the results. This is my list:
Status Column is calculated
Induction Expiry Date is also calculated
The Notification column was renamed so the actual column name behind the scenes is Originator

So basically I need a list of all the expiring soon to be listed in an email to whoever is in the Notification column which is why I am using the unique email bit.
Hope that makes sense.

Was this reply helpful? Yes No