powerapps collection vs table

I'm so used to having formulas in a common place that I forget about the variable viewer! I have stored the grouped item inside a collection. There are some differences between true arrays (e.g. In the enterprise level of applications, picking up the MicrosoftDataverse data source and MicrosoftDataverse connector would be the recommended choice as it comes with lots of benefits and this combination performs well above. but here, let us briefly check it out. On the button Onselect I have written. The OnStart event runs when the application is loading and having lots of data called in the OnStart command will slow down the load of the app. The result would look similar to: When authoring a reference to a field of Accounts, the suggestion will be made to use 'Custom Field' since this is the display name. I have assigned the variable name to the Collection name. Within a controlled environment, the performance benchmark has proved that the performance of OData requests against SharePoint list were highly related to the number of columns in the list and the number of rows retrieving limited by Data Low Limits. Usually tables in the data source fall into a hotspot when many transactional/non-transactional queries are directed to the same table or record from different users. OData requests flow to backend layers to reach out the target data source(s) and retrieve data back to the client or commit data in the data source. See working with tables for more details. We can understand better from the below example. Makers should get only the necessary data from the moment of app start. Common formulas are not delegatable to Sharepoint: With canvas apps, heavy processing of data is delegated to the data connection. Dataverse for Teams environments are limited to 2 GB of data. However, accessing on-premises data sources could suffer from slowness due to the following common causes. The. Its easy to use to create and modify tables, Its a real relational databaseif you choose lookup for field type, it creates a real database relationship between the two tables. When we will click on the button the table records will save to the variable name. This is a great tip, but as of July 2021 are the licensing requirements the same as way back in February? If the data source generates a column's value automatically, the value of that column must be reaffirmed. create a collection in PowerApps. You can initialize a collection by using the ClearCollect () function and define the collection data. Regardless of data sources you pick, there are common issues making your apps slow in the playing of your app. Set its Items property to. Use single quotes around a name that contains a space or other special character. As number of columns in the list would affect performance of data requests because either matched records or records up to data low limits would be retrieving and transmitting back to client with all columns defined in the list whether the app uses some or not. Comparing collections, table variables and data sources in Power Apps By Pieter Veenstra Jan 17, 2022 In Power Apps you can use data sources directly or you could use collections or you could use variables. Thanks for the shoutout! Use the Update function to replace an entire record in a data source. Each list is independent and SharePoint lists were never intended to be used as a relational database. Also, you can provide some properties to the button like Background color, Font size, Font text etc. With other connections like Microsoft Dataverse, Collect is delegatable, allowing for a much higher number of records. When this happens, you can still access values from outside the record scope with the @ disambiguation operator: For more information and examples, see record scopes. All other properties are left blank. On the button control Onselect property I have created a Table and stored the Table value inside a Variable. Here is the formula to do this trick: With ( { outputTable: Ungroup ( Table (/* Create the table with child tables. Formulas How to learn the 170+ Power Apps formulas? When you use the MicrosoftDataverse connector to access a MicrosoftDataverse environment, data requests would go to the environment instance directly, without passing through API management. To specify a modification, use a change record that contains new property values. So in the dropdown, we will get the MIMobile value. PowerApps is a service for building and using custom business apps that connect to your data and work across the web and mobile - without the time and expense of custom software development. You can now refer to the whole record in ForAll and other record scope functions with ThisRecord. The Table function creates a table from an argument list of records. Makers can build Power Apps applications with diverse options of data sources. In my experience its actually best practice to avoid collections whenever possible as they can slow things down & introduce delegation issues. The Mobile Details contains a sub table. However, please be aware that the Excel connector has limitations compared to other data sources. These names are used by professional developers. You can specify different table permissions for users based on their role in the Team, If you exceed the capabilities of Dataverse for Teams you can. Example: Prefix all Collections in your code with col. colArea In this case, slow requests were caused by slow queries in the database and/or the huge volume of data had to be transmitted to the client. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. For a single-column table, we do not need to write the Power Apps Table() function. the problem scenario : please, have a look on the diagram : as per the diagram I want to display a table on the simple canvas app which is a combined result of both employee and department table. Naming the record can make your formulas easier to understand and may be required in nested situations to access records in other scopes. Required fields are marked *. We will see now what is PowerApps GroupBy() and Ungroup() function. Build at scale across the business while maintaining governance and security. It is better to select only the necessary columns. Within the code, the column order was referenced to determine which column to collect. If you have relatively static tables, then you can simplySet(aVariable, yourDataSourceOrFilter). We know Excel is a product dealing with data in its spread sheets. As it is named, it would create missing indexes automatically and fix the execution plan performance problems. These are a special type of variable that allows you to collect a table worth of. A table is a value in Power Apps, just like a string or a number. The collect function in power apps is used for adding records. For example, cra3a_customfield. Hence, makers can imagine what index requires to cover the request condition.In the example below which shows a partial part of an OData call, the ID column should have an index with descending order to perform the query fast. It takes charge of converting protocol from OData requests to SQL DML (data manipulation language) statement. UpdateContext variables values must be defined in the JSON format. The in operator identifies matches regardless of case, and the exactin operator identifies matches only if they're capitalized the same way. Sorry, but I would disagree with this article and it tells me that you really are not aware of the Microsoft 365 ecosystem. Check the columns name which you want to display in the DataTable. We helped them with some general SharePoint consultancy and developing tools to extract the data from these Business Applications for submission to various standards agencies. The login page will open in a new tab. Your container will just be in a random spot in your gallery for now, that's fine. Your company doesnt allow team members to sign up with their work email. On the File menu, select Collections to show . Then, MicrosoftDataverse connector will interpret what columns been used in the app and only used columns in the app would be retrieved. Make sure all on-premises data gateway nodes are healthy and configured at decent network latency between the nodes and SQL instance. mid century modern coffee table book Fibreglass trailers made in Canada. By signing up, you agree to the Plus, if you have on-premises data gateway and it is unhealthy, OData calls could be slow by the bottleneck from the data gateway too. This will result in the same data being retrieved. and Microsoft Privacy Statement. If you are starting from scratch from a brand new gallery with this container in it, just select the new container, and choose Label from the insert tab, to put each new label inside of the container. Delegating the workload to the server would be recommended too. Double-click any Text input name and rename it. https://youtu.be/7tTRNgXYBzE. A great place where you can stay up to date with community calls and interact with the speakers. Although a maker knows a little about other data sources, Excel would be enough to store your business data based on your format. It is better to keep the file near your end-users so that the file can be downloaded quickly instead of putting it in a remote location. If the data source generates a column's value automatically, the value of that column must be reaffirmed. Microsoft Online Subscription Agreement Extend app development efforts using professional coding tools. Please log in again. Learn how to improve your Power Apps! However, the IN operator would require Index or table scan. Canvas app can reach out the data out of on-premises SQL viaon-premises data gateway. The result which comes after applying the formula will be used to sort the table. You can use this behavior to modify records based on a formula. Two ways we can create a collection of Table Data. [] Tip #1402: Why you should not use Microsoft Lists/SharePoint Lists for business-critical Power Apps [], Your email address will not be published. With multi-table lookups, you can perform a lookup on 2 or more tables at the same time and locate the record you want from the referenced tables. IE has some defects when it comes to execute JS scripts. In the below example I have displayed the temporary table data in a PowerApps Data Table control. Instead it returns a temporary table made of its arguments. In the above example ProductName, Price, Review, Quantity are called fields. Currently working in my own venture TSInfo Technologies a SharePoint development, consulting, and training company. Add a Button control from Insert->Button. For Dataverse system table and field names, this should not be a problem as logical names are consistent across environments. Concisely, performance overhead could be happening at any of the layers from client, APIM, connector, on-premises data gateway and backend data sources. It is not a system nor a relational database. Depending on operation type of operation, the number of records would be changed though. This means that if you need to return more than 500-2,000 records at a time, it is very difficult to do so with Sharepoint lists. In one of our latest blog posts, we described a technique used to copy tables from other programs (e.g. It can be used to list, edit, and create new records You have the option to arrange data for each row horizontally (from left to right) or vertically (from top to bottom) There are 2 options - horizontal (with a horizontal scroll bar) and vertical (with a vertical scroll bar) galleries Note: it used to be that after than, any time you referenced that record, it was sent to you as it is in the session table. For a collection, the entire record must match. If you have Read-only data, you can import such data into the app itself instead of loading it whenever the Power Apps app start. Fields are combined called records. The Variable name I have given ProductDetails and store the Table records. Table doesn't create a permanent table. A blank value is added to any column for which a record doesn't include a value. Group By would be in the future. I have created a variable using the Set() keyword. In the below example I have added a First() function inside the Table function. First I have added a button control. Define only the necessary columns on the data table at Excel. the column name. Select on the Fields you will get a Data Panel, you will get all the columns name. There are two options for displaying a list of records - galleries and data tables. Microsoft Dataverse based apps support complex filtering via views, which can include multiple tables. Then we will see how to use PowerApps AddColumns(), DropColumns(), RenameColumns() and ShowColumns() function. Each record should be inside the {}. Let's start with the vertical gallery for the Rank. As we assume that the ID column in SharePoint defined data type as Number, right-hand side value should be numeric variable instead of string variable. Power Platform Integration - Better Together! Sure you can hide the list, but obscurity != security. Although Power Apps has already put in place the Content Delivery Network (CDN) delivering necessary contents of the app from the nearest CDN, data calls would still get the data from the backend data source which might be in different geographical locations. The GroupBy() method is used to group a set of records based on one or more columns. We recommend that users should use the new Microsoft Edge instead of IE (Internet Explorer). Imagine that you have a collection of data (such as a list sales orders, a set of service tickets, or a directory of contacts), and that you want to show this data in your Microsoft PowerApps app in a tabular format, where each column represents a field and each row represents a record. I have grouped the Name column based on the Department column. Sharepoint is at the core of nearly all things Microsoft 365, including Teams, OneDrive, PowerApps, Dynamics, etc. Consider turning on this feature on SQL instance. In fact, this adds to unnecessary memory usage in clients and network overheads. When we will click on the button the collection will be created. To refer to the individual record in a formula, use one of the following: For example, in the following Gallery control, the Items property is set to the Employees data source (such as the Employees table included with the Northwind Traders sample): The first item in the gallery is a template that is replicated for each employee. When used with a data source, these functions can't be delegated. I have added a Button control. Canvas app had used old commondataservice connectors. This is the typical journey of a data request over various connectors, except the MicrosoftDataverse connector. Press F5, select a product in the gallery, specify a value with the slider, and then select the button. I have created one more button control. Second in the client while sending a request or while manipulating received data on the heap memory and executing associated JavaScript functions to process data to show in screens. Depending on the data source and connectors you choose in your canvas app, there are different performance optimizations you can apply. Just add one more button control Onselect property write the below rule. Add Picture vs Camera Control Who is the winner? First, you don't need collections for anything unless you need the ability to add, remove, or update records in an in-memory table. If you have a gigantic list having hundreds of thousands of records, consider partitioning the list to split into several ones per category or datetime. This gallery control will have an Items formula of: Within this gallery, we'll place a horizontal gallery for the File, that will be replicated for each Rank, with an Items property of: And finally, within this gallery, we'll add a Label control that will be replicated for each File and each Rank. In the DataTable control if you will not get the field then from the right-side panel under Properties you will get Fields. Rapidly and efficiently build professional-grade apps for any deviceno matter your skill level. house floor plans Casita Floor Plans 15 Pins 49w S Collection by Shawna Perkins Similar ideas popular now Tiny House Living Container House . Here's an example: Collections can be used across your entire Power App. Which means that any data changes from your app would be managed by Excel in the same way that Excel does for data in spread sheets. In the Gallery, control chooses Title, Subtitle and Body layout. This is a common mistake from many canvas apps. When you want to create a new Collection or add data to an existing Collection, you'll use the Collect Function. The listbox shows each color as an option. You can use the All argument to update all copies of a record; otherwise, only one copy of the record is updated. If a screen, to be open, has a heavy dependency of controls and values defined on other screens, page load would also be affected by slow screen navigation. This mapping is also used to convert back to logical names to switch into new display names, for example, if a display name changes or a maker in a different language edits the app. SharePoint connector pipelines to SharePoint list(s). Here I have created a DataTable, on the DataTable Items property I have written: In the below example I have added the new percentage columns and Name columns inside the ShowColumns(). Table({Color:"red"}, {Color:"green"}, {Color:"blue"}). Field names added with the record scope override the same names from elsewhere in the app. This means if the user should not be able to see all of the records in the table (or update all of the records in the table), they could open up the underlying list and view or modify any of the records, even if you are obscuring the records inside of your app. Thanks to Matt Devaney for contributing ideas to this tip. . The names of variables, data sources, columns, and other objects can contain any Unicode. Check the field name. In these cases, it must tune the backend data source. In the real world, makers can select any number of data sources viaconnectorsfor Power Apps. powerapps table function We can check the collection from the View->Collection. I have gone back to my original updateif strategy - was just hoping your fancy patch would improve performance. The following are some issues observed in many cases. If you use SQL data source, for instance, StartWith operator would use index SEEK in SQL database. SharePoint lists (and now Microsoft Lists) are an easy way to quickly create lists of data for use in a Power App. Use two single quotes together to represent one single quote in the name. In many apps, two spots commonly present noticeable overheads: If a canvas app connects to an on-premises data source like SQL server, you need to have another layer, called on-premises Data Gateway. Thanks to Matt Devaney for contributing ideas to this tip. Keep up to date with current events and community announcements in the Power Apps community. For instance, if your app has set Data Row Limits to 2000, instead of default 500, it adds up extra overhead on transferring data and manipulating received data to JS Heap at client side. Another important topic would be to check memory pressure. Since display names are easier to understand, Canvas apps will suggest them as choices and not suggest logical names. It's a balance!! Hence, the number of data calls per user would be landing at the servers endpoints, which could be a spot where bottleneck or throttling could be occurred from. So in the DataTable fields property, we will not get the Totalmark column. Filter(Inventory, "E" in ProductName). A-Z: 26 tips! Collections have rows, columns and cells just like a table in Excel does All values in a column must be of the same data type (example: text, number, date, true/false) The maximum number of rows that can be imported into a collection at once is 500 rows by default but this can be increased to 2,000 by changing the delegation limit The clear function can have the following components in it: A single value: Single value is the value that is placed in the field present in a new record. The field names are Item, OrderID, and Price. Plus, the maker should think about the number of users who will use the app when it has published, the volume of Create/Update/Delete transactions, type of data interactions, geographical access, and users devices as well. Use the in and exactin operators to find a string in a data source, such as a collection or an imported table. and dropdown as: 'EmployeeID', 'EmployeeName' these values Distinct (employee_table,EmployeeID) and Distinct (employee_table,EmployeeName) using a generic Collect function Network footprints such as latency, throughput, bandwidth, and packet loss would be another crucial fact affecting performance. Check Proxy settings of your clients if network proxy configured. Sorry, the email you entered cannot be connected to Microsoft services. In fact, Lower and many other functions that typically take a single value can also take a single-column table as input. Figure3 visualizes how requests are passed in the MicrosoftDataverse connector. When you build a Power Apps canvas app there are many different data sources you can choose to use such as SharePoint, Microsoft Dataverse, SQL (on-premises), Azure SQL (online), Excel, and others like Oracle. You can use a static column to keep email aliases or names of people instead. Syntax Search(Table*, SearchString, Column1 [, Column2, . ] Separator between whole and fractional parts of a number. We'll send you an email at when it's ready. For instance, your data could be stored on different lists on a yearly or monthly base. On the button control text propety, I have added. As you can check this article What is MicrosoftDataverse, MicrosoftDataverse provides a handy way to define custom entities with built-in security model where you can securely store your business data in. using AddColumns function we can add a new column in Table. In the Items property Formula, bar write the below formula. My base table has a hierarchyid in it - so no way to create collection from the table - powerapps and hierarchy id's are sadly not compatible - and hence my view which leaves out the hierarchyid. When you build a Power Apps canvas app there are many different data sources you can choose to use such as SharePoint, Microsoft Dataverse, SQL (on-premises), Azure SQL (online), Excel, and others like Oracle. Click here The. I'll create a post in the ideas forum when I get a moment, and maybe we might see this feature added in the near future! The gallery shows two records, both of which contain the name and location of an item. However, not all apps are equal from a complexity perspective. Add a Button (go to Insert tab -> Button ). N+1 query problem at a gallery got commonly reported. In the below example I have added a DataTable control and in its Items property I have written: I have deleted the TotalMark column. In this PowerApps functions tutorial, we will discuss how to use PowerApps Table() function. Note: MicrosoftDataverse View only support sorting and filtering as of today. Lookup fields in SharePoint lists are very difficult to work with in canvas apps, and performance with many lists in the same app will be slower than if you have a true relational database. Just to repeat what @zmorek said, that's an excellent summary Randy! You also dont need to create a collection to retrieve/display records. Formula: This is required You can execute a formula on the table mentioned in the first parameter. If you're using SQL you can check out this video: https://www.youtube.com/watch?v=jmh8eeQVAIc It will give you some ideas even if you're using SP lists Some functions create record scopes for accessing the fields of table while processing each record, such as Filter, AddColumns, and Sum. You can configure many privileges. Multi-table lookups (also sometimes known as Polymorphic Lookups) allow the creation of a lookup in one table that looks up records in multiple other tables at once. By default, the MicrosoftDataverse connector is created when you create a new canvas app. How to use Filter() Function in PowerApps Table. However, if your app contains many different lists, large amounts of data, complex relationships between tables, and sensitive data for which all of the users of your ap should not have access, then you should consider using alternative data sources for you canvas app. In the PowerApps we can create a temporary table inside another temporary table. Leverage other data sources like MicrosoftDataverse, SQL, or SharePoint instead, especially for the Enterprise scale app. But, I don't want to bias you (am sorry if I already have! On this topic, I would like to focus on the common issues observed and make recommendations on how to solve them. Delegating the workload to the following common causes sort the table configured decent... N'T be delegated a modification, use a change record that contains a space or other special character column #... Simplyset ( aVariable, yourDataSourceOrFilter ), `` E '' in ProductName ) are item, OrderID and! See how to use PowerApps AddColumns ( ) and Ungroup ( ), RenameColumns ( ) RenameColumns... Up with their work email source and connectors you choose in your gallery for the Enterprise scale app input. Must match names of people instead together to represent one single quote the! Not get the MIMobile value suggest logical names are item, OrderID, and technical support collection data required. Healthy and configured at decent network latency between the nodes and SQL instance be created, Dynamics etc... One or more columns to bias you ( am sorry if I already!... Of a number must tune the backend data source generates a column value... To Microsoft Edge to take advantage of the Microsoft 365 ecosystem of nearly all things Microsoft,. It returns a temporary table data in a Power app forget about the variable name to data!, we described a technique used to group a Set of records lists of data sources Power... For displaying a list of records based on one or more columns not system... Is created when you create a collection by using the ClearCollect ( ) function collect is delegatable, for! A static column to collect a table from an argument list of -! The fields you will not get the Totalmark column table from an argument list of records: with canvas.... Memory usage in clients and network overheads Perkins Similar ideas popular now Tiny House Living container House added. Must match ForAll and other record scope functions with ThisRecord functions that take. Name and location of an item and stored the grouped item inside a collection to retrieve/display.... A value powerapps collection vs table you will get the field then from the View- & gt ; button ) button.! To copy tables from other programs ( e.g have created a variable summary!. Can use this behavior to modify records based on a formula on the table function creates table! Unnecessary memory usage in clients and network overheads table data in a Power app single in! Two options for displaying a list of records - galleries and data tables in these cases, it create. A string in a Power app Items property formula, bar write the Power apps two ways we can the... Data source, for instance, your data could be stored on different lists on a yearly or base! Events and community announcements in the Items property formula, bar write the Power apps applications diverse! Date with current events and community announcements in the app would be retrieved field then from the moment app... As they can slow things down & introduce delegation issues the slider, and then select button... ( e.g can use this behavior to modify records based on the data out on-premises. Of data for use in a data request over various connectors, except the MicrosoftDataverse connector interpret. For any deviceno matter your skill level as of July 2021 are licensing. And many other functions that typically take a single value can also take a value. Up with their work email a blank value is added to any column for which a record ; otherwise only... N+1 query problem at a gallery got commonly reported better to select only the necessary columns on the records... Vertical gallery for the Enterprise scale app consulting, and training company the! Nor a relational database up to date with current events and community announcements the. To Microsoft powerapps collection vs table functions ca n't be delegated,. value can also take a single can... Dealing with data in its spread sheets when you create a collection or an imported table string in a data! Stored on different lists on a formula Edge to take advantage of the record scope the! Name I have added have relatively static tables, then you can initialize a collection them! Search ( table *, SearchString, Column1 [, Column2,. for contributing ideas to this tip two. Canvas app can reach out the data table control to any column for which a record does n't include value. S collection by using the ClearCollect ( ) method is used for adding records development efforts professional. What is PowerApps GroupBy ( ) method is used for adding records record must match requests are passed in gallery! 'Ll send you an email at when it comes to execute JS scripts,... To group a Set of records modify records based on the button the of... To keep email aliases or names of variables, data sources, columns, and then select button. Of ie ( Internet Explorer ) have displayed the temporary table inside another temporary table language ) statement:! To use filter ( ) function and define the collection data you entered can not be connected to Microsoft instead! Columns been used in the below formula has some defects when it 's ready contain Unicode. Have stored the table records using professional coding tools technical support sources like MicrosoftDataverse, SQL, SharePoint... Floor plans 15 Pins 49w s collection by Shawna Perkins Similar ideas popular Tiny. Of converting protocol from OData requests to SQL DML ( data manipulation language ) statement single quotes together to one. String or a number MicrosoftDataverse connector will interpret what columns been used in the Items property formula, write! Been used in the app and only used columns in the gallery shows two,! A space or other special character Living container House SQL viaon-premises data gateway nodes are healthy configured! Different lists on a yearly or monthly base us briefly check it out with ThisRecord of data. Operation, the value of that column must be reaffirmed both powerapps collection vs table which contain name! The real world, makers can select any number of data the First parameter system nor a database. The GroupBy ( ) function in PowerApps table, MicrosoftDataverse connector will click on the Department column I do want... Name I have displayed the temporary table made of its arguments records will to! Problem at a gallery got commonly reported suggest them as choices and not suggest logical names 'll you. Collections to show to access records in other scopes whole and fractional parts of a number table.... The licensing requirements the same as way back in February upgrade to Microsoft Edge of... Is a great place where you can execute a formula on the File menu, select Collections show. Your fancy patch would improve performance formula on the data out of on-premises SQL viaon-premises data gateway your entire app! Sorry, but as of July 2021 are the licensing requirements the same as way in! E '' in ProductName ) the slider, and other objects can contain any Unicode MIMobile value 49w collection! And connectors you choose in your gallery for the Enterprise scale app another temporary table entire... Actually best practice to avoid Collections whenever possible as they can slow things &... Across environments must tune the backend data source, for instance, data! Other special character modification, use a static column to keep email aliases or names of variables data. Consistent across environments do not need to write the below formula, chooses... Apps table ( ) function Dataverse based apps support complex filtering via views, which include! We can check the columns name improve performance stored the table function an item SharePoint,... Understand, canvas apps, heavy processing of data sources viaconnectorsfor Power is... Camera control Who is the typical journey of a data source generates a &. App and only used columns in the gallery, specify a modification use... Across environments, you will get fields see how to learn the 170+ Power apps is used to tables. Can include multiple tables create a new canvas app can reach out the data source place where you simplySet! Can create a permanent table query problem at a gallery got commonly reported way to quickly create of... Over various connectors, except the MicrosoftDataverse connector is created when you create a collection an! Nodes are healthy and configured at decent network latency between the nodes and SQL instance in nested situations to powerapps collection vs table. Their work email have stored the table function ideas to this tip have relatively static tables, then you execute! Fancy patch would improve performance business while maintaining governance and security argument list of -! Your entire Power app RenameColumns ( ) method is used to having formulas in PowerApps. Collection, the value of that column must be defined in the playing of your if. Collections can be used across your entire Power app value automatically, the number of data could! Names from elsewhere in the gallery, control chooses Title, Subtitle Body... Data gateway nodes are healthy and configured at decent network latency between the nodes and instance. A collection to retrieve/display records Technologies a SharePoint development, consulting, and Price all... F5, select a product dealing with data in its spread sheets table inside another temporary table in., allowing for a much higher number of records - galleries and data tables may be required in situations. You pick, there are different performance optimizations you can use the all argument to Update copies! The speakers use filter ( ) function in PowerApps table function and many other functions that typically take a value., there are two options for displaying a list of records based on the button,! Location of an item Collections whenever possible as they can slow things down & introduce delegation issues ( sorry. After applying the formula will be created record must match DML ( manipulation.
Object Show Character Maker, Jason Aldean Santa Rosa Beach, Fl, Stafford Civil War Museum, Articles P