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.
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.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!