Forum Engagement Daily Reports

[system]

Daily Forum Report | 24 January 2023

Top 3 Topics with Most Views

Project build: Generating synthetic test data (project) Add data row error made by @bruce.switzer with 77 views.

Need to Change Date Format from string to Date made by @manojmanu.rpa with 50 views.

How to compare the 2 excel sheets made by @Manoj_sreekanth with 46 views.

Top 3 Topics with Most Replies

PDF fields not recognizing made by @pravin_bindage with 19 replies.

How to get Excel window to foreground to send key strokes? made by @Prabin_Chand with 18 replies.

ダウンロード待機アクティビティに、『 次の拡張子の一時ファイルを無視:』が表示されない made by @masaaki.kasahara with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 41 posts!

@Yoichi made 32 posts!

@rohin_Kumar made 19 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Need to Change Date Format from string to Date

In addition to: In general we would recommend to use ParseExact for converting the string into a dateTime Afterwards we can reformat as needed DateTime.ParseExact(YourInputString, YourFormat, System.Globalization.CultureInfo.InvariantCulture) Format parts (in/out) are as: [grafik] [grafik] Still we would recommend to check if the Time part is really breaking Month / year in the Position Kindly note: Friday 20th Jan 2022 does not exist, it was a Thursday so parsing this date will fail […

This post made by @Anil_G received 2 likes!

S108 Exception Based Query

@Harsha_S1 Please search for the activity for each row in Datatable… else change the type argument to datarow in the current for each… or write dt_ReadRange.AsEnumerable and give type argument as datarow hope this helps cheers

This post made by @Steyn_Muller1 received 2 likes!

Assign Data Service Entities separately to text fields in UiPath Apps

Thank you so much! It works!

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

S108 Exception Based Query

@Harsha_S1 Please search for the activity for each row in Datatable… else change the type argument to datarow in the current for each… or write dt_ReadRange.AsEnumerable and give type argument as datarow hope this helps cheers

This solution provided by @indra received 1 likes!

Regex extractor not working with alternative anchors (word a OR word b)

@NielsF Welcome to UiPath community You can use this Regex Refer this to use regex in assign activity

This solution provided by @prasadprathmeshambika received 1 likes!

ERROR - The given key was not present in the dictionary

This kind of error mostly occurred when ,key value not present in config file and you r trying to call from workflow. eg. Config(“XYZ”).To String but XYZ key not present in config file.

---

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

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

[system]

Daily Forum Report | 25 January 2023

Top 3 Topics with Most Views

SQL CREATE issue made by @gpftr with 51 views.

What is the Regex for extract the total row? made by @Gopi_Krishna_Reddy1 with 50 views.

There is problem, why it occur? in split and append activity made by @sssim4567 with 45 views.

Top 3 Topics with Most Replies

あいまい検索について made by @a.kmni with 28 replies.

Group by and send email made by @rayz1503 with 20 replies.

What is the Regex for extract the total row? made by @Gopi_Krishna_Reddy1 with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 76 posts!

@Yoichi made 36 posts!

@Sudharsan_Ka made 14 posts!

Top 3 Most Liked Posts

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

'Process could not be started' error

To simplify management I created two roles. One that I assigned at the Tenant level: [image] And another for the folder level: [image] Then I made sure to assign the role for the Public App for the folder where my unattended automation was published: [image] What that looks like on the actual assignment screen: [image] You can validate that you’ve assigned these roles properly by checking the roles for your app under ‘Manage Access’ in Orchestrator: [image] pro-tip: when searching …

This post made by @huzaifa_sheikh received 1 likes!

UiPath Dev Dives - 2023 webinar series for developers

Excited to join this webinar.

This post made by @marian.platonov received 1 likes!

How can I open Outlook as a system admin in UiPath?

What may be the cause? The issue is due to that the target application which you are automating needs a higher privilege to interact with it. How may I overcome this behavior? You may have a couple of solutions in this case: Run the target application in a non-elevated mode or low Integrity level after which the UiPath Robot will be able to identify the application elements. Automatically start UiPath Executor as admin (Robot user should have administrator access) suitable configurations sh…

Top 3 Most Liked Solutions

This solution provided by @Ahmed_Loirdi received 1 likes!

Read Range Workbook returns me error "Implement it based on poi 4.2 in the future"

Thank you for your support, I had already had that settings. Apparently that’s an error message that pops up when a file could be encrypted. I used that workaround: Give up Read Range Workbook activity Use (inside Excel Process Scope and Use Excel Files activities) a For each Sheet in Excel Then add an If with the following condition: CurrentSheet.Name.Contains([KEYWORDS]) Finally add a Read Range from Excel package. This solution is slower but works fine

This solution provided by @rohin_Kumar received 1 likes!

Value of string cannot be converted to UI element

Hi @Bhushan_Nagaonkar, In modern design, You can delete the innertext and add the variable, Its working for me [Capture]

This solution provided by @Anil_G received 1 likes!

Uipath Support Engineer

@Harsha_S1 Might not be same everywhere but most of it would include but not limited to the following Monitor the daily jobs Raise/Fix any issues for the bots Perform enhancements and migration activities Maintain the Robot machines on a weekly basis mostly If using any ticketing system then close them as needed cheers

---

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

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

[system]

Daily Forum Report | 26 January 2023

Top 3 Topics with Most Views

Trouble adding Color Detector Package to Project Dependencies made by @beatorres2 with 52 views.

Filtering dates in Excel / CSV made by @Henson_Ibon with 45 views.

Excelに記載している日付表示を変更したい made by @miwa_yamamoto with 42 views.

Top 3 Topics with Most Replies

"Column name" is not set or is invalid ? Need help fixing this made by @Ryhan_Ahmed with 19 replies.

Excelに記載している日付表示を変更したい made by @miwa_yamamoto with 17 replies.

How NOT to change separator inside quotes made by @Matheus_Dallasta with 11 replies.

Top 3 Users Who Posted The Most

@Yoichi made 48 posts!

@Anil_G made 29 posts!

@ppr made 19 posts!

Top 3 Most Liked Posts

This post made by @Diana_Tufan received 3 likes!

UiPath products now available in Traditional Chinese!

We’re happy to announce that starting with this month almost all UiPath GA products support a new language - Traditional Chinese. The new language will be supported in all products via Automation Suite starting with 2023.4. We trust this language release will enable our users from Traditional Chinese speaking markets to navigate our products easier in their own language. Please refer to this page for a full product localization overview and don’t hesitate to get in touch vi…

This post made by @supermanPunch received 2 likes!

Datatable Manipulation To Converge Specific Rows of a Specific Column

@FilipeChiou , I believe this could be done by @Yoichi 's Implementation provided above, You would just require to perform the Operation of Deciding if it is OK or not OK inside the For Each Loop and then maybe use an If Condition and decide if it is OK or NOK using an Assign Activity. As the logic of Deciding OK or NOK is still not exposed to us, we could only maybe suggest you the approach. Let us know if you were not able to understand the above approach suggested.

This post made by @FilipeChiou received 2 likes!

Datatable Manipulation To Converge Specific Rows of a Specific Column

Hi @Yoichi, I would like to apoligize, I shouldve understood your reply and think about it further rather than respond immediately (I am a beginner in UiPath), yes you are absolutely right, I dont need to create an dt_aux since I can just put an if in the for each to run only on NULL rows. I am sorry for wasting your time, I should read and understood your reply more carefully. Lesson Learned Thank you @Yoichi and @supermanPunch for your time and help, its solved now!

Top 3 Most Liked Solutions

This solution provided by @Joe_Matuch received 2 likes!

Compilation Error in Process but not in Library: "Expression Activity type 'VisualBasicValue`1' requires compilation in order to run. Please ensure that the workflow has been compiled."

Hi, everyone. This issue is most likely due to 1 or more package misalignments. Specifically, the library is using UiPath.System.Activities 22.4.5, but the process that is using that library is on 22.10.3. Furthermore, our Studio is version 22.4. Still working on confirming that this is the issue, but it is more likely than not the cause. Word for the wise: keep your versions aligned! UPDATE: Confirmed that having the 22.10.3 version in the process interf…

This solution provided by @Ranjit_Nayak1 received 2 likes!

Issue running bot after moving the project to a different system

After long time spent, found that issue was because of Check Activity, I have used this for radio buttons, check boxes. I have changed the activity based on version and this worked fine.

This solution provided by @Yoichi received 1 likes!

How do you read date from excel and compare?

Hi, It’s excel serial value. Can you try the following condition? [image] fecha_doc=DateTime.FromOADate(CDbl(fecha_SBS)).ToString("yyyy.MM.dd") 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 | 27 January 2023

Top 3 Topics with Most Views

How to stop the bot, without Orchestrator made by @AaronMark with 44 views.

Can I have chatGPT in automated email? made by @Amy_Miller with 40 views.

[Solved] Downloading and Moving File (Couldn't read Variable and report error) made by @Jack_Tsang with 40 views.

Top 3 Topics with Most Replies

How to obtain the result of a formula with 2 decimals made by @Andreea_Nistor with 10 replies.

[Solved] Downloading and Moving File (Couldn't read Variable and report error) made by @Jack_Tsang with 9 replies.

Get-Text and TypeInto made by @Staccato with 9 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 28 posts!

@Yoichi made 17 posts!

@Anil_G made 14 posts!

Top 3 Most Liked Posts

This post made by @oraganti931 received 2 likes!

System exception at initialization: Failed setting the current sheet to: Sheet1 in workbook:

Thank you everyone for your quick response @Anil_G @Ashish_Saxena @Sudharsan_Ka . The issue has been resolved. The issue because of excel application itself. Due to some alerts i have got that error. Once i have clicked ok for all of that then it has been resolved. Thank you Aravind

This post made by @madepablo received 1 likes!

[HowTo] - Find Duplicate / NonDuplicate rows - checking all columns - without explicit listing the colnames/index

Many thanks, it solves me a big problem

This post made by @mortoman received 1 likes!

Attaching to Chromium API protocol failed. To use Chromium API on this page, please close any extension pop-up using a different input method

Nice, this fixed it for me because I had LastPass enabled. Thank you sir

Top 3 Most Liked Solutions

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

How can I get the screenshot file name which is auto created using "Verify" activities?

@jadhavsiddh use this to get latest file of the screenshots folder, this will give you the file name you need new DirectoryInfo("screenshotFolderPath").GetFiles().OrderByDescending(Function(f) f.LastWriteTime).First().ToString

This solution provided by @Sudharsan_Ka received 1 likes!

Regular Expressions available in StudioX?

Hi @bibalesecret Yes you can use Regular Expression in StudioX System.Text.RegularExpressions.Regex.Match("YourString","Your Pattern").Tostring If you want to use activities Go to Activities panel-> Filter-> Click on Show Developer You can find Matches and Is match Activity [image] [image] Regards Sudharsan

This solution provided by @Yoichi received 1 likes!

Split the String into even and odd values

Hi, The above expression also works. [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 | 28 January 2023

Top 3 Topics with Most Views

I could not able add data into table made by @Manju_Reddy_Kanughula with 58 views.

Running SQL Query in unattended mode made by @ASRG with 41 views.

How to Store the three string value in datable which is coming from the cv get text made by @Neha_Aggarwal1 with 38 views.

Top 3 Topics with Most Replies

How to Store the three string value in datable which is coming from the cv get text made by @Neha_Aggarwal1 with 14 replies.

Comparing Dates and than Year to find out if the difference is of 5years or 10 years or 15 years or more made by @Kunal_Jain with 8 replies.

Download an excel, read its range, filter date, copy them into another excel made by @Jack_Tsang with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 17 posts!

@Neha_Aggarwal1 made 8 posts!

@sangeethaneelavannan1 made 8 posts!

Top 3 Most Liked Posts

This post made by @Sanjit_Pal received 1 likes!

Rounding to two decimal places, to the nearest 0.05

Hey @Muneer_Alrashdan , You can use the below method double value = 3.14159; double roundedValue = Math.Round(value / 0.05) * 0.05; where value is the number which you want to do Round off Thanks, Sanjit

This post made by @Anil_G received 1 likes!

I need to scrape a data table from a webpage but the items has kind of different places in page

@Darius_Blaga Use a for each ui element activity and indicate the whole card as one item… [image] Inside that use get children activity to get the children and now use loop inside it and then use get text inside loop…and identify the required dates if present get …them else nove on Cheers

This post made by @Farah_halawani received 1 likes!

Send Windows Hotkey

[d(ctrl)]n[u(ctrl)] works Thank you

Top 3 Most Liked Solutions

This solution provided by @Sanjit_Pal received 1 likes!

Rounding to two decimal places, to the nearest 0.05

Hey @Muneer_Alrashdan , You can use the below method double value = 3.14159; double roundedValue = Math.Round(value / 0.05) * 0.05; where value is the number which you want to do Round off Thanks, Sanjit

---

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

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

[system]

Daily Forum Report | 29 January 2023

Top 3 Topics with Most Views

How chatGPT influence RPA? made by @sangeethaneelavannan1 with 37 views.

How to write an array elements in excel made by @mrupendrareddy123 with 34 views.

Data is getting typed in application by the bot but not getting saved made by @Santa_Krish with 31 views.

Top 3 Topics with Most Replies

How to write an array elements in excel made by @mrupendrareddy123 with 14 replies.

How to create input a number, if it is not a number generates an error message box? made by @447_J_U_S_SANDEEP with 6 replies.

How to define process and process name in kill process activity? made by @vignesh_S.M with 5 replies.

Top 3 Users Who Posted The Most

@Anil_G made 8 posts!

@vignesh_S.M made 5 posts!

@fernando_zuluaga made 5 posts!

Top 3 Most Liked Posts

This post made by @cellery received 1 likes!

Array of Strings - Compiler error BC 30311: value of type '(string, string)' cannot be converted to 'string()'

Thanks, Anil! I must have missed that detail! Really appreciate your quick help! Cheers

This post made by @shiliqiang received 1 likes!

Uipath社区版调用python scope一直卡主不动

降低python activities 的版本

This post made by @marian.platonov received 1 likes!

How chatGPT influence RPA?

ChatGPT has the potential to influence RPA (Robotic Process Automation) by providing natural language processing capabilities, such as understanding and generating human language. This can be used to improve the interactions between humans and RPA systems, making them more efficient and user-friendly. Additionally, ChatGPT can be used to automate certain tasks that involve natural language processing, such as data entry and customer service. However, it is important to note that the use of ChatG…

Top 3 Most Liked Solutions

This solution provided by @fernando_zuluaga received 1 likes!

Default designer view percentage

Hey Welcome to our community! Unfortunately this is not possible right now, we should edit it in every project so can create a post in the feedback session so UiPath Staff will look for your feedback about it! Regards!

This solution provided by @sangeethaneelavannan1 received 1 likes!

How to define process and process name in kill process activity?

@vignesh_S.M

This solution provided by @Anil_G received 1 likes!

System.Collections.Generic.List`1[System.Net.Mail.MailMessage getting this message

@vinod_h it is a collection of emails say it is stored in variable var1…then first mail is var1(0),second in var1(1) and so on you can loop through each email usign for loop and change type argument to System.Net.Mail.MailMessage …then inside loop use currentitem to get each email Hope this helps cheers

---

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

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

[system]

Daily Forum Report | 30 January 2023

Top 3 Topics with Most Views

Compare column is equal or not made by @Rahul_PK with 51 views.

How it break the loop if count is not fixed made by @Neha_Aggarwal1 with 49 views.

Selector not choosing correct variable made by @april.simon with 48 views.

Top 3 Topics with Most Replies

S112_DocumentUnderstanding Exception Scenario made by @Harsha_S1 with 33 replies.

Check if cv get text value is same as another value then the loop should break made by @Neha_Aggarwal1 with 14 replies.

Trigger is not working made by @neha.kumarief868 with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 28 posts!

@Yoichi made 18 posts!

@Sudharsan_Ka made 16 posts!

Top 3 Most Liked Posts

This post made by @jdomanski received 11 likes!

What is the role of a Solution Architect Session follow-up discussion

In my approach, the way of how we document depend on the size of the process, its ownership, clarity of happy path, goals, products and automation workload - which often turns out crucially as we want to deliver results fast. So we shouldn’t limit ourselves to the current definition in a given organization, but rather make a division according to chances for quick wins. Because, after all, according to Porter Value Chain, a process is both a macro-process and its minor component at the sub-proc…

This post made by @GT_Ropa received 3 likes!

How do you guys scale and duplicate the bot into multiple machines easily?

Hi @celie.mccook Hopefully this will help: Usually UR robots are what you want to go for. Please check the community agreement if you want to run multiple robots at the same time. https://www.uipath.com/hubfs/legalspot/Legal%20Terms/UiPath_Community_Agreement.pdf Community edition subject to the conditions herein and the Documentation. If the Customer is either an individual, oran organization that, together with its Affiliates, collectively have (a) less than 250 physical or virtual mach…

This post made by @Jon_Smith received 2 likes!

Status update - Transaction Item / Queue Item

When you don’t know these, I’d suggest looking at the reframework itself to figure it out. You can search for all the set transaction item actions and then figure it out. This will prepare you much better for the exam compared to trying to memorize answers.

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

URL orchestrator request with more than one fitler

DefaultTenant/orchestrator_/odata/QueueItems?$filter=QueueDefinitionId eq 715671 And Status eq 'Failed'

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

Status update - Transaction Item / Queue Item

queueitem is a transaction item transaction item means the unit that you are processing . such as: queue item datarow item (of a list) and so on… all of them follow the same rules since its all using the same reframework so the answer is SetTransactionData.xaml which is in Process Transaction only

This solution provided by @vignesh_S.M received 1 likes!

How to clear the error of implicit conversion from Integer to string?

Thanks @Priyanka_Ramesh … But, the issue is due to the reason that, I have defined the assign activities not within a sequence. After enclosing all the activities within a sequence, the error has gone…

---

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

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

[system]

Daily Forum Report | 31 January 2023

Top 3 Topics with Most Views

Outlook Issue- Is there any robust solution for using the Outlook on bot machine? made by @shreyash_shirbhate with 57 views.

What language is best to use if you start your automation journey now? C# vs VB.Net? made by @christel.andersson with 40 views.

Running problem due to resolution made by @mironb with 40 views.

Top 3 Topics with Most Replies

Replace blank value in datable with NA made by @Neha_Aggarwal1 with 23 replies.

Send Email with Multiple attachment made by @pravin_bindage with 15 replies.

Running problem due to resolution made by @mironb with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 50 posts!

@ppr made 26 posts!

@Sudharsan_Ka made 23 posts!

Top 3 Most Liked Posts

This post made by @fernando321 received 2 likes!

Cannot Retrieve latest UiPath.UiAutomation.Activities - error

Trying to retrieve UiPath.UiAutomations.Activities 22.10.5 was causing error. Confirmed no blockers in networking side. Came across updated URL for the Packages (in the 2022.10 documentation). Once added to Studio, the activity downloaded. https://pkgs.dev.azure.com/uipath/public.feeds/_packaging/UiPath-Official/nuget/v3/index.json Hopefully this saves others much research and troubleshooting time!

This post made by @ppr received 2 likes!

How to get the last row value from a datatable

YourDataTable.AsEnumerable.Last() - will return last Datarow lets assume a particular column value from the last row YourDataTable.AsEnumerable.Last()(ColNameOrIndex)

This post made by @supermanPunch received 2 likes!

Second-highest date

Hi @sayed.tabrez , Assuming you have already read the Data from the Excel as a Datatable, you can Check with the below Expression : SecondHighestDate = DT.AsEnumerable.OrderByDescending(Function(x)CDate(x("YourBirthDateColumnName").ToString))(1).ToString Here, SecondHighestDate is of the Type String, and DT is the Datatable variable. Let us know if the above expression does not work.

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

Second-highest date

Hi @sayed.tabrez , Assuming you have already read the Data from the Excel as a Datatable, you can Check with the below Expression : SecondHighestDate = DT.AsEnumerable.OrderByDescending(Function(x)CDate(x("YourBirthDateColumnName").ToString))(1).ToString Here, SecondHighestDate is of the Type String, and DT is the Datatable variable. Let us know if the above expression does not work.

This solution provided by @Aakash_Singh_Rawat received 2 likes!

How i can get alternative values from excel like row 1 and row 3 odd row except even row

Hi @sayed.tabrez, Use assign: odd_dt = dt.AsEnumerable.Where(Function(x) Not dt.Rows.IndexOf(x) Mod 2=0).CopyToDataTable where dt is your output datatable used in Read Range. Please mark this as solution if it solves your problem.

This solution provided by @fernando_zuluaga received 1 likes!

Filtrar un email outlook

Hola puedes probar con el siguiente codigo [image] (From m In mailMessages Where m.Subject.Trim.Contains("yournumber") Select m).ToArray Saludos

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

@Yoichi received 57 likes for their solutions!

@Anil_G received 56 likes for their solutions!

@Kaviyarasu_N received 27 likes for their solutions!

---

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

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

[system]

Daily Forum Report | 01 February 2023

Top 3 Topics with Most Views

What type of automations can be done using uipath made by @Vajrang with 66 views.

When invoking one workflow, the below error showing made by @Yashobanta_Dash with 48 views.

Excel Files Automation made by @DimiG with 47 views.

Top 3 Topics with Most Replies

Excel Files Automation made by @DimiG with 24 replies.

Table Extraction Next Page Problem made by @Arzu_Kaya with 21 replies.

Unable to select from dropdown list made by @Mathkar_kunal with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 65 posts!

@Sudharsan_Ka made 32 posts!

@supermanPunch made 26 posts!

Top 3 Most Liked Posts

This post made by @Vajrang received 8 likes!

What type of automations can be done using uipath

List down all platforms that UiPath can interact with

This post made by @Gokul001 received 6 likes!

Monthly Forum rewards - January 2023

Congratulations to all the winner

This post made by @Anil_G received 5 likes!

Monthly Forum rewards - January 2023

Congratulations Everyone.

Top 3 Most Liked Solutions

This solution provided by @arjunshenoy received 3 likes!

Close chrome gracefully

Hi @pravin_bindage Kill activity will force stop the browser and sets the browser’s ‘exit_type’ flag as Crashed. This might affect the execution & browser performance over a period of time. You can use the ‘Close Application’ or ‘Close Tab’ activity if you want to close the browser gracefully.

This solution provided by @Manish540 received 3 likes!

Linq Query for extracting excel from row containing specific string till row containing specific string

@yash.choursia Check this below workflow attached, Uipath_Extract_GetRangeOfRows.xaml (12.3 KB) Hope this may help you

This solution provided by @Sharwaree_Nimbalkar received 1 likes!

Studio Web | Easy Automation Use case | UiPath

Very helpful and Well explained !!

---

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

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

[system]

Daily Forum Report | 02 February 2023

Top 3 Topics with Most Views

Write Range Object reference not set Error made by @DimiG with 39 views.

Read File With Sequence File Name Order made by @Hendaryie_Tjoeng with 38 views.

How to remove set of words with a keyword made by @sunilkanth with 38 views.

Top 3 Topics with Most Replies

Write Range Object reference not set Error made by @DimiG with 43 replies.

Read File With Sequence File Name Order made by @Hendaryie_Tjoeng with 19 replies.

Build Data Table error with Google.Apis.Drive.v3.Data.File type made by @Jes_Hunsballe with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 87 posts!

@DimiG made 21 posts!

@fernando_zuluaga made 19 posts!

Top 3 Most Liked Posts

This post made by @arivu96 received 3 likes!

Monthly Forum rewards - January 2023

Congratulations to all the winners

This post made by @Bilal_Anwar received 2 likes!

Monthly Forum rewards - January 2023

Congratulations everyone

This post made by @Anil_G received 2 likes!

Setting ENV variables in Orchestrator

@marcus.coates12 Yes it sets the value in orchetsrator not in the system env variables…but if you want to set environment variable you have an activity for that…and the value for it can be controlled from assets Similarly you have a get env variable as well Cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Setting ENV variables in Orchestrator

@marcus.coates12 Yes it sets the value in orchetsrator not in the system env variables…but if you want to set environment variable you have an activity for that…and the value for it can be controlled from assets Similarly you have a get env variable as well Cheers

This solution provided by @Anil_G received 1 likes!

How to send emails from Outlook 365 with Two-factor authentication?

@Lynx No it is not like that…we use secret…did you give application scope? …app secret does not work with delegated permissions it needs application permissions in your azure app Can you try adding this package feed to manage packages and check https://pkgs.dev.azure.com/uipath/public.feeds/_packaging/UiPath-Official/nuget/v3/index.json Cheers

This solution provided by @Yoichi received 1 likes!

Regex to extract text before keyword and include the keyword

Hi, Can you try the following pattern? \S*\.ca [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 | 03 February 2023

Top 3 Topics with Most Views

実行するにはコンパイルする必要があります とエラーが表示される made by @spaceforce with 45 views.

How to split excel data using a specific column using Studio made by @raisonne with 43 views.

[Data Service] How to add value to variable in uipath studio made by @Anh_Tuan with 40 views.

Top 3 Topics with Most Replies

How to split excel data using a specific column using Studio made by @raisonne with 27 replies.

実行するにはコンパイルする必要があります とエラーが表示される made by @spaceforce with 13 replies.

Get IMAP Mail Messages: Input string was not in a correct format made by @Manju_Reddy_Kanughula with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 38 posts!

@supermanPunch made 21 posts!

@fernando_zuluaga made 19 posts!

Top 3 Most Liked Posts

This post made by @km81 received 2 likes!

Unable to sign in cloud.uipath.com

@loginerror Thanks for your message I will get help from Colud Technical support on this.

This post made by @Yoichi received 2 likes!

実行するにはコンパイルする必要があります とエラーが表示される

以下の事例ですと、ライブラリ側で（内部で）参照しているUiPath.System.Activites packageを22.10.3から22.4.5にダウングレードすると解消したそうです。

This post made by @ppr received 2 likes!

How to convert ienumerable<queueItem> to datatable

We assume that get Queue Item->s is used here we would recommend to specify what is needed. QueueItems Properties e.g. Reference, Status,… SpecificContent infos Example: All SpecificContent Dictionaries to DataTable Assign Activity: dtData = JArray.FromObject(YourGetQueueItemsOut.Select(Function (x) x.SpecificContent).toArray).toObject(Of DataTable)

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

How to convert ienumerable<queueItem> to datatable

We assume that get Queue Item->s is used here we would recommend to specify what is needed. QueueItems Properties e.g. Reference, Status,… SpecificContent infos Example: All SpecificContent Dictionaries to DataTable Assign Activity: dtData = JArray.FromObject(YourGetQueueItemsOut.Select(Function (x) x.SpecificContent).toArray).toObject(Of DataTable)

This solution provided by @supermanPunch received 2 likes!

How to split excel data using a specific column using Studio

Hi @raisonne , Could you Check with the below Steps : Create and Initialise a Dictionary variable in the below way using an Assign Activity : TeamDict = new Dictionary(Of String,Datatable) Get the Team Set as Groups, convert to Datatable and add to Dictionary using an Assign Activity like below TeamDict = DT.AsEnumerable.GroupBy(Function(x)x("TEAM").ToString).ToDictionary(Function(x)x.First.Item("TEAM").ToString,Function(y)y.CopyToDataTable) Now, We can loop through the Dictionary TeamD…

This solution provided by @Gokul001 received 1 likes!

Working with Date (dd.MM.yyyy) format

Hi @M_L Print the Date in the log message and get the date format from it. in_TransactionItem.SpecificContent("Start").Tostring And update the date format in the expression and check it [image] Regards Gokul

---

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

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

[system]

Daily Forum Report | 04 February 2023

Top 3 Topics with Most Views

Create HTML Content. Add Image at runtime made by @altp123 with 70 views.

Invoke PowerShell/Start Process: Backslashes get Added to String at Runtime made by @Jack_Moran with 45 views.

Windows-Legacy made by @447_J_U_S_SANDEEP with 37 views.

Top 3 Topics with Most Replies

Select unknown element made by @alexis.mendoza with 10 replies.

How press ctrl+D in excel application made by @vineelag with 7 replies.

Rearrange made by @Devendra_Bhardwaj with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 31 posts!

@rikulsilva made 10 posts!

@fernando_zuluaga made 9 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

How can I delete the same records in excel file?

@Arzu_Kaya Please remove the Write range and use Merge datatable and Write it at the ends Filter - Dt.AsEnumerable.Where(function(x) x.ItemArray.Any(function(y) IsNothing(y) OrElse String.IsNullOrEmpty(y.ToString.Trim))).CopyToDataTable cheers

This post made by @FIROZ_RANGREZ received 1 likes!

How press ctrl+D in excel application

Hi @vineelag , You can use send hotkey like this [image] in indicate on screen, try to select your excel application Regards, Firoz

This post made by @FIROZ_RANGREZ received 1 likes!

How press ctrl+D in excel application

Hi @vineelag , Try to use Active Accessibility (Marked in red in the below snap)as a framework when indicating element and select whole excel. like this [Untitled] Here you can see I have selected the whole excel and validate the properties as @RajKumar_DC has mentioned. Regards, Firoz

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

How can I delete the same records in excel file?

@Arzu_Kaya Please remove the Write range and use Merge datatable and Write it at the ends Filter - Dt.AsEnumerable.Where(function(x) x.ItemArray.Any(function(y) IsNothing(y) OrElse String.IsNullOrEmpty(y.ToString.Trim))).CopyToDataTable cheers

---

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

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

[system]

Daily Forum Report | 05 February 2023

Top 3 Topics with Most Views

How do i add flow decision activity on studio web? and loop it as in studiopath normal made by @Arvind_Karthigayan with 71 views.

How to find count of today date in excel based on input value made by @Raja.G with 35 views.

Number Filter UiPath made by @Real.Downey with 34 views.

Top 3 Topics with Most Replies

Issue with the selector made by @govindreddy_nagireddy with 18 replies.

Write Range Workbook: Object Reference Not set to an instance of an Object_Error while getting Queue Items from Orchestrator made by @Alekhya_Gandhi with 13 replies.

An activity that breaks the loop in the flowchart after a certain amount of repetitions made by @eduardo34 with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 34 posts!

@rikulsilva made 14 posts!

@govindreddy_nagireddy made 12 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

How can you pass different DataTables in .rows.Items

Hi, FYI, another approach without if: dict = New Dictionary(Of Boolean, DataTable)From{{true,dtA},{false,dtB}} dict is Dictionary<Boolean, DataTable> type Then, the following will work. dict(condition).Rows(0).Item(0).ToString [image] Sample20230206-1L.zip (2.7 KB) Regards,

This post made by @NiesonF received 1 likes!

How can you pass different DataTables in .rows.Items

This worked perfectly!

This post made by @Boopathi.M received 1 likes!

How to click on a Ui Element only if it contain a specific text ( out of many similar Ui element )

Hi @celie.mccook Use click activity and indicate it on your name and analyze the selector if any element is unique for that particular name like aaname or text and you can pass variable dynamically in the selector to click on your name or any other name you wish to click You can see Data Extract example in UiPath site Thanks

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How can you pass different DataTables in .rows.Items

Hi, FYI, another approach without if: dict = New Dictionary(Of Boolean, DataTable)From{{true,dtA},{false,dtB}} dict is Dictionary<Boolean, DataTable> type Then, the following will work. dict(condition).Rows(0).Item(0).ToString [image] Sample20230206-1L.zip (2.7 KB) Regards,

This solution provided by @rikulsilva received 1 likes!

How could I separate one column into multiple colums with their values?

@pprin001 Hi Use Read CSV activity and pass the column separator (,) The output is a DataTable that you can save

This solution provided by @Anil_G received 1 likes!

Which country has most points?

@Comet Did you create a datatable using build Datatable as stated above? Also try this, I have added check to rating if it is a number Newdt = (From d In ExtractedTable.AsEnumerable() Group d By k=d("Country").toString.Trim Into grp = Group Let sum = grp.sum(function(x) If(IsNumeric(x("Rating").ToString.Trim),CDBL(x("Rating").ToString.Trim),0)) Let ra = New Object(){k,sum} Select r = Newdt.Rows.Add(ra)).CopyToDataTable() cheers

---

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

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

[system]

Daily Forum Report | 06 February 2023

Top 3 Topics with Most Views

Where we can use ChatGPT with UiPath? made by @BNK with 55 views.

Filter requester for specific people made by @goncalo.rocha with 41 views.

Delete row studiox not working made by @Mark_Rajkumar with 41 views.

Top 3 Topics with Most Replies

Delete row studiox not working made by @Mark_Rajkumar with 24 replies.

Filter requester for specific people made by @goncalo.rocha with 21 replies.

Duplicate row Uipath made by @Krishan_Rapswal with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 50 posts!

@Gokul001 made 25 posts!

@ppr made 15 posts!

Top 3 Most Liked Posts

This post made by @PGCC received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, my name is Phil and I work mostly supporting the infrastructure that constructs the environments in which we run our automations.

This post made by @Ashutosh.Gupta received 2 likes!

Get latest file based on creation time

Hi Dinesh, Please try ‘For each file in folder’ activity. In this activity update “ORDER BY” => “Create date oldest first”. [Screenshot (29)]

This post made by @Sisay_Dinku received 2 likes!

I want to try RPA challenge using Reframework while Dispatcher Intergrated in Performer

Hi @Anil_G and @fernando_zuluaga Yes, I was able to integrate the dispatcher into the main process using switch activity and it’s worked fine. Thanks, guys, for your perspective. That was very helpful.

Top 3 Most Liked Solutions

This solution provided by @Ashutosh.Gupta received 2 likes!

Get latest file based on creation time

Hi Dinesh, Please try ‘For each file in folder’ activity. In this activity update “ORDER BY” => “Create date oldest first”. [Screenshot (29)]

This solution provided by @FIROZ_RANGREZ received 1 likes!

How to get 1st 3 letters of a 8 letter word to type into from a json string key data?

Hi @Arvind_Karthigayan, Try like this Jobj("orderId").ToString().SubString(0,3) Regards, Firoz

This solution provided by @Tuannna1 received 1 likes!

Oauth2.0

OAuth 2.0 is a protocol used to secure authorization to access resources. To integrate OAuth 2.0 with UiPath, you need to perform the following steps: Obtain OAuth 2.0 credentials: Depending on the OAuth 2.0 provider, you may need to register your application and obtain client ID, client secret, and a redirect URL. Use the UiPath Web API activities to build a workflow that performs the OAuth 2.0 authorization flow. This usually involves sending a request to the authorization endpoint to get a…

---

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

Top 3 Topics with Most Views

How to install UiPath studio for latest version 2022.10 (I am using Flex plan) made by @BNK with 42 views.

ReFrameworkでインプットファイルがない場合の処理 made by @111860 with 38 views.

How to get dynamic cell range made by @Sai.Srinivas with 36 views.

Top 3 Topics with Most Replies

Why retry is not working in system Exception in Reframework in uipath? made by @Prabin_Chand with 19 replies.

How to run java based web application in locked screen? made by @Prabin_Chand with 19 replies.

Add prefix to whole row made by @neha.kumarief868 with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 74 posts!

@Sudharsan_Ka made 30 posts!

@rikulsilva made 28 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

How to filter value using query instead of filter data table

dtResult = From d in YourDataTabeVar.AsEnumerable Let si = d.Item("Index").ToString.Trim Where {"0","1.0"}.Any(Function (x) si.StartsWith(x)) Select r = d).CopyToDataTable Handling empty results: [FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum

This post made by @rikulsilva received 2 likes!

How to filter value using query instead of filter data table

Hi, you can use linq for this yourDt = yourDt.AsEnumerable.Where(Function(x) x.Item("Index").ToString.StartsWith("0")).CopyToDataTable But, before make assignment, make sure that the DT has least one row with your condition or it will be throw a exception in CopyDataTable method. put in if condition yourDt.AsEnumerable.Where(Function(x) x.Item("Index").ToString.StartsWith("0")).Any Or you can directly put in assign using if your dt = if(yourDt.AsEnumerable.Where(Function(x) x.Item("Index")…

This post made by @rikulsilva received 2 likes!

How to create an action for x amount of times a task is performed

You can use loop activities to processes your tasks. Inside your loop, put some validation before start the next one. For example, check if login time out occurs, if so, you call other workflow just for login. Then your process continues without break. If you need more robust solution with retry mechanism, processes task individually and so on the better choice is ReFramework If you perform simple task, you can create additional step for check login. Specially create a workflow only for lo…

Top 3 Most Liked Solutions

This solution provided by @rikulsilva received 1 likes!

How to filter value using query instead of filter data table

Yes, it is. Just add “or” condition yourDt = yourDt.AsEnumerable.Where(Function(x) x.Item("Index").ToString.StartsWith("0") or x.Item("Index").ToString.StartsWith("1.0")).CopyToDataTable

This solution provided by @Anil_G received 1 likes!

For each excel Row How do I message box counting out the numbers?

@oscar.o Then use fa filter datatable and filter the required row with 0 and then use filtereddt.rowcount and in message box write "0 is repeated " + filtereddt.rowcount.tostring Or create a integer variable and initialize it with 0 …then in the then condition use counter = counter+1 in assign and get the count and outside the loop use Msg box with "0 is repeated " + counter.tostring Hope this helps Cheers

This solution provided by @supermanPunch received 1 likes!

Error "End of expression expected" on Type Into activity

Hi @Dea_Pahumi , Could you try changing the Expression to the below : if(String.IsNullOrWhiteSpace(in_Address1),"",in_Address1) This part should be handled when you enabled the Property EmptyField [image] Let us know if this does not work as Expected and describe what happens.

---

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

Top 3 Topics with Most Views

Automatically adding values inside of array input of library activity made by @GT_Ropa with 76 views.

I have one problem made by @Shubham_Bidwai with 51 views.

Need to calculate the days for different year and month made by @sruthesanju with 49 views.

Top 3 Topics with Most Replies

I have one problem made by @Shubham_Bidwai with 32 replies.

How can I set web element attribute "hasFocus" to True? made by @Prabin_Chand with 22 replies.

Selecting a range of items in an array made by @olmccb with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 70 posts!

@Sudharsan_Ka made 36 posts!

@rikulsilva made 22 posts!

Top 3 Most Liked Posts

This post made by @Omkar_Shete1 received 2 likes!

Monthly Forum rewards - January 2023

Congratulations Anil_G

This post made by @vishal.kp received 2 likes!

Linq query to filter line items not starts with particular value

Hi @mohamedalthaf , You can negate the condition by just putting Not infront of it like shown below. DT.AsEnumerable().Where(Function(w) not w(“Amount”).ToString.Trim.StartsWith(“-”)).CopyToDataTable

This post made by @supermanPunch received 2 likes!

Assign error in chatgbt (Non-invocable member can not be used like a method)

Hi @hb61 , Could you try changing to the below Expression and Check if it works : ChatGBTInput["prompt"]

Top 3 Most Liked Solutions

This solution provided by @vishal.kp received 2 likes!

Linq query to filter line items not starts with particular value

Hi @mohamedalthaf , You can negate the condition by just putting Not infront of it like shown below. DT.AsEnumerable().Where(Function(w) not w(“Amount”).ToString.Trim.StartsWith(“-”)).CopyToDataTable

This solution provided by @supermanPunch received 2 likes!

Assign error in chatgbt (Non-invocable member can not be used like a method)

Hi @hb61 , Could you try changing to the below Expression and Check if it works : ChatGBTInput["prompt"]

This solution provided by @Anil_G received 1 likes!

Filtering in /odata/jobs?

@Mads_Commerou Please try using filters on time …they look something liek this $filter=TimeStamp ge 2023-01-22T02:00:20.043Z. For more details on api please check the swagger files Get swagger by appending swagger/index.html to your orchestrator url Cheers

---

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

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

[system]

Daily Forum Report | 09 February 2023

Top 3 Topics with Most Views

🆕 Reviews Campaign: Rate UiPath on G2 and get rewarded! made by @Dana_Mustatea with 69 views.

Unique Email Creation made by @Sai.Srinivas with 46 views.

How to format an extracted text made by @alexis.mendoza with 43 views.

Top 3 Topics with Most Replies

Type into not removing previous text and not entering new text made by @Riya_Bansal with 20 replies.

Mail can not sent made by @Shubham_Bidwai with 19 replies.

Unique Email Creation made by @Sai.Srinivas with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 29 posts!

@Shubham_Bidwai made 22 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @Krollythegoalie received 3 likes!

Dev Dives: Slingshot your next Low Code App!

Hello UiPath Community, Do you like seeing examples of UiPath Apps in action? Are you ready to learn how to approach building more complicated Apps? If so, I have some exciting news for you… I’m David Kroll, Director of Product Marketing at Ashling Partners - and I’m thrilled to be on the next Dev Dives episode on Thursday, February 23rd! During my development career, I helped deliver over 20 real-world apps. In this session, I’ll walk through how I approach wireframing and design, the too…

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

Error: "Log Message : Object reference not set to an instance of an object."

the error is happening because you didnt type CourseEmails here, meaning the extracted mails are not assigned to CourseEmails variable type in CourseEmails here, and try again @Islam_ISmail [image]

This post made by @sharon.palawandram received 2 likes!

Submit your AI Use Cases for the UiPath AI Summit 2023, Challenge

Please vote on this use case - Extract structured documents using Forms AI.

Top 3 Most Liked Solutions

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

Error: "Log Message : Object reference not set to an instance of an object."

the error is happening because you didnt type CourseEmails here, meaning the extracted mails are not assigned to CourseEmails variable type in CourseEmails here, and try again @Islam_ISmail [image]

This solution provided by @Yoichi received 2 likes!

Regex to extract nth item from CSV string and save it to a string variable

Hi, If we use regex101 for UiPath, it’s better to set C# at flavor as the following image. And the following pattern will work for your requirement. (?<=^([^,]+,){5})[^,]* [image] [image] Regards,

This solution provided by @kennbalobalo received 1 likes!

Selecting a range of items in an array

Glad to know that the file opened up now. happy to help and contribute to the community!

---

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

Top 3 Topics with Most Views

If condition always comes as false made by @DimiG with 51 views.

Two Excel compare made by @pravin_bindage with 48 views.

Regex to get number made by @Deepa_Madkar with 46 views.

Top 3 Topics with Most Replies

Two Excel compare made by @pravin_bindage with 23 replies.

Regex to get number made by @Deepa_Madkar with 20 replies.

If condition always comes as false made by @DimiG with 18 replies.

Top 3 Users Who Posted The Most

@Yoichi made 29 posts!

@Sudharsan_Ka made 27 posts!

@Anil_G made 22 posts!

Top 3 Most Liked Posts

This post made by @Acovuk received 1 likes!

Issue with "IBM iAccess Client Solutions" - Microsoft C++ Runtime Library Error Popup

Hello guys, I have an issue with the application “IBM iAccess Client Solutions - AS400” when starting a workflow. I get the error message shown below: [Forum1] Expression: !“A HotSpot VM Attach API is attempting to connect to an OpenJ9 VM. This is not supported.” Problem: Microsoft C++ Visual Runtime Library Error A new pop-up appears after every click in the application. It’s not possible to run a workflow within this application… This worked fine for years but now it doesn’t… Can anybod…

This post made by @Yoichi received 1 likes!

How to obtain a new column with those values

HI, Because in the original file write it without header. For now, can you try to add the following expression just after AddDataColumn activity? dtConsolidadoOoutput.Rows(0)("newColumn")="name" [image] Regards,

This post made by @RZVP received 1 likes!

Automation Suite courses - Feedback space

Hi @Hiba_B , The UiPath Automation Suite Installation course has been released as planned, In November 2021. It’s available here: https://academy.uipath.com/courses/uipath-automation-suite-installation. As for the diagrams, some of them are available on the UiPath Documentation portal, for example here: Deployment architecture And if you have specific questions about Automation Suite, I’d suggest to check the threads under the Automation Suite category and ask the questions there. The product…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to convert json String to dictionary

Hi, Can you try the following sample? This outputs datatable. [image] Sample20230210-1L.zip (2.8 KB) Regards,

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

Data scrapping wizard not showing in the panel

Hi @Dileep_D You might have updated the studio Check if there is something called table extraction

This solution provided by @Yoichi received 1 likes!

Merge multiple rows into one based on common column values

HI, The following is grouping by column “Booking No”,“Booking Component ID”, “Item No” and “Booking Status” and concatenate string in “note” column. In remaining column, the first row is kept. Does this work for you? Or do you need grouping by all the columns except “note” column? [image] Sample20230210-4Lv2.zip (21.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 | 11 February 2023

Top 3 Topics with Most Views

I don't quite understand trim made by @CK_CHECK with 34 views.

IF problems with dynamic pages..! made by @CK_CHECK with 33 views.

Dynamic read range made by @Sabbir_Anwar with 28 views.

Top 3 Topics with Most Replies

IF problems with dynamic pages..! made by @CK_CHECK with 6 replies.

How to replace multiple words while working with 3 documents? made by @Alearns with 4 replies.

How to Convert the Parallel Activity to Parallel For Each Activity? made by @ppqrstvwxyz with 4 replies.

Top 3 Users Who Posted The Most

@Anil_G made 28 posts!

@Sudharsan_Ka made 7 posts!

@Yoichi made 6 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

Document Understanding - handle document error

@Camila_Caldas To start with when something fails because of system it is always good to retry before marking exception… So ideally adding it back to queue is good to re processes it… Again …as AI center involves sku’s/AI units which get consumed…if we are extracting information from multiple documents in same transaction and bot failed after extracting one or two and if the exception is unknown we can retry…but to maintain it…it would be good…if the process can be continued or reuse the docu…

This post made by @postwick received 1 likes!

Linq Query - datatable

Use the Join Datatable activity. What you’re trying to do is called a join. It’s a standard database operation.

Top 3 Most Liked Solutions

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

---

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

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

[system]

Daily Forum Report | 12 February 2023

Top 3 Topics with Most Views

Help about regex - UIPath made by @Shoji with 37 views.

UiPath REST API Call made by @Umer_Shahid with 34 views.

How can I change the size of chrome browser? made by @Judy with 32 views.

Top 3 Topics with Most Replies

How to download files and find path from multiple subfolders in SharePoint using 0365 Activities made by @Akshay_Suryawanshi with 12 replies.

Reply to a sent mail of particular date based on Subject made by @IT2_08_Saket_Maurya with 9 replies.

How to calculate percentage in Uipath excel file made by @Sanket_RPA with 7 replies.

Top 3 Users Who Posted The Most

@Yoichi made 10 posts!

@fernando_zuluaga made 8 posts!

@IT2_08_Saket_Maurya made 6 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Help about regex - UIPath

Hi, How about the following? dtPlace.AsEnumerable.Where(function(x) System.Text.RegularExpressions.Regex.IsMatch(CurrentRow("Address").ToString.ToLower, "\b"+x("State").ToString.ToLower + "\b")) Regards,

This post made by @nikhil.girish received 2 likes!

Activity read text file throwing an error

Hi @Prasidh_Krishna Check out this similar topic Hope this might help

This post made by @RPAForEveryone received 1 likes!

How can I change the size of chrome browser?

Hi @Judy As seen in the image I shared, the last row has a shortcut to “reset” zoom level. In your situation, you could use Reset Zoom and then zoom out 10% at a time, as needed. The standard behaviour is each Ctrl + - command zooms out by 10%. So the following three keystrokes with, say, 0.5 or 1-second delay will get you to the right zoom. Send Keystrokes → Ctrl+ 0 (100%) Send Keystrokes → Ctrl + - (90%) Send Keystrokes → Ctrl + - (80%) Adjust as needed

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Help about regex - UIPath

Hi, How about the following? dtPlace.AsEnumerable.Where(function(x) System.Text.RegularExpressions.Regex.IsMatch(CurrentRow("Address").ToString.ToLower, "\b"+x("State").ToString.ToLower + "\b")) Regards,

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

Activity read text file throwing an error

Hi @Prasidh_Krishna Check out this similar topic Hope this might help

This solution provided by @kali received 1 likes!

Reply to a sent mail of particular date based on Subject

I see what u mean now. you can try the following my example here… [image] yourDate is datetime variable. For your case that would be the date your trying to filter. This should be a filter condition for your get email activity: “[SentOn] >= '” + yourDate.ToLongDateString+“’ AND [SentOn] < '” + yourDate.AddDays(1).ToLongDateString+“'” Hope this helps

---

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

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