Answered

Convert Sharepoint Delimited String in to HTML Table

(0) Share

Report

Posted on by KW-07042023-0

I have a sharepoint list that has some pipe delimited data stored in a Text column. I am trying to extract the data and generate a table with one row for each delimited item. I am really struggling to get anywhere with this. I have tried several approaches and keep getting errors. I can't really include my current flow because I don't have anything that has come close to working.

So for this example, I am looking for a table like the one below.

I'd like to generate an email with an html table with 6 rows. The table could also be in the form of an attached csv file.

Compound	Requestor
cp1	Whalen, Kevin M
cp2	Whalen, Kevin M
cp3	Whalen, Kevin M
cp4	Whalen, Kevin M
cp5	Whalen, Kevin M
cp6	Whalen, Kevin M

Any help/suggestions are appreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

DEdFishe 9 on at

Like (2)

Report
Copy link

Link copied!
The following approach should work.

Initialize an empty array of objects variable

Create an apply to each to iterate through each SharePoint record and do the following in this scope:

In a compose action, call the split function to split the current item's Compound field on the '|' character

Use another compose action to capture the current SharePoint record's requestor for ease of use (ex item()?['Requestor'])

Create a nested apply to each to iterate through the output of the previous compose and do the following in this scope:

Compose a JSON object formatted as { "Compound": item, "Requestor": requestor_compose_output }

Append the output of this compose to your array of objects variable

Create an HTML table based off your array of objects variable

Hope this helps!

Was this reply helpful? Yes No
KW-07042023-0 4 on at

Like (1)

Report
Copy link

Link copied!

Thank you so much.....it took me a bit to figure out some details but I got it to work with your instructions!

Was this reply helpful? Yes No
Chriddle 8,689 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
With just a select and a little XPath, you can convert your input into a normal list that you can then filter:

From:

split( join( xpath( xml(json(concat('{"Root": {"Item": ', outputs('Compose'), '}}'))), concat('//Item/Compound/text()') ), '|' ), '|' )

Compound:

item()

Requestor:

first( xpath( xml(json(concat('{"Root": {"Item": ', outputs('Compose'), '}}'))), concat( '//Item[', './Compound="', item(), '" ', 'or contains(./Compound, "|', item(), '|") ', 'or starts-with(./Compound, "', item(), '|") ', 'or substring(./Compound, string-length(./Compound) - string-length("|', item(), '") + 1) = "|', item(), '"', ']/Requestor/text()' ) ) )

Was this reply helpful? Yes No