Unanswered

Daily Scheduled Flow that creates a work order based on criteria recreates work order because the same conditions are met however that work order has been completed.

(0) Share

Report

Posted on by Community Power Pla...

I have many flows that check a SharePoint list "Asset Register" daily to see if any of the vehicles (assets) have kilometres that are within the conditions of a range of values, if yes then a flow will create a work order in another list "Open Work Orders" informing the service man that a service is due, then once the service is completed the work order is marked as complete and then sent to another list "Closed Work Orders" and deleted in the "Open Work Orders" list.

All works great however if the work order is created and the service man completes the work order and the next day the vehicle is still within the same range ie the range is 10000 and 10500 and the vehicles today is 10001 and the next day 10100 it is still within that range and another work order is created,

How can i somehow mark that vehicle that the service has been completed and not create a duplicate.

Currently the service man is deleting the duplicates however id like for them to not be created.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

RobElliott 10,323 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Anonymous one way to do it would be to have a column in the Assets Register list for 10500Service with a default value of No. In the flow that gets the items from this asset register set a filter query of 10500Service eq 'No' so that only those vehicles where that service has not been completed are brought back.

Then when the flow send the item to the Closed Work Orders list it could also update the item in the 10500Service column in the Asset register with Yes.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@RobElliott wrote:
Hi @Anonymous one way to do it would be to have a column in the Assets Register list for 10500Service with a default value of No. In the flow that gets the items from this asset register set a filter query of 10500Service eq 'No' so that only those vehicles where that service has not been completed are brought back.
Then when the flow send the item to the Closed Work Orders list it could also update the item in the 10500Service column in the Asset register with Yes.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
Cheers for the reply Rob,

I had thought of this exact solution as ive used it for other issues.

However, i would have to have around 400 individual columns, as its not just kilometres services of every 10,000 like cars. There are heavy machinery here that are done every 250 hours (kind of like Kilometres but each actual hour the machine is running) There is about 400 individual flows each saying 250service due 500service due etc etc..

I was thinking of using some kind of calculation column to say service has been done in the last 14days?

Was this reply helpful? Yes No