get Outlook Category

(0) Share

Report

Posted on by 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?

Categories:

General topics

All responses (11)

Answers (1)

Sort by

VictorIvanidze 13,083 on at

Like
a
(1)

Report
Copy link

Link copied!

Use a GRPAH request.
Here is shown how to assign a category - you can modify this flow.
Verified answer

Tim_Schwarz_CT 26 on at

Like
a
(4)

Report
Copy link

Link copied!

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 13,083 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Tim,
how your approach will help if I don't know the name of category?
Tim_Schwarz_CT 26 on at

Like
a
(0)

Report
Copy link

Link copied!

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 14 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

Could you share your solution, please?
Siraj M 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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 26 on at

Like
a
(0)

Report
Copy link

Link copied!

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 4 on at

Like
a
(0)

Report
Copy link

Link copied!

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 4 on at

Like
a
(0)

Report
Copy link

Link copied!

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