Unable to copy web URL alternative text from sharepoint list of one sharepoint site to sharepoint list of another sharepoint site

[Anonymous]

Hi I have a sharepointlist in one of my sharepoint site, I am copying the data from it to my another sharepoint list located on another site.

On my primary sharepoint list from where I am copying the data , there is a column named as CDE which stores both hyperlink and alternative text for that link when user makes entry. On the primary site its displaying the alternative text in the CDE column and when I will click on that alternative text its taking me to the URL that I have stored with that text. For example see below photo-

I have created a flow in power automate to copy this column but when I am copying it to my secondary sharepoint list stored in another sharepoint site its just copying the web URL link of the text and not copying the alternative text at all. For Example as shown in below picture-

I want to copy this CDE column exactly like the original sharepoint list and if not possible then text and URL seprately but I want to copy alternative text as well.

I have tried everything but not able to figure out anything for this. Kindly help me with this issue as I am very new into power automate. It will be really helpful.

[annajhaveri]

@Anonymous  in order to update value of hyperlink column in SharePoint list with text and url, you need to use REST API with Send HTTP Request to SharePoint action.

Refer to this blog https://www.annajhaveri.com/power-automate/rest-api-to-create-and-update-sharepoint-list-items-from-power-automate/ it has details on how to provide value for hyperlink column in REST API. Let me know if you have further questions.

[WOTPRO]

did you figure out how to do that? I am having the exact same issue, and the above suggestion doesn't seem to be the solution to this problem

[annajhaveri]

@WOTPRO  did try to use API to update the hyperlink column, are you facing issue with it?

[WOTPRO]

no sadly i can't get it to work 😞 

[WOTPRO]

I get this error when doing the first example you made

An unexpected 'PrimitiveValue' node was found when reading from the JSON reader

[annajhaveri]

@WOTPRO  is it possible for you to share the the screenshot of your flow specifically the send http request action?

[WOTPRO]

Hi this is the flow, it is supposed to copies from one SharePoint list on the Intranet site to another Sharepoint list on the IT site everytime a change is made 

[annajhaveri]

@WOTPRO  thanks for sharing the screenshot, the configuration looks right, are you sure that your Hyperlink column name is Link? Also if you could help with screenshot of Send Http action from your flow run it would help me understand how the configuration looks like with actual values

[WOTPRO]

This is the raw input

{

    "host": {

        "connectionReferenceName": "shared_sharepointonline",

        "operationId": "HttpRequest"

    },

    "parameters": {

        "dataset": "https://X.sharepoint.com/sites/IT",

        "parameters/method": "POST",

        "parameters/uri": "_api/web/lists(guid'63D8FED3-CF7D-4C85-A073-1E0B53137024')/items/",

        "parameters/headers": {

            "content-type": "application/json;odata=nometadata",

            "accept": "application/json;odata= nometadata"

        },

        "parameters/body": "\"Sagsnr\": {\n            \"Description\": \"IT\",\n\n            \"Url\": \"https://X.sharepoint.com/sites/IT\"\n\n}"

    }

this is the raw output

{

    "statusCode": 400,

    "headers": {

        "Cache-Control": "no-store, no-cache",

        "Pragma": "no-cache",

        "Set-Cookie": "ARRAffinity=51c5964be65011b1cad3526b8255ea473f9a641923fda7092968c1277815672b;Path=/;HttpOnly;Secure;Domain=sharepointonline-we.azconn-we-003.p.azurewebsites.net,ARRAffinitySameSite=51c5964be65011b1cad3526b8255ea473f9a641923fda7092968c1277815672b;Path=/;HttpOnly;SameSite=None;Secure;Domain=sharepointonline-we.azconn-we-003.p.azurewebsites.net",

        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",

        "x-ms-request-id": "de01e5a0-00cf-7000-86a2-812abbff43a2",

        "X-Content-Type-Options": "nosniff",

        "X-Frame-Options": "DENY",

        "Timing-Allow-Origin": "*",

        "x-ms-apihub-cached-response": "true",

        "x-ms-apihub-obo": "false",

        "Date": "Tue, 17 Oct 2023 14:01:30 GMT",

        "Content-Length": "547",

        "Content-Type": "application/json",

        "Expires": "-1"

    },

    "body": {

        "status": 400,

        "message": "{\"odata.error\":{\"code\":\"-1, Microsoft.SharePoint.Client.InvalidClientQueryException\",\"message\":{\"lang\":\"da-DK\",\"value\":\"An unexpected 'PrimitiveValue' node was found when reading from the JSON reader. A 'StartObject' node was expected.\"}}}\r\nclientRequestId: f0d37772-01f2-4f74-b493-da5b75d5390a\r\nserviceRequestId: de01e5a0-00cf-7000-86a2-812abbff43a2",

        "source": "https://x.sharepoint.com/sites/IT/_api/web/lists(guid'63D8FED3-CF7D-4C85-A073-1E0B53137024')/items/",

        "errors": []

    }

}

[WOTPRO]

@annajhaveri No my column is called Sagsnr - i changed that now but still throws the same error, was hoping that would have fixed the issue.

[annajhaveri]

@WOTPRO  please add the additional curly brackets around the body as shown in below screenshot, those are missing that is why you are getting the error

[WOTPRO]

Thanks! that worked :))