Unanswered

Parse Incoming Emails into sharepoint list

(0) Share

Report

Posted on by AlmogM

Hi,

I'm getting an email (example below) as a table and I want to create a flow that takes all the values from the email and create a new item on SharePoint list

traying to understand what is the relevant code I should use for it - what is the Tab delimiter in a table.

Below is the flow I have created for it, not sure how to use split for this table

split(outputs('Html_to_text')?['body']).............????????

Thanks

Almog

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

AlmogM 60 on at

Like (0)

Report
Copy link

Link copied!

Not sure I understands what needs to be fill when selecting Encodian- parse HTML table - how it knows what value to insert to what field on the SharePoint list

let me know if there other easy way for doing that
Thanks
Almog

Was this reply helpful? Yes No
AlmogM 60 on at

Like (0)

Report
Copy link

Link copied!

Is there other option to get this done without the trail version for limited time?
other way to parse a data table from an email to create an SP item acc the relevant fields/values??(what about the split option)?

Was this reply helpful? Yes No
AlexEncodian 4,409 Moderator on at

Like (0)

Report
Copy link

Link copied!

@AlmogM

Look at the output of the HTML to text conversion. That will tell you what native expressions you need to use to parse the values that you need.

Was this reply helpful? Yes No
AlmogM 60 on at

Like (0)

Report
Copy link

Link copied!

OK, so I got progress with it . I have success to insert the values into the share point list using below expression - outputs('compose')[1]

but all come into the 1st column(see below)

What I need to add for the expression that it will give me each time the value I need in the right column

Thanks
Almog

Was this reply helpful? Yes No
AlmogM 60 on at

Like (0)

Report
Copy link

Link copied!

@AlexEncodian can you help with my question as there is a progress to get the relevant data into SharePoint list?
Thanks
Almog

Was this reply helpful? Yes No
AlmogM 60 on at

Like (0)

Report
Copy link

Link copied!

Thanks , the data that I'm getting after the Html to text is below
Delimiter is ENTER

Do I need to have compose after this one or I can directly put on the SharePoint fields a split formula?

Was this reply helpful? Yes No