Get items of a Array

(0) Share

Report

Posted on by Sven4

211

Hi everyone,

i would need some help with an array. I get an email whicht looks like this:

<html>

<head>
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>

<body>
 <div dir="ltr">
 <div id="gmail-:t0" class="gmail-Ar gmail-Au gmail-Ao">
 <div id="gmail-:sw" class="gmail-Am gmail-aiL gmail-Al editable gmail-LW-avf gmail-tS-tW gmail-tS-tY"
 aria-label="Inhalt der Nachricht" role="textbox" tabindex="1" style="direction:ltr; min-height:296px">
 <div
 style="border:0px; font-variant-numeric:inherit; font-variant-east-asian:inherit; font-variant-alternates:inherit; font-stretch:inherit; font-size:14px; line-height:inherit; font-family:Inter,sans-serif; font-kerning:inherit; font-feature-settings:inherit; margin:0px; padding:0px; vertical-align:baseline; color:rgb(33,35,44); background-color:rgb(255,246,214)">
 <strong
 style="border:0px; font-style:inherit; font-variant:inherit; font-stretch:inherit; font-size:inherit; line-height:inherit; font-family:inherit; font-kerning:inherit; font-feature-settings:inherit; margin:0px; padding:0px; vertical-align:baseline">Vorname</strong>:
 Kathleen</div>
 <div
 style="border:0px; font-variant-numeric:inherit; font-variant-east-asian:inherit; font-variant-alternates:inherit; font-stretch:inherit; font-size:14px; line-height:inherit; font-family:Inter,sans-serif; font-kerning:inherit; font-feature-settings:inherit; margin:0px; padding:0px; vertical-align:baseline; color:rgb(33,35,44); background-color:rgb(255,246,214)">
 <strong
 style="border:0px; font-style:inherit; font-variant:inherit; font-stretch:inherit; font-size:inherit; line-height:inherit; font-family:inherit; font-kerning:inherit; font-feature-settings:inherit; margin:0px; padding:0px; vertical-align:baseline">Nachname</strong>:
 Baier</div>

I was able to turn this in to an array which looks like this:

[
 "Vorname: Kathleen",
 "Nachname: Baier"
]

There are more data of curse. I need to put that data in a SharePoint table but i can't find a way to do so. I tried to transform that Array into a json object so i can use a function like variables('myObject')['Vorname'] but it didn't work.

Can anyone help me on that?

Thanks a lot.

Sven

Categories:

General topics

All responses (2)

Answers (1)

Sort by

Verified answer

Chriddle 8,729 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Compose (the HTML)

Spoiler (Highlight to read)
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> </head> <body> <div dir="ltr"> <div id="gmail-:t0" class="gmail-Ar gmail-Au gmail-Ao"> <div id="gmail-:sw" class="gmail-Am gmail-aiL gmail-Al editable gmail-LW-avf gmail-tS-tW gmail-tS-tY" aria-label="Inhalt der Nachricht" role="textbox" tabindex="1" style="direction:ltr; min-height:296px"> <div style="border:0px; font-variant-numeric:inherit; font-variant-east-asian:inherit; font-variant-alternates:inherit; font-stretch:inherit; font-size:14px; line-height:inherit; font-family:Inter,sans-serif; font-kerning:inherit; font-feature-settings:inherit; margin:0px; padding:0px; vertical-align:baseline; color:rgb(33,35,44); background-color:rgb(255,246,214)"> <strong style="border:0px; font-style:inherit; font-variant:inherit; font-stretch:inherit; font-size:inherit; line-height:inherit; font-family:inherit; font-kerning:inherit; font-feature-settings:inherit; margin:0px; padding:0px; vertical-align:baseline">Vorname</strong>: Kathleen </div> <div style="border:0px; font-variant-numeric:inherit; font-variant-east-asian:inherit; font-variant-alternates:inherit; font-stretch:inherit; font-size:14px; line-height:inherit; font-family:Inter,sans-serif; font-kerning:inherit; font-feature-settings:inherit; margin:0px; padding:0px; vertical-align:baseline; color:rgb(33,35,44); background-color:rgb(255,246,214)"> <strong style="border:0px; font-style:inherit; font-variant:inherit; font-stretch:inherit; font-size:inherit; line-height:inherit; font-family:inherit; font-kerning:inherit; font-feature-settings:inherit; margin:0px; padding:0px; vertical-align:baseline">Nachname</strong>: Baier </div> </div> </div> </div> </body> </html>
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> </head> <body> <div dir="ltr"> <div id="gmail-:t0" class="gmail-Ar gmail-Au gmail-Ao"> <div id="gmail-:sw" class="gmail-Am gmail-aiL gmail-Al editable gmail-LW-avf gmail-tS-tW gmail-tS-tY" aria-label="Inhalt der Nachricht" role="textbox" tabindex="1" style="direction:ltr; min-height:296px"> <div style="border:0px; font-variant-numeric:inherit; font-variant-east-asian:inherit; font-variant-alternates:inherit; font-stretch:inherit; font-size:14px; line-height:inherit; font-family:Inter,sans-serif; font-kerning:inherit; font-feature-settings:inherit; margin:0px; padding:0px; vertical-align:baseline; color:rgb(33,35,44); background-color:rgb(255,246,214)"> <strong style="border:0px; font-style:inherit; font-variant:inherit; font-stretch:inherit; font-size:inherit; line-height:inherit; font-family:inherit; font-kerning:inherit; font-feature-settings:inherit; margin:0px; padding:0px; vertical-align:baseline">Vorname</strong>: Kathleen </div> <div style="border:0px; font-variant-numeric:inherit; font-variant-east-asian:inherit; font-variant-alternates:inherit; font-stretch:inherit; font-size:14px; line-height:inherit; font-family:Inter,sans-serif; font-kerning:inherit; font-feature-settings:inherit; margin:0px; padding:0px; vertical-align:baseline; color:rgb(33,35,44); background-color:rgb(255,246,214)"> <strong style="border:0px; font-style:inherit; font-variant:inherit; font-stretch:inherit; font-size:inherit; line-height:inherit; font-family:inherit; font-kerning:inherit; font-feature-settings:inherit; margin:0px; padding:0px; vertical-align:baseline">Nachname</strong>: Baier </div> </div> </div> </div> </body> </html>

Compose 2 (XML from sanitized HTML)

xml( replace( outputs('Compose'), '<meta http-equiv="Content-Type" content="text/html; charset=utf-8">', '' ) )

Select (Grab values using xpath)

From

range(0, int(xpath(outputs('Compose_2'), 'count(/html/body/div/div/div/div)')))

Map (left)

trim(first(xpath(outputs('Compose_2'), concat('/html/body/div/div/div/div[', add(item(), 1), ']/strong/text()'))))

Map (right)

trim(replace(first(xpath(outputs('Compose_2'), concat('/html/body/div/div/div/div[', add(item(), 1), ']/text()'))), ':', ''))

Compose 3 (Convert array to object)

first(json(replace(string(body('Select')), '},{', ',')))
Sven4 211 on at

Like
a
(0)

Report
Copy link

Link copied!

@Chriddle thanks a lot for your answer. It worked perfectly fine.