Practical Microsoft 365 articles, implementation notes, and hands-on solutions.
645 articles
Remove Columns From A Collection Input collection: myTeams43 Team Person1 Person2 Person3 Team A Jen Phillips Leonard Petersen Murray Cole Team B Percy Walte...
Rename The Columns In A Collection Input collection: myInventory34 ID Name Quantity 1001 Desktop PC 10 1002 Monitor 23 1003 Laptop 16 Output collection: myIn...
Replace All Values In A Column Input collection: myInspections18 Location Date InspectionCompleted Headquarters 1/1/2020 Yes Branch 1 1/1/2020 Yes Branch 2 1...
Replace Cells In A Collection With Blank Values Input collection: myOrders49 OrderID Item UnitsOrdered CostPerUnit 1001 Notebook 25 2.5 1002 Crayons 8.62 100...
SORT A Collection By One Or More Columns Input collection: myCities35 City Country Population Los Angeles United States 4000000 Toronto Canada 2930000 New Yo...
Split A Text Column By A Delimiter Input collection: myContactNames16 FullName Email Johnson, Bruce [email protected] Field, Sally [email protected] Nyugen, ...
Ungroup A Table Stored In A Cell [object, Object] Input collection: myMeetingRooms47 Info value This is a list of meeting rooms [object Object], [object Obje...
UNIQUE Values From A Collection Column With A Blank At The Top Input collection: myCities55 City Continent Country New York North America USA London Europe U...
UNIQUE Values From A Collection Column Input collection: myCities1 City Continent Country New York North America USA London Europe United Kingdom Kyoto Asia ...