Forum Engagement Daily Reports

[system]

Daily Forum Report | 14 January 2022

Top 3 Topics with Most Views

Get Text Questions made by @user118 with 57 views.

How to extract data from two delimiter where 2nd delimiter is bit changing made by @Mansi_Mhatre with 38 views.

動的セレクターに変数を入れたらエラーになります。 made by @miwa_yamamoto with 33 views.

Top 3 Topics with Most Replies

Get Text Questions made by @user118 with 23 replies.

動的セレクターに変数を入れたらエラーになります。 made by @miwa_yamamoto with 7 replies.

For each row data made by @brettthompson with 7 replies.

Top 3 Users Who Posted The Most

@Yoichi made 24 posts!

@ppr made 17 posts!

@user118 made 13 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

How to remove only numbers from string

in addition to: [grafik] Kindly note: some enhancements are to do for additional spaces and keeping var2 [grafik] the difference to your output: from data vs. from or data or is not a number, so we do not remove. Maybe the requirements are to redefine

This post made by @ppr received 2 likes!

Get half of a time duration?

similar as Oneliner: [grafik] ts2 = TimeSpan.FromTicks(CLng(ts1.Ticks / 2))

This post made by @pikorpa received 1 likes!

How to remove only numbers from string

Hey, try to use: System.Text.RegularExpressions.Regex.Replace(myStr ,"\d", “”)

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

How to remove only numbers from string

in addition to: [grafik] Kindly note: some enhancements are to do for additional spaces and keeping var2 [grafik] the difference to your output: from data vs. from or data or is not a number, so we do not remove. Maybe the requirements are to redefine

This solution provided by @Larry_Rogers received 2 likes!

Automation Fails as Unattended from Orchestrator - Elements not found

Quick Update. So I went and downgraded then re-updated the System and Automation dependencies then re-published. And, it works. Thanks all for the feedback and ideas.

This solution provided by @ppr received 1 likes!

LIST LINQ/LAMBDA TO FILTER DATA FROM LIST

YourListVar.Where(Function (x) x.toUpper.Contains("DOG")).toList [grafik]

---

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 | 15 January 2022

Top 3 Topics with Most Views

How to change date in right format for column of excel using uipath made by @Kanchan_Gawande with 42 views.

Store a message box in another excel file made by @Abx9 with 42 views.

How to use a regex selector which matches multiple UI-Elements? made by @akapak with 37 views.

Top 3 Topics with Most Replies

Store a message box in another excel file made by @Abx9 with 9 replies.

MOVE TRANSACTIONS FROM ONE QUEUE TO ANOTHER made by @icehouselux with 9 replies.

How to change date in right format for column of excel using uipath made by @Kanchan_Gawande with 7 replies.

Top 3 Users Who Posted The Most

@Robinnavinraj_S made 8 posts!

@poorna_nayak07 made 6 posts!

@Abx9 made 6 posts!

Top 3 Most Liked Posts

This post made by @Le_Chiffre received 6 likes!

Monthly Forum rewards - December 2021

Congratulations to everyone. In this forum I can always find everything what I need. And it’s thanks to You.

This post made by @pikorpa received 2 likes!

Next working date

Hey, you can try use: or check this workflow: BlankProcess24.zip (2.5 KB)

This post made by @Thong_Mai_Tr_ng_Hoang received 1 likes!

Document Understanding: Machine Learning Document Classification Community Release

Hi @Lahiru.Fernando and @Tarun_Singh , Can Machine Learning Classification be able to split document the same as intelligent keyword classifier ?

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to use a regex selector which matches multiple UI-Elements?

Hi, In this case, we need to use FindChildren activity. Hope the following sample helps you. [img20220115-a3] Sample20220115-2.zip (2.9 KB) Regards,

This solution provided by @Robinnavinraj_S received 1 likes!

How to run a local sequence in Cloud?

Hi @akapak If you want to learn uipath from the scratch Create a account in https://academy.uipath.com And register for RPA DEVELOPER FOUNDATION In that course they will cover overall basics of uipath If you want to run your local sequence into orchestator First you have to publish your workflow by publish icon in uipath studio After that you have to create a unattended bot in orchestrator And connect that bot with your uiassistant If all set well you can run your code from orchestrator …

---

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 | 16 January 2022

Top 3 Topics with Most Views

Problem with File Exist made by @NHoe with 40 views.

Save CountRows from excel file to another excel file made by @Abx92 with 40 views.

I am creating a new topic base on my error about selector made by @Ang_Weng_Fook with 36 views.

Top 3 Topics with Most Replies

Everytime executing same transaction item made by @Rakesh_Tiwari with 16 replies.

Save CountRows from excel file to another excel file made by @Abx92 with 12 replies.

Problem with File Exist made by @NHoe with 11 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 22 posts!

@90s_Developer made 10 posts!

@Rakesh_Tiwari made 8 posts!

Top 3 Most Liked Posts

This post made by @Robinnavinraj_S received 3 likes!

Select todays excel file from specific location uipath

Hi @Abx9 First create a directory variable with DirectoryInfo type ex directorylocation directorylocation = new DirectoryInfo("your excel file directory") Then you have to create a another array variable with FileInfo type. ex newly_created_files newly_created_files = directorylocation.GetFiles(".xlsx").Where(function(file) file.LastWriteTime.Date=DateTime.Now.Date).OrderByDescending(function(d) d.LastWriteTimeUtc).ToArray Today created files are stored in newly_created_files Pass this a…

This post made by @Nithinkrishna received 2 likes!

Linq Query -- Help

Hi @Anjali_Rani Hope the below helps you… (From r In mergedtextfileop.AsEnumerable Let ra = r.ItemArray.Select(Function (x) if(not string.isNullOrEmpty(Convert.ToString(x).Trim), x.ToString.Trim.Replace("%%",","), x)).toArray() Select correctData.Rows.Add(ra)).CopyToDataTable() Thanks #nK

This post made by @Nithinkrishna received 2 likes!

How to run multiple process using mail subject

Hey @Ranganathan_M Have a bot to monitor outlook (may be a background process) and then start the other job based on the mail subject. The logic will be built to trigger appropriate process based on the mail subject in the above process. Hope this helps. Thanks #nK

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 2 likes!

Linq Query -- Help

Hi @Anjali_Rani Hope the below helps you… (From r In mergedtextfileop.AsEnumerable Let ra = r.ItemArray.Select(Function (x) if(not string.isNullOrEmpty(Convert.ToString(x).Trim), x.ToString.Trim.Replace("%%",","), x)).toArray() Select correctData.Rows.Add(ra)).CopyToDataTable() Thanks #nK

This solution provided by @Robinnavinraj_S received 2 likes!

Select todays excel file from specific location uipath

please find the attached xaml file for more reference TodaysNewestFileIinDirectory.xaml (9.9 KB) Thanks, Robin

---

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 | 17 January 2022

Top 3 Topics with Most Views

Need regex expression to scrape particular data from e mail body made by @Aleem_Khan with 51 views.

"project.json" file corrupted made by @hsendel with 45 views.

Read all from PDF and Paste into Excel made by @Md_Hidayat with 43 views.

Top 3 Topics with Most Replies

About Data Table filtering Date made by @Likesh_Lim with 21 replies.

How to convert this Date formate 26-Dec-2021 to this formate 26/12/2021 made by @Gopi_Krishna1 with 18 replies.

Need regex expression to scrape particular data from e mail body made by @Aleem_Khan with 14 replies.

Top 3 Users Who Posted The Most

@Robinnavinraj_S made 35 posts!

@THIRU_NANI made 24 posts!

@90s_Developer made 23 posts!

Top 3 Most Liked Posts

This post made by @pravin_calvin received 3 likes!

How to split text that comes from String

Hi @Arthur_Ziganshin Use the expression below! InputString.SubString(0,3) Regards

This post made by @Dana_Mustatea received 2 likes!

Rate UiPath and get rewarded!

Rate UiPath and get rewarded! Hi everyone! We have two new campaigns, waiting for you: Deadline: 2022-01-31T23:00:00Z (UTC) G2 Rewards: The first 50 reviewers of UiPath will get a $25 Visa.com‌ gift card directly from the G2 team, once the review will be approved If you already wrote a review on G2 for UiPath, you cannot write another one, by using the same account Users from UiPath partners’ companies are not eligible. Please be sure to use your LinkedIn or your business email for…

This post made by @Mr_JDavey received 2 likes!

UI Explorer validating selector even though element does not exist

Hi there @lapet, I hope you are having a great day! Most likely, the element still exists, but upon dismissal, it has it’s visibility set to false. There are a few ways to handle this, you could: Use a Get Attribute - Set to Visibility. Use a Find Element - With Visibility set to True. The above will allow you to check, not only that it exists, but whether it is visible on the screen. Please let me know if you have any questions. Thanks once again for your support, Josh

Top 3 Most Liked Solutions

This solution provided by @Mr_JDavey received 2 likes!

UI Explorer validating selector even though element does not exist

Hi there @lapet, I hope you are having a great day! Most likely, the element still exists, but upon dismissal, it has it’s visibility set to false. There are a few ways to handle this, you could: Use a Get Attribute - Set to Visibility. Use a Find Element - With Visibility set to True. The above will allow you to check, not only that it exists, but whether it is visible on the screen. Please let me know if you have any questions. Thanks once again for your support, Josh

This solution provided by @Robinnavinraj_S received 1 likes!

Read all from PDF and Paste into Excel

Hi @Md_Hidayat First you have to install UiPath.PDF.Activities package [image] then read your pdf with read pdf text activity and store the output variable like Str [image] Drag and drop the matches activity and choose dropdown as Advanced and paste the regex **([\w\W]+(?=\n))**in value tab [image] create a output variable for matches activity like RegEx_Out enter input string as read pdf text activity output variable [image] Build a datatable for output excel and create one column…

This solution provided by @THIRU_NANI received 1 likes!

Cron Expression schedule

Hi! You have to create 3 triggers Job1 Cron Expression: 0 30 9 2 1/1 ? * Job2 Cron Expression: 0 45 9 2 1/1 ? * Job3 Cron Expression: 0 0 10 2 1/1 ? * Regards, NaNi

---

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 | 18 January 2022

Top 3 Topics with Most Views

I need some help with extracting data from Youtube Playlists made by @Nostradamon1 with 52 views.

Suddenly Bot is not able to read the excel file made by @kkpatel with 43 views.

Regular expression to fetch yellow highlighted value made by @Aleem_Khan with 41 views.

Top 3 Topics with Most Replies

I need some help with extracting data from Youtube Playlists made by @Nostradamon1 with 16 replies.

Type Into 'INPUT email': Could not find target element because Internet Explorer is running in Enhanced Protected Mode made by @Neha_Singh1 with 15 replies.

Suddenly Bot is not able to read the excel file made by @kkpatel with 11 replies.

Top 3 Users Who Posted The Most

@90s_Developer made 27 posts!

@Shikhar_Tandon made 25 posts!

@Robinnavinraj_S made 19 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Convert XLS to XLSX problems

Hi, Your attached file is not xls format but text format. Anyway, how did you convert it to xlsx? I recommend to use SaveExcelFileAs activity in modern-excel as the following. [img20220119-1] Sample20220119-1.zip (4.3 KB) Hope this helps you. Regards,

This post made by @ppr received 2 likes!

I wonder the way using Maketransparent in Uipath

methods with no return values (sub - subroutine) cannot be used within an assign activity we can use: invoke method - sometimes also the reference got lost invoke code

This post made by @Sudharsan_Ka received 2 likes!

Regular expression to fetch yellow highlighted value

HI @Aleem_Khan Expression for Optional modules: (?<=Optional modules:\s)\S.+ Regards Sudharsan

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Convert XLS to XLSX problems

Hi, Your attached file is not xls format but text format. Anyway, how did you convert it to xlsx? I recommend to use SaveExcelFileAs activity in modern-excel as the following. [img20220119-1] Sample20220119-1.zip (4.3 KB) Hope this helps you. Regards,

This solution provided by @pikorpa received 2 likes!

Cannot able to read Orchestrator Asset Value in Read Range

Hey @saritha So you are use double quotes. You don’t need it in the path Instead: “c:\folder\fileName.xlsx” please use: c:\folder\fileName.xlsx

This solution provided by @Robinnavinraj_S received 1 likes!

Fetch url from outlook e mail body

Hi @Aleem_Khan There are two methods to extract Url from Email 1 ) Matches activity In the matches activity click configure regular expressions and Choose regex dropdown as Url [image] pass input string as email body variable and create a output variable in result tab Finally output variable holds Url value 2)using regex in assign activity you have to create a variable Like *Str_Out Str_Out=System.Text.RegularExpressions.Regex.Match(your_email_body_string_variable, “(?:(?:https?|ftp|fi…

---

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 | 19 January 2022

Top 3 Topics with Most Views

Submit your use case to earn a 50% discount on advanced certification voucher made by @Oana_Chicioroaga with 199 views.

Unable to create Trigger: No user with unattended robot permissions made by @praveen_sonkusare with 87 views.

Uipath Orchestrator issue in another machine made by @soundarya_vanama with 79 views.

Top 3 Topics with Most Replies

Uipath Orchestrator issue in another machine made by @soundarya_vanama with 28 replies.

Unable to create Trigger: No user with unattended robot permissions made by @praveen_sonkusare with 26 replies.

Error message running attended robot: Open Browser: Cannot open the browser: access denied made by @atarantino with 20 replies.

Top 3 Users Who Posted The Most

@THIRU_NANI made 43 posts!

@Nithinkrishna made 38 posts!

@90s_Developer made 37 posts!

Top 3 Most Liked Posts

This post made by @Oana_Chicioroaga received 10 likes!

Submit your use case to earn a 50% discount on advanced certification voucher

Dear community fellows, New year resolutions? Choose to be a self-learner and start upskilling your competence with UiPath Academy certification modules. The community team is here to support your automation journey by offering a 50% discount on an advanced certification voucher. Here are the details you need to know about the certification program. UiPath Certified Advanced RPA Developer is recommended for candidates with more than six months’ working experience in developing RPA solutions. …

This post made by @ptrobot received 2 likes!

How to get text from shape?

The code @phyomt refer to should work fine if you use it inside an Invoke Code activity and change “AlternativeText” to “TextFrame.Characters().Text”. [image] If you prefer C# instead of VB.NET: string excelFile = Path.Combine(Directory.GetCurrentDirectory(), @"Data\Exp.xlsx"); Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook wb = excel.Workbooks.Open(Filename: excelFile, ReadOnly: true); Microsoft.O…

This post made by @Gokul001 received 2 likes!

How to print the Json Array using for each loop

Hi @shreyash_shirbhate Use this Assign acticity inside the For each loop Use Assign activity RHS : item.GetValue(“predictions”).ToString Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @ptrobot received 2 likes!

How to get text from shape?

The code @phyomt refer to should work fine if you use it inside an Invoke Code activity and change “AlternativeText” to “TextFrame.Characters().Text”. [image] If you prefer C# instead of VB.NET: string excelFile = Path.Combine(Directory.GetCurrentDirectory(), @"Data\Exp.xlsx"); Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook wb = excel.Workbooks.Open(Filename: excelFile, ReadOnly: true); Microsoft.O…

This solution provided by @Gokul001 received 2 likes!

How to print the Json Array using for each loop

Hi @shreyash_shirbhate Use this Assign acticity inside the For each loop Use Assign activity RHS : item.GetValue(“predictions”).ToString Regards Gokul

This solution provided by @liu_shubin received 1 likes!

Convert XLS to XLSX problems

Another way is to use “Read Range” activity to read XLS file and “Write Range” activity to write Datatable to XLSX file. You refer to the screenshot. [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 | 20 January 2022

Top 3 Topics with Most Views

Search in excel with like %% made by @Aguirre with 51 views.

Check row in excel (delete & cut) made by @fairymemay with 48 views.

Splitting String at multiple words made by @Pathler with 44 views.

Top 3 Topics with Most Replies

Data extraction failed, no data was obtained made by @Uddynitjh with 13 replies.

Error in Send SMPT Mail message Activity made by @monika.c with 13 replies.

Convert semicolon delimited text (;) to excel file from a CSV file made by @Ionut_Frincu with 12 replies.

Top 3 Users Who Posted The Most

@Robinnavinraj_S made 27 posts!

@ppr made 25 posts!

@90s_Developer made 24 posts!

Top 3 Most Liked Posts

This post made by @ingo.leonhard received 3 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi all, I’m Ingo from Germany. I’m a software developer in a internationally operating company and I’m very new to UiPath. Like you, I have a lot of questions and hope that someone can answer it See you in the Forum!

This post made by @ppr received 2 likes!

Delete duplicate AND original value from a datatable

one of many options would be to merge the two tables (we assume the column structure / names are the same dtMerged: Col1 1 2 3 5 1 2 3 4 then we remove the duplicated values by dtResult = (From d in dtMerged.asEnumerable Group d by k=d(0).toString.Trim into grp=Group Where grp.Count = 1 Select r = grp.First()).CopyToDataTable

This post made by @Yoichi received 2 likes!

200万行以上あるデータテーブルの重複行削除

こんにちは あまり変わらないかもしれませんが以下試してみてください。 dt = dt.AsEnumerable.Distinct(DataRowComparer.Default).CopyToDataTable()

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

200万行以上あるデータテーブルの重複行削除

こんにちは あまり変わらないかもしれませんが以下試してみてください。 dt = dt.AsEnumerable.Distinct(DataRowComparer.Default).CopyToDataTable()

This solution provided by @kirankumar.mahanthi1 received 1 likes!

Delete duplicate AND original value from a datatable

Hi @Timsener , There is another method we can use to achieve this requirement. Use Join data table activity with Full join mode and assign DT1, DT2 to get the DT3. Use Filter to remove the blank values those are not matched. Please refer the attached work flow for your reference. if you wish you could try. thanks. Join Demo.zip (17.4 KB)

This solution provided by @Robinnavinraj_S received 1 likes!

How to create two new datatables only with rows that have content?

hi @Lynx Please find the attached overall project Diccionario (2).zip (25.9 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 | 21 January 2022

Top 3 Topics with Most Views

Excelの表をHTMLに埋め込みたい made by @miwa_yamamoto with 51 views.

Problem to insert formula in Excel using Uipath made by @Re_Walter with 47 views.

About Split Method result made by @mat-tang with 44 views.

Top 3 Topics with Most Replies

Wrong Browser is starting sometimes made by @atomic with 17 replies.

How do i check if it is approved? made by @SIM_BERTRAM with 16 replies.

About Split Method result made by @mat-tang with 12 replies.

Top 3 Users Who Posted The Most

@ppr made 22 posts!

@Yoichi made 19 posts!

@THIRU_NANI made 19 posts!

Top 3 Most Liked Posts

This post made by @pikorpa received 4 likes!

Creation of Dashboard in UiPath

Hey, UiPath can collect the mentioned data and send it to, for example, a database, where the previously created dashboard will show the changes. UiPath is not used for data visualization.

This post made by @ppr received 3 likes!

How to pass multiple variable to check is variable empty

{var1, var2, var3}.Any(Function (x) String.IsNullOrEmpty(x.Trim)) we assume alll vars of datatype string

This post made by @kirankumar.mahanthi1 received 2 likes!

How to remove the duplicate key from json array

Hi @Harshini_Lakshmi , My suggestion for your question is try converting your json array to datatable by using the deserialize Json Array so that once you get the json array in datatable format you will be able to find out whether the key is having duplicates or not. thanks.

Top 3 Most Liked Solutions

This solution provided by @Sudharsan_Ka received 2 likes!

Certain activities not showing up

If in case you need modern design you can also enable it in the filter in the activity panel [image] You can also use classic activities(i.e., Default activities like element exist ,open browser ) in the modern design workflow [image] I Regards Sudharsan

This solution provided by @pikorpa received 2 likes!

How to start Dispatcher process when Queue is Empty?

Hey, If you don’t want add any changes into script the best way will be use UiPath API. From Orchestrator level you can’t do what you want.

This solution provided by @Yoichi received 1 likes!

Excelの表をHTMLに埋め込みたい

こんにちは 新しい（モダン用の）「メールを送信」アクティビティの場合、HTMLエディタがついていて、 ここでDataTableをマッピングすると、そのまま表として貼り付けてくれます。 [img20220121-3] ただしデスクトップ版アウトルックではうまく機能しない場合があるとのことなので、 その場合は要確認です

---

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 January 2022

Top 3 Topics with Most Views

Uipath empid check and send email made by @sayali_rokade with 44 views.

Describe this expression made by @Lakshya_Garg with 37 views.

How to Rename Multiple Files at once in UiPath ?Helps made by @punnipah with 37 views.

Top 3 Topics with Most Replies

Uipath empid check and send email made by @sayali_rokade with 11 replies.

Sorting columns without sort datatable activity made by @Shoebmd with 11 replies.

How to infinite loop in try catch? made by @NervousTuber with 10 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 24 posts!

@Shikhar_Tandon made 21 posts!

@kirankumar.mahanthi1 made 13 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 6 likes!

Describe this expression

Hi @Lakshya_Garg , Let’s break this Expression into individual pieces and Explain Let’s take an Example String as well : gettext= "Client ID : 1111212 Client Name : Jack" gettext.Substring(gettext.IndexOf("Client ID: ")+"Client ID: ".Length) The Above Expression is using a String Substring Method. The Syntax goes as below : String.Substring(startIndex, length) startIndex - An Integer value indicating the position from where the start of the String should be selected. (Shou…

This post made by @kirankumar.mahanthi1 received 2 likes!

Describe this expression

Great explanation @supermanPunch it is giving more clarity with the examples. Nice to see your post.

This post made by @supermanPunch received 2 likes!

How to auto select the column instead of typing Column Number for a formula?

Hi @xxGoRpa , One of the methods would be to Iterate over the Datatable that is the Excel file and Update the Column Value Accordingly. You can follow the below Steps : Read the Excel file using Workbook Read Range Activity. Assign an Output Variable named DT. Next you can use an For Each Row In Datatable Activity, provide the Input Datatable as DT. Inside the For Each Row use an Assign Activity with the following : row("Total") = CDbl(row("Quality").ToString)*CDbl(row("Price").ToStrin…

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 6 likes!

Describe this expression

Hi @Lakshya_Garg , Let’s break this Expression into individual pieces and Explain Let’s take an Example String as well : gettext= "Client ID : 1111212 Client Name : Jack" gettext.Substring(gettext.IndexOf("Client ID: ")+"Client ID: ".Length) The Above Expression is using a String Substring Method. The Syntax goes as below : String.Substring(startIndex, length) startIndex - An Integer value indicating the position from where the start of the String should be selected. (Shou…

This solution provided by @Palaniyappan received 1 likes!

Find time difference between 2 dates

Hi Did we check with this thread We can combine all those individual conversion and concatenate the string with space in the middle so that you get the expected output format Cheers @hsendel

This solution provided by @atomic received 1 likes!

Wrong Browser is starting sometimes

Hi, You can close this post. I found the problem. It was an “open browser activity” that wasnt used much in my REF that I forgot about hehe. Everything is fine with the logic and your platform. Developer 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 | 23 January 2022

Top 3 Topics with Most Views

[System Exception]How to resolve this problem? made by @Apple with 45 views.

Nupkg not found in Studio made by @ecSC2 with 39 views.

How can I install Studio X on Apple IOS made by @Leo_Mazuran with 38 views.

Top 3 Topics with Most Replies

Nupkg not found in Studio made by @ecSC2 with 15 replies.

How to read the mail body of Office365 mail message as Html made by @MariaJosephina with 13 replies.

"A table can't overlap another table" error by using Fomat DataTable made by @saritha with 8 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 33 posts!

@supermanPunch made 12 posts!

@hemal made 9 posts!

Top 3 Most Liked Posts

This post made by @Jiban_Stars received 2 likes!

Need regex expession to find certain words

Hii All I have just started learning regex & im stuck at a point Actually i need to check 2 words are present in a string im definitely using is match activity(BUT not getting the expressions) please help test String- Isle of Man(COM),Estonian(EE),Danish(DK),European(EU),United Kingdom(UK),Bulgarian(BG),Schleswig-Holstein(DESH),Romanian(RO),Isle of Man(RUSO) & we need find these 3 words- isle of man(COM) , European(EU), Please help Thanks in advance

This post made by @jaume.ros received 1 likes!

Hi, I want to check number of occurrences of keywords from string based on keywords from filter datatable columns

Hi @Mansi_Mhatre, you can achieve this by doing some nested iterations and a RegEx pattern. I have done this generic workflow that works for all the examples that you posted. Let me know if it is what you are looking for. CheckStringOcurrences.7z (31.2 KB)

This post made by @liu_shubin received 1 likes!

How to Rename Multiple Files at once in UiPath ?Helps

You can try another folder as the previous screenshot showed that your flow ran successfully.

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 1 likes!

Achieve use cases with community edition is fine or require enterprise

Hi Welcome to uipath forum Yes you can go ahead with community edition of its for your personal use But if it’s for a enterprise then go for enterprise edition Even you have got a 60 days of trial enterprise version that would help you experience how a enterprise setup would be Cheers @Akesh_John

This solution provided by @Robinnavinraj_S received 1 likes!

Filter data and delete row?

Hi @fairymemay Please find the attached overall project i developed a flow as per your requirement Forum_CutDelete (4).zip (133.2 KB) thanks Robin

---

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 January 2022

Top 3 Topics with Most Views

Automation in background made by @vikash.poddar with 59 views.

Rename multiple files in a folder with date format made by @Sudheer_Kumar_S with 39 views.

データスクレイピングでデータに張ってあるリンク情報を取得 made by @176_Tamasa with 38 views.

Top 3 Topics with Most Replies

Automation in background made by @vikash.poddar with 25 replies.

How to manage error in macro with uipath made by @fairymemay with 12 replies.

データスクレイピングでデータに張ってあるリンク情報を取得 made by @176_Tamasa with 10 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 67 posts!

@Yoichi made 19 posts!

@kirankumar.mahanthi1 made 18 posts!

Top 3 Most Liked Posts

This post made by @AndyMenon received 3 likes!

Unlock Linux automation with 21.8 Robot!

Sweet! Wanted to get into it, and now I did. Output of a Bot performing Linux file create + write operation on the default WSL 2 Alpine Linux container. Had to install nano that I’m used to in Debian and Raspbian. [image] Cheers!

This post made by @Palaniyappan received 3 likes!

Automation in background

Hi Welcome to UiPath forum When you want to run a process in background with UI interaction then go for Unattended bots Have a view on this for details We can’t use background process as we won’t be able to interact with UI elements when background process template is used Background processes must not make use of interactive activities, like Click or Type Into found in the UiPath.UIAutomation.Activitiespackage. Check out the Background Process Automation page to read more about how …

This post made by @Satrajit_Bari received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello Everyone, I am Satrajit Bari working on RPA for last 8 years and manage to deliver 500+ Bots using various technologies. I would like to try UiPath too. Thanks

Top 3 Most Liked Solutions

This solution provided by @MariaJosephina received 2 likes!

How to read the mail body of Office365 mail message as Html

Thanks @Palaniyappan and @Yoichi for the support. On enabling, Get as HTML property and also reading the mail body as : mail.Body, I am able to fetch the mail body in HTML format.

This solution provided by @Palaniyappan received 1 likes!

Color cell vb.net/LINQ

Hi We can use the same with a simple if condition and a Ser range Color activity like this Row(“NAMECOLUNN”).ToString.Contains(“NOK”) If true it goes to then block where use set range Color and mention the same expression as you had like System.Drawing.Color.Red And same with else block like System.Drawing.Color.Green Cheers @Luan

This solution provided by @111561 received 1 likes!

データの途中から処理をしたいです

ありがとうございます！ できました！ 最終行が取得できたので 未処理の『A6:C8』でデータテーブルを作りました。 ありがとうございます！！

---

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 January 2022

Top 3 Topics with Most Views

How to use Add data row Activity made by @Doonline with 50 views.

Invoke Pythod Method Error made by @Yudhisteer_Chintaram1 with 48 views.

I am expected to get 0 as output but I am getting 1 as my Output in Excel operation made by @Gopikrishna_S with 47 views.

Top 3 Topics with Most Replies

I am expected to get 0 as output but I am getting 1 as my Output in Excel operation made by @Gopikrishna_S with 31 replies.

Dictionary does not recognise Key even though it is unique made by @andrea.ong with 28 replies.

Invoke Pythod Method Error made by @Yudhisteer_Chintaram1 with 19 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 57 posts!

@Yoichi made 41 posts!

@Gopikrishna_S made 15 posts!

Top 3 Most Liked Posts

This post made by @Corina_Gheonea1 received 5 likes!

Our Community is nominated at the CMX Community Industry Awards 2022!

Dear community members, it’s good to close the loop on this one and celebrate getting into the finalists: out of 400 applicants in total, the UiPath Community was a finalist on multiple categories (5 in total) ranking us among the best communities worldwide. We hope you continue to feel good among the top 3. In the end, we did not manage to get more trophies back to you, but our amazing community manager @DeaTo indeed got one of the best trophies there: Best Community Professional…

This post made by @balupad14 received 2 likes!

UiPath Assistant for macOS

Superb @ElenaBuchir

This post made by @jhonson48 received 2 likes!

Monthly Forum rewards - December 2021

Congratulations to all the winners. All the best

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Why Form Activity Not Working Properly?

do not use “Agree” on the cases remove the "

This solution provided by @Yoichi received 2 likes!

Remove duplicate based on a condition

Hi, Can you try the following sample? [img20220125-8] dt = dt.AsEnumerable.GroupBy(Function(r) r("A").ToString).Select(Function(g) g.First).CopyToDataTable() Sampe20220125-5.zip (8.7 KB) Or if you need to keep the oldest row, the following is better. dt = dt.AsEnumerable.GroupBy(Function(r) r("A").ToString).Select(Function(g) g.OrderBy(Function(r) DateTime.Parse(r("C").ToString)).First).CopyToDataTable() Regards,

This solution provided by @Palaniyappan received 2 likes!

Activity to be used for Loading Page

Fine Hope the below steps would help you resolve this Usually we increase the timeout property like 60000 or 80000 but at times page might take more time than that So I would suggest to go with one of your already tried method but with small changes Use a RETRY SCOPE activity and inside the action block have a simple log message like this “Waiting for the page to load” While in ACTION block use a ELEMENT EXISTS activity Set the property as below Timeout - 60000 WaitForReady - C…

---

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 January 2022

Top 3 Topics with Most Views

Http request set Variable made by @FingFong with 44 views.

Need help in getting calculated values in a data table column without looping and grouping based on another column made by @sharazkm33 with 43 views.

Cron, two different hours on the same day? made by @Aguirre with 43 views.

Top 3 Topics with Most Replies

Http request set Variable made by @FingFong with 15 replies.

フォルダ名に変数をいれたい made by @YYYYYYY with 12 replies.

Merge 3 datatables with the same column name into one with different column names made by @RaduNRV with 9 replies.

Top 3 Users Who Posted The Most

@ppr made 24 posts!

@Yoichi made 23 posts!

@Nithinkrishna made 17 posts!

Top 3 Most Liked Posts

This post made by @guenter.schramm received 3 likes!

Execute database query but don't wait for the results

Hi, I solved this in a different way: I’ve created an Elastic Job Agent (free Azure feature). That agent has a job configured with excutes my stored procedure. The uipath robot is no longer calling "exec " and then waits till it’s finished (20-25min later). Instead it now calls "exec " which immediately returns and the process resumes and finishes without a 20-25min waiting period. The elastic job agent is actually starting the job almost immediately so I’m not losing any time here.

This post made by @Yoichi received 2 likes!

Convert Datarow into list of datarow

Hi, Do you mean add DataRow instance to List of DataRow using Assing activity? If so, can you try the following? listDataRow = listDataRow.Concat({dr}).ToList() Regards,

This post made by @ppr received 2 likes!

Convert Datarow into list of datarow

the lazy approach: {YourDataRowVar}.toList()

Top 3 Most Liked Solutions

This solution provided by @guenter.schramm received 3 likes!

Execute database query but don't wait for the results

Hi, I solved this in a different way: I’ve created an Elastic Job Agent (free Azure feature). That agent has a job configured with excutes my stored procedure. The uipath robot is no longer calling "exec " and then waits till it’s finished (20-25min later). Instead it now calls "exec " which immediately returns and the process resumes and finishes without a 20-25min waiting period. The elastic job agent is actually starting the job almost immediately so I’m not losing any time here.

This solution provided by @Nithinkrishna received 1 likes!

Convert Datarow into list of datarow

Hey @Doonline, Kindly find the snippet below. list_DR = new List(Of DataRow)({ DR }) Hope this helps. Thanks #nK

This solution provided by @codemonkee received 1 likes!

Apollo Orchestrator

You cannot initiate an Process from Orchestrator for an Attended Robot. This was restrcited a few versions ago as it would create a risk and potential inconvenience for end users. Process on an attended Robot are invoked directly from Assistant. If you want/need to kick off a process from Orchestrator on the same User/Machine that you are using, you need to also configure your user’s robot with an Unattended Runtime/Robot Credentials in the User’s Profile.

---

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 January 2022

Top 3 Topics with Most Views

Problem with UiPath Studio Interface made by @Subhrapratim_De with 47 views.

How to handle SAP automation freeze and robot freeze made by @anto.santhosh with 44 views.

【UiPathアカデミー】1月分新規コースのお知らせ made by @yuko.tanaka with 39 views.

Top 3 Topics with Most Replies

Excelの指定の項目ごと異なる動作をしたい。 made by @YYYYYYY with 22 replies.

How to handle SAP automation freeze and robot freeze made by @anto.santhosh with 19 replies.

I had one Queue in QA folder and i have access to that folder . while i use get transaction item its throwing error made by @MitheshBolla with 13 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 62 posts!

@Gokul001 made 29 posts!

@ppr made 21 posts!

Top 3 Most Liked Posts

This post made by @gdesouter received 2 likes!

UiPath Integration Service General Availability Release is Now Available!

Hey Steffen - we are working on bringing event filters into the Integration Service as part of our next major release (April/May). This will allow kicking off your process based on any criteria we have available and avoid the need to build this logic in your process itself. Stay tuned!

This post made by @Bas received 1 likes!

CI/CD in the context of RPA

Thanks for the swift response @warren_lee I will contact UIPath and once I have a solution I will share it here.

This post made by @anet received 1 likes!

Restrict user access to view tenants and users

Hello all, Was this solved? I am in shock seeing that any user can see all the tenants, all the options in the left bar, any single option in automation Cloud or Hub. I would like that users can see only the areas/sections where they have access and not the whole platform. Thanks.

Top 3 Most Liked Solutions

This solution provided by @Shikhar_Tandon received 1 likes!

Edit LINQ

Hi @fairymemay , Try this - InputDT.AsEnumerable.Where(Function(x)x(“Status (1)”).ToString.ToLower.Equals(“complete”) and Cint(x(“Count”)) >= 15 and String.IsNullOrEmpty(“Chk Dup”).ToString and DateTime.ParseExact(x(“Issue Date”).ToString.Trim,“yyyyMMdd”,System.Globalization.CultureInfo.InvariantCulture).AddYears(-543)<= ApproveDate andAlso String.IsNullOrWhiteSpace(x(“Status”).ToString)).ToArray Thanks

This solution provided by @StefanSchnell received 1 likes!

Inject .Net Code Error

@kevin.moore Hello Kevin, I have never used this activity before. This activity “Injects .NET code into the main UI thread of the target application. Intended for usage with .NET UI applications that do not expose traditional automation technologies or cannot be correctly targeted by traditional means”, as the documentation says. In my opinion really only for special use cases to apply. I changed your code a little bit: public class Class1 { public static object testMethod() …

This solution provided by @liu_shubin received 1 likes!

Remove data column more than 1 column name?

There are many ways to remove columns from data table. One of the methods is using activity “Filter Data Table” to remove specified columns. You can refer to the screenshot below. [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 | 28 January 2022

Top 3 Topics with Most Views

Initializing empty datarow made by @Doonline with 42 views.

Which activity packages do you prefer? made by @tainan.ramos with 40 views.

How to update column's value in datatable with LINQ? made by @111962 with 39 views.

Top 3 Topics with Most Replies

How to update column's value in datatable with LINQ? made by @111962 with 21 replies.

How to match the data from 2 different excel worksheets? made by @kit2815 with 17 replies.

I am unable to deserlize data which i got from get trasaction item in C#, can any one help made by @MitheshBolla with 14 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 43 posts!

@Palaniyappan made 36 posts!

@ppr made 29 posts!

Top 3 Most Liked Posts

This post made by @lukasziebold received 2 likes!

Task Capture 2022.1 Preview Release

Hi, looks great! BPMN, Click-documentation and PDD with one tool?! You’re nailing it Are we able to link Sub-Process elements to their own Sub-Process diagrams like in other BPMN tools?

This post made by @Lucas.Pimenta received 2 likes!

Which activity packages do you prefer?

I’m curious to know the results

This post made by @111962 received 2 likes!

How to update column's value in datatable with LINQ?

I resolved this error with the method you taught me. Thank you very much!!! [image]

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

A string question

[grafik] StrConv(“MARIO ROSSI”, VbStrConv.ProperCase) “Mario Rossi”

This solution provided by @Yoichi received 1 likes!

How to update column's value in datatable with LINQ?

Hi, Can you try the following expression using Assign activity? dt = dt.AsEnumerable.Select(Function(r) dt.Clone.LoadDataRow({r(0),r(1).ToString.Replace(",","、"),r(2),r(3),r(4),r(5),r(6)},False)).CopyToDataTable() Please replace index number to column name for readability, if the above works. Regards,

This solution provided by @Sudharsan_Ka received 1 likes!

How to delete datarow where Column Value is equal to a string. Inside a for each loop

HI @Archie you can try with Filter Datatable Activity [image] Regards Sudharsan

---

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 January 2022

Top 3 Topics with Most Views

Condition in if error? made by @fairymemay with 54 views.

How to replace particular word from string in excel without using For each made by @NervousTuber with 46 views.

Write a formula using RPA to refer to another sheet if match the Column is the same then add? made by @xxGoRpa with 45 views.

Top 3 Topics with Most Replies

Condition in if error? made by @fairymemay with 27 replies.

Issue on using type info into a Web Calendar made by @Jim_Yang_1117 with 14 replies.

I want to check only starting words matching with keywords made by @Mansi_Mhatre with 12 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 33 posts!

@fairymemay made 15 posts!

@NervousTuber made 13 posts!

Top 3 Most Liked Posts

This post made by @Arun_Thimmaiah received 2 likes!

Submit your use case to earn a 50% discount on advanced certification voucher

Thanks @Vibhor.Shrivastava @Oana_Chicioroaga @loginerror for the opportunity and happy to support Uipath Community , I have received 50% discount voucher. Keep encouraging and keep growing.

This post made by @Nithinkrishna received 2 likes!

Condition in if error?

Cool @kirankumar.mahanthi1 Very thanks for that prompt help. @fairymemay, Kindly check please… Thanks #nK

This post made by @kirankumar.mahanthi1 received 2 likes!

Condition in if error?

For me perfectly working fine. please check the suggestion from Nitin @Nithinkrishna [image]

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Condition in if error?

Kindly correct the Address2 spelling in the input sheet. For the data count you mentioned, is it input sheet data or the other sheet…? Hopefully that shouldn’t be an issue… Thanks #nK

This solution provided by @Nithinkrishna received 1 likes!

How can we build an API request to kill the running process in the Orchestrator?

Hey @sandeep_thota Here you go… [IMG_20220129_135802] You can access this from your swagger for ref <Orch Url>/Swagger Hope this helps. Thanks #nK

This solution provided by @Nithinkrishna received 1 likes!

I had my output as string and i want to add to dictonary (string ,object). But getting object reference not set

Hey @MitheshBolla For C#, new Dictionary<String,Object>() Please make sure you do the same, n should be small in new. Thanks #nK

---

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 January 2022

Top 3 Topics with Most Views

How to manipulate a row item in a data table and "update" the data table made by @Botter with 49 views.

Pass variable to linq? made by @fairymemay with 38 views.

I had a variable of type JObject which contains id and its value,name and its value and address and its value. , i need to get Name . i am getting error if i use this DruidConfig["Name"].ToString() made by @MitheshBolla with 38 views.

Top 3 Topics with Most Replies

Write range will write extra column row? made by @xxGoRpa with 10 replies.

System.Text.RegularExpressions.Regex.Replace(new_String.Substring(var_Start_Index, var_End_Index - var_Start_Index), @"[\s]{3,}", "|" made by @Rateb_Thor with 10 replies.

How to manipulate a row item in a data table and "update" the data table made by @Botter with 10 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 25 posts!

@Nithinkrishna made 21 posts!

@Yoichi made 11 posts!

Top 3 Most Liked Posts

This post made by @fairymemay received 2 likes!

Pass variable to linq?

Now I use linq as below. [image] But I want change from text Voucher to variable in TypeVoucher (voucher,central) [image] Please guide me about it.

This post made by @Nithinkrishna received 2 likes!

Pass variable to linq?

Hey @fairymemay Kindly check this now please… It was due to a bracket mismatch. OutputDT.AsEnumerable.Where(Function(x) _ TypeVoucher.Contains(x("Premium").ToString) AndAlso x("Type Special").ToString.Equals("Yes") OrElse (x("Premium").ToString.Equals("เงินคืนเข้าบัญชีเงินฝาก SCB") Or x("Premium").ToString.Equals("เงินคืนเข้าบัตรเครดิต SCB")) AndAlso x("Type Special").ToString.Equals("Yes") AndAlso String.IsNullOrWhiteSpace(x("Account No").ToString)).ToArray Thanks #nK

This post made by @ppr received 2 likes!

Deleting middle rows in dataTable

Give a try on following: Assign Activity LHS: dtReduced | DataType: DataTable RHS: dt.AsEnumerable.Where(Function (x,i) i < 5 or i > dt.Rows.Count - 6).CopyToDataTable dt = your Origin DataTableVar

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 2 likes!

Pass variable to linq?

Hey @fairymemay Kindly check this now please… It was due to a bracket mismatch. OutputDT.AsEnumerable.Where(Function(x) _ TypeVoucher.Contains(x("Premium").ToString) AndAlso x("Type Special").ToString.Equals("Yes") OrElse (x("Premium").ToString.Equals("เงินคืนเข้าบัญชีเงินฝาก SCB") Or x("Premium").ToString.Equals("เงินคืนเข้าบัตรเครดิต SCB")) AndAlso x("Type Special").ToString.Equals("Yes") AndAlso String.IsNullOrWhiteSpace(x("Account No").ToString)).ToArray Thanks #nK

This solution provided by @ppr received 1 likes!

Deleting middle rows in dataTable

it about LINQ we used an indexed where statement and i is representing the poisition/row index from the processed collection of datarows

This solution provided by @Nithinkrishna received 1 likes!

Replace text in excel?

Hey @fairymemay Here you go… nmnithinkrishna_DTColBulkUpdate.zip (13.5 KB) Hope this helps Thanks #nK

---

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 January 2022

Top 3 Topics with Most Views

All about Datetime - UiPath made by @Palaniyappan with 50 views.

UiPath Queue Triggers - InProgress item made by @MohammadAljaafreh with 46 views.

How can I click on a button without getting detected by a web page? made by @lsl with 45 views.

Top 3 Topics with Most Replies

How to Add the Data in Ascending order made by @anurita.mishra with 17 replies.

Delete Excel rows with specific value made by @Ritika_Singh with 15 replies.

Can't Extract Text made by @raja_ias with 14 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 42 posts!

@Nithinkrishna made 39 posts!

@Gokul001 made 15 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 12 likes!

All about Datetime - UiPath

Hi All, My recent post on datatable [All About Datatable- UiPath] (All about Datatable - UiPath) was received well in forum with great feedbacks and many suggested to provide some tutorial on topics which are discussed often in our forum In regards to that I would like to share the commonly used expression for DATETIME conversion Let’s get started one by one 1. Get Current Date in string format Datetime.Now.ToString() (Output - string type - “dd/MM/yyyy hh:mm:ss”) **To get only current da…

This post made by @pikorpa received 4 likes!

I have problem with IMAP

Hey @rpa6 , for gmail you have to enable IMAP on your account settings: Sign in to your Gmail account by using a browser that is supported (Google Chrome, Firefox, Internet Explorer, or Safari). Choose or click the gear icon ([Choose the Gmail gear icon.]) on the top right. Choose Settings > Forwarding and POP/IMAP . Select Enable IMAP , and then choose Save Changes . Don’t forget to switch on the ‘less secure apps’ option: Click Security > Basic settings . Under Less secure apps, select G…

This post made by @AMALRAJ received 3 likes!

Send smtp mail message unknown host

Hi @Raul_Palma Change your smtp host at the right side of the properties panel, there is some spelling mistake at the first screenshot you write it as smpt instead of smtp try with @Palaniyappan feedback also. Make a try may be its work. Happy mail automation. Regards AMAL

Top 3 Most Liked Solutions

This solution provided by @pikorpa received 4 likes!

I have problem with IMAP

Hey @rpa6 , for gmail you have to enable IMAP on your account settings: Sign in to your Gmail account by using a browser that is supported (Google Chrome, Firefox, Internet Explorer, or Safari). Choose or click the gear icon ([Choose the Gmail gear icon.]) on the top right. Choose Settings > Forwarding and POP/IMAP . Select Enable IMAP , and then choose Save Changes . Don’t forget to switch on the ‘less secure apps’ option: Click Security > Basic settings . Under Less secure apps, select G…

This solution provided by @AMALRAJ received 3 likes!

Send smtp mail message unknown host

Hi @Raul_Palma Change your smtp host at the right side of the properties panel, there is some spelling mistake at the first screenshot you write it as smpt instead of smtp try with @Palaniyappan feedback also. Make a try may be its work. Happy mail automation. Regards AMAL

This solution provided by @Palaniyappan received 2 likes!

Read data from another column

Then mention like this str_monthnumber = Convert.ToInt32(Datetime.ParseExact(Strinput.ToString, “MMM”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MM”)).ToString Cheers @fairymemay

[Previous Month] Top 3 Users with the most likes on their solutions

@Yoichi received 55 likes for their solutions!

@ppr received 40 likes for their solutions!

@pikorpa received 26 likes for their solutions!

---

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 February 2022

Top 3 Topics with Most Views

Convert txt to excel? made by @fairymemay with 54 views.

How to Add condition (LINQ) made by @fairymemay with 48 views.

開いているウェブページのURLを取得したい made by @HANAKO with 45 views.

Top 3 Topics with Most Replies

How to Add condition (LINQ) made by @fairymemay with 18 replies.

Convert txt to excel? made by @fairymemay with 15 replies.

String Not Recognized as a Valid Date Time made by @Dr_Raza_Abidi_PhD with 14 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 41 posts!

@Nithinkrishna made 26 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 5 likes!

How to use a Windows Forms UI

In some cases, with attended bots, it could be necessary to input data into the automation workflow. As long as we work in desktop environments, we have everything aboard to enable such inputs on a simple way. In this post I describe an example of how to use Windows Forms UI. Windows Forms UI DLL Windows Forms is a UI framework to create rich desktop client apps for Windows. We can use Windows Forms for the compatibility modes Windows - Legacy (dotNET Framework 4.61 - x86 architecture) and Wind…

This post made by @Oana_Chicioroaga received 2 likes!

Submit your use case to earn a 50% discount on advanced certification voucher

Hello community fellows, Thank you all for the amazing contribution! Our use case repository has been significantly enriched. We appreciate you for joining us in this learning and sharing campaign. Now we are closing it as the first 50 approved use cases are achieved! If your use case was added after that deadline, you won’t qualify for voucher. In any case, we do encourage you to share your knowledge and make your voice known. Enjoy your learning journey and use the vouchers until May 2022. …

This post made by @ppr received 2 likes!

Counting the full KeyValuePair in transaction item variable

TransactionItem.SpecificContent.Where(Function (kvp) isNothing(kvp.Value) OrElse String.IsNullOrEmpty(kvp.Value.toString.Trim)).Count

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Counting the full KeyValuePair in transaction item variable

TransactionItem.SpecificContent.Where(Function (kvp) isNothing(kvp.Value) OrElse String.IsNullOrEmpty(kvp.Value.toString.Trim)).Count

This solution provided by @Gokul001 received 2 likes!

How to Convert this string to date type

Hi @Gopikrishna_S Try this below expression DateTime.ParseExact(“Input string”,(“ddMMyyyy”),Globalization.CultureInfo.InvariantCulture).ToString(“ddMMyyyy”) ddMMyyyy - Your conversion format. For more info refer the post Hope it will works Regards Gokul

This solution provided by @StefanSchnell received 1 likes!

Where to add license information to nupkg template

@nicortak Hello Nico, to add license URL and other stuff very comfortable you can use NuGet Package Explorer, a fantastic tool. [image] Best regards Stefan

---

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 February 2022

Top 3 Topics with Most Views

How to extract using both substring and split method made by @ydash999 with 43 views.

Write range date formatting made by @kl_kl with 41 views.

Robot Names made by @Balan with 41 views.

Top 3 Topics with Most Replies

Write range date formatting made by @kl_kl with 15 replies.

How to get sheets from Excel or check if sheet name exist made by @vlast with 14 replies.

Robot Names made by @Balan with 13 replies.

Top 3 Users Who Posted The Most

@ppr made 22 posts!

@Gokul001 made 19 posts!

@supermanPunch made 18 posts!

Top 3 Most Liked Posts

This post made by @Sudharsan_Ka received 7 likes!

Monthly Forum rewards - January 2022

Congratulation All the winners

This post made by @Palaniyappan received 7 likes!

Monthly Forum rewards - January 2022

Congratulations everyone And thanks for this initiative Awaiting to share and see great ideas Cheers

This post made by @Gokul001 received 6 likes!

Monthly Forum rewards - January 2022

Congratulation to all the reward winners

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 3 likes!

How can I use if condition for perticular browser window?

HIb @Jalan_Pranav For getting an bool Value. you can use “Element Exist Activity” Indicated the appropriate browser → Create an output variable in the properties panel (BoolBrowser) You can use “IF condition” → BoolBrowser Then → “Kill Process” [image] Hope it will help you Regards Gokul

This solution provided by @supermanPunch received 2 likes!

How to add all key value of a dictionary

Hi @ramadhani.sheffi , For a more dynamic approach to Sum up all of the Values of the Dictionary (Provided all values are numbers), we can use the below Expression : myDict = new Dictionary(of String, String) From {{"A","10"},{"B","20"}, {"C", "30"},{"D","40"}} TotalSum = myDict.Values.Sum(Function(x)CDbl(x)) Where TotalSum is of the data Type Double, myDict is of Data Type Dictionary(Of String,String)

This solution provided by @supermanPunch received 2 likes!

String Not Recognized as a Valid Date Time

Hi @Dr_Raza_Abidi_PhD , As per the Data that was Provided, the dates read by the Read Range activity is converted into an OADate representation and Hence we were not able to convert the Date properly since it is a Double value. By Debugging we can get to know the value of the Date at Run Time. [image] For Handling such changes in datetime values, we could use a Try Catch on the First Conversion in Assign and then in the Catch Block we could use the Conversion from OADate as Shown in the Imag…

---

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.