Forum Discussion
SharePoint list
Hello Community - Looking for guidance on a problem. Appreciate any suggestions. We have an Excel spreadhseet in SharePoint that receives input from 20 users. Sort of a project tracking shee...
I'd implement in PowerShell quite frankly. Drop the excel file (or csv would be better) somewhere on a share. Have the PowerShell script iterate the rows in the excel file, and check if the the entry exists. If not create a new list item, but if so, get the existing comments, append it to the new comments, and update the list item with the consolidate comments.