Hello everyone!
I'd been playing Power Automate for a while. I've been trying to extract the original email user who uses a shared mailbox to send emails externally. (I'm not an expert, just a novice at all)
For example, imagine 20 users using a single shared mailbox. Ex: salesatexample.com (Scenario where everyone is using SEND AS)
user A: johnexample.com sends external A, external replies, and it lands on the shared mailbox, but it should also send a copy/forward to John since he's the original composer of that email.
and so on; the idea is that every reply email lands in the original composer's inbox instead of giving the user access and managing the shared mailbox.
So far, if using "when a new email arrives (V3)" and I used the option to capture the sent items since John added his email on the BCC line to receive a copy (following this methodology to get the conversational ID)
I'm able to see the conversational ID and the BCCline if I run this flow at it is; this methodology won't work at all unless I use SQL or a database and create a workflow to compare the conversational ID and the BCC line, but that would be too complex and unnecessary data storage and since, if I select the "Inbox" option on the folder option, I won't get any metadata from the original composer (unless I'm missing something).
I tried researching over the internet, using AI to make this work, and it seems that there is no such feature or configuration like this (I'm doing this this way so we can automate and avoid the users entering the shared mailbox and seeing 100 replies per day). And, I don't want to rely on 3rd party software as much as possible if it's something that can be achievable in Microsoft tools. I know that you will probably say they need to access the sharedmailbox but, if we can avoid this, the better. (I understand using exchage rules does not have such things either)
Here is what I have so far; of course, I haven't worked on the condition yet because I was trying to get the data that I'm looking for.
Anything that helps, will be appreciated!
Thank you for your time!
Edited: Better formating and fixed screenshots error
