Using MS FLOW to send an email when a CRMDynamics field changes.
FLOW triggers correctly and sends email to correct recipient. However, SENDER is Microsoft PowerApps and Flow <firstname.lastname@example.org>.
My customers expect email From: me not Microsoft@powerapps.com
Sender should be person who updated trigger field, or, failing that the owner of CRM record.
MSFLOW email ACTION does not appear to allow specifying "From:" field.
Can someone tell me what I am doing wrong?
You aren't doing anything wrong. This is a known limitation of using Flow (or PowerApps). Most of the Email actions are hard coded to come from a microsoft service account. If you use the email actions under Office 365 Outlook the mail will come from whoever is creating the Flow, but there you can change it. The problem is to set the From field the person creating the email needs "SendAs" permission to that person's mailbox. So its not really feasible on a large scale. About the best you can do is create a specific service mailbox to use for sending mail and change it to that so it doesn't come from your mailbox.
Thanks for the reply.
I wonder if the development team would be interested in adding a "normal" user to their testing cadre?
Frustratingly, my email address was used occasionally during testing of the Flow and then that behavior vanished.
Our situation cannot be unique. We use Dynamics CRM / O365 and i'm sure that MS has more than a few clients. I'll see if I can find a Dynamics community and get them involved too. I'll kepp the Flw group updated with anything useful that is uncovered.
As suggested in dynamics community:
"Click on the 'From' field and you will see dynamic values on your right.
Scroll to 'When a record is updated' you will see modified by.
But you will have to get data operators for modified by.
I have explained it in a video here: https://www.youtube.com/watch?v=A8lAdb1vfRk
The video is not on your question but it talks about getting data operators from owner/user entities.
Once you have done that, email 'From' will get correct value."
He doesn't want to change the TO, he wants to change the FROM. As I explained that is doable with some of the Send Email action, but it requires that the person who creates/runs the Flow has "Send on Behalf" permisison to the mailbox that you want to use in the FROM. That's just not feasible.
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!