Unanswered

Power automate desktop flow: retrieve excel file from outlook

(0) Share

Report

Posted on by AD6

Hi,

Every week i receive a lot of mails from all the employees with their time sheets of that week (Excel-file). These mails arrive in my Outlook mailbox and i have to copy their working hours from their Excel-time sheets to another Excel file where you can see all the hours of every employee. I'm stuck right now at the step how i can retrieve the data from their Excel and paste it into the other one.

I'm working with a desktop flow and i'm struggling with the 'for each' loop action. (i figured it had something to do with that).

I hope this is somewhat clear to understand

I have the same question (0)

All responses (2)

Answers (0)

lbendlin 8,361 Super User 2025 Season 2 on at

Like (0)

Report

Re: Power automate desktop flow: retrieve excel file from outlook

What are you planning to do with the emails once you have processed the Excel attachment? If you keep the emails in the inbox then the PAD flow will process them over and over again.

It may help if you write down the business flow of your process. Once you have that, and are sure it is accurate, you can then implement it step by step in PAD.

Was this reply helpful? Yes No
AD6 2 on at

Like (0)

Report

Re: Power automate desktop flow: retrieve excel file from outlook

After i copied all the info from the one Excel file (in the mail) to the other one then i will automate it so that the initial mail gets deleted that way it doesnt keep doing it over and over again. It will only read the unread emails.

Was this reply helpful? Yes No