filmov
tv
Files and Folders in Power Automate for Desktop (Full Tutorial)
Показать описание
This full tutorial shows how to work with files and folders in Microsoft Power Automate for Desktop. The step-by-step use case teaches you to move files between folders based on advanced conditions and create a log.
VIDEOS FOR YOU:
- Join my network with 2800+ RPA Developers, where we solve RPA problems, network, and help each other upgrade our careers. It's free!
FOLLOW ME:
MY MONITOR (Amazon affiliate):
0:00 Intro
Download the course files from the link above. The hands-on Power Automate Desktop use case is about sorting files into their respective folders given their type. But first, we must unzip files. Copy the path to the file and assign it to a variable.
2:00 Unzip
Use a Get files in folder, with a filter for zip extensions, action to get all the zip files into a list. We use comments to make our flow easy to understand in the future. Use a For each action to iterate the files (names). When you have unzipped the file(s) you can use a Delete file(s) to delete the zip file.
6:48 Sort files
The Get files in folder action get all the files in the target folder. Including subfolders, if you want. The file names are stored in a list, so we can work with them. Again we use a For each action to iterate through the files. We use an If action with a condition, where we look at the end of the file name, the file extension. The Move file(s) action moves the files based on the If condition.
14:08 Create a log
We store the sorted and moved files into lists. We use these in the log including a count of each file type. The Create new list action creates the list and an Add item to list action adds to the list. To have multiple lines in the log we use a Set variable and design the log here. We add Total files sorted, Total Notepad files sorted, Total Excel files sorted, Total Word files sorted and each file name sorted and moved. Use a Write text to file and use the variable just created to print out the log. To create unique log names we use the date and time as the file name, so each time the robot runs, there will be a new file name.
25:56 The Switch and case actions in Power Automate for Desktop
If we have many else's in our If action, it's great to use a Switch action. Then we'll use the Case action for each branch.
#office365 #powerautomate #rpa
VIDEOS FOR YOU:
- Join my network with 2800+ RPA Developers, where we solve RPA problems, network, and help each other upgrade our careers. It's free!
FOLLOW ME:
MY MONITOR (Amazon affiliate):
0:00 Intro
Download the course files from the link above. The hands-on Power Automate Desktop use case is about sorting files into their respective folders given their type. But first, we must unzip files. Copy the path to the file and assign it to a variable.
2:00 Unzip
Use a Get files in folder, with a filter for zip extensions, action to get all the zip files into a list. We use comments to make our flow easy to understand in the future. Use a For each action to iterate the files (names). When you have unzipped the file(s) you can use a Delete file(s) to delete the zip file.
6:48 Sort files
The Get files in folder action get all the files in the target folder. Including subfolders, if you want. The file names are stored in a list, so we can work with them. Again we use a For each action to iterate through the files. We use an If action with a condition, where we look at the end of the file name, the file extension. The Move file(s) action moves the files based on the If condition.
14:08 Create a log
We store the sorted and moved files into lists. We use these in the log including a count of each file type. The Create new list action creates the list and an Add item to list action adds to the list. To have multiple lines in the log we use a Set variable and design the log here. We add Total files sorted, Total Notepad files sorted, Total Excel files sorted, Total Word files sorted and each file name sorted and moved. Use a Write text to file and use the variable just created to print out the log. To create unique log names we use the date and time as the file name, so each time the robot runs, there will be a new file name.
25:56 The Switch and case actions in Power Automate for Desktop
If we have many else's in our If action, it's great to use a Switch action. Then we'll use the Case action for each branch.
#office365 #powerautomate #rpa
0:30:06
Files and Folders in Power Automate for Desktop (Full Tutorial)
0:21:13
Work with Files and Folders in Power Automate Desktop
0:13:47
Smart Folders: The macOS Power Feature You're Overlooking
0:04:14
Importing Folders with Power Query
0:09:48
Combine Files from SharePoint folder and sub folders ( Easily enter a File Path )
0:12:27
Easily Rename All Files In Folders (NOOB vs PRO) & rename files based on an Excel table with PAD
0:10:29
Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)
0:14:00
Get Data From SharePoint or OneDrive with Power Query - Demystified!
0:48:27
POWER BI tutorials || Demo - 4 || by Mr. Vamsi Krishna On 15-08-2024 @5PM IST
0:05:28
You are getting files from folders the WRONG way in Power BI!! Here is how to fix it- Part 1
0:03:44
Find Large Files in Sub Folders with Power BI
0:12:01
Power Query - Data from many folders with Single Query
0:05:31
Get the List of FOLDERS only in Power BI using Power Query
0:03:55
Share Files Folders Drives Between Computers Over A Network In Windows 11 - How To
0:07:26
Revolutionize Your File Management with Power Automate - Create Dynamic Folders in a Snap!
0:12:50
Efficiently extract Data Multiple Folders in Power BI
0:11:14
Hyperlink to Files and Folders in Excel | Create Links to all Files and Sub-folders in a Folder
0:13:04
The Power of Smart Folders To Organize Files in MacOS
0:06:32
Power Query 01: Combine multiple files from multiple folders
0:00:24
Export list of files, folders including subfolders to a txt file from command line
0:04:18
Get Filenames from Windows Folders with Power Query
0:08:44
The best way to connect to a SharePoint Folder to speed up your Excel and Power BI data refresh
0:08:49
Get Multiple Files Containing Multiple Sheets with Power Query
0:11:24
AUTOMATICALLY Save Email Attachments 📎 Using Power Automate (create different folders by topic)
Комментарии