Power Automate /Populate Word Template with an Array /Create a File Bug

GUten Morgen,
<br />Bitte wende Dich an die Kollegen hier
<br />Oder an die Power Automate DCommunity
<br />Mit freundlichem Gruß
<br />Wolf Fabian Spohr
<br />Microsoft office 365 business Support
<br />

Hallo Franziska,

vielen Dank für deine Anfrage.

Das soll mit einem Power Automate Flow möglich sein. Eine ähnliche Aufgabe wurde hier diskutiert. Du kannst gern die Kollegen aus dem Flow Forum für weitere Unterstützung anschreiben.

Mit freundlichen Grüßen
Alexander Petrov
Microsoft Office 365 Business Support Engineer

Good Morning,
<br />Please open up a ticket with the Power Automate Support.
<br />Power Automate Forum:
<br />Power Automate Ideas - Power Platform Community (microsoft.com)
<br />Kind Regards
<br />Wolf Fabian Spohr
<br />Microsoft Office 365 Business Support
<br />

Hello

I am Abdal and I would be glad to help you with your question.

Yes, it is possible to use Power Automate to automatically convert Outlook emails to HTML files. One way to do this is to set up a Power Automate flow that triggers when a new email is received in a specific Outlook folder. The flow can then extract the email's content and save it as an HTML file in a specified location.

You can also use Power Automate to convert multiple emails at once, for example, all emails in a folder to HTML files, by creating a flow that triggers when a new email arrives and then iterating through all the emails in the folder and convert them to HTML files.

It's worth noting that Power Automate is a powerful tool and it's best to have some knowledge of programming or automation to be able to set it up.

Here is a step-by-step guide to set up a Power Automate flow to automatically convert Outlook emails to HTML files:

Log in to the Power Automate website and create a new flow.

In the "Triggers" section, choose "When a new email arrives" and select the specific Outlook account and folder that you want the flow to monitor.

In the "Actions" section, add an action to "Get email" by choosing the Outlook account and folder where the email is located.

Next, add an action to "Create HTML file" and specify the location where you want to save the HTML file. You can use the dynamic content from the "Get email" action to fill in the file name and content.

Finally, add an action to "Delete email" or "Move email" to remove the original email from your inbox, or move it to another folder if you wish to keep it.

Test your flow by sending an email to the specified folder and ensure the email is converted to an HTML file.

It's important to note that this is a basic example, and depending on your specific use case, you might want to add more actions or conditions to the flow.

Please also be aware that there might be some formatting issues when converting an email to HTML file, it's possible that the final result may not look the same as the original email, due to the nature of the HTML language, and may need some manual adjustments.

I hope this information helps.

Regards,

Abdal
Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

Ja, das Problem hatte ich schon öfters.

Eine richtig saubere Lösung gibt es dafür nicht, aber Alternativen. Claus hat schon eine gezeigt.

Kopier den Text unten in eine Textdatei und speichere diese mit dem Namen der Volage und der Endung .VBS in dem Verzeichnis der Vorlage ab. Dann erstellst Du den Hyperlink zu der VBS-Datei.

Alternativ kannst Du die datei auch hier runterladen:

https://www.dropbox.com/s/ewf533virb7zgr8/OfficeTemplate.vbs?dl=1

Andreas.

'File:

'  OfficeTemplate.vbs

'

'Problem:

'  A hyperlink from an Office application to an Office template opens the template,

'    instead of creating a new file.

'  The proposed solution 

'    support.microsoft.com/kb/278627 

'  did not work.

'

'Solution:

'  Create a hyperlink to a VBS file that starts the process.

'

'Instructions:

'  Copy this VBScript into the same directory of your template.

'  Rename it so that the VBS file name has the name of the template file in front.

'  Example:

'    Template name: test.dotx

'    VBScript name: test.dotx.vbs

'  Create the hyperlink to the VBS file.

Set fso = CreateObject("Scripting.FileSystemObject")

'Get the name of the template

OurName = fso.GetBaseName(WScript.ScriptName)

'Find all files in our directory

For Each File In fso.GetFolder(fso.GetParentFolderName(WScript.ScriptFullName)).Files

  'Did we found the template?

  If StrComp(OurName, File.Name, vbTextCompare) = 0 Then

    'Invoke the default verb

    CreateObject("Shell.Application").Namespace(0).ParseName(File.Path).InvokeVerb

    'Wait a second to let the application start

    WScript.Sleep 1000

    'Done

    Exit For

  End If

Next