Unable to extract Data where sharepoint has multiline statement

Hi AnshumanPatnaik ,

It appears you're facing a common issue when extracting multi-line text from SharePoint. The problem is that SharePoint wraps each line of a "Multiple lines of text" field in hidden HTML <div> tags when you press "Enter." Your function is likely pulling this raw HTML and only reading the content of the first tag, which is why single-line entries work correctly while multi-line entries do not. To fix this, you need to handle the HTML formatting.

If you are working within Power Automate, the solution is to convert the HTML to plain text. After your "Get item" or "Get items" action, you should add the Html to Text action. The dynamic content from your SharePoint multi-line column should be placed into the Content field of this action. Then, in any following steps, you can use the plain text output from the "Html to Text" action, which will have proper line breaks.

1. Trigger: When an item is created or modified
2. Action: Get item from SharePoint
3. Action: Html to Text (Input: YourMultiLineColumn)
4. Action: Post a message (Input: Plain text output from step 3)

For those using Power Apps, you have a couple of options. The most direct method is to use an HTML Text control instead of a standard Text Label. You would set the HtmlText property of this control to your SharePoint data, like ThisItem.'YourMultiLineColumnName', and it will render the text with the line breaks intact. Alternatively, if you must use a standard Label, you can convert the HTML to plain text by setting the label's Text property to use the PlainText() function.

PlainText(ThisItem.'YourMultiLineColumnName')

When using this function, it is important to also set the label's AutoHeight property to true so it can expand to display all the lines of text.

The underlying reason for this behavior is how SharePoint stores the data. When you input text with a line break, such as "Development is complete" on one line and "Project is now in SIT phase." on the next, SharePoint saves it as HTML code.

<div>Development is complete</div><div>Project is now in SIT phase.</div>

The methods described above correctly parse this HTML, ensuring all your text is extracted and displayed as intended.

Best regards,