Update Test outcome/import run results via Excel in ADO devops

Samantha Pokpas 0 Reputation points
2023-10-25T05:52:14.1866667+00:00

I have exported a testsuite from ADO.

There are test cases which contains steps and some do not.

Business testers do not have access to ADO and have updated the sheet as per below

Testcases which do not contain steps contain have the below columns added

  • A column with comments
  • A column with a sharepoint link for screenshots
  • A column with the test Outcome ie Pass/Fail

Testcases which contain steps contain have the below columns added

  • A column with comments
  • A column with a sharepoint link for screenshots
  • A column with the test Outcome ie Pass/Fail.
    • The test outcome is on the 1st line and
    • Every executed step contains a test outcome in the same column
    I want to use this information from excel to
    1. Create bugs/enquiries for failed test cases
    2. Update test Step outcome
    3. Update Test outcome for the
    How do I upload this excel to ADO to update the outcome. I have the integration tool installed and have VS 2022 installed.
Azure DevTest Labs
Azure DevTest Labs
An Azure service that is used for provisioning development and test environments.
261 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. KarishmaTiwari-MSFT 18,667 Reputation points Microsoft Employee
    2023-10-28T00:51:54.8666667+00:00

    @Samantha Pokpas

    Currently, Azure DevOps is not supported on Microsoft Q&A. Please check this [supported products list here] (more to be added later on).

    The Azure DevOps team and community are active and answering questions on https://developercommunity.visualstudio.com/spaces/21/index.html
    I would recommend posting your question there and DevOps experts will guide you.

    You can also ask for help on Stack overflow: https://stackoverflow.com/questions/tagged/azure-devops
    or request for support here: https://azure.microsoft.com/en-us/support/devops/215816-image.png

    If you have any further queries related to Q&A supported services, do let me know in the comments.

    0 comments No comments