Sharepoint list characters limit

[bireta]

Hey guys

I have already checked some different topics but couldnt find any solution

I need to transfer an added item (attachment) from MS Forms to Sharepoint List.

Column set to Hyperlink gives me an error. Column set to text gives me an information about characters limit = 255.

The full line with name of the attachment, hyperlink etc has to be 400-600 characters.

What could I do to extend the limit or to take it down completly? Is there any json based trick/code that could shorten the hyperlink automatically for every attachment added while filling the Forms?

That limit does not fit my needs at all. I need a quick and easy workaround for all the links/files there, which are transfered from Form to SP by the Flow, just like that;

Thanks

Pawel

[Paulie78]

As easy way is to make a short link with bit.ly and use that instead, super easy to do from within the flow.

[bireta]

But everytime someone adds a new file to the Form the link is different. How am I able to make it fully automatic to cut every OneDrive hyperlink (to where these files were added) so the same link is shown in the Sharepoint List later via Flow?

[krootz · Accepted solution]

how using about a multi-line?

[bireta]

I have tried but it still says that the limit of 255 characters was reached. I can't change the character limitation, just how many rows of multi-line text I want to have. And it doesnt matter if i put 6 od 1000, it still ends with the same error

[bireta]

EDIT:

I was wondering how is it possible to have that many rows of multi-line text and looked over it again. I changed it to multi-line to make sure its set correctly, then I deleted the attachment/file/hyperlink TAG in Flow, added it again on the specific row for this targed and somehow it now understands the multi-line change i've made!

Now it works like a charm, the flow goes straight to the finish. THANKS!

[Marktke]

HI,i am having the exact same issue but dont understand your solution and wondering if you would be willing to help? Simply editing the column to multitext didnt change anything but scared of breaking my working flow!