Power Automate Http request an Excel

[Simon.PA]

Hello everyone, I am trying to send data via the Http request, i.e. the graph api, because add rows in power automate cloud is too slow for me. The following data is displayed as input from the select step to the http step:



"Uri": "https://graph.microsoft.com/v1.0/me...JHYOK377UXARWIC/workbook/tables/Tabelle1/rows",
"Method": "POST",
"Body": "{\n\"values\": [{\"Umsatz\":\"1111\",\"Bu-Text\":\"test\"},{\"Umsatz\":\"26.59\",\"Bu-Text\":\"test\"},{\"Umsatz\":\"1056.13\",\"Bu-Text\":\"test\"}]\n}",
"ContentType": "application/json"
}
Code view:

"type": "OpenApiConnection",
"inputs": {
"parameters": {
"Uri": "https://graph.microsoft.com/v1.0/me/drive/items/@{outputs('Copy_file')?['body/Id']}/workbook/tables/Tabelle1/rows",
"Method": "POST",
"Body": "{\n\"values\": @{body('Select')}\n}",
"ContentType": "application/json"
},
"host": {
"apiId": "/providers/Microsoft.PowerApps/apis/shared_office365users",
"connection": "shared_office365users",
"operationId": "HttpRequest"
}
},
"runAfter": {
"Select": [
"Succeeded"
]
}
}

In the Uri after items i use the "Id" identifier for the excel i wanted to write.

This is the output messages.
Headers:

{
"Transfer-Encoding": "chunked",
"Vary": "Accept-Encoding",
"Strict-Transport-Security": "max-age=31536000",
"request-id": "14d90a90-4dc7-43a5-bbee-54596768fa03",
"client-request-id": "14d90a90-4dc7-43a5-bbee-54596768fa03",
"x-ms-ags-diagnostic": "{\"ServerInfo\":{\"DataCenter\":\"Germany West Central\",\"Slice\":\"E\",\"Ring\":\"4\",\"ScaleUnit\":\"000\",\"RoleInstance\":\"FR1PEPF000018E6\"}}",
"x-ms-environment-id": "default-e10a9c97-6c83-4090-b7be-56eefcc121c7",
"x-ms-tenant-id": "e10a9c97-6c83-4090-b7be-56eefcc121c7",
"x-ms-dlp-re": "-|-",
"x-ms-dlp-gu": "-|-",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"Date": "Fri, 31 Jan 2025 08:48:30 GMT",
"Content-Type": "application/json",
"Content-Length": "283"
}

body:

{
"error": {
"code": "invalidRequest",
"message": "Invalid request",
"innerError": {
"date": "2025-01-31T08:48:31",
"request-id": "14d90a90-4dc7-43a5-bbee-54596768fa03",
"client-request-id": "14d90a90-4dc7-43a5-bbee-54596768fa03"
}
}
}

Even with this URI i tried it and its not working: "Uri": "https://graph.microsoft.com/v1.0/me/drive/items/split(actions('Copy_file')?['inputs']?['parameters']?['file'],'.')?[1]/workbook/tables/Tabelle1/rows",.

Does anyone know what might be causing this issue or how I can resolve it? Any help would be greatly appreciated!

Thanks in advance!

 

[wirelessy]

You seem to be a paying customer of that software.
What does the vendor support say to this, have you contacted him?