cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper V
Helper V

Update SharePoint Item based on Email Response

Intended Outcome:

User submits a new SharePoint item with a specific Request Type, from a choice of options. Based on the type, an email is kicked off via Flow and sent to a person or multiple people. Different people “own” different request types. The “owner” gets an email with the options of “Acknowledge” and “Send for Triage”. Once an option is selected via the email, the SharePoint item gets updated via Flow from Submitted to Acknowledged or Send for Triage.

 

Issue:

I cannot figure out how to dynamically set the Status to reflect what option (Acknowledged, Send for Triage) is chosen in the email. I have to choose one or the other.

 

Flow1.png

flow2.png

flow3.png

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support
Community Support

 

Hi @kriggo15 ,

 

Please click on Enter custom value and populate the SelectedOption in this field.

65.PNG

Hope it helps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

 

Hi @kriggo15 ,

 

Flow does not fail to execute but does not satisfy the conditions you set in Condition, so Flow is Cancelled.

You could check the value of the Status field in the Body of the Flow run history-Update item action, whether it is consistent with your expectations.

 

The Status values you mentioned earlier are "Submitted (default), Acknowledged, Needs Triage, Triaged". It seems that there is no Send for Triage. Have you made any changes?

If there have been changes, I suspect that the actual status value may contain extra characters such as space.

If so, you could refer to the method contained in this similar thread to solve this problem:

https://powerusers.microsoft.com/t5/Building-Flows/Build-Flow-Based-on-Dropdown-list/td-p/371979

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Community Support
Community Support

 

Hi @kriggo15 ,

 

Please click on Enter custom value and populate the SelectedOption in this field.

65.PNG

Hope it helps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

That didn't do it for me. Right now, the Status column has the option for the following values: Submitted (default), Acknowledged, Needs Triage, Triaged. In the email I'm providing 2 options: Acknowledge and Send for Triage.

 

Is it not working because the choices don't match?

I was actually able to fix the problem, but it led to a new one... If the status gets set to "Send for Triage", I want that to kick off an email to someone to look at. I can see the update in SharePoint where the status is updated, but it fails when trying to send the email.

 

flow4.png

flow5.png

 

Hi @kriggo15 ,

 

Flow does not fail to execute but does not satisfy the conditions you set in Condition, so Flow is Cancelled.

You could check the value of the Status field in the Body of the Flow run history-Update item action, whether it is consistent with your expectations.

 

The Status values you mentioned earlier are "Submitted (default), Acknowledged, Needs Triage, Triaged". It seems that there is no Send for Triage. Have you made any changes?

If there have been changes, I suspect that the actual status value may contain extra characters such as space.

If so, you could refer to the method contained in this similar thread to solve this problem:

https://powerusers.microsoft.com/t5/Building-Flows/Build-Flow-Based-on-Dropdown-list/td-p/371979

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (7,901)