Forum Discussion
Impactful IndividualQuerying Exchange mailbox
Hi I found a great post of using power query to interogate the messages in a mailbox
https://www.excelguru.ca/blog/2014/01/09/using-powerquery-with-email/
This works prett much perfectly, but I cannot see anywhere that you can extract the flag status. Basically trying to build a simple CRM tool ofr our call centre so they can prioritise incoming webforms. Makes a big differnece if they can use the flag function and have this pulled into the report.
Anyone got any clues how to get holdof the Flag Status ofr a message woudl be appreciated.
Thnaks
Mike
9 Replies
v-huizhn-msftMicrosoft Employee
Hi masplin,
After research the blog you posted, you can query the needed data from Exchange mailbox. Then use the data to create a report, the report will update everytime you refresh your data. For your requirement, I am really confusing the flag status. And what's the meaning of using the flag function? Could you please share more details for further analysis?
In addition, could you get the data from mailbox just like the data from the “Affiliates’'\Exceluser.com” folder. And filter the data as the following screenshot?
Best Regards,
Angelia
masplinI can do everythnig this post suggested. However in outlook there is a function ot flag a message for follow up. I cannot find this field under any of the fields shown in the query. i checked every column and table including al lthe attributes and its not there. I can see catagories, read status etc, but not flags.
In the example below I have put flags on 2 messages and one I marked complete. This data must be avaialbe somewhere?
- v-huizhn-msft
Hi masplin,
I am not specific about Exchange how works and how it stores data on the server. I personally suggest you post it to Exchange forum to confirm where the data is stored. Thanks for understanding.
Best Regards,
Angelia
I have the same question. How can I get access to additional fields from Outlook? The built-in connector in PowerQuery only makes a limited number available.
You need to expand the attributes column in the email table (records) and select TaskDateCompleted. You do this by editing the table after you have imported the outlook email data.
I use the TaskDateCompleted to calculate how many days have passed from the date an email is received before the email is marked completed. Attributes.ExtendedProperties.TaskDateCompleted
Oskar
