activities
latest
false
Productivity Activities
Last updated Oct 23, 2024

Microsoft 365 how-to guides

This page includes guides and resources that can help you learn how to create automations using the activities in this package.

Tutorials

Step-by-step guides on how to create automations from scratch.

TutorialDescriptionApplication
Merge Multiple Sheets into a New Summary Excel SheetConcatenate data from multiple sheets into one new Excel sheet. Excel
Automatically Accept Calendar Invites From Your ManagerAutomatically accept calendar invites received from your manager. Outlook Calendar
Move files to dedicated folders by typeMove new files in subfolders based on type (PNG, JPEG, XLSX, PPTX, PDF). OneDrive
Verify if new employment documents (I9 and ID) matchExtract I9 and ID documents arrived by email and verify if both documents have the same holder. Outlook Email, Document Understanding
Add new customers to a SharePoint ListAdd new customers to a SharePoint List and create Salesforce accounts using their data. SharePoint Lists, Excel, Salesforce
Delete SharePoint List items newer than yesterdayDelete SharePoint List items based on a date filter. SharePoint Lists
Notify me by email when a new file is createdWhen a file is added to a OneDrive folder, notify me by email and send me a link to the file. OneDrive, Outlook Mail
Notify me on Slack when an important Outlook Email is receivedWhen an important email is received in Outlook, notify me through a message in Slack. Outlook Mail, Slack
Include creation date in new OneDrive file namesWhen a file is created in OneDrive, rename it to include the creation date. OneDrive

Studio Web templates

Preconfigured projects that automate common scenarios. You can use a template as is or you can use it as a starting point for a new project to avoid starting from scratch. Templates are also a good way to learn how to automate.

Here are some templates with activities from this package available in Studio Web:

TemplateDescriptionActivities
Upload email attachments to OneDrive or SharePointUpload Outlook email attachments to OneDrive or SharePoint and move the email to a different folder.Email received, Download email attachments, Move email
Extract data from a new invoice file in OneDrive and store it in ExcelExtract data using Document Understanding when a new invoice is uploaded to OneDrive, then export it to an Excel workbook.File created, Create workbook, Write range, Add sheet
Table Data Extraction for Sales Opportunities to Excel WorkbookTake data from rpasamples.com/opportunities, write it to a new Microsoft Office 365 Excel workbook, and send the workbook to your Inbox via Outlook. Create workbook, Write range, Send email
Extract data from a new invoice file in OneDrive and store it in ExcelExtract data using Document Understanding when a new invoice is uploaded to OneDrive, then export it to an Excel workbook.File created, Create workbook, Write range
Extract the first 1000 emails from the current month in a new Excel reportExtract the latest 1000 Email from Outlook from the Current Month and creates an Excel Report, storing the sender, received date, subject, CC, body, and number of attachments. Create workbook, Write range, For each email
  • Tutorials
  • Studio Web templates

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.