Hi,
I have an Excel workbook on the SharePoint server which contains two sheets named TFE and XBL on which I need to run office scripts for automation. So I have used the power automation flow to pick up the files from the SharePoint server using the list folder - SharePoint and run the script. After building the flow completely when I tested it, it was working as expected with a minimum amount of data in the Excel workbook and when the Excel workbook has more than 400 rows of data the power automate flow fails after 2 retires. I could not identify the issue because I did not get a proper error message in the logs. Could any kindly help me with this?
Attaching the error message for reference:
{
"statusCode": 504,
"headers": {
"Cache-Control": "no-store, no-cache",
"Pragma": "no-cache",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"x-ms-datasourceerror": "True",
"x-ms-request-id": "d3bc3e99-8beb-42ef-9f7c-bac039bdc218",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"x-ms-apihub-obo": "false",
"Date": "Tue, 02 Jan 2024 10:10:18 GMT",
"Content-Length": "531",
"Content-Type": "application/json",
"Expires": "-1"
},
"body": {
"error": {
"code": 504,
"source": "flow-apim-msmanaged-na-northcentralus-01.azure-apim.net",
"clientRequestId": "d3bc3e99-8beb-42ef-9f7c-bac039bdc218",
"message": "BadGateway",
"innerError": {
"status": 504,
"message": "Request to Graph API has timed out.\r\nclientRequestId: d3bc3e99-8beb-42ef-9f7c-bac039bdc218",
"error": {
"message": "Request to Graph API has timed out."
},
"source": "excelonline-ncus.azconn-ncus-001.p.azurewebsites.net"
}
}
}
}
Thanks in advance.