Forum Discussion

NEJO's avatar
NEJO
Advocate I
7 years ago

Importing Outlook - User Defined fields

Hi Experts   I'm building dashboards which look to track outlook activity across a number of my teams, and have successfully introduced a number of mailboxes to my Dashboard.   What I'm having di...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Neil,

 

Please refer to the snapshot below. It's from the Microsoft Exchange mail system. The fields that the blue arrows point at are fields you can extract. Maybe you can find the details there.

1. Which email system is it? Different email system could be different.

2. How did you add these user-defined fields?

3. Can you see these UDF online, the web portal of the email system?

 

Importing-Outlook-User-Defined-fields1

Best Regards,
Dale

  • NEJO's avatar
    NEJO
    Advocate I
    7 years ago

    Hi Dale

     

    Thanks for your response - and apologioes for the delayed reply.

     

    The fields are no where to be seen in those attributes unfortunately.  I added the UDF's through Outlook, simply by clicking on mail heading and clicking Field chooser, then New, so it then becomes a field under the user defined fields.

     

    Its on a shared mailbox, so dont think I have the ability to log into it through the Online web portal.

     

    I've managed to get around it for now, instead of using UDF's - I have the tool changing the email folder name and adding the categories at the end, which I can then unpick on the way in to Power BI.

     

    Thanks

    Neil

    • JemmaD's avatar
      JemmaD
      Helper V
      3 years ago

      I'm also having this issue, I found PropertyDefinitionStream within ExtendedProperties, which is under Attributes. But this holds the name fo the UDF not the value. I found an article which mentions the value of UDF are under PS_PUBLIC_STRINGS but I cannot see this field anywhere. 
      Did anyone get a solution for this?