Unanswered

Get UPN from Microsoft Entra ID and send mail

(1) Share

Report

Posted on by AvsKadoo

I have a model driven app with standard table 'tblGenAITracker'
primary key column with logical name: genai_usecasetitle
then there is a Lookup column with logical name: genai_ucowner
Related table is [Microsoft Entra ID/aaduser] which is virtual table connected to my organization Active Directory.

So in my Main Form of tblGenAITracker table, which I have names as 'Gen AI-Submission'.
In this form I added genai_ucowner with default view of Microsoft Entra ID. So when user search any employee of my organization user can select it and in that Form I can show case Employee's jobtitle, officelocation, userprincipalname in 'my Main Form of tblGenAITracker table'.

Now when user save & close this record I want to send mail to email id which is in 'userprincipalname ' column of Microsoft Entra ID table. So I created Power Automate flow.
This flow will get trigger when new row added or modified in tblGenAITracker .
But Email id which I need is in 'Microsoft Entra ID'[userprincipalname ] column which I can't get it.
Please suggest me solution.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

ivan_apps 2,187 Moderator on at

Like (0)

Report

Userprincipal name is usually the email address but not always. External or guest users will have a different value and your Entra ID policies could affect username. There is an Email address property that you can use that directly ties to the Entra ID email field.

having said that it seems power automate can’t query virtual tables so you’re out of luck for a straightforward update. What you can try to do is created a classic Dataverse workflow (instant/real-time) that runs after the record is created or after the virtual entity field is updated. This workflow should be able to capture the Entra Id display name of the person and drill into its properties (like email) and get a copy of it. Then create a new field in your table for the selected user’s email (standard string field). Power automate should be able to read that no problem and since you are running a real-time workflow before your power automate asynchronous email flow, you ensure the data copy is done first.

hope this helps!

Was this reply helpful? Yes No
AkshayKadoo 6 on at

Like (0)

Report

I already tried to create power automate flow.
Initiated flow "when a row is added, modified or deleted" on my dataverse table.
Then "Get a row by ID" for Row ID: triggerBody()?['genai_usecasetitle']
Which is my Primary column.

But in return I got 404 error:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/> <title>404 - File or directory not found.</title> <style type="text/css">  </style> </head> <body> <div id="header"><h1>Server Error</h1></div> <div id="content"> <div class="content-container"><fieldset> <h2>404 - File or directory not found.</h2> <h3>The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.</h3> </fieldset></div> </div> </body> </html>

Was this reply helpful? Yes No