Answered

Assistance with Email Parsing and SharePoint List Updating

(0) Share

Report

Posted on by MK-04030856-0

Hi all,

In the example below, i want to take the values below 1 and 2, and store them in different columns of a SharePoint list.

For the text extraction, the emails will have structured text where the line i need always starts with a bulletpoint.

It would be best to split the lines at every dash that's surrounded by spaces, and skip the line with bulletpoint when no such dash is found in it.

2023-11-08 07_45_26-_Naamloos - Kladblok.png

Later, when the e-mail gets categorised (E.g. Marked as Yellow or Green), I want a specific 'choices column' in the SharePoint list to update.

Could anyone provide advice on how to set this up?

Thank you in advance for your help!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

grantjenkins 11,063 Moderator on at

Like (2)

Report
Copy link

Link copied!
This will hopefully get what you need with regards to extracting out the ID and Description.

See full flow below. I'll go into each of the actions.

When a new email arrives will trigger when we receive a new email.

Html to text converts the body of the email to text.

Filter array splits the data by new line, then removes any rows that don't begin with an asterixis *

//From split(outputs('Html_to_text')?['body'], decodeUriComponent('%0A')) //Filter trim(item())

Select uses the output from Filter array and uses the following expressions.

//ID trim(split(item(), ' - ')[1]) //Description trim(split(item(), ' - ')[2])

Apply to each uses the output from the Select.

Create item uses the following expressions to add the data to the SharePoint List.

//Title item()?['ID'] //Description item()?['Description']

After running the flow we would have new items added to our list.

Was this reply helpful? Yes No
MK-04030856-0 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much! This works perfectly.

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @grantjenkins

Just for learning purpose, why have you filter the result with asterisk? Is it for filtering bulleted points in the email text?

Thanks & Regards,

Manish Solanki

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!

Correct - the bullet points were coming into the flow as an asterisk so used that in the filter.

Was this reply helpful? Yes No
shirokun on at

Like (0)

Report
Copy link

Link copied!

Thank you this is helpful! I have figured out how to create an item but i have trouble updating the item on sharepoint. could you explain how i can parse and update the item thats already on sharepoint list? thank you!

Was this reply helpful? Yes No