Hi,
Is it also possible to use Flow,
if a new word online document appears in a folder an email is sent with the text of the word document in the body?
That must be done for every online word document that is stored in the folder.
Hi there, welcome!
If you switch your Trigger to "When a file is created in a folder" (not the properties only one), you'll have an option for "File Content" in your dynamic content drop down (see below)...try that and let us know.
Keep us posted.
-Ed-
No worries, I tried it out on my own. It looks like the "file content" is a binary file, which is why you can't just dump the text to the inside of an email. I looked for something that would convert the .doc file so you could put the contents as text into the email, but didn't immediately see anything in Flow.
But, there are a couple of options -
I don't think it will be pretty (html might be the best-looking thing) because of all of the formatting stuff Word and pdfs put in there. But take a look at those options and let us know if either works in your scenario and we can try to build something together. Others might have better ideas, but this is what I got 🙂
Keep us posted.
-Ed
Ok, so I found out the Word connector forces you to choose a specific file, rather than dynamic content.
But...I took a look at Encodian, they have a free plan that limits you to 50 actions per month and some other limitations. Details here. In addition to the action to pull the text from a pdf, they had a doc > pdf action.
So I was able to find a solution by converting the doc to a pdf, then stripping the text from the pdf, and throwing that in the email. Here's what it looks like (you'll probably want to add a condition that verifies the source file is indeed a word doc):
Take a look at their connector (or the other one from Plumsail) and see if either will work for you. The email I got wasn't pretty (no formatting in the text), but the content was definitely there.
Let us know how it turns out.
-Ed-
Hi @edgonzales
Yes, it is indeed better to save it as a .html in word.
The disadvantage is that folders with .html files are also stored.
How should I remove it after sending the email to prevent contamination?
The Sharepoint connector has a "Move File", you can use that. Or there is a File System connector with a Delete File action. (I don't know much about that one, but I bet there's loads of documentation on it as I think it is a System Connector.
Hi @edgonzales
Hi I try to save the word document directly to sharepoint as a filtered webpage (then no folders are saved and is better)
However, word indicates that it cannot be saved on sharepoint.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
48 | |
32 | |
32 | |
31 | |
29 |