Aug 28 2019 03:48 AM
Hello.
I need to upload data from several excel files to the one SPO list.
Could someone advice hove to do this correctly and if this possibility exists?
Aug 28 2019 05:17 AM
Aug 28 2019 05:22 AM
Aug 28 2019 07:42 AM
Aug 28 2019 07:50 AM
Aug 28 2019 11:13 AM
@Freenit It all depends on your data and some answers are already provided as well.
If you are concerned about accuracy then I will either go with
A] Power shell
B] Small Console Application
But if you can take risk with Accuracy then
A] Copy the data from different excels to diff. lists (hopefully some correlation will be their to makes tows unique) and then write a workflow or ms flow which triggers and copies that data from different list to a single list. Why I said the accuracy can be challenging if you have some conflicting data you need to handle carefully.
B] Manually coping with quick edit its painful and leads lot of errors.
Hope this helps.