cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vMagnifica
Regular Visitor

Parsing data from an email

Hello,

 

i want to extract fields from a incoming email body, that looks like the following and add the values to a SharePoint List

 

<tr>
    <td>Herr</td>
    <td>Test Test</td>

</tr>
<tr>
    <td></td>
    <td></td>
</tr>
<tr>
    <td>Anschrift:</td>
    <td>Test 12, 22541 Test</td>
</tr>
<tr>
    <td>E-Mail: </td>
    <td>tes@email.de</td>
</tr>
<tr>
    <td>Telefon: </td>
    <td>12312345678</td>
</tr>
<tr>
    <td>Geburtstag:</td>
    <td>01.01.2002</td>
</tr>
<tr>
    <td>Zahlungsintervall:</td>
    <td>monatlich</td>
</tr>
<tr>
    <td>Betrag:</td>
    <td>8</td>
</tr>
<tr>
    <td>Kontoinhaber:</td>
    <td>Test Test</td>
</tr>
<tr>
    <td>IBAN:</td>
    <td>DE123456789123</td>
</tr>
<tr>
    <td>BIC:</td>
    <td>HASPDDTEYT</td>
</tr>

 

 How can I save every 2nd td value into a variable that i can then create a new SP List item with?

 

Thank you!

 

0 REPLIES 0

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Users online (2,415)