Getting new page url from "Send an HTTP request to SharePoint" News page creation

(1) Share

Report

Posted on by t.sheehy

We are working on a flow where a form submission after an approval gets automatically posted to the News section of one of our SharePoint sites. I've already successfully worked out how to create and publish the page, but my issue lies in getting the correct URL to email to the submitter.

My 4 steps for initializing and publishing the News Article Post are as below:

body.d.Id pulls the page ID from the initial HTTP request, however that's sequential for all posts within pages. I know the article saves based on the title in the SavePageAsDraft JSON Payload but if it's a replicated title you end up with (1), (2), etc appended to the .aspx page.

I notice on the raw outputs of the first request it has an absolute url but that has a placeholder page name that gets overwritten by the draft save. Is there a way to pull the absolute url after using SavePageAsDraft or Publish?

Attachment of screenshot as required by power platform.

Categories:

Building flows

Screenshot 2024-0...

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Expiscornovus 33,194 Most Valuable Professional on at

Like (0)

Report
It looks like the SavePageAsDraft and Publish methods don't return the Url. You could use a new Get request after the publish action. With a $select query parameter you can specifically retrieve the AbsoluteUrl.

Try something like the below example

URI

_api/sitepages/pages(@{outputs('Send_an_HTTP_request_to_SharePoint')?['body']['d']['Id']})?$select=AbsoluteUrl

Headers

{ "Accept": "application/json;odata=nometadata", "Content-Type": "application/json;odata=nometadata" }

Was this reply helpful? Yes No
t.sheehy 4 on at

Like (0)

Report

UPDATE: Disregard, I had the new module pointed at the wrong sharepoint site

-----
Unfortunately I get this error:

{"odata.error":{"code":"-1, Microsoft.SharePoint.Client.ClientServiceException","message":{"lang":"en-US","value":"Item does not exist. It may have been deleted by another user."}}}

Was this reply helpful? Yes No