how to collect sharepoint online column names and datatypes to a list


Badge +1

I'm trying to collect a list of column names and datatypes to track changes to the sharepoint custom list.  does anyone know how to do this?  I'm hoping there is a practical way of doing this through a workflow instead of a powershell or c# script.  

thanks 


4 replies

Badge +1
You should be able to just enable auditing for the custom sharepoint list. In theory you shouldnt need to create a workflow to do so.

https://support.office.com/en-ie/article/view-audit-log-reports-4293e8d5-4e7d-4201-b8ac-c8e63a100131

Let me know if I've misinterpreted your question.
Badge +1

this article seems to only apply to sharepoint 2010.  I need this for Sharepoint.com custom lists.  It did give me the idea to check the workflow%history/allitems.aspx but that didn't work either.  

 

Badge +1

Heres some more up to date links. I still think auditing is the easiest option for this.

 

https://support.office.com/en-us/article/configure-audit-settings-for-a-site-collection-a9920c97-38c0-44f2-8bcb-4cf1e2ae22d2

 

https://support.office.com/en-us/article/view-audit-log-reports-b37c5869-1b47-4a82-a30d-ea20070fe527

 

Let me know how you go 

Badge +1

after testing the audit settings, you have to manually run the audit report to get the list of column changes.  i was hoping for a list where a nintex workflow could export on a scheduled basis.  . 

 

Reply