cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cdmcali
Level: Powered On

Update Sharepoint List Item Through Email

Hello,

 

I have an interesting problem I am trying to solve. We have a help desk ticketing system that we use. I am creating a SharePoint list and setting up a flow that when an item is added to the list the flow will send an email to the ticketing system. In the email, it will have details of the list item. These items will be parsed by the ticketing system and fill in the ticket with the list item details. I would like to setup a way to email back some information from the ticketing system to a email box that flow would watch and then update the appropriate list item when the ticket is closed. 

 

I can pass over the list item ID to the ticket system and back through email. Just not sure how to parse the email to update the list item.

 

Any ideas?

4 REPLIES 4
Super User
Super User

Re: Update Sharepoint List Item Through Email

It sounds as though no one will actually be reading the emails sent from the ticketing system, so the emails need not be "pretty".

 

A simple suggestion might be to put nothing but the ID in the subject line (no need to parse anything).  When an email arrives, use the ID in the subject line with the Get Items action and an OData filter:

ID eq '[insert ID from subject line via Dynamic Porperties]'

 

That will allow you to retrive that particular list item.  You'll need to use a For Each loop but only 1 item will be returned (it will only loop once).

 

You might then update the ticket to closed and insert the email body into a multi-line text column.

 

If you want an example, please let me know.

 

If this solves you issue, please mark you post as Solved.

 

Scott

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
cdmcali
Level: Powered On

Re: Update Sharepoint List Item Through Email

Thank you!

 

An example would be great.

 

The email account would never be checked so we could make it as ugly as needed. I would like to be able to send an email to that account with the Item ID and have it update a column that would add the ticket number. Do you think that would be doable?

joshua_harris
Level: Power Up

Re: Update Sharepoint List Item Through Email

Hello,

 

I hope this emails finds you well! I am the Product Manager at MailParser, a cloud-based email parsing solution that has been in business since 2013. 

 

Our app works by extracting data locked inside of emails and sending that data somewhere else on the internet, like Microsoft Flow - your query here stuck out to me a bit as I thought our solution may be a good fit for you.

 

If interested in a streamlined email parsing solution to pass your email data to Sharepoint, I would recommend creating a 14-day free trial here and letting me know at support@mailparser.io where you get stuck getting set up 🙂

 

https://mailparser.io/

 

Best regards,

Joshua Harris

Jonas11
Level: Powered On

Re: Update Sharepoint List Item Through Email

Hi, 

 

I am currentely trying to do someting similar, and thought @ScottShearer idea seems brilliant. Did you provide an example Scott? Did you alternatively come up with a solution cdmcali

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,943)