Practical Microsoft 365 articles, implementation notes, and hands-on solutions.
665 articles
COUNT The Unique Values In A Column Input collection: myCities24 City Continent Country New York North America USA London Europe United Kingdom Kyoto Asia Ja...
Export a Collection To A CSV Input collection: myOrders37 OrderID Item UnitsOrdered CostPerUnit 1001 Notebook 25 2.5 1002 Crayons 15 8.62 1003 Binders 10 13....
Export a Collection To A Datasource (SharePoint List, Excel, SQL, CDS) Input collection: myOrders54 OrderID Item UnitsOrdered CostPerUnit 1001 Notebook 25 2....
Export a Collection To A HTML Table Input collection: myOrders38 OrderID Item UnitsOrdered CostPerUnit 1001 Notebook 25 2.5 1002 Crayons 15 8.62 1003 Binders...
Export a Collection To A JSON Input collection: myOrders36 OrderID Item UnitsOrdered CostPerUnit 1001 Notebook 25 2.5 1002 Crayons 15 8.62 1003 Binders 10 13...
Fill Blanks In A Column With Last Non-Blank Value Input collection: myCities52 Country City Population United States New York 8600000 Los Angeles 4057000 Chi...
Filter A Collection With AND Condition Input collection: myTrucks40 Year Make Model 2020 Ford F150 2018 Chevy Silverado 2019 Ford F150 2020 Chevy Avalanche 2...
Find Matching Values Within Two Collections Input collection: myFruit27a Value Apples Oranges Bananas Kiwis Grapes Pears Input collection: myFruit27b Value A...
Get A Column From A Collection Input collection: myCars45 SerialNo Year Make Model 6453 2016 Toyota Corolla 8946 2014 Honda Civic 3571 2019 Toyota Camry 1165...