{"id":19423,"date":"2022-04-21T07:00:00","date_gmt":"2022-04-21T14:00:00","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/"},"modified":"2025-06-11T07:50:11","modified_gmt":"2025-06-11T14:50:11","slug":"announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/","title":{"rendered":"Announcing the AAD User Virtual Table &#8211; Find and add any AAD user to your records."},"content":{"rendered":"<p>We are happy to announce support for an Azure Active Directory &#8211; <strong>AAD\u00a0 User<\/strong> virtual table for Dataverse. The AAD User table makes it easy to retrieve any user in your organization&#8217;s Azure Active Directory &#8211; not just users who have a Dataverse license assigned to them.\u00a0 You can also retrieve details like job title, email, phone number and more.<\/p>\n<p>The new AAD user table is available automatically with no additional configuration required.<\/p>\n<p>AAD User is different from the User table in Dataverse. The User table only displays users who have a Dataverse license assigned to them. AAD User will show anyone in the AAD User address book.\u00a0 Note that the AAD User table is read only.<\/p>\n<p>Here is a brief video about the new table, also information is available below.<\/p>\n<p><iframe loading=\"lazy\" title=\"Easily add active directory Users to your records using the AADUser Virtual Table\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube-nocookie.com\/embed\/GHlecOwrx0A?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>The AAD User virtual table can be found in your Tables view by selecting &#8220;All&#8221;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone wp-image-19424 size-large\" height=\"194\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-tables-1024x379.jpg\" width=\"525\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-tables-1024x379.jpg 1024w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-tables-300x111.jpg 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-tables-768x284.jpg 768w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-tables.jpg 1122w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/p>\n<p>The table itself includes many valuable columns of information about each user.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone wp-image-19425 size-large\" height=\"420\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AAD-User-Table-View-1024x820.jpg\" width=\"525\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AAD-User-Table-View-1024x820.jpg 1024w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AAD-User-Table-View-300x240.jpg 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AAD-User-Table-View-768x615.jpg 768w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AAD-User-Table-View.jpg 1170w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/p>\n<p>AAD User can be used as a Lookup column in an existing table, which will immediately provide a list of all AAD Users.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone wp-image-19426 size-full\" height=\"464\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-lookup-create.jpg\" width=\"845\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-lookup-create.jpg 845w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-lookup-create-300x165.jpg 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-lookup-create-768x422.jpg 768w\" sizes=\"auto, (max-width: 845px) 100vw, 845px\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" alt=\"Screenshot of a Power App displaying the AAD User Dropdown Contents\" class=\"alignnone wp-image-19427 size-full\" height=\"584\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-in-app.jpg\" width=\"479\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-in-app.jpg 479w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-in-app-246x300.jpg 246w\" sizes=\"auto, (max-width: 479px) 100vw, 479px\" \/><\/p>\n<p>With some additional formulas you can also use the selected dropdown value to populate additional information from the AAD User table into your forms<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"A screenshot showing how to build a formula to populate a text field with a job title based on the selection of a user in the AAD User lookup.\" class=\"alignnone wp-image-19428 size-large\" height=\"372\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-app-formula-1024x725.jpg\" width=\"525\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-app-formula-1024x725.jpg 1024w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-app-formula-300x212.jpg 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-app-formula-768x544.jpg 768w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-app-formula.jpg 1412w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/p>\n<p>For example, the <strong>AAD User Lookup<\/strong> dropdown is <strong>DataCardValue5<\/strong>.\u00a0 In the\u00a0<strong>text field<\/strong>\u00a0named <strong>Job Title<\/strong>\u00a0the <strong>Default<\/strong> value is formula:<\/p>\n<p style=\"text-align: center;\"><strong>DataCardValue5.selected.&#8217;Job Title&#8217;<\/strong><\/p>\n<p>When the app is run, selecting a user from the dropdown will automatically retrieve the job title from the AAD User table and insert it into the text field.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"Screenshot of a Power App displaying a populated Job Title value that was retrieved using a formula on the job title field.\" class=\"alignnone wp-image-19429 size-full\" height=\"472\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-in-app-with-formula.jpg\" width=\"574\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-in-app-with-formula.jpg 574w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-in-app-with-formula-300x247.jpg 300w\" sizes=\"auto, (max-width: 574px) 100vw, 574px\" \/><br \/>\n<strong>Note:<\/strong> At this time, AAD User will not retrieve groups or provide expanded information such as manager. These are potential future enhancements to the table.<\/p>\n<p><strong>Important:<\/strong> AAD User is not currently available for Automate. This is planned for a future release.<\/p>\n<p>API information for the AAD User table <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-apps\/developer\/data-platform\/reference\/entities\/aaduser\">can be found here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I am happy to announce a new Out of the Box virtual table for Dataverse, AAD User. AAD User makes it easy to retrieve any user that is in your organization&#8217;s Azure Active Directory as well as user details like job title, email, phone number and more.<\/p>\n","protected":false},"author":189,"featured_media":19424,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","ms-ems-related-posts":[],"footnotes":""},"audience":[3378],"content-type":[3424],"job-role":[],"product":[3473],"property":[],"topic":[3421],"coauthors":[2055],"class_list":["post-19423","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","audience-it-professional","content-type-news","product-power-apps","topic-application-modernization"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Announcing the AAD User Virtual Table - Find and add any AAD user to your records. - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Announcing the AAD User Virtual Table - Find and add any AAD user to your records. - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"I am happy to announce a new Out of the Box virtual table for Dataverse, AAD User. AAD User makes it easy to retrieve any user that is in your organization&#039;s Azure Active Directory as well as user details like job title, email, phone number and more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-21T14:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T14:50:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-tables.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1122\" \/>\n\t<meta property=\"og:image:height\" content=\"415\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nathan Helgren\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nathan Helgren\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/nathan-helgren\/\",\"@type\":\"Person\",\"@name\":\"Nathan Helgren\"}],\"headline\":\"Announcing the AAD User Virtual Table &#8211; Find and add any AAD user to your records.\",\"datePublished\":\"2022-04-21T14:00:00+00:00\",\"dateModified\":\"2025-06-11T14:50:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/\"},\"wordCount\":338,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-tables.jpg\",\"keywords\":[\"Dataverse\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/\",\"name\":\"Announcing the AAD User Virtual Table - Find and add any AAD user to your records. - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-tables.jpg\",\"datePublished\":\"2022-04-21T14:00:00+00:00\",\"dateModified\":\"2025-06-11T14:50:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-tables.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-tables.jpg\",\"width\":1122,\"height\":415,\"caption\":\"graphical user interface, text, application\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Announcing the AAD User Virtual Table &#8211; Find and add any AAD user to your records.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/fa447f4b6af7600e43b061b4d9414e42\",\"name\":\"Nathan Helgren\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/d2f9dfa87b93c15d292251be00ccc5ac57b800311732ec01be7180e3c3e4094b?s=96&d=mm&r=g750ad28c34befc14a76a8514583c06e4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d2f9dfa87b93c15d292251be00ccc5ac57b800311732ec01be7180e3c3e4094b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d2f9dfa87b93c15d292251be00ccc5ac57b800311732ec01be7180e3c3e4094b?s=96&d=mm&r=g\",\"caption\":\"Nathan Helgren\"},\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/nhelgren\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Announcing the AAD User Virtual Table - Find and add any AAD user to your records. - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/","og_locale":"en_US","og_type":"article","og_title":"Announcing the AAD User Virtual Table - Find and add any AAD user to your records. - Microsoft Power Platform Blog","og_description":"I am happy to announce a new Out of the Box virtual table for Dataverse, AAD User. AAD User makes it easy to retrieve any user that is in your organization's Azure Active Directory as well as user details like job title, email, phone number and more.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2022-04-21T14:00:00+00:00","article_modified_time":"2025-06-11T14:50:11+00:00","og_image":[{"width":1122,"height":415,"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-tables.jpg","type":"image\/jpeg"}],"author":"Nathan Helgren","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nathan Helgren","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/nathan-helgren\/","@type":"Person","@name":"Nathan Helgren"}],"headline":"Announcing the AAD User Virtual Table &#8211; Find and add any AAD user to your records.","datePublished":"2022-04-21T14:00:00+00:00","dateModified":"2025-06-11T14:50:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/"},"wordCount":338,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-tables.jpg","keywords":["Dataverse"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/","name":"Announcing the AAD User Virtual Table - Find and add any AAD user to your records. - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-tables.jpg","datePublished":"2022-04-21T14:00:00+00:00","dateModified":"2025-06-11T14:50:11+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-tables.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/04\/AADUser-tables.jpg","width":1122,"height":415,"caption":"graphical user interface, text, application"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2022\/04\/21\/announcing-the-aad-user-virtual-table-find-and-add-any-aad-user-to-your-records\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Announcing the AAD User Virtual Table &#8211; Find and add any AAD user to your records."}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/fa447f4b6af7600e43b061b4d9414e42","name":"Nathan Helgren","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d2f9dfa87b93c15d292251be00ccc5ac57b800311732ec01be7180e3c3e4094b?s=96&d=mm&r=g750ad28c34befc14a76a8514583c06e4","url":"https:\/\/secure.gravatar.com\/avatar\/d2f9dfa87b93c15d292251be00ccc5ac57b800311732ec01be7180e3c3e4094b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d2f9dfa87b93c15d292251be00ccc5ac57b800311732ec01be7180e3c3e4094b?s=96&d=mm&r=g","caption":"Nathan Helgren"},"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/nhelgren\/"}]}},"bloginabox_animated_featured_image":null,"bloginabox_display_generated_audio":false,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/19423","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/189"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=19423"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/19423\/revisions"}],"predecessor-version":[{"id":130161,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/19423\/revisions\/130161"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media\/19424"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=19423"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=19423"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=19423"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=19423"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=19423"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=19423"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=19423"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=19423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}