Forum Discussion

Arun_J_Yadav's avatar
Arun_J_Yadav
Copper Contributor
Mar 23, 2020

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 .

Mark-Kashman wbaer 

6 Replies

  • Sudharsan K's avatar
    Sudharsan K
    Iron Contributor
    Hi,
    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_Yadav's avatar
      Arun_J_Yadav
      Copper 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 K's avatar
        Sudharsan K
        Iron Contributor
        Hi,
        My suggestion is to use Power Automate which is tightly integrated with many services and doesn't need any extra cost.

Resources