Easily automate every-day processes with 'a robot for every person™' bundle!
This collection features out-of-the-box attended automations designed to benefit every employee at your organization.
Simply download automations, customize them according to your company needs, and share with employees via UiPath Assistant - instantly delivering business impact at scale.


A Robot for Every Person

すべての従業員が自動化を使用、作成、および恩恵を受けることができるようにすることで企業がRPAの可能性を最大化する、現代における職場向けのUiPathの戦略です。

Collection of customers' most popular pre-built automations, integrations, workflow templates, solutions and connectors for SAP platforms . Use them out of the box to accelerate implementation time of your SAP automations projects.

ユーザーに最も人気のあるSAPプラットフォームで使用可能な予め構築されたコレクションで、自動化ツール、統合、ワークフローテンプレート、ソリューション、コネクターが含まれます。取り出してすぐに使用することができ、SAPの自動化プロジェクトの実装時間を短縮できます。

Simplify process automation for industry leading enterprise software with Officially Supported API Integrations from UiPath.

UiPath Native Integrations

UiPathの公式サポートのAPI統合アクティビティによって、業界をリードするエンタープライズソフトウェアのプロセス自動化を容易に行うことができます。

Drag and drop AWS AI Services directly into your automations through pre-built integrations to solve additional business challenges.

Amazon Web Services

予め構成された統合サービスを通じてAWS AIサービスを直接ドラッグアンドドロップでご自身の自動化の仕組みに追加することにより、更なるビジネス上の課題を解決できます。

Whether it's about modifying text or graphics on slides or executing macros, let robots create presentations for you by using these 100+ activities.

PowerPoint

スライド上のテキストやグラフィックを変更する場合でも、マクロを実行する場合でも、準備された100以上のアクティビティを使用して、ロボットにプレゼンテーションを作成させることができます。

Easily configurable pack of 100+ activities to perform basic to advanced Excel automations such as cell/table/graph operations, extra-large files processing, PDF/DOC exports, and so on.

Excel

セル/テーブル/グラフ操作、大容量のファイル処理、PDF/DOCエクスポートなど、基本的な操作から高度な操作までExcel自動化に有効な100以上のアクティビティからなる容易に設定が可能なパックです。

Automation pack to carry on chats, fetch, understand and extract relevant info from documents and even perceive sentiment thus reducing operating costs and time to insights for healthcare providers.

Health

チャットで患者とやりとりをし、病状に関する情報の取得や理解をし、資料から関連する情報を抽出した上で判断のための分析結果を提供し、医療提供者の運用コストと診断するための時間を削減することができる自動化用パックです。

Comprehensive pack of 100+ activities and workflows to efficiently deploy & manage automation that leverage ServiceNow without the need for invasive implementation or costly custom integrations.

ServiceNow

既存のシステムの改修やコストのかかるカスタマイズをすることなく、ServiceNowを活用した自動化を効率的に展開および管理するための、100を超えるアクティビティとワークフローの包括的なパックを用意しました。

Comprehensive set of 500+ activities and workflows for end-to-end automation of Microsoft's Cloud, Server Virtualization, Security, Networking & Storage ecosystem & Microsoft AI services.

Microsoft

Microsoftのクラウド、サーバー仮想化、セキュリティ、ネットワーキングとストレージのエコシステム、およびMicrosoftAIサービスのエンドツーエンドの自動化を実現するための500以上のアクティビティとワークフローを網羅したセットです。

Configurable tools & Frameworks with established structure enabling developers to apply best practices in their projects building first time custom activities or enterprise-grade attended automation.

Development, Framework and Tools

確立された構造を備えた設定可能なツールとフレームワークにより、開発者は初めてカスタムアクティビティを構築する時であっても、エンタープライズのAttendedロボットによる自動化でも、プロジェクトにベストプラクティスを適用できます。

Explore our selection of certified content that offers a high variety of top quality listings ready to cover your automation needs.

Staff Picks

自動化のニーズに対応した、さまざまな高品質のリスティングを提供できる認定コンテンツのセレクションをご覧ください。

Comprehensive pack of 150+ activities to build fast &robust automation for Salesforce that is independent of UI and layout changes in the platform facilitating design time testing through 10+ wizards.

Salesforce

プラットフォームのUIやレイアウトの変更に依存せず、10以上のウィザードによって設計時のテストも容易にする、Salesforceの高速で堅牢な自動化を構築するための150以上のアクティビティパックを用意しました。

If you’ve always wanted a robot assistant, this is your chance to download build and customize one for you and learn the technology that is changing the nature of work.

RobotPack

もしロボットのアシスタントを常々ほしいと思っていたら、このビルドをダウンロードしてカスタマイズし、テクノロジーを学び仕事の質を変えるチャンスです。

Comprehensive pack of activities and workflows to automate filtering & processing of emails across individual and shared mailboxes. Manage tasks and Outlook Calendar events with easy configurations.

Outlook

個人のまたは共有されたOutlookメールボックスからEメールのフィルタリングや処理を自動化するための包括的なアクティビティとワークフローのパックです。 簡単な設定でタスクやOutlookカレンダーのイベントを管理します。

Easily configurable set of useful utilities to simplify frequent PDF automation needs such as merging, watermarking, exporting to DOC/ XLSX, processing semi-structured PDF invoices/receipts.

マージ、透かし、DOC/XLSXへのエクスポート、一部フォーマット化されたPDFの請求書/領収書の処理など、よくあるPDF自動化のニーズを簡素化するために便利なユーティリティであり容易に設定できるセットを用意しました。

This package has 5 activities for handling dates, they are:

Calculates age between two dates and return the result in years, months and days.

ContinueOnError - A Boolean value specifying if the automation      should continue even when the activity throws an error. The default value      is False. As a result, if the field is blank and an error is thrown, the      execution of the project stops. If the value is set to True, the execution      of the project continues regardless of any error.

FirstDate - The first date (or date of birth).

CalcDate - The date used to calculate age. The default      value is the current date.

Years - The number of completed years at the      calculated age.

Months - The number of completed months at the      calculated age.

Days - The number of completed Days at the      calculated age.

Converts the date component of a DateTime instance to a String without using code.

InputDate - The date to be converted to string.

ConversionMode - Indicates the conversion mode to be used, it can      be:

SpecifFormat - Used to indicate that the conversion will use       a user-specified format.

SpecificCulture - Used to indicate that the conversion will       take place according to the culture specified by the user.

DayFormat - Indicates the day format used to convert      the date when ConversionMode is SpecificFormat.

MonthFormat - Indicates the month format used to convert the      date when ConversionMode is SpecificFormat.

YearFormat - Indicates the year format used to convert      the date when ConversionMode is SpecificFormat.

DateFormat - Indicates the date format used to convert      the date when ConversionMode is SpecificFormat.

Separator - A string containing the separator to be used in      formatting the date in text when ConversionMode is SpecificFormat.

CultureName - Indicates the culture to be used when ConversionMode      is set to SpecificCulture.

DatePattern - The date patter used when the selected      conversion mode is 'Specific Culture', it can be:

Short - Converts the date to its equivalent short       date string representation.

Long - Converts the date to its equivalent long date       string representation.

Result - A string containing the converted date.

Converts a String containing a date representation to a DateTime instance.

ContinueOnError - A Boolean value specifying if the automation      should continue even when the activity throws an error. The default value      is False. As a result, if the field is blank and an error is thrown, the execution      of the project stops. If the value is set to True, the execution of the      project continues regardless of any error.

InputString - A string containing the text to be converted to      date.

YearFormat - Indicates the format of the year used to convert      the date when ConversionMode is SpecificFormat.

Separator - A string containing the separator to be used when      ConversionMode is SpecificFormat.

CultureName - Indicates the culture to be used when      ConversionMode is set to SpecificCulture.

Result - The converted date or null if there was      an error and ContinueOnError was set to true.

RpaBrasil.Date.Activities.GetBusinessDays

Returns an IEnumerable<DateTime> with the dates and the number of business days in a specified date range.

FinalDate - Calculation final date. It must be greater than      or equal to StartDate property.

Holidays - An IEnumerable<DateTime> with holiday dates.

SaturdayAsBusinessDay      - Considers Saturday as a business day.

SundayAsBusinessDay      - Considers Sunday as a business day.

BusinessDays - An IEnumerable of DateTime with business days.

NumberOfDays- An integer with the number of business days.

RpaBrasil.Date.Activities.GetRelativeBusinessDate

Returns the date of the next business day in relation to the start date and the specified number of business days.

NumberOfDays - An integer with the number of business days to      add. It must be greater than or equal to 0 (zero).

RelativeDate - The relative final date after added      NumberOfDays property value.

Some actions that we need to do with dates are often very complex to perform and often require complex code.
This package contains activities that facilitate manipulation of dates without the need for code.

Apache License Version 2.0, January 2004 http://www.apache.org/licenses/ TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION 1. Definitions. 'License' shall mean the terms and conditions for use, reproduction, and distribution as defined by Sections 1 through 9 of this document. 'Licensor' shall mean the copyright owner or entity authorized by the copyright owner that is granting the License. 'Legal Entity' shall mean the union of the acting entity and all other entities that control, are controlled by, or are under common control with that entity. For the purposes of this definition, 'control' means :info: the power, direct or indirect, to cause the direction or management of such entity, whether by contract or otherwise, or (ii) ownership of fifty percent (50%) or more of the outstanding shares, or (iii) beneficial ownership of such entity. 'You' (or 'Your') shall mean an individual or Legal Entity exercising permissions granted by this License. 'Source' form shall mean the preferred form for making modifications, including but not limited to software source code, documentation source, and configuration files. 'Object' form shall mean any form resulting from mechanical transformation or translation of a Source form, including but not limited to compiled object code, generated documentation, and conversions to other media types. 'Work' shall mean the work of authorship, whether in Source or Object form, made available under the License, as indicated by a copyright notice that is included in or attached to the work (an example is provided in the Appendix below). 'Derivative Works' shall mean any work, whether in Source or Object form, that is based on (or derived from) the Work and for which the editorial revisions, annotations, elaborations, or other modifications represent, as a whole, an original work of authorship. For the purposes of this License, Derivative Works shall not include works that remain separable from, or merely link (or bind by name) to the interfaces of, the Work and Derivative Works thereof. 'Contribution' shall mean any work of authorship, including the original version of the Work and any modifications or additions to that Work or Derivative Works thereof, that is intentionally submitted to Licensor for inclusion in the Work by the copyright owner or by an individual or Legal Entity authorized to submit on behalf of the copyright owner. For the purposes of this definition, 'submitted' means any form of electronic, verbal, or written communication sent to the Licensor or its representatives, including but not limited to communication on electronic mailing lists, source code control systems, and issue tracking systems that are managed by, or on behalf of, the Licensor for the purpose of discussing and improving the Work, but excluding communication that is conspicuously marked or otherwise designated in writing by the copyright owner as 'Not a Contribution.' 'Contributor' shall mean Licensor and any individual or Legal Entity on behalf of whom a Contribution has been received by Licensor and subsequently incorporated within the Work. 2. Grant of Copyright License. Subject to the terms and conditions of this License, each Contributor hereby grants to You a perpetual, worldwide, non-exclusive, no-charge, royalty-free, irrevocable copyright license to reproduce, prepare Derivative Works of, publicly display, publicly perform, sublicense, and distribute the Work and such Derivative Works in Source or Object form. 3. Grant of Patent License. Subject to the terms and conditions of this License, each Contributor hereby grants to You a perpetual, worldwide, non-exclusive, no-charge, royalty-free, irrevocable (except as stated in this section) patent license to make, have made, use, offer to sell, sell, import, and otherwise transfer the Work, where such license applies only to those patent claims licensable by such Contributor that are necessarily infringed by their Contribution(s) alone or by combination of their Contribution(s) with the Work to which such Contribution(s) was submitted. If You institute patent litigation against any entity (including a cross-claim or counterclaim in a lawsuit) alleging that the Work or a Contribution incorporated within the Work constitutes direct or contributory patent infringement, then any patent licenses granted to You under this License for that Work shall terminate as of the date such litigation is filed. 4. Redistribution. You may reproduce and distribute copies of the Work or Derivative Works thereof in any medium, with or without modifications, and in Source or Object form, provided that You meet the following conditions: You must give any other recipients of the Work or Derivative Works a copy of this License; and You must cause any modified files to carry prominent notices stating that You changed the files; and You must retain, in the Source form of any Derivative Works that You distribute, all copyright, patent, trademark, and attribution notices from the Source form of the Work, excluding those notices that do not pertain to any part of the Derivative Works; and If the Work includes a 'NOTICE' text file as part of its distribution, then any Derivative Works that You distribute must include a readable copy of the attribution notices contained within such NOTICE file, excluding those notices that do not pertain to any part of the Derivative Works, in at least one of the following places: within a NOTICE text file distributed as part of the Derivative Works; within the Source form or documentation, if provided along with the Derivative Works; or, within a display generated by the Derivative Works, if and wherever such third-party notices normally appear. The contents of the NOTICE file are for informational purposes only and do not modify the License. You may add Your own attribution notices within Derivative Works that You distribute, alongside or as an addendum to the NOTICE text from the Work, provided that such additional attribution notices cannot be construed as modifying the License. You may add Your own copyright statement to Your modifications and may provide additional or different license terms and conditions for use, reproduction, or distribution of Your modifications, or for any such Derivative Works as a whole, provided Your use, reproduction, and distribution of the Work otherwise complies with the conditions stated in this License. 5. Submission of Contributions. Unless You explicitly state otherwise, any Contribution intentionally submitted for inclusion in the Work by You to the Licensor shall be under the terms and conditions of this License, without any additional terms or conditions. Notwithstanding the above, nothing herein shall supersede or modify the terms of any separate license agreement you may have executed with Licensor regarding such Contributions. 6. Trademarks. This License does not grant permission to use the trade names, trademarks, service marks, or product names of the Licensor, except as required for reasonable and customary use in describing the origin of the Work and reproducing the content of the NOTICE file. 7. Disclaimer of Warranty. Unless required by applicable law or agreed to in writing, Licensor provides the Work (and each Contributor provides its Contributions) on an 'AS IS' BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied, including, without limitation, any warranties or conditions of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A PARTICULAR PURPOSE. You are solely responsible for determining the appropriateness of using or redistributing the Work and assume any risks associated with Your exercise of permissions under this License. 8. Limitation of Liability. In no event and under no legal theory, whether in tort (including negligence), contract, or otherwise, unless required by applicable law (such as deliberate and grossly negligent acts) or agreed to in writing, shall any Contributor be liable to You for damages, including any direct, indirect, special, incidental, or consequential damages of any character arising as a result of this License or out of the use or inability to use the Work (including but not limited to damages for loss of goodwill, work stoppage, computer failure or malfunction, or any and all other commercial damages or losses), even if such Contributor has been advised of the possibility of such damages. 9. Accepting Warranty or Additional Liability. While redistributing the Work or Derivative Works thereof, You may choose to offer, and charge a fee for, acceptance of support, warranty, indemnity, or other liability obligations and/or rights consistent with this License. However, in accepting such obligations, You may act only on Your own behalf and on Your sole responsibility, not on behalf of any other Contributor, and only if You agree to indemnify, defend, and hold each Contributor harmless for any liability incurred by, or claims asserted against, such Contributor by reason of your accepting any such warranty or additional liability. END OF TERMS AND CONDITIONS APPENDIX: HOW TO APPLY THE APACHE LICENSE TO YOUR WORK To apply the Apache License to your work, attach the following boilerplate notice, with the fields enclosed by brackets '[]' replaced with your own identifying information. (Don't include the brackets!) The text should be enclosed in the appropriate comment syntax for the file format. We also recommend that a file or class name and description of purpose be included on the same 'printed page' as the copyright notice for easier identification within third-party archives. Copyright [yyyy] [name of copyright owner] Licensed under the Apache License, Version 2.0 (the 'License'); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an 'AS IS' BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.



Visual Basic

This software project will connect the network drive using the Drive Name, network path, username and password to connect to a particular drive. If the drive is already connected it will disconnect it.

For disconnecting network drive it uses only drive name and no username and password are required.

The above piece of code will use PowerShell scripts to connect or disconnect the drive.

This project includes two xaml files & powershell scripts as mentioned below:

1) Map_Network_Drive: This xaml file is used to connect the network drive and it takes as input parameter username, password,network path and the name of the drive.

2) Disconnect_Network_Drive: This xaml is used to disconnect the network drive if it is already connected. If no network drive is connected it will display the details in log messages.

3) Map_Network_Drive: This text file contains the PowerShell commands required to connect the network drive. This PowerShell script is used by Map_Network_Drive.xaml to connect to the network drive. It requires username, password, network drive and drive name.

4) Disconnect_Network_Drive: This text file is used to disconnect the network drive if already connected. It will check the details on the basis of the input parameter supplied which is the name of the drive.

All of the above code is designed without hard coding and the code is dynamic, which requires only input parameters so that it can run without any issues.

The above design of xaml code was done to meet the requirements where different processes need to access different paths and files. So by connecting to different network paths, different processes have access to different folders and files. This will achieve the objective of meeting security approvals which may be required in different projects/clients.

This snippet will connect and disconnect network drive on the basis of the input supplied. It uses PowerShell scripts to achieve the purpose.

Project Manager

Sequence Name = ClickExecuteAndCheckResult

Standardized sequence that will click execute button in SAP and handle all scenarios:

2. Fail case (where it will send Business Exception） 

3. Timeout (where it will send System Exception) (Note that you need to provide the selectors to it to tell what is success and what is fail) 

1. Landing in success page (you can capture a selector in this page and pass it to the sequence) 

2. Status bar showing success message (you can capture the message and pass to the sequence) 

Fail case includes: (throws Business Exception) 

1. Landing in fail page (you can capture a selector in this page and pass to the sequence) 

2. Status bar showing message with type=Error (you don’t have to capture the message as any message with type=”Error” will be treated as Fail)

3. Status bar showing message with type NOT = Error but the message indicates an error. E.g.  message type = "Success" but message = "No Data" (in this case you need to pass this message to the sequence)

1. in_executeButtonSelector [String] (must have) - the selector of the execute button

1. in_statusBarSelector  [String] (must have) - the selector of the status bar

2. in_successSelectorArray [Array of String] - array of selectors that indicate the execution is successful (e.g. element(s) in the success page) . Optional if in_successStatusTextArray isn't empty

3. in_successStatusTextArray [Array of String] - array of status bar messages indicating execution success. Optional if in_successSelectorArray isn't empty

4. in_failSelectorArray [Array of String] - array of selectors that indicate the execution has failed (e.g. element(s) in the fail/no data page) . Optional

5. in_failStatusTextArray [Array of String] - array of status bar messages indicating execution fail. Optional (Note - you don't have to put Error messages from the status bar here as the Robot will automatically throw Business Exception if it detects error status, just put non-error status bar messages where you need to throw a business exception, for example No Data status etc...)

6. in_timeoutMaxSeconds - If the robot doesn't find a success / fail indicator within the # seconds specified here, it will throw a System Exception. Optional (Defaulted to 30 seconds if blank)

2. If Status bar Type = "E" (Error), throw business exception

3. For Each element in in_failStatusTextArray, check if status bar message contains the element, if it does throw business exception

4. For Each element in in_successStatusTextArray, check if status bar message contains the element, if it does exit loop

5. For Each element in in_successSelectorArray, check if one of them exists, if it does exit loop

6. For Each element in in_failSelectorArray, check if one of them exists, if it does throw business exception

7. If the robot doesn't find a success / fail indicator within  in_timeoutMaxSeconds, it will throw a System Exception  

Standardized sequence that will click execute button in SAP and handle all scenarios.




MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

The classical Levenshtein distance metric allows for the comparison between any two arbitrary strings. The "edit distance" measures how many additions, substitions, or deletions are needed to convert one string into another. While this is a powerful way to compare strings, it does have its limitations. 

The Damerau-Levenshtein distance is a little more robust, in that it includes transpositions/permutations as one way to manipulate a string. For example, "Hello" and "Helol" would have a D-L distance of 1, instead of 2, because it is possible to transpose the "o" and the "l". 

This library includes a lightweight D-L distance calculator, written in C#, which can take in two strings and output a distance between these two strings. 

Because many use-cases involve selecting an individual string from a collection of strings, this library also includes an activity which takes in a collection of strings and a chosen string, and it outputs the string from the original collection that matches most to the chosen string. 

This activity is meant to be used in workflows that include tokenization of texts, such that one token needs to be extracted from a larger body. 

Calculates the more robust Damerau-Levenshtein distance between two strings. Includes an activity for comparing a string against an array of strings to select the closest match. 

This package has three activities to help you manage file downloads:

A container activity that waits for a file to be downloaded and enables you to perform multiple actions with it. A local variable can be used by child activities to access the current downloaded file name.

FileNamePattern - The file name pattern to be downloaded.

Local variable (Only on designer panel) – The local variable that will store the name of the downloaded file and that can be used for child activities.

ContinueOnError - If set, continue executing the remaining activities even if the current activity has failed.

Timeout (milliseconds) - Specifies the amount of time (in milliseconds) to wait for the file to download before an error is thrown. The default value is 60000 milliseconds (1 minute).

DownloadFolder - The folder path where the file will be downloaded, if not specified, the Downloads folder of the current user will be used.

StartDateTime - The DateTime value at which the download started; if not specified, the current DateTime is used.

DelayBetweenSearches - Specifies the amount of time (in milliseconds) used between each check that the file has been downloaded. The default value is 1000 milliseconds (1 second).

FileName - The full downloaded file name.

Wait for a file to be downloaded by the browser.

Get the downloads folder path for the current user.

DownloadFolder - The download folder path for the current user.

This set of activities will help you monitor files download.

1. Use blobfuse to mount a Blob storage container on Linux

Blobfuse is an open source project developed to provide a virtual filesystem backed by the Azure Blob storage.

2. Use Filebeat to ship the logs from the mountpoint to Elasticsearch

   2.1 Configure Filebeat to connect to Elasticsearch

   2.2 Configure Elasticsearch to format the logs

The solution allows the user to ship the Automation Cloud logs saved in a Blob Storage to an on-prem instance of Elasticsearch by mounting the Blob Storage on a Linux VM and using Filebeat to ship them

One of the main functionalities that the latest update contains is the WebLogin Authentication Mode (found under the SharePoint Instance Type property) which can  potentially authenticate the robot even if the SharePoint instance is using 3rd party identity providers or if only multi factor authentication is possible. This happens by prompting the user to insert their credentials the first time the workflow is executed, afterwards which the robot stays authenticated. Given that this mode requires human input, it is recommended that this authentication mode is used only for attended automation

The activity should be used only in case you are signed in to a WebLogin SharePoint Instance!

Gets the current user in case you are signed into a WebLogin SharePoint Instance.

· Have access to an instance of SharePoint and an account with all the necessary permissions. You will not be able to use this package using your credentials to do any operations that you couldn't do on your SharePoint environment in the browser.

· This solution might not work if your SharePoint instance is using a 3rd party Identity Provider.

Please find more details on how to use each of the activities on the package in the attached documentation!

A custom activities package that allows the management of List Items, Library Files and Folders, Users, Groups and Permissions.New activities and a new authentication mode have been added in 1.5.2

RPA Developer

Hi Guys,I have a scenario of downloading a excel file from sharepoint. For instance, the site username is "aaa" and password is "123". I tried to pass username and password in Sharepoint application scope, but im getting (username argument is invalid error). How can i fix it??

Hi Radu, I'm unable to print list content in Writeline Activity . i'm using the expression 'item("Title").ToString' in the writeline, it is showing error as 'Option restrict On disallows late binding'. Could you please help me on this?

Not able to install the package -getting this error-Unable to resolve dependency 'Microsoft.SharePoint2016.CSOM (≥ 16.0.0).Please assist me on resolving this issue.

I noticed that I'm not able to give an entire path to be created on SharePoint using Create folder activity, for example "Path1/Path2/Path3", I need to create a loop and create one folder by time: "Path1", "Path1/Path2", "Path1/Path2/Path3". The documentation says that "It creates nested folders as well", but it throws an exception when one of the nested paths of the RelativeUrl does not exists.

When I try to upload a file with Upload file activity, the RelativeUrl parameter causes problems with some characters, for example a dot, it throws an exception with this message: "Upload file: The remote server returned an error: (500) Internal Server Error.". In this case I'm obligated to make the replacements, for example, "." for "%2E". I think the activity should handle it, shouldn't it?Suggestion: Upload file activity could return the URL of the uploaded file for SharePoint online.

Share point custom activity documentation is not available. Kindly provide manual guide for these activities in this package

Hi,I am trying to use this library and I am storing the username as string and passing it as a variable.It is throwing a error as invalid username and I am not able to figure out the issue. Kindly let me know if you think of anything.Thanks and Regards,Madhukar Chatra

Hi, I try to use Lists related activities, such as read list Items, update list items. But it all turns out below runtime execution error: (Cannot contact site at the specified URL https://xxxxxx.sharepoint.com/sites/xxxxx/Lists/List1/. There is no Web named "/sites/xxxxx/Lists/List1/_vti_bin/sites.asmx". Exception Type:Microsoft.Sharepoint.Client.ClientRequestException).Could you please kindly help on this? Thanks very much~

The link to the documentation pdf seems to have expired.

Can you please give example for create folder ?

Do this activity works with SSO on SharePoint? I have used this for one of the SP url which is SSO and it is giving me error for SP connection saying "Unauthorized User", though the creds are correct, would you please suggest some solution on this?

Where is the link to download this package? Please!

Question:Hi Radu, Thank you for quick response, I am using SSO for on premises apps like SharePoint, Outlook, etc. So the SSO should be standard one. could you suggest difference between standard and custom SSO. And also if this SSO does belong to standard category, do let me know about possible solution for failed authentication.

I'm using the Upload file activity and the File is getting uploaded to the sharepoint successfully. Even then UiPath is throwing error, 'File not found'. What could be the issue?Microsoft.Sharepoint.Client.ServerException: File Not FoundAlso, the sharepoint gets stuck after uploading 5 files. Is there any restriction on the number of files that can be uploaded?I din receive any responses on the UiForum for this<a href="https://forum.uipath.com/t/sharepoint-file-upload-error/136745" target="_blank">https://forum.uipath.com/t/sharepoint-file-upload-error/136745</a>

Getting error while trying to add this .nuget package to studio."Cannot be installed "

hi, i am trying to cap the amount of results how from my read list items, but even with &lt;RowLimit&gt;6&lt;/RowLimit&gt; and CAMLRowLimit: 6 doesnt seem to work. Do you know why?

hi, I get an error in the Create Folder activity.Message: List 'xxx' does not exist at site with URL 'https: // xxxxxx'.I think this is a problem with SharePoint permissions. Where should I check it?<ul><li>Upload File and Get File activities work normally, so URL and Library Name are correct.</li><li>I can create a folder manually in the browser.</li><li>I can create a folder with the Create Folder activity at another site in the same environment.</li></ul>

Hi, Is it possible to install this package offline?

While installing the package from studio am getting the error Cannot load assembly: C:\Users\djaykrishna\.nuget\packages\uipathteam.sharepoint.activities/1.3.0\lib/net461/UiPathTeam.SharePoint.Activities.dll : System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint.Client, Version=16.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.But the file is present in the specified location.

I'm a novice when it comes to writing in CAML. There are some pages in the UiPath Forms that I posted in at the link below, but a couple of simple examples would really help developers still learning. Could you put an example of what the CAML text would look like to update a SharePoint List Item?<a href="https://forum.uipath.com/t/update-sharepoint-list-item/11239/27" target="_blank">https://forum.uipath.com/t/update-sharepoint-list-item/11239/27</a>

One more question. Is there a way to handle a SecureString variable for the SharePoint Application Scope? Or, must you use a String variable to input your password?

Hi, I'm having problem with update list items activity. As the list column types are "User" and "Refer to", we can not update them. The error message is "Invalid data has been used to update the list item. The field you are trying to update may be read only". Could you please kindly advise how I can handle this problem, thanks in advance.

Can you provide an example on how you can read from a list from a site and then add this item to another list in another site? Thank you!

Does this tool work with on-premise 2010 sharepoint? Having error on Upload file activity as noted below.Source: Upload fileMessage: The object specified does not belong to a list.Exception Type: Microsoft.SharePoint.Client.ServerException An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:Microsoft.SharePoint.Client.ServerException: The object specified does not belong to a list.Cut some of the error due to length restrictions here.

HI Radu, Could you please let me know where this activity is hosted? If I use this custom activities where does my ID and password for Sharepoint go? Will my ID/Pwd will be available local to my UI path or will it pass through the API called by the activity wherever it is hosted? Will this activity work on latest UI path 2019 version?I wanted to be sure and safe that if I use my credentials for Sharepoint it will not go to any third party application and make it vulnerable.Thanks,Milind

Hello Radu,I'm having failure with the Sharepoint Scope activity connecting to Sharepoint Online. I'm receiving the following return error message on a Get File:Message: Cannot contact web site 'https://signetjewelers.sharepoint.com/' or the web site does not support SharePoint Online credentials. The response status code is 'Unauthorized'.My admin thinks this is related to Microsoft SharePoint online using Modern Authentication method which may be the issue.Please advise.Thank you.

HI Radu, Referring my questiond below and based on your answer do you know What is the library created by Microsoft, and where is it hosted ? is it on the machine where we execute ?&nbsp;Thanks,Milind Kumar

Hi, Thank you for providing the package which make automating in sharepoint easy. However, I encountered "Microsoft.Sharepoint.Client.ServerException" telling me that the group cannot be found. This group which is also a Active directory group is the group that I have been using to set permission for all my folders in the library but somehow the system not detecting. Please help. My system in onpremises and this I have selected in place of default online.

Hi, RaduReferring to my question below, I have posted the screen capture and error msg in the forum. The link to the post is<a href="https://forum.uipath.com/t/add-permissions-activity-does-not-work-help/149824" target="_blank"> here</a>. Please help as I need to be able to use it urgently. The version of Sharepoint I am using is 2013. Hopefully that is not the limitation. If it is, any way to overcome it.

Hello Radu, thank you for your package which is very useful for us.We are trying to upload quite a big file (800 MB) on a Sharepoint site, and we get this error :Upload file: The operation has timed outIs this a limitation of the activity ? Or of the Sharepoint site ? We saw there is a property "PropertiesToAdd", could we set another timeout with this ?Thanks !Nicolas

Hello Radu,I have downloaded the “SharePoint Custom Activities Package” from the “go.uipath.com” portal. I have added that to the UiPath studio. After that I tried to use the activity “Sharepoint application scope”, but it is asking for the UserName and Password as the mandatory field. What value should be enter in these two fields? Please confirm.NOTE - SharePoint which we are using is Single Sign On(SSO), we are not entering any UserName and Password while interacting with the SharePoint.

I am trying to update list items using UpdateListItem activity. List contains around 30K items. Activity is returning the error "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator."I know LVT is set to 5000. Please advice any alternative approach without changing LVT.

HI Radu, I am using O365 Cloud Sharepoint. I am using Sharepoint List Activities and using “Add List Item” activity to add the item in the list. I am getting the below Runtime Execution error.Source: Sharepoint application scope.Message: The remote server returned an error:(403) Forbidden.Exception Type: System.Net.WebException.I am using Sharepoint Instance type as “OnPremises”. Using "Online" is giving Bad sign in name and password error. What is the solution for this issue?

Hi Radu, On upload file activity I'm getting "Upload File The object specified does not belong to a list" .. but activity actually uploads the file and throws the error after Have you seen this issue before?

HI Radu, Related to your question below, this is general issue and not specific to Add list item. I am able to upload data manually through excel but not with this SharePoint activity. I guess our organization is using Azure Active Directory for authentication since we are using cloud based SharePoint online. EX"<a href="https://sp-cloud.kp.org/sites/AutomationCatalog" target="_blank">https://sp-cloud.abc.org/sites/D</a>ata". Does this activity will not work? Or do we have any other workaround? Exception on using Online Option:"Microsoft.SharePoint.Client.IdcrlException"

HI Radu, Yes I am using email id and password and manually its working but not via this activity even by providing the credentials as it is giving Bad ID/Password error. Could you please provide the dummy script in powershell and I can try it out. Please find the below link for UI Path forum where we can discuss. I already posted this but did not get any response.<a href="https://forum.uipath.com/t/uploading-excel-data-into-sharepointonline/156747" target="_blank">https://forum.uipath.com/t/uploading-excel-data-into-sharepointonline/156747</a>Could you please provide your response on the forum below?

Hi Radu, first thank you for this package is really helpful, but I guess I will have a little problem, I will start to work in a old Uipath version 2018.2.3 enterprise. And I will need this activities. Do you know if will be compatible to that version?

Hi Radu, I am facing an issue in getting, uploading and renaming the file on the SharePoint Online inside the scope,. The same functionalities carried on with SharePoint on-premises works fine. Can you please let me know what can be done to make it work? Error faced : "403- Forbidden error". Although I have access to SharePoint Online and on-premises to download, upload and renaming the files.Regards,Arabinda

Hi I'm getting the following Error when I try to use the update List Items activity on a Sharepoint Online document libraryUpdate list items: The requested operation is part of an experimental feature that is not supported in the current environment.Seems to be a catch all error. Any ideas was causing this ?

@RaduBucur I'm getting the following Error when I try to use the update List Items activity on a Sharepoint Online document libraryUpdate list items: The requested operation is part of an experimental feature that is not supported in the current environment.I have used the Upload File activity without issue. I created a CAML query to get my doc suing a unique field value in the list and I'm trying to update a Single line of text field for that document but its failing with the aboveLiam

hi ! Could you tell me if is it possible create an item with an attached file ? I tried create an item, then attach a file but I am getting an error.the item is created ok, attach a file seems not working.<a href="https://forum.uipath.com/t/add-an-new-item-in-a-sharepoint-list-with-attachments/163467" target="_blank">https://forum.uipath.com/t/add-an-new-item-in-a-sharepoint-list-with-attachments/163467</a> Could you help me please?

Hello @RaduBucur,This package is really useful for me. Thank you!I have one problem discovered lately while using this activity in Sharepoint Online. I often received "The remote server returned an error: (503) Server Unavailable.&nbsp;" and strange thing here is that sometimes activity works and sometimes not (40-60%). (tested on different SP sites) I wrote about this to Microsoft Support and they replied that this is because of throttling

UiPath Marketplace

Welcome to UiPath Marketplace

We make automation easy

Automation makes life easier. We make automation easy.

A Robot for Every Person…

SAP…

UiPath Native Integrations…

Amazon Web Services…

PowerPoint…

Excel…

Health…

ServiceNow…

Microsoft…

Development, Framework and Tools…

Staff Picks…

Salesforce…

RobotPack…

Outlook…

PDF…

SharePoint Custom Activities Package…

Find Recently Modified File in a Directory…

Two-Factor Authentication Activities…

Google GSuite…

RPA Brasil Date Activities…

BalaReva Excel Activities…

RPA Brasil Date Activities…

Sopra Steria - Connect Disconnect Network Drive…

SAP Click Execute And Check Result…

Damerau–Levenshtein Distance - String Similarity…

RPA Brasil File Download Activities…

UiPath Automation Cloud logs - on-prem Kibana…

Help

How To