Forum Discussion
Please FIX Quick Edit Mode (so it doesn't create duplicate items!)
I'm working on two major projects right now, both of which will require that users import data from Excel spreadsheets into SharePoint lists. The people doing this are NOT IT professionals, so the si...
Well,
Bearing in mind this fix is not going to happen soon: Have you consider to use other alternatives more friendly for your users? One that come to my mind is to use Flow to insert excel data into the list..you could create the Flow and instruct the users to use it.
By the way, you have to open a support ticket so Microsoft Support can be aware of this problem you are experiencing and that it's not acceptable as you well mention
Bearing in mind this fix is not going to happen soon: Have you consider to use other alternatives more friendly for your users? One that come to my mind is to use Flow to insert excel data into the list..you could create the Flow and instruct the users to use it.
By the way, you have to open a support ticket so Microsoft Support can be aware of this problem you are experiencing and that it's not acceptable as you well mention
Bearing in mind this fix is not going to happen soon: Have you consider to use other alternatives more friendly for your users? One that come to my mind is to use Flow to insert excel data into the list..you could create the Flow and instruct the users to use it.
The Excel actions in flow ("Get tables" and "get rows") are potentially useful, except they, too, have limits (255 rows, I think, which is NOT a lot of data!) Also, they only work with Excel files stored locally or on OneDrive for Business. I could store a sample file on my OneDrive, set up the flow, but then for someone else to use it, I need to also share that file with them, or walk them through re-building the Flow themselves. There really needs to be a set of similar actions that run against Excel files stored in SharePoint.
