Answered

Create SharePoint Site Pages automatically with Power Automate when an item is added to OnPrem List

(0) Share

Report

Posted on by knishal

185

Hi I am having the follow error on my flow. What I am trying to do is, whenever an item is added to Sharepoint OnPrem List, create a news page on Sharepoint Online. Here is the error:

URI: /_api/web/GetFileByServerRelativeUrl('/sites/spfx/sitepages/NewsTemplate.aspx')/copyto('/sites/spfx/sitepages/Test8.aspx')

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (1)

Expiscornovus 33,757 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @knishal,

Can you try this for the URI:

_api/web/getfilebyserverrelativeurl('/sites/spfx/SitePages/NewsTemplate.aspx')/copyto(strnewurl='/sites/spfx/SitePages/Test8.aspx',boverwrite=false)

I see the copyto method also has strnewurl & boverwrite parameters:

https://learn.microsoft.com/en-us/previous-versions/office/developer/sharepoint-rest-reference/dn450841(v=office.15)#copyto-method

Below is an example in a Send an HTTP request to SharePoint action.

Was this reply helpful? Yes No
knishal 185 on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus I tried that and its giving me the same error:
"message": "Server relative urls must start with SPWeb.ServerRelativeUrl\r\nclientRequestId: 2d8e2338-3ec9-43f3-8768-ae4c19b6a901\r\nserviceRequestId: ec0f69a0-1014-d000-6ce6-0883805a103e",

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

Like (0)

Report
Copy link

Link copied!

Hi @knishal,

It looks like it cannot find the original page, which it tries to copy. The NewsTemplate page does exist within the spfx site, correct?

And another check. Are you using the same site name in the Uri value as in the Site Address dropdown?

Was this reply helpful? Yes No
knishal 185 on at

Like (0)

Report
Copy link

Link copied!

@ExpiscornovusI see the issue and it works now. I will accept that as a solution. I have another Issue and dont want to create another post. Moving on from that step, I have an issue with getting the file meta data.

Flow:

Error:

Any idea on how I can resolve this?

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

Like (0)

Report
Copy link

Link copied!
Hi @knishal,

I would use some encoding in the File Identifier.

You could use the encodeUriComponent function for this.

In your setup that would be probably something like below:

encodeuricomponent(concat('/SitePages/', triggerOutputs()?['body/Title_x002f_Name'], '.aspx'))

Was this reply helpful? Yes No
knishal 185 on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus tried that and got the same error. Did i miss something:

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

Like (0)

Report
Copy link

Link copied!

Hi @knishal,

Can you add the previous code snippet via the expression editor/tab instead of pasting it as plain text?

Was this reply helpful? Yes No
knishal 185 on at

Like (0)

Report
Copy link

Link copied!

Tried that, didnt work too 😞 Same error.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,757 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @knishal,

Did you add the expression in the File Identifier field in the same way as in the animation below?

Can you also double check that your title/name field has the same internal name as in my expression. I used Title_x002f_Name. Your field could be different.

If it is different you also need to update the expression so that it will be using your specific internal field name.

You can check that via the peek code in a compose. Or just hover over it. That is in the second part of the same animation below.

Was this reply helpful? Yes No