- All of Microsoft
Power Automate Compose, Join, Select, Filter, Create tables, Parse JSON | Data Operations in flow
This Power Automate video is an introduction to Data Operations in flow. You'll learn about some common data operations in flow, such as Compose, Join, Select, Filter arrays, Create tables, and parse JSON. These actions are available to manipulate data when you create flows.
Flow Data Operations:
- Compose Action - Use the Data Operation - Compose action to save yourself from having to enter the same data multiple times as you're designing a cloud flow.
- Join - Use the Data Operation - Join action to delimit an array with the separator of your choice.
- Select - Use the Data Operation – Select action to transform the shape of objects in an array
- Filter Array - Use the Filter array - Data Operation action to reduce the number of objects in an array to a subset that matches the criteria you provide
- Create CSV table - Use the Create CSV table - Data Operation action to change a JSON array input into a comma-separated value (CSV) table
- Create HTML table - Use the Create HTML table - Data Operation action to change a JSON array input into an HTML table
- Parse JSON - by providing JSON content and schema
More about this topic
- Use data operations
In this article, you'll learn about some common data operations in Power Automate, such as compose, join, select, filter arrays, create tables, and parse JSON. These are available to manipulate data when you create flows.
https://docs.microsoft.com/en-us/power-automate/data-operations - Power Automate flow Expressions Tutorial
This video is a step-by-step tutorial on Microsoft Power Automate flow expressions.
https://www.youtube.com/watch?v=O97IdCbfMQI&t=0s
Table of Contents:
00:00 - Introduction to Power Automate Data Operations
00:41 - What are the actions in flow for data operations?
01:10 - Compose action in flow
03:38 - Join action in flow
04:35 - Select action in Power Automate
07:27 - Filter array action
08:31 - Create HTML table & Create CSV table actions
09:29 - Parse JSON action in flow
10:59 - Use data operation actions in flow
11:25 - Use Select & Join to create semicolon separated strings in flow
14:35 - Create formatted HTML table in flow using JSON Array data
19:33 - Send scheduled email with HTML data using flow create HTML table action
20:25 - Generate Dynamic HTML data, CSV & PDF files using Create HTML & CSV table actions in flow
22:18 - Send Grouped Data as HTML using Compose, Select & HTML flow actions
23:48 - Document Review workflow tracking using Select, Filter & other data operation actions in flow.
25:02 - Subscribe to Reza Dorrani channel