{"id":110815,"date":"2017-04-11T09:59:42","date_gmt":"2017-04-11T16:59:42","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/html-tables-csvs-computer-vision\/"},"modified":"2017-04-11T09:59:42","modified_gmt":"2017-04-11T16:59:42","slug":"html-tables-csvs-computer-vision","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/html-tables-csvs-computer-vision\/","title":{"rendered":"Build flows with HTML Tables, CSVs and other new features like OCR and image content detection"},"content":{"rendered":"

New actions to build tables and lists<\/h2>\n

Steps in a flow can output a list of items, and up until today, the only way that you could handle such lists was with an\u00a0Apply to each<\/strong>. For example, if you get a list of attachments for an Email, you can upload each <\/strong>of them to your OneDrive for Business (as shown in this template<\/a>). However, sometimes you want to get a list of items and include these items in a single action, such as sending an email with the items, or saving them all to a file. Today, this is possible with the new\u00a0Create HTML Table<\/strong>,\u00a0<\/strong>Create CSV Table<\/strong> and Join<\/strong>\u00a0actions.<\/p>\n

Create HTML Table<\/h3>\n

The first new action, <\/em>Create HTML Table<\/strong> is particularly useful when you want to send emails that contain a full list of all of the items from a previous step. One simple example is 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. Just add an action called\u00a0Get Subtasks<\/strong>, and then pass the contents of that step to the Create HTML Table<\/strong> action:<\/p>\n

\"\"<\/p>\n

There is advanced option to\u00a0Include headers<\/strong>\u00a0– this will tell you what each column is. Once the email is sent, it will look something like this:<\/p>\n

\"\"<\/p>\n

Check out the template here to try this yourself.<\/a><\/p>\n

Create CSV Table<\/h3>\n

The second new action is\u00a0Create CSV Table<\/strong>. This action is most useful when you want to save the contents to a file. These new actions that interact with lists now make it much easier to run flows on a schedule. For example, you can have a flow that will run once a week, and save all of the items in a SharePoint list to a CSV file for archiving.\u00a0<\/p>\n

\"\"<\/p>\n

This action works just like the HTML action, but instead outputs a CSV table, which you can then open in any spreadsheet program, such as Excel. Try out this template to see this example of how it works.<\/a><\/p>\n

Join action<\/h3>\n

The third new action, Join, is also very simple. It works with any list of strings. For example, the Twitter action outputs a list of Media URLs. You can\u00a0Join<\/strong>\u00a0each of these urls together with an HTML tag like <br><\/strong> and then you get a simple list that looks like this:<\/p>\n

\n<br>http:\/\/example.com\/image1.jpg\n<br>http:\/\/example.com\/image2.jpg\n<\/pre>\n
Insert steps anywhere in your workflow<\/h2>\n
Previously, you had to add every step to the bottom of the workflow and then drag-and-drop it to where you want. We have added new “+”<\/strong> buttons anywhere you can add an action, so now it’s easy to insert a step right in the middle of a large workflow.<\/p>\n
\"\"<\/p>\n
This will make it easier than ever to edit and enrich your existing flows.<\/p>\n
New services<\/h2>\n
This week there were three new services from our partners:<\/p>\n
    \n
  1. 10 to 8 Scheduling<\/a> – 10 to 8 Scheduling<\/strong> is a powerful appointment management, communications & online booking system.<\/li>\n
  2. Act!<\/a> –\u00a0Act!<\/strong> helps individuals, small businesses, and sales teams organize prospect and customer details in one place.<\/li>\n
  3. Inoreader<\/a>\u00a0–\u00a0Inoreader <\/strong>is a content reader built for power users. Use Inoreader to subscribe to feeds, read articles or catalogue them for viewing later.<\/li>\n<\/ol>\n
    \"\"<\/a><\/p>\n
    Computer Vision API<\/h3>\n
    Finally, we have also added support for the Computer Vision API<\/a>. The Computer Vision API lets you create flows that extract rich information from images to categorize and process visual data.<\/p>\n
    To get started, you will first have to get an API get from Cognitive Services. Click this link<\/a>, and be sure to select Computer Vision<\/strong>. You may need to verify your email. You can then copy the Key for this API to your clipboard (you can use Key 1 or Key 2):<\/p>\n
    \"\"<\/p>\n
    Next, create a flow and select one of the actions. When you do, you will be asked to name the connection and pasted in the Key you copied:<\/p>\n
    \"\"<\/p>\n
    This API has many useful functions including:<\/p>\n