Forum Discussion
Auto Filling SharePoint Library columns with Outlook Email Quick parts Data
Hi,
I'm using Flow(MS Automate) to export Email with Attachments in my Inbox to a SharePoint Library. This worked.
Now the next requirement, I need to capture(populate) the Metadata AUTOMATICALLY in SharePoint Document Library for this Email item from the same E-Mail Content aforementioned say the Email Sender's A) Company name, B) Employee Name, C) Industry Domain of their Company etc
Can this requirement be achieved with Quick Parts in Outlook or any other method? If yes, Please explain the Process for the same .
6 Replies
- Sudharsan KIron ContributorHi,
You can use the Power Automate for the library whenever a file is uploaded, there are few actions from which you can get the metadata information.- Arun_J_YadavCopper Contributor
Sudharsan, thank you for update.
I see Variables as one of the Feasible thing to Parse email content and extract data via Power Automate. Other options are Content parsing 3rd Party Apps like PARSERR which needs separate login unlike SSO in O365 to parse and extract data.
Which option do you think will be apt to Parse the Email Body and Subject Content ?- Sudharsan KIron ContributorHi,
My suggestion is to use Power Automate which is tightly integrated with many services and doesn't need any extra cost.