Forum Engagement Daily Reports

[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] https://docs.uipath.com/activities/docs/file-change-trigger-v-2 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.

[system]

Daily Forum Report | 05 May 2022

Top 3 Topics with Most Views

Type Into/Click Element Visibility Issue made by @Joshua_Burton with 42 views.

Split String - after time and before dashes made by @chauhan.rachita30 with 42 views.

Dynamic file name in Config File made by @roberto.piccolli with 41 views.

Top 3 Topics with Most Replies

Assignment 2 - Issue made by @Sean_Ryan1 with 29 replies.

Outlook mail automation made by @afsaneh_keivani with 22 replies.

Getting error on office365 Get Mail activity made by @Poonam_Yadav with 18 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 64 posts!

@Rahul_Unnikrishnan made 30 posts!

@jack.chan made 23 posts!

Top 3 Most Liked Posts

This post made by @NIVED_NAMBIAR received 4 likes!

How to use Contains Help

Hi @punnipah use the regex for this, that would be good [image] adding the code for extracting the data assume the string which is used as input is stored in input1 variable use assign activity output1= System.Text.RegularExpressions.Regex.Match(input1,“abc\d{10}”).Value.ToString You can also use the matches activity for this as well Thanks & Regards, Nived N

This post made by @tracydixon received 2 likes!

Monthly Forum rewards - April 2022

Great job! Thank you for your contribution to the entire community, giving us all the opportunity to focus more on what matters.

This post made by @The_coder received 2 likes!

Get Outlook Mail Messages - item.date

Hi, There is a package issue with UiPath.Mail.Activities version 1.14.0-preview and 1.15.0-preview. Just downgrade package version 1.13.1-preview and it will work fine.

Top 3 Most Liked Solutions

This solution provided by @The_coder received 2 likes!

Get Outlook Mail Messages - item.date

Hi, There is a package issue with UiPath.Mail.Activities version 1.14.0-preview and 1.15.0-preview. Just downgrade package version 1.13.1-preview and it will work fine.

This solution provided by @fernando_zuluaga received 1 likes!

Activity open browser

hey welcome to our community check this [image] enable the classic activities and it will appear there, also remember that in moder experience the open browser activity is called Use application/Browser activity Regards!

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

How to make to continue on error while using the Wait Download Activity?

set timeout for wait for download activity [image] then put wait for download in try-catch under catch section, dont throw any exception. this means if theres no file after x seconds (set in timeout), bot will continue [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 | 06 May 2022

Top 3 Topics with Most Views

Confused in String made by @Himanshu_Pratap_Rana with 48 views.

How to click the latest elements in the web list made by @HuaiYe with 39 views.

Find account holder then select it made by @meeraa with 38 views.

Top 3 Topics with Most Replies

Get assets made by @happyfeat87 with 22 replies.

Confused in String made by @Himanshu_Pratap_Rana with 21 replies.

Time Format Convert in Linq made by @Shyam_Pragash with 18 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 68 posts!

@Nithinkrishna made 51 posts!

@postwick made 28 posts!

Top 3 Most Liked Posts

This post made by @Security_Kevin received 4 likes!

Path traversal vulnerability found in OWASP ESAPI Impact in UiPath products Orchestrator 2, Insights, AI center, action center, task capture, orchestrator, studio

No UiPath products currently leverage the org.owasp.esapi library, so there is no impact.

This post made by @Hendrix_Santos received 2 likes!

Transcribe a name correctly

Hello, I need to make a modification to a bank that I am creating. I downloaded a TXT directly from SAP and there is a name column where you can find abbreviated names and the site where I need to fill in the names, it can’t have abbreviation. How do I make Uipath read each row of the name column and all the names that I have abbreviated and leave it only with the full name? Example: Original TXT : Alana B. Santos Carlos C Costa Fernanda A. Garcia New database: Alana Santos Carlos Costa …

This post made by @Razvan_Dumitru received 2 likes!

Postman, Swagger showing You are not authenticated!

Hi @Sanjit_Pal1, You’re encountering this issue because the cookie isn’t present anymore. We recently moved from cookie to access token authentication. For replaying or edit & replay requests you might want to use Copy as fetch, Copy as cURL functionalities. Examples (in Chrome): 1. [image] 2. Navigate to Console 3. Paste [image] 4. Hit Enter 5. Check the Network tab and you’ll be able to find the request. Some guidance for multiple browsers: Edit and replay XHR chrome/firefox etc? -…

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Licenses classic vs modern folder

Yep @maxena2872 You are right, Thanks

This solution provided by @Nithinkrishna received 1 likes!

Copy sheets to a new workbook and rename the

Hey @Laura2 As per the activity docs, Copy Sheet will copy sheet in the same source sheet of there is no destination provided. Thanks #nK

This solution provided by @fernando_zuluaga received 1 likes!

Rename Excel Sheet for MULTIPLE Excel Files

hey try this [image] 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 | 07 May 2022

Top 3 Topics with Most Views

How to trigger hidden radio button after clicking the drop-down menu made by @dawei.jiang with 36 views.

Desktop automation source from excel update DAY made by @Ravi_R with 29 views.

How to Run UiPath studio and Studiox on same computer made by @Ravindra_Kumar with 28 views.

Top 3 Topics with Most Replies

REFramework issue MaxRetryLimit issue made by @BlackCurrant with 11 replies.

How to trigger hidden radio button after clicking the drop-down menu made by @dawei.jiang with 10 replies.

Extraction of information from a database made by @AlexandreManuelLara with 10 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 29 posts!

@Rahul_Unnikrishnan made 26 posts!

@jack.chan made 13 posts!

Top 3 Most Liked Posts

This post made by @fernando_zuluaga received 2 likes!

How to Run UiPath studio and Studiox on same computer

hey check this Regards!

This post made by @METALI_Garg_US received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi I am Mitali, I studied IT and working in IT since the beginning of my career. Excited to join this forum and pleased to have this learning opportunity with you all. Looking forward.

This post made by @sophi.priyanka received 1 likes!
https://forum.uipath.com/t/421232/10

Top 3 Most Liked Solutions

This solution provided by @fernando_zuluaga received 2 likes!

How to Run UiPath studio and Studiox on same computer

hey check this Regards!

This solution provided by @Yoichi received 1 likes!

Rename Excel Sheet for MULTIPLE Excel Files

Hi, Is your sheet to read from B1 has same name as its filename? If so,the following will work. [image] infoSheetName = System.IO.Path.GetFileNameWithoutExtension(currentFile.Name) If not, can you share naming rule of the target sheet? Regards,

This solution provided by @Nithinkrishna received 1 likes!

Desktop automation source from excel update DAY

Hey @Ravi_R You can automate that as well using Click activity and dynamic selector with a variable in it. And the variable will hold the day value in it. 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 | 08 May 2022

Top 3 Topics with Most Views

Why this error is showing? made by @ydash999 with 50 views.

Palindrome of string without using Reverse function? made by @BlackCurrant with 50 views.

Click on context made by @A_Learner with 40 views.

Top 3 Topics with Most Replies

Why this error is showing? made by @ydash999 with 31 replies.

Palindrome of string without using Reverse function? made by @BlackCurrant with 25 replies.

Need to update cell in excel after finding row number using combination of more than two column values made by @Shashi123 with 15 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 53 posts!

@Rahul_Unnikrishnan made 39 posts!

@ydash999 made 13 posts!

Top 3 Most Liked Posts

This post made by @Sunshine_Summerville received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hey Everyone, Could you help me get started ? I’m a bit lost but please allow me to introduce myself. My name is Sunshine, one of the newbies here. I have started a UiPath course because I wanna learn to develop in UiPath in combination with HTML. Learning about development has always been a great interest of mine and I would like to dive in the developer world while connnecting and working with people. I started the full path with lots of excitement. However, I think that I missed some sort …

This post made by @Abdul_Samad_Qureshi received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hey Everyone, Glad I could make it here, excited to start with UIPath.

This post made by @Saltukhan_Dura received 1 likes!

Given key is not present in dictionary

I fixed my problem by the way. The config file path was wrong. I updated and the process worked.

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Palindrome of string without using Reverse function?

Hey @BlackCurrant Create a new boolean variable as bol_Palindrome with default value as True Remove the WriteLine activity in the Then block Then just replace the WriteLine activity with Assign activity in the Else block, with the below statement bol_Palindrome = False Add a Break activity below the above Assign After the For-Each completion, just add a Log message with below statement, strVal + if(bol_Palindrome, " is a Palindrome", " is not a Palindrome") Hope this helps Thanks #nK

This solution provided by @Nithinkrishna received 1 likes!

Need to update cell in excel after finding row number using combination of more than two column values

Hey @Shashi123 Here you go… nmnithinkrishna_XlRowIdxForMultiColMatch_08May2022.zip (8.3 KB) Hope that helps. Thanks #nK

This solution provided by @Joysogood received 1 likes!

Bring up Data Scraping tool

I set my designer tab like this. [2022-05-09 01 30 36] [2022-05-09 01 31 38]

---

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

Top 3 Topics with Most Views

Add Queue Item using API made by @john.mari with 46 views.

Add multiple screenshot in email body made by @Sana_Afreen with 45 views.

アカデミーの動画が見れません made by @sigo with 41 views.

Top 3 Topics with Most Replies

Add multiple screenshot in email body made by @Sana_Afreen with 28 replies.

Get xml value through xpath made by @maxena2872 with 17 replies.

Object reference not set to instance of objectt made by @avnreddy007 with 17 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 105 posts!

@Rahul_Unnikrishnan made 87 posts!

@ppr made 22 posts!

Top 3 Most Liked Posts

This post made by @praveenchintu374 received 3 likes!

UIDemo App Apk,Username And Password

Hi Everyone If anyone needs to download UIDemo App for practising Uipath please download the app with below link n thank me later UIDemo.zip (17.7 KB) Above Zip File link is for UiDemo App Download UserName : admin Password : password Regards, Praveen

This post made by @Kotla_Gunasekhar received 2 likes!

Rate UiPath and Get Rewarded! Huge campaign for this summer!

Received my gift voucher

This post made by @john.mari received 2 likes!

Add Queue Item using API

Hi Everyone, In our process, we are building a bot to push queue items using API. The structure of the JSON body: ""{""itemData"": {""Name"": ""Value1"",""Priority"": ""Value2"",""SpecificContent"": {""Data"": [{""Key3"": ""Test"",""Key4"": ""TES8"",""Key5"": ""Test"",""Key6"": ""1234 Street""}] }}}"" The error message logged: { “message”: “queueItemParameters must not be null”, “errorCode”: 0, “resourceIds”: null } Inside the Specific Content, we need to add a key with an array value. …

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 2 likes!

Why this error is showing?

Hey @ydash999 Okay sorry, just noted from the screenshot. Remove everything from the endpoint and keep only /odata/Folders Thanks #nK

This solution provided by @Rahul_Unnikrishnan received 2 likes!

How to connect UiPath studio with Orchestrator?

You have to make the connection between UiPath assistant and Orchestrator. once it is done then you will able to see the connection details here in studio. [UiPath - How to connect UiPath to Orchestrator|Run Process,Jobs & Triggers|UiPath Licensing]

This solution provided by @Rahul_Unnikrishnan received 1 likes!

Getting text from website using OCR

Hello @tolgademir , I’m able to fetch those values from the webpage. Plz find the screenshot below. I haveatteched the workflow which i have created. [image] [image] ExcelDemo.zip (435.9 KB)

---

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

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

[system]

Daily Forum Report | 10 May 2022

Top 3 Topics with Most Views

UiPath Studio 2022.4.1 breaks local file access on my local robot through Assistant made by @oscar with 42 views.

Version question made by @A_Learner with 42 views.

How to read and write data to file excel made by @Chanwit with 41 views.

Top 3 Topics with Most Replies

Multiple click on dynamic selector made by @Nur_Alif_Irawan with 24 replies.

Terminate Workflow if the datatable is empty made by @Ishan_Shelke1 with 17 replies.

I have to extract data in a web page where the data is hidden hidden so in orders to extract the data i have to click on plus button to extract the hidden data can i automatically click on the plus option made by @lokeshmello with 17 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 80 posts!

@Nithinkrishna made 59 posts!

@ppr made 31 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

UiPath Studio 2022.4.1 breaks local file access on my local robot through Assistant

Hi, FYI, it might be same issue with the following. (not solved yet…) Regards,

This post made by @jeevith received 2 likes!

Creating error-proof reusable workflows in UiPath

Hi @Steven_McKeering, I appreciate your very thoughtful inputs A check on a string is empty or null can be another alternative to Try and Catch. I try limiting the use of try catch on activity level and rather use it on a workflow level / wrapper level (invoked workflow/s within a wrapper) and let the Process.xaml decide how the error needs to be thrown to Process Transaction state. I have found that this approach ensures easy debugging provided all the three arguments (out_Suc…

This post made by @Yoichi received 2 likes!

After updating v2022.4, the robot stops with an error "The workbook dose not exist."

Hi @loginerror , I guess the following topic might be same issue with this. Can you also check it? Regards,

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Urgent: Can anybody help with getting queue value only using regex form this text value

the pattern from regex used within an assign: strPattern = "(?<=Number of Queues Displayed:)(?:.*?)(\d+)" [CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum

This solution provided by @ppr received 2 likes!

How to edit value in data table or in data row in debug mode?

have a check with working on immediate panel [grafik]

This solution provided by @Srini84 received 1 likes!

How to add another account to Uipath

@raju_alakuntla It’s better if you add more details to your issue Are you trying to add another Community account like a Tenant? If that is the case, then it won’t be possible in Community Account Hope this may 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.