Scharepoint page copy, 1 view does not change

[LanderDG]

Hey

I have a flow that copies a site page to another site. Currently, the flow is functioning correctly, as shown in the screenshot below.

In the new site, I have already created all the necessary lists with the same names. When I run this flow, everything works fine, and all the lists and views are automatically imported and correct, except for one specific list.

For all the other lists, the flow correctly imports the corresponding views. However, with this particular list, named "documents," it appears empty. It should have the same views as the original site page, but it doesn't change automatically. Please note that the "documents" list exists in the original site page as well, and the flow successfully updates the views for the other lists.

Can you assist me in troubleshooting this issue with the "documents" list in my flow?

[Expiscornovus]

Hi @LanderDG,

Can you share the part of your flow where you are copying views/recreating the views of the lists? What action are you using for the views?

[LanderDG]

Firstly, I use these actions to obtain the old view. Once I have retrieved it, I proceed to copy it to my new site.

After successfully copying the old view, I employ another action to add a field. Since I only desire a single field in my view, I delete the default views using a specific action.

To summarize, these are the actions I employ to establish the desired flow. The flow executes without any errors.

[Expiscornovus]

Hi @LanderDG,

I see you are using a viewquery of a different view, can you share the viewquery value from the outputs?

Typically the viewquery value contains references to existing fields. Are you only using out the box fields in your original view?

If you are using custom fields I can imagine this approach won't work (unless you have other actions in your setup which are creating those fields) because the fields don't yet exist (and therefore cannot be added to the view as viewfields).

And also spotted a potential small typo. I see some trailing white space in the Send an HTTP request to add title field page action in the URI field. You might want to remove that white space at the end.

[LanderDG]

This is my view query, 

"ViewQuery": '<OrderBy><FieldRef Name="Modified" Ascending="FALSE" /></OrderBy><Where><And><Neq><FieldRef Name="Title" /><Value Type="Text">Home</Value></Neq><Neq><FieldRef Name="ContentType" /><Value Type="Computed">Folder</Value></Neq></And></Where>'

I don't see custom fields.

But even when I make the "documents" manually, the page copy does not set the view to "Documents".

[Expiscornovus]

Hi @LanderDG,

Just to double check.

With does not set the view to "Documents" you mean the newly created view does not get set in the View dropdown in the Document Library web part on the copied page? Or do you mean the newly created view is missing from the dropdown in the Document Library web part settings entirely?

[LanderDG]

It is visible in the dropdown. 

Although I can manually set the view to 'Documents,' I require an automatic solution due to the large number of sites that need the page to be configured in the same way.

[Expiscornovus]

Hi @LanderDG,

Every view has its own unique view id. The newly created view will also have a different view id compared to the old one. That is probably the reason why it is not selected in that web part.

In that case you probably want to have a look at the SavePage (or SavePageasDraft) method and update the view id of that webpart within the CanvasContent1 property.

[LanderDG]

Do you know a good way to replace it in the cancascontent1? That property is so long and i dont know how properly navigate in it. This is a small bit( i deleted some sensitive info like names).

<div><div data-sp-canvascontrol=\"\" data-sp-canvasdataversion=\"1.0\" data-sp-controldata=\"&#123;&quot;controlType&quot;&#58;4,&quot;id&quot;&#58;&quot;ec4ff90a-8178-4b37-9f68-f983c8603f98&quot;,&quot;position&quot;&#58;&#123;&quot;layoutIndex&quot;&#58;1,&quot;zoneIndex&quot;&#58;0.5,&quot;sectionIndex&quot;&#58;1,&quot;controlIndex&quot;&#58;1,&quot;sectionFactor&quot;&#58;12&#125;,&quot;zoneGroupMetadata&quot;&#58;&#123;&quot;type&quot;&#58;1,&quot;isExpanded&quot;&#58;false,&quot;showDividerLine&quot;&#58;false,&quot;iconAlignment&quot;&#58;&quot;left&quot;,&quot;displayName&quot;&#58;&quot;Meldingen / Links&quot;&#125;,&quot;addedFromPersistedData&quot;&#58;true&#125;\"><div data-sp-rte=\"\"></div></div><div data-sp-canvascontrol=\"\" data-sp-canvasdataversion=\"1.0\" data-sp-controldata=\"&#123;&quot;controlType&quot;&#58;4,&quot;id&quot;&#58;&quot;86d2e23c-67ad-413f-8fba-

[Expiscornovus]

Hi @LanderDG,

I had a look at the json. There should be a SelectedViewId property nested in the settings of that web part.

You could first use a GET request to retrieve the CanvasContent1 property and use a replace function to replace the old ViewId by the new one. After that you can use the SavePageAsDraft with Merge Headers to set it to the new view.

Below is an example

I have also added HTTP requests for the checkoutpage and publish methods. This way the change also gets published directly.

The payload of the SavePageAsDraft method

{
"CanvasContent1": "@{replace(replace(outputs('Send_an_HTTP_request_to_SharePoint')?['body']['CanvasContent1'], variables('OldViewId'), variables('NewViewId')), '"', '\"')}"
}

[LanderDG]

The suggested solution appears to be viable. However, when I attempted to implement it, I encountered a "bad gateway" error. I have included screenshots below, illustrating the steps I followed. Please note that I manually inserted the View ID in the replacement field.

This is my error code 

{
  "error": {
    "code": 502,
    "source": "flow-apim-europe-001-northeurope-01.azure-apim.net",
    "clientRequestId": "294204b9-3b09-4cfc-ba51-2a9271303f56",
    "message": "BadGateway",
    "innerError": {
      "status": 502,
      "message": "{\"odata.error\":{\"code\":\"-1, System.Runtime.Serialization.SerializationException\",\"message\":{\"lang\":\"en-US\",\"value\":\"There was an error deserializing the object of type Microsoft.SharePoint.Publishing.SitePageFieldsData. The token 'false' was expected but found 'fontC'.\"}}}\r\nclientRequestId: 294204b9-3b09-4cfc-ba51-2a9271303f56\r\nserviceRequestId: c2fab5a0-70d5-6000-923f-7cc290d57b99",
      "source": "https://censored",
      "errors": []
    }
  }
}

[Expiscornovus]

Hi @LanderDG,

1. A page id is a number, in your case number 105. It does not require single quotes around the number. Please remove those quotes around the number 105.

2. I also see you have some trailing with space in the Uri field. Also remove that, just in case.

3. Can you test the view id values with lower case characters. The replace function might not be able to find the values, as far as I am aware the replace functions are case sensitive.

4. I see you used different headers. With these headers the body payload would need be formatted differently.  Please use the same (nometadata) headers as in my example if you want to use the same body.

5. Lastly, the replace function refers to the CanvasContent1 property value of a previous Send an HTTP request to SharePoint action with the name "Send an HTTP request to SharePoint". Have you also created that action as well, and does it have exactly the same name?

[LanderDG]

Did everything you said, still same error.

[Expiscornovus]

Hi @LanderDG,

Thanks for checking and changing those things. Only other thing I notice is that there is some trailing white space in the Body of the second HTTP request. Also remove that, just in case.

Can you also share the value of the CanvasContent1 you are using (should be in the outputs of the first HTTP action)?

This will help us troubleshoot/reproduce your issue. In my test example I used a page which only contained one single list web part. Your setup might be different.

[LanderDG]

Thank you for helping with searching a solution.

CanvasContent1": "[{\"controlType\":4,\"id\":\"blur-8178-blur-9f68-f983c8603f98\",\"position\":{\"layoutIndex\":1,\"zoneIndex\":0.5,\"sectionIndex\":1,\"controlIndex\":1,\"sectionFactor\":12},\"zoneGroupMetadata\":{\"type\":1,\"isExpanded\":false,\"showDividerLine\":false,\"iconAlignment\":\"left\",\"displayName\":\"Meldingen / Links\"},\"addedFromPersistedData\":true,\"innerHTML\":\"<p><span class=\\\"fontColorGreen\\\">Note: </span>Interne omgeving van censor. .</p>\"},{\"controlType\":4,\"id\":\"blur-67ad-413f-blur-f4c00d3d49fc\",\"position\":{\"zoneIndex\":1,\"sectionIndex\":1,\"controlIndex\":1,\"sectionFactor\":4,\"layoutIndex\":1},\"addedFromPersistedData\":true,\"zoneGroupMetadata\":{\"type\":1,\"isExpanded\":true,\"showDividerLine\":false,\"iconAlignment\":\"left\",\"displayName\":\"Device view\"},\"innerHTML\":\"<h3>Locatie</h3>\"},{\"position\":{\"zoneIndex\":1,\"sectionIndex\":1,\"controlIndex\":2,\"sectionFactor\":4,\"layoutIndex\":1},\"controlType\":3,\"id\":\"blur-39da-47a1-a5db-blur\",\"webPartId\":\"blur-blur-489e-a556-blur\",\"reservedHeight\":214,\"reservedWidth\":353,\"addedFromPersistedData\":true,\"zoneGroupMetadata\":{\"type\":1,\"isExpanded\":true,\"showDividerLine\":false,\"iconAlignment\":\"left\",\"displayName\":\"Device view\"},\"webPartData\":{\"id\":\"blur-bc19-blur-a556-7fe95f508720\",\"instanceId\":\"blur-39da-47a1-a5db-blur\",\"title\":\"List\",\"description\":\"Display a list from this site.\",\"audiences\":[],\"serverProcessedContent\":{\"htmlStrings\":{},\"searchablePlainTexts\":{\"listTitle\":\"Filter op locatie\"},\"imageSources\":{},\"links\":{}},\"dynamicDataPaths\":{},\"dynamicDataValues\":{\"filterBy\":{}},\"dataVersion\":\"1.0\",\"properties\":{\"isDocumentLibrary\":false,\"selectedListId\":\"blur-a6e1-blur-830a-blur\",\"selectedListUrl\":\"/sites/censor-censor/Lists/Locaties\",\"webRelativeListUrl\":\"/Lists/Locaties\",\"webpartHeightKey\":4,\"selectedViewId\":\"blur-c4d8-4518-a3f9-dabfd6beb695\",\"hideCommandBar\":true,\"hideSeeAllButton\":false},\"containsDynamicDataSource\":true}},{\"position\":{\"zoneIndex\":1,\"sectionIndex\":1,\"controlIndex\":3,\"sectionFactor\":4,\"layoutIndex\":1},\"controlType\":3,\"id\":\"blur-5f9e-4a51-aa48-blur\",\"webPartId\":\"blur-bc19-489e-a556-blur\",\"reservedHeight\":182,\"reservedWidth\":353,\"addedFromPersistedData\":true,\"zoneGroupMetadata\":{\"type\":1,\"isExpanded\":true,\"showDividerLine\":false,\"iconAlignment\":\"left\",\"displayName\":\"Device view\"},\"webPartData\":{\"id\":\"blur-bc19-489e-a556-blur\",\"instanceId\":\"e2afa814-5f9e-4a51-aa48-blur\",\"title\":\"Document library\",\"description\":\"Show a document library from this site.\",\"audiences\":[],\"serverProcessedContent\":{\"htmlStrings\":{},\"searchablePlainTexts\":{\"listTitle\":\"Documentatie locatie\"},\"imageSources\":{},\"links\":{}},\"dynamicDataPaths\":{\"filterBy\":\"WebPart.blur-bc19-489e-a556-7fe95f508720.e228fc26-39da-47a1-a5db-blur:selectedItems:Title\"},\"dynamicDataValues\":{},\"dataVersion\":\"1.0\",\"properties\":{\"isDocumentLibrary\":true,\"selectedListId\":\"blur-1528-42b0-9a42-5df57af36c6e\",\"selectedListUrl\":\"/sites/censor-censor/SitePages\",\"webRelativeListUrl\":\"/SitePages\",\"webpartHeightKey\":4,\"selectedViewId\":\"blur-a960-4652-a4ce-blur\",\"showFilterByControl\":true,\"selectedTargetFieldId\":\"Locatie\",\"hideCommandBar\":true},\"containsDynamicDataSource\":true}},{\"position\":{\"zoneIndex\":1,\"sectionIndex\":1,\"controlIndex\":4,\"sectionFactor\":4,\"layoutIndex\":1},\"controlType\":3,\"id\":\"blur-0902-430c-9361-23fb0a80f6c0\",\"webPartId\":\"f92bf067-bc19-489e-a556-blur\",\"reservedHeight\":282,\"reservedWidth\":353,\"addedFromPersistedData\":true,\"zoneGroupMetadata\":{\"type\":1,\"isExpanded\":true,\"showDividerLine\":false,\"iconAlignment\":\"left\",\"displayName\":\"Device view\"},\"webPartData\":{\"id\":\"blur-bc19-489e-a556-blur\",\"instanceId\":\"blur-0902-430c-9361-23fb0a8blurf6c0\",\"title\":\"List\",\"description\":\"Display a list from this site.\",\"audiences\":[],\"serverProcessedContent\":{\"htmlStrings\":{},\"searchablePlainTexts\":{\"listTitle\":\"SSH Tunnel\"},\"imageSources\":{},\"links\":{}},\"dynamicDataPaths\":{\"filterBy\":\"WebPart.f92bf067-bc19-489e-a556-7fe95f508720.blur-39da-47a1-a5db-blur:selectedItems:Title\"},\"dynamicDataValues\":{},\"dataVersion\":\"1.0\",\"properties\":{\"isDocumentLibrary\":false,\"selectedListId\":\"blur-a62c-4b4c-b104-blur\",\"selectedListUrl\":\"/sites/censor-censor/Lists/Credentials\",\"webRelativeListUrl\":\"/Lists/Credentials\",\"selectedViewId\":\"blur-2662-40ef-8f18-215d3c27ca48\",\"showFilterByControl\":true,\"selectedTargetFieldId\":\"Locatie\",\"webpartHeightKey\":1,\"hideCommandBar\":true,\"hideSeeAllButton\":true},\"containsDynamicDataSource\":true}},{\"position\":{\"zoneIndex\":1,\"sectionIndex\":2,\"controlIndex\":0.5,\"sectionFactor\":8,\"layoutIndex\":1},\"controlType\":3,\"id\":\"blur-b4ae-40f8-a4f2-blur\",\"webPartId\":\"f92bf067-bc19-489e-a556-blur\",\"reservedHeight\":682,\"reservedWidth\":755,\"addedFromPersistedData\":true,\"zoneGroupMetadata\":{\"type\":1,\"isExpanded\":true,\"showDividerLine\":false,\"iconAlignment\":\"left\",\"displayName\":\"Device view\"},\"webPartData\":{\"id\":\"f92bf067-bc19-489e-a556-blur\",\"instanceId\":\"blur-b4ae-40f8-a4f2-blur\",\"title\":\"List\",\"description\":\"Display a list from this site.\",\"audiences\":[],\"serverProcessedContent\":{\"htmlStrings\":{},\"searchablePlainTexts\":{\"listTitle\":\"Hosts\"},\"imageSources\":{},\"links\":{}},\"dynamicDataPaths\":{\"filterBy\":\"WebPart.f92bf067-bc19-489e-a556-blur.e228fc26-39da-47a1-a5db-93e7aa1d6879:selectedItems:Title\"},\"dynamicDataValues\":{},\"dataVersion\":\"1.0\",\"properties\":{\"isDocumentLibrary\":false,\"selectedListId\":\"blur-95ca-4e49-a1b6-blur\",\"selectedListUrl\":\"/sites/censor-censor/Lists/Devices\",\"webRelativeListUrl\":\"/Lists/Devices\",\"webpartHeightKey\":2,\"selectedViewId\":\"blur-c9b4-4452-9559-b4b26bf07862\",\"hideCommandBar\":true,\"showFilterByControl\":true,\"selectedTargetFieldId\":\"Locatie\",\"hideSeeAllButton\":false},\"containsDynamicDataSource\":true}},{\"position\":{\"zoneIndex\":1,\"sectionIndex\":2,\"controlIndex\":1.5,\"sectionFactor\":8,\"layoutIndex\":1},\"controlType\":3,\"id\":\"57cbd4fa-bc71-4296-a54e-blur\",\"webPartId\":\"f92bf067-bc19-489e-a556-blur\",\"reservedHeight\":269,\"reservedWidth\":755,\"addedFromPersistedData\":true,\"zoneGroupMetadata\":{\"type\":1,\"isExpanded\":true,\"showDividerLine\":false,\"iconAlignment\":\"left\",\"displayName\":\"Device view\"},\"webPartData\":{\"id\":\"blur-bc19-489e-a556-blur\",\"instanceId\":\"blur-bc71-4296-a54e-blur\",\"title\":\"List\",\"description\":\"Display a list from this site.\",\"audiences\":[],\"serverProcessedContent\":{\"htmlStrings\":{},\"searchablePlainTexts\":{\"listTitle\":\"Onderhoud\"},\"imageSources\":{},\"links\":{}},\"dynamicDataPaths\":{\"filterBy\":\"WebPart.f92bf067-bc19-489e-a556-blur-b4ae-40f8-a4f2-efab4866db38:selectedItems:Title\"},\"dynamicDataValues\":{},\"dataVersion\":\"1.0\",\"properties\":{\"isDocumentLibrary\":false,\"selectedListId\":\"blur-ed83-4013-bd98-blur\",\"selectedListUrl\":\"/sites/censor-censor/Lists/Onderhoud\",\"webRelativeListUrl\":\"/Lists/Onderhoud\",\"webpartHeightKey\":4,\"selectedViewId\":\"v-b51e-4d00-b883-blur\",\"selectedFolderPath\":\"\",\"hideCommandBar\":true,\"showFilterByControl\":true,\"selectedTargetFieldId\":\"Device\"},\"containsDynamicDataSource\":true}},{\"id\":\"emptySection\",\"position\":{\"layoutIndex\":1,\"zoneIndex\":2,\"sectionIndex\":1,\"sectionFactor\":12,\"controlIndex\":1},\"addedFromPersistedData\":true},{\"position\":{\"layoutIndex\":2,\"zoneIndex\":1,\"sectionIndex\":1,\"controlIndex\":1.5,\"sectionFactor\":12,\"isLayoutReflowOnTop\":true},\"controlType\":3,\"id\":\"blur-6a91-4c0e-b730-9ec988ea3d6f\",\"webPartId\":\"blur-bc19-489e-a556-blur\",\"reservedHeight\":282,\"reservedWidth\":348,\"addedFromPersistedData\":true,\"emphasis\":{\"zoneEmphasis\":0},\"webPartData\":{\"id\":\"blur-bc19-489e-a556-blur\",\"instanceId\":\"blur-6a91-4c0e-b730-blur\",\"title\":\"List\",\"description\":\"Display a list from this site.\",\"audiences\":[],\"serverProcessedContent\":{\"htmlStrings\":{},\"searchablePlainTexts\":{\"listTitle\":\"Credentials\"},\"imageSources\":{},\"links\":{}},\"dynamicDataPaths\":{\"filterBy\":\"WebPart.f92bf067-bc19-489e-a556-blur-b4ae-40f8-a4f2-efab4866db38:selectedItems:Title\"},\"dynamicDataValues\":{},\"dataVersion\":\"1.0\",\"properties\":{\"isDocumentLibrary\":false,\"selectedListId\":\"blur-a62c-4b4c-b104-3bd65cd58be0\",\"selectedListUrl\":\"/sites/censor-censor/Lists/Credentials\",\"webRelativeListUrl\":\"/Lists/Credentials\",\"webpartHeightKey\":1,\"selectedViewId\":\"blur-ac6c-488e-b669-blur\",\"showFilterByControl\":true,\"selectedTargetFieldId\":\"Device\",\"hideCommandBar\":true},\"containsDynamicDataSource\":true}},{\"position\":{\"layoutIndex\":2,\"zoneIndex\":1,\"sectionIndex\":1,\"controlIndex\":2,\"sectionFactor\":12,\"isLayoutReflowOnTop\":true},\"controlType\":3,\"id\":\"blur-9ea7-419b-a31b-d66e5d61be2f\",\"webPartId\":\"blur-bc19-489e-a556-blur\",\"reservedHeight\":282,\"reservedWidth\":348,\"addedFromPersistedData\":true,\"emphasis\":{\"zoneEmphasis\":0},\"webPartData\":{\"id\":\"f92bf067-bc19-489e-a556-blur\",\"instanceId\":\"blur-9ea7-419b-a31b-d66e5d61be2f\",\"title\":\"Document library\",\"description\":\"Show a document library from this site.\",\"audiences\":[],\"serverProcessedContent\":{\"htmlStrings\":{},\"searchablePlainTexts\":{\"listTitle\":\"Documentatie host\"},\"imageSources\":{},\"links\":{}},\"dynamicDataPaths\":{\"filterBy\":\"WebPart.f92bf067-bc19-489e-a556-blur-b4ae-40f8-a4f2-efab4866db38:selectedItems:Title\"},\"dynamicDataValues\":{},\"dataVersion\":\"1.0\",\"properties\":{\"isDocumentLibrary\":true,\"selectedListId\":\"blur-1528-42b0-9a42-blur\",\"selectedListUrl\":\"/sites/censor-censor/SitePages\",\"webRelativeListUrl\":\"/SitePages\",\"webpartHeightKey\":1,\"selectedViewId\":\"blur-a960-4652-a4ce-9e7f6dcaf140\",\"showFilterByControl\":true,\"selectedTargetFieldId\":\"Device\",\"hideCommandBar\":true,\"hideSeeAllButton\":false},\"containsDynamicDataSource\":true}},{\"position\":{\"layoutIndex\":2,\"zoneIndex\":1,\"sectionIndex\":1,\"controlIndex\":4,\"sectionFactor\":12,\"isLayoutReflowOnTop\":true},\"controlType\":3,\"id\":\"blur-0afa-423d-b547-38772dfdbbb1\",\"webPartId\":\"a8cd4347-f996-48c1-bcfb-blur\",\"reservedHeight\":393,\"reservedWidth\":348,\"addedFromPersistedData\":true,\"emphasis\":{\"zoneEmphasis\":0},\"webPartData\":{\"id\":\"blur-f996-48c1-bcfb-blur\",\"instanceId\":\"blur-bb1\",\"title\":\"List properties\",\"description\":\"Connect to a list web part on the same page and dynamically display a selection from that list.\",\"audiences\":[],\"serverProcessedContent\":{\"htmlStrings\":{},\"searchablePlainTexts\":{},\"imageSources\":{},\"links\":{}},\"dynamicDataPaths\":{\"requestedDynamicProperty\":\"WebPart.f92bf067-bc19-489e-a556-blur-b4ae-40f8-a4f2-efab4866db38:selectedItems\"},\"dynamicDataValues\":{},\"dataVersion\":\"1.0\",\"properties\":{\"title\":\"Host Details\",\"dataSourceType\":\"DynamicData\",\"formOption\":\"View\",\"size\":\"Auto\",\"allowEditing\":true},\"containsDynamicDataSource\":false}},{\"controlType\":0,\"pageSettingsSlice\":{\"isDefaultDescription\":true,\"isDefaultThumbnail\":true,\"isSpellCheckEnabled\":true,\"globalRichTextStylingVersion\":0,\"rtePageSettings\":{\"contentVersion\":4},\"isEmailReady\":false}}]",