See original post here: https://powerusers.microsoft.com/t5/Building-Flows/Update-macro-enabled-Excel-file/m-p/59123    We cannot do actions such as "insert row", "delete row" etc. on macro-enabled files.    We can try working around by updating files with the "File content" data from an edited Excel file, but since it's not the same format, the target .xlsm file gets corrupted.    Allowing for selecting macro-enabled files and for updating them from the content of non-macro-enabled files would be helpful.  ... View more

We have a simple flow that is inserting data into an Excel spreadsheet in OneDrive.. it works great until I'm looking at the file & then Flows error with, 423 - File locked, e.g.     If you look in the Settings for the 'Insert Row' step, they look like they should handle this nicely, by retrying over a specified period of time, e.g.     But unfortunately they don't have any effect.. the operation isn't retried at all & the Flow fails.   This really needs fixing.     ... View more

Concering the Content Conversion connector: https://docs.microsoft.com/en-us/connectors/conversionservice/   could you please add a function to convert from Excel files from .XLS format to .XLSX format.   thank you ... View more

Dear Microsoft,   Can you please increase the number of rows you can retrieve with one of the Excel connectors from SharePoint and Onedrive to a proper number?   It has been increased (for onedrive at least) to 2048 rows but it feels underwhelming and not logical as, for example, a for each can process 5000 lines.   My question is to at least increase the limit to 5000 as most Excel files contain many many lines on which you want to do certain operations.   Thanks in advance!   With kind regards,   Joseph ... View more

When we convert a excel-file to pdf using the standard convert file option, it always exports the file in landscape mode. No matter what we change in excel with orientation and such, the pdf-file is always in landscape mode?!   Can you please add the functionality to export in portrait mode. (Or take-over the orientations of the excel file) At the moment the excel-to-pdf conversion is useless for us. ... View more

I would love to be able to run Macros in Excel as an action. I am currently working with weekly reports and receiving them as .csv via email. There are a few character replacements I need to run before saving them in Box, I would love to see some automation here. ... View more

It would be great if we could have the capability in Flow to read an Excel file saved on a Sharepoint site, similar to what currently exists for OneDrive.   shahab ... View more

I want to use Excel file on OneDrive for Business which include Formula in cells.   Now, "Excel - Get row" action does not support any formula in cell.   Body { "status": 400, "message": "Excel files containing formula are currently not supported. Please use a file that has no formula.", "source": "127.0.0.1" } Regards, Yoshihiro Kawabata   ... View more

I love the button where i can track my location to Excel. But it would be great if i could use the location variables in other/time triggered actions. Then i could do the same as thebutton, but time triggered and not a manual action. ... View more

Problem I have a list in SharePoint online which I have connected to an excel file, in stored on the same site collection, which then creates a chart to display the status of the list on the main SharePoint site using the Excel Services connection. This all works fine except with no way to mark the site as a 'Trusted Excel Service Location' I can't have the excel file updating automatically unless I want users to be faced with a warning about external data connections (which they automatically click NO to)   You can do this on other versions of SharePoint but not the new online version.   Solution Idea Use a flow to monitor for changes to the SharePoint list and on update of an item the flow could then update the external data connection in the excel file - but there isn't a connection which will do this.   So a connection that will allow a data update on an excel file which is stored in SharePoint. ... View more

Many times we are using Excel to track information that is contributed from multiple teams.  It would be great to be able to trigger a flow when someone has made a change to a row in an Excel spreadsheet.  That flow could then email the curator of that sheet and enable the tracking and identify when all the appropriate people have contributed. ... View more

It would also be nice if I could programatically get at the stored data in the spreadsheet. The quiz results do not appear to show up in OneDrive. Feels like this resides in an inaccessible location.   ... View more

Is it possible to create a Flow that can apply a filter to specified Outlook folders based on Outlook email Categories and can import into Excel email Subject, Categories, and a link to the Outlook email? #WednesdayWisdom ... View more

Really need some sort of filtering on Excel Get Rows results. ... View more