How to Check Out a File in a SharePoint Library Using Power Automate

(0) Share

Report

Posted on by LL-21030320-0

Hello Everyone,

I have a file in a SharePoint library that I want to Check Out automatically using Power Automate. I understand the Check out file action requires an integer, and I have the full path and relative paths for the file. But I continue to receive multiple errors for every method I've used (i.e., 404 for HTTP, file not found using queries, etc.) yet I can read files in other subfolders (just not check them out).

My question is which is the best way to get the SharePoint file ID from the full or relative path to present to the Check out file action?

Please help, I'm stumped.

Thank you,

Len

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report
Hi @LL-21030320-0,

You don't need an ID to use this checkout method. You can also use the file relative path value in a getfilebyserverrelativeurl method.

Below is an example
My relative site url is /sites/PowerUsers, make sure you replace that by your relative site url.

_api/web/getfilebyserverrelativeurl( /sites/PowerUsers/@{variables('LibraryUrl')}/Testdocument.docx')/checkout

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
LL-21030320-0 10 on at

Like (0)

Report

Hello Expiscornovus,

Thank you for your reply. I have multiple files in an array that I'm attempting to check out. Would I apply your solution inside of an Apply to each action?

Thanks,

Len

Was this reply helpful? Yes No
LL-21030320-0 10 on at

Like (0)

Report

Hello Expiscornovus,

What does the variable do in your response?

Len

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

Like (1)

Report

Hi @LL-21030320-0,

That variable action is used to store the name of the library as a string. It is not needed in your setup and you can replace it by your library name.

And in your use case you would loop through the item of your array inside an apply to each loop.

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
LL-21030320-0 10 on at

Like (0)

Report

Hello Expiscornovus,

My original VBA text file list is generating "https://MySite.sharepoint.com/sites/MySite/Shared Documents/MyFolder/MyFolder1/MyFolder2/MyFolder3/MyFolder4/MyFolder5/MyFile.ext" Do I need to reconstruct this path to present it to the HTTP/Check Out action?

If so, when parsing the path to send to the HTTP/Check Out action, do I need to use relative path? Also, when parsing or reconstructing the path, should I use "MySite/Documents/" "MySite/Shared Documents/" or "MySite/Shared%20Documents/"?

I'm having a really hard time with this. I just can't seem to get it to operate correctly.

Thank you for all your help this far.

Len

Was this reply helpful? Yes No