Forum Engagement Daily Reports

[system]

Daily Forum Report | 14 April 2022

Top 3 Topics with Most Views

Capitalize first letter of a string for Composed words made by @hsendel with 44 views.

Avoid ip blocking made by @Patel_Piyush1878 with 43 views.

Cron expression For alternative friday made by @Sudharsan_Ka with 38 views.

Top 3 Topics with Most Replies

Capitalize first letter of a string for Composed words made by @hsendel with 30 replies.

Data Scraping software's table and using Add Data Row to enter new rows into Data Scrapped DataTable made by @beepboop with 20 replies.

SAP field wasn't able to select made by @Cari with 13 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 57 posts!

@supermanPunch made 35 posts!

@lakshman made 33 posts!

Top 3 Most Liked Posts

This post made by @asha_jyothi received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, I am Asha. New to RPA learning through Uipath Academy. Can someone let me know I I can install Studio X on Chromebook?

This post made by @AndyMenon received 2 likes!

COMING SOON - You’re invited to join the “Studio Web and UiPath IT Automation” event

Just signed up!

This post made by @aalaghbari received 2 likes!

Text to Columns Google Sheet

Thanks a lot.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to get String within a String with Regex

Hi, Can you try the following expression? System.Text.RegularExpressions.Regex.Match(yourString,"(?<=-\s+).*?(?=\s+\(it is a normal name\))").Value Regards,

This solution provided by @Nithinkrishna received 1 likes!

Capitalize first letter of a string for Composed words

Hey @hsendel Please find the updated, CapitalizeFirstLetter_v2.zip (8.5 KB) Thanks #nK

This solution provided by @supermanPunch received 1 likes!

How to get output from a powershell activity?

Hi @kkpatel , I am able to get the Output using a return provided the TypeArgument is a String : [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 | 15 April 2022

Top 3 Topics with Most Views

📢 Launching UiPath Technology Integrations Series 2022: Alteryx, Qlik & Cyberark made by @cristina.vidu with 47 views.

How to select the policy number based on the logic made by @HeartCatcher with 44 views.

Excel起動時に出てくるポップアップ回避策について made by @r.nakanishi with 40 views.

Top 3 Topics with Most Replies

Is it Possible to have String Input as a WebPage Content? made by @hsendel with 21 replies.

Comparing two DataTables with inconsistent values made by @beepboop with 18 replies.

I have a small captcha problem made by @Vijay_Manimaran with 15 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 33 posts!

@ushu made 21 posts!

@jack.chan made 18 posts!

Top 3 Most Liked Posts

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

Launching UiPath Technology Integrations Series 2022: Alteryx, Qlik & Cyberark

Time has come to restart and pick-up the pace on UiPath’s Technology Integrations Series! As an end-to-end automation platform, UiPath can integrate with various enterprise technologies to deliver maximum benefit. This is especially true for technologies we have worked on with the help of our partners: Alteryx, Qlik and CyberArk. To help you understand the best methods for integrating these services with the UiPath automation solution, we are happy to announce our next UiPath Tech…

This post made by @jeevith received 2 likes!

For each loop in group wise

Hi @Jesmine, Go with the approach @saurabhB said. That is the most robust way to get what you want. I do think you will also want to sort the other two columns when you make such groups corresponding to the name column (Sort which affects all columns). You can either use the Index ( in your case 1, or the name of the column) If the column is string, sort goes from a-z or z-a [image] When using a dummy data : [image] SortDataTable.xaml (8.4 KB)

This post made by @jeevith received 2 likes!

Storing the values in JSON output to Data table

Hi @Harsha_Vemula, There are plenty of ways to achieve this. I agree with @saurabhB that you do not need to convert to a datatable to get count of certain values. In both approaches you will need the following dependency (to ensure your input string is converted to Json object) [image] or the namespace in imports [image] The datatable approach [image] JsonCountValueUnique.xaml (9.6 KB) The query approach [image] @saurabhB you can trim down the expression even more as the Input…

Top 3 Most Liked Solutions

This solution provided by @jeevith received 2 likes!

Storing the values in JSON output to Data table

Hi @Harsha_Vemula, There are plenty of ways to achieve this. I agree with @saurabhB that you do not need to convert to a datatable to get count of certain values. In both approaches you will need the following dependency (to ensure your input string is converted to Json object) [image] or the namespace in imports [image] The datatable approach [image] JsonCountValueUnique.xaml (9.6 KB) The query approach [image] @saurabhB you can trim down the expression even more as the Input…

This solution provided by @grosner received 2 likes!

How Can I use Argument or Variable in RegEx Builder Value field?

Surrounding variable name with curly braces appears to work. This is what it looks like: [uipath-RegExBuilder-with-variable] Additional Information: The variable is of type String. You cannot start typing the variable name and see a pop-up list of variable suggestions. It is better to use a variable name rather than an argument because changing the variable name will automatically update the variable name for this activity.

This solution provided by @jeevith received 2 likes!

Deleting rows in a Data Table

Hi @RPA_Path, I would recommend you use the Filter Datatable Activity. Compare dates and where Date column is equal to your comparision, choose to remove that row. Finally, save the filtered datatable to the same variable as your input datatable. Essentially, you are filtering your input datatable. [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 | 16 April 2022

Top 3 Topics with Most Views

Generate Data Table from Clipboard made by @Likesh_Lim with 29 views.

How to open recently downloaded Excel file while getting errors? made by @zeynepnaz.yardim with 28 views.

NOT ABLE TO SEND SMTP MAIL made by @Syed_Husnain_Ali with 27 views.

Top 3 Topics with Most Replies

How to open recently downloaded Excel file while getting errors? made by @zeynepnaz.yardim with 12 replies.

Generate Data Table from Clipboard made by @Likesh_Lim with 9 replies.

The rpc server is unavailable made by @fairymemay with 8 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 18 posts!

@jack.chan made 11 posts!

@Nithinkrishna made 9 posts!

Top 3 Most Liked Posts

This post made by @sssi received 1 likes!

Is there a way to run the robot in the cloud, not locally, when using the orchestrator api?

Hello I deploy the package to the orchestrator, and the process was executed in my local PC when external server requests the below cloud consuming api. POST startJobs API https://cloud.uipath.com/[serviceName]/[tenantName]/odata/Jobs/UiPath.Server.Configuration.OData.StartJobs When external server sends an API request, the process runs on my local PC where the machine is installed. But, I can’t turn on my local PC all the time, so I want it to run in the cloud. In short, Is…

This post made by @Jesmine received 1 likes!

For each loop in group wise

Hi Thanks all for your wonderful supports. Can you tell me how can I get the first value from the group? like first flower then book and then pen like this

This post made by @Nithinkrishna received 1 likes!

For each loop in group wise

Hey @Jesmine Try using the Group Linq dt_input.AsEnumerable.GroupBy(Function(row) row("Name").ToString) The above statement will provide you a collection of grouped items (3items for above example) with Name as key Store the above result in a variable & use it in foreach collection & then you will be going for one more foreach inside it. What I can suggest is, if you can let us know what’s the actual business logic after grouping what should be done. We can think of or build using Linq itse…

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 1 likes!

The rpc server is unavailable

Remove process and keep it empty And mention ProcessName as “Excel” @fairymemay

This solution provided by @jack.chan received 1 likes!

How to open recently downloaded Excel file while getting errors?

you can try use my component https://marketplace.uipath.com/auth/refresh-session?url=/listings/handle-popups-such-as-update-links-popup

---

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

Top 3 Topics with Most Views

Browser click made by @A_Learner with 40 views.

Getting Error. cannot find an asset with this name in Get Credential activity made by @mail4bobbysam with 34 views.

Next activates after (Continue) activity still exected made by @Mohammed_Bakr with 34 views.

Top 3 Topics with Most Replies

Getting Error. cannot find an asset with this name in Get Credential activity made by @mail4bobbysam with 19 replies.

Classic Activity Selector not dynamic how to fix it? made by @Mystical_Devices with 10 replies.

How to copy and paste specific dynamic range- only 1 column in Excel? made by @zeynepnaz.yardim with 9 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 16 posts!

@mail4bobbysam made 12 posts!

@Mystical_Devices made 9 posts!

Top 3 Most Liked Posts

This post made by @A_Learner received 2 likes!

Browser click

Hi, I am opening chrome browser with open browser, maximizing window and doing clicks. This works fine when there is only one Chrome browser window open. If I have other Chrome windows open when I am running the bot, it cannot find elements properly. Do you have any suggestions? Thanks a lot,

This post made by @mail4bobbysam received 2 likes!

Getting Error. cannot find an asset with this name in Get Credential activity

Getting Error. cannot find an asset with this name in Get Credential activity. Went thru similar posts in uipath forum and google and youtube but did not help. Anybody kindly advise?

This post made by @lakshman received 1 likes!

Is there a way to run the robot in the cloud, not locally, when using the orchestrator api?

@sssi Have a look below thread. Note: Currently it is in community preview but not released in Enterprise level.

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Is there a way to run the robot in the cloud, not locally, when using the orchestrator api?

Hey @sssi You may need to enable either of the options as below, Have a windows VM server and install UiPath robot in it, connect the robot to the orchestrator with an Un-Attended bot license which will help you to trigger the bot remotely using API Use UiPath cloud managed robot where you no need to have any VM but just the configuration in the cloud orchestrator to trigger the bot remotely using API Hope that helps. Thanks #nK

This solution provided by @Yoichi received 1 likes!

Generate Data Table from Clipboard

Hi, Wizard of GenerateDataTable activity doesn’t support TAB character (chr(9)) as input. So it works in actual workflow. Can you try the following sample, then check result xlsx? [img20220417-1] Sample20220416-1.zip (4.5 KB) 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 | 18 April 2022

Top 3 Topics with Most Views

How to save each mail as list of mail message made by @Debojyoti_chanda with 38 views.

Filter DataTable activity? made by @fairymemay with 37 views.

UI Selector made by @dylankiu with 36 views.

Top 3 Topics with Most Replies

Multiple bot run and share consolidate report at the end made by @Aleem_Khan with 15 replies.

StudioX Outlook ポップアップが押せない made by @megumi-aritomi.yh with 15 replies.

How to save each mail as list of mail message made by @Debojyoti_chanda with 14 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 36 posts!

@Nithinkrishna made 31 posts!

@lakshman made 29 posts!

Top 3 Most Liked Posts

This post made by @Nithinkrishna received 4 likes!

How to Send email copying (cc) from rows("code") as Cc recipients

Hey @RPA-botDev If you want to send for all recipients at once, kindly try the below… String.Join(";", dt_Mails.AsEnumerable.Select(Function(row) row("CodeEmail").ToString.Trim)) Pass the above statement in the send mail CC property. Hope this helps. Thanks #nK

This post made by @athira.somasekharan received 3 likes!

How to Send email copying (cc) from rows("code") as Cc recipients

Hello, If you are sending for each recipients, inside for each row you can get the mail id and use send email activity. If you are sending the mail together to all the recipients, inside for each loop use an assign activity and append all the emails together like this: [image] Don’t forget to initialise the CCEmail variable will empty quotes ("") In the end, pass the variable to cc property while sending mails. Thanks! Athira

This post made by @Byra_Padha_Saradhi received 3 likes!

Please tell me how to run a process in modern folder?

have created one modern folder and assigned machine and unattended [robot] to the modern folder. when i tried to run that process it went to pending state. it’s not going to running state or stopped state.

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 3 likes!

How to Remove Rows in Datable, if it contains a line break

Hi Did we refer this thread where we can use FILTER DATATABLE activity with contains Cheers @Shinjid

This solution provided by @jack.chan received 3 likes!

Filter DataTable activity?

do this…@fairymemay this will handle 1 or more values and you dont have to change anything in the code Sequence.xaml (7.6 KB) this line of code lets us filter using 1 line: dt = dt.Select("[Type]='ii' or [Type]='text'") how to generate the above code?? example : config condition= “ii or text” [image] declare list variable filterList and string filterString [image] loop over System.Text.RegularExpressions.Regex.Split(condition, " or ").ToList , for each iteration add "[Type]='"+ite…

This solution provided by @Palaniyappan received 2 likes!

Pros and cons of using 365 activities over excel activities

Hi Microsoft Office 365 is a cloud-based subscription service that brings together the best tools for the way people work today. By combining best-in-class apps like Excel and Outlook with powerful cloud services like OneDrive and SharePoint, Office 365 lets anyone create and share anywhere on any device. Pros The Microsoft Office 365 Activities Package gives you the ability to automate interactions with Office 365 applications. Integrating with the Microsoft Graph API, this activities p…

---

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

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

[system]

Daily Forum Report | 19 April 2022

Top 3 Topics with Most Views

Output of my web scraping data is repeating twice made by @Himanshu_Singh2 with 41 views.

If Hidden Sheet is Not Detected, made by @WS_Chai with 37 views.

100% retry rate means 0 retries? made by @mail4bobbysam with 35 views.

Top 3 Topics with Most Replies

Copy values of particular column and paste the column values all at a time in SAP made by @Sirisha_Siri with 23 replies.

Output of my web scraping data is repeating twice made by @Himanshu_Singh2 with 20 replies.

UiPath Identity Server URL: "You do not have permission to view this directory or page" made by @Andra_Necula with 15 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 42 posts!

@jack.chan made 29 posts!

@ppr made 23 posts!

Top 3 Most Liked Posts

This post made by @happyfeat87 received 3 likes!

Not able to create bank with Create a new bank (BAPI, Tcode: FI01) pacakage

@Nithinkrishna . The issue was in config . Commit option was blank. It should be set to X. [image]

This post made by @jordanhaggett received 2 likes!

Issue in send smtp mail message

Hello everyone, Just incase anyone comes across this post again while looking for a solution, I spoke to UiPath today and they gave me the below advise on fixing the issue. Hope it helps someone! ############################################################ Regarding the issue you described in the ticket description, we would like to ask you to do the following: Kill the Assistant process to make UiPath.Service.UserHost.exe free from parent Assistant Start UiPath.Service.UserHost.exe standal…

This post made by @Marius_Puscasu received 2 likes!

100% retry rate means 0 retries?

Hello @mail4bobbysam , Retry Rate Enables you to see your successfully processed queue items broken down according to the number of retries. The number of retries for successfully executed items are also taken into account in this widget. You can filter out states by clicking the labels below the chart. In your case, 100% of the processes have 0 retries… Source: https://docs.uipath.com/orchestrator/v0/docs/monitoring-queues#retry-rate Best regards, Marius

Top 3 Most Liked Solutions

This solution provided by @happyfeat87 received 3 likes!

Not able to create bank with Create a new bank (BAPI, Tcode: FI01) pacakage

@Nithinkrishna . The issue was in config . Commit option was blank. It should be set to X. [image]

This solution provided by @Yoichi received 1 likes!

How to read a e-mail between dates and time?

Hi, Can you try to use ToString(“d”) instead of ToString(“dd/MM/yyyy”) as the following? "[Received] >= '" + DateTime.Today.AddDays(-1*BackDate).ToString("d") + " 00:00AM' AND [Received] <= '"+ DateTime.Today.ToString("d") + " 09:00PM'" Regards,

This solution provided by @lakshman received 1 likes!

Filter by use Directory.GetFiles?

@fairymemay You mean want to filter text files whose name is equal to Report ? If yes then try below expression. Directory.GetFiles("FolderPath",varFile+"*.txt") Here, varFile = Report

---

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

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

[system]

Daily Forum Report | 20 April 2022

Top 3 Topics with Most Views

Sum of datatable column using C# uipath made by @Ram_Gurav1 with 49 views.

Unable to create selector made by @Shoebmd with 46 views.

Could someone help me with this? It's urgent made by @anjasing with 39 views.

Top 3 Topics with Most Replies

Sum of datatable column using C# uipath made by @Ram_Gurav1 with 19 replies.

Convert data in columns into having 2 decimal places (possibly using LINQ) made by @beepboop with 18 replies.

DATA SCRAPING NOT WORKING BECAUSE NEXT PAGE BUTTON NOT VISIBLE made by @nr.arinaazizi with 18 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 47 posts!

@lakshman made 46 posts!

@supermanPunch made 33 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 3 likes!

Error with SAP logon and parameter

@Lynx Hello, as far as I can see it is not possible to set arguments at the SAP Logon Path, only a filename. That’s why this approach can’t work on that way. @jack.chan suggestion sounds interesting, to use a shortcut in this context. Let us know your result, I have never tried that. Please take a look at the SAP Documentation, it is possible to set an environment variable to solve your requirement. Best regards Stefan

This post made by @LevKushnir received 3 likes!

Selecting Field instead of table in SAP VA01 for Sales Order Creation

HI @jmcheong7 The solution: SAP Scripting must be enabled on Server side. See the link from @lakshman (thanks) and also thanks to @jack.chan Best regards, Lev

This post made by @jack.chan received 2 likes!

Error with SAP logon and parameter

@Lynx not sure if this will work but can you try go to Security tab and copy the shortcut link and try use that instead? e.g. in screenshot my shortcut is C:\users\desktop\brave.lnk [image]

Top 3 Most Liked Solutions

This solution provided by @jack.chan received 2 likes!

Error with SAP logon and parameter

@Lynx not sure if this will work but can you try go to Security tab and copy the shortcut link and try use that instead? e.g. in screenshot my shortcut is C:\users\desktop\brave.lnk [image]

This solution provided by @Nithinkrishna received 2 likes!

Help with regex to extract number following a particular word

Hey @MasterOfLogic Kindly try the below. (?<=Zestimate®)\$\d+(,|\d)*\.*\d* Thanks #nK

This solution provided by @Arvind_Kumar1 received 2 likes!

How to change the date format from datepicker control

Hello @anit.michael , You can’t apply date format into Apps right now as function is not available. But you can pass the selected app date as Input to Process and apply the format into Process as dd.MM.yyyy Thanks, AK

---

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

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

[system]

Daily Forum Report | 21 April 2022

Top 3 Topics with Most Views

Ignore Folders from Publish made by @lakshman with 58 views.

Terminal Session: Method not found made by @Crestyan with 43 views.

How to delete old File made by @AaronMark with 35 views.

Top 3 Topics with Most Replies

Ignore Folders from Publish made by @lakshman with 16 replies.

How to select upload in Browser made by @LeTH23 with 15 replies.

Queue items not getting processed Correctly made by @mail4bobbysam with 15 replies.

Top 3 Users Who Posted The Most

@lakshman made 48 posts!

@Nithinkrishna made 37 posts!

@Rahul_Unnikrishnan made 25 posts!

Top 3 Most Liked Posts

This post made by @ptrobot received 3 likes!

Ignore Folders from Publish

Some of our customers don’t want sensitive data uploaded to Orchestrator Cloud. So it would be good e.g. to be able to exclude the whole .screenshots folder. What we have done before is to delete the .screenshot folder completely which makes debugging very hard.

This post made by @lakshman received 3 likes!

Ignore Folders from Publish

@alexandru One more thing Documentation folder contains one file related to ReFramework documentation. It’s also not required for actual process to run.

This post made by @lakshman received 2 likes!

Ignore Folders from Publish

@alexandru In ReFramework project template, we have folder called Test and it contains all test cases related xaml files. We may required these files in later stage if we want to do any enhancements to the existing code and do testing but it’s not required for actual process to run in the production.

Top 3 Most Liked Solutions

This solution provided by @jack.chan received 2 likes!

Convert data in columns into having 2 decimal places (possibly using LINQ)

then just remove the comma like this . dt.AsEnumerable().ToList().ForEach(Sub(row) If row("Deposit").tostring.contains(".") Then row("Deposit")= Convert.ToDouble(row("Deposit")).ToString("N2").Replace(",","") End If If row("Withdrawal").tostring.contains(".") Then row("Withdrawal")= Convert.ToDouble(row("Withdrawal")).ToString("N2").Replace(",","") End If End Sub )

This solution provided by @ppr received 2 likes!

How to filter out and retain different duplicates in a column in Excel and do certain operations with it

assign Activity: LHS: dictReport | Dictionary(of String,Int32) RHS: (From d in dtData.AsEnumerable Let dp = DateTime.ParseExact(d("Judge Date").toString.Trim, "yyyy-MM-dd HH:mm", System.Globalization.CultureInfo.InvariantCulture) Group d by k=dp.Date into grp=Group Let fc = grp.Where(Function (x) x("Result").toString.Trim.ToUpper.Equals("FAIL")).Count Select t = Tuple.Create(k.toString("yyyy-MM-dd"), fc)).ToDictionary(Function (t) t.Item1,Function (t) t.Item2) We would assume that the date …

This solution provided by @athira.somasekharan received 1 likes!

Optimize your robot

Hello @mateo.drouillard , It depends on the usecase. If you are absolutely sure about the selectors, you can use click activity with simulate click enabled. But in case of citrix environment it is more reliable to use send hotkeys. About optimising processes, you can check the below points: If no ui interaction is required, use background processes. Try to avoid hardcoded delays as much as possible. If you think a particular screen might take some time to load, use timeout instead of delays. …

---

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

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

[system]

Daily Forum Report | 22 April 2022

Top 3 Topics with Most Views

Community Edition バージョンアップデート後（v2022.4)、急にロボットがエラーで停止 made by @nosawa with 48 views.

How to know the column count of a specific column? made by @wdescalsota with 41 views.

Regex Match issue made by @ravindar.singh with 40 views.

Top 3 Topics with Most Replies

Add time to TimeVariable made by @rahul_gola with 17 replies.

Automation running time and failure made by @mumin with 13 replies.

How to know the column count of a specific column? made by @wdescalsota with 12 replies.

Top 3 Users Who Posted The Most

@lakshman made 48 posts!

@Rahul_Unnikrishnan made 38 posts!

@Nithinkrishna made 30 posts!

Top 3 Most Liked Posts

This post made by @LevKushnir received 3 likes!

SAP logon using UiPath accelerators

Hi @happyfeat87 Agree 100% with @Nithinkrishna " There is a manual documentation attached in the listing." Please read the documentation first, as in most cases you do not need to take care about LOGON as it will be done for you in background. Or even better, check this video UiPath SAP Accelerators - BAPI_REQUISITION_CREATE | SAP S/4HANA - YouTube from @gabi_verzea and learn in 15 Minutes all about UiPath Accelerators. Best regards, Lev

This post made by @Nithinkrishna received 2 likes!

SAP logon using UiPath accelerators

Hey @happyfeat87 There is a manual documentation attached in the marketplace listing. Kindly go through it, if still no help let me know and show some screenshots of the workflow we can check it. Thanks #nK

This post made by @LevKushnir received 2 likes!

SAP automation - selector query - very big selectors

HI @gokul1904 Here is the answer: I would say, even SAP IDs are up to 99,9% stable and reliable. It does not matter how long/big it is. You as a User doing automation, I as a UiPath taking care about technique in background. No worries at all. UiPath is certified by SAP for SAP WinGUI automation. Thanks @amalmarella & @lakshman ! Best regards, Lev

Top 3 Most Liked Solutions

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

Password is not able to retrieve using get asset

Hi @Swathi_U Since it’s a username and password Kindly use Get credentials activity Get assset retrieves only single value and it can’t hold username and password

This solution provided by @Yoichi received 1 likes!

Regex Match issue

Hi, regex101 is not 100% compatible with .net regex. Can you try it in regex wizard of matches activity or .net compatible regex test site? Regards,

This solution provided by @lakshman received 1 likes!

Get last 3 characters from string excepting the last 1 character

@RPA-botDev Try below expression. strInput.Substring(strInput.Length-4,3) Here strInput variable holds your input string.

---

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

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

[system]

Daily Forum Report | 23 April 2022

Top 3 Topics with Most Views

How to get the cell value? made by @mohamedalthaf with 37 views.

How to excel file contains Multiple columns with same name made by @Ranganathan_M with 36 views.

If Else and Elseif Condition in linq made by @Shyam_Pragash with 34 views.

Top 3 Topics with Most Replies

2 output to message box help made by @MikeC with 28 replies.

Use Application/Browser Activity not getting processed made by @vishnu5 with 15 replies.

I want to pass last row as header made by @Divya_Sadhasivam with 10 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 19 posts!

@MikeC made 16 posts!

@athira.somasekharan made 10 posts!

Top 3 Most Liked Posts

This post made by @opkushwaha999 received 2 likes!

Unable to solve the excel task. what activities to use?

Marksheet Data__ (1) (1).xlsx (13.9 KB) unable to solve to problem .Requirement is on the other sheet(Description sheet) help out guys

This post made by @Mike_Campbell received 1 likes!

Chrome extension malfunction after auto-update to 22.4

@Werve - This 98% resolved my issue! I’m going to be a bit more explicit in steps for those trying to follow: From the workstation I followed these steps: Opened Chrome and REMOVED/Uninstalled the broken Chrome Extension. Close Chrome In Start menu, I right-clicked Studio shortcut, clicked More>Open File Location One layer deeper, I right-clicked the Studio shortcut again, selected >Open File Location That opened an explorer window in my case to… C:\Users[my name]\AppData\Local\Programs\Ui…

This post made by @Nithinkrishna received 1 likes!

Unable to solve the excel task. what activities to use?

Hey @opkushwaha999 You will need to use a combination of for-each, if, assign Thanks #nK

Top 3 Most Liked Solutions

This solution provided by @Mike_Campbell received 1 likes!

Chrome extension malfunction after auto-update to 22.4

@Werve - This 98% resolved my issue! I’m going to be a bit more explicit in steps for those trying to follow: From the workstation I followed these steps: Opened Chrome and REMOVED/Uninstalled the broken Chrome Extension. Close Chrome In Start menu, I right-clicked Studio shortcut, clicked More>Open File Location One layer deeper, I right-clicked the Studio shortcut again, selected >Open File Location That opened an explorer window in my case to… C:\Users[my name]\AppData\Local\Programs\Ui…

This solution provided by @Nithinkrishna received 1 likes!

Filter email (Subject)

Hey @fairymemay Try adding nested condition with second variable by using AND OR Thanks #nK

This solution provided by @athira.somasekharan received 1 likes!

2 output to message box help

Glad it worked! For new line use like this: CompanyName(0).ToString + Environment.NewLine+CompanyEmail(0).ToString Thanks! Athira

---

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

Top 3 Topics with Most Views

Manipulation of excel made by @manoj_verma1 with 40 views.

Select file activity shows error made by @emon.matlab with 33 views.

Excel Replicate values for empty cells made by @satish_kumar with 33 views.

Top 3 Topics with Most Replies

For each sheet is giving incorrect result made by @WS_Chai with 15 replies.

Excel write to first free row on column help made by @MikeC with 13 replies.

I cant import web data to excel made by @Ozlem_Yigit with 7 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 19 posts!

@jack.chan made 11 posts!

@Nithinkrishna made 11 posts!

Top 3 Most Liked Posts

This post made by @ptrobot received 2 likes!

What is the most effective way to handle date strings which expected format is dd/MM/yyyy but come as d/M/yyyy

Just use "d/M/yyyy". It can handle both 05/05/2022 and 5/5/2022.

This post made by @MasterOfLogic received 1 likes!

What is the most effective way to handle date strings which expected format is dd/MM/yyyy but come as d/M/yyyy

wowu! why didn’t i think of this … thank you so much , works @ptrobot

This post made by @jon4378 received 1 likes!

HTTP Request: Passing Parameters in Body

Sure, you can find it here. [Screen Shot 2022-04-24 at 12.22.36 PM]

Top 3 Most Liked Solutions

This solution provided by @ptrobot received 2 likes!

What is the most effective way to handle date strings which expected format is dd/MM/yyyy but come as d/M/yyyy

Just use "d/M/yyyy". It can handle both 05/05/2022 and 5/5/2022.

This solution provided by @jack.chan received 1 likes!

Select file activity shows error

because you assign ( From row in AllDistrict.AsEnumerable() Select Convert.Tostring(row(“District”)) ).ToList() to default value of AllDistrict, which will fail because allDistrict is null until the read CSV activity try delete the default value of DistrictList and only assign it after read CSV [image]

This solution provided by @jack.chan received 1 likes!

I cant import web data to excel

can you try this? i just added some retry logic in case it fails because its working fine for me DergiPark.xaml (27.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 | 25 April 2022

Top 3 Topics with Most Views

After updating v2022.4, the robot stops with an error "The workbook dose not exist." made by @nosawa with 49 views.

Dt issue made by @manoj_verma1 with 46 views.

Logic related question made by @meeraa with 41 views.

Top 3 Topics with Most Replies

License Issue, Uipath Robot does not exist made by @PALKUMARI_PATEL with 20 replies.

Access to Data Service with Power Bi made by @Benjamin_Wurth with 18 replies.

Postman, Swagger showing You are not authenticated! made by @Sanjit_Pal1 with 14 replies.

Top 3 Users Who Posted The Most

@ushu made 40 posts!

@Nithinkrishna made 38 posts!

@lakshman made 28 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Getting List of Duplicate Rows with Unique Multiple Columns - LINQ

give a try at: (From d in dtData.AsEnumerable Let sk = String.Join("_",{“UID”,“Name”,“Gender”,“Age”}.Select(Function (x) d(x).toString.Trim)) Group d by k=sk into grp = Group Where grp.Count > 1 From g in grp Order by dtData.Rows.IndexOf(g) Select r=g).CopyToDataTable

This post made by @Ioana_D received 2 likes!

Extract entire line containing keyword

That works, thanks a lot!

This post made by @athira.somasekharan received 2 likes!

How to know if I am in the first row of a data table?

Hello @Lynx , Instead of for each loop, use For Each Row activity and in the property, assign a variable to index. Inside the loop, use an if condition to check if IndexVariable=0 Thanks! Athira

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Getting List of Duplicate Rows with Unique Multiple Columns - LINQ

give a try at: (From d in dtData.AsEnumerable Let sk = String.Join("_",{“UID”,“Name”,“Gender”,“Age”}.Select(Function (x) d(x).toString.Trim)) Group d by k=sk into grp = Group Where grp.Count > 1 From g in grp Order by dtData.Rows.IndexOf(g) Select r=g).CopyToDataTable

This solution provided by @athira.somasekharan received 2 likes!

How to know if I am in the first row of a data table?

Hello @Lynx , Instead of for each loop, use For Each Row activity and in the property, assign a variable to index. Inside the loop, use an if condition to check if IndexVariable=0 Thanks! Athira

This solution provided by @jack.chan received 2 likes!

Error Input string was not in a correct format?

sorry try this DT_Detail.AsEnumerable().Where(function(z) not z("APAPDT").ToString.Equals("") and not z("PAID_DATE").ToString.Equals("")).CopyToDataTable().AsEnumerable().Where(Function(w) Convert.ToInt32(w("APAPDT").ToString.Trim) >= startDatePeriod And Convert.ToInt32(w("APAPDT").ToString.Trim) <= endDatePeriod And Convert.ToInt32(w("PAID_DATE").ToString.Trim) >= startDatePeriod And Convert.ToInt32(w("PAID_DATE").ToString.Trim) <= endDatePeriod).CopyToDataTable()

---

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

Top 3 Topics with Most Views

How to find the middle date of the month? made by @Unknown_User with 47 views.

How to handle this made by @manoj_verma1 with 43 views.

Insert values in two cells horizontally + Skip a column made by @beepboop with 39 views.

Top 3 Topics with Most Replies

How to generate table for the data available in excel? made by @PALKUMARI_PATEL with 20 replies.

I am unable to delete a column from excel file downloaded on runtime through uipath.....how i can use the file downloaded on runtime and can make changes made by @mu_nazza with 19 replies.

Published package does not appear in Orchestrator made by @Rodrigo_Buch with 15 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 43 posts!

@jack.chan made 32 posts!

@ushu made 24 posts!

Top 3 Most Liked Posts

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

Reboot Your Skills Program - Let us know who YOU are!

Hello everyone! Welcome to the Reboot Your Skills program! We are so glad you’re here. Thousands of people around the world have signed up for this 10-days learning program to learn how to build their first automations with StudioX. As we get started, we’d love to learn a little more about everyone that’s joining us on this RPA learning journey. How about the following to get us introduced : What’s your name? What kind of work do you do? Where are you based? Why do you …

This post made by @ashutoshkhantwal received 1 likes!

Distinct values in a datatable

I hope you might have resolved this already? apologies for replying this late.

This post made by @kiarodelalune received 1 likes!

Can't Find "Excel Application Scope" Option In UI Path

THIS IS THE BEST SOLUTION.

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

FileInfo Argument don't pass

please check again the argument direction settings. for returning back a value we would set it at least to out direction

This solution provided by @athira.somasekharan received 1 likes!

Add automatic item in dispatcher queue

Hello @RENU_KHALKHO , You can use File change trigger for this. [image] Thanks! Athira

This solution provided by @Nithinkrishna received 1 likes!

Assets failing

Hey @Short Also check access as I said please… The role assigned to your robot should have Write Asset Access Thanks #nK

---

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

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

[system]

Daily Forum Report | 27 April 2022

Top 3 Topics with Most Views

Replace dot with comma made by @yulya with 49 views.

UiPath Assistant not opening made by @Nelson.R with 49 views.

How to Add a variable to json config made by @vishal_nachankar with 45 views.

Top 3 Topics with Most Replies

How to Add a variable to json config made by @vishal_nachankar with 26 replies.

In this String "AB0610E001" I am using "Str.Substring(Str.Length -6)" this expression to get the last 6 digits of the String like this "10E001" but meanwhile i am entering it into excel cell i am getting like number value "100" made by @Gopikrishna_S with 19 replies.

Using a Variable value as a clicking selector? made by @dr1992 with 14 replies.

Top 3 Users Who Posted The Most

@jack.chan made 32 posts!

@lakshman made 32 posts!

@Nithinkrishna made 28 posts!

Top 3 Most Liked Posts

This post made by @ppr received 10 likes!

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues

This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in hurry: Example Assignment Following Excel data will be processed and the corresponding Quarter is to calculate for the particular task date Input data: [input_raw] Quarter Calculation Quarter = CInt(Math.Ceiling(YourDateTimeVar.Month / 3 )) Initial Implementation [initial_flow_raw] tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", Culture…

This post made by @user123mem received 2 likes!

How to read and open folder files path inside Excel

Hi this works ! Thanks !!

This post made by @kali received 2 likes!

How to activate "Simulate Type" in the new version of "Type Into"

It’s there for me. [image]

Top 3 Most Liked Solutions

This solution provided by @postwick received 2 likes!

Click on Specific name, fetching from Queue

As another possible option, does the web page have search functionality? If so, you could perform a search for the employee name so it is the only one shown on the page, then click it.

This solution provided by @Nithinkrishna received 1 likes!

"Couldn't find any user with unattended robot permissions in the current folder. (#1671)"

Hey @B_Bastien Triggering from orchestrator is an Un-Attended approach as you are triggering from a remote source. The only way to trigger an attended bot is by using UiPath Assistant or Robot JS, from the same machine where the bot resides. Hope you get it Thanks #nK

This solution provided by @kali received 1 likes!

How to activate "Simulate Type" in the new version of "Type Into"

If u want to use special keys like: enter u should use hardware type. and if u want to use simulate type, you should set your Click before typing to none.

---

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

Top 3 Topics with Most Views

How to use replace for double quotes made by @kavya.s16 with 47 views.

I'm having trouble with "Get Text" made by @Ozlem_Yigit with 42 views.

How to replace last two digits with 00? made by @HeartCatcher with 41 views.

Top 3 Topics with Most Replies

How to use replace for double quotes made by @kavya.s16 with 18 replies.

How to Split and store DataTable? made by @vip.thsantos with 16 replies.

Not able to pass variable/argument in connection string made by @Ulhas_Guttikar with 16 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 34 posts!

@Yoichi made 25 posts!

@supermanPunch made 23 posts!

Top 3 Most Liked Posts

This post made by @Mark.Edgeller received 3 likes!

Ignore Folders from Publish

This would be fine, but adds administrative overhead unnecessarily. The UiPath implementation of version control will not correctly handle a GIT repository being set as anything other than the project folder. So if this documentation/tests need to be version controlled, storing them elsewhere is not a good idea.

This post made by @StefanSchnell received 2 likes!

UiPath Stuido With SAP GRC

SAP Governance, Risk and Compliance (SAP GRC) is a security tool which can be used to ensure companies to meet data security and authorization standards.

This post made by @LevKushnir received 2 likes!

UiPath Stuido With SAP GRC

HI @s.swapna8 You can automate any SAP Process and any SAP Use Case. UiPath supports automation across all SAP user interfaces, therefore we do not have any specific limitation to any specific use case and whatever SAP automation you see in the internet is also valid for your use case. One of examples is here: See Automate SAP S/4HANA business processes across all user interfaces at UiPath EMEA&APAC Virtual Events Automation across all SAP interfaces. If you like, share your business proces…

Top 3 Most Liked Solutions

This solution provided by @LevKushnir received 2 likes!

UiPath Stuido With SAP GRC

HI @s.swapna8 You can automate any SAP Process and any SAP Use Case. UiPath supports automation across all SAP user interfaces, therefore we do not have any specific limitation to any specific use case and whatever SAP automation you see in the internet is also valid for your use case. One of examples is here: See Automate SAP S/4HANA business processes across all user interfaces at UiPath EMEA&APAC Virtual Events Automation across all SAP interfaces. If you like, share your business proces…

This solution provided by @Yoichi received 2 likes!

Check string using contain

Hi, Because you use ToUpper method and it returns true as Indonesia. I think it’s better to use regex as the following. System.Text.RegularExpressions.Regex.IsMatch(varString,"\bDone\b",System.Text.RegularExpressions.RegexOptions.IgnoreCase) This returns true if “done” (Case ignored) exists as a word. Regards,

This solution provided by @Nithinkrishna received 1 likes!

How to handle Robot in another server?

Hey @MasterSinge Just create a machine template in the orchestrator and allocate Un-Attended license to it Create a robot user with the same user name of your robot machine (go to cmd in robot machine → whoami) Copy the machine key and open the remote robot assistant → Preferences and provide URL and key The bot will now get connected and can be mapped to any folder for running a process Hope this helps Thanks #nK

---

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

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

[system]

Daily Forum Report | 29 April 2022

Top 3 Topics with Most Views

UIPath 2022.4 Open aplication Activity - Could not find the UI element corresponding to this selector made by @jobs.tagif with 47 views.

Can you any one solve this error made by @divya.paul with 45 views.

SQL Table to csv with delimiters made by @aishwarya1 with 42 views.

Top 3 Topics with Most Replies

Add Serial Number to an already existing Datatable made by @RPA-botDev with 15 replies.

SQL Table to csv with delimiters made by @aishwarya1 with 14 replies.

UIPath 2022.4 Open aplication Activity - Could not find the UI element corresponding to this selector made by @jobs.tagif with 13 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 34 posts!

@nikhil.girish made 19 posts!

@Nithinkrishna made 16 posts!

Top 3 Most Liked Posts

This post made by @Ollie_King received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello! I am a new UiPath Developer for USDA and looking forward to the “Reboot Your Skill” course starting Monday, May 2, 2022! See you there! ~Ollie King

This post made by @StefanSchnell received 2 likes!

Code Generator for the Invoke Code Activity to use SAP RFC Function Modules Easily

@happyfeat87 Hello Happy, sure, open the application and insert your RFM, in your case BAPI_PROFITCENTERGRP_CREATE. [image] Double click on the name in the list and press the button Generate Excel. [image] And therewith you get an Excel sheet with all preparations to use it as an SAP accelerator. [image] Best regards Stefan

This post made by @Lynx received 2 likes!

Try catch is not catching the error

Apparently it was because it was running in debug, so the bot stopped. I tried with run and if the try catch works for me [imagen]

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

SQL Table to csv with delimiters

Hey @aishwarya1 Ok I guess it’s due to collection - so now it’s just converted to iEnumerable of column, String.Join(",",dt_DbData.Columns.Cast(Of DataColumn).Select(Function(col) """"+col.ColumnName+"""")) Thanks #nK

This solution provided by @fernando_zuluaga received 1 likes!

Try catch is not catching the error

the try catch activity will cath the first exception that will appear inside the try block, no matter how much secuences you have, if the first secuence throw and error, the rest will not execute and will go to the catch block, if you need to catch 2 secuence then you need to use 2 differents try catch Regards

This solution provided by @ptrobot received 1 likes!

Add Serial Number to an already existing Datatable

Then the suggestion from @kumar.varun2 should work fine. Depending on the column type of “S/N”, you might also need to convert sn to a string first. DT.rows.Add(New Object(){sn.ToString, row.item(“Name”), row.item(MobileNumber)})

---

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

Top 3 Topics with Most Views

Standalone option -UiPath made by @Anjali_Rani with 38 views.

Click on elements by putting condition! made by @Althaf_nazeer_Nazeer with 31 views.

Excel Auto made by @AsadPathan2665 with 29 views.

Top 3 Topics with Most Replies

Standalone option -UiPath made by @Anjali_Rani with 15 replies.

「繰り返し各行」を使ってデータをDictionary型に代入しようとしても、1行目のみが繰り返し代入される。 made by @NTNTNT with 14 replies.

Please Give me an idea about how to approach this Process, if Possible an Example Xaml made by @Bhagyaraj_Digumarthi with 6 replies.

Top 3 Users Who Posted The Most

@Yoichi made 13 posts!

@ushu made 12 posts!

@Rahul_Unnikrishnan made 9 posts!

Top 3 Most Liked Posts

This post made by @westcoasthoover received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, I am with a company who is an Enterprise client and am using the community edition for training purposes. I am a non-programmer type and would like to learn rpa. I’m already stuck as the Automation cloud keeps signing me out of the session and I need to know why…so here I am!

This post made by @Yoichi received 2 likes!

I want to stop the process only if excel rows have status as CANCELLED is >60%? Please help with the query for excel

Hi, How about the following? [image] dt.AsEnumerable.Count(Function(r) r("Status").ToString="Canceled")/dt.Rows.Count>0.6 Regards,

This post made by @anjasing received 1 likes!

I want to stop the process only if excel rows have status as CANCELLED is >60%? Please help with the query for excel

Thank you so much for helping even on Saturday.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

I want to stop the process only if excel rows have status as CANCELLED is >60%? Please help with the query for excel

Hi, How about the following? [image] dt.AsEnumerable.Count(Function(r) r("Status").ToString="Canceled")/dt.Rows.Count>0.6 Regards,

This solution provided by @fernando_zuluaga received 1 likes!

Add Column with null values in a Data table

hey perhabs this is what you are looking for? [image] make sure to activate the allow null [image] regards!

This solution provided by @ushu received 1 likes!

How to add type into in sequence without open browser? or How to link 2sequences in such a way that open browser is not need to add again?

@Yash These activities has to be used within the Use Application/ Browser activity. There are two ways to achieve your scenario Approach1 You can use Type into without any Use Application/ Browser` activity. For this make sure you follow the below steps Go to the activities panel Click on the filter option at the top and enable Show Classic [Capture] Search for Type Into and you can see that activity under Classic. This helps you to use directly without any Use Application/ Browser activ…

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

@Yoichi received 52 likes for their solutions!

@lakshman received 37 likes for their solutions!

@Nithinkrishna received 37 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 May 2022

Top 3 Topics with Most Views

Reading a HTML and extracting information made by @RaVillalobos with 38 views.

Uipath extension Chrome made by @A_Learner with 38 views.

Uninstalling Uipath studio made by @Anjali_Rani with 34 views.

Top 3 Topics with Most Replies

Uninstalling Uipath studio made by @Anjali_Rani with 16 replies.

Scrape Sub Menu from Main Menu made by @CGhoST with 8 replies.

Getting error in Assign Activity while creating workflow for PDF reading made by @varun_shinde1 with 8 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 35 posts!

@Rahul_Unnikrishnan made 17 posts!

@jack.chan made 10 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 2 likes!

Experiment Proved that the Extraordinary in an Ordinary Environment does not Shine

Here a quotation of a post at LinkedIn which I read last week, with an interesting conclusion: A violinist played 45 minutes on the New York subway. 4 people stopped and one clapped, and the violinist managed to raise 20 dollars. The following night, the same violinist played in one of the most recognized stages in the world and charged a minimum of $100 per audience. The experiment proved that the extraordinary in an ordinary environment does not shine. There are brilliant professionals who…

This post made by @tile2 received 1 likes!

Element Exists Activity is missing?

Thank you for prompt reply btw, @nikhil.girish I really appreciate it!

This post made by @anoop.mohandas received 1 likes!

Close Tab: Cannot communicate with Internet Explorer browser (Using Chrome Browser)

I am getting the same error after I have updated the Uipath to 22.4 version. I have selected Browser Type as ‘Chrome’ for the Attach browser activity. This was working perfectly before I update the UiPath to 22.4 version [image] Please find the package version I was using in that process. [image] Also, After the update to new version 22.4 , I was getting the below error frequently. “Attach Browser ‘chrome.exe SpinTel’: Could not communicate with the UiPath extension for browser ‘chrome.e…

Top 3 Most Liked Solutions

This solution provided by @jack.chan received 1 likes!

Cron Expression for schedulding a bot daily 2 times a day

try 0 0 6,17 * * ? * [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 | 02 May 2022

Top 3 Topics with Most Views

Why is the uipath documentation site throwing an error? made by @KD11 with 52 views.

How to use filter Datatable activity made by @varun_shinde1 with 49 views.

TYPE INTO and CLICK made by @LUIS_REYES with 45 views.

Top 3 Topics with Most Replies

Remove everything after first phrase made by @CGhoST with 19 replies.

Urgent - Excel Folder Permission is not allowing any files to Write or change data made by @PALKUMARI_PATEL with 19 replies.

Get Max and Min Date in Column made by @mateo.drouillard with 16 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 38 posts!

@Rahul_Unnikrishnan made 30 posts!

@ushu made 23 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Get Max and Min Date in Column

Hi, Can you try the following expression? Max dt.AsEnumerable.Max(Function(r) DateTime.Parse(r(0).ToString)) Min dt.AsEnumerable.MIn(Function(r) DateTime.Parse(r(0).ToString)) The above returns DateTime type. If you need string please add .ToString Regards,

This post made by @Maria_Gutierrez received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Greetings, my name is Maria Gutierrez and I look forward to knowing more about UiPath and get certified in order to help businesses in their automation journey.

This post made by @raymond.haughton received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, I am Raymond. I am a freelancer. I helped a company automate one of their processes, but, I never got help build/write the commands for the robot. Which seems like the most interesting part to me!

Top 3 Most Liked Solutions

This solution provided by @jack.chan received 1 likes!

TYPE INTO and CLICK

you need to replace this with SelEstado i think… @LUIS_REYES [image] just replace the whole thing with this please… "<webctrl aaname='"+SelEstado+"' tag='A' type='' check:text='"+SelEstado+"' />"

This solution provided by @Yoichi received 1 likes!

How to find and filter out reverse of all a number in the column

Hi, Thank you for sharing your requirement. How about the following sample? [img20220502-3] Main.xaml (12.4 KB) Regards,

This solution provided by @Yoichi received 1 likes!

How to deserialize XML

Hi, In this case, we can get these value simply using Descendants method as the following. [img20220502-4] Sample20220502-3.zip (3.2 KB) 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 | 03 May 2022

Top 3 Topics with Most Views

Output data table with pipe delimiter made by @FMCgclifford with 54 views.

How to Convert any format Date(String Variable) into YYYYMMDD format made by @nilesh.mahajan with 37 views.

Unattended export logs made by @Etienne_Vahrmeijer with 36 views.

Top 3 Topics with Most Replies

Output data table with pipe delimiter made by @FMCgclifford with 19 replies.

Sort function for custom list in UiPath Apps made by @Kiruthika_Nithyanandan with 12 replies.

Not able to connect with The Tenant made by @Hugo_Thorschmidt with 11 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 45 posts!

@Rahul_Unnikrishnan made 29 posts!

@postwick made 15 posts!

Top 3 Most Liked Posts

This post made by @s_c2 received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello everyone My name is KelClarke. I am new to uipath and will like to discover rap and automation I am from WA, south

This post made by @Nithinkrishna received 2 likes!

Different machine with same username/domain

Hey @pratiksha_pawar Of course, yes. It should work. You can have it. Thanks #nK

This post made by @Athira received 2 likes!

Not able to find UiPath.Orchestrator.Cli.exe

I’m trying to upgrade orchestrator and i am not able to find UiPath.Orchestrator.Cli.exe to decrypt the UIPath.Orchestrator.dll.config

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 2 likes!

Different machine with same username/domain

Hey @pratiksha_pawar Of course, yes. It should work. You can have it. Thanks #nK

This solution provided by @CosminV received 2 likes!

Not able to find UiPath.Orchestrator.Cli.exe

The tool UiPath.Orchestrator.Cli.exe will be available for 2021.10+. If you are upgrading from 2021.4, you should use the procedure from the docs corresponding to that version: Encrypting UiPath.Orchestrator.dll.config Sections. Then you upgrade and you use the docs specific to the new version for encrypting the file back: Encrypting UiPath.Orchestrator.dll.config Sections

This solution provided by @Oana_Georgiana_Vasile received 2 likes!

Pending state stuck - Can't run processes with 2 different robot accounts sharing same NonProduction license

Found my issue. At the installation I had the User Mode checked, instead of Service Mode, now is working perfectly [image] [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.