Unanswered

Check if SharePoint date contain 2019

(0) Share

Report

Posted on by rory99

Hi Guys

Is there a way I can add a condition in a flow that check a SharePoint list and go over each item to see if the date has the year 2019? I would like to automatically copy only the items that are dated 2019 to another SharePoint list

How can I create such a condition?

Thanks

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @rory99,

Do you want to get specific items that dated 2019 from one SharePoint list to another?

Please check the following flow for a reference.

Add Button trigger.

Get items from List B.

Add a Condition with the following code to filter out items that are dated 2019:

@equals(formatDateTime(items('Apply_to_each')?['DueDate'],'yyyy'),'2019')

Under If yes branch, add action Create item to create the filtered items into List A.

A screenshot for your reference:

Best regards,

Mabel

Was this reply helpful? Yes No
rory99 28 on at

Like (0)

Report
Copy link

Link copied!

Hello Mabel

Sorry for my late response

Unfotunalty my flow still does not work properly...
In my flow, I am ckecking if a column has the phrase "Testing Center" in it and if so, it checks if another column has the value "2019" as you suggested, if so, it copies the items to a different SP list

Only it fails on the first condition...but when I delete the 2nd condition and keep only the first one it works

any idea whay? Have I missed anything?

Here is the flow:

Was this reply helpful? Yes No