Announcements
I'm trying to create a flow:
When an object is modified in salesforce, send an email to the case owner. Everything is done expect retrieving email address of the case owner. How to get email address of the case owner?
Hi @Anonymous,
What's the mean of the case owner? Is it a column of the Salesforce? You could give more information about your requirements.
Could you find the case owner in the output body of the trigger?
Best Regards,Community Support Team _ Lin TuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes. There is an object "Cases" and it has records something like this: Case owner, case number, status, etc.
Now "Case Owner" holds name of the person who is owning the case. When I hover on person's name, it shows the email ID of that person. This is what I want to pick so that I can put this email ID later in "Send email" section
Could you please share the output of the trigger? (including the Case owner, you should shield the key information, just need the format)
Well, I'm pretty close now. I'm adding a row in excel which is successful. This is how I have created the output to get an email:
So, I'm getting output for Case, Incorrect Case Type and Resolution Category. But Email and First Name are not showing and displaying blank output. Here is the excel:
It may be caused by the type of column, I have tested on my side that to add a row into the table, then send it via email, it works, and the format of First Name and Email columns are general.
I have checked, the format is set to General for all the columns. But I have figured out one thing - The First Name and Email are generating in excel though a formula (Screenshot Below) and probably causing this. Other columns like Case, Resolution Category are not generating though a formula. What should I do now?
If you want to catch calculated values from an excel table, I afraid that there is no way to achieve your needs in Microsoft Flow currently. The Calculated column of Excel table is not supported in Microsoft Flow currently.
If you would like this feature to be added in Microsoft Flow, please vote the following idea:
https://powerusers.microsoft.com/t5/Flow-Ideas/Calculated-excel-flieds/idi-p/98657
Ok Thank you!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 250 Super User 2026 Season 1
Expiscornovus 222 Most Valuable Professional
Haque 174
