Unanswered

Update SharePoint site page properties with Send HTTP request

(0) Share

Report

Posted on by kevintaylor81

Greetings,

I have a list in one SharePoint site which represents normalized data I want to turn into site pages. I'm using this technique to make it happen:

(39) Create SharePoint Site Pages automatically with Power Automate - YouTube

In some of the columns on my list of items that I will convert to site pages have data that I want to map to site page properties. The end goal I'm shooting for is the same as what's highlighted in the video I shared. A list in one SP site driving the creating of pages in another SP library. The one variation I want to make here is updating page properties after the new page has been created. This is important because I need these properties to develop the UX my end-users will need and I don't want to do this by hand since we have a few hundred list items to convert to site pages.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Expiscornovus 33,871 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @kevintaylor81,

It should be possible to use the update file properties action for this.

Below is an example of that.

Was this reply helpful? Yes No
kevintaylor81 22 on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus Thanks! That got me moving forward but I've hit a new snag

I'm getting an access denied error in my flow's second step.

Here is the raw output from that step.
{
    "statusCode": 403,
    "headers": {
        "Pragma": "no-cache",
        "x-ms-request-id": "4364d59f-e0c0-0000-c4da-17f625367271",
        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
        "X-Content-Type-Options": "nosniff",
        "X-Frame-Options": "DENY",
        "Cache-Control": "no-store, no-cache",
        "Set-Cookie": "ARRAffinity=8ce2988208de9833422b6cabc9516aa20d0421ce61bf7c3c18ce2a28cdfca90c;Path=/;HttpOnly;Secure;Domain=sharepointonline-eus.azconn-eus.p.azurewebsites.net,ARRAffinitySameSite=8ce2988208de9833422b6cabc9516aa20d0421ce61bf7c3c18ce2a28cdfca90c;Path=/;HttpOnly;SameSite=None;Secure;Domain=sharepointonline-eus.azconn-eus.p.azurewebsites.net",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "true",
        "Date": "Fri, 25 Jun 2021 16:53:41 GMT",
        "Content-Length": "500",
        "Content-Type": "application/json",
        "Expires": "-1"
    },
    "body": {
        "status": 403,
        "message": "Access denied.\r\nclientRequestId: 224187df-0df2-46de-8c23-f59f4f20884e\r\nserviceRequestId: 4364d59f-e0c0-0000-c4da-17f625367271",
        "source": "https://highhavencannabis.sharepoint.com/sites/ComplianceSupport/_api/web/getfilebyurl('sites/ComplianceSupport/SitePages/Templates/ImportTemplate.aspx')/copyto('/sites/ComplianceSupport/SitePages/Blood%20and%20Bodily%20Fluid.aspx')",
        "errors": [
            "-2147024891",
            "System.UnauthorizedAccessException"
        ]
    }
}

Was this reply helpful? Yes No
Expiscornovus 33,871 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @kevintaylor81,

Can you share a screenshot of the configuration of that action? Just want to check for instance the URI in the action.

I also notice that you are using the GetFileByUrl method in your error message.

In SharePoint Online I have seen a lot of examples which use the GetFileByServerRelativeUrl method instead. Might be worth checking that as well:

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-folders-and-files-with-rest#working-with-files-by-using-rest

Was this reply helpful? Yes No
kevintaylor81 22 on at

Like (0)

Report
Copy link

Link copied!

Here is the image I think you're asking for. In the video I shared where the developer demonstrates this method, they started by using a relative URL method, but I wasn't able to get that to work so tried this. Would I just swap out that one string for GetFileByServerRelativeUrl?

Was this reply helpful? Yes No
kevintaylor81 22 on at

Like (0)

Report
Copy link

Link copied!

I tried the GetFileByServerRelativeUrl method and this is what I got.

Was this reply helpful? Yes No