Unanswered

How to automate every saved file in a OneDrive for business folder into an excel sheet

(0) Share

Report

Posted on by Community Power Pla...

How can I use power automate, to save each attachment from outlook emails as as file into my OneDrive for business, and then transfer the information of the email (from, subject, date and time) into an excel table and automatically get a hyperlink to the email attachments that were saved to the one drive folder? This would be an extremely huge help in keeping track of what invoices are still needing paid, which we are still needing final copies for etc

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Community Power Pla... on at

Like (0)

Report

As of right now I already have a flow that automatically saves every attachment into the OneDrive folder for business for every email that is received, I cannot figure out how I can transfer the from, subject, date and time received of the email, PLUS the link to each email attachment that are automatically saved into the OneDrive for business folder that I chose so I can easily access them from the excel sheet by clicking on the hyper link or path link

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Also, the emails I receive contain more than one attachment, so the format on the excel sheet I would want would be
From-subject-date and time received- then links to all attachments from the email
so- is want the excel table to look like this in terms of excel rows
email information- link to first attachment
- link to second attachmnt
-link to third attachment
next email received info - link to attachment
- link to 2nd attach
next email received info - link to 1st attach

Was this reply helpful? Yes No