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:

Business Process Flows

Screenshot 2024-0...

All responses (2)

Answers (0)

t.sheehy 4 on at

Like (0)

Report

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

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."}}}
Suggested answer

Expiscornovus 31,844 Most Valuable Professional on at

Like (0)

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

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" }

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Michael Gernaey – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Michael Gernaey – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates