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!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,931)