cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate IV
Advocate IV

Hyperlinks inside share point rich text fields break when used in body of an email in flow

Hyperlinks from rich text field breaks as sharepoint urls are relative urls . Is there a solution for this ?

 

i am trying to read email body content from a sharepoint rich text field( Enhanced rich text field).

 

Thanks,

Sru

8 REPLIES 8
Community Support
Community Support

Hi @Sru,

 

Could you please share a screenshot of your flow's configuration?

Could you please share more details about your issue?

Further, could you please show a bit more about the rich text field that you mentioned? Is it the Multiple lines of text type column in your SharePoint list?

 

I have made a test on my side and don't have the issue that you mentioned. I have created a SharePoint list on my side and the data structure of it as below:4.JPG

Note: The HyperlinksFromRich column is a Multiple lines of text type column which enables Enhanced rich text option in my SharePoint list.

 

 

Please take a try with the following workaround:3.JPGWithin the "Send an email" action, the Is HTML field set to Yes.

 

When I input a hyperlink within the HyperlinksFromRich column in my SharePoint list, the flow works successfully as below:5.JPG

 

6.JPG

 

 

Best regards,

Kris

 

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

hi @v-xida-msft

 

can you please try to add a link pointing to a sharepoint site in the rich text column ?

 

Please find attached screen shots for the same.

add link via Link option to a sharepoint siteadd link via Link option to a sharepoint siterich text field with enhanced rich text optionrich text field with enhanced rich text optionflow configurationflow configuration

ipr4.PNGipr6.PNG

hi @v-xida-msftcan

 

can you please let me know if you are facing teh same issue or if you have a workaround for this?

 

Thanks,
Sru

hi @v-xida-msftcan

 

can you please let me know if you are facing teh same issue or if you have a workaround for this?

 

Thanks,
Sru

Administrator
Administrator

Hey, @Sru!

Thank you for posting on the Flow Community Forum! It appears as though @v-xida-msft would like some more information in order to further assist you properly with your issue. Please share any additional information that was requested in order to decrease the amount of time that it will take for you to be assisted!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager
Power Platform Communities

hi @GabrielStJohn,

 

I shared the screen shots and flow configurations in the same thread. after which i have not got any update.

Let me know if you need any additional info.

 

Thanks,

Sru

@GabrielStJohn Your guy got the info he needed from @Sru . His initial response showed that he didn't understand the issue and did not end with him asking for any more information. There's a difference between a hyperlink and a url. A hyperlink is a URL that is clickable and displays alternate text.

 

The problem is that the enhanced rich text column in SharePoint is taking URLs that are entered, even the ones with the FULL URL included, for example: https://tenant.sharepoint.com/teams/site/subsite/page.aspx and turning them to /teams/site/subsite/page.aspx. If you click something with that second one as a target URL from *inside* sharepoint it works fine, but if you use that enhanced rich text column containing the formatted hyperlink as the body of an email, it seems there is no way to STOP it from stripping out the first part of the URL, so what you end up with is an email that is telling people to click a link that points to an invalid url. The fact that the original poster is using Flow isn't the issue. The issue is with the way SharePoint is messing with url's entered into an enhanced rich text column.

 

I've been looking around online for a while now today to try to find a way to get around this, and aside from just putting the full url right there in the email (ugly) or using tinyurl or bit.ly to get an alternate url (can make users think it is a suspicious url and means the url is stored on a third party service) I am coming up with *nothing*. I've got an entire list of custom email dates like this that I only recently discovered has this issue.

Regular Visitor

Hi @Sru,

 

I had a similar requirement, I used the replace function in power automate, just use it in the place where you are placing your emailContentField.

 

replace(emailContentField,'/sites','https://contoso.sharepoint.com/sites')

 

Thanks,

Hitesh Nagpal

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (3,686)