Forum Engagement Daily Reports

[system]

Daily Forum Report | 19 January 2023

Top 3 Topics with Most Views

How to get the difference in years based on current date made by @Kunal_Jain with 45 views.

I want to loop only one row from excel in flowchart is there any way I can do that just passing number to iterate? made by @Bhushan_Nagaonkar with 39 views.

String to Double Datatable LinQ made by @DimitriLYR with 38 views.

Top 3 Topics with Most Replies

For join data table made by @Shubham_Bidwai with 19 replies.

I want to loop only one row from excel in flowchart is there any way I can do that just passing number to iterate? made by @Bhushan_Nagaonkar with 15 replies.

How to get the difference in years based on current date made by @Kunal_Jain with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 57 posts!

@indra made 18 posts!

@sangeethaneelavannan1 made 17 posts!

Top 3 Most Liked Posts

This post made by @Sushma_Ganapatisa received 2 likes!

You successfully published a package from UiPath Studio to Orchestrator. You did not make any changes to the work, and then published it a second time successfully. When you go into Orchestrator, what will have happened?

Hello Team, Scenario: You successfully published a package from UiPath Studio to Orchestrator. You did not make any changes to the work, and then published it a second time successfully. When you go into Orchestrator, what will have happened? Options are : The package will generate an alert that no changes were made in Orchestrator A new version of the project is sent to Orchestrator only if the Release Notes for the second publish were populated A new version of the project is sent t…

This post made by @vishnuvarthanp received 2 likes!

I want to loop only one row from excel in flowchart is there any way I can do that just passing number to iterate?

Hi @Bhushan_Nagaonkar Please check the below ss: [image]

This post made by @Manoj_sreekanth received 1 likes!

Get only todays files from folder

Facing Error: ‘FileInfo’ is a type and ‘IO’ cannot be used as an expression

Top 3 Most Liked Solutions

This solution provided by @indra received 1 likes!

Check if in string there are 18 digits

@camaro123 You can use regex.ismatch so it will give Boolean result System.Text.RegularExpressions.Regex.IsMatch(str_PdfResult,“(\d{18})”).ToString [image]

This solution provided by @Anil_G received 1 likes!

Unable to Downgrade Package Windows Version Studio

@Kyleb91 This means aome activity needs this specific version of activity to function properly… So first remove the dependecy and then downgrade Cheers

This solution provided by @Anil_G received 1 likes!

SAP-FIORI data table

@dinesh.s1 Use ui explorer and check for static parts in selector 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 | 20 January 2023

Top 3 Topics with Most Views

How to insert variable in open browser link made by @Riya_Bansal with 43 views.

How to split an address to a new life if it is too long? made by @NervousTuber with 42 views.

How to check if a click element is enabled or disabled made by @krishna_r with 41 views.

Top 3 Topics with Most Replies

I have one question and can ane one help me for the solution made by @Shubham_Bidwai with 18 replies.

How to insert variable in open browser link made by @Riya_Bansal with 13 replies.

Where can I find published projects made by @Povilas_Jonikas with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 66 posts!

@Yoichi made 23 posts!

@Sudharsan_Ka made 12 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

How to Extract the fields from pdf using Regex

HI, Can you try the following sample? [image] mc = System.Text.RegularExpressions.Regex.Matches(strData,"^(?<INVREF>\S+)\s+(?<POSTDATE>\d{2}/\d{2}/\d{4}).*?(?<INVDATE>\d{2}/\d{2}/\d{4})\s+(?<GROSSAMOUNT>[-\d.,]+)\s+(?<TDS>[-\d.,]+)\s+(?<AMOUNT>[-\d.,]+)",System.Text.RegularExpressions.RegexOptions.Multiline) Then, set the following at ArrayRow {m.Groups("INVREF").Value,DateTime.ParseExact(m.Groups("POSTDATE").Value,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture),DateTime.Pa…

This post made by @fernando_zuluaga received 2 likes!

How to focus on next tab after click

Hey After clicking that button, use another attach browser activity or use application/browser activity to capture the next page, and then perform your process inside that activity

This post made by @J0ska received 2 likes!

Documentation of uipath

Dear @nora_ziani @ppr wrote you polite and relevant response. In case you want to use such offensive tone pls leave this community. Cheers

Top 3 Most Liked Solutions

This solution provided by @Kalpesh_Chaudhari received 2 likes!

Object reference not set to an instance of object in getText

if still error persists, then try to initialize the variable at start and assign empty string to it.

This solution provided by @Yoichi received 1 likes!

How to split an address to a new life if it is too long?

Hi, Is it no problem if length of 2nd line is greater than 20? If yes, the following regex will work [image] System.Text.RegularExpressions.Regex.Replace(yourString,"^(.{0,20}) ","$1"+vbcrlf) Regards,

This solution provided by @Yoichi received 1 likes!

How to Extract the fields from pdf using Regex

HI, It seems difficult to identify which string should be added to INV.REF string in the previous line. [image] If string to be added always consists of numeric characters at the beginning of the line, the following will work. (However, i suppose it may not work as there are various cases…) [image] Sample20230120-3Lv2.zip (4.6 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 | 21 January 2023

Top 3 Topics with Most Views

Work with pending items in queue made by @Rajshri_Potekar with 40 views.

Loop through invoke workflow activities in flowchart made by @Bhushan_Nagaonkar with 37 views.

Can Check App state be run in background? made by @adrianab.98 with 32 views.

Top 3 Topics with Most Replies

Loop through invoke workflow activities in flowchart made by @Bhushan_Nagaonkar with 12 replies.

Issue running bot after moving the project to a different system made by @Ranjit_Nayak1 with 12 replies.

I want to compare two excels and update the data in third sheet in excel where each sheet contains 100k line items made by @Ranganathan_M with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 36 posts!

@sunilch made 9 posts!

@Bhushan_Nagaonkar made 7 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

Manage Packages Marketplace Error: No compatible version with windows projects

@Atakan_Genc On the old computer I believe you created the project in windows - Legacy…and not windows compatible You can change it when you create a new project …with the name you can also select windows,windows-legacy or cross platform Even here if you select windows-Legacy then it will show you the packages [image] Cheers

This post made by @Atakan_Genc received 1 likes!

Manage Packages Marketplace Error: No compatible version with windows projects

Thanks a lot.

This post made by @Anil_G received 1 likes!

Loop through invoke workflow activities in flowchart

@Bhushan_Nagaonkar Use read cell to read the value of the count into a variable… Now use a while loop with max iteration value as the value read from the cell… So the loop would continue for those many times Cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Manage Packages Marketplace Error: No compatible version with windows projects

@Atakan_Genc On the old computer I believe you created the project in windows - Legacy…and not windows compatible You can change it when you create a new project …with the name you can also select windows,windows-legacy or cross platform Even here if you select windows-Legacy then it will show you the packages [image] Cheers

This solution provided by @Anil_G received 1 likes!

Loop through invoke workflow activities in flowchart

@Bhushan_Nagaonkar This is how it looks…condition will be true means it will loop till max iteration value…which you will read from excel using read data [image] 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 | 22 January 2023

Top 3 Topics with Most Views

Separate the name made by @Muneer_Alrashdan with 44 views.

Regex Matches with Anchors made by @Beere_Plays with 40 views.

Http Request unknown host Error made by @Man_Kay_So with 35 views.

Top 3 Topics with Most Replies

RESULT からの例外:0x800706BE made by @miwa_yamamoto with 16 replies.

Unable to define solution approach for multiple attachments made by @rds0511 with 7 replies.

Cannot anchor PDF file data made by @Isabel_Chau with 5 replies.

Top 3 Users Who Posted The Most

@Anil_G made 23 posts!

@rds0511 made 8 posts!

@fernando_zuluaga made 7 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

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

@cellery Welcome to the community For adding array you have to use flower/curly brackets not round.please try this {"John","Don"} Hope this helps Cheers

This post made by @Yoichi received 1 likes!

Can not assign 'Convert.ToDouble(row("Amount").ToString)

Hi, Which do you need to handle “24.28-”, as positive or negative? If positive Convert.ToDouble(row("Amount").ToString.TrimEnd("-"c)) +dbSumAmount If negative Convert.ToDouble(System.Text.RegularExpressions.Regex.Replace(row("Amount").ToString,"^([.,\d]+)(-)?$","$2$1")) +dbSumAmount Hope the above helps you. Regards,

This post made by @Comet received 1 likes!

Leap year

Thank you very much! This again solved my problem.

Top 3 Most Liked Solutions

This solution provided by @fernando_zuluaga received 1 likes!

What is the ideal way of creating libraries?

in every project that we develop, remove the unused dependecies will be a good practice to apply, no matters if the projects is a sequence or library etc, we should remove all of them and just keep the used dependencies. Library won’t affect the project perfomance, just remember to publish then in the orchestrator if you will move to production environment For example if you run the analyze file it will retrieve you a warning in case that you dont delete the unused depencies [image] Regards! …

This solution provided by @Yoichi received 1 likes!

Call cell from data table with Variables

Hi, Which type of variables do you use : in_dtItems, RowCount and ColumnCount? If in_dtItems is DataTable and RowCount and ColumnCount are String type and store index value of row or column, the following will work. in_dtItems( CInt(RowCount))( CInt(ColumnCount)).ToString or in_dtItems.Rows(CInt(RowCount))( CInt(ColumnCount)).ToString 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 | 23 January 2023

Top 3 Topics with Most Views

How to pass the assign value as an argument(datatable) so that I can add the value to "add data row" activity made by @Bhushan_Nagaonkar with 64 views.

One environment per tenant? made by @jaime.salazar with 48 views.

Reframework - Add key/value pair:Column'Value' does not belong to table datatable made by @ldiaz with 47 views.

Top 3 Topics with Most Replies

(I am a beginner) . I was trying to change the variable type but it's not allowing me. I can only keep the default (string) made by @akheelahmad with 19 replies.

Cv computer click is not clickable when text is not visible made by @nora_ziani with 11 replies.

Datatable convert automatically from General Number to Date made by @IPIX with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 24 posts!

@Yoichi made 18 posts!

@sangeethaneelavannan1 made 14 posts!

Top 3 Most Liked Posts

This post made by @kakoozavian received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello here, I am Kakooza Vianey from East Africa, Kampala Uganda, currently doing the RPA Foundations with Ui Path, I have been working with automation using python and thats how I landed on Ui Path. Hope to have a great interaction here. Thank you

This post made by @jaime.salazar received 2 likes!

One environment per tenant?

I should have mentioned that I’m talking about Orchestrator Cloud (and not on-prem) because that appears to make a big difference. With the Cloud version, it seems like the multi-tenant approach is good enough, as explained by @Anil_G. On the other hand, with the on-prem version, multiple Orchestrator instances is probably best, as explained by @vishnuvarthanp. Since my case is the former, I suppose Anil’s solution is the most relevant, although I appreciate Vishnu’s as well.

This post made by @Gokul_Jayakumar received 2 likes!

I try to save excel file in today date in one specific folder

Hello @krishna_priya1 Try this "Yourpath\Samplefile_"+Datetime.now.tostring("dd_MM_yyyy")+".xlsx" If you need to save in Project loaction Environment.currentdirectory+("\Samplefile_"+Datetime.now.tostring("dd_MM_yyyy")+".xlsx").tostring

Top 3 Most Liked Solutions

This solution provided by @Gokul_Jayakumar received 2 likes!

I try to save excel file in today date in one specific folder

Hello @krishna_priya1 Try this "Yourpath\Samplefile_"+Datetime.now.tostring("dd_MM_yyyy")+".xlsx" If you need to save in Project loaction Environment.currentdirectory+("\Samplefile_"+Datetime.now.tostring("dd_MM_yyyy")+".xlsx").tostring

This solution provided by @Anil_G received 1 likes!

One environment per tenant?

@jaime.salazar So …to answer your question let me give ypu scenarios… When using on prem people prefer multiple orchestrators as it would be easier for upgrade of different environment… But when coming to automation cloud the upgrades and load balancing is not taken care by us…which is much smoother…so a multi tenant would be good as per the licensing cost and the ease of access Hope this helps Cheers

This solution provided by @marian.platonov received 1 likes!

Upgrade studio pro 2020.4 to the latest enterprise edition 2022.10.4

Here you can find the latest Enterprise UiPath Studio 2022.10.4 https://download.uipath.com/versions/22.10.4/UiPathStudio.msi

---

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 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.