Training: Instruction to develop new skills.
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:
- Open List rows present in a table.
- Clear the current Location value.
- Open the Location dropdown and select the sandbox’s Corp SharePoint site. Do not paste a URL, path, or dynamic value.
- Under Document Library, select Shared Documents from its dropdown.
- Under File, use the file picker to browse to
opportunities.xlsx. - Select the workbook’s table from the Table dropdown.
- Select Save. The action should load its table metadata without the
GetTableHTTP 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