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.

Challenge: Logging new file uploads in a workbook

Challenge: Logging new file uploads in a workbook - Microsoft Excel Tutorial

From the course: Excel: Automating Tasks with Power Automate

Start my 1-month free trial Buy for my team

Challenge: Logging new file uploads in a workbook

“

Now that you've learned how to use Power Automate with office scripts for tasks like updating a table of contents across multiple workbooks and managing emails, let's test your skills with a hands-on challenge. This time, you'll create a flow that automatically adds a row to an Excel table whenever a new workbook is added to a specific folder. To get started, open the exercise files for this challenge found in the 02-challenge folder. First, launch file-log.xlsx. This is a starter table that will let us log the file name, upload date, and file size right here. You'll also notice an empty folder called incoming files. Your goal is to upload files into this folder, and the Excel table will automatically update with the details of each new upload. Now here's the twist. We'll set it up so that only Excel workbooks with .xlsx extensions are added to this log. I won't reveal too much, but since we haven't used this trigger before, the one you're going to need is "when a file is created…

Contents