Hello! I am trying to set up an integration with Microsoft Flow so that once a new row is added in Smartsheet, it is converted to a Microsoft Planner task.

The complication is that our project manager uses multiple sheets to track projects. I tried creating a report which lists all of the data from those sheets, but since it is a "report" Microsoft Flow doesn't recognize it as a viable data source... it needs to be a sheet it seems.

So my question is - is there another way to create a live sheet which combines data from multiple sheets. Or does anyone know a way to pass the data from the report to Excel since I can use Excel to feed that data into Microsoft Flow as well.