Power Automate Compose, Join, Select, Filter, Create tables, Parse JSON | Data Operations in flow
Aug 30, 2022 12:00 AM

Power Automate Compose, Join, Select, Filter, Create tables, Parse JSON | Data Operations in flow

External YouTube Channel

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

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