It would be good to have Excel action for sharepoint documents.
Now i have to copy from SharePoint to "OneDrive for Business" and from there its possible to open.
You can now work with Excel documents in SharePoint online: https://flow.microsoft.com/en-us/blog/approval-history-accessibility/
This is what I'm looking for;
- When a file is uploaded to SharePoint Document library
- I want to read the file
Specifically I'm looking for a solution to read an excel file that is uploaded to SharePoint document library.
Currently, I do not see "SharePoint" datasource under excel actions.
Fully Supportive - this is URGENTLY NEEDED to maximize value of both SharePoint document libraries and Flow.
Create an Enterprise Flow Application Directroy to manage centrally supported, shared Flow Apps
1) Create new app entries in Excel
2) upload excel to sharepoint
3) when new file is created, run flow to append new records to Sharepoint list.and move file to archive directed, ...
Why use Excel?
Most users prefer entering data into Excel versus Sharepoint lists
Why use sharepoint library?
better access control, one place to run the flow from, central archive
Yes, that would be very nice to update, insert or delete rows in excelsheets in a SharePoint documentlibrary