Dynamic file viewer (SP Webpart) within a flow

[PowerAutoGuy1]

Hey folks,

hey @Expiscornovus :D,

Here is an overview of my task:

I need to copy a bundle of sites for a new workspace at the same site and put those to the Navigator within a Flow.

I managed that already.

Now I need to change the embedded files inside the new pages in the SP file viewer webparts.

In order to do that, I created a flow that gives me an Excel sheet with the ETAGs and the path of the new documents.

Due to further research, I recognized, CanvasContent1 is different in each site and I'm not powerful enough to recognize the difference.

So I've created a flow to face this problem (I guess):

I've tried my best to translate everything.

So if the body of the CanvasContent1 contains the word file viewer, the content has to be adjusted.

Is it possible to just edit a part of the CanvasContent1 or do I have to write everything inside this item?

I hope I have presented my problem clearly and you can see how much of a not professional I am.

Thanks for your eventual help!

Your biggest fan @Expiscornovus !

PowerAutoGuy1

[Expiscornovus]

Hi @PowerAutoGuy1,

I am able to update the same pages as you with a couple of changes to the earlier flow logic.

- Add a condition to check if the page contains any File Viewer web parts

- Append replacement json for File viewer to Array

- Use a union to add other web parts json to same Array

- Making sure the CanvasContent1 & Counter variables are reset before looping to the next page content

- Using checkout, savepageasdraft, publish methods per page

Now, need to find some time to write-up the steps 😁

[PowerAutoGuy1]

Hey @Expiscornovus ,

your approach seems logical. I‘m trying my best to implement this until you got enough time to Display your approach. 

Thank you!

[Expiscornovus · Accepted solution]

Hi @PowerAutoGuy1,

Ok, ready for some write-up.

Warning, this is probably a good case for a TL;DR response 😂

The whole flow setup in one screenshot.

1. List rows present in a table action

2. Send an HTTP request to SharePoint action

a. Use the below in the URI

_api/sitepages/pages?$orderby=ID desc&$select=Id,CanvasContent1

b. No Metadata Headers

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

3. Initialize Variable action

a. Integer variable with Counter as Name and 1 as Value

4. Initialize Variable action

a. Array variable with CanvasContent1 as Name and an empty Value

5. Apply to Each action

a. Uses the below expression in the Select an output from previous steps field

outputs('Send_an_HTTP_request_to_SharePoint_-_Get_Page')?['body']['value']

6. Filter array action

a. From field uses

json(item()?['CanvasContent1'])

b. Criteria field uses (advanced mode)

@equals(item()?['webPartId'], 'b7dd04e1-19ce-4b24-9132-b60a1c2b910d')

7. Condition action

a. Criteria used:

length(body('Filter_array'))

is greater than 0

8. Apply to Each action

a. Uses the below expression in the Select an output from previous steps field

body('Filter_array')

9. Get a row action (within apply to each of step 😎

a. Key Column identifier, Key Value Counter variable

10. Append to array variable action (within apply to each of step 😎

a. Appends the below to the CanvasContent1 variable

replace(replace(replace(replace(replace(replace(replace(string(item()), slice(split(split(string(item()), 'file":')[1], '",')[0], 1), outputs('Get_a_row_-_FileViewer')?['body/file']), slice(split(split(string(item()), 'listId":')[1], '",')[0], 1), outputs('Get_a_row_-_FileViewer')?['body/listId']), slice(split(split(string(item()), 'webId":')[1], '",')[0], 1), outputs('Get_a_row_-_FileViewer')?['body/webId']), slice(split(split(string(item()), 'uniqueId":')[1], '",')[0], 1), outputs('Get_a_row_-_FileViewer')?['body/uniqueId']), slice(split(split(string(item()), 'siteId":')[1], '",')[0], 1), outputs('Get_a_row_-_FileViewer')?['body/siteId']), slice(split(split(string(item()), 'serverRelativeUrl":')[1], '",')[0], 1), outputs('Get_a_row_-_FileViewer')?['body/serverRelativeUrl']), slice(split(split(string(item()), 'wopiurl":')[1], '"}')[0], 1), outputs('Get_a_row_-_FileViewer')?['body/wopiurl'])

11. Increment variable action (within apply to each of step 😎

a. Increments the Counter Variable with Value 1

12. Filter Array action

a. From field uses

json(item()?['CanvasContent1'])

b. Criteria field uses (advanced mode)

@not(equals(item()?['webPartId'], 'b7dd04e1-19ce-4b24-9132-b60a1c2b910d'))

13. Compose action

a. Uses the below expression

union(body('Filter_array_-_Other_web_parts'), variables('CanvasContent1'))

14. Set Variable action

a. Uses the outputs of the Compose action as a value for the CanvasContent1 variable

15. Send an HTTP request to SharePoint action

a. Use the below in the URI

_api/sitepages/pages(@{items('Apply_to_each_-_Page')?['Id']})/checkoutpage

b. Verbose Headers

{
  "content-type": "application/json;odata=verbose",
  "Accept": "application/json;odata=verbose"
}

16. Send an HTTP request to SharePoint action

a. Use the below in the URI

_api/sitepages/pages(@{items('Apply_to_each_-_Page')?['Id']})/SavePageAsDraft

b. MERGE Headers

{
  "Accept": "application/json;odata=nometadata",
  "Content-Type": "application/json;odata=nometadata",
  "X-HTTP-METHOD": "MERGE",
  "If-Match": "*"
}

c. Body

{
"CanvasContent1": "[@{replace(join(variables('CanvasContent1'), ','), '"', '\"')}]"
}

17. Send an HTTP request to SharePoint action

a. Use the below in the URI

_api/sitepages/pages(@{items('Apply_to_each_-_Page')?['Id']})/publish

b. Verbose Headers

{
  "content-type": "application/json;odata=verbose",
  "Accept": "application/json;odata=verbose"
}

18. Set Variable action

a. Set CanvasContent1 variable to value []

19. Set Variable action

a. Set Counter variable to value 1