Answered

Recurrence Workflow Condition Based

(0) Share

Report

Posted on by Nelygee28

Hello Everyone,

I was hoping to get some help on a workflow issue I'm having. I built a 'Recurrence' workflow to check on a list every hour which is checking on the 'Start Date and Time' and 'End Date and Time' of an item. I placed a condition that if the Start Date exceeds more than 2 weeks and the End Date hasn't occurred yet. Then it will be moved from the main list to another and be deleted from the main list along with attachments included.

Everything in the flow seems to be working fine up except when it transfers from the one list to the other based on the 2 week condition. When running the flow it will check each item correctly. But instead of just the one item that meets the condition transferring, it will transfer the entire list over even though the conditions weren't met for the other items.

I've tried using different outputs as 'Current Item' value from the Apply to Each and also using 'ID', but using those return a failed flow run. How can I go about just transferring the items based on the particular condition I placed.

Thank you.

Categories:

Building flows

Workflow2.png

Workflow1.png

I have the same question (0)

All responses (3)

Answers (1)

Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Nelygee28
You are using create item action inside apply to each Action that's why it's create all the item in another list after condition become true to prevent this you could use filter query in get item action.

Please show me Expression Which you are using inside of Condition Action.

--------------------------------------------------------------------
If I have answered your question, please mark post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Nelygee28 4 on at

Like (0)

Report

Hello @Amit_Sharma ,

Thank you for your reply. I see now what you mean, So I must use the filter query in the get items before applying the conditions. If my column is named 'Start Date and Time' would I use the same filter you have placed for 'Start Date It'?

For the condition I use the following:
'Start Date and Time' is less than subtractFromTime(utcNow(),15,'day')

And also created another condition which included both:
'Start Date and Time' is less than subtractFromTime(utcNow(),15,'day')
'Has Attachments' is equal to bool(true)

Thank you.

Was this reply helpful? Yes No
Verified answer

Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Nelygee28
You have to use correct column name according to your existing list without using space like StartDateandTime

If it's not work, please confirm internal column name of SharePoint list it should be same which you are passed in filter query of get item action.

Was this reply helpful? Yes No