Answered

Different Column Output in SharepointList as Compared to the source

(0) Share

Report

Posted on by rohchsita21

I have created a power automated flow that takes queries as source from ADO and takes that data into a SharePoint list.
For one column the data in ADO is:

and the output that I get in my SharePoint list is:

I am not so sure why that is happening. This is the very first time I am facing this issue.
The column type in my SharePoint list is "Multiple Lines" for that column.
I am unsure why this is happening.
My power automate workflow is as follows:

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Expiscornovus 32,856 Most Valuable Professional on at

Like (1)

Report

Re: Different Column Output in SharepointList as Compared to the source

Hi @rohchsita21,

Those look like <div> and <span> html tags. You could use the HTML to text action to convert this html which you are getting from the ADO work item to text, if you only want to use plain text in your SharePoint list item?

Was this reply helpful? Yes No
rohchsita21 33 on at

Like (0)

Report

Re: Different Column Output in SharepointList as Compared to the source

Yes, I only want the text in my SharePoint list. But I don't know why I am getting HTML tags as output in my SharePoint list.
If you see in my source data we don't have any HTML tags.
those HTML tags are coming once i run the flow and hence you could see the HTML tags along with the text.
All i want is plain text as mentioned in the screenshot.

Was this reply helpful? Yes No
rohchsita21 33 on at

Like (0)

Report

Re: Different Column Output in SharepointList as Compared to the source

I have currently used content conversion (HTML to text) to convert the HTML tags into normal text. It works fine and i am getting my required results.
Using the following to achieve it:

use compose to pass the column which has html tags present for the data and then use content conversion (html to text) and pass the declared compose component.

Was this reply helpful? Yes No
Expiscornovus 32,856 Most Valuable Professional on at

Like (0)

Report

Re: Different Column Output in SharepointList as Compared to the source

Hi @rohchsita21,

The text in your screenshot has a certain font size and font colour, it probably is not noticeable because it might be pretty similar to normal plain text 😁

The HTML could be accidently added when somebody for example copy/pasted that description from a different application into that field.

Was this reply helpful? Yes No