From the course: Excel: Automating Tasks with Power Automate

Unlock this course with a free trial

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

Solution: Automated file upload tracking with Excel

Solution: Automated file upload tracking with Excel - Microsoft Excel Tutorial

From the course: Excel: Automating Tasks with Power Automate

Start my 1-month free trial Buy for my team

Solution: Automated file upload tracking with Excel

“

I hope you had fun building your very own conditional flow in Power Automate. Before we dive into the solution for this challenge, let's take a moment to discuss a related task that Power Query handles and how it differs from what we just did. Power Query lets you pull data from various sources, even generating a live list of files in a folder. Meanwhile, what we did with Power Automate was create a log of uploaded files, specifically workbooks. The key difference is that Power Automate is used for recording history and triggering actions based on real-time events, like new file uploads. Power Query, however, focuses on extracting and transforming data when refreshed, making it perfect for static reports and periodic analysis. With that difference out of the way, let's head over to make. powerautomate. com and create this flow. We'll build an automated cloud flow triggered by a specific event. In this case, the trigger will be "when a file is created properties only." Create and let's…

Contents