Power Platform Community Forum Thread Details

Hello Everyone,

I have a PowerApps which pushes data into a SharePoint list. This SharePoint list has multiple columns from Plain text, Multiple line rich text, Multiselect dropdown, single select dropdown, etc. which stores each entry row wise. There is an option in PowerApps to sent this SharePoint list data to their email based on filter parameters selected in PowerApps.

The PowerAutomate structure is:

PowerApps trigger > Get items (based on Odata received from PowerApps) > Select action > Create HTML Table (output select action) > Clean HTML (input Create HTML table) > Compose HTML Style > Send email V2 (insert Compose HTML Style + Clean HTML output)

Clean HTML expression is

replace(replace(replace(replace(replace(body('Create_HTML_table'), '&lt;', '<'), '&gt;', '>'), '&amp;', '&'), '&#39;', '"'), '&quot;','"')

All the values appear properly in the HTML table output, except the organization based SharePoint folder document embedded hyperlinks or OneDrive document hyperlinks embedded in the Rich text column in SharePoint list. External file hyperlinks in the same HTML column seem to be clickable and appear properly in the HTML Outlook email.

SharePoint HTML column details

Sample column text received in Outlook

Clicking the hyperlink displays following message. As you can see the internal SharePoint/OneDrive organization based hyperlinks starts with \:f\:r\ and also some of the later hyperlink text gets auto truncated.