3 ms·
Completely agree that this should be a seamless experience but unfortunately it's not there. As faeriechangling said, you can start with Power Automate and do a
by ics 4y ago
Completely agree that this should be a seamless experience but unfortunately it's not there. As faeriechangling said, you can start with Power Automate and do a lot of dirty work with Powershell but the amount of effort is annoying especially if you hit a wall in your organization (e.g. in my case Power Automate is fine, but there's no way I'm getting PnP).
The dumbed down version is to use the "edit in grid view" feature of lists, which happens to make copy/pasting cells and rows between Sharepoint and Excel easy. I've done this before to make bulk changes when any additional effort isn't worth it.
- gompertz 4y agoYeah, while I myself can deal with Power Automate / Powershell, the average company layman user still can't even do an index match formula, so there's no way they are going to understand anything that complex. I've done what you have done and demonstrated the pasting into grid view. But this requires a perfect placement of the cursor and also the slow as f*ck row-by-row validation+commit to the database is outright comedic.