Practical Microsoft 365 articles, implementation notes, and hands-on solutions.
645 articles
Group By And Find The MINIMUM Values Input collection: myTravelExpenses 8 Date Item Value 1/1/2020 Hotel 1050 1/1/2020 Food 30 1/2/2020 Food 75 1/3/2020 Hote...
Group By And Find The SUM Input collection: myTravelExpenses6 Date Item Value 1/1/2020 Hotel 1050 1/1/2020 Food 30 1/2/2020 Food 75 1/3/2020 Hotel 1300 1/3/2...
Insert A New Row Into A Collection Input collection: myTestScores31a FullName Age TestScore David Jones 32 78 Anne Lisbon 45 92 Penlope Parra 26 56 Input rec...
Insert Multiple Rows Into A Collection Input collection: myTestScores32a FullName Age TestScore David Jones 32 78 Anne Lisbon 45 92 Penlope Parra 26 56 Input...
JOIN All Columns From Another Collection Input collection: mySales4 ProductID QuantitySold 1001 4 1002 5 1001 7 1000 1 1000 8 Input collection: myProduct4 Pr...
JOIN One Columns From Another Collection Input collection: mySales3 ProductID QuantitySold 1001 4 1002 5 1001 7 1000 1 1000 8 Input collection: myProduct3 Pr...
MERGE Two Columns Into A Single Column Input collection: myContactNames17 FirstName LastName Email Johnson Bruce [email protected] Field Sally [email protect...
Remove A Row From A Collection Input collection: myTrucks50 Serial Year Make Model 8943 2020 Ford F150 4623 2018 Chevy Silverado 2315 2019 Ford F150 5466 202...
Remove All Columns From A Collection Except Input collection: myTeams44 Team Person1 Person2 Person3 Team A Jen Phillips Leonard Petersen Murray Cole Team B ...