Concatenates formula results across table records into single string. Requires table, formula, and separator parameters. Used to store data from tables/collections in single column
Display form controls show all or selected fields in data source. Edit form controls allow editing, creating, and saving records. Gallery controls show tables with form controls for selected records. Multiple Button controls enable save, cancel, and record creation
Gallery control displays multiple records from data sources like SharePoint and Excel. Allows users to view, edit, and interact with data
XYZ Inc. sales agent uses static application to enter order details. Static application creates new items on SharePoint list when submitted. Custom Power App enables dynamic order details entry
InfoPath is a form design program for structured data in Microsoft Office 2003. Features WYSIWYG form designer with hierarchical data field view. InfoPath 2013 became standalone download in 2015, requiring Office 365 ProPlus
Use Concurrent function for cloud data loading, not device-local data. Write formulas that can be delegated to cloud data sources. Cache frequently used data in collections and variables. Limit collection size to minimum required rows and columns