This video demonstrates how to use Power Automate to work with arrays and objects from SharePoint lists. It covers the concepts of get item, get items, apply to each, select, join, and expressions. It also shows how to avoid or understand common errors and how to manipulate data efficiently.
[00:00:00] The purpose and overview of the demonstration
To show how to avoid or understand apply to each
To use expressions, select, and join actions
To work with people pickers and multiple choice fields
[00:00:41] The SharePoint list and its columns
A list of 10 items with various columns
Industry column is a choice type with multiple selections
Account manager column is a people picker with multiple selections
[00:01:37] The get item and get items actions
Get item returns a single item from a list
Get items returns a table of data from a list
The output of each action and how to examine the JSON
[00:03:54] The apply to each and compose actions
How to use compose to output dynamic values
How to use apply to each to loop through an array
How to examine the expressions and understand the syntax
[00:06:35] The variable and append to string actions
How to use variable to store a string
How to use append to string to add values to the string
How to compare the efficiency of variable vs select
[00:08:12] The select and join actions
How to use select to filter an array and output only the values
How to use join to combine the values of an array into a string
How to avoid the extra semicolon at the end of the string
[00:11:46] The first expression and integer indexes
How to use the first expression to get the first object from an array
How to use integer indexes to get a specific object from an array
How to avoid the error of selecting values from an array
[00:15:46] The industry column and multiple choice values
How to use the industry column as an input to an apply to each or a select
How to use the value key to get the values of the multiple choice field
How to use the join expression to create a string of the values
Other JSON related videos:
• How to write expressio...
• JSON Array in Power Au...
Please buy me a coffee www.buymeacoffee.com/DamoBird365 ☕