Unanswered

How to fix my HTTP REQUEST TO SHAREPOINT body so it doesnt time out

(0) Share

Report

Posted on by zajacjos

120

My code takes a template and copies it to another folder. It will then send an http request to a onenote file and an excel file to rename them. I can not figure out how to change the metadata part of the body so it actually changes this does anyone know how to fix this?

{
"__metadata":{
"type": "@{body('Send_an_HTTP_request_to_SharePoint')['d']['__metadata']['type']}"
},
"Title": "@{variables('Folder Name')}",
"FileLeafRef": "@{variables('Folder Name')}"
}

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (0)

Expiscornovus 33,175 Most Valuable Professional on at

Like (0)

Report
Re: How to fix my HTTP REQUEST TO SHAREPOINT body so it doesnt time out

Hi @zajacjos,

That first HTTP POST request will not return the type with those headers. As far as I am aware it will only return a HTTP 204.

What you could do is add a HTTP GET request to retrieve the type instead directly after the Copy Folder action. You can use the outputs of that action instead of the current type expression you are using.

Try something like below:

After that you should be able to use:

outputs('Send_an_HTTP_request_to_SharePoint_-_Type')?['body']['d']['__metadata']['type']

If it helps I got also two code snippet example blogs about this use case:

https://www.expiscornovus.com/2022/11/15/get-odata-type-folder/

https://www.expiscornovus.com/2022/11/15/rename-a-folder/

Was this reply helpful? Yes No
zajacjos 120 on at

Like (0)

Report

Re: How to fix my HTTP REQUEST TO SHAREPOINT body so it doesnt time out

I tried this and it didnt work should I be doign the outputs in the bodies of the rename?

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

Like (0)

Report
Re: How to fix my HTTP REQUEST TO SHAREPOINT body so it doesnt time out

Hi @zajacjos,

My suggestion was to use that expression in the body of the rename action.

Below is the full example

{ "__metadata":{ "type": "@{outputs('Send_an_HTTP_request_to_SharePoint_-_Type')?['body']['d']['__metadata']['type']}" }, "Title": "@{variables('Folder Name')}", "FileLeafRef": "@{variables('Folder Name')}" }

Was this reply helpful? Yes No
zajacjos 120 on at

Like (0)

Report

Re: How to fix my HTTP REQUEST TO SHAREPOINT body so it doesnt time out

Any clue why This isnt working?

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

Like (0)

Report
Re: How to fix my HTTP REQUEST TO SHAREPOINT body so it doesnt time out

Hi @zajacjos,

Looks like a typo. You used a different name for that request Type action.

I used "Send an HTTP request to SharePoint - Type". You used "Send an HTTP request to - Type".

The expression cannot find the action name you used in the expression.

You have two options to fix this.

1. Change the name of the action in the expression to what you used as an action name.

{ "__metadata":{ "type": "@{outputs('Send_an_HTTP_request_to_-_Type')?['body']['d']['__metadata']['type']}" }, "Title": "@{variables('Folder Name')}", "FileLeafRef": "@{variables('Folder Name')}" }

2. Or alternatively rename the action to what I used in my example (in other words, add the missing word SharePoint), in that case you don't have to update the expression in the body.

Was this reply helpful? Yes No
zajacjos 120 on at

Like (0)

Report

Re: How to fix my HTTP REQUEST TO SHAREPOINT body so it doesnt time out

Very odd now it is just copying the name of the template.

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

Like (0)

Report

Re: How to fix my HTTP REQUEST TO SHAREPOINT body so it doesnt time out

Hi @zajacjos,

Did you include the name of the document library in the Uri of the last HTTP request? In your last screenshots it looks like that part is missing.

Was this reply helpful? Yes No
zajacjos 120 on at

Like (0)

Report

Re: How to fix my HTTP REQUEST TO SHAREPOINT body so it doesnt time out

I changed to Project Folders
It is now accepting it. Still no change on the one note file though.

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

Like (0)

Report
Re: How to fix my HTTP REQUEST TO SHAREPOINT body so it doesnt time out

Hi @zajacjos,

I see you removed the /sites/automation part, that is also required.

In both actions can you make sure the URIs are like below:

Action to retrieve the type value

_api/web/GetFolderByServerRelativeUrl('/sites/automation/Project Folders/@{outputs('Copy_folder')?['body/Name']}')/ListItemAllFields?$select=type

Action to rename Folder

_api/web/GetFolderByServerRelativeUrl('/sites/automation/Project Folders/@{outputs('Copy_folder')?['body/Name']}')/ListItemAllFields

Was this reply helpful? Yes No
zajacjos 120 on at

Like (0)

Report

Re: How to fix my HTTP REQUEST TO SHAREPOINT body so it doesnt time out

Im really confused why it isnt changed the onenote. Am I making changes a layer too high? I thought fileleafref is what I need to change the name of a onenote file?

Was this reply helpful? Yes No