Forum Engagement Daily Reports

[system]

Daily Forum Report | 28 November 2021

Top 3 Topics with Most Views

Is there any another shortcut rather than giving all the arrays seperately like below in for each loop made by @Bhagyaraj_Digumarthi with 32 views.

Taking as a list from xml file made by @Basak_Demirel_Kacmaz with 32 views.

Filter data and set color to filtered data(dynamically) keeping it in another sheet in same workbook made by @ydash999 with 31 views.

Top 3 Topics with Most Replies

Matches activity to extract multiple url made by @BHARAT_NAGAR with 14 replies.

Connection error with studio and Uipath Assistant made by @AMALRAJ with 12 replies.

Filter data and set color to filtered data(dynamically) keeping it in another sheet in same workbook made by @ydash999 with 11 replies.

Top 3 Users Who Posted The Most

@kirankumar.mahanthi1 made 16 posts!

@Srini84 made 14 posts!

@ydash999 made 6 posts!

Top 3 Most Liked Posts

This post made by @Jobin_Joy received 2 likes!

Is there any another shortcut rather than giving all the arrays seperately like below in for each loop

Hi @Bhagyaraj_Digumarthi , Here is the solution. [Sum] [Sum] Hope this will help you. Thank you. @prasath_S You are correct.

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

Google blocks access

Hi, Could you please try below steps in your google admin website to resolve the issue. Sign in to your Google Admin console. Sign in using an administrator account On the Admin console Home page, go to Security [and then] API controls . Under App access control , select MANAGE THIRD-PARTY APP ACCESS . View details about apps in the app table. The following details are displayed: App name Type ID Status Change the status to Trusted to resolve the app blocked issue. thanks.

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

Optimization maximum utilisation

Hi @kl_kl , Sharing my thoughts over the issue you mentioned in the above post. If you want better productivity for your bot you have to remove some other applications which are running background in your vm which occupy unnecessary RAM memory. Please un install those applications. In my point of view increasing RAM will help you because RAM play vital role in the performance of the Machine. And also can we use multi bot for your processes so that we can increase the productivity of your bo…

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 1 likes!

Is there any another shortcut rather than giving all the arrays seperately like below in for each loop

Hi Here you are passing the value as a sum which is a individual value So first I would like to suggest that we won’t be in need of For each loop first If we are passing the array variable Numbers, then we need for each loop If we want the sum of array values then we can directly use writeline or any activity where you want to pass that sum value With this expression YourArrayVar.Sum(function (x) Convert.ToInt32(x)).ToString Sometimes there can be some blank values in the array an…

This solution provided by @bencemarci received 1 likes!

How to click, change things (sound output, firewall stop) at windows system tray?

ok i found out what the problem was: I have nvidia vga card and the driver was running with a “game/share overlay option”. This function was acting like a top layer and the uipath >>studiox >> activities >> indicate function did only recognize this top layer. And nothing beneath. I turned off this “nvidia gameshare layer” stuff after that it was no problem with recognizing system tray icons, softwares. thanks for the help!

This solution provided by @Srini84 received 1 likes!

Filter data and set color to filtered data(dynamically) keeping it in another sheet in same workbook

@ydash999 Check below to color the column, Let’s say A column we need to color, follow below [image] This will always dynamic according to the Rows of the datatable This will help you Thanks

---

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 November 2021

Top 3 Topics with Most Views

Invoke VB code does not work made by @abdel with 45 views.

How can we pass the data table output to custom table please help me? made by @panguluri_saritha with 44 views.

How to pass variable into send hotkey made by @dhanashree22 with 40 views.

Top 3 Topics with Most Replies

How can add one by one add integer in web page made by @Rajiduraikannu_Santhosh_G with 17 replies.

How to use add data row if there is already value in datatable? made by @CharlotteG with 15 replies.

How can i modify Datatable in foreach loop? in C# made by @Sa_Ge with 13 replies.

Top 3 Users Who Posted The Most

@kirankumar.mahanthi1 made 32 posts!

@Yoichi made 21 posts!

@ppr made 19 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 3 likes!

How to extract table data from mail body?

Hi There are multiple approaches to read a DATATABLE from a mail body Like data scrapping or converting the HTML mail body to DATATABLE Have a view on this thread for multiple approaches Or This component can help you convert the HTML to datatable that is it will read the mail and give the datasets in it If you using this component Then the steps involved will be like [image] [image] In property HTMLText – item.Header(“HTMLBody”).ToString . This will extract the HTML code from the e…

This post made by @n.balaji10 received 2 likes!

“Insert: IErrorInfo.GetDescription failed with E_FAIL(0x80004005).”

If you get this error means, Check excel header and DB table header, and check if any header has spaces inbetween. if yes remove the spaces then choose database connection wizard from Microsoft ODBC Data Source and try

This post made by @prasath_S received 2 likes!

Regex Help to read - Merchant statement

Hi @Duleepa_Krishan Please give a try, System.Text.RegularExpressions.Regex.Match("your input","(?<=MERCHANT NUMBER)[\s\d:]*").tostring.trim.replace(":","") Thanks

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 3 likes!

How to extract table data from mail body?

Hi There are multiple approaches to read a DATATABLE from a mail body Like data scrapping or converting the HTML mail body to DATATABLE Have a view on this thread for multiple approaches Or This component can help you convert the HTML to datatable that is it will read the mail and give the datasets in it If you using this component Then the steps involved will be like [image] [image] In property HTMLText – item.Header(“HTMLBody”).ToString . This will extract the HTML code from the e…

This solution provided by @pavithra_pavi received 1 likes!

How replace a special characters in string

Hi @Kavya_Bhat , From what i understand, you need to remove the special character from a string. Try using Regex. System.Text.RegularExpressions.Regex.Replace(“thisIs@myQues#”, “[^a-z A-Z]”, “”).ToString Let me know if it works.

This solution provided by @pravin_calvin received 1 likes!

Extract value from a selector

Hi @hacback17 Use get Attribute to get the parentid attribute from the selector and use the Regex pattern to match only digits! 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 | 30 November 2021

Top 3 Topics with Most Views

UiPath Educator Certification Challenge 2021 made by @Rajesh_Nambiar with 89 views.

Need to clarify in fine element varaible made by @siva_sankar with 41 views.

Read Range : illegal character in path made by @111153 with 39 views.

Top 3 Topics with Most Replies

Extracting Data from All documents of same type made by @Seema_Jethe with 19 replies.

Read Range : illegal character in path made by @111153 with 18 replies.

Datatable out of memory exception made by @RPA-botDev with 17 replies.

Top 3 Users Who Posted The Most

@Srini84 made 32 posts!

@kirankumar.mahanthi1 made 26 posts!

@ppr made 20 posts!

Top 3 Most Liked Posts

This post made by @Rajesh_Nambiar received 8 likes!

UiPath Educator Certification Challenge 2021

( only for Academic Alliance educators, who are teaching RPA in their university or institution ) [EmailHeaderShape-Large-30Nov21 Copy (1)] In our efforts to support our educator community in the region, we are pleased to announce - UiPath Educator Certification Challenge 2021. This challenge will help our educators prepare and attempt UiPath Certified RPA Associate ( UiRPA ) certification and validate their RPA fluency with an industry-recognized credential from UiPath Sign up to the chall…

This post made by @ppr received 3 likes!

Email Body Extract

give a try on this generic pattern [grafik] ^(.*?)(?:\:)(.*?)$ And rely on groups (you would later trim the values) [grafik] Along with the Post from @Steven_McKeering you will also get the link to and vice versa:

This post made by @Yoichi received 3 likes!

What is vbLf?

Hi, It’s constant. The entity is chr(10). The following helps you. Regards,

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Error while using the data table argument in invoke code activity

How to Update Data Column Values of a Data Table | Community Blog it is listing your case

This solution provided by @pavithra_pavi received 2 likes!

Change date from dd/mm/yy into dd-MMM-yyyy

Hey @Preethi2 , Welcome to the forum. Check the below post. https://forum.uipath.com/t/date-functionality/365013 The solution is :- 1.create a variable of string “yourDate” 2.assign yourDate = “27/11/21” 3.Output = DateTime.ParseExact(yourDate , dd/MM/yy ,CultureInfo.InvariantCulture,DateTimeStyles.None).ToString(“dd-MMM-yyyy”)

This solution provided by @Yoichi received 1 likes!

Extract substring in between symbols reading from the end of a string

Hi, There are some ways to achieve it. One of them is to use regex as the following, for example. System.Text.RegularExpressions.Regex.Match(yourString,"[^_]+(?=_[^_]*$)").Value Regards,

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

@Yoichi received 87 likes for their solutions!

@ppr received 47 likes for their solutions!

@Palaniyappan received 41 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 December 2021

Top 3 Topics with Most Views

Regional release - Celebrating 1000+ UiPath Academic Alliance partners made by @Rajesh_Nambiar with 64 views.

Extracting Data using Regular expression made by @Seema_Jethe with 50 views.

Why output is not coming based on the condition? made by @ydash999 with 43 views.

Top 3 Topics with Most Replies

Extracting Data using Regular expression made by @Seema_Jethe with 19 replies.

Validation Error - The current activity must be used within a Use Application/Browser activity that automates a browser made by @Andrei30 with 18 replies.

Can't find UiPath.Database.Activities made by @stanstilo with 18 replies.

Top 3 Users Who Posted The Most

@Jobin_Joy made 41 posts!

@kirankumar.mahanthi1 made 33 posts!

@Srini84 made 22 posts!

Top 3 Most Liked Posts

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

Monthly Forum rewards - November 2021 - With updates!

Thank you so much Maciej for your message and special mention. Heartful Congratulations to all the winners. thanks to all the fellow forum members for their wonderful questions and knowledge sharing.

This post made by @Palaniyappan received 11 likes!

Monthly Forum rewards - November 2021 - With updates!

Congrats everyone Great job Cheers

This post made by @pravin_calvin received 11 likes!

Monthly Forum rewards - November 2021 - With updates!

Congrats to all winners💥

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

How to get current and last day of every month?

Hi, Another solution: Hope the following helps you. Last day previous month New DateTime(Now.Year,Now.Month,1).AddDays(-1).ToString("dd/MM/yyyy") 1st dat previous month New DateTime(Now.Year,Now.Month,1).AddMonths(-1).ToString("dd/MM/yyyy") Regards,

This solution provided by @Yoichi received 1 likes!

任意の列で重複データがある場合、条件で１行だけ残したい

こんにちは 列数が多いなら、以下お試しください。 dt = dt.AsEnumerable.GroupBy(Function(r) r("ごはん").ToString).Select(Function(g) dt.Clone.LoadDataRow(g.OrderBy(Function(r) r("仕入先").ToString.Substring(1,1)).First().ItemArray,False)).CopyToDataTable

This solution provided by @THIRU_NANI received 1 likes!

Extracting the zip file

Hi! “FIS_”+now.AddDays(-1).ToString(“MMM”).ToLower+now.AddDays(-1).ToString(“yy") 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 | 02 December 2021

Top 3 Topics with Most Views

Tip: How to use Win32 API or DLL Calls with Roslyn Compiler for the Windows Compatibility Mode made by @StefanSchnell with 43 views.

Read Range not working made by @badal_sharma with 34 views.

Excel datatables work made by @siva_sankar with 33 views.

Top 3 Topics with Most Replies

How to filter excel sheet through if condition made by @Lakshya_Garg with 13 replies.

Excel datatables work made by @siva_sankar with 11 replies.

How to write Row value on next sheet made by @Majunu09 with 10 replies.

Top 3 Users Who Posted The Most

@Srini84 made 27 posts!

@kirankumar.mahanthi1 made 26 posts!

@Jobin_Joy made 25 posts!

Top 3 Most Liked Posts

This post made by @PrankurJoshi received 4 likes!

Monthly Forum rewards - November 2021 - With updates!

Congratulations everyone

This post made by @StefanSchnell received 3 likes!

Tip: How to use Win32 API or DLL Calls with Roslyn Compiler for the Windows Compatibility Mode

Almost a year ago I introduced the possibility to make Win32 API or DLL calls. However, this approach no longer works with .NET5+, which is Windows compatibility mode in UiPath. So I investigated if there is a possibility to develop this approach for .NET5+ as well. One possible approach can be implemented using the Roslyn compiler. It is part of .NET SDK and also part of the UiPath installation. This Invoke Code Activity has the same interface as in the other example. Thus, the routines can be…

This post made by @Steven_McKeering received 3 likes!

Cron Expression For Specific Days Of Month AND Specific Days Of The Week

Hey @david.kameka Welcome back to the forums You won’t be able to achieve this with a single cron expression (happy to be wrong). You will need to combine the cron expression you have created in your post (0 30 6 ? * 2-6 *) with a non working days Calendar. The calendar will need to be setup exclude the jobs running on the 1st of each month. In summary, these two elements combined will make the job run at 6:30am Monday to Friday minus the 1st of each month because of the Non …

Top 3 Most Liked Solutions

This solution provided by @Steven_McKeering received 3 likes!

Cron Expression For Specific Days Of Month AND Specific Days Of The Week

Hey @david.kameka Welcome back to the forums You won’t be able to achieve this with a single cron expression (happy to be wrong). You will need to combine the cron expression you have created in your post (0 30 6 ? * 2-6 *) with a non working days Calendar. The calendar will need to be setup exclude the jobs running on the 1st of each month. In summary, these two elements combined will make the job run at 6:30am Monday to Friday minus the 1st of each month because of the Non …

This solution provided by @ppr received 3 likes!

Message Box: Empty ChosenButton Output

A formal RnD round came out with following: AutomaticallyCloseAfter: set to 3 seconds YesNoCancel Button Case: not clicking any button - ChosenButton: “OK” Cases: clicking any button - ChosenButton: “” AutomaticallyCloseAfter: not set - YesNoCancel Button Cases: clicking any button - ChosenButton: has the Value of the clicked Button Repeated also with other ButtonOptions: OkCancel - Result as above Fazit: it seems that Requirements/Expectations/Design/Implementation is not on a common p…

This solution provided by @prasath_S received 2 likes!

Is there any way to make a hidden column reappear in Excel?

Hi @Kirigirisu_Coin You can try VBA by using invoke VBA activity, Sub unhide() Columns.EntireColumn.Hidden = False End sub Below is the document for how to use invoke VBA activity, Or you can also try balareve activity to hide/unhide columns

---

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 December 2021

Top 3 Topics with Most Views

URGENT (NEED HELP ASAP) Oracle db Connection keep saying: "System.data.oracleclient requires oracle client software version 8.1.7 or greater" even though already installed ODAC v12c made by @wija with 50 views.

How to Get date only form designer with c#? made by @Sa_Ge with 46 views.

Retry Scope - Please list all 'Condition Activities' that can be used made by @Steven_McKeering with 40 views.

Top 3 Topics with Most Replies

URGENT (NEED HELP ASAP) Oracle db Connection keep saying: "System.data.oracleclient requires oracle client software version 8.1.7 or greater" even though already installed ODAC v12c made by @wija with 30 replies.

Retry Scope - Please list all 'Condition Activities' that can be used made by @Steven_McKeering with 19 replies.

Extracting Pan Card holder name using regex made by @Seema_Jethe with 18 replies.

Top 3 Users Who Posted The Most

@Jobin_Joy made 30 posts!

@kirankumar.mahanthi1 made 27 posts!

@Yoichi made 18 posts!

Top 3 Most Liked Posts

This post made by @Steven_McKeering received 4 likes!

Retry Scope - Please list all 'Condition Activities' that can be used

Thanks @Yoichi and everyone for your help! @prasath_S @Divyanshu_Divyanshu @pravin_calvin @Jobin_Joy @moosh

This post made by @Jobin_Joy received 3 likes!

Retry Scope - Please list all 'Condition Activities' that can be used

Oops . My bad I missed to read this thread. Hope already resolved. Thank you @Yoichi

This post made by @Yoichi received 3 likes!

Retry Scope - Please list all 'Condition Activities' that can be used

Hi, It seems CheckTrue activity in SystemActivities 21.4 or higher has Result property and it works in the condition of RetryScope. Thank you for sharing useful information. Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Retry Scope - Please list all 'Condition Activities' that can be used

Hi, if you want to use IsTrue activity, can you try to install Workflow Manger Activities package from Offcial feed, as the following? [img20211203-3] Regards,

This solution provided by @Yoichi received 2 likes!

How to Get date only form designer with c#?

Hi, Can you try the following expression? DateTime.Parse(Output["sdate"].ToString()).ToString("ddMMyyyy") Regards,

This solution provided by @Vishal_K received 2 likes!

Help to remove rows in datatable if they match value in a second datatable

Hi @kkiw You can use the Assign activity with the following LINQ query dtOutput=io_dtInactiveUsers.AsEnumerable().Where(Function(row) NOT dtExclusion.AsEnumerable().Any(Function(x) x(“ID”).ToString=row(“ID”).ToString)).CopyToDatatable; The dtOutput fetches data from io_dtInactiveUsers which are not in dtExclusion based on ID column (assumed that in both of these datatables ID is the common column to be matched) Note : If by chance you get “ AsEnumerable is not a member of datatable ” issu…

---

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 December 2021

Top 3 Topics with Most Views

Select query help made by @Shilpa_Mohanty with 53 views.

Datacolumn expression made by @kl_kl with 36 views.

Scrapping Query made by @kailas_jadhav with 35 views.

Top 3 Topics with Most Replies

Select query help made by @Shilpa_Mohanty with 46 replies.

Scrapping Query made by @kailas_jadhav with 15 replies.

How can I change targetFramework back to Windows-legacy? made by @grosner with 8 replies.

Top 3 Users Who Posted The Most

@Jobin_Joy made 26 posts!

@kirankumar.mahanthi1 made 21 posts!

@Shilpa_Mohanty made 21 posts!

Top 3 Most Liked Posts

This post made by @pravin_calvin received 2 likes!

Scrapping Query

Hi @Jobin_Joy Looping @StefanSchnell SAP Expert! Regards @pravin_calvin

This post made by @Jobin_Joy received 2 likes!

Scrapping Query

@ppr @pravin_calvin @kirankumar.mahanthi1 @Yoichi @Srini84 Your insights on SAP B1 application to scrap data please. Thank you.

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

Scrapping Query

Hi, As per the @Jobin_Joy earlier post for your query. did you tried enabling the GUI scripting for the SAP applications. if you enable this option most of the SAP applications will allow you to extract the data from the UI(even data scraping or you can extract the data as table format) or else you could spy only total window. Please refer the below documentation on how to enable GUI scripting. if you already enabled please share your confirmation.

Top 3 Most Liked Solutions

This solution provided by @maldpkdamle received 1 likes!

Can a UiPath App be 'transfered' to a different Organization Tenant?

Thank you for the suggestion! Unfortunately, I already reviewed that Thread, and it is a different issue than mine. That thread is basically regarding access to a UiPath App by Users within the same Tenant in the same Organization. My issue is more about ‘replication’/‘cloning’/‘transfer’ of a UiPath App from the Tenant of one Organization to the Tenant of a Different Organization. But good news is that I think I have found the answer (and it is simple): Basically, my team is is working withi…

This solution provided by @ppr received 1 likes!

Datacolumn expression

[grafik] "[Column2] Like '%' + [Column1] + '%'" find starter help here: DCExpression_ColXIsContainedInColY.xaml (7.2 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 | 05 December 2021

Top 3 Topics with Most Views

Problems logging into orchestrator from UIPath Studio 2021.10.3 made by @John_Castilletti with 36 views.

Help Pelase - I need read specific Number dont’read Text and Empty (Excel) made by @alicezona with 30 views.

How to include a variable into the file name for an Excel export from SAP made by @Fabio_Di_Turi with 29 views.

Top 3 Topics with Most Replies

Get text generating this error: Compiler error(s) encountered processing expression...Value of type 'String' cannot be converted to 'UiPath.Core.UiElement' made by @MilTri with 7 replies.

Table extraction and clicking html button for each row that meets criteria made by @Jon_Mason with 6 replies.

Which type of process model is the REFramework template by default made by @Shuhratjon_Zikiryaev with 5 replies.

Top 3 Users Who Posted The Most

@kirankumar.mahanthi1 made 8 posts!

@Srini84 made 5 posts!

@Jobin_Joy made 5 posts!

Top 3 Most Liked Posts

This post made by @pradeep-shukla received 2 likes!

Monthly Forum rewards - November 2021 - With updates!

kudos to all the winners !!!

This post made by @StefanSchnell received 2 likes!

Select query help

@Shilpa_Mohanty @prasath_S Hello Shilpa and Prasath, I just tried the code sequence and it works fine for me, for Windows - Legacy and Windows mode, with UiPath Studio 2021.10.2. The class Microsoft.CodeAnalysis.SyntaxTree with the method ParseText is part of the Roslyn compiler. It is part of the Studio installation and in a normal case I would never expect this kind of error. Here as example my two test cases, please try it and let us know your results. ShilpaTestWindows.zip (99.9 KB) Sh…

This post made by @Yoichi received 2 likes!

Select query help

@Shilpa_Mohanty @prasath_S @StefanSchnell Hi, I can just reproduce this problem in my environment as the following. [img20211206-2] I haven’t get the exact conditions for reproduction yet, but In Studio 20.10.9 with System.Activities package 21.10.2 this occurs. If downgrade System.Activities package to 20.10.4 (this is bundled version of Studio 20.10.9) , there is no error. So for now can you try to downgrade System.Activities package to 20.10.4, if you use Studio except the latest. Rega…

Top 3 Most Liked Solutions

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

---

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

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

[system]

Daily Forum Report | 06 December 2021

Top 3 Topics with Most Views

Remove last characters in excel made by @christian.bendtsen with 45 views.

Subtract Days from the Current Date made by @Anggara_Rahmadhani with 43 views.

Using RegEx condition to validate mail body made by @Basit_Xe with 43 views.

Top 3 Topics with Most Replies

Remove last characters in excel made by @christian.bendtsen with 33 replies.

Using RegEx condition to validate mail body made by @Basit_Xe with 23 replies.

Subtract Days from the Current Date made by @Anggara_Rahmadhani with 14 replies.

Top 3 Users Who Posted The Most

@Srini84 made 23 posts!

@kirankumar.mahanthi1 made 21 posts!

@ppr made 19 posts!

Top 3 Most Liked Posts

This post made by @THIRU_NANI received 4 likes!

Monthly Forum rewards - November 2021 - With updates!

Congratulations everyone

This post made by @pikorpa received 4 likes!

Monthly Forum rewards - November 2021 - With updates!

Congratulations for everyone

This post made by @AMALRAJ received 4 likes!

Monthly Forum rewards - November 2021 - With updates!

Heartfelt congratulations to all the winners :moneybag:once again. Regards AMAL

Top 3 Most Liked Solutions

This solution provided by @ppr received 3 likes!

Subtract Days from the Current Date

[grafik] Enumerable.Range(1,3).Select(Function (x) now.Date.AddDays(-x)).Reverse().toArray Enumerable.Range(1,3).Select(Function (x) now.Date.AddDays(-x).ToString("ddMMyyyy")).Reverse().toArray

This solution provided by @Jobin_Joy received 2 likes!

Convert Int32[] to String{}

Hi @henokhbrian Dim intArray() As Integer = {1, 2, 3,4,5} Dim strArray() As String = intArray.Select(Function(x) x.ToString()).ToArray() Hope this will be helpful. Thank you

This solution provided by @ppr received 2 likes!

How To Compare lists

Are you looking for this? [grafik] list1.Intersect(list2).ToList

---

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 December 2021

Top 3 Topics with Most Views

Current time made by @shreyaank with 42 views.

How to compare or match the two different excel files made by @kailas_jadhav with 41 views.

Increment a column according to a value in column A made by @Soudios with 40 views.

Top 3 Topics with Most Replies

Increment a column according to a value in column A made by @Soudios with 22 replies.

重複する項目を持つコンボボックスの全選択方法 made by @takahiro1 with 19 replies.

Current time made by @shreyaank with 14 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 32 posts!

@Yoichi made 24 posts!

@ppr made 23 posts!

Top 3 Most Liked Posts

This post made by @swathikindre received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi , I am Swathi Kindre ,working as Associate Developer RPA having 6 months of experience.

This post made by @Jobin_Joy received 2 likes!

How to build a dynamic row table in mail body

Hi @111183 Appreciate @pravin_calvin for doing this on different way. Here is an alternative solution for your requirement. [image] [image] [image] [image] [image] Code: DynamicRowInHTML.zip (2.7 KB) Hope this will help you. Thank you.

This post made by @pravin_calvin received 2 likes!

How to build a dynamic row table in mail body

Hi @111183 Please find the Zip below for starter help! test_Process_list.zip (3.0 KB) Regards

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Get files in folder inside folder

we can retrieve files from folders and subfolders e.g. by: Directory.GetFiles(MyDirPathVar,"*.*",SearchOption.AllDirectories) taken from:

This solution provided by @ImPratham45 received 1 likes!

Multiply all the numbers in a list

You can do . Assign Result=1 Use for Each for list Assign Result=Result*Cint(Item) At the end you will get Result.

This solution provided by @Yoichi received 1 likes!

Excelの行選択からOutlookの宛先へ入力するには？

こんにちは 上記はサンプルに添付しているExcelシート用ですので、構成がことなる場合は、それ用に修正が必要です。 お使いのものはどのようなシートになっていますでしょうか？

---

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 December 2021

Top 3 Topics with Most Views

動的処理で次のページへ進みたい made by @r.shimura with 66 views.

How to get date of the previous month ie i need 11\01\2021 made by @Gayathri_Mk with 60 views.

How to find column value is blank and update the status without using Loop made by @nithya with 50 views.

Top 3 Topics with Most Replies

Attach browser# Unable to detect any filed on the new Windows opened made by @abdellah_Abu_mohamed with 17 replies.

サーバー上に使用可能なライセンスがありません。 made by @sato_rana with 15 replies.

How to Create Pivot table using Invoke code Method? made by @Priyanka_Jadhav1 with 14 replies.

Top 3 Users Who Posted The Most

@Yoichi made 26 posts!

@kirankumar.mahanthi1 made 21 posts!

@Jobin_Joy made 18 posts!

Top 3 Most Liked Posts

This post made by @Jobin_Joy received 3 likes!

Link Input Dialog to Open Excel File

Just open Adobe Acrobat Reader and indicate the screen. Here is the sample selector for it [image] Thank you.

This post made by @Robertson_Daniel received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, Forum Community! I work for a Travel and Hospitality Technology Company that is embracing UiPath and I will be heading up our Center of Excellence. I look forward to learning more with you all. Daniel

This post made by @pbartlett1 received 2 likes!

Searching a webpage for email address

Hi Thomas, I have attached a process that does exactly what you have described. Make sure you have the UiPath.UIAutomations.Activities package installed. I noted what each activity does. If you have any questions, just let me know. Main.xaml (18.8 KB)

Top 3 Most Liked Solutions

This solution provided by @Jobin_Joy received 3 likes!

Link Input Dialog to Open Excel File

Just open Adobe Acrobat Reader and indicate the screen. Here is the sample selector for it [image] Thank you.

This solution provided by @ppr received 2 likes!

If query whether datatable is empty

dtvar.Rows.Count = 0

This solution provided by @Jobin_Joy received 2 likes!

How to run R Script in Uipath

That’s correct but one important this is that Activity is not compatible with R versions greater than 3.4.3. [image] The version you used is higher that causing the issue. You can download R3.4.3 from here. https://cran.r-project.org/bin/windows/base/old/3.4.3/ Hope this will be helpful. Thank you.

---

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 December 2021

Top 3 Topics with Most Views

Comparing string variables made by @Seema_Jethe with 64 views.

Sumif in Uipath made by @Satish_Ch with 50 views.

How to download the UiPath Advanced Certification? made by @HeartCatcher with 48 views.

Top 3 Topics with Most Replies

Comparing string variables made by @Seema_Jethe with 30 replies.

Conversion of General Data Type to an Integer made by @Dr_Raza_Abidi_PhD with 28 replies.

Sumif in Uipath made by @Satish_Ch with 21 replies.

Top 3 Users Who Posted The Most

@Jobin_Joy made 36 posts!

@Seema_Jethe made 27 posts!

@Yoichi made 23 posts!

Top 3 Most Liked Posts

This post made by @pikorpa received 3 likes!

How to Get the previous day (ddMMYYYY)-1?

Hey, you can use: yourDateVariable.AddDays(-1)

This post made by @yuko.tanaka received 2 likes!

【UiPathアカデミー】12月分新規コースのお知らせ

平素より、UiPathアカデミーをご愛顧いただき誠にありがとうございます。 このたび、「Studio Pro による RPA テスト」コースを新たにリリースしましたのでお知らせいたします。 このコースでは、RPA テストをオートメーション プロセス全体のうちの 1 つの過程と位置付けて、UiPath Studio Pro でのテストに関連する機能について詳しく学習できます。 また、先だって「RPA 開発者の一日」コースもリリースしております。 こちらのコースでは、RPA 開発者として理解しておくべきこと、考え方についていくつか取り上げています。 オートメーション ファーストの考え方、プロセスとは何か、プロセスが自動化に適しているかどうかを評価する方法等を学習する内容となっており、これから RPA 開発者として RPA 開発を行われる方を対象としたコースとなっております。 ※アカデミーにログイン後、リンクが遷移しない場合は、ブラウザーを一度閉じクッキーとキャッシュをクリアしてください。 UiPath 製品に関する知識の拡充にお役に立てればと思います。 ぜひ、UiPath …

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

Clarify in some topics?

Global variables is generic term which we can create and use anywhere in the our process. In Uipath mostly we keep global variables in two places. As mentioned by @shreyash_shirbhate we can keep global variables in config file as dictionary variable like file path and application url and we can access anywhere in our process and second place would be assests in orchestrator. Mostly assets are our app credentials. Once we create assests we can access these in our entire process by calling with g…

Top 3 Most Liked Solutions

This solution provided by @Michaeljep received 2 likes!

How to Get the previous day (ddMMYYYY)-1?

Date.Now.AddDays(-1).ToString(“ddMMyyyy”) Should do the trick

This solution provided by @NIVED_NAMBIAR received 2 likes!

Get all the column names From datatable using linkQ query

Hi @Tabbu Use this query to get all columns name column_names= dt.Columns.Cast(Of DataColumn).Select(Function(m) m.ColumnName.ToString).ToList() Regards, Nived N

This solution provided by @pravin_calvin received 1 likes!

How to use .contain in filter property in get outlook mail message?

Hi @aapostol Use Filter Condition like Below! “@SQL=((urn:schemas:httpmail:subject LIKE ‘%YourValue%’)" 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 | 10 December 2021

Top 3 Topics with Most Views

☃️🎁 Coming soon: The UiPath Community Winter Wonderbeats !🎄❄️ made by @cristina.vidu with 60 views.

How to compare Subject line with Attachement Name? made by @Priyanka_Jadhav1 with 46 views.

How to increment made by @lakshya_garg1 with 37 views.

Top 3 Topics with Most Replies

How to compare Subject line with Attachement Name? made by @Priyanka_Jadhav1 with 39 replies.

Unable to find Web scraping option - UIPath Studio made by @aravind_sudarshan with 16 replies.

How to increment made by @lakshya_garg1 with 15 replies.

Top 3 Users Who Posted The Most

@kirankumar.mahanthi1 made 46 posts!

@Priyanka_Jadhav1 made 28 posts!

@Srini84 made 25 posts!

Top 3 Most Liked Posts

This post made by @cristina.vidu received 9 likes!

☃️ Coming soon: The UiPath Community Winter Wonderbeats !❄️

It’s starting to look a lot like… winter, and we’re all tingling with excitement for the holiday season . While some us are even hoping for snow , others still dream away in the tropics To mark the end of this year, the diverse beauty of our global community, and the festive season too, we decided to give back in our true spirit. In a way that: we all contribute all would have the chance to give and all would receive gladly a gift that re…

This post made by @cristina.vidu received 2 likes!

☃️ Coming soon: The UiPath Community Winter Wonderbeats !❄️

I’ll get the headstart!! The Pogues - Fairytale Of New York (Official Video) - YouTube

This post made by @evan.cohen received 2 likes!

Any one can help me the usecases on custom lists and lists in apps

Top 3 Most Liked Solutions

This solution provided by @jeevith received 2 likes!

Can UiPath run on Chromebook/ChromeOS?

HI @Elango_N, Welcome to the community! On ChromeOS UiPath does not support ChromeOS. So short answer is no you cannot run an attended robot process on ChromeOS. On Chromebook If you installed a linux distro (removed ChromeOS) on a chromebook + your automation was cross-platform + you want to run a unattended robot, then the answer is YES: You can run UiPath robot on a Chromebook by using the new feature Unlock Linux automation with 21.8 Robot! - News / New Features - UiPath Community Foru…

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

How to compare Subject line with Attachement Name?

Hi, Updated work flow and try to run and see are you able to get your PDF. thanks. TM_CR1 Updated.zip (790.5 KB)

This solution provided by @pravin_calvin received 1 likes!

Conversion of General Data Type to an Integer

Hi @Dr_Raza_Abidi_PhD Please refer to the Zip file below! And Sorry for the delay! Update_Excel_Process_Template.zip (3.3 KB) below! Regards Praveen Kumar

---

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 December 2021

Top 3 Topics with Most Views

How to increment counter made by @lakshya_garg1 with 34 views.

Issue with Dynamic Selectors RPA Challenge made by @Efrain_Magos with 29 views.

After upgrade to 2021.10.4 - browser error, Studio crashed made by @IPIX with 27 views.

Top 3 Topics with Most Replies

How to add data with status made by @Lakshya_Garg with 19 replies.

How to increment counter made by @lakshya_garg1 with 7 replies.

How i find or create chatbot? made by @Mohammed_Shehata with 7 replies.

Top 3 Users Who Posted The Most

@Srini84 made 17 posts!

@Robinnavinraj_S made 15 posts!

@pikorpa made 14 posts!

Top 3 Most Liked Posts

This post made by @rahulsharma received 3 likes!

☃️ Coming soon: The UiPath Community Winter Wonderbeats !❄️

This should be refreshing to hear. Jingle Bell Rock by Bobby Helms

This post made by @StefanSchnell received 2 likes!

dotNET 6 Support

Hello Community, a tiny hint for all developers of activities, who want to make their activities available also in Windows compatibility mode: Access to the Windows registry via RegistryKey class of the namespace Microsoft.Win32 is only available from dotNET 6. A compilation with the target platform net5.0-windows7.0 fails. A NuGet package with the target platform net6.0-windows7.0 is not considered by UiPath Studio, with the Managed Packages dialog. As @alexandru has explained it here, we wil…

This post made by @Le_Chiffre received 2 likes!

How to install studio pro on windows server 2016

Yes. it’s works. Thank you @pikorpa and @kirankumar.mahanthi1 for your responses. I have to compare both version. I very apprecite.

Top 3 Most Liked Solutions

This solution provided by @pikorpa received 1 likes!

How to install studio pro on windows server 2016

Hey, If you have installed the community version on your computer and selected StudioX - you can easily switch to the Studio Pro version. You just need to go to settings → license and profile → change profile and choose profile ‘UiPath Studio’ instead studioX. You can switching profile as many times as you want [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 | 12 December 2021

Top 3 Topics with Most Views

Assigning values in datatable (data scraping) to variables made by @SH_94 with 34 views.

UiPath studio.exe completely disappeared from my machine after the latest update! made by @kamal_hamad with 32 views.

Modify Text made by @Jarvius with 30 views.

Top 3 Topics with Most Replies

Assigning values in datatable (data scraping) to variables made by @SH_94 with 13 replies.

How to access files from a different drive letter in UiPath made by @Brady_Williams with 13 replies.

For Each Row... using Flowchart made by @IPIX with 7 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 25 posts!

@kirankumar.mahanthi1 made 13 posts!

@IPIX made 11 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 4 likes!

Workflow Analyzer with Customize Rules

Hello UiPath Developer Team, today I build my first Workflow Analyzer rule based on the great explanation of @TomaB presentation on your documentation site. Now I have three questions: In your documentation I read: “When building custom rules, please target the .NET Framework version 4.6.1.” I work with net5.0-windows7.0 as target platform and all works well and as expected. I use Studio 21.10.4. Do I have an old link? Your Rules Naming Convention is e.g. ST-NMG-001 = Studio Naming 001 ru…

This post made by @Palaniyappan received 2 likes!

Assigning values in datatable (data scraping) to variables

Hi We can use default view method That is if the datatable is saved in a variable named dt once after data scrapping then use a assign activity like this dt_1 = dt.DefaultView.ToTable(False,”Column-1”) And another assign activity like this dt_2 = dt.DefaultView.ToTable(False,”column-2”) This will save as two different datatable Hope this would help you Or you can get them as two different data columns like this In a assign activity dt_col1 = dt.Columns(0) And another assign with dt_…

This post made by @Matthijs_Geleedst received 1 likes!

MSc Information Management research study (survey); Most important features of low-code solutions

Dear fellow UIPath users, I am currently writing my thesis at NXP Semiconductors on a research study related to low-code platforms and was wondering if you could help me with filling in a small survey. The research study focuses on the question of what the most important features are of low-code platforms? Examples of these platforms are OutSystems, UiPath, ServiceNow, Mendix, Liferay, Appian Corporation, Salesforce, Winshuttle, Power automate, and Power Apps. Every low-code platform has its s…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Filter a recent date from duplicate data

Hi, Hope the following sample helps you. [img20211212-2] dt = dt.AsEnumerable.GroupBy(Function(r) r("Name").ToString).Where(Function(g) g.Count>1).Select(Function(g) g.OrderByDescending(Function(r) DateTime.Parse(r("Date").ToString)).First).CopyToDataTable Sample20211212-1.zip (2.6 KB) Regards,

This solution provided by @ravig1206 received 1 likes!

Excel get value from Excel based on other value

Hi Robin, Thanks for your reply but this is not perfect solution because this is returning multiple values that to in list variable. I have figured out solution my self. We can use below query Convert.ToString(Dt.select(“Month=‘May’”)(0)(“Yellow sales”)) This is working perfectly. Thanks for your replies.

This solution provided by @Palaniyappan received 1 likes!

How to count any range in an excel sheet

Hi We can just mention as “A4”. So that READ RANGE ACTIVITY will read from A4 to the entire sheet Regarding headers there is a property called ADD HEADERS which if disabled read range activity will create its own column name as Column-1, Column-2,…Column-N exclusive of the data Hope this clarifies Cheers @yulya

---

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 | 13 December 2021

Top 3 Topics with Most Views

Inquiry on UiPath's logging framework - concerns on Log4Shell vulnerability made by @michael_wong with 625 views.

Log4j critical vulnerability made by @Beula_Climaxi with 366 views.

BalaReva is a vendor in UiPath Marketplace made by @balupad14 with 45 views.

Top 3 Topics with Most Replies

How can i attribute index to rows made by @Soudios with 14 replies.

Validate file path returned by bot made by @x_xxx with 12 replies.

Best Practice for managing Downloads within Edge Chromium made by @LewisHenderson with 11 replies.

Top 3 Users Who Posted The Most

@kirankumar.mahanthi1 made 28 posts!

@Srini84 made 24 posts!

@ppr made 23 posts!

Top 3 Most Liked Posts

This post made by @michael_wong received 11 likes!

Inquiry on UiPath's logging framework - concerns on Log4Shell vulnerability

A good day to you. I wish to inquire if there is any concern from UiPath in regards to threat pose by the Apache Log4j vulnerability (Recently uncovered software flaw ‘most critical vulnerability of the last decade’ | Software | The Guardian). I know UiPath orchestrator runs on MS IIS and wanted to know what logging framework is used.

This post made by @balupad14 received 10 likes!

BalaReva is a vendor in UiPath Marketplace

Dear All, Now BalaReva is a vendor in UiPath Marketplace. I’m excited to share that my activities for Excel automation have been enhanced and are already available on UiPath Marketplace. BalaReva - Excel Automation for Enterprises will help you automate all kinds of Excel tasks. Also, I’ve successfully completed the UiPath security checks and now offer official support for the users of my activity package. The package helps to accelerate the automation developments across industries and do…

This post made by @Geoff received 7 likes!

Automation Cloud Robots are now in public preview!

One last 2021 milestone announcement for our Automation Cloud™ Enterprise customers: to cap off a big year for Automation Cloud, we’re excited to announce the public preview of Automation Cloud Robots! With Automation Cloud Robots, we’re adding a fully SaaS option for your Unattended Robots in Automation Cloud Enterprise – no infrastructure required to get the robot capacity you need when you need it. If you have been using Elastic Robot Orchestration, the concept is similar but requires even …

Top 3 Most Liked Solutions

This solution provided by @pavithra_pavi received 4 likes!

How to filter mail subject using Filter properties of get exchange mail activity

Hi @Preethi2 , Try this below filter expression. "subject:Invoice" Here, the above filter expression behaves as it will fetch only those emails containing subject name as Invoice To know more about this property, Please check out the below link

This solution provided by @Yoichi received 2 likes!

Expression for Directory.GetFiles

Hi, Unfortunately, GetFiles doesn’t support regex filter as the following document. Can you try to use LINQ as the following, for example. System.IO.Directory.GetFiles(FilePaths1).Where(Function(f) System.Text.RegularExpressions.Regex.IsMatch(System.IO.Path.GetFileName(f),"(PAN|CHEQUE|GST).*.pdf|jpeg$")).ToArray Regards,

This solution provided by @ppr received 2 likes!

Convert String Value to Date

[grafik] DateTime.FromOADate(43165)

---

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 | 14 December 2021

Top 3 Topics with Most Views

Not all Posts have to be Questions made by @StefanSchnell with 45 views.

HOw to convert .csv files into .xlsx files in uipath made by @Gayathri_Mk with 40 views.

Converting a string variable into date made by @Dr_Raza_Abidi_PhD with 36 views.

Top 3 Topics with Most Replies

HOw to convert .csv files into .xlsx files in uipath made by @Gayathri_Mk with 16 replies.

365 Get Mail Filter and Wrong Received Date made by @ravindar.singh with 10 replies.

Sum amount column and output the result in the next empty row made by @RPA-botDev with 10 replies.

Top 3 Users Who Posted The Most

@Srini84 made 33 posts!

@kirankumar.mahanthi1 made 23 posts!

@Yoichi made 19 posts!

Top 3 Most Liked Posts

This post made by @Parth_Doshi received 6 likes!

☃️ Coming soon: The UiPath Community Winter Wonderbeats !❄️

I think this is one of the best Hindi song to vibe on: ['Gallan Goodiyaan' Full VIDEO Song | Dil Dhadakne Do | T-Series]

This post made by @Maneesha_de_silva received 5 likes!

☃️ Coming soon: The UiPath Community Winter Wonderbeats !❄️

merry christmas [MINIONS Christmas Song]

This post made by @codemonkee received 4 likes!

Log4j critical vulnerability: CVE-2021-44228

I reached out to our CSM and received the following communication for the time being. The UiPath Security and Product Engineering teams are completing the exposure analysis of the Log4J vulnerability, categorized as CVE-2021-44228 and taking mitigation actions. At this time, UiPath has found no evidence of risk associated with this vulnerability for the following products: Studio (all types), Assistant, Robot (all types including AI Robots, Cloud Robots, etc.) Orchestrator Automation Hub (in…

Top 3 Most Liked Solutions

This solution provided by @Srini84 received 2 likes!

Is it possible to lock a excel file but the bot can open it to do the process

@Soudios You can do in two ways Password protect the excel, and provide the password to the excel application scope Encryption of the file : By using Cryptography activities, Use Encrypt File activity to encrypt entire file using a key, now use Decrypt File activity to decrypt the file and that file can be used in your bot process [image] Hope this will help you Thanks

This solution provided by @Srini84 received 2 likes!

What is the Exception when a sheet does not exist in the Excel Read range activity?

@Kirigirisu_Coin Check below [image] system.ArgumentException Hope this will help you Thanks

This solution provided by @Vijay_RPA received 2 likes!

How to Take between the Matches?

(?s)start_Word(.*?)last_Word you can use this . for last one I think you can use date format regex , Test it in regex101.com

---

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 December 2021

Top 3 Topics with Most Views

How to write location to save as window of excel? made by @Anna.Dewitt with 54 views.

Private - RPA Developer - houston - United States - Full Time made by @jellickal with 49 views.

RE framework doubt made by @praneet.naik26 with 41 views.

Top 3 Topics with Most Replies

Captcha Solver made by @burakavuncu with 12 replies.

Get the latest job details using UiPath APIs made by @sherlin.s with 11 replies.

How to write location to save as window of excel? made by @Anna.Dewitt with 10 replies.

Top 3 Users Who Posted The Most

@kirankumar.mahanthi1 made 25 posts!

@ppr made 20 posts!

@Srini84 made 20 posts!

Top 3 Most Liked Posts

This post made by @Michelle_Yurovsky received 4 likes!

Log4j critical vulnerability: CVE-2021-44228

We have just posted an update! For all versions of Insights below 2021.10, please see Products Security | UiPath. We have mitigation steps posted at Products Security | UiPath. We appreciate the patience while we investigated and worked to confirm impact and mitigation. We understand that many of you have been waiting for this announcement.

This post made by @JuveriaSiddiqui received 4 likes!

☃️ Coming soon: The UiPath Community Winter Wonderbeats !❄️

Let it snow! Let it snow! Let it SNOW!!! [Frank Sinatra - Let It Snow! Let It Snow! Let It Snow! (Official Music Video)]

This post made by @Lakshay_Verma received 3 likes!

☃️ Coming soon: The UiPath Community Winter Wonderbeats !❄️

One from Polar Express [Alan Silvestri - Spirit Of The Season from The Polar Express (Official Audio)]

Top 3 Most Liked Solutions

This solution provided by @ppr received 3 likes!

Uipath community edition License question

have a look here: [grafik] on the section: Community License you will find some more info on it. In case of doubts get in touch with UiPAth

This solution provided by @ppr received 3 likes!

How to convert numbers into datetime

[grafik]

This solution provided by @AndyMenon received 2 likes!

Creating App

Hello Basak, Our community MVP @JuveriaSiddiqui has written a blog that you might find helpful. And, you might want to take a look at UiPath Apps to Data Service integration that’s still in Preview. Also, you may want to watch these videos to get you started: [UiPath Apps-Data Service Integration - Part 03 | Create & View Data Service Entity Records] Hope these will help you get started.

---

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 December 2021

Top 3 Topics with Most Views

Try Catch and Throw activities made by @AdityaVN with 39 views.

Changing the value into proper number format made by @Sudharsan_Ka with 37 views.

Unable to ZIP excel files, getting error made by @srinivasanma1 with 35 views.

Top 3 Topics with Most Replies

Read specific column A value and write on particular cell B1 made by @Majunu09 with 22 replies.

Convert system.collections.generic.list to System.data.dataTable in FlowChart made by @NHoe with 15 replies.

Write todays date without time stamp into a cell in excel file made by @satishmypudi with 13 replies.

Top 3 Users Who Posted The Most

@kirankumar.mahanthi1 made 28 posts!

@Palaniyappan made 19 posts!

@Yoichi made 19 posts!

Top 3 Most Liked Posts

This post made by @pavithra_pavi received 5 likes!

Get the duplicate rows and non- duplicate rows

Get the duplicate rows and non- duplicate rows. Im back with another solution for our problem with datatable. I.e. Getting the duplicate rows and non- duplicate rows. We all know one simple approach of getting these details, i.e. For each loop. This approach is okay when we deal with small amount of data. But what if, we are dealing with huge amount of data. And that’s where LINQ come into picture. Watch the video to learn more about this LINQ query. Also, get the code [GetDuplicateRo…

This post made by @pikorpa received 4 likes!

Orchestrator Dashboard looks confusing- Need Clarification

Hey, In this chart on dashboard are showing only transaction. Transaction for UiPath is the item from queue. So, if you have 2 processes which don’t use the queues you will not see anything in this chart.

This post made by @pavithra_pavi received 3 likes!

Monthly Forum rewards - November 2021 - With updates!

Congratulations to all the winners

Top 3 Most Liked Solutions

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

Is it okay to combine both Dispatcher and Performer into single REframework?

Hi, it is perfectly alright to have both dispatcher and performer in RE frame work. we can have the dispatcher work flow in init state first run. We have to consider some of the scenarios like where it will take huge amount of time to get the data by using dispatcher workflow. in some case like it will take 5 to 6 hours to get the input data from the application so we cannot wait those many hours to gather our input data instead of that we have to go the approach like maintain the dispatcher a…

This solution provided by @Lucas_Ferraz received 1 likes!

Upgrade AI Center On Premisses

Hey guys, So, I figured things out. Turns out AI Center 2021.4 cannot be directly upgraded to 2021.10. As the infrastructure part of the application changed considerably due to the Automation Suite, a fresh install is necessary. Also, UiPath engineers strongly recommend using Automation Suite, because it will make upgrades and maintenances easier in future releases.

This solution provided by @codemonkee received 1 likes!

Get the latest job details using UiPath APIs

Hi @sherlin.s, I was just setting up an example when you deleted your post so I’m going to finish responding anyways in case it helps you or someone else that stumbles on the topic. In my environment I have ran 4 Jobs with the following start times over the last year or so. 2020-11-20T09:11:00.91Z 2020-11-20T09:12:15.387Z 2021-10-21T18:03:43.097Z 2021-10-21T18:03:44.073Z If I run the following GET request and Parameters {{orchestrator_url}}/{{account_name}}/{{tenant_name}}/odata/Jobs? $fil…

---

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 December 2021

Top 3 Topics with Most Views

Uipath Studio : An error occurred during the activation of a particular registration made by @charan.singh with 63 views.

Split a string without a delimiter made by @Gopalakrishnan_K with 50 views.

Array To String made by @pavithra_pavi with 44 views.

Top 3 Topics with Most Replies

Want to be able to specify one of a group of buttons made by @ruiang with 12 replies.

SNOW + HTTP Get Request + Unable to open downloaded Excel & Pdf files made by @Sairam_RPA with 11 replies.

Error occurred when using the DownloadPackage api made by @1111141 with 10 replies.

Top 3 Users Who Posted The Most

@Srini84 made 28 posts!

@kirankumar.mahanthi1 made 22 posts!

@Yoichi made 16 posts!

Top 3 Most Liked Posts

This post made by @pavithra_pavi received 8 likes!

Array To String

Array To String Hello to my UiPath Community. Hope you all are doing great!!!. I have been asked a lot by my fellow connections here or my other social media that how we can convert Arrays into Strings. So, I thought why not make a video on this, and share it across all my social media platform to reach all those people who want answers to this question. Here is the video link, Check out and also get the source code

This post made by @jeevith received 7 likes!

Split a string without a delimiter

Hi @Gopalakrishnan_K, String[] YourVariable = System.Text.RegularExpressions.Regex.Split("OtherSupplierLogisticsDesign", "(?<!^)(?=[A-Z])"); YourVariable is an array type containing string items. Later you can poll the array like so YourVariable(0).ToString.Trim resulting in "Other" YourVariable(1).ToString.Trim resulting in "Supplier" YourVariable(2).ToString.Trim resulting in "Logistics" YourVariable(3).ToString.Trim resulting in "Design" So each of the purple piped lines will be place…

This post made by @Masli received 4 likes!

New Training! UiPath Integration Service

New course release: UiPath Integration Service We proudly present this training which will equip you with the skills and knowledge needed to automate complex enterprise processes through RPA and UI automation, together with API automation from app integrations. Duration: 1 hour Audience: RPA Developers familiar with UiPath RPA development capabilities Objectives: Expand the skillset with API automation of third-party apps such as: Outlook, OneDrive, ServiceNow, Salesforce,…

Top 3 Most Liked Solutions

This solution provided by @yoshimura.tomoko received 1 likes!

画面にセットしたパスワードを確認したい

先日はありがとうございました。 パスワードについては、文字列一致チェックではなく 入力パスワード=画面セットしたパスワード桁数のチェックで構わないと上長確認が 取れましたので、そちらで実施してまいります。 今後ともよろしくお願いいたします

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

File is read only and cannot be overwritten

Hi, Some how execute macro making xlsm file to read only mode. Did you already enable all option in the macro settings in the excel application scope. And also please un check the save excel option if you are just reading the visible sheet names from xlsm file so un necessarily it will not try to save xlsm for each and every action. Please try the above option and let us know. If you still not able to resolve the issue. If possible please share us the macro code you are trying run in that xl…

This solution provided by @Yoichi received 1 likes!

Filter Date from datatable after scraping from web

Hi, Can you try the following expression? ExtractDataTable = ExtractDataTable.AsEnumerable.Where(Function(r) DateTime.Parse(r("PRDDATE").ToString)>=New DateTime(2021,12,1) AndAlso DateTime.Parse(r("PRDDATE").ToString)<=New DateTime(2021,12,10)).CopyToDataTable Note: If there is invalid date string/character (including empty) in PRDDATE column, the aboce will fails. 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.