Power Platform Community Forum Thread Details

Hello!

I am trying to automate a report as part of the automation efforts at my company. Every week my team gets an email from a certain sender with a specific title so I am going to use that as triggers/actions. The email contains a word doc that has text information in the beginning and then data in table format. I want to extract the table into an excel for further manipulation/automation.

Does anyone know how to do this or has any experience with doing something similar?

Categories:

Power Automate Desktop

Good Afternoon,

You can achieve something similar if their is a semi-consistent way the file is built. The way I know how to do it however would consist of:

Power Automate Cloud Flow + Power Automate Desktop Flow:

Cloud flow:

When an email arrive (V3)

Create a File - SharePoint Connector

Run a flow built with Power Automate for desktop (Attended or Unattended if you don't know which you will probably need to use attended and be there when it runs) - Pass the file location in SharePoint

Power Automate Desktop flow:

Open word - select your file etc

Read the table

Create an Excel - > Write your table to the excel

Create file in SharePoint version of your excel

Return Status

Cloud Flow finish:

Send yourself an email of the location of the file.

Its a lot of work around for grabbing that file but, it can work I will say this method will be inconvient if you aren't actively watching it be processed which I feel like for most use cases human in the loop ruins the purpose of the project.

If this answers your question please select it as the answer if not feel free to follow up I will try to respond.