Answered

Help with replace and HTML in create table

(0) Share

Report

Posted on by AJPowerfulBI

Hey Community,

I have a flow that I am building and in it I am creating an array and converting that into a HTML Table to send via email.

For context the Array looks something like this:

[

{

"Col1":"I am a test column",
"Col2":"I am another test columns",
"Col3":"<strong>Hello World</strong><br>Test Value:<strong><br>Result Value:</strong>"

{

"Col1":"I am a test column",
"Col2":"I am another test columns",
"Col3":"<strong>Hello World</strong><br>Test Value:<strong><br>Result Value:</strong>"

{

"Col1":"I am a test column",
"Col2":"I am another test columns",
"Col3":"<strong>Hello World</strong><br>Test Value:<strong><br>Result Value:</strong>"

}

]

the HTML table that comes out via email ends up looking something like this:

Col1	Col2	Col3
I am a test column	I am another test columns	<strong>Hello World</strong><br>Test Value:<strong><br>Result Value:</strong>
I am a test column	I am another test columns	<strong>Hello World</strong><br>Test Value:<strong><br>Result Value:</strong>
I am a test column	I am another test columns	<strong>Hello World</strong><br>Test Value:<strong><br>Result Value:</strong>

I wanted it to output like this:

Col1	Col2	Col3
I am a test column	I am another test columns	Hello World Test Value: Result Value:
I am a test column	I am another test columns	Hello World Test Value: Result Value:
I am a test column	I am another test columns	Hello World Test Value: Result Value:

It outputs the HTML as plain text. I am assuming I need to do some magic with the replace function to get the desired result but I have tried a few options and am hitting a wall.

Please can someone help with this

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Expiscornovus 32,916 Most Valuable Professional on at

Like (2)

Report
Re: Help with replace and HTML in create table

Hi @AJPowerfulBI,

Is by any chance the body of your e-mail showing characters like <? It is very likely that the < less than character and other HTML characters are rendered with their entity name.

Try an expression like below to avoid this.

replace(replace(replace(body('Create_HTML_table'),'<','<'),'"','"'),'>','>')

Was this reply helpful? Yes No
AJPowerfulBI 7 on at

Like (1)

Report

Re: Help with replace and HTML in create table

Wow thanks for lending a hand 🙂 this was very helpful. This was 100% the solution to what was happening. I applied the same logic to the email and other areas and it fixed everything 🙂 .

thanks again 😄

Was this reply helpful? Yes No
perlite77 2 on at

Like (0)

Report

Re: Help with replace and HTML in create table

Hello Dennis,
Hope you are well.
I am developing a Power Automate Flow that is fetching documents from SharePoint document library and returning results to Copilot Studio in a table format as below. I am using three parameters in flow 1. Title, 2. Product Category and 3. Document Type (e.g. SOP or a Form etc.).
Below table works fine if I have only one parameter e.g. Title.
Complete Flow

Now when I included two parameters e.g. "Title" and "document type" then I received error: Unable to process template language expressions in action 'Return_value(s)_to_Power_Virtual_Agents' inputs at line '0' and column '0': 'The template language function 'replace' expects its first parameter 'string' to be a string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#replace for usage details.'.

I used following code in last step of Flow, i.e Return Values to PVA.
replace(replace(replace(replace(replace(replace(replace(body('Create_HTML_table'), '<table><thead><tr><th>', '| '), '</th></tr></thead><tbody>', concat(' |',decodeUriComponent('%0A%0D'),'|-----------|:-----------:|',decodeUriComponent('%0A%0D'))), '</th><th>', ' | '), '<tr><td>', '| '), '</td><td>', ' | '), '</td></tr>', concat(' |',decodeUriComponent('%0A%0D'))), '</tbody></table>', '')
Could you help with a correction to below for more than one parameter in user question so that results can be communicated to user as a table in Copilot Studio bot.
Many thanks.
replace(replace(replace(replace(replace(replace(replace(body('Create_HTML_table'), '<table><thead><tr><th>', '| '), '</th></tr></thead><tbody>', concat(' |',decodeUriComponent('%0A%0D'),'|-----------|:-----------:|',decodeUriComponent('%0A%0D'))), '</th><th>', ' | '), '<tr><td>', '| '), '</td><td>', ' | '), '</td></tr>', concat(' |',decodeUriComponent('%0A%0D'))), '</tbody></table>', '')

Was this reply helpful? Yes No