Azure drive error in assessment sandbox

Duane Billue 0 Reputation points
2026-11-19T16:48:13.9533333+00:00

Anyone else experiencing this issue while taking an assessment? The Power Automate flows are not being saved. Please see attachment. I guess I will try it again in 72 hours.

User's image

Regards,

Duane Billue

Azure | Azure Training

1 answer

Sort by: Most helpful
  1. AI answer

    2026-11-19T16:49:15.66+00:00

    Replace the custom Location value in List rows present in a table with the SharePoint site selected from the dropdown, then select Shared Documents and browse to opportunities.xlsx using the file picker.

    Correct the Excel action

    The screenshot shows Location populated with a combined value similar to:

    sites/https://…sharepoint.com/sites/Corp:/Shared Documents:

    That is not a valid drive selection for this field and corresponds directly to the displayed “provided drive id appears to be malformed” error.

    If the assessment session is still open:

    1. Open List rows present in a table.
    2. Clear the current Location value.
    3. Open the Location dropdown and select the sandbox’s Corp SharePoint site. Do not paste a URL, path, or dynamic value.
    4. Under Document Library, select Shared Documents from its dropdown.
    5. Under File, use the file picker to browse to opportunities.xlsx.
    6. Select the workbook’s table from the Table dropdown.
    7. Select Save. The action should load its table metadata without the GetTable HTTP 400 error.

    The Excel Online (Business) connector supports SharePoint document libraries and expects the file to be selected with the file picker, supplied through a SharePoint Id/Identifier, or entered as a path relative to the selected drive—not as a site URL combined with the library path.^1^

    If Table remains empty after the drive is corrected, open the workbook and verify that its data is an actual Excel table. Select the data and use Insert > Table, then return to the flow and select that table.^2^

    If the assessment has already ended

    Assessment labs cannot be saved and resumed. After leaving, the same lab environment cannot be reopened because scoring begins when the session ends.^3^

    A cancelled or abruptly ended lab still counts as an attempt. The normal Applied Skills retake becomes available 72 hours after the previous attempt.^4^

    Because the screenshot records a sandbox configuration failure, submit it to Credentials Support rather than only waiting and hoping the next instance differs:

    • Include the assessment name, attempt date/time, screenshot, and exact error: DynamicOperationRequestClientFailure, GetTable, HTTP 400, and “provided drive id appears to be malformed.”
    • Explain that the supplied sandbox task/file location prevented the Power Automate flow from being saved.
    • Do not include the temporary sandbox username, password, tenant ID, or other credentials.

    Microsoft directs other Applied Skills assessment issues to Credentials Support.^5^ If challenging the assessment result itself, the candidate agreement allows 15 days from the assessment date.^6^


    References

    1. Excel Online (Business) - Connectors | Microsoft Learn
    2. Unable to find Excel Online table in Microsoft Flow
    3. Assessment lab frequently asked questions
    4. Exam and Applied Skills assessment lab retake policies
    5. Credentials support
    6. Microsoft Applied Skills Lab Assessment Candidate Agreement
    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.