Adding link to Rich Text Editor

(0) Share

Report

Posted on by Setayesh2

105

Hi,

I have a SharePoint list with about 600 items. this list has a column with the type 'multiple lines of text' and rich-text enabled. users used it to insert a link to the record. Now I tried to create a customized form with powerapps. but those links are not opened through that form. links still working if we click on the SharePoint list view, but not when we open the form.

anyone can advise?

Regards

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Setayesh2 ,

Would you like to add hyperlinks in Power Apps and allow users open the link via clicking in a ViewForm?

If so, and if you are using SharePoint share links with https protocol, Power Apps would automatically modify the URL to "us.create.create.powerapps.com/.....", then you will be unable to open it. When pasting the URL of share links, users need to select http:// protocol instead:

However, you could not force any user focus on the protocol before saving the Form, so it is difficult to avoid generating wrong URLs. As a work around, you could use a hyperlink type column in SharePoint list, in Power Apps Edit Form change the control type of the Data Card to Edit URL and View Form control type to View URL:

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Setayesh2 105 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @v-jefferni
But my problem is how to transfer those links to the new hyperlink column. Any Idea?

Was this reply helpful? Yes No
Setayesh2 105 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni
I could move the link to the new hyperlink column but it shows as URL. users should copy and paste the URL. its not clickable. How I can fix it?

Regards

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Setayesh2 ,

You could use Power Apps to transport Rich Texts in the Text column to Hyperlink column directly:
1\ Add a Gallery with Items set to the SP list.

2\ Add a button in Power Apps, set OnSelect of it to:
ForAll(Gallery.AllItems As A, Patch(SPlist,LookUp(SPlist,ID = A.ID),{HyperlinkColumnName:Match(Substitute(A.TextColumnName,":",":"),"https.*?(?=<)").FullMatch}))

3\ Click the button once and waiting for all records be updated.

4\ Check SP list if Hyperlinks updated successfully. If true, remove the Patch button.

4\ In the ViewForm, set the layout of Hyperlink column Data Card to View URL.

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No