Power Platform Community Forum Thread Details

I have a very unique issue I was hoping to get some advice on building a Power Automate flow for.

We have an shared mailbox, let's call it the XZ group. We deal with consultants who BCC that mailbox so that our entire team is included on the response. They will not CC that mailbox for various unrelated reasons. When I am included in both the "To" or "CC" and the BCC - Outlook will truncate those two emails into just one. However, if that is the case I don't know if my entire team got the reply email or if just I got it. Maybe the consultant forgot to BCC my "XZ" group. So then I would have to forward the email to my team and that defeats the purpose in having the "XZ" group to begin with.

I have tried the following approaches including:

- Emails Rules (only works for "CC" or "To"), not bcc

- Email Macros (not allowed by my organization)

I was thinking there may some way to use Power Automate to isolate these emails. Perhaps power automate would be able to tell if I was both sent via "To" or "CC" and BCC and can send me an email letting me know that I technically got this email twice but Microsoft consolidated it into one.

Categories:

Building flows

The whole purpose of the BCC field is so that the recipients of the e-mail do not know who has been added to the BCC field. Even if you could see the BCC field in Power Automate when e-mail arrives, it would only show your e-mail address. However, you may be able to do something like this, which I have not tested, so you may encounter issues along the way.

Trigger:
1. Use the “When a new email arrives (V3)” trigger.
2. Set it up to only check when the e-mail is from your consultant and sent to you or whatever you prefer to limit it to only the ones applicable to the process.
Initialize Variables:
1. Extract the from email address and subject of the email.
2. Use the “Initialize variable” action to store the from address and subject into variables.
HTTP Request to Graph API:
1. Use the “HTTP” action to make a GET request to the Microsoft Graph API.
2. Construct the URL with the from address and subject extracted from the email:
3. Replace {shared_mailbox_id}, {sender_email}, and {subject_keyword} with the appropriate variables.
4. I think this is the correct HTTP request: GET https://graph.microsoft.com/v1.0/users/{shared_mailbox_id}/messages?$filter=from/emailAddress/address eq '{sender_email}' and contains(subject, '{subject_keyword}')
Parse JSON:
1. Parse the response from the Graph API to check if there are any matching emails in the shared mailbox.
2. Use the “Parse JSON” action to handle the response.
Condition:
1. Use a condition to check if the shared mailbox received the email.
Notify Yourself:
1. If the condition is met, send yourself a notification or an email using the “Send an email (V2)” action to notify yourself.