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.

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Adrian59 161 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Adrian59 161 on at

Like (0)

Report
Copy link

Link copied!

Hi Manish
It did not work.

Was this reply helpful? Yes No
Verified answer

Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Adrian59 161 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No