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?
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
There is no straight forward action using SharePoint connector to get the all files in a document library.
But there are some workarounds to get the files in a particular folder or by using SharePoint REST APIs like below:
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