Forum Engagement Daily Reports

[system]

Daily Forum Report | 21 March 2021

Top 3 Topics with Most Views

UiPath Certified Advanced RPA Developer (UiARD) made by @pragya_neekhra with 24 views.

Input duplicate data into row made by @Yudhisteer_Chintaram1 with 24 views.

Can I open excel file based on current Month information? made by @Dorothy_lee with 24 views.

Top 3 Topics with Most Replies

Can you please explain email regex in UiPath matches activity? made by @Surya_Narayana_Korivipadu with 12 replies.

Convert a string column to double made by @padmapadh1895 with 10 replies.

Input duplicate data into row made by @Yudhisteer_Chintaram1 with 10 replies.

Top 3 Users Who Posted The Most

@Cristian_Negulescu made 12 posts!

@Yameso made 11 posts!

@Pravin_Patil1 made 9 posts!

Top 3 Most Liked Posts

This post made by @Srini84 received 2 likes!

Filter option in excel

@ahamed_mansoor Welcome to forums Check below for your reference Hope this may help you Thanks

This post made by @Cristian_Negulescu received 1 likes!

PowerPointスライドにgraphを連続で貼付けたい その２

Hello Shinji, In this video, I have multiple use cases of UiPath working with POWERPOINT via VB.NET: [Multiple use-cases of PowerPoint Automation with UiPath] I have a lot of VB.NET Code that maybe you can reuse on your projects: startUiPathFromSalesforce/PowerPointCODE.txt at master · cristinegulescu/startUiPathFromSalesforce · GitHub Thanks, Cristian Negulescu

This post made by @Dorothy_lee received 1 likes!

[Date Inquiry] Can I set specific day of the week?

Thank you so much… !!! It’s working perfectly:)))) I’ll utilize for other function ! Happy Automation !!!

Top 3 Most Liked Solutions

This solution provided by @Yameso received 1 likes!

Convert a string column to double

It is not returning anythig because there is no data for today! I added those values to .xlsx: [image] And with the same workflow as you did i got: [image]

This solution provided by @Karuna received 1 likes!

Adding a robot to a machine

@Ignacio_Joaquin_Castro Yes, You need to connect your robot to orchestractor. The robot status is disconnected because your robot is not connected to orchestractor. Once its connected, The Status will be available. Screenshots are for your reference, How to connect your robot to orchestractor. Robot_Connection.zip (358.8 KB)

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 22 March 2021

Top 3 Topics with Most Views

Connected, Unlicensed same error made by @GovardhanReddy with 42 views.

Queues explanation made by @HomaDzz with 37 views.

DataTableから特定の列を抽出したい made by @nagumo with 34 views.

Top 3 Topics with Most Replies

How to use URLDownloadToFile in CodeActivity in UiPath made by @Vijay_Kumar_C with 16 replies.

Connected, Unlicensed same error made by @GovardhanReddy with 16 replies.

Sort dates output in IEnumerable<Match> made by @AhmedKutraphali with 12 replies.

Top 3 Users Who Posted The Most

@Yoichi made 21 posts!

@Pravin_Patil1 made 19 posts!

@Hiba_B made 18 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 3 likes!

Make your package compatible with Studio 21.4

@Sophia_Salo Hello Sophia, thanks for your hint about the internal changes. This is very important for Custom Activity developers. Here the status of my activities: SAP GUI Info updated to SAP GUI 7.70 and successfully tested with UiPath 21.2 ABAP Runner updated and successfully tested with UiPath 21.2 UnRAR updated and successfully tested with with UiPath 21.2 AutoIt successfully tested with UiPath 21.2 All activities are now prepared to use it in x86 and x64 environments, they are al…

This post made by @StefanSchnell received 3 likes!

An Approach how to Implement Unit Tests in UiPath

For some time now I have been working on the topic of how unit tests can be implemented in UiPath. Unit tests are very important elements in automation for me. In my case I want to realize manual executed black-box tests, to ensure that my automations deliver the expected result. I look at this from the perspective of an RPA developer who is in the development process. Here an example: I have a Main process which invokes an SAP BAPI call. Here I add an empty sequence. [image] In the next step…

This post made by @prasath17 received 3 likes!

Filling Up Blank Cloumn-DT

@shrayud - As an alternate if you have more rows and then you want to avoid “For each” - you can try like this…In the “Invoke Code” Activity… dt.AsEnumerable().ToList().ForEach(Sub(row) row(“Test”)= “New”) [image] My Output(I tried to write “New” in my Test Column… [image]

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 3 likes!

Filling Up Blank Cloumn-DT

@shrayud - As an alternate if you have more rows and then you want to avoid “For each” - you can try like this…In the “Invoke Code” Activity… dt.AsEnumerable().ToList().ForEach(Sub(row) row(“Test”)= “New”) [image] My Output(I tried to write “New” in my Test Column… [image]

This solution provided by @prasath17 received 2 likes!

How to sort date column

@Vinutha_L - Please try like this… (From r In DT Order By DateTime.ParseExact(r.Item(“YourColumnName”).ToString, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture) Descending Select r).CopyToDataTable

This solution provided by @Yameso received 2 likes!

Zip folder not visible while attaching it in web

Are you uploading files? Do you need to choose file in the window like this? [image] If thats yes then dont type into your Path_ varaible into: [image] Type it in: [image] after type into use sent hotkey with enter on the same selector.

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 23 March 2021

Top 3 Topics with Most Views

Split excel into Unique and Duplicate Rows made by @Yudhisteer_Chintaram1 with 35 views.

引数の使い方 made by @0st0eDSep9 with 31 views.

Log message return NULL exception with UiPath.MicrosoftTeams.Activities made by @q.gio with 29 views.

Top 3 Topics with Most Replies

引数の使い方 made by @0st0eDSep9 with 18 replies.

Retrieve all Rows of a particular column from Datatable and assign it to an DataRow[] made by @Jadeja_Chandravijaysinh with 15 replies.

Sum of column where row is of a certain type made by @atomic with 14 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 34 posts!

@Yoichi made 31 posts!

@Hiba_B made 27 posts!

Top 3 Most Liked Posts

This post made by @Pravin_Patil1 received 4 likes!

Pause Automation

Better idea to take an element exist or wait element to appear activity and increase timeout property to 30 min… Just for information, If you want to do it in attended mode as one time activity then In UiRobot section we have an option to pasue… Refer below… [image]

This post made by @seanrockvz13 received 3 likes!

Most Active Users - New community feature

Cool Feature Pablito!

This post made by @Vibhor.Shrivastava received 3 likes!

Techgig Code Gladiators 2021 virtual hackathon is live

Code Gladiators is the largest and annual coding battle in India and UiPath is an exclusive automation partner, 3rd year in a row for the 2021 Techgig Code Gladiators virtual hackathon. All RPA enthusiasts worldwide are invited to participate and showcase their skills. So, what are you waiting for? Create your team or participate individually by Registering HERE Think of your next big idea, we are looking forward to seeing ideas & solutions based on the following categories Category # 1 : Aut…

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 3 likes!

Sum of column where row is of a certain type

Hi @atomic to calculate the sum of RA use the below linq query dt1.AsEnumerable().Where(Function(row) row(“Type”).ToString.Equals(“RA”)).Sum(Function(row) Cint(row(“Amount”).ToString)) use the same way for other values too apart from RA Try this Regards, Nived N Happy Automation

This solution provided by @ppr received 2 likes!

Join data table activity - left Join not working as expected

we do see that 123 occurs twice. So the nature of join will create follwoing: take first 123 from dt1 join it with 123-pen from dt2 123-pen from dt2 take the second 123 from dt1 join it with 123-pen from dt2 123-pen from dt2 thats why th 4 rows are found. In such cases removing duplicates e.g in dt2 or custom join logic can help. here is just to rule when left 123 is picked up by which rule the both 123 rows from dt2 are to select for the pairing.

This solution provided by @Yoichi received 2 likes!

項目を選択←リストをデータテーブル型で取得

こんにちは 一度リボンメニューにあるスクリーンスクレイピングウイザードを試してもらえますでしょうか？ スクレイピングメソッドをフルテキスト、ネイティブそれぞれでどうなるか見てもらえると良いかもしれません。

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 24 March 2021

Top 3 Topics with Most Views

Robot.js로 로봇이 구동되지 않을 때 확인할 사항 made by @Minoh_Kang with 52 views.

Data scrapping / This control does not support data extraction made by @Soudios with 27 views.

Uipath StudioのOrchestratorへの接続設定 made by @Chiu_Haoyu with 27 views.

Top 3 Topics with Most Replies

Data scrapping / This control does not support data extraction made by @Soudios with 15 replies.

Issue with Use Application: Global Protect made by @Kinga_Formela with 14 replies.

Need Help on RegEx issue made by @Debartha_Mitra_DE with 13 replies.

Top 3 Users Who Posted The Most

@Lakshay_Verma made 30 posts!

@NIVED_NAMBIAR made 23 posts!

@Adrian_Star made 17 posts!

Top 3 Most Liked Posts

This post made by @AndersJensen received 2 likes!

BLOG: My name is Anders and I’m allergic to manual work

Hey Blog. I received one of the UiPath Most Valued Professional awards this year. Why did I get such a nice award when I’m an average technical RPA developer? I don’t exactly know the jury’s thoughts, but I’ll share how I see it in the next blog posts here. Long story short: There are other just as important aspects to being a UiPath MVP (and a good RPA developer). Hard skills + Soft skills + fast learner = A great RPA developer Stay tuned! Can you find me? [MVP4]

This post made by @ppr received 2 likes!

How to click the row which is highlited with green color?

@krishnareddy maybe it can be solved by dynamizing the selector:

This post made by @Pradeep_Shiv received 2 likes!

I need to extract the name from the email address using regex

Try this System.Text.RegularExpressions.Regex.Split(“Cheery123@gmail.com”,"\d{0,}@")

Top 3 Most Liked Solutions

This solution provided by @Pradeep_Shiv received 2 likes!

I need to extract the name from the email address using regex

Try this System.Text.RegularExpressions.Regex.Split(“Cheery123@gmail.com”,"\d{0,}@")

This solution provided by @Srini84 received 2 likes!

Finding Unique Values and Summing them from an Array Using LINQ

@ashwin.ashok Check as below [image] Use ArrayVariable.Distinct().ToArray.Sum(Function (r) Double.Parse(r.ToString)) Mark as solution if this help you Thanks

This solution provided by @prasath17 received 2 likes!

DT is blank

hi @shrayud …Dttable.clone method does not copy all the records to other datatable. it’s just copies the schema to the new dt. See the below screenshot, I have cloned dtIn to dtcorrected and printed the dtcorrected which just shows the column names… [image] So, if you want to a backup use datatable.copy method…see below… [image] Here is the reference:

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 25 March 2021

Top 3 Topics with Most Views

Structure of Loops made by @Yudhisteer_Chintaram1 with 38 views.

How to check if item exist in array? made by @AhmedKutraphali with 29 views.

There are no Available licence comunity version made by @davron20 with 28 views.

Top 3 Topics with Most Replies

Structure of Loops made by @Yudhisteer_Chintaram1 with 24 replies.

Convert cell or range value from text to number [Excel][Vb] made by @AS07 with 22 replies.

フォルダ内のテキストファイルの起動について made by @kawagolf with 19 replies.

Top 3 Users Who Posted The Most

@Pravin_Patil1 made 34 posts!

@prasath17 made 33 posts!

@NIVED_NAMBIAR made 26 posts!

Top 3 Most Liked Posts

This post made by @GBK received 3 likes!

How to give default value for regex iendurable<Match>

@copy_writes - you can try to assign a variable in if activity based on match response like below matched_string = Regex.Match(regex); if(matched_string == null) { matched_string = "default"; }

This post made by @prasath17 received 3 likes!

Get text after string and ignore any spaces

@JeffNZ1 - You can try this Regex pattern… Assumption: After the Last Name there will be usermenu always.. [image] StrFNLN= Regex.Match(“JS Jeff ShumUserMenu”,"(?<=\s*)\w+\s*?\w+(?=UserMenu)").value Import : System.text.regularexpressions (if Regex.Match did not recognize) [image]

This post made by @Berke received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, My name is Berke, I am 17 years old and studying in the informatics department. I’m trying to learn more about Rpa and improve myself as much as possible on these issues.

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 2 likes!

Structure of Loops

Hi @Yudhisteer_Chintaram1 Have a look at that workflow Main.xaml (14.0 KB) You can look at the workflow comments which i had put to get the logic how we can execute the workflow I am preffering a while loop here to do the process @copy_writes please have a look on that too Regards, Nived N Happy Automation

This solution provided by @Cristian_Negulescu received 2 likes!

Unable to update description in jira , but able to update summery

Please Check the movie on minute 1:52 to see how I define variables you need to write new JObject() . I also have a movie dedicated how to create JSON with details: [UiPath Tutorial for JSON Parsing and Creation (UseCase)]

This solution provided by @ppr received 2 likes!

Excel rows, create list only from integer numbers of rows

@Danny_Gi we do feel that a list with 1,2,3 will not help your case Also a list with all number will not add a value. Looking on this from another viewpoint we do see the chance to form groups based on main and sub items. for this we can use a group by approach: and if we do the grouping by logic like bring e.g. 1 and 1.1,1.2 … etc together we can segment the data for a further processing. Here following statement will help for defining the group key: [grafik] Let us know if you want to…

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 26 March 2021

Top 3 Topics with Most Views

How to read email and save in data table? made by @praveen_sonkusare with 31 views.

How to skip the first row of a foreach loop in C#? made by @lmoham with 31 views.

Limitations of uipath tool made by @srividhya.r with 29 views.

Top 3 Topics with Most Replies

Send path from UIPath to macro made by @fairymemay with 15 replies.

フィルタのように、特定のものだけのDTを作りたい made by @miwa_yamamoto with 12 replies.

How to skip the first row of a foreach loop in C#? made by @lmoham with 10 replies.

Top 3 Users Who Posted The Most

@Kah_Liang made 19 posts!

@Srini84 made 19 posts!

@prasath17 made 18 posts!

Top 3 Most Liked Posts

This post made by @Chio_f received 3 likes!

UiPath Marketplace ガイド の日本語翻訳が完了しました！

こんにちは。Marketplaceからお知らせです。 UiPath Marketplaceガイドについて、この度日本語の翻訳が完了し、新しく生まれ変わりました。 https://docs.uipath.com/marketplace/lang-ja ようやく日本語版としてご案内できることを嬉しく思います。 皆様のMarketplace利用に役立てていただくことができれば何よりです。 新しいコンテンツも随時、英語から日本語へ変更されていく予定ですので、どうぞ日本語版もご参考ください！

This post made by @ppr received 3 likes!

Need suggestion on filename's regex

As an alternate also with case ignore flag, but control on space and underscore: [grafik]

This post made by @Yoshi_Akiyama received 2 likes!

Kill processes from server ONLY for current user

Hi, We added an option in kill process activity to kill process per user, and per session(useful for PiP, since user is same from parent session). This is from 21.4 System Activity pack. 21.4-beta is already available in the official feed.

Top 3 Most Liked Solutions

This solution provided by @vignesh.ks received 1 likes!

Possible to count the number of '+' appearing in an excel column?

Hi @lmoham Please use the below method. System.Text.RegularExpressions.Regex.Matches(yourVariable,"[+]").count Feel free to reach us at any time if you have doubts. Thanks. Happy Automation

This solution provided by @prasath17 received 1 likes!

How to Append file excel

@fairymemay - Fixed now…Your workflow is perfect other than you had duplicated ‘dt’ variable. Run this below file “As is” you will see the output.xlsx gets created in the project folder… Append Files_Noona.zip (58.0 KB)

This solution provided by @Kah_Liang received 1 likes!

フィルタのように、特定のものだけのDTを作りたい

Hi @miwa_yamamoto Yes you definitely can. Just start from creating a variable, let’s say “Month” dt = dt.AsEnumerable.Where(Function(r) r(“Month”).ToString = Month).CopyToDataTable You can try to call the variable by pressing ctrl+space at r(“Month”).ToString = HERE Also, for you information there are many different ways to filter datatable you can learn them here and use different one for different scenario. Regards, Kah Liang

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 27 March 2021

Top 3 Topics with Most Views

Starts a process only when a new data is added to database made by @Alamyr_Junior with 25 views.

Hello How to replace text in text file made by @copy_writes with 22 views.

Regex pattern to extract date format ddMMMyyyy made by @MasterOfLogic with 20 views.

Top 3 Topics with Most Replies

Excel 2 different sheet in same excel made by @vishal22landge with 11 replies.

Data scrapping multiple pages made by @xyzxyz_123 with 8 replies.

Starts a process only when a new data is added to database made by @Alamyr_Junior with 7 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 7 posts!

@copy_writes made 6 posts!

@prasath17 made 6 posts!

Top 3 Most Liked Posts

This post made by @Minoh_Kang received 1 likes!

IIS에서 Let's Encrypt 인증서를 발급받는 방법

Azure에 있는 윈도우즈 VM에서 사용할 인증서를 Let’s Encrypt에서 무료로 발급받는 방법을 공유합니다. 해당 머신의 웹서버는 IIS인 경우입니다. Let’s Encrypt 인증서 발급을 도와주는 RCL Client for Let’s Encrypt 서비스를 사용합니다. Let’s Encrypt 인증서는 무료이지만, 이 서비스는 free trial이 만료되면 유료로 전환되는 점에 주의하시기 바랍니다. Azure에서 이 서비스를 찾아 가입하고 계정을 활성화하면 아래와 같이 Let’s Encrypt 인증서 발급을 시작할 수 있습니다. [image] 용도에 맞는 적합한 옵션을 선택하여 "Select"를 클릭하면 아래와 같이 필요한 정보를 입력하게 됩니다. Azure VM에 부여한 도메인명(FQDN)이 myweb.koreacentral.cloudapp.azure.com이라면 아래와 같이 입력해야 합니다. Let’s Encrypt가 인증서를 발급하기 전에 해당 도메인의 소유자…

This post made by @Alamyr_Junior received 1 likes!

Starts a process only when a new data is added to database

Hi, I have a process that I need to run just when new data is added to a database, is there a way to link that database to orchestrator and make it starts only with new data? Regards, Alamyr

This post made by @NIVED_NAMBIAR received 1 likes!

Starts a process only when a new data is added to database

Hi @Alamyr_Junior Try webhooks for it to trigger a Uipath process when a new entry is added to database

Top 3 Most Liked Solutions

This solution provided by @Sahil_Garg1 received 1 likes!

Hello How to replace text in text file

Hey, You can user String.Format method. For example: SampleString = Hi {0} , Welcome to {1}. In Bot: String.Format(SampleString,“Copy_Writes”,“UiPath”) Output : Hi Copy_Writes, Welcome to UiPath. Give index value in your text whereever you wants specific word, and extract word from excel it will replace it in the string. Let me know in case of any concern. Regards, Sahil

This solution provided by @Rachita_Chauhan received 1 likes!

Communication between UiPath Studio and the Taxonomy Manager ended unexpectedly

I saw many posts on this but no solution. I found the Package that is responsible for this error. Its this package: [image] it fixed the issue.

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 28 March 2021

Top 3 Topics with Most Views

https://forum.uipath.com/t/301684 made by @Sujata_Bagul with 23 views.

How to wait for image to finish loading on screen before continuing with other activities made by @testcapypara with 20 views.

Extract Data from multiple excel files with multiple sheets into one master sheet made by @noor.akroush with 18 views.

Top 3 Topics with Most Replies

Need help in setting variable in selector made by @Ashwin_Swain with 6 replies.

Extract Data from multiple excel files with multiple sheets into one master sheet made by @noor.akroush with 4 replies.

Time Trigger via Orchestractor API made by @Karuna with 4 replies.

Top 3 Users Who Posted The Most

@Ronak.Khamar made 5 posts!

@AndresTarazona made 3 posts!

@mks made 3 posts!

Top 3 Most Liked Posts

This post made by @Ronak.Khamar received 1 likes!

Announcing the 2021 UiPath MVPs!

Congratulations to all the MVPs

This post made by @StefanSchnell received 1 likes!

Tip: How to use Notepad++ with CS-Script PlugIn to Develop and Debug VB.NET Invoke Code Sequences

A longer time ago I presented the possibility how to use Notepad++ with CS-Script Plugin to Develop C# Invoke Code Sequences. The CS-Script Plugin supports C# directly, without any additional libraries. But the CS-Script Plugin supports also alternative compilers, like VBdotNET. Thus exactly the same approach is also suitable for the pre-development of VBdotNET sequences, which can then be transferred to the Invoke Code Activity on the same way. Here the steps how to setup the environment: D…

This post made by @AndresTarazona received 1 likes!

Orchestrator 라이센스 수강중입니다!

Hi @Bobae_Lee Probably the program was installed only on your user, please check this path C:\Users%username%\AppData\Local\UiPath Bests, Andres

Top 3 Most Liked Solutions

This solution provided by @AndresTarazona received 1 likes!

Orchestrator 라이센스 수강중입니다!

Hi @Bobae_Lee Probably the program was installed only on your user, please check this path C:\Users%username%\AppData\Local\UiPath Bests, Andres

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 29 March 2021

Top 3 Topics with Most Views

DTを複数条件で列の数字の合計を取得したい made by @miwa_yamamoto with 36 views.

How can I get next item after break from ForEachRow made by @ripper_Gao with 32 views.

Mail folder Filter made by @mtalha.shafiq with 27 views.

Top 3 Topics with Most Replies

I am retrieve the latest file from a directory however it retrieves the one prior to it made by @manjesh_kumar with 11 replies.

DTを複数条件で列の数字の合計を取得したい made by @miwa_yamamoto with 9 replies.

How to filer the mail address in get mail made by @copy_writes with 9 replies.

Top 3 Users Who Posted The Most

@Pravin_Patil1 made 14 posts!

@NIVED_NAMBIAR made 13 posts!

@prasath17 made 13 posts!

Top 3 Most Liked Posts

This post made by @Anna_Hotsa received 7 likes!

Task Capture 2021.4 Preview Release

Task Capture 2021.4 Preview Release Hello, everyone! We are happy to announce the preview release of the Task Capture 2021.4 version! We’ve prepared a lot of updates in order to improve your experience with the app, resolve the key pain points and provide the new capabilities that help you document your processes faster and easier! Please check out the key changes below and feel free to share the feedback What’s new? Interactive sign …

This post made by @Adit2917 received 2 likes!

How to pass a Python DataFrame to UiPath?

I was also having issues with this earlier, but found out this solution somewhere on stack overflow which worked for me. You can convert the python dataframe to datatable format using the following three steps. Python Script: Return python data frame as JSON string i.e. return df.to_json(orient='records') Get Python Object: Save the JSON string in a variable of type string Deserialize JSON: Choose ‘System.Data.DataTable’ as TypeArgument and store the result in a variable of type dataTa…

This post made by @ppr received 2 likes!

Add New Row with code only!

@MARIODC YourDataTableVar.NewRow will return an empty datarow within the column structure of the datatable. Maybe you are looking for this

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 1 likes!

Studio Regular Expression Help

@bertc - Here are the Regex Patterns: [image] Email address Tariff change - Not sure where is text in your email??? Tariff name Contract account

This solution provided by @Yoichi received 1 likes!

Find UiPath Studio Stable v2019.10.6

Hi, We can get it at ResourceCenter in UiPath Automation Cloud. Can you try to click the link at right-bottom in portal of Automation cloud? [img20210329-2] [img20210329-1] Regards,

This solution provided by @prasath17 received 1 likes!

Regex and String have no match

@bertc - If this connects with your previous post…please adjust the pattern as shown below… [image] or If you are using the \s? in the brackets…then please use… YourRegexvar(0).value.tostring.trim → this will remove the leading and trailing spaces…

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 30 March 2021

Top 3 Topics with Most Views

Document Understanding 2021.4 - or Why We've Been so Quiet made by @Ioana_Gligan with 204 views.

データテーブルの項目キー毎の件数を取得したい made by @miwa_yamamoto with 65 views.

Pick Data From PDF made by @supu123 with 65 views.

Top 3 Topics with Most Replies

Pick Data From PDF made by @supu123 with 22 replies.

View Code of Custom Activities eg invoices receipt etc made by @nashrahkhan with 13 replies.

Edit Rectangle made by @Snowman with 9 replies.

Top 3 Users Who Posted The Most

@prasath17 made 24 posts!

@NIVED_NAMBIAR made 19 posts!

@ptrobot made 13 posts!

Top 3 Most Liked Posts

This post made by @Ioana_Gligan received 12 likes!

Document Understanding 2021.4 - or Why We've Been so Quiet

Dear Community, Here we are, another few months have passed… and we haven’t written you any news in such a long time… But I believe you’ll excuse us for not making small talk (, , ), while waiting to be able to make some pretty big announcements (, , )! (however nice small talk may be ) So hoping this letter finds you well, let’s pick up from where we left off in February, when we announced some really nice little features: …

This post made by @muneeb received 2 likes!

Announcing the 2021 UiPath MVPs!

Congratulations to all MVPs

This post made by @jvanmarion received 2 likes!

Task Capture 2021.4 Preview Release

Hi Anna, the link in your post to the “Documentation portal - v2021.4” results in a 404. From the docs in UiPath Task Capture this version does not exists.

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Out of sudden, Send hotkey activity is disappeared

@bluesnam - Please check this post… You are on the modern design, you can choose classic as shown in the post which will solve your problem. I personally like, Keyboard shortcuts activity in the Modern Design…where you can record the keystrokes …

This solution provided by @HomaDzz received 1 likes!

External ip without domain at hosts

Wasn’t fixed. Created with a domain name instead of it.

This solution provided by @ptrobot received 1 likes!

How can i create a folder and create a new one into it plz?

Have you tested the Create Folder activity? [image]

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 31 March 2021

Top 3 Topics with Most Views

Excelの表へ罫線・フォント・色の設定をしたい made by @miwa_yamamoto with 32 views.

Make a string Generic made by @awaisji2001 with 31 views.

Could not find a part of the path 'C:\Users....etc while trying to open studio made by @Archana_N_L with 31 views.

Top 3 Topics with Most Replies

Make a string Generic made by @awaisji2001 with 21 replies.

Orchestrator problems. Studio and Robot no available licenses made by @hubert.ropa with 13 replies.

Adding folder path hyperlink in email body of send Outlook Email Activity made by @skg_161125 with 13 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 39 posts!

@prasath17 made 22 posts!

@Pravin_Patil1 made 22 posts!

Top 3 Most Liked Posts

This post made by @Anna_Hotsa received 3 likes!

Task Capture 2021.4 Preview Release

Please check the URL now, the documentation for 2021.4 version should be available and marked as beta

This post made by @sbotan received 3 likes!

Activation Instructions OnPremise Computer Vision

Hi @Frei_Janick , At the moment Linux on premise server doesn’t require a license.

This post made by @jvanmarion received 2 likes!

Task Capture 2021.4 Preview Release

Hi Anna, Nice. It is working now indeed!

Top 3 Most Liked Solutions

This solution provided by @postwick received 1 likes!

Custom Activity: Object reference not set to an instance of an object

I figured it out. Known issue with Studio v2019.10.3 and specifically the Select Item activity. Replacing Select Item with Select Multiple Items fixed the issue, and apparently upgrading to at least 2019.10.4 would also solve the issue.

This solution provided by @Yoichi received 1 likes!

How to extract paragraph in regex

Hi, I wrote 2 sample xaml files as the following. (Main.xaml and Sequence.xaml) Sample20210331-3.zip (4.2 KB) Hope them helps you. Regards,

This solution provided by @Yoichi received 1 likes!

Excelの表へ罫線・フォント・色の設定をしたい

こんにちは [img20210331-4] エクセルアプリケーションスコープに 出力ｰワークブックというプロパティがあるので、そこに出力用の変数をセットするということです。 Ctrl+Kを使うと適切な型の変数を生成してくれるので、こちらを使うと良いと思います。

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 01 April 2021

Top 3 Topics with Most Views

Free UiPath Certified Advanced RPA Developer exam voucher made by @Karan_Gupta1 with 35 views.

印刷タイトル列が設定できない made by @miwa_yamamoto with 32 views.

Assist of Extract pdf data made by @Sneha1 with 29 views.

Top 3 Topics with Most Replies

Regex for string format match made by @RaduNRV with 16 replies.

I am not getting the default folder for the new user made by @copy_writes with 12 replies.

Computer vision activities suddenly started reporting error made by @Naveed_Hakim1 with 12 replies.

Top 3 Users Who Posted The Most

@Pravin_Patil1 made 35 posts!

@Hiba_B made 26 posts!

@AndyMenon made 18 posts!

Top 3 Most Liked Posts

This post made by @6bb4b246e29849ebb4f41548c received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

I have 3 bots running and a 4th in the works developed by NeoStella. I need to learn the basics of UIpath coding for those bots to help me maintain them. hopefully the 4 week RPA learning program will get me started on that path.

This post made by @tiago.fernandes received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, I’m Tiago and I work as an IT System Analist in an area that sometimes connects with RPA processes. I joined the UIPath Academy to better understand what RPA is really about and what it can do.

This post made by @wayne.short received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

I have been scripting for 25 years, and doing crude automation with AutoIT when needed. Finally time to step it up to an enterprise grade RPA tool. So psyched! Mostly I’m looking to extract data from various consoles (since we can’t get to the raw data) and write it to CSVs on a share for automatic import in our reporting tool.

Top 3 Most Liked Solutions

This solution provided by @Pravin_Patil1 received 2 likes!

Unable to create new project Studio

Can you try to create the project in the C Drive… It looks like you don’t have full control of the directory…

This solution provided by @Rajesh.Attada01 received 2 likes!

Image in Email Body - Using Send Email Activity

@NIVED_NAMBIAR and @Pravin_Patil1 Thanks both of you for assisting me. Got the solution. Read image into Byte byteArray=System.IO.File.ReadAllBytes(“Image.jpg”) Convert Byte Array to base64 String base64String=Convert.ToBase64String(byteArray) Place the base64String inside the HTML img tag “<img src=”“data:image/jpg;base64, base64String”“alt=”“Red Dot”“>” Happy Face → you will see the image in the email body as output.

This solution provided by @balupad14 received 1 likes!

How sort column by custom?

Hi @Gopi_Arumugam , Please take a look this video. Thank you Balamurugan.S

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 02 April 2021

Top 3 Topics with Most Views

"Navigate Browser" not working made by @Khrystyna_Sarakhman with 34 views.

How to Remove the space in between the lines made by @anbarasu.k with 30 views.

特定の文字列を含むファイルを削除したい made by @nagumo with 25 views.

Top 3 Topics with Most Replies

"Navigate Browser" not working made by @Khrystyna_Sarakhman with 10 replies.

How to Remove the space in between the lines made by @anbarasu.k with 7 replies.

How to pick specific row value in next iteration made by @rsr.chandu with 5 replies.

Top 3 Users Who Posted The Most

@Yoichi made 10 posts!

@sangL made 10 posts!

@Hiba_B made 9 posts!

Top 3 Most Liked Posts

This post made by @chris.hill2000 received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, My name is Chris. Im currently in Canberra. I have about 20 years IT experience and 5 of those in Automation and Monitoring using different products. I am now associated with designing and developing IT solutions fit for Automation - for Accounting and Tax firms/businesses. I am new the the UiPath products but really enjoy its capabilities for this field (Accounting/ Bookkeeping/Tax). Im looking forward to leaning as much as I can! Happy Automating

This post made by @nagumo received 2 likes!

特定の文字列を含むファイルを削除したい

途中のパスに”確認”が含まれておりました・・ 気付かなかったです。。 無事に解決出来ました！ ありがとうございました！

This post made by @JiYeon received 2 likes!

Citrix VDI환경에서의 Unattended Robot 원격실행 팁

안녕하세요. Citrix VDI에서 Unattended Robot 원격실행에 대한 경험을 공유합니다. 윈도우에는 Console 세션과 RDP 세션이 있습니다. [ Console 세션 ] 아래와 같이 설정한 경우 Robot과 사람이 함께 화면을 볼 수 있습니다. Robot 실행 중에 Console을 열어도 Robot을 끊지 않고 작업이 수행되는 것을 볼 수 있습니다. [image] Login to Console이 disable 인 경우(기본 설정) Robot이 실행 중일 때 사람이 원격 화면을 열면 Robot 이 끊깁니다. 일반적으로 Desktop has been disconnected 에러가 발생합니다. [ RDP 세션 ] Unattended Robot을 연결한 경우 기본 설정은 아래와 같이 되어 있습니다. 아래를 변경하지 않고도 일반적으로 Robot은 원격 실행이 잘됩니다. 다만, 사람과 Robot이 함께 화면을 봐야 한다면 위의 설명된 설정(Login t…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

特定の文字列を含むファイルを削除したい

こんにちは 上記ですべてのファイルが消えてしまうということは、途中のパス名に「確認」という文字が 含まれているからではないでしょうか？ もしそうであれば条件分岐の条件欄は System.IO.Path.GetFileNameWithoutExtension(item.ToString).Contains("確認") とすると、ファイル名の部分のみを評価してくれます。

This solution provided by @anokhiraaz received 1 likes!

Duplicate Values Count increment - HELP

Hi,Anjali You can also use this Approach.This is suitable if there is large amount of data. By using Generic.dictionary key,value pair You can solve this. Try this…Hope this will work for you. Mark this as Solution , if it works. Main.xaml (15.3 KB) output:- [image]

This solution provided by @prasath17 received 1 likes!

How to create Multiple folders with last moth dates

@balaji.S - Please try like this… [image] startDate = Convert.ToDateTime(New DateTime(System.DateTime.Now.Year, System.DateTime.Now.Month-1, 1)) endDate = Convert.ToDateTime(New DateTime(System.DateTime.Now.Year, System.DateTime.Now.Month-1, System.DateTime.DaysInMonth(System.DateTime.Now.Year, System.DateTime.Now.Month-1))) Here startDate and EndDate are of variable type “DateTime” For Each [image] Create Folder “LastMonthFolders” + item.ToString(“dd-MM-yyyy”) My Outp…

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 03 April 2021

Top 3 Topics with Most Views

Run a Normal Process and a Background Process at same time made by @murat.karasoy with 25 views.

アウトプットexcelファイルの処理結果書き込みについて made by @R_Y with 21 views.

PowerShellを呼び出し made by @atuoko8694 with 20 views.

Top 3 Topics with Most Replies

Select query for column name with space or "&" or "/" made by @ranjani with 5 replies.

Run a Normal Process and a Background Process at same time made by @murat.karasoy with 4 replies.

End Processing After X Number of the Same Error made by @Tyler294 with 4 replies.

Top 3 Users Who Posted The Most

@ppr made 7 posts!

@AndyMenon made 3 posts!

@Aleem_Khan made 3 posts!

Top 3 Most Liked Posts

This post made by @balaji.S received 1 likes!

How to create Multiple folders with last moth dates

@prasath17 many thanks for your efforts , this is absolutely working fine.

This post made by @ppr received 1 likes!

How to fix this package error

@Tharusha_Fernando issue is related to UiPath.System.Activities and/or its dependended packages [grafik] ensure the feed is activated and the network is not blocking the feeds

This post made by @sebastien.raimbault received 1 likes!

Since 21.4 robot with "studio pro" is refusing connection with error "authentication required"

More info on issue faced, I confirm this is proxy related. Laptop with fresh install 21.4, but at home “without coporate VPN connected”, open’s Studio OK immediately and get’s my named licence studio pro (floating) from tenant in Orchestrator cloud, at first trial. @Lim_Leng, I’ve found your recent post on proxy issue for you too, related to last release 2021.4. Very interested in reading next step on this.

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 04 April 2021

Top 3 Topics with Most Views

LINE WORKS というアプリが全画面表示できません made by @nagumo with 27 views.

Data Manager에서 직접 지원하지 않는 OCR 엔진을 사용하여 레이블링하는 방법 made by @Minoh_Kang with 23 views.

表抽出ウィザードがでてこない made by @Xiao1 with 23 views.

Top 3 Topics with Most Replies

Could not add Robot manually made by @Sakshi_Gupta with 14 replies.

Web formunu excel verileriyle doldurun ve excel'e aktarın made by @ridvanucok with 10 replies.

LINE WORKS というアプリが全画面表示できません made by @nagumo with 8 replies.

Top 3 Users Who Posted The Most

@Dorothy_lee made 5 posts!

@NIVED_NAMBIAR made 5 posts!

@Pravin_Patil1 made 5 posts!

Top 3 Most Liked Posts

This post made by @Karuna received 1 likes!

"idx" value of the Website is changing randomly and couldn't find out the pattern and also the selectors to be used to fetch the target

@Nimesh_Bc Try some workarounds Use Get Attribute" activity —> Retrives the value of a specified attribute of UI element —> Specify, Attribute = Innertext Use “Anchore Base” activity —> This should be used when reliable selector is not availble.

This post made by @kumar.varun2 received 1 likes!

UiPath email regex explaination?

Can anyone explain this regex used to get the email address? It is given in the ‘Matches’ activity. (?>[a-zA-Z\d!#$%&'*+\-\/=?^_`{|}~]+\x20*|"((?=[\x01-\x7f])[^"\\]|\\[\x01-\x7f])*"\x20*)*(?<angle><))?((?!\.)(?>\.?[a-zA-Z\d!#$%&'*+\-\/=?^_`{|}~]+)+|"((?=[\x01-\x7f])[^"\\]|\\[\x01-\x7f])*")@(((?!-)[a-zA-Z\d\-]+(?<!-)\.)+[a-zA-Z]{2,}|\[(((?(?<!\[)\.)(25[0-5]|2[0-4]\d|[01]?\d?\d)){4}|[a-zA-Z\d\-]*[a-zA-Z\d]:((?=[\x01-\x7f])[^\\\[\]]|\\[\x01-\x7f])+)\])(?(angle)>)

This post made by @nagumo received 1 likes!

LINE WORKS というアプリが全画面表示できません

UiPath初心者です LINE WORKS というアプリを使用したロボットを作成したのですが、LINE WORKS のアップデート後から全画面表示が出来なくなりました。 ①「プロセスを開始」でLINE WORKS を開いて、 ②「ウィンドウにアタッチ」でLINE WORKS を開いているウィンドウを指定して、 ③「ウィンドウを最大化」という流れです。 上記の方法以外でウィンドウを最大化させる方法はございませんでしょうか？ よろしくお願いいたします。

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 05 April 2021

Top 3 Topics with Most Views

Changes of the SAP GUI Scripting made by @StefanSchnell with 96 views.

How to Use Regex or Split Method made by @Reddy_1 with 38 views.

How to count amount by status? made by @fairymemay with 34 views.

Top 3 Topics with Most Replies

Excel印刷設定方法 made by @miwa_yamamoto with 17 replies.

Search for a list of filenames from the excel in a directory made by @NSharma05 with 9 replies.

Error to Write Formula in Excel made by @lourena.coutinho with 8 replies.

Top 3 Users Who Posted The Most

@Srini84 made 18 posts!

@prasath17 made 11 posts!

@HANACCHI made 10 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 5 likes!

Changes of the SAP GUI Scripting

For all of you who work with the SAP GUI Scripting API here a list of all changes in release 7.60 and 7.70 in the last two years. Having this information at a glance is very interesting. Document history: 7.70 PL 1 - Published 05.04.2021 7.70 PL 2 - Published 24.06.2021 7.70 PL 3 - Published 05.08.2021 7.70 PL 4 - Published 03.11.2021 7.70 PL 5 - Published 21.01.2022 7.70 PL 6 - Published 31.03.2022 7.70 PL 7 - Published 24.06.2022 7.70 PL 8 - Published 04.08.2022 SAPGUIScriptingChange…

This post made by @NIVED_NAMBIAR received 5 likes!

How to write status success in the cell hear am using LINQ

Hi @copy_writes Use invoke code with dt1 variable as In/Out dt1.AsEnumerable.Where(Function(r) String.IsNullOrWhiteSpace(r(“Status”).ToString.Trim)).ToList().ForEach(Sub(row) row(“Status”) =“Success”) Here i am updating status with Sucess for demnstration, but u can add status according to yours After the invoke code, use write range to write the dt1 to the excel file Regards, Nived N Happy Automation

This post made by @voineacristian90 received 3 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi everyone, My name is Cristian Voinea and I am really excited to join this community. I got here through a friend that recommended the Reboot Your Skills program but also wanted to get to meet the members of this community and perhaps even contribute to it soon. Wish you all a wonderfull week!

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 5 likes!

How to write status success in the cell hear am using LINQ

Hi @copy_writes Use invoke code with dt1 variable as In/Out dt1.AsEnumerable.Where(Function(r) String.IsNullOrWhiteSpace(r(“Status”).ToString.Trim)).ToList().ForEach(Sub(row) row(“Status”) =“Success”) Here i am updating status with Sucess for demnstration, but u can add status according to yours After the invoke code, use write range to write the dt1 to the excel file Regards, Nived N Happy Automation

This solution provided by @Mr_Meeseeks received 3 likes!

Remove empty lines from .txt file

@LZlz Can Do! First Do a Read Text activity then an Assign activity (Use .TrimEnd) Finally do a Write Text activity [image] Before [image] After [image]

This solution provided by @prasath17 received 2 likes!

Error to Write Formula in Excel

@lourena.coutinho - Please check this… [image] In Excel… [image] Hope this helps… Note: Since you have double quotes, you have to use ““Attention!”” like this , if not write cell will show an error.

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 06 April 2021

Top 3 Topics with Most Views

Take the survey: The State of the RPA Developer 2021 made by @teresa with 83 views.

Excel操作 made by @Jel with 82 views.

How to count the number of rows in the each group? made by @anonymous3 with 67 views.

Top 3 Topics with Most Replies

Concatenate 2 Column into 1 Column made by @Anggara_Rahmadhani with 19 replies.

I'm new to UiPath, can't get a regex to work made by @Gabriel_Wisniewski with 12 replies.

Data scraping remains in the same web page made by @hamdan.hadeel with 12 replies.

Top 3 Users Who Posted The Most

@Srini84 made 28 posts!

@prasath_S made 21 posts!

@NIVED_NAMBIAR made 12 posts!

Top 3 Most Liked Posts

This post made by @danielasstavares received 5 likes!

Reboot Your Skills Program - Introduce Yourself!

Hi, I’m Daniela, join from Portugal! I’m a student. I hope being able to learn more about RPA.

This post made by @teresa received 5 likes!

Take the survey: The State of the RPA Developer 2021

Hey everyone, The survey for the State of the RPA Developer 2021 is here! You might recall that we ran this industry survey last year for the first time to capture the current experience of RPA developers. (Read last year’s report: The State of the RPA Developer 2020.) Over 1,500 of you responded last year, and we got such great feedback that we’re doing it again. We’ve added in some new questions to get some fresh insights—and we’ll explore year over year trends. And for students? We’…

This post made by @Vibhor.Shrivastava received 3 likes!

Reboot Your Skills Program - Introduce Yourself!

Hi All, My name is Vibhor Shrivastava and I am a Community Manager, APAC at UiPath. I am responsible to drive various programs for the UiPath Community such as meetups, hackathons, and all sorts of community engagement activities. I am based in the Silicon Valley of India which is Bangalore. I am learning automation so that I can address and help #uipathcommunity queries and guide them in the best possible ways. I would love to automate a process that can help me capture details of all-new vide…

Top 3 Most Liked Solutions

This solution provided by @yukino received 2 likes!

日付として値が存在するか判定したい

和暦は説明も実装も面倒くさいんや・・・（苦笑） こんな感じになりますが、ちょっと読んでみてもらえます？ Main.xaml (7.4 キロバイト)

This solution provided by @Pravin_Patil1 received 1 likes!

How can I download StudioX?

@julie.t.duncan Welcome to Community! Follow the below steps to get Studio X Go to setting of UiPath studio when it open Go to the License and profile option Go to view or change profile Select Studio X then it will ask you to restart studio click yes. Refer below. [image] [image] Note: Follow the same step to get back to Studio from Studio X

This solution provided by @HANACCHI received 1 likes!

Excel印刷設定方法

"Sheet1"が対象となるはず。。。 改造してみました。エントリメソッドのパラメタに、対象シート名を{}で括って指定してみてください（例ではSheet3を対象とした） PrintSet.txt (714 バイト) [image]

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 07 April 2021

Top 3 Topics with Most Views

テキストファイルをデータテーブルに made by @111884 with 34 views.

Getting unicorn name to be the email signature made by @jeremy.lim with 31 views.

Got error when open week1 video made by @ron.liu with 29 views.

Top 3 Topics with Most Replies

No compiled code to run made by @Jenni_K with 13 replies.

Calculate Client Security Hash - Result 0/100 made by @mustak.rased with 12 replies.

Getting actors age from web and writing down in excel made by @xyzxyz_123 with 12 replies.

Top 3 Users Who Posted The Most

@Hiba_B made 24 posts!

@prasath_S made 18 posts!

@nashrahkhan made 13 posts!

Top 3 Most Liked Posts

This post made by @cosminSimion received 3 likes!

Week1 Build your first automation project is not changing status

Hey @Victor_Villa_MM-JZ, congrats for completing your first milestone. If your progress is not updated yet, please try the following steps: Open “Welcome to Week 1” module again [Screenshot 2021-04-07 at 09.38.46] Scroll all the way down and select “Exit Page” [Screenshot 2021-04-07 at 09.40.18] Refresh your Course Page This should update your progress status. However, if this doesn’t work, please go here, and complete the contact details. You should select Academy for “What i…

This post made by @jane.rowe received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi There, My name is Jane Rowe and I am an administrator at La Trobe University in Melbourne, Australia. I have joined other uni members to learn RPA so am taking the Reboot Your Skills course. Looking forward to a new experience. Cheers Jane

This post made by @rkym123456 received 2 likes!

日付として値が存在するか判定したい

回答ありがとうございます。 パラメータ内の順番が違っており、修正したところ上手くいきました。 大変ありがとうございました。

Top 3 Most Liked Solutions

This solution provided by @cosminSimion received 3 likes!

Week1 Build your first automation project is not changing status

Hey @Victor_Villa_MM-JZ, congrats for completing your first milestone. If your progress is not updated yet, please try the following steps: Open “Welcome to Week 1” module again [Screenshot 2021-04-07 at 09.38.46] Scroll all the way down and select “Exit Page” [Screenshot 2021-04-07 at 09.40.18] Refresh your Course Page This should update your progress status. However, if this doesn’t work, please go here, and complete the contact details. You should select Academy for “What i…

This solution provided by @vignesh.ks received 1 likes!

Could not load file or assembly 'ClosedXML, Version=0.87.0.0' How to remove the reference of this version from the project

Okay, Please update the dependencies mentioned below, UiPath.Excel.Activities UiPath.MicrosoftOffice365.Activities Update the package and try running the process. Thanks Happy Automation

This solution provided by @melanie.p received 1 likes!

Runtime Execution Error: Unexpected PDF structure - Exception Type: BitMiracle.Docotic.pdf.UnexpectedStructureException

Hi @GreenTea thanks a lot for answering. I looked into it a bit more because Copy File Activity was not an option, because many users in the department will use it and its kinda “unsexy” to copy it to everyones local path to use the process. I found out that there was a hidden file named Thumbs.db in the folder which was the first file that would be read. I now did configure the Directory.GetFiles() to get just PDF or Word Files, so the Thumb.db will be ignored. The process is now working agai…

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 08 April 2021

Top 3 Topics with Most Views

【UiPathアカデミー】UiPath Orchestrator のコースが新しくなりました！ made by @Taeko_UiPath with 90 views.

Kill process issue made by @mannu.1996.08 with 31 views.

I am not able to download Ui Path from the link provided.....the page is not being loaded inspite of good internet connection, pls help made by @Garima_Soni with 27 views.

Top 3 Topics with Most Replies

Kill process issue made by @mannu.1996.08 with 19 replies.

Excel merge cell and delete empty row made by @Shiva_Kumar1 with 17 replies.

Write cell : Root Element is Missing made by @Ganesh_S1 with 15 replies.

Top 3 Users Who Posted The Most

@Srini84 made 20 posts!

@ppr made 20 posts!

@mannu.1996.08 made 14 posts!

Top 3 Most Liked Posts

This post made by @tseidler received 3 likes!

Milestone 5 - Automating Word

There was a minor inconvenience with using the template word doc: I had Office 365 on auto-save, while in StudioX the word resource was set to not save changes. The Office 365 option takes precendence it seems Other than that it was a fun excercise!

This post made by @LisaBoneta received 2 likes!

Announcing the 2021 UiPath MVPs!

Congrats to all the MVPs! Amazing work

This post made by @Taeko_UiPath received 2 likes!

【UiPathアカデミー】UiPath Orchestrator のコースが新しくなりました！

平素より、UiPathアカデミーをご利用くださいまして誠にありがとうございます この度、下記の3つのコースを、新たにリリースいたしました UiPath Orchestrator 入門コース ⇒ 受講対象者：どなたでも UiPath Orchestrator 基礎コース ⇒ 受講対象者：RPAデベロッパー向け UiPath Orchestrator 管理コース ⇒ 受講対象者：Orchestrator管理者向け Orchestrator バージョンについて Orchestrator モダンフォルダーを前提としたコースにて、 最新の Automation Cloud 2021.4 から、オンプレミスにてご利用の方まで、広く対応しております カリキュラム再構成の背景について 入門コースは、より多くの方に Orchestrator の魅力が伝わる構成となり、 管理コースは、モダンフォルダー内のリソース管理方法に焦点をあて、 各リリースの概念が理解できるように構成しました （旧）UiPath Orchestratorコースをご受講済みの方へ 名称は、「UiPath…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

スプレットシートをクリップボードにコピー

こんにちは @Kah_Liang さんの記述内容とほぼ同じですが Excel application scopeの 出力-ブック または 既存のブックを使用－既存のブック に DataTableの変数をセットしているのではないでしょうか？ もしそうなら、これらを削除してみてください。

This solution provided by @vignesh.ks received 1 likes!

Switch : object reference not set to an instance of an object

Hi @Mohamad_Izudin_Bin_Abdul Before switch activity, kindly print all the variables used in switch condition and check whether the variables contains value or not. Thanks.

This solution provided by @irahmat received 1 likes!

Studio has Robot Error Status

Hi Alex, I solved the issue by add exception IP address in the proxy [image]

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 09 April 2021

Top 3 Topics with Most Views

Fill missing data in excel - Replace "?" made by @Yudhisteer_Chintaram with 28 views.

How to Convert time to text string in excel? made by @Welcoming with 27 views.

Connection with UiPath Excel-Add-In keeps failing made by @anotherulrich with 27 views.

Top 3 Topics with Most Replies

How to split the equation(string type),if A1-A2 then var1=A1, var2=- , var3=A2 made by @eimon with 20 replies.

Question on Number type made by @Prinal_C with 12 replies.

https://forum.uipath.com/t/305355 made by @SIM_JUN_HUI_BERTRAM_CSOD with 12 replies.

Top 3 Users Who Posted The Most

@prasath_S made 37 posts!

@Hiba_B made 24 posts!

@prasath17 made 16 posts!

Top 3 Most Liked Posts

This post made by @Hiba_B received 2 likes!

Data extraction from text to excel

Hi @sayali_rokade ! A way is to use regex, @prasath17 masters it: would you mind helping us ?

This post made by @sangL received 2 likes!

How pass datatable as checkbox or selectboxes in Form.Activities

Hi @lojyehuang - thanks for the inquiry. We will check this internally to see if we can resolve and follow up with you. Thanks.

This post made by @Eric_Wong_Test received 2 likes!

How to split the equation(string type),if A1-A2 then var1=A1, var2=- , var3=A2

You can use this [image]

Top 3 Most Liked Solutions

This solution provided by @wood.raymond79 received 2 likes!

Activities Pane Remains above Main Window

Problem solved. I was able to resize the pane by dragging it out from the side. It popped out of the centre and I was able to move it back to its home.

This solution provided by @prasath_S received 1 likes!

Delete text in SAP

Hi @Markus3003 Use type into activity and set empty field propery ticked, it will clear the text field and type whatever text you given in the input field of the activity. In properties panel of type into activity, [image]

This solution provided by @Eric_Wong_Test received 1 likes!

How to split the equation(string type),if A1-A2 then var1=A1, var2=- , var3=A2

match.xaml (6.0 KB)

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.