I have multiple flows setup to copy a Table from an Excel Spreadsheet to a Sharepoint list.
The Spreadsheet is the same and is updated daily and the flow is used to either copy new data or overwrite existing data.
These flows work for a while sometimes weeks / sometimes months but then all of a sudden I get the following error:
Action 'List_rows_present_in_a_table' failed: Graph API request failed. Error code is 'itemNotFound'. Error message is 'The resource could not be found.
If I go to edit the flow I get this error message:
Failed to retrieve dynamic outputs. As a result, this operation's outputs might not be visible in subsequent actions. Error details: The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code 'NotFound'. This may indicate invalid input parameters. Error response: { "status": 404, "message": "Graph API request failed. Error code is 'itemNotFound'. Error message is 'The resource could not be found.'.\r\nclientRequestId: e05d597c-ffab-4cc5-9c1f-87d161923bcb", "error": { "message": "Graph API request failed. Error code is 'itemNotFound'. Error message is 'The resource could not be found.'." }, "source": "excelonline-we.azconn-we-003.p.azurewebsites.net" }
I have to repoint the parameter at the same file and select the same table again for it to work.
Has anyone else come across this and found a fix?
Thanks