Скачать с ютуб Power Automate | Apply to Each | Why? | Arrays and Objects в хорошем качестве

Power Automate | Apply to Each | Why? | Arrays and Objects

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:    • Power Automate JSON Array Challenges ...      • JSON Array in Power Automate - Walkth...   Please buy me a coffee https://www.buymeacoffee.com/DamoBird365 ☕