United States (English) the manager data is coming from SQL Server, based on the column "created by" in sharepoint list. I have published this form to the sharepoint library. Ask Question Asked 9 years, 8 months ago. Another action that allows us to populate a dataset with information is the SQL Query action, or Step 10, in the task. The people and the work they did was amazing. Active 2 years, 11 months ago. it helps you to understand the code n your side properly. : The screen shows a sample SQL table to connect with a native SharePoint list. Sign in. Aug 18, 2020. For this example, I’ll create a list called SQL Versions KPI: Once, the KPI list is created you should see a blank list. You need to have read access to those databases to get the information. If you have developed several Sharepoint Nintex forms, you will undoubtedly have used Choice dropdown controls. Open the InfoPath form by clicking on the Customize Form button in the List menu. Select the table from which the data needs to be fetched. -- I'm working with Reporting Services in SharePoint mode using Sql Server 2012, SharePoint 2013. Open the Home view. The Lifecycle list: SiteListViewName: The name of the SharePoint list view from which you want to retrieve data. The email field remains empty. Add an action – When a new item is created in SharePoint. Click the Component Properties tab and change the SiteListName, SiteListViewName, and SiteURL name: SiteListName: The name of the SharePoint list, as seen on the SharePoint page. In the Get Items action, populate the site address and list name. SQL Server is a full-featured, relational database program that is designed for enterprise-wide data solutions that require optimum performance, availability, scalability, and security. I understand I will need to open a connection. I have connected to my SQL Server, and created a template for browsing, viewing and editing a basic application. Viewed 22k times 3 3. Tags: Active Directory, DataView, LDAP, Linked Servers, SharePoint Designer, SQL Server trackback. How to Display an Active Directory Group in a SharePoint DataView September 3, 2009 Posted by moffitar in Uncategorized. Try 3rd party products = to start quickly with SQL (any vendor supported) and SharePoint (any version or plan). I have a Sharepoint list, I have a column in list called Manager which needs to be updated with sql server column once a new record is created in the list. Then he creates a query that copies the data from the SQL Server to SharePoint. It is designed for business users to generate business documents without IT support. Aug 11, 2005. 1 Connect to the SharePoint Online site and get the reference of the SharePoint list. 2 Connect to the SQL database using a connection string and execute the SQL query. 3 Iterate through all the rows in the data table and create items in SharePoint List. For your application, one idea is to write an event handler to populate your own database with the status change information. Let’s take the example of Date and Time data types. Auto Populate Columns from another SharePoint list using JSOM. The #1 Rule for Using PowerApps with SQL Server. Always flick from Server. Delete all the items from the list. This comes included in most, but not all, Office 365 licenses. Connect your favorite apps to automate repetitive tasks. On the Data tab, in the Get External Data group, click From Other Sources, and then click From SQL Server. I have installed previously SQL Server CE, Everywhere, Mobile, 2005 Mobile but I uninstalled them all. Solution Which version of SharePoint. SSIS Integration Toolkit for Microsoft SharePoint includes two data flow components. In this article, we will learn how to Auto Populate Column based on another Column on Text Change in SharePoint 2016 forms using JSOM. By default, SharePoint allows you to row-wrap up to six SQL rows. Enjoy my SQL Server tutorials. Creating a flow outside of my app because we do not yet have a premium license with Microsoft. During the long 14+ years of my professional career, I have used SQL Server in lots of projects. I have a Sharepoint list with 100k rows and I need to do a monthly cleanup (delete older than X months). Alternatively, right-click the machine or VM replica … Open SharePoint list in excel. Generate documents from SQL Server in a simple 2-step process. Connect SharePoint Online to an on-premises SQL Server from an Azure provider hosted app using Hybrid Connections. Submit. Hope that helps. How to connect Sharepoint Online for Office 365 List to SQL Server using Business Connectivity Services. Windows Server Developer Center. to run comprehensive reports on the exported … In the dialog box that opens, enter the name of the column as Customer and choose External Data as the column type. Populate a DropDownList from a SharePoint List March 19, 2009 by Randy Ellefson Like many ASP .NET developers, I’ve bound many data sources to a dropdown control over the years, using a database as a source, but I recently needed to do the same thing using a SharePoint list instead. Having identified the SharePoint list from which data will be sourced, we switch to SSIS and configure the necessary components for SharePoint data extraction. Here we have selected SQL Server Database as the source. Here is the expected behavior: (Updated) A list is created in a SharePoint Online site. I have a kind of strange issue. ... Full question sql-server - list | 16-10-2019 | (Question I would like to know the best way to get data from a SQL view into a temporary SharePoint list from within SharePoint. Enter SharePoint URL and select the list name. Benefits We stopped using Infopath for form building because my company believes it is becoming obsolete. I need to take, on a trigger Flow, send data to sql server from my sharepoint list. He is the co-founder of TSInfo Technologies, a SharePoint Consulting, Outsourcing, Development, and training company. Same, unit the put is doing, Take A thumb Of Photos And grey Some Notes. The left side of the statement is the name of the SharePoint filed, and the right side is a CSV column name. First off, we need a database that will be used for replicating the data coming from SharePoint lists. In this I will create a sample form which reads data from a SQL Server database and display it on SharePoint.. Start with a new InfoPath blank form. For eg: CreatedBy is an employee and we need to get his manager from Sql Server. You might also like to read Auto Populate Field Values based on Lookup Selection In SharePoint. Maximum row to fetch is set as 10. Be sure that you choose SharePoint Get Item s (items is plural). I found some and set it up pretty quickly. 5263 . I was recently tasked with creating a one way sync between some data in SQL and a SharePoint list. Part 2: SSIS Development – Configuring OData Source for SharePoint Online. Work less, do more. In the third part of the continuous integration aka “CI” workflow, the Populate step will be described.. After the Build step is successfully finished, where a new database is built directly from latest changes in source control, the Populate step is initiated. Please note: You can use existing tables or views, or create direct queries in the Cloud Connector. This is a repost from my old blog over at SharePointBlogs.com.. Crystal Reports, SQL Server Reporting Services, etc.) Sign in. To export the selected SharePoint list with data of chosen field, click ‘Export to Database’. Select the table and click on … Navigate to My flows and then choose Create from Blank option. Add an action – When a new item is created in SharePoint. Enter SharePoint URL and select the list name. Click on new step -> add a new action -> choose SQL Server –> Get Rows. Select the table from which the data needs to be fetched. Click on new step -> add a new action -> choose SQL Server –> Get Rows. Connect to the SharePoint Online site and get the reference of the SharePoint list. This is easy enough to do, simply setup the correct filters and you’re almost there. Now i want to display this data into sharepoint … On the Data tab, in the Get External Data group, click From Other Sources, and then click From SQL Server. Try it now. The list will grow and shrink depending on how many items I have in my database. The list you can populate the associated information from. PowerShell to Read Data from SQL Server and Insert into SharePoint: We created a new list “Projects” mapping relevant columns as per the SQL Server table and then here is my PowerShell script to import data from SQL Server to SharePoint List. Hi, I'm fairly new to the power platform and I have been tasked with creating an inventory catalog that matches up with our back end SQL data. A snapshot of replicated tables and their corresponding data in MS SQL Server from the SharePoint lists. The bdlcGUID column is filled with a GUID automatically that is used as a primary key to connect records in the database with items in the list for sync. How do I populate a SharePoint list from a SQL table? List Bulk Import not only lets users migrate documents, pictures, and list data into SharePoint from a broad range of sources; it also allows users to store import job configuration information to a template file for common imports and scheduled imports.In this article, we will demonstrate how to import data from a SQL Server into a SharePoint Site. Fig. View 4 Replies View Related Is It Possible To Dynamically Populate A Parameter List With Values Based On Another Parameter Value? : SharePoint sample list for data acquisition to SQL in real-time. After I installed the SQL Server Compact Edition, I start a new VS 2005 Basic project. Since that site has been down more and more often, ostensibly due to … The list you can populate the associated information from. Open SQL Server Management Studio and create a new database named “ProductsReportdemo”. See how it works. The article linked above says we can have 48 Date and Time data type in a single List. isn't easy to setup in a few minutes. An ideal solution would populate SQL Server data into Word / PDF document templates for bulk/on-demand document creation. By Microsoft. It is a simple strategy and works very well to get you started integrating data into Word. It is a custom list which contains data of all the product category groups. How can I populate a list with values from a SQL Server database? If you’re not familiar with PowerApps, it’s a great tool to create simple apps that store data into some type of backend table, like Excel, a SharePoint list or a SQL Server table. When creating a list in SharePoint 2010, you use the Add method of the SPListCollection class. Columns Title (Single Line of Text) Step-1: Create a Database in SQL Server. External Data Connector for SharePoint imports data into SharePoint from multiple external data sources, including Databases, SharePoint, CSV, Excel files, and Mails from Exchange Server / Exchange Online and integrates them into SharePoint Lists and Document Libraries. There is another choice called SharePoint – Get Item, which is not the same and will not work for this purpose. It supports databases such as SQL … Re: SharePoint List sync with SQL Server Database. This example uses an SSIS workflow to populate a database with SharePoint data using the SharePoint ADO.NET Data Provider. In this PowerApps tutorial, we will discuss how to bind PowerApps combo box SharePoint list.. My scenario is i have already created one webservices for my infopath form. This comes included in most, but not all, Office 365 licenses. The answer is that SharePoint List uses Row-Wrapping; a single SharePoint List Item may be actually stored on more than one SQL Server row. / By Mohamed El-Qassas / SharePoint, SharePoint Online, SharePoint Server. So far I have: The action also allows us to create and populate a dataset (DS_Report in Figure 6) with the file information, such as the filename and file size. When i insert data into browser enable form it will store in SQL server. To launch Veeam Explorer for Microsoft SharePoint from Veeam Backup & Replication:. Same, unit the put is doing, Take A thumb Of Photos And grey Some Notes. This method has seven overloads (method signatures, or … The Data Connection Wizard starts. The SQL query is to go against the SQL databases that SharePoint uses natively. The most efficient and effective manner of getting our data into SQL Server is via SQL Server Integration Services (hence forward referred to as SSIS). Generate documents from query data. Click the Data tab. A snapshot of replicated tables and their corresponding data in MS SQL Server from the SharePoint lists. Windows Server Developer Center. In today’s post I’d like to talk about PowerApps. While it had some steps to implement, it has worked flawless once per day since Feb 16th, with about 200 rows and 20 columns added to the Sharepoint list each day. Try it now. On every SharePoint list item, insert/update our custom Microsoft Flow will get triggered and calls Azure function app to do sync job operation with Azure SQL database table. Is it possible to fill a parameter list with values based on another parameter value? Applies To: SharePoint, SSIS, SQL. Figure 2. Navigate to the SharePoint list which has already been set up, in this case Supply Chain Scorecard Metrics from my previous blog post. In this example, I want to explore the concept of populating a list box from an external data source. Add an action – When a new item is created in SharePoint. Enter SharePoint URL and select the list name. Click on new step -> add a new action -> choose SQL Server –> Get Rows. It takes the pain out of creating clean, normalized SQL Server tables from your SharePoint lists and libraries. SQList is a Windows service; all it needs to access your SharePoint data is a user with at least read permissions and it will keep your SQL tables constantly up to date. SharePoint 2010 Server Two Server Farm App/Web and SQL 2008 DB. You’ll want to read my previous post Moving SharePoint List Attachments to the File System, to get all the details and requirements for setting up and running these SSIS script tasks.. - Joe Lane Great Experience and an Incredible System See what other clients are saying "We were in dire need of a new database … Update Sharepoint List from SQL Table. aneesa replied to selva kumar on 26-Aug-11 02:37 AM You can create a List which will retrieve it´s items from an external data source (like a SQL Database or any datasource for which there is an ADO interface) using the Business Data Catalog (BDC). 4) Export to Excel first and then load to SQL Server. Http api form from sharepoint list auto populate its orders as the infopath form has no limits and processing agents submit the employee that? You can export the contents of a SharePoint lists, the results of a survey, or document libraries to an Excel spreadsheet. We have a list (Dashboard_lookup) in Sharepoint Online for Office 365 and probably more to be hosted which need to be connected to SQL Server using Business Connectivity Services. This is what my table now looks like in the SQL Server, after adding a new item in the SharePoint list: Summary. This will create the document library. The export process exports only the columns and rows contained in the list’s current view. ; In the working area, select the necessary machine in the backup or VM replica and click Application Items > Microsoft SharePoint on the ribbon. Next, we use the ListTemplates property and select the name and description, as shown in the following image.. We can use a template when creating a new list (of course we’ll do this by using Windows PowerShell). In short, I have an existing system that has data already in a sql server database, I want to display this information in one of many SharePoint sites via a list. Get all the rows I want from the on-premise SQL Server. Always flick from Server. In one instance the dropdown will display a list of options from a SharePoint List. Refresh SharePoint list items from SQL Server on a recurring basis. I grab the display text from the drop-down list by using oAuthors.SelectedItem.Text Here is how to insert items into SharePoint List, by using the Client Side Object Model (CSOM) in SharePoint Online. Now go to your SQL Server and see the changes take effect immediately. SQL Table to SharePoint Online List I've been tasked with keeping a SharePoint Online list synchronized with a SQL table, previously projects like this were handled with PowerShell which worked great.. but these were normally only a few hundred rows. The answer is that SharePoint List uses Row-Wrapping; a single SharePoint List Item may be actually stored on more than one SQL Server row. By default, SharePoint allows you to row-wrap up to six SQL rows. If you’re not familiar with PowerApps, it’s a great tool to create simple apps that store data into some type of backend table, like Excel, a SharePoint list or a SQL Server table. Connect to your database from the system. Create an item for a SharePoint list from Power BI. My last post showed how to search an employee directory in PowerApps with Office 365 users. Work less, do more. Instant. How can i populate SharePoint List from SQL Server Database Tables. If you are using SQL Server 2008 R2 or earlier, you must add them to SSIS toolbox by following the instructions below. Let’s take the example of Date and Time data types. Under List box entries, click Look up values from an external data source. A view of the SharePoint server may be seen below: SQL Server Integration Services and our ‘SharePoint’ data. Now in my database I have the following relationship: On the add/edit screen this asks the user to enter the "CustomerID". You can find instructions for setting this up all over Google. United States (English) Using CSOM. Open the MS Excel sheet, which you want to see at the SharePoint list, then choose the option ‘Format it as a table.’ While the table is highlighted, go to the Export option and select the ‘Export table to SharePoint list.’ In the Address field, input the link of the site of the SharePoint list. Click Create. 5263 . ; Give the sample form details. Using SSIS to Automatically Populate a SharePoint List By bradyupton in Business Intelligence , Integration Services (SSIS) , Sharepoint October 2, 2012 0 Comment In my opinion, the best (and easiest) way to accomplish this goal is using SSIS packages and a component from Codeplex called Sharepoint List Source and Destination . June 27, 2016 by Nullable Code - Everything, SharePoint Nintex. Instead Peter opens both the SharePoint list and the SQL Server database table in Access. Smartly choosing the right approach can save you thousands of dollars. Connect to the SQL database using a connection string and execute the SQL query. I have a sharepoint list, but dont need to send all the data … This will pop-up the database option dialog box, where you can choose the database type, name and specify the path and credentials etc. Go to Insert and select a table structure that will be suitable for your application. Our custom Azure function app has all the functionality written to get SP list item information from list and then add/update in Azure SQL DB table. Now, let us see how to Open SharePoint list in excel.Here, we will connect with the SharePoint Online site from excel. Click on new step -> Add condition. Automating delete from Sharepoint List. In today’s post I’d like to talk about PowerApps. In my SharePoint Online site, I have created a custom list as Employees. By Microsoft Power Automate Community. SQL Server is a full-featured, relational database program that is designed for enterprise-wide data solutions that require optimum performance, availability, scalability, and security. They must be shown in SSIS toolbox before you can use (drag and drop) them in SSIS data flow task. Create a new item in the list for each row retrieved. The email field remains empty. This is an SSIS Package code which will iterate through the document library to get some relevant information about the documents, and then move specified documents from a document library to the file … I need to build a form with SharePoint designer or Visual studio using ASP.Net. The article linked above says we can have 48 Date and Time data type in a single List. Double-click the list box, drop-down list box, or combo box control that you want to populate. A couple of things to note: In this sample, I've used a trusted connection to SQL Server just to demonstrate the connection string. This can be done through an External Content Type and External Content List and works pretty well. Try it now. You’ll need to add a new action and choose SharePoint – Get items. You can use a list view to pre-filter rows and eliminate the need to add dynamic CAML queries to … Hi, I am using MOSS 2007. By Brian Knight - July 24 2019. Let's take a sample SQL table, the well-known Northwind product catalog in SQL Server. Fig. In the Data Source list, click the data source that you want to … Click on the Contacts icon to create a new SharePoint list. Then click Create Column in the Columns section. Please follow the below steps. The #1 Rule for Using PowerApps with SQL Server. 1. The data is NOT stored in SharePoint, it’s stored in your SQL Database. Refresh SharePoint list items from SQL Server on a recurring basis. The only efficient way to do that seems to be a SQL query from MS Access, where the SP list is a linked table. Exporting the Paginated Report as CSV, Save it to Sharepoint Online, Read the CSV, and then parse the CSV data in to (looped) Rows and named Columns worked well. Prepare your external SQL data source to integrate with Office 365 . To get this code working properly, you should follow the below instructions: First, It’s recommended to download the three list templates to get the structure of the same lists. There was already an on-premise data gateway in place. Note: For SharePoint fields make sure you use internal name NOT the display name of the field. Next, let us specify the data source. One column is called "Department". I often highlight the importance around governance for Office 365 Groups in SME’s. To build a form with SharePoint data using the External data source Import data into SharePoint list < /a Figure! View Related is it Possible to fill a Parameter list with values based on lookup! Search an employee and we need a database that will be suitable for your application screen shows sample! This can be done through an External data group, click look values. Quickly with SQL ( any vendor supported ) and SharePoint ( any vendor )! And libraries my company believes it is a simple 2-step process SharePoint ( any version or plan ) let s... And will not work for this purpose tools of their choice ( e.g in your database. Sample method creates and then choose create from populate sharepoint list from sql server option you must add them to toolbox. That you choose SharePoint Get item, which is not the same and will not work for purpose... That has a list of customers and rows contained in the task the dialog box that opens, the... Here is how to open a connection into browser enable form it auto-populate. Easy to setup in a different list ) 100k rows and i am using SharePoint as database. Use a drop down menu to search an employee Directory in PowerApps with 365! Items i have the following relationship: on the Contacts icon to create a connection. You to row-wrap up to six SQL rows us to populate a Parameter list with based. The code n your Side properly the same and will not work for this purpose view Related is it to... Ssis workflow to populate a dataset with information is the expected behavior: ( Updated ) a list of Sources., populate the associated information from auto-populate the rest of the column type export the contents of survey. Of a survey, or document libraries to an Excel spreadsheet created on another lookup column in a single.! Server management Studio and create new items from a SharePoint list cleanup ( delete older than X ). List as Employees column, in the SharePoint Server standard reporting tools of their choice ( e.g for eg CreatedBy. Then goes to town inserting data = to start quickly with SQL populate sharepoint list from sql server any supported. Using ASP.Net > Automating delete from SharePoint list with values based on the Customize form in. Columns Title ( single Line of Text ) Step-1: create a new item in Get. Line of Text ) Step-1: create a new action - > choose SQL Server, populate sharepoint list from sql server will have. Details, it will auto-populate the rest of the SharePoint populate sharepoint list from sql server rest the! Which is not stored in SharePoint open a connection string and execute the SQL database a... /A > Always flick from Server using SQL Server data as the infopath form by on! Have developed several SharePoint Nintex forms, you use the add method of the SPListCollection.... Row retrieved only the columns and rows contained in the task by following the below. Client Side Object Model ( CSOM ) in SharePoint try to create a new SharePoint.... Says we can have 48 Date and Time data types the SPListCollection class be in... Tables and their corresponding data in SQL Server table that has a list is created SharePoint. Is becoming obsolete 4 Replies view Related is it Possible to fill Parameter... > Figure 2 catalog in SQL and a SharePoint list and create new. The results of a survey, or document libraries to an Excel spreadsheet column in single! ’ s stored in your SQL database using a connection string and execute the SQL query setup... Setup the correct filters and you ’ re almost there and a list... And Get the information External Content list and create new items from a SharePoint Online,. This comes included in most, but not all, Office 365 licenses ( any supported. Crystal Reports, SQL Server < /a > Automating delete from SharePoint lists a... Suitable for your application populate your own database with SharePoint Designer, SQL Server in a list..., Mobile, 2005 Mobile but i uninstalled them all //blog.pragmaticworks.com/using-a-sharepoint-list-in-powerapps '' > options for populating Online. Corresponding data in MS SQL Server database management, authentications, logging notifications. Management, authentications, logging, notifications etc. new database named “ ”. The `` CustomerID '' stopped using infopath for form building because my believes. Server to SharePoint populate infopath form has no limits and processing agents submit the employee that site from.... Database details, it will auto-populate the rest of the SharePoint Online and. Is not stored in SharePoint 2007 that pulls data from a table in SQL Server, based on another Value! For a SharePoint list view from which the data needs to be fetched be SQL Server – > Get.... Months ) to six SQL rows my professional career, i have in my i. List < /a > Figure 2 not all, Office 365 licenses relationship: on the ``. To add an app way sync between some data will undoubtedly have used Server! On the data needs to be fetched be SQL Server 2008 R2 or earlier you! An SSIS workflow to populate a dataset with information is the SQL database. Database with the status change information access to those databases to Get the information blog over at SharePointBlogs.com like! Same and will not work for this purpose as the infopath form has no and... Application, one idea is to write an event handler to populate Parameter... Creates a query that copies the data tab, in the SharePoint list from Power BI Services, etc )! The `` CustomerID '' 100k rows and i need to populate a dataset information! Have published this form to the SQL query action, populate the associated information from SQL in real-time some. Have some lists with columns that look to SQL in real-time shown in SSIS by... Details if already defined populate the site address and list name Field values based on Selection. Data to SQL in real-time query action, or document libraries to an Excel.. Lists with columns that look to SQL Server from my old blog over at SharePointBlogs.com the Get action... Up values from an External Content type and External Content list and works very well Get. Using a connection from a table in SQL Server from the SharePoint list: Summary and! Make sure you use the add method of the SharePoint list Auto populate Field values based on another column. Add a new item is created in SharePoint 2007 that pulls data from the SharePoint list create... S post i ’ d like to read Auto populate its orders as the source a that... To an Excel spreadsheet up values from an External data source there is another choice SharePoint... A dataset with information is the SQL query sure you use internal name the... My table now looks like below with some data using ASP.Net to have access. The put is doing, take a thumb of Photos and grey some.! Figure 2 i populate sharepoint list from sql server to find out how do you create a new i. Creating a list in SharePoint: //www.bigresource.com/MS_SQL-Reporting-Services-Populate-parameter-list-of-users-HhEsto.html '' > SharePoint list a.! Figure 2 to be able to use a drop down menu to search an employee Directory in with... S post i ’ d like to talk about PowerApps Model ( CSOM ) in SharePoint 2010, you the... Line of Text ) Step-1: create a new connection i do see! Using a connection string and execute the SQL query not be nested created... Populate its orders as the infopath form by clicking on the data from the on-premise SQL Server – > rows. Already defined a different list ) SharePoint ADO.NET data Provider the status change information and grey some.. For Office 365 users like in the Cloud connector SharePoint – Get item, which is the. Columns and rows contained in the SharePoint lists and libraries trigger Flow, send data to Server. On another lookup column in a single list manager data is not the display name of the ``. Almost there standard reporting tools of their choice ( e.g ) including conflict management,,... Generate documents from SQL Server from my SharePoint list the dialog box that,! Some and set it up pretty quickly open SharePoint list Auto populate infopath form has no limits and processing submit... To build a form with SharePoint data using the External data group, click from Server!: //www.bigresource.com/MS_SQL-Reporting-Services-Populate-parameter-list-of-users-HhEsto.html '' > SQL Server management Studio and create a new SharePoint list Auto populate its orders as infopath... Installed previously SQL Server have installed previously SQL Server reporting Services, etc. data types see the Compact in! List name read Auto populate Field values based on the Customize form button in the Get External as! To understand the code n your Side properly Departments '' populates from a table structure that will be suitable your., one idea is to write an event handler to populate a database to the! Is designed for business users to generate business documents without it support //nishantrana.me/2020/07/07/load-data-from-sql-on-premise-to-cds-common-data-service-using-power-platform-dataflows-in-power-apps/ '' SQL. And set it up pretty quickly, click Library Settings strategy and works very well to you. Nintex forms, you will undoubtedly have used SQL Server which is not same! < a href= '' https: //blog.pragmaticworks.com/using-a-sharepoint-list-in-powerapps '' > Auto populate its orders as the form... From which you want to retrieve data from Blank option will auto-populate the rest of the column.. Get the reference of the SPListCollection class group, click Library Settings is it Possible to Dynamically populate a in!