Template Import - Issue

[Magnusson2]

Hi Ben, thanx for this template. When I am trying to import the power automate flow i receive the message below, saying "error when saving the flow. Code xy". It looks similar to the issue the dutch mate raised. Do you have an idea what the problem might be here?

Fehler beim Speichern des Flows. Code: MultipleErrorsOccurred, Meldung: "Fehler bei der dynamischen Vorgangsanforderung an API "excelonlinebusiness", Vorgang "GetTable" mit Statuscode "NotFound". Dies kann auf ungültige Eingabeparameter hinweisen. Fehlerantwort: { "status": 404, "message": "Item not found\r\nclientRequestId: f25e5a2b

[ben-howard]

Hi, I don’t know why this is happening. The “GetTable” will apply to the Excel file, so please make sure all of tables are updated correctly. Each table is referenced twice, once to delete all of the rows, and the 2nd time to write data (Add a row into a table). There are 5 tables and hence a total of 10 references. I would try there first… From: Magnusson2 ***@***.***> Sent: 10 January 2022 16:45 To: ben-howard/Planner-PowerBI-with-PowerAutomate ***@***.***> Cc: Subscribed ***@***.***> Subject: [ben-howard/Planner-PowerBI-with-PowerAutomate] Template Import - Issue (Issue #2) Hi Ben, thanx for this template. When I am trying to import the power automate flow i receive the message below, saying "error when saving the flow. Code xy". It looks similar to the issue the dutch mate raised. Do you have an idea what the problem might be here? Fehler beim Speichern des Flows. Code: MultipleErrorsOccurred, Meldung: "Fehler bei der dynamischen Vorgangsanforderung an API "excelonlinebusiness", Vorgang "GetTable" mit Statuscode "NotFound". Dies kann auf ungültige Eingabeparameter hinweisen. Fehlerantwort: { "status": 404, "message": "Item not found\r\nclientRequestId: f25e5a2b — Reply to this email directly, view it on GitHub<#2>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AI26AMSHMAM5VICJM3EXCW3UVMEHHANCNFSM5LUD26JA>. Triage notifications on the go with GitHub Mobile for iOS<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you are subscribed to this thread.Message ID: ***@***.******@***.***>>

[scottman01]

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.

[scottman01]

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!