Submitted on09-28-201701:41 AMSubmitted byzesamsamon09-28-201701:41 AM
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
Submitted on01-31-201904:25 AMSubmitted byMattC_Aon01-31-201904:25 AM
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
Submitted on07-24-201802:51 AMSubmitted byCamon07-24-201802:51 AM
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
Submitted on08-08-201802:17 AMSubmitted byBEND-Arrivaon08-08-201802:17 AM
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
Submitted on02-13-201901:53 AMSubmitted byBieson02-13-201901:53 AM
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
Submitted on06-12-201712:38 AMSubmitted byAnonymouson06-12-201712:38 AM
When trying to get rows from Excel you currently can only use TABLES as the objects to import from. I would like it when you can refer to an Excel workbook but reference a data range (dynamic ideally) as often the data being picked up is from 3rd parties that do not place the data into TABLES.
... View more
Submitted on10-23-201809:01 AMSubmitted byApuenteon10-23-201809:01 AM
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
Submitted on08-23-201604:38 AMSubmitted byyoshihirokon08-23-201604:38 AM
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
Submitted on03-13-201811:26 AMSubmitted bymknightonon03-13-201811:26 AM
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
Submitted on02-08-201701:54 AMSubmitted byjvondermanson02-08-201701:54 AM
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
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
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
Submitted on11-20-201706:56 AMSubmitted byrobertcarettaon11-20-201706:56 AM
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