cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bendraper
Level: Power Up

Reading file contents from Sharepoint

Hi I'm trying to get flow to read word documents (and outlook messages) stored in a document library on sharepoint and export the content to a list on sharepoint.

The files will be between 1/2 pages long with limited formatting - which can get lost without an issue.

 

The flow appears to struggle exporting the outputs, both in that the output is too long (as expressed in the error message when the flow is reviewed) but also in that the flow is clearly not reading the text property, and where it does export anything it's a garblled mess.

 

I've tried this with a normal txt file and it works prefectly, so I presume that the issue is with the reading of microsoft's file formats - something that surprises me given that it microsoft's flow!

 

Any ideas on the capabilties or restrictions on the sharepoint read file content function (and any links to documentation of this or any other functions as I've tried and failed to find any).

 

Kind regards

 

Ben

2 REPLIES 2
Community Support Team
Community Support Team

Re: Reading file contents from Sharepoint

Hi Ben,

 

May I know the detailed information of your flow? How did you export the content to list?

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bendraper
Level: Power Up

Re: Reading file contents from Sharepoint

Hi Mona,

 

There isn't much detail to provide, I simply linked up sharepoint online and using the basic connectors in flow selected it to run when a file is added to a document library and then the sharepoint action item to add an item to a list, using the dynamic content, "File content" from the document library stage to populate the description in the list.

 

 Capture.PNG

 

Kind regards

 

Ben

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (6,477)