Hello wonderful community of helpful people,
Hoping you can help with an intermittent issue i'm having regarding the URL.
Please see flow below
Error message - "Invalid URL value.
A URL field contains invalid data. Please check the value and try again.
clientRequestId: 449d2f9c-4e3d-4550-900f-018d295f7437
serviceRequestId: 449d2f9c-4e3d-4550-900f-018d295f7437"
This error message comes up in other flows I have as well but only for certain folders - I wonder if its because the URL is too long? Is there a way of by-passing this?
https://XXXXXXXXXXXX.sharepoint.com/sites/XXXXXXXXXX/Documents/Forms/AllItems.aspx?useFiltersInViewXml=1&isAscending=true&id=%2Fsites%2FXXXXXXXXXX%2FDocuments%2FXXXXXXX%2F2021%2F111%20%2D%20test&sortField=LinkFilename&viewid=dc323592%2Db8a8%2D4761%2D99b8%XXXXXXXXXXXXXXX - this is an example of a link that breaks it (I added the X's for anonymity)
For context this is what the flow is supposed to do - 'For a selected file' - change the column value - 'update file properties'
Your solution is a bombshell, thanks Oliver01 !
Hi Kate,
I haven't personally used library, so I cannot say if that's the case.
This method is more like a work-around to the character limitation of using a hyperlink column. You are not going to create a URL column, you will need to create a multiple lines of text column for the field you want to store your URLs. (Make sure it is multiple lines of text, because single line of text has the same character limitation as the hyperlink field)
The detailed setting for that multiple lines of text looks like the following:
Choose "Plain text", and in the Column formatting box paste in the JSON code:
{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "a", "txtContent": "=if(@currentField, 'Link to Folder', '')", "attributes": { "target": "_blank", "href": "@currentField" } }
Once you save the settings, whatever URL you paste into the cell should automatically turn into a Hyperlink once you hit enter and save the cell.
Let me know if that helps!
Best,
Oliver
Hi Oliver01, Thank you for replying to this, I had given up hope of an answer! My apologies, but would you mind explaining this a bit more? I knew it was to do with the length of the URL which i agree shouldn't be limited (very annoying intermittent error) - I have just been living with the occasional failed flow.
I have tried doing as suggested and looked at the link provided but I'm not sure what I'm looking for as there is no URL Column listed? Help would be very appreciated - this may be because its a library rather than list?
Thank you
Kate
Credit: https://sharepoint.stackexchange.com/questions/288082/how-to-convert-text-to-url-in-multi-line-text
3. You can input the URL from Form as normal to that field in Power Automate.
Hope this helps!
The issue usually occurs when the URL has more than 255 characters. Very annoying limit. Took me forever to figure out a way around it. So here is what you can do:
1. Instead of using the Hyperlink field, use multiple lines of text field.
2. Go edit your column, and in format column with JSON field, paste in the following code:
{
Thank you, I will try this. 🙂
I may have a fix to this but works with some projects and not with other - but thought it worth posting in case it helps you @stacyjpelletier .
For the URL field that requires filling I use an ETag instead see photo below. You first need to use 'Get File Properties' and then select the ETag from that. I hope this helps you 🙂
I am having a similar problem and posted about it today. I hope we get an answer 🙂
WarrenBelz
146,786
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,093
Most Valuable Professional