0

I have a question and want to know if we can achieve this by SharePoint & flow. The scenario is, I have created a simple SharePoint list with a choice column (In-Progress and Completed). When I change the status to completed, the users will receive an email that your request has been completed. I was wondering, is there a way if the user replies to the email and status changes to in-progress again?

Kind Regards

0

If you just use the send email action, there is no such way to accept the reply.

As a workaround, use the send email with options action as shown below:

enter image description here

Email recipient needs to reply the email to accomplish the flow, if they need further changes, the related list column will be updated to "In-Progress".

enter image description here

----------------------------------Update--------------------------------

Create a new YES/NO column named "ModifiedByFlow", then click settings of the trigger:

enter image description here

Then use the expression @equals(triggerOutputs()?['body/ModifiedByFlow'], false) to add a trigger condition: enter image description here

Later, remember to set it as Yes when you update item in flow:

enter image description here

In this way, if the "ModifiedByFlow" is Yes, the flow trigger will not work.

2
  • Hi Julie, this is a great option. However, I need the email to be sent out when the status changes to Completed. The issue I have now is that I have another field called comments that can be updated at any time, even after the status is completed. So the trigger is when an item or a file is modified. In this case, when they update the comments filed, the WF will trigger again. What's your thought on this? How can we fix this?
    – Harris
    Nov 25 at 2:06
  • Please check the updated reply.
    – Julie_MSFT
    Nov 25 at 9:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.