Forum Engagement Daily Reports

[system]

Daily Forum Report | 23 July 2023

Top 3 Topics with Most Views

ElementExists timed out made by @rpn_mail with 43 views.

How to fasten vlookup made by @Nur_Amin with 42 views.

Cant find the Inject JS Script Activity made by @Hugen_Dugen with 42 views.

Top 3 Topics with Most Replies

Practice - Book Sales Report made by @kimberly.lin with 27 replies.

How to fasten vlookup made by @Nur_Amin with 25 replies.

Cant find the Inject JS Script Activity made by @Hugen_Dugen with 16 replies.

Top 3 Users Who Posted The Most

@lrtetala made 26 posts!

@Anil_G made 26 posts!

@Parvathy made 11 posts!

Top 3 Most Liked Posts

This post made by @lrtetala received 1 likes!

Windows Exploeer: Get file path, file name and creation date from folder and all subfolders into an Excelfie

@hagen [image] [image] [image] Is it okay

This post made by @vrdabberu received 1 likes!

Can someone explain how to do lookup from one excel to another excel

@madhav_ravi Please refer the below attached xaml file it might help you. sample.xaml (67.3 KB) test (2).xlsx (10.4 KB) Hope it works!!

This post made by @Vikas_M received 1 likes!

Add Headers of Data Table in HTML Editor Send Email Activity (Adding DataTable in Email Body)

@marina.dutta While writing the data table to Excel u have to check the add headers property And while reading it from excel uncheck add headers, and check the Preserve Format Property And then pass that DT variable to HTML content , You will get headers in your output [image] [image] bELOW IS THE OUTPUT [image] Note: Dont forget to Map the New DT in your HTML content Happy Automation!

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Windows Exploeer: Get file path, file name and creation date from folder and all subfolders into an Excelfie

@hagen [image] [image] [image] Is it okay

This solution provided by @vrdabberu received 1 likes!

Can someone explain how to do lookup from one excel to another excel

@madhav_ravi Please refer the below attached xaml file it might help you. sample.xaml (67.3 KB) test (2).xlsx (10.4 KB) Hope it works!!

---

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 July 2023

Top 3 Topics with Most Views

Edge Extension not working - Could not communicate made by @Daniel_H-E with 251 views.

The robots couldn't communicate with Private mode of MS Edge browser made by @Mohammed_Bakr with 98 views.

🎯 UiPath Tutorial: Using the Pick Activity made by @ManFrancko with 53 views.

Top 3 Topics with Most Replies

3 Excel Reading made by @Gokul_Murali with 43 replies.

Unable to read unread mail made by @Mathkar_kunal with 25 replies.

Write Cell: Object reference not set to an instance of an object. Error made by @HENG_JUN_YING_AARON with 23 replies.

Top 3 Users Who Posted The Most

@mkankatala made 68 posts!

@Anil_G made 57 posts!

@lrtetala made 52 posts!

Top 3 Most Liked Posts

This post made by @Vikas_M received 3 likes!

Managing Data Table columns

Hey @Luis_Fernando , If you want to add only specified columns to Orchestrator then follow below steps Input datatable snapshot [image] Filtered Datatable snapshot (I removed AGE and SALARY columns) [image] Below is the Output of Filter Datatable [image] After filtering you can add the filtered Datatable to "Bulk Add Queue Items " Below is the Workflow Snapshot [image] Hope it helps You! Happy Automation!

This post made by @Mohammed_Bakr received 2 likes!

The robots couldn't communicate with Private mode of MS Edge browser

Hi after the last update of MS Edge, there is an issue with the extension of UiPath… the extension is installed and enabled but still, the robot is not able to communicate with the browser in Private mode… I tried to: disable and enable the extension. reinstall the extensions uninstall and reinstall the studio but unfortunately same issue … after a lot of investigation, I found that when the robot is opening Edge in normal mode there is an application called (Chrome Native Messaging Hos…

This post made by @Quenton_Wayne_Rebello received 2 likes!

FIlling excel using LINQ

Dim previousColumn7 As String = "" Dim previousColumn9 As String = "" For Each row As DataRow In dataTable.Rows Dim column7Value As String = If(String.IsNullOrEmpty(row("Column7").ToString()), previousColumn7, row("Column7").ToString()) Dim column9Value As String = If(String.IsNullOrEmpty(row("Column9").ToString()), previousColumn9, row("Column9").ToString()) row("Column7") = column7Value row("Column9") = column9Value previousColumn7 = column7Value previousColumn9 = col…

Top 3 Most Liked Solutions

This solution provided by @Quenton_Wayne_Rebello received 2 likes!

FIlling excel using LINQ

Dim previousColumn7 As String = "" Dim previousColumn9 As String = "" For Each row As DataRow In dataTable.Rows Dim column7Value As String = If(String.IsNullOrEmpty(row("Column7").ToString()), previousColumn7, row("Column7").ToString()) Dim column9Value As String = If(String.IsNullOrEmpty(row("Column9").ToString()), previousColumn9, row("Column9").ToString()) row("Column7") = column7Value row("Column9") = column9Value previousColumn7 = column7Value previousColumn9 = col…

This solution provided by @pravallikapaluri received 1 likes!

Activities in version 2023

Hi @Pratik_Chaudhari1 Install the UiPath.excel.Activities [image] Hope it helps!!

This solution provided by @Yoichi received 1 likes!

Regex match question

Hi, According to your pattern, you want to match not only MM/dd/yyyy style but also MMMM/dd/yyyy style (such as July 25,2023) don’t you? If so, the following pattern will work. System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Statement\s+(Issued\s+)?)(Jan(uary)?|Feb(ruary)?|Mar(ch)?|Apr(il)?|May|Jun(e)?|Jul(y)?|Aug(ust)?|Sep(tember)?|Oct(ober)?|Nov(ember)?|Dec(ember)?)\s?\d+,?\d+|(\d{1,2}/\d{1,2}/\d{2,4}|\d{1,2}-(Jan(uary)?|Feb(ruary)?|Mar(ch)?|Apr(il)?|May|Jun(e)?|Jul(y)?|Aug(ust)?…

---

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 July 2023

Top 3 Topics with Most Views

MV3 browser extensions are broken when starting Edge v115 with InPrivate option made by @Luiza_Surdu-Bob with 131 views.

Edge extension not working in Incognito mode made by @Oana_Georgiana_Vasile with 66 views.

Error when Open Browser in private : Cannot communicate with the browser, please check the UiPath extension made by @marc.loppion with 50 views.

Top 3 Topics with Most Replies

Excel Extension made by @Kuldeep_Pandey with 27 replies.

Delete Sheet Item made by @Shivam_Rana with 25 replies.

How to store the extracted tables data in an excel sheet made by @raju_alakuntla with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 62 posts!

@lrtetala made 50 posts!

@mkankatala made 45 posts!

Top 3 Most Liked Posts

This post made by @Luiza_Surdu-Bob received 3 likes!

MV3 browser extensions are broken when starting Edge v115 with InPrivate option

The latest Microsoft Edge browser update to version 115.0.1901.183 introduced a bug regarding the initialization of MV3 extensions for Edge started “InPrivate” mode. This issue affects all MV3 extensions, not just the UiPath Extension for Microsoft Edge. We have reported this issue to Microsoft as an Edge bug and are waiting for their review. Observed behavior When Microsoft Edge browser is started using: the Open Browser activity with Options → Private property set to True or the Use Appl…

This post made by @RAKESH_KUMAR_BEHERA received 2 likes!

Developing a Star Rating Design using UiPath Apps

[Developing a Star Rating Design using UiPath Apps]

This post made by @Manish540 received 2 likes!

How to use Success Factor Activities

Hi @Deeipauk , Check this below link, https://docs.uipath.com/activities/other/latest/legacy-integrations/successfactors-scope Hope this might help you

Top 3 Most Liked Solutions

This solution provided by @MohammedKher_Kibabi received 1 likes!

Can't open UiPath Orchestrator - it's hanging and entering into redirect loop

Welcome @Filipe_Vitorino1 I resolved this issue by synchronize the PC Time from the control panel → time zone settings

This solution provided by @lrtetala received 1 likes!

Linq for joining 2 columns

Hi @yashchoursia25 Please try this (From d In InputFile.AsEnumerable() Group d By k1 = d(6).ToString().Trim(), k2 = d(8).ToString().Trim() Into grp = Group Let s13 = String.Join(",", grp.Select(Function(x) x(13).ToString())) Let s12 = String.Join(",", grp.Select(Function(x) x(12).ToString())) Let ra = New Object() {k1, k2, s12, s13} Select joiningDT.Rows.Add(ra)).CopyToDataTable() Regards,

This solution provided by @vrdabberu received 1 likes!

Checking Excel calculation is complete before extracting data

@clark.coleman Use the “Excel Application Scope” activity to open the Excel file and perform operations on it. After pressing F9 (manually or programmatically), use the “Send Hotkey” activity to send the F9 key to Excel. This will trigger the recalculation of the spreadsheet. Use the “Delay” activity to introduce a wait time after sending the F9 key. The duration of the delay depends on the complexity of your spreadsheet and the time it takes to finish calculating. You may need to experiment …

---

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 July 2023

Top 3 Topics with Most Views

Important updates in Orchestrator roles and permissions made by @sebastian.ungureanu with 415 views.

How to get the date from a specific day till today? made by @connect360 with 49 views.

Comparing Excel Row Values made by @marina.dutta with 42 views.

Top 3 Topics with Most Replies

Group by column and add other columns accordingly made by @tharaninatarajan1901 with 38 replies.

How to get the date from a specific day till today? made by @connect360 with 27 replies.

Need only classic activities made by @T_Y_Raju with 26 replies.

Top 3 Users Who Posted The Most

@mkankatala made 55 posts!

@Anil_G made 51 posts!

@lrtetala made 49 posts!

Top 3 Most Liked Posts

This post made by @sebastian.ungureanu received 6 likes!

Important updates in Orchestrator roles and permissions

Hello, UiPath community! We’ve been collecting your feedback around setting up roles and permissions in Orchestrator, and are pleased to announce a few upcoming improvements in the initial setup experience, as well as some important changes to the Automation User role. When creating a new tenant, you will notice a better separation of group roles by default. The changes to the default seeding are as follows: Updated group: Automation Users will no longer be able to access the Orchestrator UI…

This post made by @rameshrangaraj1970 received 2 likes!

How do I simulate the keystrokes of keeping the "SHIFT" button pressed and simultaneously pressing "TAB"?

Thanks much All for your very quick reply. My problem got solved. Thanks once again!

This post made by @Yoichi received 2 likes!

How to get 2 words in both sides of some word

How about the following? System.Text.RegularExpressions.Regex.Replace(yourString,"^[\s\S]*\s+(\w+)\W+овогтой\W+(\w+)[\s\S]*$","$1 $2") Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to get 2 words in both sides of some word

How about the following? System.Text.RegularExpressions.Regex.Replace(yourString,"^[\s\S]*\s+(\w+)\W+овогтой\W+(\w+)[\s\S]*$","$1 $2") Regards,

This solution provided by @Yoichi received 2 likes!

Get text gives me thousand separator with coma and I need it with dot

HI, How about using Replace method as the following? PR.Replace(",","_").Replace(".",",").Replace("_",".") This assumes there is no _ in the string. Regards,

This solution provided by @ppr received 1 likes!

In a list of string identify those with 3 out of 4 characters similar to each other

maybe this Quick dirty approach can help: uncommon [grafik] common [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 | 27 July 2023

Top 3 Topics with Most Views

How do I count the number of rows with same variable? made by @helpplease with 58 views.

Column not found made by @helpplease with 53 views.

Different date format made by @helpplease with 53 views.

Top 3 Topics with Most Replies

Compare two sheets and change color in both or any one of sheets made by @Bhushan_Nagaonkar with 30 replies.

How to insert images into excel cells made by @alexis.mendoza with 30 replies.

Need to find index of array value in text file made by @Anil_Rajavarapu with 29 replies.

Top 3 Users Who Posted The Most

@mkankatala made 67 posts!

@lrtetala made 58 posts!

@vrdabberu made 50 posts!

Top 3 Most Liked Posts

This post made by @helpplease received 3 likes!

What exactly are special keys?

Thank you all for the explanations! I really appreciate them

This post made by @brian.oberman received 2 likes!

Change Scheduled Delivery of Reports to be globally and centrally set up and managed

Today, you can schedule delivery of reports via email in Insights. However, ONLY the person/user that set up the schedule and see/change their own schedules. This is a problem. First, if the person that set up the report delivery leaves your organization, you cannot change/update/view the report without UiPath assistance. (Per UiPath documentation: " Schedules are user-specific and can only be viewed by the user that created them in the Schedule/Alert Settings section." Second, it creates th…

This post made by @Felix_Rech1 received 2 likes!

Add Collection argument to 'Add Log fields' Activity

Hey UiPath Team, please consider adding a new input argument to the ‘Add Log Fields’ activity that allows users to hand in a collection Object (dictionary) as an alternative to adding the fields manually one by one, similar to how the ‘Add Queue Item’ activity allows users to supply a variable/argument of type ‘Dictionary(String,Object)’ instead of adding the required fields manually (ItemInformation vs. ItemInformationCollection). This is currently not possible with the ‘Add log Fields’ activ…

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

How to saperate json

@Mathkar_kunal , Apologies as I could not get the separate term intially in your Query. The concentration was more towards the last line of the query. Even for the Expected Results provided by you, we could use the Same Expression : To retrieve results other than 1322 : jArr1 = JArray.FromObject(jArr.Where(Function(x)Not x("testExecKey").toString.Equals("TEST81313-1322"))) To retrieve results with 1322 : jArr2 = JArray.FromObject(jArr.Where(Function(x)x("testExecKey").toString.Equals("TES…

This solution provided by @pravallikapaluri received 1 likes!

Read every PDF files with OCR

Hi @Temuulen_Buyangerel [image] [image] Hope it helps!!

This solution provided by @lrtetala received 1 likes!

Round off to a decimal number

Hi @adishjain Math.Ceiling(Var1 * Math.Pow(10, Round)) / Math.Pow(10, Round) [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 July 2023

Top 3 Topics with Most Views

I tried to open chrome browser but I can't open made by @Krishnendu_Paul with 53 views.

What are the RPA Tools that are getting rapid popularity Recently made by @hikumar with 52 views.

Date and time formate chnaging after reading json and appending to new text file made by @Mathkar_kunal with 50 views.

Top 3 Topics with Most Replies

How to convert to number in excel? made by @Priyesh_Shetty1 with 31 replies.

Excel “printer setup” popup made by @wija with 26 replies.

Date and time formate chnaging after reading json and appending to new text file made by @Mathkar_kunal with 24 replies.

Top 3 Users Who Posted The Most

@mkankatala made 67 posts!

@lrtetala made 60 posts!

@pravallikapaluri made 33 posts!

Top 3 Most Liked Posts

This post made by @hikumar received 6 likes!

What are the RPA Tools that are getting rapid popularity Recently

Give me a list of RPA Tools that are getting rapid popularity recently, that do the robotic process automation work similar to RPA UiPath

This post made by @AndyMenon received 3 likes!

How to Filter Data in Dropdown Lists - UiPath Apps Tutorial Part 01

Hello Community, If you want to know how to build UiPath Apps that lets users filter data in multi-select dropdown lists, then you may find this video interesting. In this session we use a series of multi-select dropdown lists. Setting the filter criteria in the first dropdown results in data being filtered in the second! You will experience how minimal configuration and a bit of practice with UiPath Apps Functions and Expressions can help build powerful features into your Apps! NOTE: If y…

This post made by @Quenton_Wayne_Rebello received 2 likes!

How to add only a particular column using LINQ

(From row in dt.AsEnumerable Select dt.Clone.Rows.Add({row(“ColumnName”)})).CopyToDataTable Then use invoke code and remove unnecessary column names where target object is dt2.Columns and method is RemoveAt [tmp_149e8431-3648-4194-a50b-cfd72af2e226]

Top 3 Most Liked Solutions

This solution provided by @Quenton_Wayne_Rebello received 2 likes!

How to add only a particular column using LINQ

(From row in dt.AsEnumerable Select dt.Clone.Rows.Add({row(“ColumnName”)})).CopyToDataTable Then use invoke code and remove unnecessary column names where target object is dt2.Columns and method is RemoveAt [tmp_149e8431-3648-4194-a50b-cfd72af2e226]

This solution provided by @lrtetala received 1 likes!

Regex matching help

Hi @A_Learner Try this (?<=Last PAY Amount\s)[\s\S]*(?=Adjustments) [image] I hope it helps!!

This solution provided by @wija received 1 likes!

Excel “printer setup” popup

actually i also in the process of trying this solution in this link (possibility 2 section): my excel template that used by my RPA to process excel, is in page-break preview state, i change it to normal preview and save. hope this will also works.

---

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 July 2023

Top 3 Topics with Most Views

Explain transpose table made by @helpplease with 33 views.

Have Question about the Linq and 1 line assign made by @kuku_uu with 31 views.

I want to write in excel from specific cell made by @Bhushan_Nagaonkar with 30 views.

Top 3 Topics with Most Replies

How to use string expressions with Write Range Workbook made by @emir_ozsimsir with 17 replies.

I want to write in excel from specific cell made by @Bhushan_Nagaonkar with 13 replies.

How I can paste the text inside text-inputs instead of typing it? made by @Sami_Rajput with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 38 posts!

@mkankatala made 28 posts!

@Parvathy made 20 posts!

Top 3 Most Liked Posts

This post made by @Pranay_Kumar_Bose received 2 likes!

Raname sheets

@Yoichi @vrdabberu Thanks for the solution. Both the solution are easier to understand and fulfills my requirement, but marking only one as solution for thread closure.

This post made by @Parvathy received 2 likes!

Date time format error

Hi @Harsh_Garg Try this syntax: DateTime.Now.Tostring("dd-MMM-yyyy") The above syntax will print first 3 letters of Month name. Refer the image: [image] DateTime.Now.Tostring("dd-MMMM-yyyy") The above syntax will print with whole Month name. Refer the image: [image] Hope it helps!! Regards,

This post made by @lrtetala received 2 likes!

Issue sorting by time in Excel

Hi @tmcwade12 Use Format Cells activity [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 2 likes!

Issue sorting by time in Excel

Hi @tmcwade12 Use Format Cells activity [image] Regards,

This solution provided by @Parvathy received 1 likes!

Google drive file upload

Hi @Harsh_Garg You may not get videos regarding latest version og Gsuite. By watching below videos you can similarly try with the latest one. [Google Drive automation using UiPath | How to use Google Drive Activities in UiPath?] [UiPath Drive Activities in Google Workspace - Part 1 | Google Workspace Activites |#coderslobby] [UiPath Drive Activities in Google Workspace - Part 2 | Google Workspace Activities | @robobix] Hope it helps!!

This solution provided by @vrdabberu received 1 likes!

Read Range gives only DataTable text as output

@emir_ozsimsir Use the output data table activity and pass the dt variable into that activity and pass the ouput of the output data table activity into the message box [image] [image] Hope it helps!!

---

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 July 2023

Top 3 Topics with Most Views

Take screenshot send mail made by @suraj_gaikwad with 41 views.

Write list of integers into excel horizontally made by @Joecom101 with 31 views.

Vba entry paramyer value for a vba code made by @Demo_User with 31 views.

Top 3 Topics with Most Replies

Reduce Fetched Data after API Input made by @Hugen_Dugen with 30 replies.

Fetching just a particular part of a json row made by @Hugen_Dugen with 26 replies.

Take screenshot send mail made by @suraj_gaikwad with 24 replies.

Top 3 Users Who Posted The Most

@lrtetala made 41 posts!

@Hugen_Dugen made 19 posts!

@Anil_G made 18 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

How to sum and average the whole column

When the localization plays a role (dot is group seperator) we can do Int32.Parse(YourString, System.Globalization.CultureInfo.CreateSpecificCulture("tr-TR")) Double.Parse(YourString, System.Globalization.CultureInfo.CreateSpecificCulture("tr-TR"))

This post made by @Parvathy received 2 likes!

How to Remove a Newline from an Excel cell using UiPath

Hi @tmcwade12 Use “Read Range WorkBook” activity and read the excel and store it in an data table say dtExcel. Use “For Each Row in Data Table” activity to iterate through each row in excel. Use the below two syntax in assign activity: CurrentRow("Departure Time")= CurrentRow("Departure Time").ToString.Replace(vbLf, " ").Replace(vbCr, "") CurrentRow("Arrival Time")= CurrentRow("Arrival Time").ToString.Replace(vbLf, " ").Replace(vbCr, "") Use “Write Range Workbook” activity to write the dat…

This post made by @lrtetala received 2 likes!

How to Remove a Newline from an Excel cell using UiPath

Hi @tmcwade12 Try this Input.ReplaceLineEndings(" ") [image] I hope it helps!!

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 2 likes!

How to Remove a Newline from an Excel cell using UiPath

Hi @tmcwade12 Use “Read Range WorkBook” activity and read the excel and store it in an data table say dtExcel. Use “For Each Row in Data Table” activity to iterate through each row in excel. Use the below two syntax in assign activity: CurrentRow("Departure Time")= CurrentRow("Departure Time").ToString.Replace(vbLf, " ").Replace(vbCr, "") CurrentRow("Arrival Time")= CurrentRow("Arrival Time").ToString.Replace(vbLf, " ").Replace(vbCr, "") Use “Write Range Workbook” activity to write the dat…

This solution provided by @supermanPunch received 1 likes!

Write list of integers into excel horizontally

Hi @Joecom101 , You could also maybe check with the below Expression : DT = (From i In Enumerable.Range(0,CInt(integerList.Count/4)).Select(Function(x)x*4).ToArray Let ra = integerList.Skip(i).Take(4).Cast(Of Object).ToArray Select dt.Clone.Rows.Add(ra)).CopyToDatatable Implementation : [image] Debug Visuals : [image]

This solution provided by @lrtetala received 1 likes!

How to sum and average the whole column

Hi @emir_ozsimsir Please find below xaml for your reference BlankProcess5.zip (164.0 KB) O/P Excel: FORD.xlsx (14.2 KB) I hope it helps!!

---

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 July 2023

Top 3 Topics with Most Views

How do i get specific value from JSON string made by @Goku with 49 views.

Get Sheetname if condition is True made by @WS_Chai with 45 views.

Get dates till today in a provided format and loop through from that list made by @connect360 with 44 views.

Top 3 Topics with Most Replies

Pick the latest date in datatable made by @Nikhil_Katta with 26 replies.

Reading Data Table from website and comparing with an excel doc made by @R_Wolff with 25 replies.

Get Sheetname if condition is True made by @WS_Chai with 23 replies.

Top 3 Users Who Posted The Most

@mkankatala made 60 posts!

@rlgandu made 41 posts!

@lrtetala made 40 posts!

Top 3 Most Liked Posts

This post made by @Mason_Turvey_Silver received 2 likes!

UiPath HyperHack 2023 Finalist Teams

Thanks so much Cristina! I also had two other members in my team @Srinivas k and @Vishal Kalra, id there’s a specific invite or anything make sure they get it as well. Hyped to present our solution Thank you, Mason S Turvey Aerospace Engineer Systems Architect Automation Evangelist https://www.linkedin.com/in/mason-turvey-785180128

This post made by @suraj_gaikwad received 2 likes!

Error while sending hot key in window 7

Issue solved I use just again element exist and I sent again send hot key as a escape if pop up available it’s escape that otherwise process move forward Thank you guys,

This post made by @Salman_Faries received 2 likes!

ShouldMarkJobAsFaulted

Thank you all for explaining this much detailed!

Top 3 Most Liked Solutions

This solution provided by @suraj_gaikwad received 2 likes!

Error while sending hot key in window 7

Issue solved I use just again element exist and I sent again send hot key as a escape if pop up available it’s escape that otherwise process move forward Thank you guys,

This solution provided by @supriya117 received 1 likes!

Perform mathematical calculation on a two Lists

Hi @shikharno.7 Try this: listResult = listActual.Zip(listBudget, Function(a, b) a - b).ToList()

This solution provided by @mkankatala received 1 likes!

Split string into 3 sections

Hi @balt-ochir.g CurrentFile.Name.Split(“-”)(1) When we use split function the output will be stored as a collection. We can use the index to get the value what we want. Check the below one for better understanding. [image] Hope it helps!!

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

@Yoichi received 54 likes for their solutions!

@Anil_G received 50 likes for their solutions!

@raja.arslankhan received 31 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 August 2023

Top 3 Topics with Most Views

Role Based Access Control for Document Understanding - coming August 8th made by @alexcabuz with 49 views.

Removed made by @gorby with 45 views.

How can I extract the Dynamic hyperlink text from the Gmail body? made by @chandrakala.productanalys with 42 views.

Top 3 Topics with Most Replies

How can I extract the Dynamic hyperlink text from the Gmail body? made by @chandrakala.productanalys with 55 replies.

How to download files from portal for specific date made by @connect360 with 25 replies.

How to add String to excel sheet made by @mironb with 22 replies.

Top 3 Users Who Posted The Most

@vrdabberu made 41 posts!

@lrtetala made 33 posts!

@mkankatala made 33 posts!

Top 3 Most Liked Posts

This post made by @alexcabuz received 5 likes!

Role Based Access Control for Document Understanding - coming August 8th

Hello all! Role Based Access Control in Document Understanding is finally here! Users in large organizations with complex compliance requirements have been confined to using AI Center to access Document Understanding capabilities due to Document Understanding itself not having Role Based Access Control capabilities. Not anymore! Starting August 8th you will be able to control at a Tenant level and at a Project level who can do what, and most importantly, who can see what data, in the Document …

This post made by @lrtetala received 2 likes!

Reading Data Table from website and comparing with an excel doc

Hi @R_Wolff Please remove double quotes and reassign double quotes

This post made by @esongi_park received 1 likes!

Attended robot , 어텐디드 봇 관련 문의

안녕하세요 attended robot 과 unattended robot 의 차이점이 다양히 있겠지만, 트리거(스케쥴)은 unattended robot 만 가능한데, attended robot 은 해당 pc에서 어시스턴트로 수행가능 한 걸로 알고 있는데, 오케스트레이터를 통해서 job start 도 가능한지 궁금합니다.(예전에 온프레미스 오케스트레이터로는 불가능했습니다.현재 클라우드 오케스트레이터 사용중입니다)

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

Attended robot , 어텐디드 봇 관련 문의

Hi @esongi_park You can trigger both attended and unattended robots. Attended robots will be run in the foreground, Unattended robots will be run in the background. You can run the attended robot from orchestrator from the process tab. Note - While Trigger the attended robot at the trigger time the local machine has to be in the on position, no lock and no shutdown position. Hope it helps!!

This solution provided by @lrtetala received 1 likes!

Type into press enter

@Povilas_Jonikas Try this [image] It is working

This solution provided by @ppr received 1 likes!

Issue while sending string variable with special characters through send secure SMTP mail

We can escape the string option 1: [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 | 02 August 2023

Top 3 Topics with Most Views

Contains is not a member of datatable made by @WS_Chai with 49 views.

I want to remove entire column if balank header or entire column blank then have to remove entire column without knowing the index made by @shaik.muktharvalli1 with 45 views.

How to Remove Blank Lines from a string? made by @Nitesh_Rajput with 40 views.

Top 3 Topics with Most Replies

I want to remove entire column if balank header or entire column blank then have to remove entire column without knowing the index made by @shaik.muktharvalli1 with 26 replies.

The robot is entering the wrong date format made by @sullivanne with 14 replies.

Getting error while using "Type into" activity : Could not find the user-interface (UI) element for this action made by @sid04 with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 44 posts!

@ppr made 35 posts!

@Parvathy made 31 posts!

Top 3 Most Liked Posts

This post made by @Mohammed_Ismail_Rahid received 2 likes!

Find the file in folder

BlankProcess2.zip (2.6 KB) try this…

This post made by @ppr received 2 likes!

Check if Day is between 20th and 5th of any month

one of many options [grafik]

This post made by @miwa_yamamoto received 2 likes!

セレクターへの変数設定について

Yoichi様 ありがとうございます。 レコーディングし直すと、動きました！ 本当にありがとうございました。 初期値が必要である件、初めて知り、大変勉強になりました。

Top 3 Most Liked Solutions

This solution provided by @Vikas_M received 1 likes!

How to swap details

@Kira You can use invoke code activity and then write the below code EmployeeDT.AsEnumerable().ToList.foreach(Sub(row) row(“Gender”)= If((row(“Gender”).tostring = “Male”), “Female”, If((row(“Gender”).tostring = “Female”), “Male”, “”)) End Sub) And pass the datatable as an argument Hope it helps you out

This solution provided by @Yoichi received 1 likes!

セレクターへの変数設定について

こんにちは これは表示されているメッセージがあまり良くないです。 どちらかというと、その変数のデフォルト値が設定されていない（そのために要素検証ができない）意図なので、その変数のデフォルト値（規定値）を設定すると解消すると思います。（あるいは無視しても動作自体には影響ないと思います。） 以下の様に昨年改善要望のトピックは上げたのですが、なかなか修正されません…

This solution provided by @Yoichi received 1 likes!

UI Explorerで色の判別を取得できる方法がわかりません

こんにちは 基本的に色情報をセレクターから直接取得することはできないので、 間接的にCSS等が指定されているCLASSや各HTML要素を特定し、 その差異で識別する方法が考えられます。（属性取得アクティビティで取得します） あるいは要素を画像として取得して、その色情報を取得する方法もあるかもしれませんが、まずは前者かと思います。

---

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 August 2023

Top 3 Topics with Most Views

Announcing the General Availability of Snowflake Connector and Activity Package in Integration Service made by @Samrat_Dutta with 85 views.

Public Preview: Automation Cloud™ Robots – Automated Domain Join made by @Chetak_Shankar with 50 views.

Problem in installing packages made by @Mariam_Saeed with 49 views.

Top 3 Topics with Most Replies

How to Resolve Duplicate elements Found Issue made by @Muhammad_Anas_Baloch with 19 replies.

Faster UiPath Automation made by @Naman_Arora with 19 replies.

I have csv data Want to update value in Name column from Id column made by @Garyy with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 54 posts!

@ppr made 37 posts!

@Nguyen_Van_Luong1 made 37 posts!

Top 3 Most Liked Posts

This post made by @Jon_Smith received 3 likes!

Make automatic detection of TypeArgument in ForEach optional

Can I make a suggestion that with alot of these new stuff you try out, that you typically make it something that can be ‘overidden’ or reverted? I realise that can mean dragging along some legacy stuff (like having classic activities still be a thing even though Modern Design in the intended way to use Ui Automation now) but I think its better at least at the beginning to allow bugs and issues to not be chronic. Certain things I think just make sense to be optional. Like the If layout being ver…

This post made by @Vikas_M received 3 likes!

Monthly Forum Rewards - July 2023

Kudos to everyone!

This post made by @famastyle received 3 likes!

How to scrap multiple pages with many buttons page

I solved thanks to @supriya117 who made for me a while cycle to scrap all 52 pages! thank so much to everyone whom answered with patience to me! @rlgandu @B_H_Akshatha_Pai @mkankatala @raja.arslankhan @Veera_Raj

Top 3 Most Liked Solutions

This solution provided by @nikhil.girish received 2 likes!

How to check if a value is already present as the reference of any of the existing queue item in orchestrator?

Hi @Harsha_Vemula try to pass a date stamp in the queue as a reference with employee Id (append) Once your are passing Datestamp as well with emp I’d as reference, enforce unique reference property…that would solve ur issue

This solution provided by @rlgandu received 1 likes!

Getting error while using "Type into" activity : Could not find the user-interface (UI) element for this action

@sid04 Use Set text activity instead of Type into

This solution provided by @vrdabberu received 1 likes!

Uipath Regex not taking data if it is 1 decimal point

@Irfan_Musa use the below regex expression in Find Matching Pattern activity and then use the for each (?<=\):\s+)\d+.\d+ or use the below syntax in assign activity and use the for each System.Text.RegularExpressions.Regex.Matches(input,"((?<=\):\s+)\d+.\d+)") [image] Hope it helps!!

---

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 August 2023

Top 3 Topics with Most Views

Getting the sheet names in an Excel File dynamically using Modern Excel made by @RobertRussell_Monsalud with 43 views.

How to update last row in first row made by @Garyy with 42 views.

[Q] how can i get the sheet name in Excel (env StudioX not Studio) made by @yuppiensimpson with 40 views.

Top 3 Topics with Most Replies

Regex pattern for pyhton made by @Jhun_III_Daganzo with 14 replies.

Uipath Assistant quiz made by @Latifa with 13 replies.

GetIMAPMailMessagesで添付ファイルが認識できない made by @111790 with 13 replies.

Top 3 Users Who Posted The Most

@mkankatala made 43 posts!

@rlgandu made 42 posts!

@vrdabberu made 30 posts!

Top 3 Most Liked Posts

This post made by @RobertRussell_Monsalud received 4 likes!

Getting the sheet names in an Excel File dynamically using Modern Excel

Hi All @pravallikapaluri @rlgandu @Veera_Raj @vrdabberu @lrtetala @mkankatala @Akshay_B Thank you so much for all of your help and inputs. I really appreciate it. Best regards, Robert

This post made by @tazunnisa.badavide received 3 likes!

Split the string data

[image]

This post made by @Mohammed_Ismail_Rahid received 2 likes!

Linq to filter and add

you can add it to other datatable (From row In in_FailedConversations.AsEnumerable Let conversationID = row(0).ToString Let reminderCount = CInt(row(1).ToString) Let updatedReminderCount = If((conversationID).Equals(ConversationID.toString), (reminderCount + 1).ToString,“”) Select dt.rows.add(reminderCount,updatedRemindercount)).copytodatatable Hope it helps…

Top 3 Most Liked Solutions

This solution provided by @pravallikapaluri received 1 likes!

Getting the sheet names in an Excel File dynamically using Modern Excel

Hi @RobertRussell_Monsalud [image]

This solution provided by @Vikas_M received 1 likes!

How to take screenshot of the whole window without selector?

Hey @yu.li , Try changing the UI framework in selectors panel while indicating, Shortcut to change it is clicking on F4 while indicating [Screenshot 2023-08-04 143731] Hope it helps you!

This solution provided by @Yoichi received 1 likes!

Where is docs about StudioX free for enterprise users?

Hi, How about the following document? Enterprise plan provides with 100 AutomationExpress liceses. https://docs.uipath.com/automation-cloud/automation-cloud/latest/admin-guide/about-licensing#plans-comparison Regards,

---

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 August 2023

Top 3 Topics with Most Views

Select year using regular expression made by @helpplease with 52 views.

How can I extract the complete phone number from the website when it's displayed as '0096279552xxx' initially and only revealed after clicking on it? Any ideas? made by @M.Abd with 35 views.

LINQ query! made by @Rohan_Dhole with 34 views.

Top 3 Topics with Most Replies

Multiple extractions using regex made by @helpplease with 12 replies.

VBA code excel made by @shama93 with 11 replies.

Switch Activity Expression Field made by @Joel_Metheny with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 53 posts!

@mkankatala made 26 posts!

@Parvathy made 9 posts!

Top 3 Most Liked Posts

This post made by @mkankatala received 2 likes!

How can I extract the complete phone number from the website when it's displayed as '0096279552xxx' initially and only revealed after clicking on it? Any ideas?

Hi @M.Abd Use get text activity to get the mobile number and indicate on the element. After indicates open the UI explorer and select the attribute which has the proper mobile number data. After this use get attribute activity and select the attribute in the output of get attribute create a variable which stores the exact data. Hope it helps!!

This post made by @Anil_G received 1 likes!

Select year using regular expression

@helpplease Try this one (?<[A-Za-z]{3} ?)\d{4} [image] cheers

This post made by @bhavana_kolli received 1 likes!

Validation error BC30512:

solved.i used generic value

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Select year using regular expression

@helpplease Try this one (?<[A-Za-z]{3} ?)\d{4} [image] cheers

This solution provided by @shama93 received 1 likes!

While activity

Ok thanq so much… will try

This solution provided by @Anil_G received 1 likes!

Excel COUNT IF Formula

@Omkar_Shete2 Add two columns for each to write the data in excel And then use write cell activity and give the formula as "=If(COUNTIF(A:A,A2)>1,""Duplicate Found"","""")" Then use auto fill range to fill the formula to the bottom Repeat same for the second columns as well Hope this helps Cheers

---

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 August 2023

Top 3 Topics with Most Views

Taking from a different line made by @helpplease with 39 views.

Convert PDF File into Excel from studio made by @Agantuk_Avi with 33 views.

Type into 'INPUT' execution error made by @helpplease with 32 views.

Top 3 Topics with Most Replies

Comapare the File path in a directory with the input value from the Excel row made by @srinusoft37 with 12 replies.

Detection of clicking on an object that is revealed only after standing on it made by @mironb with 12 replies.

Join two JObjects into one JObject made by @Axel_Albert with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 17 posts!

@mkankatala made 12 posts!

@Parvathy made 10 posts!

Top 3 Most Liked Posts

This post made by @NISHITHA received 2 likes!

How to consider both Captital and Small Case

Thanks @mkankatala , @supermanPunch and @Anil_G for your prompt responses

This post made by @Axel_Albert received 1 likes!

Join two JObjects into one JObject

I already have 2 working JObjects. [image] [image] I just want to merge them. jObject1.Merge(jObject2) This was already mentioned in another thread and it doesn’t work, it shows this error. [image]

This post made by @Axel_Albert received 1 likes!

Join two JObjects into one JObject

Hi, I have red a few topics about this and none of them worked for me, so I’m asking it myself. I’m trying to merge/join two JObjects into one. 2 jsons into one json. Anyone knows how to do that?. Thank you.

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

Comapare the File path in a directory with the input value from the Excel row

Hi @srinusoft37 => Take an assign activity and store the File path in a array of string variable called FilePath. Assign -> FilePath = Directory.Getfiles("Folder Path") => Take the Use Excel file activity and give the path of the file. => Inside use Excel file insert the for each Excel row activity. Output - CurrentRow => Inside for each Excel row activity insert the for each to iterate the FilePath (Array of String variable) Output - CurrentItem - Condition -> CurrentItem.Contains(Curre…

---

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 August 2023

Top 3 Topics with Most Views

Generative Extraction & Classification using Document Understanding in cross-platform projects - Public Preview made by @Monica_Secelean with 46 views.

Please let me know the code that can be +1 in the Excel file name! made by @22222222asas with 46 views.

How to use downloaded excel file, copy paste to existing template made by @Muhamad_Izwan_Bin_Hamran with 46 views.

Top 3 Topics with Most Replies

Please let me know the code that can be +1 in the Excel file name! made by @22222222asas with 25 replies.

Unable to read CSV file having > 2 GB Data made by @Nissy_Ruth_Prabhu with 21 replies.

Send calender invite made by @Yogita_Gaikwad1 with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 70 posts!

@vrdabberu made 51 posts!

@rlgandu made 38 posts!

Top 3 Most Liked Posts

This post made by @Monica_Secelean received 8 likes!

Generative Extraction & Classification using Document Understanding in cross-platform projects - Public Preview

Overview Note: As with all preview features in Studio Web, this functionality is only available for Community accounts and not accessible for Enterprise - to try it out without a community account, feel free to download the DocumentUnderstanding.Activities 2.3.1-preview package in Studio. We understand that classifying and extracting information from diverse document types can be challenging and time-consuming, especially when dealing with custom or unstructured use cases. Therefore, we are e…

This post made by @Gokul001 received 3 likes!

Announcing the UiPath Community HyperHack 2023 Winners!

Congratulations to all the winners Regards

This post made by @Quenton_Wayne_Rebello received 3 likes!

I want to keep the time of received mail in Outlook and keep the data in Excel, what should I do?

You can use mailMessage.Date to get date of the mail recieived E.g:- mailMessages.Select(Function(recieved) recieved.DateAsDateTime.ToString("dd/MM/yyyy")).ToArray mailMessages.Select(Function(recieved) recieved.Date.ToString).ToArray These to give an array of dates of the mail recieved, then loop through the array and add to datatable using add data row Activity

Top 3 Most Liked Solutions

This solution provided by @Nguyen_Van_Luong1 received 3 likes!

I want to keep the time of received mail in Outlook and keep the data in Excel, what should I do?

Hi @Famui_Yanisa , You can extract the date from the email as a DateTime variable type with EmailReceiveTime = CDate(mail.Headers(“Date”)), and then simply covert that received date into the time format you need, like this: EmailTime = TimeEmailReceived.ToString(“HH:mm”) … Then add 1 columns "Time received "in Excel to write my output [image] my step: -create file to save mail and time -get list mail -for each mail to get body and time -write cell to write value of body and time to ex…

This solution provided by @vrdabberu received 2 likes!

I want to know how to use "Each For" activity using array variable

@yuppiensimpson [image] Hope it helps!!

This solution provided by @Anil_G received 1 likes!

Join two JObjects into one JObject

@Axel_Albert The merge needs to be used in the invoke code and not in assign activity Pass both the jobjects as in/out arguments to invoke code and then use it inside invoke code…it would work Hope this helps Cheers

---

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 August 2023

Top 3 Topics with Most Views

Having Error in Data Extraction Scope made by @Mariam_Saeed with 69 views.

How to run a python script in UiPath StudioX made by @Afsal_Baaqir_A with 62 views.

Help me to create regex to only get numbers made by @StevenIsRobotOnline with 61 views.

Top 3 Topics with Most Replies

Help me to create regex to only get numbers made by @StevenIsRobotOnline with 35 replies.

Having Error in Data Extraction Scope made by @Mariam_Saeed with 33 replies.

Excel query- if value have more than 100 then pass or fail made by @Jeeru_venkat_Rao with 29 replies.

Top 3 Users Who Posted The Most

@Anil_G made 75 posts!

@mkankatala made 47 posts!

@rlgandu made 45 posts!

Top 3 Most Liked Posts

This post made by @Shiva_Nikhil received 3 likes!

How to load Excel data into a DataTable and calculate row and column sums?

Hi @ram_pv dt.AsEnumerable.Sum(Function(r) r.ItemArray.Sum(Function(a) cint(a.ToString))) gives Total Sum of rows the datatable dt.Columns.Cast(of DataColumn).Select(Function(c) dt.AsEnumerable.Sum(Function(r) Cint(r(c.ToString)))).Toarray Gives the columns count of datatable cheers.

This post made by @anthonyjr received 3 likes!

Regex Alphanumeric and Certain Special Characters

All the solutions presented were working but this kind of solution is what I’m looking for, more dynamic and flexible. Thanks miss @sasi_poosarla and also to sir @tazunnisa.badavide , @rlgandu , @mkankatala and @lrtetala

This post made by @vinjam_likitha received 3 likes!

I need to filter multiple excel columns data

Thank you all for the solutions

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

【質問】ActionCenter タスクの割り当て方法について

Hi @jin.ota You can assign to other If you have admin access - All users, that have the required permissions for the specific folder, can be assigned an action. To assign an Action to another user: Make sure you are in the Manage Actions view. On the Unassigned tab, select the More options [image] menu for the desired action. Select Assign to user. The Assign Action window opens. Select a user from the drop-down list. Hope it helps!!

This solution provided by @rlgandu received 1 likes!

Extract the date

@NA_AN Assign firstDayOfPrevMonth = Now.AddMonths(-1).AddDays(-Now.Day + 1) Assign lastDayOfPrevMonth = Now.AddDays(-Now.Day).AddTicks(-1)

This solution provided by @Yoichi received 1 likes!

DataRow[]変数に値が入っているか判定

地名_1はデータテーブルを結合した際に自動生成される列名です。 （同一データテーブル内に同じ列名が存在できないので） 以下Windowsプロジェクト版ですので一度お試しください。 Sample20230808-5CS.zip (3.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 | 09 August 2023

Top 3 Topics with Most Views

https://forum.uipath.com/t/571347 made by @Bruskie143 with 52 views.

https://forum.uipath.com/t/571276 made by @gorby with 52 views.

https://forum.uipath.com/t/571318 made by @Udiar with 43 views.

Top 3 Topics with Most Replies

https://forum.uipath.com/t/571528 made by @helpplease with 21 replies.

https://forum.uipath.com/t/571347 made by @Bruskie143 with 19 replies.

https://forum.uipath.com/t/571318 made by @Udiar with 19 replies.

Top 3 Users Who Posted The Most

@Nguyen_Van_Luong1 made 49 posts!

@ppr made 41 posts!

@mkankatala made 36 posts!

Top 3 Most Liked Posts

This post made by @tazunnisa.badavide received 2 likes!
https://forum.uipath.com/t/571494/11

This post made by @Mohamed_Rateb received 1 likes!
https://forum.uipath.com/t/571435/1

This post made by @Kartheek_Battu received 1 likes!
https://forum.uipath.com/t/571319/3

Top 3 Most Liked Solutions

This solution provided by @Vikas_M received 1 likes!
https://forum.uipath.com/t/571322/7

This solution provided by @Mariam_Saeed received 1 likes!
https://forum.uipath.com/t/571337/7

This solution provided by @nikhil.girish received 1 likes!
https://forum.uipath.com/t/571298/2

---

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 | 10 August 2023

Top 3 Topics with Most Views

How to Extract XML File with Parsing made by @marina.dutta with 58 views.

How to rename excel/files? made by @Muhamad_Izwan_Bin_Hamran with 51 views.

I want to add symbols in between a string variable made by @Gines_Cirera with 48 views.

Top 3 Topics with Most Replies

How to Extract XML File with Parsing made by @marina.dutta with 27 replies.

Compare 2 columns and Log message made by @Bhushan_Nagaonkar with 24 replies.

Read PDF With OCR (Tesseract OCR) made by @Temuulen_Buyangerel with 19 replies.

Top 3 Users Who Posted The Most

@mkankatala made 41 posts!

@Nguyen_Van_Luong1 made 38 posts!

@ppr made 33 posts!

Top 3 Most Liked Posts

This post made by @Bhushan_Nagaonkar received 2 likes!

Compare 2 columns and Log message

It is working. Thankyou so much. @mkankatala @Shiva_Nikhil @Nguyen_Van_Luong1

This post made by @Bhushan_Nagaonkar received 2 likes!

Compare 2 columns and Log message

Thankyou I wil try it

This post made by @Yazan_Otaibi received 1 likes!

Send attachment by mail

hi all , i want to send one file as attachment by mail using Outlook send mail the attachment option cant let me put the path its required var as ienumerable and this var contains all files in folder and i want a specific file to sent by giving the path

Top 3 Most Liked Solutions

This solution provided by @B_H_Akshatha_Pai received 1 likes!

I want to get any of those value and write only on single cell

After selecting the element Use if condition , if condition satisfies use a gettext activity and then write that text in excel sheet using write cell Regards,

This solution provided by @rlgandu received 1 likes!

Send attachment by mail

@Yazan_Otaibi Add Attachments to IEnumerable of String: Assign: attachments = {“C:\Path\To\file1.txt”, “C:\Path\To\file2.pdf”} In this example, the attachments variable holds a collection of file paths (strings), which are then passed to the “Send Outlook Mail Message” activity as attachments. This allows you to attach specific files to the email without needing to attach all files from a folder.

This solution provided by @mkankatala received 1 likes!

Benifit of using orchestrator queues

Hi @gr82testing Option B is the correct one. => Queues are created in Orchestrator when we are creating we can give the max retry count but we cannot change after the creation of queues. So Option A is incorrect. => we can monitor the status of the queue items in queue tab in Orchestrator. When upload to queue it is in new state. When run by bot it is in process state. If it is success it is in success state, if any exception is occured it will be in retry state. So Option B is Correct one. …

---

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 | 11 August 2023

Top 3 Topics with Most Views

How to compare excel row by row comparison and view same excel sheet column output made by @nkaushalya with 46 views.

Filter datatable based on dates made by @Kunal_Jain with 43 views.

How to use try catch in singgle line vb? made by @Iwan_Kurniawan2 with 41 views.

Top 3 Topics with Most Replies

How to get Items in List made by @marina.dutta with 19 replies.

Reading headers- excel made by @Anjali_Rani with 17 replies.

How to add header name to excel sheet made by @mironb with 15 replies.

Top 3 Users Who Posted The Most

@Nguyen_Van_Luong1 made 35 posts!

@ppr made 29 posts!

@Shiva_Nikhil made 28 posts!

Top 3 Most Liked Posts

This post made by @Kuldeep_Pandey received 2 likes!

Last Second string 1

Thankyou all its working fine

This post made by @H_khot received 2 likes!

Getting "Key,Value ""Value"",""""" as Invoice Number

ok, Next Time i will Try to Provide a Proper Idea Thanku @supermanPunch and @Shiva_Nikhil for Helping.

This post made by @Gowthaman_Gajakutti received 1 likes!

How to store date value in Datatable in Ui path?

I am having assign variable with date value: experienceDate = 01/12/2023 - 22/08/2023. I want to store experienceDate in a datatable. What type should i choose to store the experienceDate? Please give me solution with an example. Thanks.

Top 3 Most Liked Solutions

This solution provided by @Quenton_Wayne_Rebello received 1 likes!

How to compare excel row by row comparison and view same excel sheet column output

Hey @nkaushalya , You can try the xaml attached below Main.xaml (12.0 KB) Output:- [image]

This solution provided by @esongi_park received 1 likes!

Data Scrape기능에서 필요 없는 컬럼은 어떻게 자를 수 있나요?

[image] 해당 액티비티 사용하시면 됩니다. 0번째가 첫번째입니다 구글링 참고하시면 도움이 될거에요

This solution provided by @ppr received 1 likes!

How to get Items in List

we should not try to put the variety of all possible XML scenarios, which can occur in the world, into one solution. Your XML is bound to an office:document xml. You also have implemented to work with text:p elements We can bring some flexibility into by: [grafik] Or [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.