Forum Discussion
Export SharePoint List on Mac
I'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.
debit72 I tried this solution, but insert row is nowhere to be found anymore, and I get API errors when I try to connect.
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.
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.
- Wow, they've really changed the excel connector, I don't remember all those options 🙂
I just did a test and didn't need to do any kind of prepopulate on the table in Excel. I did create the table in the excel file first and gave the columns headings. Then the 'add row' parameters showed up correctly instead of being labeled 'Column 1, Column 2....'
I noticed when I was testing that when I tried to do it from a trigger of 'selected item' in a SharePoint list, that didn't work. That only gave me the information related to the person triggering the action. I had to do a get item to get my columns of information to insert.