Share
Report
194Hello together I have the following problem
I have written an Excel import function that has actually always worked but now not.
The user can upload an excel in sharepoint and then import an excel
The import start ("Import Starten") is formatted by me this is the code:
{
"elmType": "button",
"txtContent": "Import Starten",
"customRowAction": {
"action": "executeFlow",
"actionParams": "{\"id\": \"06cd929f-aec8-4ebb-899f-d85c4fbf8cee\"}"
}
}
The error message is in the first line
I have entered the code of the first line in the explorer
I searched the area with $ref and found the following 2 entries
I have also linked to the corresponding Power Automate workflow.
I think the error could be in the first two steps but I'm not sure.
Enclosed the steps from PowerAutomate
1. for a selected file ("Für eine ausgewählte Datei")
also the corresponding preview code
{
"kind": "ApiConnection",
"splitOn": "@triggerBody()['rows']",
"inputs": {
"schema": {
"type": "object",
"properties": {
"rows": {
"type": "array",
"items": {
"type": "object",
"properties": {
"entity": {
"type": "object",
"properties": {
"ID": {
"title": "ID",
"type": "integer",
"format": "int64"
},
"fileName": {
"title": "fileName",
"type": "string"
}
},
"required": [
"ID",
"fileName"
]
}
},
"required": [
"entity"
]
}
}
},
"required": [
"rows"
]
},
"host": {
"connection": {
"name": "@parameters('$connections')['shared_sharepointonline_1']['connectionId']"
}
},
"operationId": "ForASelectedFileHybridTrigger",
"parameters": {
"table": "396d2319-dd5e-451d-973c-652f89a0f3c4"
}
},
"metadata": {
"operationMetadataId": "07e15fc5-4aee-4723-a8d3-546c23043c24"
}
}
Also the second step List existing rows in table ("In Tabelle vorhandene Zeilen auflisten")
here the previous code as well
"inputs": {
"host": {
"connectionName": "shared_excelonlinebusiness_1",
"operationId": "GetItems",
"apiId": "/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness"
},
"parameters": {
"drive": "b!xxRDk4ivVU-Omb--gkfOXjfKW84iPihBh4pxCzIVyfYZI205Xt0dRZc8ZS-JoPPE",
"file": "/@{triggerBody()?['entity']?['fileName']}",
"table": "Import"
},
"authentication": {
"type": "Raw",
"value": "@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"
}
},
"metadata": {
"015QV3XBKNH4LSD2FTQVDKIAHG6V2KHWDU": "/Importvorlage 2022 für Test.xlsx",
"operationMetadataId": "29d3c624-b50d-494b-9f76-4dbea79e7f2b",
"tableId": "Import"
}
}
Possibly the error could also be in the JSON parse
{
"type": "array",
"items": {
"type": "object",
"properties": {
"@@odata.etag": {
"type": "string"
},
"ItemInternalId": {
"type": "string"
},
"Import-Referenz-ID": {
"type": "string"
},
"Investitionsobjekt": {
"type": "string"
},
"KstVer": {
"type": "string"
},
"Betrag": {
"type": "string"
},
"Kostenstelle (Nummer)": {
"type": "string"
},
"Verantwortliche (E-Mail)": {
"type": "string"
},
"Beschreibung": {
"type": "string"
}
},
"required": [
"@@odata.etag",
"ItemInternalId",
"Import-Referenz-ID",
"Investitionsobjekt",
"KstVer",
"Betrag",
"Kostenstelle (Nummer)",
"Verantwortliche (E-Mail)",
"Beschreibung"
]
}
}
I hope the information is sufficient and you can help me here
Categories:
All responses (
Answers (
