Hello everyone,
I want to use 'send an HTTP request to Sharepoint' in order to put new content into an Excel Sheet on Sharepoint. This is my standard form which I change with new data during my flow, then save the changed version under a new name, and finally want to restore the content of that standard form.
I have to use this approach as I cannot just copy the form within the flow as it is not possible to access dynamic content created during the flow with "add row" etc. Furthermore, I cannot replace the form with original content either as it is blocked due to being used within the flow before.
I expect that the HTTP Request can solve my problem.
However, I cannot get this command to work:
Method: PUT
URI:
/_api/web/getFolderByServerRelativeUrl('Documents/General')/Files('{Form_B.xlsx}')
-> it should work, but it doesn't, I get the error "file could not be found" (it exists of course)
Headers:
{"Accept": "application/json;odata=verbose",
"Content-Type": "application/json;odata=verbose"}
-> not sure if a header is necessary here at all
{
"body": {
"$content": "Get_file_content"
}}
-> this is the content of the original standard form which I receive via "get file content" at the start of my flow. I am sure that this is not complete yet.
I wish I could have added an image, but I somehow dont have permissions to do so.
I would be very grateful indeed for any help, I googled this issue many hours but did not find the needed information.
Thanks!
