Update existing Sharepoint list with new data (adding new rows)

Question

Before I start, I should say I have the answer for the above question, but I need something better and I will explain. I am writing an app in powerapps that references data in a sharepoint list. Something like: Name From To Project Fred 12 44 55555 But that data comes from customers and I need it to be imported easily into the sharepoint list. There are several ways to do this, but most involve copying and pasting data from their spreadsheet to ours. If we could make an app that reads the fields from their data, lets the user choose which fields to import and which fields from the user data go to which fields in the sharepoint list, and then imports it, that would be what we are after. Powerapps works well for all of this except the import from a new file, so I am looking for a script or app to do this. I'm not afraid to write in other languages (have written stuff in perl,ruby, vba before), but I can't find something I can set on a website for other users, possibly customers themselves, can use to import the data to our sharepoint list, without a lot of custom coding (i.e. building a whole website just for the import). I started to work on something in Powershell, but that wouldn't be easy to add to a website. Any thoughts or suggestions?

Answer 1

This site is not a code writing service. If you want, you can post the code you have and explain what problems you have with it, but this is not generally a forum for suggestions as there are plenty of opinions in the dev world. Mods will probably close your thread unless you provide something specific.