I have a document library. I want to use power automate connectors to get files from document library and do some operation on those files (Excel, word)?

How can I achieve through power automate?

  • Do you want to get all files from document library? what type of operations you want to perform on files? There might be some limitations using Power Automate. can you please add more details to your question, what exactly are you trying to achieve? Apr 28, 2021 at 16:53
  • I have unique id generator in sp library .. so I want to retreive the files which is having same ID ... and filter operation is not allowed in Files
    – jijo
    Apr 28, 2021 at 17:18
  • You can use filters in "Get files" action as well as "Send an HTTP request to SharePoint" action. try solutions given in my answer & let me know if it works for you. Apr 28, 2021 at 17:36
  • Get files is only for properties I believe ..we cant get attachment here ..and can we use filter for file type in rest call?? can you share your solution link ?
    – jijo
    Apr 28, 2021 at 18:08

3 Answers 3


There is no straight forward action using SharePoint connector to get the all files in a document library.

You can find all available actions at SharePoint actions or SharePoint connector - Actions.

But there are some workarounds to get the files in a particular folder or by using SharePoint REST APIs like below:

  1. Microsoft Flow – Retrieve All Files from SharePoint Library Folder & Send Email Attachment
  2. Get all files in a SharePoint folder using Power Automate

It seems you are trying to modify file content via Power Automate. You can get file content via the action Get File Content. However if you are trying to modify the content, that is well supported in Power Automate. You can update the file content with the Update File action. However it is needed to provide the content in a format Power Automate can recognize and handle. In most case, we can do a copy and paste, but not changing certain words or lines.

A video which may help:https://www.youtube.com/watch?v=3Yhx7dAGFAw


so actually I had find the solution..i will get files (properties) --> put filter ----> get file content by path ---> create item with the file content .For me get file content by path worked .

Not the answer you're looking for? Browse other questions tagged or ask your own question.