Excel & SharePoint
✓ Fixes "No Table Found" & 6-Min File Locks
Setup: ~3 mins
Read Any SharePoint / Email Excel (.xlsx) Without Creating an Excel Table
Automatically parse multi-sheet .xlsx attachments arriving in Outlook or SharePoint into clean typed JSON rows — zero Ctrl+T Table formatting, zero 256-row pagination limits, and zero SharePoint file locks.
Why Makers Use This Blueprint: Standard Excel Online (Business) actions fail whenever an external supplier sends a raw .xlsx spreadsheet without a named Excel Table, and lock the SharePoint file for up to 6 minutes.
Cloud Flow Architecture (Trigger → Zetaleap → Destination)
STEP 01 • Microsoft Outlook / SharePoint
Capture Raw .xlsx Bytes
Read attachment contentBytes or SharePoint Get file content ($content).
STEP 02 • Zetaleap Automation Pack
POST /api/automation/xlsx-to-json
Converts raw Base64 .xlsx bytes into clean JSON objects in <20ms with automatic header normalization.
STEP 03 • SharePoint / Dataverse
Loop Over Rows & Insert Records
Map clean row keys directly without fragile expression casting.
Power Automate HTTP Action Definition (
POST /api/automation/xlsx-to-json)
Replace
zl_YOUR_API_KEY with your free Personal Access Token from /profile — or import the typed Custom Connector at /connectors.{
"type": "Http",
"inputs": {
"method": "POST",
"uri": "https://zetaleap.com/api/automation/xlsx-to-json",
"headers": {
"Authorization": "Bearer zl_YOUR_API_KEY",
"Content-Type": "application/json"
},
"body": {
"xlsxBase64": "@{base64(outputs('Get_file_content')?['body'])}",
"hasHeaderRow": true
}
}
}
Returned Dynamic Output Tokens
sheets[].namerows[]rowCountheaders[]