get Outlook Category

[Tim_Schwarz_CT]

Hi,

we got a shared mailbox and do categorise the emails.

I want to forward the emails by category. 

I already wrote a vba solution but i cant figure out how to trigger my script by Power Automate.

Is there a way to get the category property in a flow or to trigger my vba script?

[VictorIvanidze]

Use a GRPAH request.

Here is shown how to assign a category - you can modify this flow.

[Tim_Schwarz_CT · Accepted solution]

Thank you for your help 🙂 

Sadly we dont have Azure thats why i was looking for new solutions and i found a very easy one. 

To get the category one can use the search query by "get emails (v3)" like shown in my picture:

maybe others will find this usefull too  🙂

[VictorIvanidze]

Hi @Tim,

how your approach will help if I don't know the name of category?

[Tim_Schwarz_CT]

in that case in dont know, maybe its possible to work with an index aswell. Or u try to get a part of the string and start all categories with the same String. I didnt have enough time to try it yet. If i stumble upon a solution i willl reply.

But i think usually if someone uses categories in outlook he should know how they are named. Then you could for excample use a table in the flow to store all possible values and search for the ones needed. 

[mevargasc]

It's possible I have done already , so if somebody needs yet , I can upload the captures

[SerdarCoban]

Could you share your solution, please?

[SirajM12]

Using the syntax recommended in the solution, it searches for the specified text in the email subject and body instead of searching for emails labeled with that category. Could you please verify its functionality by creating a category with a custom name on your end?

[Tim_Schwarz_CT]

Hi Siraj,

the flow is working i set it up for our company multiple times.

Here is a testflow with the category "Test_123".

[JBCFK]

You can also create a custom view in View Settings where you can concatenate the original email subject  field with your Category name. 

View Settings--> Columns --> New Column --> change Type to 'Combination', Edit the formula, Insert (under 'All Mail Fields') choose the field you want to use in conjunction with your Category, as well as your Category. My O365 has 2 "Categories" selections, not sure why, but only the one without the ".." at the end worked for me. This function also seems to allow additional text to be displayed in the new view, i added some asterisks to raise awareness.  

[JBCFK]

NOW IF SOMEONE CAN HELP ME PULL IN THIS CONTENT IN THE CREATED FIELD.... 

[VictorIvanidze]

Hi @JBCFK,

it looks you'd better to ask somebody at Outlook forum. Reddit, MS Tech Community etc...