cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
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
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (8,842)