Unanswered

Retrieve file content from SharePoint

(0) Share

Report

Posted on by lena112

Hi everyone,

I'm currently creating a chatbot using Copilot Studio that involves calling a Power Automate flow to get certain file content from SharePoint. The flow retrieves the file content and uses it further as a string.

The files I'm working with can be in PDF or Word format. I have a URL to access the file in SharePoint.

However, I'm encountering an issue with the output from the Power Automate flow. The output seems to be in a bunch of characters (instead of the file content), which I can't use as a string.

Could someone help me transform the file content from SharePoint into a usable string?

A screenshot of my flow:

retrieve file flow.jpg

This is the response, example of a file content:

Thank you!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @lena112

see whether this helps 🙂

https://www.tachytelic.net/2021/05/power-automate-extract-text-from-word-docx-file/

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
lena112 8 on at

Like (0)

Report

Thanks, but some of my files are pdf. What do i do with them?
And this method has many steps, is there a shorter method?

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @lena112

for PDF Files > you need to try with ai builder or any other premium connectors to extract the text, the extraction of word/pdf document should be done on basis of file type, if file type = pdf> then follow the path for extracting pdf data , else go with word document extraction data.

Also i could not find any other option apart from this to extract text from word documents , else you have to use premium connectors for this purposes.

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No