Answered

Multiple lines of Text font differs for each column

(1) Share

Report

Posted on by Poweruser32490

I have a around 10 Multiple of text - Enhanced rich text column in SharePoint, which renders differently on Powerapps font wise.

May i know why this happens and how to standardize this on the Powerapps side?

I noticed on the SharePoint side, some columns have different font family. I updated the font family on SharePoint for all 10 columns but still the issue exists on PowerApps side.

I understood that when we copy a paragraph from somewhere and put it in multiple lines of text, it renders in a different font. When we manually type in the paragraph in multiple lines of text, it renders in a different font. May i know how to resolve this?

Categories:

AI Builder

GCC, GCCH, DoD - Federal App Makers (FAM)

Microsoft Dataverse with Power Apps

Connector development

Building Power Apps

Error handling

Experimental features

Power Apps Pro Dev & ISV

Governance & administering

Power Query

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

MS.Ragavendar 6,409 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Poweruser32490,

I could see the similar post in the past (few days back) check for the solution.

If the field is connected to a text column in Sharepoint make sure the Sharepoint column is set to Plain Text, not Rich Text.

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Poweruser32490 52 on at

Like (0)

Report
Copy link

Link copied!

It cannot be plain text. I have formatting applied to the column value which should reflect in powerapps as well.

Was this reply helpful? Yes No
Verified answer

11manish 987 on at

Like (1)

Report
Copy link

Link copied!
SharePoint rich text stores data as HTML, not plain text
When users:

Copy-paste content → it brings external font styles (Calibri, Arial, etc.)

Type manually → uses default SharePoint/editor font

These styles are saved like:

<span style="font-family:Calibri;">Text</span>

Power Apps renders HTML as-is, so different records show different fonts

Fix by cleaning HTML or overriding font in Power Apps

Use Substitute() or regex-like cleanup to remove font styles

Use Power Automate or form logic to:

Strip unwanted HTML

Store clean/standardized content

Avoid copy-paste from Word/Outlook

Encourage:

Plain text paste (Ctrl + Shift + V)

Was this reply helpful? Yes No