web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Power Automate Desktop
Suggested answer

When_a_new_email_arrives_in_a_shared_mailbox_(V2)' failed

(0) ShareShare
ReportReport
Posted on by 10
I created this flow last week and it worked perfectly for 2 days but over the weekend til today, my email stopped receiving email records.
Categories:
I have the same question (0)
  • srduval Profile Picture
    1,743 Moderator on at
    When_a_new_email_arrives_in_a_shared_mailbox_(V2)' failed
    Do you get any error messages or anything that might help us troubleshoot the issue with you?
  • Tomac Profile Picture
    3,198 Moderator on at
    When_a_new_email_arrives_in_a_shared_mailbox_(V2)' failed
     
    In a failed run, please expand the failed action and copy/paste the full error message from there. While the overall error is Bad Gateway, there may be more helpful information contained in the full error message.
  • JM-10111453-0 Profile Picture
    10 on at
    When_a_new_email_arrives_in_a_shared_mailbox_(V2)' failed
    Hi everyone, this the error i'm getting...
     
     
    {"message":"Request failed with status code 400","name":"AxiosError","code":"ERR_BAD_REQUEST","config":{"transitional":{"silentJSONParsing":true,"forcedJSONParsing":true,"clarifyTimeoutError":false},"transformRequest":[null],"transformResponse":[null],"timeout":0,"xsrfCookieName":"XSRF-TOKEN","xsrfHeaderName":"X-XSRF-TOKEN","maxContentLength":-1,"maxBodyLength":-1,"env":{},"headers":{"Accept":"application/json, text/plain, */*","Content-Type":"application/json","accept-language":"en-US","x-ms-client-session-id":"636cd5d0-bf19-11f0-abc7-8786d5df8393","x-ms-client-request-id":"653a59b8-78b4-4dbe-924a-4b1c911964b0","authorization":""},"operationName":"PROCESSSIMPLE:POST/PROVIDERS/MICROSOFT.PROCESSSIMPLE/ENVIRONMENTS/FLOWS","params":{"api-version":"1"},"method":"post","url":"https://defaultdb05facac82a4b9db9c50f64b67554.21.environment.api.powerplatform.com/powerautomate/flows","data":"{\"properties\":{\"connectionReferences\":{\"shared_excelonlinebusiness\":{\"id\":\"/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness\",\"connectionName\":\"shared-excelonlinebu-3a851331-c223-4c24-a862-e33e7b5e9ef5\"},\"shared_sharepointonline\":{\"id\":\"/providers/Microsoft.PowerApps/apis/shared_sharepointonline\",\"connectionName\":\"e2e2485a7d484fe18ee3db5feff6b33a\"}},\"definition\":{\"$schema\":\"https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#\",\"contentVersion\":\"undefined\",\"triggers\":{\"Recurrence\":{\"type\":\"Recurrence\",\"recurrence\":{\"frequency\":\"Day\",\"interval\":\"1\",\"startTime\":\"2025-11-13T14:00:00.000Z\"}}},\"actions\":{\"List_rows_present_in_a_table\":{\"type\":\"OpenApiConnection\",\"inputs\":{\"parameters\":{\"source\":\"https://uhgazure.sharepoint.com/sites/01_NMT\",\"drive\":\"b!HFK32KX5IkawJiO-c0ElzXULBWMUnxNFokYqlMIl90DIInXPFq-GS7nsGUO8wdro\",\"file\":\"01S6PXM2JWZ7EEGPFQXJFJ3NT2K5NSE2AE\",\"table\":\"{03CBCFEE-88CA-4A1B-819C-AEDCC842FA67}\",\"dateTimeFormat\":\"ISO 8601\"},\"host\":{\"apiId\":\"/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness\",\"operationId\":\"GetItems\",\"connectionName\":\"shared_excelonlinebusiness\"}},\"runAfter\":{},\"runtimeConfiguration\":{\"paginationPolicy\":{\"minimumItemCount\":100000}},\"metadata\":{\"01S6PXM2JWZ7EEGPFQXJFJ3NT2K5NSE2AE\":\"/SBO Reports/FPO Dashboards/Email Inventory Report/Inventory Raw/Excel to Sharepoint.xlsx\"}},\"Get_items\":{\"type\":\"OpenApiConnection\",\"inputs\":{\"parameters\":{\"dataset\":\"https://uhgazure.sharepoint.com/teams/JamDatabase\",\"table\":\"ae504767-0532-42c7-bdcc-0969b1138241\"},\"host\":{\"apiId\":\"/providers/Microsoft.PowerApps/apis/shared_sharepointonline\",\"operationId\":\"GetItems\",\"connectionName\":\"shared_sharepointonline\"}},\"runAfter\":{\"List_rows_present_in_a_table\":[\"SUCCEEDED\"]},\"runtimeConfiguration\":{\"paginationPolicy\":{\"minimumItemCount\":100000}}},\"Apply_to_each\":{\"type\":\"Foreach\",\"foreach\":\"@outputs('List_rows_present_in_a_table')?['body/value']\",\"actions\":{\"Filter_array\":{\"type\":\"Query\",\"inputs\":{\"from\":\"@outputs('Get_items')?['body/value']\",\"where\":\"@equals(item()?['Title'],items('Apply_to_each')?['Title'])\"}},\"Condition\":{\"type\":\"If\",\"expression\":{\"and\":[{\"equals\":[\"@length(body('Filter_array'))\",1]}]},\"actions\":{\"Apply_to_each_1\":{\"type\":\"Foreach\",\"foreach\":\"@body('Filter_array')\",\"actions\":{\"Update_item\":{\"type\":\"OpenApiConnection\",\"inputs\":{\"parameters\":{\"dataset\":\"https://uhgazure.sharepoint.com/teams/JamDatabase\",\"table\":\"ae504767-0532-42c7-bdcc-0969b1138241\",\"id\":\"@items('Apply_to_each_1')?['ID']\",\"item/Title\":\"@items('Apply_to_each')?['Title']\",\"item/From\":\"@items('Apply_to_each')?['From']\",\"item/Subject\":\"@items('Apply_to_each')?['Subject ']\",\"item/ReceivedDate\":\"@items('Apply_to_each')?['Received Date']\",\"item/EmailPending_x003f_/Value\":\"NO\",\"item/STATUS/Value\":\"OPEN\"},\"host\":{\"apiId\":\"/providers/Microsoft.PowerApps/apis/shared_sharepointonline\",\"operationId\":\"PatchItem\",\"connectionName\":\"shared_sharepointonline\"}}}}}},\"else\":{\"actions\":{\"Create_item\":{\"type\":\"OpenApiConnection\",\"inputs\":{\"parameters\":{\"dataset\":\"https://uhgazure.sharepoint.com/teams/JamDatabase\",\"table\":\"ae504767-0532-42c7-bdcc-0969b1138241\",\"item/Title\":\"@items('Apply_to_each')?['Title']\",\"item/From\":\"@items('Apply_to_each')?['From']\",\"item/Subject\":\"@items('Apply_to_each')?['Subject ']\",\"item/ReceivedDate\":\"@items('Apply_to_each')?['Received Date']\",\"item/EmailPending_x003f_/Value\":\"NO\",\"item/STATUS/Value\":\"OPEN\"},\"host\":{\"apiId\":\"/providers/Microsoft.PowerApps/apis/shared_sharepointonline\",\"operationId\":\"PostItem\",\"connectionName\":\"shared_sharepointonline\"}}}}},\"runAfter\":{\"Filter_array\":[\"SUCCEEDED\"]}}},\"runAfter\":{\"Get_items\":[\"SUCCEEDED\"]}}},\"parameters\":{\"$authentication\":{\"defaultValue\":{},\"type\":\"SecureObject\"},\"$connections\":{\"defaultValue\":{},\"type\":\"Object\"}}},\"displayName\":\"FPO Excel to Sharepoint\",\"environment\":{\"name\":\"Default-db05faca-c82a-4b9d-b9c5-0f64b6755421\"}},\"telemetryMetadata\":{\"creationSource\":\"Portal\",\"modifiedSources\":\"Portal\"}}","team":"PowerAutomate","bodyDetails":{"locale":"en-US"},"axios-retry":{"retryCount":0,"lastRequestTime":1762878880507},"context":{"ppapiContext":{"endpoint":"defaultdb05facac82a4b9db9c50f64b67554.21.environment.api.powerplatform.com"}},"knownServiceId":"ppapi-pauto","activityId":"c7d174fc-b17f-4628-b2e5-ff22480b1b97"},"request":{},"response":{"data":{"error":{"code":"InvalidOpenApiFlow","message":"Flow save failed with code 'InvalidPaginationPolicy' and message 'The pagination policy of workflow run action 'List_rows_present_in_a_table' of type 'OpenApiConnection' at line '1' and column '1010' is not valid. The value specified for property 'minimumItemsCount' exceeds the maximum allowed. Actual: '100000'. Maximum: '5000'.'."}},"status":400,"statusText":"","headers":{"access-control-allow-origin":"*","access-control-expose-headers":"Content-Type,Date,Server,Access-Control-Allow-Origin,Access-Control-Expose-Headers,Content-Length,x-ms-ppapigateway,x-ms-gateway-clusters,x-ms-request-id,x-ms-correlation-request-id,x-ms-flow-mobile-ios-version,x-ms-armresiliency,x-ms-flow-routing-request-id,Strict-Transport-Security","cache-control":"no-cache, no-store","content-length":"384","content-type":"application/json; charset=utf-8","date":"Tue, 11 Nov 2025 16:34:43 GMT","strict-transport-security":"max-age=31536000; includeSubDomains","x-ms-armresiliency":"False","x-ms-correlation-request-id":"ef2c78a9-7c2e-4cf4-8912-5d19ca450d42","x-ms-flow-mobile-ios-version":"3.0.421","x-ms-flow-routing-request-id":"WESTUS:20251111T163443Z:f7e05adf-5535-4476-b724-8b367361e266","x-ms-gateway-clusters":"prdil108wus","x-ms-ppapigateway":"_prdil108wusgb0_3","x-ms-request-id":"westus:f7e05adf-5535-4476-b724-8b367361e266"},"config":{"transitional":{"silentJSONParsing":true,"forcedJSONParsing":true,"clarifyTimeoutError":false},"transformRequest":[null],"transformResponse":[null],"timeout":0,"xsrfCookieName":"XSRF-TOKEN","xsrfHeaderName":"X-XSRF-TOKEN","maxContentLength":-1,"maxBodyLength":-1,"env":{},"headers":{"Accept":"application/json, text/plain, */*","Content-Type":"application/json","accept-language":"en-US","x-ms-client-session-id":"636cd5d0-bf19-11f0-abc7-8786d5df8393","x-ms-client-request-id":"653a59b8-78b4-4dbe-924a-4b1c911964b0","authorization":""},"operationName":"PROCESSSIMPLE:POST/PROVIDERS/MICROSOFT.PROCESSSIMPLE/ENVIRONMENTS/FLOWS","params":{"api-version":"1"},"method":"post","url":"https://defaultdb05facac82a4b9db9c50f64b67554.21.environment.api.powerplatform.com/powerautomate/flows","data":"{\"properties\":{\"connectionReferences\":{\"shared_excelonlinebusiness\":{\"id\":\"/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness\",\"connectionName\":\"shared-excelonlinebu-3a851331-c223-4c24-a862-e33e7b5e9ef5\"},\"shared_sharepointonline\":{\"id\":\"/providers/Microsoft.PowerApps/apis/shared_sharepointonline\",\"connectionName\":\"e2e2485a7d484fe18ee3db5feff6b33a\"}},\"definition\":{\"$schema\":\"https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#\",\"contentVersion\":\"undefined\",\"triggers\":{\"Recurrence\":{\"type\":\"Recurrence\",\"recurrence\":{\"frequency\":\"Day\",\"interval\":\"1\",\"startTime\":\"2025-11-13T14:00:00.000Z\"}}},\"actions\":{\"List_rows_present_in_a_table\":{\"type\":\"OpenApiConnection\",\"inputs\":{\"parameters\":{\"source\":\"https://uhgazure.sharepoint.com/sites/01_NMT\",\"drive\":\"b!HFK32KX5IkawJiO-c0ElzXULBWMUnxNFokYqlMIl90DIInXPFq-GS7nsGUO8wdro\",\"file\":\"01S6PXM2JWZ7EEGPFQXJFJ3NT2K5NSE2AE\",\"table\":\"{03CBCFEE-88CA-4A1B-819C-AEDCC842FA67}\",\"dateTimeFormat\":\"ISO 8601\"},\"host\":{\"apiId\":\"/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness\",\"operationId\":\"GetItems\",\"connectionName\":\"shared_excelonlinebusiness\"}},\"runAfter\":{},\"runtimeConfiguration\":{\"paginationPolicy\":{\"minimumItemCount\":100000}},\"metadata\":{\"01S6PXM2JWZ7EEGPFQXJFJ3NT2K5NSE2AE\":\"/SBO Reports/FPO Dashboards/Email Inventory Report/Inventory Raw/Excel to Sharepoint.xlsx\"}},\"Get_items\":{\"type\":\"OpenApiConnection\",\"inputs\":{\"parameters\":{\"dataset\":\"https://uhgazure.sharepoint.com/teams/JamDatabase\",\"table\":\"ae504767-0532-42c7-bdcc-0969b1138241\"},\"host\":{\"apiId\":\"/providers/Microsoft.PowerApps/apis/shared_sharepointonline\",\"operationId\":\"GetItems\",\"connectionName\":\"shared_sharepointonline\"}},\"runAfter\":{\"List_rows_present_in_a_table\":[\"SUCCEEDED\"]},\"runtimeConfiguration\":{\"paginationPolicy\":{\"minimumItemCount\":100000}}},\"Apply_to_each\":{\"type\":\"Foreach\",\"foreach\":\"@outputs('List_rows_present_in_a_table')?['body/value']\",\"actions\":{\"Filter_array\":{\"type\":\"Query\",\"inputs\":{\"from\":\"@outputs('Get_items')?['body/value']\",\"where\":\"@equals(item()?['Title'],items('Apply_to_each')?['Title'])\"}},\"Condition\":{\"type\":\"If\",\"expression\":{\"and\":[{\"equals\":[\"@length(body('Filter_array'))\",1]}]},\"actions\":{\"Apply_to_each_1\":{\"type\":\"Foreach\",\"foreach\":\"@body('Filter_array')\",\"actions\":{\"Update_item\":{\"type\":\"OpenApiConnection\",\"inputs\":{\"parameters\":{\"dataset\":\"https://uhgazure.sharepoint.com/teams/JamDatabase\",\"table\":\"ae504767-0532-42c7-bdcc-0969b1138241\",\"id\":\"@items('Apply_to_each_1')?['ID']\",\"item/Title\":\"@items('Apply_to_each')?['Title']\",\"item/From\":\"@items('Apply_to_each')?['From']\",\"item/Subject\":\"@items('Apply_to_each')?['Subject ']\",\"item/ReceivedDate\":\"@items('Apply_to_each')?['Received Date']\",\"item/EmailPending_x003f_/Value\":\"NO\",\"item/STATUS/Value\":\"OPEN\"},\"host\":{\"apiId\":\"/providers/Microsoft.PowerApps/apis/shared_sharepointonline\",\"operationId\":\"PatchItem\",\"connectionName\":\"shared_sharepointonline\"}}}}}},\"else\":{\"actions\":{\"Create_item\":{\"type\":\"OpenApiConnection\",\"inputs\":{\"parameters\":{\"dataset\":\"https://uhgazure.sharepoint.com/teams/JamDatabase\",\"table\":\"ae504767-0532-42c7-bdcc-0969b1138241\",\"item/Title\":\"@items('Apply_to_each')?['Title']\",\"item/From\":\"@items('Apply_to_each')?['From']\",\"item/Subject\":\"@items('Apply_to_each')?['Subject ']\",\"item/ReceivedDate\":\"@items('Apply_to_each')?['Received Date']\",\"item/EmailPending_x003f_/Value\":\"NO\",\"item/STATUS/Value\":\"OPEN\"},\"host\":{\"apiId\":\"/providers/Microsoft.PowerApps/apis/shared_sharepointonline\",\"operationId\":\"PostItem\",\"connectionName\":\"shared_sharepointonline\"}}}}},\"runAfter\":{\"Filter_array\":[\"SUCCEEDED\"]}}},\"runAfter\":{\"Get_items\":[\"SUCCEEDED\"]}}},\"parameters\":{\"$authentication\":{\"defaultValue\":{},\"type\":\"SecureObject\"},\"$connections\":{\"defaultValue\":{},\"type\":\"Object\"}}},\"displayName\":\"FPO Excel to Sharepoint\",\"environment\":{\"name\":\"Default-db05faca-c82a-4b9d-b9c5-0f64b6755421\"}},\"telemetryMetadata\":{\"creationSource\":\"Portal\",\"modifiedSources\":\"Portal\"}}","team":"PowerAutomate","bodyDetails":{"locale":"en-US"},"axios-retry":{"retryCount":0,"lastRequestTime":1762878880507},"context":{"ppapiContext":{"endpoint":"defaultdb05facac82a4b9db9c50f64b67554.21.environment.api.powerplatform.com"}},"knownServiceId":"ppapi-pauto","activityId":"c7d174fc-b17f-4628-b2e5-ff22480b1b97"},"request":{}},"isAxiosError":true}
  • srduval Profile Picture
    1,743 Moderator on at
    When_a_new_email_arrives_in_a_shared_mailbox_(V2)' failed
    Double check your connections and try reconnecting as well. I get that error when I have a bad connection in the flow somewhere. You can try switching to the old editor as well, sometimes it loads the connection stuff better especially if there's an error/bad connection.
  • Tomac Profile Picture
    3,198 Moderator on at
    When_a_new_email_arrives_in_a_shared_mailbox_(V2)' failed
     
    You've posted two screenshots of two completely different flows.
     
    Are you getting the same error on both?
     
    Which actions are giving this error? In the second screenshot you're showing the error but not what action it came from. The warning on the right side is a completely different thing.
     
    Please show the expanded actions that are giving this error both from a failed run and in edit mode so we can see what information Power Automate is working with.
  • JM-10111453-0 Profile Picture
    10 on at
    When_a_new_email_arrives_in_a_shared_mailbox_(V2)' failed
    I posted the question again with the complete information of this problem. 

    https://community.powerplatform.com/forums/thread/details/?threadid=98939336-38c6-f011-bbd3-000d3a1a2a23
     
  • Suggested answer
    Tomac Profile Picture
    3,198 Moderator on at
    When_a_new_email_arrives_in_a_shared_mailbox_(V2)' failed
     
    Here's the relevant error message from your flow output:
    "code":"InvalidOpenApiFlow","message":"Flow save failed with code 'InvalidPaginationPolicy' and message 'The pagination policy of workflow run action 'List_rows_present_in_a_table' of type 'OpenApiConnection' at line '1' and column '1010' is not valid. The value specified for property 'minimumItemsCount' exceeds the maximum allowed. Actual: '100000'. Maximum: '5000'.'."
     
    This means that you have a List Rows action with Pagination set to 100,000. The maximum is 5,000
     
    Once you lower the Pagination amount to the maximum, you will not get this error.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 438 Moderator

#3
chiaraalina Profile Picture

chiaraalina 258

Last 30 days Overall leaderboard