Practical Microsoft 365 articles, implementation notes, and hands-on solutions.
645 articles
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...
Get A Value From A Record (Lookup & Positional) Input collection: myCars23 SerialNo Year Make Model 6453 2016 Toyota Corolla 8946 2014 Honda Civic 3571 2019 ...
Get A Value From A Table Stored In A Cell Input collection: myMeetingRooms48 Info value This is a list of meeting rooms [object Object], [object Object]… Not...