Answered

Terminate a Flow when a SharePoint List Item is moved to another SharePoint List.

(0) Share

Report

Posted on by Adrian59

161

I have a flow that monitors a single SharePoint List Item when created. If the List Item is completed and moved to the Archived database prior to the end of the Flow Delay Period, the Flow fails, and I get failure messages from Microsoft.

How can I Terminate the Flow when the List Item is no longer in the original SharePoint List.

Any help would be greatly appreciated.

All responses (6)

Answers (1)

Adrian59 161 on at

Like (0)

Report

Re: Terminate a Flow when a SharePoint List Item is moved to another SharePoint List.

Excellent and thanks Manish
All working now.
Just have to get time conversion and emails work now.
Kind regards
Adrian
Verified answer

ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (1)

Report

Re: Terminate a Flow when a SharePoint List Item is moved to another SharePoint List.

Hi @Adrian59

The filter query syntax is incorrect. Pls give space after eq operator.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Adrian59 161 on at

Like (0)

Report

Re: Terminate a Flow when a SharePoint List Item is moved to another SharePoint List.

Hi Manish
It did not work.
ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (0)

Report

Re: Terminate a Flow when a SharePoint List Item is moved to another SharePoint List.

Hi @Adrian59

Pls add "Get items" action as mentioned in my previous reply after "Delay" action that query the list with item ID.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Adrian59 161 on at

Like (0)

Report

Re: Terminate a Flow when a SharePoint List Item is moved to another SharePoint List.

Hi Manish
Thanks for your response. Unfortunately I understand technically what you are saying but visually it is not working.
This Flow is for 1 SharePoint List Item only. Below is the error I am getting.
ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (0)

Report
Re: Terminate a Flow when a SharePoint List Item is moved to another SharePoint List.

Hi @Adrian59

You can add "Get items" action with filter query to check if an item exists in the list. Here is an example:

ID eq @{triggerOutputs()?['body/ID']}

Next, we will check the length of output array from the get items. The length will be greater than zero if item exists else it returns zero.

Expression used for calculating the length of output array:

length(outputs('Get_items')?['body/value'])

Pls adjust the name of the get items action in the above expression.

Add terminate action in "Yes" block when item is not found, or length is zero.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.