Wanted a simple Flow: Excel row - send email
Easy Right? WRONG!! 😠
Our plan seems to have created an issue. Not really sure how I going to be able to "trick" excel into connecting but I wont give up.
- Imported SharePoint list to excel
- Used power query to adjust table to our needs
- Created simple FLOW from template: Excel to Outlook
BUT oh noooooo not simple
The system detected this table/file has dynamic content - so
WHAM! This was in the 'Select Table' field of the Excel file action
The dynamic invocation request failed with error: Unexpected error occurred when calling the ApiHubsRuntime API: 'Microsoft.Azure.ProcessSimple.Data.Entities.Exceptions.ProcessSimpleDataException: The ApiHubsRuntime API call failed with http status code 'BadGateway' and response content '{ "error": { "code": 502, "source": "msmanaged-na.azure-apim.net", "clientRequestId": "8ad2ab7f-7ffc-435d-ae1a-6a75-1f4ccc38", "message": "BadGateway", "innerError": { "status": 502, "message": "This workbook cannot be edited because it contains the following features:\r\n\r\n• SharePoint lists\r\n\r\nTo edit this workbook, open the workbook for viewing, select Save a Copy from the File tab, and edit the new copy.\r\nclientRequestId: 8ad2ab7f-7ffc-435d-ae1a-6a75-1f4ccc38", "error": { "message": "This workbook cannot be edited because it contains the following features:\r\n\r\n• SharePoint lists\r\n\r\nTo edit this workbook.....there was more but I think I made the point
Other posts with similar issues that may help:
https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-use-dynamic-files-with-Excel-Read-Table-connector-a/td-p/757515
https://powerusers.microsoft.com/t5/General-Power-Automate/Power-automate-issue/td-p/1211493
If anyone has the work around - your knowledge and help would be greatly appreciated.
Thanks
