Unanswered

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

(0) Share

Report

Posted on by Community Power Pla...

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.

Categories:

Using flows

I have the same question (0)

All responses (12)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
WOTPRO 26 on at

Like (0)

Report

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

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
WOTPRO 26 on at

Like (0)

Report

no sadly i can't get it to work 😞

Was this reply helpful? Yes No
WOTPRO 26 on at

Like (0)

Report

I get this error when doing the first example you made

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

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
WOTPRO 26 on at

Like (0)

Report

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

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report

@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

Was this reply helpful? Yes No
WOTPRO 26 on at

Like (0)

Report

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": []
    }
}

Was this reply helpful? Yes No
WOTPRO 26 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No