techcommunity.microsoft.com Open in urlscan Pro
2a02:26f0:3500:892::207e  Public Scan

Form analysis
2 forms found in the DOM

Name: form_567ba27c51bf2c — POST https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.searchformv32.form.form

<form enctype="multipart/form-data" class="lia-form lia-form-inline SearchForm" action="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.searchformv32.form.form" method="post" id="form_567ba27c51bf2c" name="form_567ba27c51bf2c">
  <div class="t-invisible"><input value="blog-id/ExcelBlog/article-id/1626/q-p/b2NpZDplbWxfY29yZV9jb25zX2NnY191c2dfZW1sX20zNjVST1dmZWF0dXJlc3Vuc2V0" name="t:ac" type="hidden"><input value="search/contributions/page" name="t:cp" type="hidden"><input
      value="EAzlvC6yyq0d378no8ep9EuHJ1FkapzdtNdtzh58Bgo0vzKbqlwOE6P4dZs8LxabX-e8Rl3EJoYKJ9hBxDtTCzlYaWBLYC-a00t_sgV716M_M3GAIjqu0Rp3MxJWDCL54-jCwoozsBRKQYE_32CYXUAI3_4H-wvxsI_6JPr_nWWwn2OvW9FegL5QgW-Oy-QbgUUrAZlyqxQQt9z1EeauQWTufcR8b--voPPCKwFhWOifny7_v4l7VOYdPJrYmqHvXnYXk9fckfXQu8qu6VdFHi4LkEA-Fqg0MRjLSZuwJp8xf75qTJgMIRDn6cD8v6NOQywjqL7Uxz3rJx6lNiFrBPwuzhiR0Mk3KbNRqxSSx4t6ifMC_ZSR5y1W8-B3PoGZK6uJZjghrLFWx89-TKTl4MGlPHmgR0M8S6UO4SBMEQG7Mmj7qP8Rv_WdrTjHbphvrlxKCXcuX6tUIHvW0xbRhmfNv3HVMh6WQKJnchnmNGjIbw9Y4ffIadr8KN-_KsE5cU4bU2yF5Ln_A1_hqcMwewttMU75UV8-BY-it294a2vEAp8PfrBI92sH_46oIk7VEnRPZKWTh87-qFPbnD-zmiQ85sI2t43AaO6UoxdFKEfUIh8Y0_dmuFYUqHLB6husV2LgoyCyM0kLlgqzsRZFC0r5U2hQ96m5q8X5YKiAQtstUa2ye1HGjsXEiwUBs6yP6QyndbjcTOQXi23ihB9dUJi2dMO18oquIXtiZbaS-lIFRxJTieRc1nBgDyb3OnXONJGPhlJJ80sV_Ao_lZN20fRoe_AstVb-4Qzih8WpSAait1b-oUo1L36G8bS_qUnt1rXTfAbtVngmJII-YP4r7YIgtTOCuSKd7euBSSTvquLu6rwp4oxacDZ4deoV0-gaY9H2lgRf6Z2wSJ7u4-iLEr-zLs8dE3uenkKyL1L-RXnS3I6MHe6w8X7d8dLT6-aeriGqnl0abL_goz9ocTdGxz4UNuSnRWubqitcvS8RALotBMUYP0ewgdan-lTwhtupueq-4WiZkBRrt0YTxjCZHfdlOaz5rw8vWbK4R2HDylq_Mhk5BUaas6LEujWl_Ndm13QdxxGAoQo9MXgz5h_fYF8vT5fX3v86WB4sLdf4xoadI9D-SeQPnR5q0OpxZwc-HzJOe8p2e6L_F_nMDbbY51DPF_SrwGzDYKZtKKa9tbl1M-rVS35MbTple6bznQJEbcVcJfrr44ruqLiuR4cy4Exqq6NRxxp2dcuyALatm3t8RM2OnxNQcN11fy17zROZNvlVAre-MN30_aFmninjVg.."
      name="lia-form-context" type="hidden"><input value="BlogArticlePage:blog-id/ExcelBlog/article-id/1626:searchformv32.form:" name="liaFormContentKey" type="hidden"><input
      value="yDZKQFNI0U/sd9X4pbUemqvQQZw=:H4sIAAAAAAAAALWSzUrDQBSFr4Wuigiib6DbiajdqAhFUISqweBaZibTNJpk4sxNEzc+ik8gvkQX7nwHH8CtKxfmzxJbwaTUVZhzw/nOmblP79COD+FAC6r40OAyQOWyCF0ZaMOkjtgrJgOp/NHONtER810sP9nfIkGtoCuVQ2hI+VAQpKHQqO67hEslPJcRRrUgPZaKlOOxKzx7wxIYhZtX487b+stnC5b60MnZ0junvkBY7d/QETU8GjiGlUYKnP0kRFguwEcFeAHBe02Dm0pyobWV+Wid0sbP9u7g4/G1BZCE8QWc1U3kpzapWoqZ+S+SvoMHgPQ+ypGVj/IoC2dlqHZ8CWZdV7xljUqszZa43voPYNHkFE7qGkdaqKrl1Pm7wEqmV59gcYjGkQOJP25h6jyJnOlzRv4DUURusIWhknbEsWo5K002vhzNufG1WHmDLwdzh8gDBQAA"
      name="t:formdata" type="hidden"></div>
  <div class="lia-inline-ajax-feedback">
    <div class="AjaxFeedback" id="feedback_567ba27c51bf2c"></div>
  </div>
  <input value="KmHFdQrIlzddKRXvxed7Bd9kDIjMD5_Rfq4YixN1FeA." name="lia-action-token" type="hidden">
  <input value="form_567ba27c51bf2c" id="form_UIDform_567ba27c51bf2c" name="form_UID" type="hidden">
  <input value="" id="form_instance_keyform_567ba27c51bf2c" name="form_instance_key" type="hidden">
  <span class="lia-search-input-wrapper">
    <span class="lia-search-input-field">
      <span class="lia-button-wrapper lia-button-wrapper-secondary lia-button-wrapper-searchForm-action"><input value="searchForm" name="submitContextX" type="hidden"><input class="lia-button lia-button-secondary lia-button-searchForm-action"
          value="Search" id="submitContext_567ba27c51bf2c" name="submitContext" type="submit"></span>
      <input placeholder="Search the community" aria-label="Search" title="Search" class="lia-form-type-text lia-autocomplete-input search-input lia-search-input-message" value="" id="messageSearchField_567ba27c51bf2c_0" name="messageSearchField"
        type="text" aria-autocomplete="both" autocomplete="off">
      <div class="lia-autocomplete-container" style="display: none; position: absolute;">
        <div class="lia-autocomplete-header">Enter a search word</div>
        <div class="lia-autocomplete-content">
          <ul></ul>
        </div>
        <div class="lia-autocomplete-footer">
          <a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="so578ZscE22H8USI7rb78LblzB8EL3ATJGLlWGZNnFQ." rel="nofollow" id="disableAutoComplete_567ba27c7f9437" href="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.disableautocomplete:disableautocomplete?t:ac=blog-id/ExcelBlog/article-id/1626/q-p/b2NpZDplbWxfY29yZV9jb25zX2NnY191c2dfZW1sX20zNjVST1dmZWF0dXJlc3Vuc2V0&amp;t:cp=action/contributions/searchactions">Turn off suggestions</a>
        </div>
      </div>
      <input placeholder="Search the community" aria-label="Search" title="Search" class="lia-form-type-text lia-autocomplete-input search-input lia-search-input-tkb-article lia-js-hidden" value="" id="messageSearchField_567ba27c51bf2c_1"
        name="messageSearchField_0" type="text" aria-autocomplete="both" autocomplete="off">
      <div class="lia-autocomplete-container" style="display: none; position: absolute;">
        <div class="lia-autocomplete-header">Enter a search word</div>
        <div class="lia-autocomplete-content">
          <ul></ul>
        </div>
        <div class="lia-autocomplete-footer">
          <a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="K26dZCUU1GfwAOjQw-nw6LtNfkYDGkBbHV_A-Q22fGk." rel="nofollow" id="disableAutoComplete_567ba27cf9c122" href="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.disableautocomplete:disableautocomplete?t:ac=blog-id/ExcelBlog/article-id/1626/q-p/b2NpZDplbWxfY29yZV9jb25zX2NnY191c2dfZW1sX20zNjVST1dmZWF0dXJlc3Vuc2V0&amp;t:cp=action/contributions/searchactions">Turn off suggestions</a>
        </div>
      </div>
      <input placeholder="Search all content" ng-non-bindable="" title="Enter a user name or rank" class="lia-form-type-text UserSearchField lia-search-input-user search-input lia-js-hidden lia-autocomplete-input"
        aria-label="Enter a user name or rank" value="" id="userSearchField_567ba27c51bf2c" name="userSearchField" type="text" aria-autocomplete="both" autocomplete="off">
      <div class="lia-autocomplete-container" style="display: none; position: absolute;">
        <div class="lia-autocomplete-header">Enter a user name or rank</div>
        <div class="lia-autocomplete-content">
          <ul></ul>
        </div>
        <div class="lia-autocomplete-footer">
          <a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="uNFbidTZXv8rO0a5c0mqEfzoTvBR1F8_YxW5I0iZPaY." rel="nofollow" id="disableAutoComplete_567ba27d24ee0a" href="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.disableautocomplete:disableautocomplete?t:ac=blog-id/ExcelBlog/article-id/1626/q-p/b2NpZDplbWxfY29yZV9jb25zX2NnY191c2dfZW1sX20zNjVST1dmZWF0dXJlc3Vuc2V0&amp;t:cp=action/contributions/searchactions">Turn off suggestions</a>
        </div>
      </div>
      <input title="Enter a search word" class="lia-form-type-text NoteSearchField lia-search-input-note search-input lia-js-hidden lia-autocomplete-input" aria-label="Enter a search word" value="" id="noteSearchField_567ba27c51bf2c_0"
        name="noteSearchField" type="text" aria-autocomplete="both" autocomplete="off">
      <div class="lia-autocomplete-container" style="display: none; position: absolute;">
        <div class="lia-autocomplete-header">Enter a search word</div>
        <div class="lia-autocomplete-content">
          <ul></ul>
        </div>
        <div class="lia-autocomplete-footer">
          <a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="MeqczXVdyHYxIyhPqYWZBZJ4j6SgFO9s8fDWnjnz5n4." rel="nofollow" id="disableAutoComplete_567ba27d4d7f4f" href="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.disableautocomplete:disableautocomplete?t:ac=blog-id/ExcelBlog/article-id/1626/q-p/b2NpZDplbWxfY29yZV9jb25zX2NnY191c2dfZW1sX20zNjVST1dmZWF0dXJlc3Vuc2V0&amp;t:cp=action/contributions/searchactions">Turn off suggestions</a>
        </div>
      </div>
      <input title="Enter a search word" class="lia-form-type-text ProductSearchField lia-search-input-product search-input lia-js-hidden lia-autocomplete-input" aria-label="Enter a search word" value="" id="productSearchField_567ba27c51bf2c"
        name="productSearchField" type="text" aria-autocomplete="both" autocomplete="off">
      <div class="lia-autocomplete-container" style="display: none; position: absolute;">
        <div class="lia-autocomplete-header">Enter a search word</div>
        <div class="lia-autocomplete-content">
          <ul></ul>
        </div>
        <div class="lia-autocomplete-footer">
          <a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="7KCpL5Hs_941Jgzls2olf9ISj1j5UTB3KJ3ehXASCso." rel="nofollow" id="disableAutoComplete_567ba27d784dad" href="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.disableautocomplete:disableautocomplete?t:ac=blog-id/ExcelBlog/article-id/1626/q-p/b2NpZDplbWxfY29yZV9jb25zX2NnY191c2dfZW1sX20zNjVST1dmZWF0dXJlc3Vuc2V0&amp;t:cp=action/contributions/searchactions">Turn off suggestions</a>
        </div>
      </div>
      <input class="lia-as-search-action-id" name="as-search-action-id" type="hidden">
    </span>
  </span>
  <span class="lia-cancel-search" tabindex="0">cancel</span>
</form>

Name: form — POST https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.searchformv32.form.form

<form enctype="multipart/form-data" class="lia-form lia-form-inline SearchForm" action="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.searchformv32.form.form" method="post" id="form" name="form">
  <div class="t-invisible"><input value="blog-id/ExcelBlog/article-id/1626/q-p/b2NpZDplbWxfY29yZV9jb25zX2NnY191c2dfZW1sX20zNjVST1dmZWF0dXJlc3Vuc2V0" name="t:ac" type="hidden"><input value="search/contributions/page" name="t:cp" type="hidden"><input
      value="An3WaJpon9QpEeh0FNN26uPzkKdynuWxzBn0kFgS1_TAYn4AL-ll6H2_PdKsmdNmJ6bqArwqzcnEk5nBzo6ZjieCWJ2KiAWo6p65H-8i7Oyghd6EHUHRfT7FQHgbqZhSwBm1E99a0n274_t1Gdro0NjvLwgU7NxrtEKUKpvtR5eHkl8VFvVooaHmCZwtCHuvJJ40TpFaY_kpOx26x9Bvj5nLloCQQu9m2dp3q8JA0WADaozKDIEyvdwbpkKZEeOgOL4Ok76pz7snch4EhhCfUNCvrcPprP5SD2eugk6bBzkTtqT8mE9UaCKMZWVjsSZThFabx7mK1CmV-a_To1lxj71Gr6hOG9PwU7Iq7PsCOm2933KFhqaNoonF4qVdbcDSP8-9kbdPO7ty1U9N9nofiTQRg8rw1uP9ZxqJIDZvhRe1s82_DXgu3QrRM9YVyH8o-x3gTL8xRRz_31kzTVuSl2OWvcDnEZIFEUOYm7aoN6OHxDn3NFJ0ICBo5bLKwAaP2DFgj71znJ8J3YmSwXYeqt6nywb2JPB8qQ88Or-CXDtDLtvvyL-wVY0o-M2VKX-T8SEJms6sQvwdLtTyp-H3lKOKGOFXvUWAF49DE2hHWL6q10yWZdocHsAm3ijIKBv0-INJnxKLb-GPePDHTucaQvgSkU_gwXbAbj86SiMgnInC9Nxmz85tqugS7kwGQexzqsVvv4UCnGreyJnXe0_RtS9eJ5C2jGBDpJ08j300caxnpOxzVc_FvB_T_2dKyy-cFwEMgdDtuBHZvJVWUjgLkI2Mahpi_yqSClYq44oUZHkBiPoYR8BKShC9kvFhJydR8cfIDlwMNaeiq1rQUm8eGt-vv41Gr1X_vck1LavATLcXEomtMgrAi0px-rbJZYS48W_B5pvLQau0NPZsbZ8m_NlpAnEpXzW0NS2clpNmF_nDiT4xCcepmD9epbp-OAVuqyBkTJM627PimQQnhyT8Q_n6zPIMkI3kV_dhZs9uAuFRg9YRgcD5tM-iQ0_WOtdQ_v-v95bMCQR-UMnyV4SPw03a_eI6GPGV8_5IDUT6SR4n6n9B3v7FDGnlATmsx8zONb_K2G5XxcaDwrFdbsUbnY4y5wTJY9Fjbsv4vslo6J2Om4-AIFJHoKCz2z4XeTNYWs0pvsPlhI5K7X8VJJrmzuv9eL8dUorIxWk16IzOuo0."
      name="lia-form-context" type="hidden"><input value="BlogArticlePage:blog-id/ExcelBlog/article-id/1626:searchformv32.form:" name="liaFormContentKey" type="hidden"><input
      value="yDZKQFNI0U/sd9X4pbUemqvQQZw=:H4sIAAAAAAAAALWSzUrDQBSFr4Wuigiib6DbiajdqAhFUISqweBaZibTNJpk4sxNEzc+ik8gvkQX7nwHH8CtKxfmzxJbwaTUVZhzw/nOmblP79COD+FAC6r40OAyQOWyCF0ZaMOkjtgrJgOp/NHONtER810sP9nfIkGtoCuVQ2hI+VAQpKHQqO67hEslPJcRRrUgPZaKlOOxKzx7wxIYhZtX487b+stnC5b60MnZ0junvkBY7d/QETU8GjiGlUYKnP0kRFguwEcFeAHBe02Dm0pyobWV+Wid0sbP9u7g4/G1BZCE8QWc1U3kpzapWoqZ+S+SvoMHgPQ+ypGVj/IoC2dlqHZ8CWZdV7xljUqszZa43voPYNHkFE7qGkdaqKrl1Pm7wEqmV59gcYjGkQOJP25h6jyJnOlzRv4DUURusIWhknbEsWo5K002vhzNufG1WHmDLwdzh8gDBQAA"
      name="t:formdata" type="hidden"></div>
  <div class="lia-inline-ajax-feedback">
    <div class="AjaxFeedback" id="feedback"></div>
  </div>
  <input value="PwTHh0AhfRW_Tb-vguKO74Xck51qq_j5yFVlqjuneLc." name="lia-action-token" type="hidden">
  <input value="form" id="form_UIDform" name="form_UID" type="hidden">
  <input value="" id="form_instance_keyform" name="form_instance_key" type="hidden">
  <span class="lia-search-input-wrapper">
    <span class="lia-search-input-field">
      <span class="lia-button-wrapper lia-button-wrapper-secondary lia-button-wrapper-searchForm-action"><input value="searchForm" name="submitContextX" type="hidden"><input class="lia-button lia-button-secondary lia-button-searchForm-action"
          value="Search" id="submitContext" name="submitContext" type="submit"></span>
      <input placeholder="Search the community" aria-label="Search" title="Search" class="lia-form-type-text lia-autocomplete-input search-input lia-search-input-message" value="" id="messageSearchField_0" name="messageSearchField" type="text"
        aria-autocomplete="both" autocomplete="off">
      <div class="lia-autocomplete-container" style="display: none; position: absolute;">
        <div class="lia-autocomplete-header">Enter a search word</div>
        <div class="lia-autocomplete-content">
          <ul></ul>
        </div>
        <div class="lia-autocomplete-footer">
          <a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="-tRaIsZTRTGCDS6LvxoPONmcSLKspAMiKUKnLmw7C3s." rel="nofollow" id="disableAutoComplete_567ba27df73dd6" href="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.disableautocomplete:disableautocomplete?t:ac=blog-id/ExcelBlog/article-id/1626/q-p/b2NpZDplbWxfY29yZV9jb25zX2NnY191c2dfZW1sX20zNjVST1dmZWF0dXJlc3Vuc2V0&amp;t:cp=action/contributions/searchactions">Turn off suggestions</a>
        </div>
      </div>
      <input placeholder="Search the community" aria-label="Search" title="Search" class="lia-form-type-text lia-autocomplete-input search-input lia-search-input-tkb-article lia-js-hidden" value="" id="messageSearchField_1"
        name="messageSearchField_0" type="text" aria-autocomplete="both" autocomplete="off">
      <div class="lia-autocomplete-container" style="display: none; position: absolute;">
        <div class="lia-autocomplete-header">Enter a search word</div>
        <div class="lia-autocomplete-content">
          <ul></ul>
        </div>
        <div class="lia-autocomplete-footer">
          <a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="-HCOMJES-m_OXRufNuOrkAtC4ZKJXq0TcSVLtTwDTAI." rel="nofollow" id="disableAutoComplete_567ba27e22c2a4" href="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.disableautocomplete:disableautocomplete?t:ac=blog-id/ExcelBlog/article-id/1626/q-p/b2NpZDplbWxfY29yZV9jb25zX2NnY191c2dfZW1sX20zNjVST1dmZWF0dXJlc3Vuc2V0&amp;t:cp=action/contributions/searchactions">Turn off suggestions</a>
        </div>
      </div>
      <input placeholder="Search all content" ng-non-bindable="" title="Enter a user name or rank" class="lia-form-type-text UserSearchField lia-search-input-user search-input lia-js-hidden lia-autocomplete-input"
        aria-label="Enter a user name or rank" value="" id="userSearchField" name="userSearchField" type="text" aria-autocomplete="both" autocomplete="off">
      <div class="lia-autocomplete-container" style="display: none; position: absolute;">
        <div class="lia-autocomplete-header">Enter a user name or rank</div>
        <div class="lia-autocomplete-content">
          <ul></ul>
        </div>
        <div class="lia-autocomplete-footer">
          <a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="CIva22mW9koLwNNo3tQNkd98JnOiutSxM8nnUf1Fhjw." rel="nofollow" id="disableAutoComplete_567ba27e4b1ba8" href="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.disableautocomplete:disableautocomplete?t:ac=blog-id/ExcelBlog/article-id/1626/q-p/b2NpZDplbWxfY29yZV9jb25zX2NnY191c2dfZW1sX20zNjVST1dmZWF0dXJlc3Vuc2V0&amp;t:cp=action/contributions/searchactions">Turn off suggestions</a>
        </div>
      </div>
      <input title="Enter a search word" class="lia-form-type-text NoteSearchField lia-search-input-note search-input lia-js-hidden lia-autocomplete-input" aria-label="Enter a search word" value="" id="noteSearchField_0" name="noteSearchField"
        type="text" aria-autocomplete="both" autocomplete="off">
      <div class="lia-autocomplete-container" style="display: none; position: absolute;">
        <div class="lia-autocomplete-header">Enter a search word</div>
        <div class="lia-autocomplete-content">
          <ul></ul>
        </div>
        <div class="lia-autocomplete-footer">
          <a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="SqOdMWxQbFmQ46Pr0b0okIzbKjABKbRxs9s7upX1324." rel="nofollow" id="disableAutoComplete_567ba27eac6f7a" href="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.disableautocomplete:disableautocomplete?t:ac=blog-id/ExcelBlog/article-id/1626/q-p/b2NpZDplbWxfY29yZV9jb25zX2NnY191c2dfZW1sX20zNjVST1dmZWF0dXJlc3Vuc2V0&amp;t:cp=action/contributions/searchactions">Turn off suggestions</a>
        </div>
      </div>
      <input title="Enter a search word" class="lia-form-type-text ProductSearchField lia-search-input-product search-input lia-js-hidden lia-autocomplete-input" aria-label="Enter a search word" value="" id="productSearchField"
        name="productSearchField" type="text" aria-autocomplete="both" autocomplete="off">
      <div class="lia-autocomplete-container" style="display: none; position: absolute;">
        <div class="lia-autocomplete-header">Enter a search word</div>
        <div class="lia-autocomplete-content">
          <ul></ul>
        </div>
        <div class="lia-autocomplete-footer">
          <a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="agKSazDHclELFY1u7kXekxPZQLK30Sll13Uft-cr7hk." rel="nofollow" id="disableAutoComplete_567ba27eddd069" href="https://techcommunity.microsoft.com/t5/blogs/v2/blogarticlepage.disableautocomplete:disableautocomplete?t:ac=blog-id/ExcelBlog/article-id/1626/q-p/b2NpZDplbWxfY29yZV9jb25zX2NnY191c2dfZW1sX20zNjVST1dmZWF0dXJlc3Vuc2V0&amp;t:cp=action/contributions/searchactions">Turn off suggestions</a>
        </div>
      </div>
      <input class="lia-as-search-action-id" name="as-search-action-id" type="hidden">
    </span>
  </span>
  <span class="lia-cancel-search">cancel</span>
</form>

Text Content

We use optional cookies to improve your experience on our websites, such as
through social media connections, and to display personalized advertising based
on your online activity. If you reject optional cookies, only cookies necessary
to provide you the services will be used. You may change your selection by
clicking “Manage Cookies” at the bottom of the page. Privacy Statement
Third-Party Cookies

Accept Reject Manage cookies


Skip to main content

Microsoft

Tech Community

Home

Community Hubs

Community Hubs
 * Community Hubs Home
 * Products
 * Special Topics
 * Video Hub

Close


PRODUCTS (68)


SPECIAL TOPICS (41)


VIDEO HUB (865)


MOST ACTIVE HUBS

Microsoft Teams
Microsoft Excel
Windows
Security, Compliance and Identity
Office 365
SharePoint
Windows Server
Azure
Exchange
Microsoft 365
Microsoft Edge Insider
.NET
Sharing best practices for building any app with .NET.
Microsoft FastTrack
Best practices and the latest news on Microsoft FastTrack
Microsoft Viva
The employee experience platform to help people thrive at work


MOST ACTIVE HUBS

ITOps Talk
Core Infrastructure and Security
Microsoft Learn
Education Sector
Microsoft 365 PnP
AI and Machine Learning
Microsoft Mechanics
Healthcare and Life Sciences
Small and Medium Business
Public Sector
Internet of Things (IoT)
Azure Partner Community
Expand your Azure partner-to-partner network
Microsoft Tech Talks
Bringing IT Pros together through In-Person & Virtual events
MVP Award Program
Find out more about the Microsoft MVP Award Program.


VIDEO HUB

Azure
Exchange
Microsoft 365
Microsoft 365 Business
Microsoft 365 Enterprise
Microsoft Edge
Microsoft Outlook
Microsoft Teams
Security
SharePoint
Windows
Browse All Community Hubs

Blogs

Blogs

Events

Events
 * Events Home
 * Microsoft Ignite
 * Microsoft Build
 * Community Events

Microsoft Learn

Microsoft Learn
 * Home
 * Community
 * Blog
 * Azure
 * Dynamics 365
 * Microsoft 365
 * Security, Compliance & Identity
 * Power Platform
 * Github
 * Teams
 * .NET


Lounge

Lounge
 * 867K Members
 * 3,994 Online
 * 247K Discussions

Search
Enter a search word

Turn off suggestions
Enter a search word

Turn off suggestions
Enter a user name or rank

Turn off suggestions
Enter a search word

Turn off suggestions
Enter a search word

Turn off suggestions
cancel
Turn on suggestions
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Sign In

Sign In




Enter a search word

Turn off suggestions
Enter a search word

Turn off suggestions
Enter a user name or rank

Turn off suggestions
Enter a search word

Turn off suggestions
Enter a search word

Turn off suggestions
cancel
Turn on suggestions
Showing results for 
Show  only  | Search instead for 
Did you mean: 



 * Home
 * Microsoft Excel
 * Excel Blog
 * Announcing Power Query Data Types

 * Back to Blog
 * Newer Article
 * Older Article




ANNOUNCING POWER QUERY DATA TYPES

 * Subscribe to RSS Feed
 * 
 * Mark as New
 * Mark as Read
 * 
 * Bookmark
 * Subscribe
 * 
 * Email to a Friend
 * 
 * Printer Friendly Page
 * Report Inappropriate Content


By
Jonathan Kahati
Published Oct 29 2020 05:58 AM 38.8K Views
Skip to footer content
jokahati
Microsoft
‎Oct 29 2020 05:58 AM


ANNOUNCING POWER QUERY DATA TYPES

‎Oct 29 2020 05:58 AM

We are excited to announce a new and exciting update to Get & Transform Data
capabilities in Excel – Power Query data types! This tool will help you organize
your data better and consume it easily.

 

Power Query data types are available as part of an Office 365 subscription. If
you are an Office 365 subscriber, find out how to get the latest updates.

 

The following sections describe how create data types with Power Query and how
to consume them in Excel.

 

Power Query data types 

Power Query is a powerful and time-saving tool used to gather and analyze large
sets of data by organizing them in a way that will make its consumption in Excel
much easier. With this feature, you can create custom data types from any and
load them in the Excel grid as rich values.  

 

How to use it 

 1. Start with importing the data set using Power Query.
    
    
    
    
 2. In the Power Query Editor, select the relevant columns, and then click
    the Create Data Type button on the Transform tab.
    
    
    
    
 3. Define the data type name and choose a display column.
    
    
    
    
 4. Notice the selected columns are collapsed into a single data type column and
    click the Close and Load button on the Home tab to load the query into
    Excel.
    
    
    
    
 5. Easily consume and explore the output of the query in Excel with interactive
    data cards and formulas that reference your rich values.
    
    
    
    
    

 

Scenarios to try

Interact with the data types:

Check out the data type fields by clicking the  icon the cell, and then open the
associated card.

Extract fields to the grid by clicking the  button. Use the data type fields in
Excel formulas by referencing to a cell with a data type.

Refresh data types by clicking the   button – from the data type context menu,
the respective query context menu, or the Data tab in the Excel ribbon.


 

Requirements
To use Power Query data types in Excel, you must meet these requirements:
• You are in an organization with an Office 365 subscription.
• You are using Excel for Windows.


 

More Resources
Check out this video from one of Microsoft Excel’s Creators, Mynda Treacy from
MyOnlineTrainingHub:


 







 


Microsoft Creators are community experts who create video content on YouTube
that can help you learn how to use Microsoft products and services. Their
content appears in the following playlists on the Microsoft 365 channel.


 

Customer Feedback
We hope you like this new addition to Excel and we’d love to hear what you think
about it!

Let us know by using the Feedback button in the top right corner in Excel -
add #PowerQuery in your feedback so that we can find it easily.
For more activities, join the conversations in our Excel Tech Community at
aka.ms/ExcelCommunity.

 

Jonathan Kahati
~ Excel Team

11 Likes
Like




19 Comments
Sergei Baklan
MVP
‎Oct 29 2020 02:27 PM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Oct 29 2020 02:27 PM

@jokahati , great to know it's GA now. On which channels this functionality is
available?

1 Like
Like




Mynda Treacy
MVP
‎Oct 29 2020 02:27 PM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Oct 29 2020 02:27 PM

Awesome to have Custom Data Types available in Excel. Congratulations to the
Excel Team!

 

Mynda

3 Likes
Like




Sergei Baklan
MVP
‎Oct 29 2020 02:35 PM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Oct 29 2020 02:35 PM

@Mynda Treacy , everyone in this world who knows something about Excel knows you
as Excel MVP, but why don't you ask techcommunity@microsoft.com to change your
status on this resource accordingly. @cuong ?

2 Likes
Like




Mynda Treacy
MVP
‎Oct 29 2020 03:14 PM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Oct 29 2020 03:14 PM

@Sergei Baklan great idea! Thanks for mentioning it. Hopefully @cuong can make
it happen.

1 Like
Like




cuong
Microsoft
‎Oct 29 2020 05:26 PM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Oct 29 2020 05:26 PM

@Mynda Treacy Done. Thanks to the Tech Community team!

1 Like
Like




jokahati
Microsoft
‎Nov 01 2020 08:30 AM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Nov 01 2020 08:30 AM

@Sergei Baklan Thanks!

Current Channel - rolling to Production as we speak.

MEC should follow, so estimating a few weeks.

Semi-Annual - next year, not sure yet if Jan/Jun (depends on stability and other
factors).

1 Like
Like




James Fitch
New Contributor
‎Nov 03 2020 03:39 AM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Nov 03 2020 03:39 AM

This is a real game changer. Not as big as Power Query (of which this is a
capability enhancement), but bigger than dynamic arrays (which rocked our small
company’s world). I’ve been trying to hold my breath about its GA release since
I saw Mynda’s preview on YouTube. Now, I will exhale & breathe. Well done, Excel
Team!

2 Likes
Like




Phil Trick
Frequent Visitor
‎Dec 29 2020 12:11 PM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Dec 29 2020 12:11 PM

Custom Data Types cannot have hierarchical records without flattening them out
first and re-creating a new custom object.

 

Another missing feature is a tie-in with dynamic arrays. A Custom Data Type with
a List object within one of the properties would be an exceptional opportunity.

 

Any chance these types of features are in the works?

1 Like
Like




jokahati
Microsoft
‎Jan 06 2021 05:51 AM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Jan 06 2021 05:51 AM

Hey @Phil Trick ,

Are you referring to nesting of data types? 

For example, a data type that is included within a data type (this could be a
list within a data type, as you mentioned).

If so, it is indeed part of our next phase for PQ data types. Keep following
Excel publications

0 Likes
Like




DS_London
Occasional Contributor
‎Jan 20 2021 09:04 AM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Jan 20 2021 09:04 AM

Will there be a "DataType supplier" interface at some point? For example, the
industry standard for some sectors of the financial markets is Bloomberg, which
has its own API for accessing data. Ideally one would be able to create a "Bond"
datatype (for example) and have its details (ISIN code, coupon, maturity, yield
and price history) loaded from Bloomberg.

Put another way, what does a data source have to do to make itself accessible to
the new DataType functionality?

Is the compound data saved with the Workbook, or does Excel have to reload each
time the Workbook is opened?



Will DataTypes be accessible/understood by VBA or the C-API? ie can we programme
with them? Currently if I try to pass a range containing one of the new
DataTypes to VBA, the parameter simply contains an error code (2015). 

Maybe this is the first step towards Excel being able to hold "state"?
Developers of financial (and other) analytic software aimed at Excel usually
have to build a "handle" layer, whereby the reference to a complex structure
held in memory (eg might be a simulation result set, or a yield curve etc) is
stored in an Excel cell (most commonly as a string with a calculation counter).
This handle is then passed to the analytics function, which uses it to find the
object's data in memory. It is clunky but necessary as Excel is (was?)
restricted to holding single built-in types in a cell. 

0 Likes
Like




jokahati
Microsoft
‎Jan 27 2021 03:01 AM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Jan 27 2021 03:01 AM

Hey @DS_London ,

 

Thanks for the feedback.

These are all great ideas, and we are actually considering them for the future.

Regarding reloading data - we do save the data accessed in the workbook.

0 Likes
Like




Leo_Rivas
Senior Member
‎Mar 23 2021 07:17 PM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Mar 23 2021 07:17 PM

Wow, qué interesante, estaré haciendo pruebas. Felicidades Excel y @Mynda
Treacy , she is a wonderful teacher!

3 Likes
Like




Arun Kumar
Occasional Visitor
‎Dec 15 2021 08:03 PM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Dec 15 2021 08:03 PM

Hi,

 

I am not able to see this option, pasting below the version of excel I am using.

 



Can anyone help me out to understand and fix the issue?

 

Thank you,

Arun

0 Likes
Like




jokahati
Microsoft
‎Dec 15 2021 10:23 PM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Dec 15 2021 10:23 PM

Hi @Arun Kumar ,

 

Power Query data types will be included in the next Semi-Annual release
(January), so you should be able to use it pretty soon.

1 Like
Like




weav8060
Senior Member
‎Jan 28 2022 07:32 PM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Jan 28 2022 07:32 PM

interesting, but honestly, who would have predicted what these 'data types' were
all about.  It's a managed information card.  Wish presenters and software folks
could define their subject properly so one doesn't have to spend ten minutes
deciding whether it is in my ball park or not.    

0 Likes
Like




IronyOfFate
Visitor
‎Jun 02 2022 06:38 AM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Jun 02 2022 06:38 AM

@jokahati Is there already a release of the Power Query data types?
I am using version 2108("latest version in the group") and unfortunately I don't
have access yet. 

0 Likes
Like




jokahati
Microsoft
‎Jun 07 2022 05:22 AM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Jun 07 2022 05:22 AM

@IronyOfFate could you share info about your subscription and version of Excel?

It should be available.

0 Likes
Like




IronyOfFate
Visitor
‎Jun 07 2022 06:09 AM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Jun 07 2022 06:09 AM

@jokahati 




 

0 Likes
Like




jokahati
Microsoft
‎Jun 08 2022 11:02 PM
 * Mark as Read
 * Mark as New
 * 
 * Bookmark
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

‎Jun 08 2022 11:02 PM

@IronyOfFate Please try to update your Excel version again. 
If that doesn't help, please Email me.

0 Likes
Like





You must be a registered user to add a comment. If you've already registered,
sign in. Otherwise, register and sign in.

 * Comment

Version history
Last update:
‎Oct 19 2020 11:09 AM
Updated by:
cuong


Labels
 * Excel 133
 * Power Query 9




SHARE

 * Share to LinkedIn
 * Share to Facebook
 * Share to Twitter
 * Share to Email




Browse

Skip to primary navigation

WHAT'S NEW

 * Surface Pro X
 * Surface Laptop 3
 * Surface Pro 7
 * Windows 10 Apps
 * Office apps

MICROSOFT STORE

 * Account profile
 * Download Center
 * Microsoft Store support
 * Returns
 * Order tracking
 * Store locations
 * Buy online, pick up in store
 * In-store events

EDUCATION

 * Microsoft in education
 * Office for students
 * Office for schools
 * Deals for students and parents
 * Microsoft Azure in education

ENTERPRISE

 * Azure
 * AppSource
 * Automotive
 * Government
 * Healthcare
 * Manufacturing
 * Financial Services
 * Retail

DEVELOPER

 * Microsoft Visual Studio
 * Window Dev Center
 * Developer Network
 * TechNet
 * Microsoft developer program
 * Channel 9
 * Office Dev Center
 * Microsoft Garage

COMPANY

 * Careers
 * About Microsoft
 * Company News
 * Privacy at Microsoft
 * Investors
 * Diversity and inclusion
 * Accessibility
 * Security

 * Sitemap
 * Contact Microsoft
 * Privacy
 * Manage cookies
 * Terms of use
 * Trademarks
 * Safety and eco
 * About our ads
 * © 2022 Microsoft

Auto-suggest helps you quickly narrow down your search results by suggesting
possible matches as you type.

Auto-suggest helps you quickly narrow down your search results by suggesting
possible matches as you type.