Jan 22 2019 08:27 AM
We are in a Mac-only environment and need to extract SharePoint list data for eventual manipulation in Excel. The "Export to Excel" function does not work on Macs and the "workaround" to this limitation is to export it using Windows, which is not an option for us. Nor can we connect to the SharePoint list using Excel, since PowerQuery isn't available in Excel for Mac.
I'm looking for suggestions how to get our data out of SharePoint in some (any!) format that can be ingested by Excel. CSV would be fine. Open to using Flow and/or PowerApps, but needs to be fairly simple.
Jan 22 2019 09:25 AM
SolutionI'm just a Flow newbie, but I'd try something like this - haven't tested it but might give you some ideas?
Manually trigger a flow
Get Items from the SharePoint list
Apply to each - 'value' is the list of items.
Insert row - give it the excel file name and figure out the mapping between the rows and the values in the SharePoint list row.
Jan 22 2019 09:55 AM
Thanks for the idea, Robin. I was able to create a proof-of-concept Flow that updated an Excel on my OneDrive with the list items I needed.
Dec 10 2019 10:43 AM
@debit72 I tried this solution, but insert row is nowhere to be found anymore, and I get API errors when I try to connect.
Dec 10 2019 12:09 PM
@Arin Komins Looks like it's been renamed this year. Use the action 'add a row into a table' - you'll need to pre-create a table in your sheet so the rows have somewhere to attach to.
Dec 11 2019 04:39 AM
@Robin Nilsson Thanks! Do you need to prepopulate columns in the table with certain columns? I found an old reference for the insert a row which stated you needed title, empid, employeename, department in the table. Once I added those, it seems to work.
Dec 11 2019 07:58 AM
Dec 11 2019 11:37 AM
@Robin Nilsson I managed to get mine working using Created as my ID column...but yes, they very much changed the connector.
Now if only we could get a "clear rows" action!
Jun 24 2020 05:45 AM
Hi There,
I am also using a Mac and wondering how to export a sharepoint list - the reason I want to is to get the many headings from my list so I can set up a Flow to import data from the list into Excel as items are added.
Is there a way to use Flow to export the column headings?
Thank you
Apr 23 2021 01:47 PM
@debit72 FYI this feature is now available by default for Macs! There's now an option to Export to CSV that actually works on a Mac. Found that out today!
Jun 03 2021 04:28 PM
@KittyKat1082 Hey, how do you export to CSV on a mac?
Mar 15 2023 08:42 AM
@KittyKat1082 Hi - how did you get this to work? I don't find an option available to export to Mac.
Mar 15 2023 09:00 AM - edited Mar 15 2023 09:01 AM
@stephenmwilliams in the list you can click the export button and it gives you an option to export to CSV or to PowerBI. I am using Chrome, and a Sharepoint Online site.
Jan 22 2019 09:25 AM
SolutionI'm just a Flow newbie, but I'd try something like this - haven't tested it but might give you some ideas?
Manually trigger a flow
Get Items from the SharePoint list
Apply to each - 'value' is the list of items.
Insert row - give it the excel file name and figure out the mapping between the rows and the values in the SharePoint list row.