Power Automate Http request an Excel

Simon.PA

Newbie
Registriert
Jan. 2025
Beiträge
1
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!
 

Anhänge

  • Screenshot 2025-01-31 095844.png
    Screenshot 2025-01-31 095844.png
    20,1 KB · Aufrufe: 46
Zurück
Oben