Planner-PowerBI-with-PowerAutomate
Planner-PowerBI-with-PowerAutomate copied to clipboard
ben-howard
Perhaps something has changed cause I get this error
When I try to import the zip into power automate it says (sorry, it is in dutch):
Het opslaan van de stroom is mislukt met de code MultipleErrorsOccurred en het bericht De dynamische bewerkingsaanvraag naar de API excelonlinebusiness voor de bewerking GetTable is mislukt met de statuscode NotFound. Dit kan duiden op ongeldige invoerparameters. Foutbericht: { "status": 404, "message": "Item not found\r\nclientRequestId: 12c3c214-747e-4ee1-96d9-c3c00cf5ca94", "error": { "message": "Item not found" }, "source": "excelonline-we.azconn-we.p.azurewebsites.net" };De dynamische bewerkingsaanvraag naar de API excelonlinebusiness voor de bewerking GetTable is mislukt met de statuscode NotFound. Dit kan duiden op ongeldige invoerparameters. Foutbericht: { "status": 404, "message": "Item not found\r\nclientRequestId: 12c3c214-747e-4ee1-96d9-c3c00cf5ca94", "error": { "message": "Item not found" }, "source": "excelonline-we.azconn-we.p.azurewebsites.net" };De dynamische bewerkingsaanvraag naar de API excelonlinebusiness voor de bewerking GetTable is mislukt met de statuscode NotFound. Dit kan duiden op ongeldige invoerparameters. Foutbericht: { "status": 404, "message": "Item not found\r\nclientRequestId: 12c3c214-747e-4ee1-96d9-c3c00cf5ca94\r\nserviceRequestId: 5c62f073-7291-4310-9478-0d5ed43b0ef8", "error": { "message": "Item not found" }, "source": "excelonline-we.azconn-we.p.azurewebsites.net" };De dynamische bewerkingsaanvraag naar de API excelonlinebusiness voor de bewerking GetTable is mislukt met de statuscode NotFound. Dit kan duiden op ongeldige invoerparameters. Foutbericht: { "status": 404, "message": "Item not found\r\nclientRequestId: 12c3c214-747e-4ee1-96d9-c3c00cf5ca94", "error": { "message": "Item not found" }, "source": "excelonline-we.azconn-we.p.azurewebsites.net" };De dynamische bewerkingsaanvraag naar de API excelonlinebusiness voor de bewerking GetTable is mislukt met de statuscode NotFound. Dit kan duiden op ongeldige invoerparameters. Foutbericht: { "status": 404, "message": "Item not found\r\nclientRequestId: 12c3c214-747e-4ee1-96d9-c3c00cf5ca94", "error": { "message": "Item not found" }, "source": "excelonline-we.azconn-we.p.azurewebsites.net" }.
Something with "GetTable" failed, even though it is still in the import, so I haven't attached an excel file to it ..
Perhaps you should leave out the existing excel file or something in the template?!? Because that would be your excel file in your environment, and of course, it can't find that...
I had the same issue. There looking at the error code, there was a message that said to save it as a new flow in order to be able to import.
Did that. Saw that every Excel connection had to be updated. Once I did that, and reconfigured everything to point to my SharePoint document folder where the Excel file was saved I was able to run the workflow successfully. It is not perfect though. It is pulling in every team and every planner that I am associated with and taking way too much time to run even though I set the filters to a specific team/plan. I am going to modify the flows to not pull all of the Teams and see if it works any better. Will update my results when complete.
OK, I found that the step "List Teams" was causing the flow to pull in every team from our organization and subsequently every Planner Plan, all of the users from all of the teams and essentially more information than I wanted or needed.
I deleted the List Teams step, changed it to List Plans for group and moved everything up a notch in each branch.
The flow worked great except that it was stopping after doing 400 rows from our plan (currently over 600). So I went in to the steps List Tasks and List assignments and changed the pagination settings setting a max of 1000. Flow ran perfect!
When I try to import the zip into power automate it says (sorry, it is in dutch):
I also receive this error, and do not get prompted to "Save as New Flow". I've tried manually changing the package maps without much success, but cannot import the flow in order to be able to edit.
Base on the errors, the issue is that the Flow is referencing an unavailable file location (since it's your O365 environment). Please remove references to the file location in your exported flow (or make it reference a local file location & add notes for changing that parameter to the readme).
I get prompted to change the other connections on import, so hopefully that won't be an issue, but the file location is forcing a fail on import.
