From the course: Learning Power Platform: Excel Integration

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Refining outputs with additional steps and Power Fx

Refining outputs with additional steps and Power Fx - Microsoft Excel Tutorial

From the course: Learning Power Platform: Excel Integration

Start my 1-month free trial Buy for my team

Refining outputs with additional steps and Power Fx

“

- [Instructor] In our previous video, we created a Power Automate flow that added key information to an Excel workbook table whenever someone mentioned us in Teams. However, we encountered a couple of issues with the results. The creation timestamp was difficult to read and not in a user-friendly format, and the body content retained all its HTML tags, making it nearly illegible in Excel. In this video, we'll address these problems by adding an extra flow step and using Power FX to clean things up. Let's head back to make.powerautomate.com, go to My flows, locate the flow we built, Track Teams Mentions in Excel, and click Edit. Now that we're back in the flow editor, we'll tweak a few parameters to improve how data moves from Teams into Excel. First, let's tackle stripping the HTML from the body content. We'll do this by adding an intermediate step to the workflow. Click the plus sign below the Teams trigger, search for HTML, and select the HTML to text action. As the name suggests…

Contents