autmatically change item status to delivered

[Khan321]

Hi Everyone 🙂

I have SharePoint list where people sends their orders for IT equipment's for example iPhone, computer, mouse, keyboard and a lot more.

The problem is when i order equipment and deliver that equipment after receiving i supposed to go to SharePoint list and change the status to delivered. I many time forgets to change the status to delivered and suddenly there are a lot of items in my list and i cannot remember if i have delivered them.

I have 4 categories in the in item status.

1. Not ready-- when we receive an order

2. Ordered but not received-- When we order that equipment but not received

3. Received--- when we receive equipment then employee gets an autogenerated email notifying him of arrival of the equipment.

Is it possible to send a notification after 7 days of changing the status to number 2 (Ordered but not received) to the person who send an order of equipment that if he has received the equipment and if he says yes then the status of equipment on the SharePoint list is automatically changed to Delivered?

Best Regards

Naji

[EnricoKnapp]

A common approach would be having a second flow on the same list with a daily schedule.

The workflow queries all the items from the list that have

- change date older than 7 days

- status number 2

After querying the items it iterates all found items and sends a Mail to the person who sent the order of the equipment.

When the person then sets the status to Delivered, the item will not be found the next day the workflow queries pending items.

[Khan321]

@EnricoKnapp Thanks for your reply. 🙂

Sounds Good.  Do you have any link which can help making above mentioned flow?

Best Regards

Naji

[SamLed · Accepted solution]

Hi @Khan321,

I've got a slightly different approach to deal with such customer feedback need. Here's how I do that :

• Build a solution
• Create a child flow which take concerned item ID as input
  • it will send an email with options (Yes, No) to requester (item creator)
  • On requester feedback, item status is updated
• Build a parent flow
  • It retrieve all items filtered by status
  • For each, it calls child flow sending it current item ID

My parent flow :

Note: my parent flow use manual trigger for testing purpose, but you can switch with a scheduled one running every days. Then filter items on status value and creation date where it equals creation date + 7 days.

My Child flow :

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

[Khan321]

@SamLed thanks for your replay and solution.  

I think it will help.  

thank you so much once again 🙂