Microsoft Flow

Microsoft Flow is adding some cool new flows for its users to be more productive. As you might already know that steps in a flow output a list of items, and the only way to handle such lists is with an Apply to each. But, starting today, you will be able to grab the items and put them in a single action, such as sending an email with the items, or saving them all to a file.

This is made possible with the new Create HTML Table, Create CSV Table and Join actions.

Create HTML Table

The action is particularly useful when you want to send emails that contain a full list of all of the items from a previous step. Take an example of Wunderlist tasks: they can have several Subtasks associated with them. With the new action, you can now get a table in your email with the list of all those subtasks. Check out the template here to try this yourself.

Create CSV Table

This action is most useful when you want to save the contents to a file. Since these actions interact with lists, it is possible to run flows on a schedule. For example, running a flow on weekly basis, and save all of the items in a SharePoint list to a CSV file for archiving. Try out this template to see this example of how it works.

Join action

Join works with any list of strings. For example, the Twitter action outputs a list of Media URLs. You can Join each of these URLs together with an HTML tag like <br> and then you get a simple list that looks like this:

<br>http://example.com/image1.jpg
<br>http://example.com/image2.jpg

It is also easier than ever to edit and enrich your existing flows with new Insert Steps Anywhere feature. A new “+” button is displayed where you can add an action, without drag and dropping the action from the bottom of a large workflow.
Insert Steps Anywhere feature

Sign up for Microsoft Flow