Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 difficulties with at the moment, is pulling in some additional, non standard fields to really be able to add value to the dahsboards.
The teams mailboxes have an in house built ticketing system which utilises User Defined fields against the messages. The Ticketing tool adds various values to predefined UFDs within outlook, and these would be great to include to enable me to categorise the emails accordingly and present real insight into the team activities.
I've looked at all of the attributes in the query, but fear that non standard fields dont get pulled in. Has anyone come across this and managed to work around it somehow, or anyone have any ways n which I can get this type of data.
Thanks for any help you might be able to provide.
Neil
Hi @NEJO,
Could you please mark the proper answers as solutions?
Best Regards,
Dale
Hi @v-jiascu-msft ,
I too have added the UDF's through Outlook by clicking on mail heading > Field chooser > New, then became a field under the user defined fields. The fields are editable text.
It is also on a shared mailbox, so its not available through the OWA.
Do you have any suggestions on where to go from there?
Thanks Dale,
Sabri
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?
Best Regards,
Dale
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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |