Practical Microsoft 365 articles, implementation notes, and hands-on solutions.
665 articles
Group By And Find The COUNT Input collection: myTravelExpenses9 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...
Group By And Find The MAXIMUM Values Input collection: myTravelExpenses 7 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 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...