Getting records from Excel - InfoPath Dev

InfoPath Dev

Use our Google Custom Search for best site search results.

Getting records from Excel

Last post 05-29-2020 10:13 AM by granDelimiter. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 05-29-2020 09:49 AM

    Getting records from Excel

    Happy Spring! I have a SharePoint List with InfoPath forms all set up but need to get many records that are in Excel spreadsheets, with columns not formatted correctly. I tried just copying and pasting the columns. It actually wasn't too bad, at least to start. I had to go down the columns where the imported data wasn't formatted correctly and fix each cell using Quick Edit - the quick edit cells had drop down controls to facilitate that and it went quick. It all looked pretty good until I was ready to stop editing. Then it told me that I cannot create new records in quick edit because I don't have all required fields. I displayed the ID field. I will not allow me to create a new ID. Not sure about other 'required' fields. Is there any way to create new records in Quick Edit? Is the any way to get excel data into and already created List? Thanks
  • 05-29-2020 10:13 AM In reply to

    Re: Getting records from Excel

    I now see that I can create new records in quick edit. I had to delete some old 'required' fields. This may fix me up. We'll see.
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.