Solved

"Edit" URL - SharePoint Online Library

  • 9 March 2023
  • 4 replies
  • 149 views

Userlevel 4
Badge +14

"Edit" URL - SharePoint Online Library

How in the world do we pass the edit URL through a workflow for users to open files and edit as if they were opening it from a library? The only URL available in NAC is the item URL which just allows user to download the file. Not open the source file.

icon

Best answer by brandiwoodson 9 March 2023, 05:40

View original

4 replies

Userlevel 4
Badge +14

After much time spent on this, I did the following steps to make it work as intended. I nixed the concept of using a SPO list hyperlink field. 

 

  1. I created a text string. Used Item URL from start event and then added ?web=1 to the end of it.
  2. Created a single line of text in SPO list.
  3. Formatting single line of text with the below JSON code.
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "a",
"attributes": {
"href": "@currentField",
"target": "_blank"
},
"txtContent": "Open or Edit Doc"
}


 

Userlevel 4
Badge +14

I should have added in my initial post, passing the EDIT URL is fine in tasks. I needed something for a hyperlink field in SPO list passing through a NAC workflow. It’s probably nothing on Nintex’s side, appears to be an issue with SPO and how it writes strings to hyperlink field. It kept breaking. 

Either way, would be nice to have the link for editing opposed to having to create a string to open a doc in edit mode. 

Userlevel 3
Badge +8

Hi, you can also try saving the link in a multiple lines of text column with rich text/enhanced rich text enabled.

Userlevel 4
Badge +14

Hi, you can also try saving the link in a multiple lines of text column with rich text/enhanced rich text enabled.

Yes, that's true. I did end up switching to a ML text field in case URL was too long. I will do that next time and use the a href html tag to shorten it by using instructions or the file name. I think its nice having it say open or edit doc or the file name instead of just the URL.

 

Thanks so much. 

Reply