Create HTML Table from Delimited String

[mboonie]

Hi. I am having a great deal of difficulty just trying to create an HTML table from a string (read from a file) that I'm "split-ting" into an array.

Here's the story: I have a delimited string (a run-on, bulleted list) that I read from a text file. I use the Split() function to create an array from it, splitting at the bullets. (The output is formatted as '["item 1","Item 2","Item 3", etc...]', which is obviously not in strict JSON dictionary format.)

Now I want to generate an HTML table using the Create HTML Table action, which ostensibly takes an array as its input. Lucky me, the Split() function purports to generate an array! However, if I use the output from the Split() function as the INPUT for the Create HTML Table action, Flow fails and tells me I must specify the Column parameter, which is required because (apparently) my Split() output is not seen as an array. (???????) The kicker, of course, is that there are no column names to reference when you split a string into an array, or at least none that I'm aware of. So I took a stab at transforming the array it by wrapping it in the JSON() function, but I get an error for THAT action, because the function requires a string, and it considers the output from the Split() to be an array!

Any ideas on how to REALLY go from a delimited string to a simple single-column HTML table with one row for each delimited item? 

Thanks in advance!!

[v-yuazh-msft]

Hi @mboonie,

I have made a test on my side and your issue is confirmed on my side.

I afraid that there is no any way to achieve your requirement to go from a delimited string to a simple single-column HTML table with one row for each delimited item in microsoft flow currently.

Best regards,

Alice

[mboonie]

Ah, well, here is the workaround:

I ended up looping through my "Next Critical Steps" array variable; using a Compose action to create a bit of JSON (the Concat adds a bullet to each element in the string array, i.e. 'concat('• ',item())'); and then appending the "composed" output to a "Create HTML Table"-compatible array.

I used my array variable to create an actual JSON array, which worked for the HTML Table