Get email of user stored in Dataverse column with Power Automate

If you're working with Dataverse and need to extract email addresses from user columns, you can use the Expand query in Power Automate. Unlike SharePoint, Dataverse stores users in the User table, and the only information you get directly is the user display name and ID. To get the email addresses, you can use the Expand query to extract data from connected tables. For example, you can get the email of the OwningUser of a row by using the query "owninguser($select=internalemailaddress)". You can also go deeper and extract data from tables connected to the directly connected table. This allows you to collect data from across Dataverse in a single action.

Article 6m Tom Riha

---

Login now to access my digest by 365.Training

Login