Forum Engagement Daily Reports

[system]

Daily Forum Report | 06 May 2022

Top 3 Topics with Most Views

Confused in String made by @Himanshu_Pratap_Rana with 48 views.

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

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

Top 3 Topics with Most Replies

Get assets made by @happyfeat87 with 22 replies.

Confused in String made by @Himanshu_Pratap_Rana with 21 replies.

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

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 68 posts!

@Nithinkrishna made 51 posts!

@postwick made 28 posts!

Top 3 Most Liked Posts

This post made by @Security_Kevin received 4 likes!

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

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

This post made by @Hendrix_Santos received 2 likes!

Transcribe a name correctly

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

This post made by @Razvan_Dumitru received 2 likes!

Postman, Swagger showing You are not authenticated!

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

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Licenses classic vs modern folder

Yep @maxena2872 You are right, Thanks

This solution provided by @Nithinkrishna received 1 likes!

Copy sheets to a new workbook and rename the

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

This solution provided by @fernando_zuluaga received 1 likes!

Rename Excel Sheet for MULTIPLE Excel Files

hey try this [image] Regards!

---

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

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

[system]

Daily Forum Report | 07 May 2022

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Nithinkrishna made 29 posts!

@Rahul_Unnikrishnan made 26 posts!

@jack.chan made 13 posts!

Top 3 Most Liked Posts

This post made by @fernando_zuluaga received 2 likes!

How to Run UiPath studio and Studiox on same computer

hey check this Regards!

This post made by @METALI_Garg_US received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

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

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

Top 3 Most Liked Solutions

This solution provided by @fernando_zuluaga received 2 likes!

How to Run UiPath studio and Studiox on same computer

hey check this Regards!

This solution provided by @Yoichi received 1 likes!

Rename Excel Sheet for MULTIPLE Excel Files

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

This solution provided by @Nithinkrishna received 1 likes!

Desktop automation source from excel update DAY

Hey @Ravi_R You can automate that as well using Click activity and dynamic selector with a variable in it. And the variable will hold the day value in it. Thanks #nK

---

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

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

[system]

Daily Forum Report | 08 May 2022

Top 3 Topics with Most Views

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

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

Click on context made by @A_Learner with 40 views.

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Nithinkrishna made 53 posts!

@Rahul_Unnikrishnan made 39 posts!

@ydash999 made 13 posts!

Top 3 Most Liked Posts

This post made by @Sunshine_Summerville received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

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

This post made by @Abdul_Samad_Qureshi received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

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

This post made by @Saltukhan_Dura received 1 likes!

Given key is not present in dictionary

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

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Palindrome of string without using Reverse function?

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

This solution provided by @Nithinkrishna received 1 likes!

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

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

This solution provided by @Joysogood received 1 likes!

Bring up Data Scraping tool

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

---

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

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

[system]

Daily Forum Report | 09 May 2022

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Nithinkrishna made 105 posts!

@Rahul_Unnikrishnan made 87 posts!

@ppr made 22 posts!

Top 3 Most Liked Posts

This post made by @praveenchintu374 received 3 likes!

UIDemo App Apk,Username And Password

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

This post made by @Kotla_Gunasekhar received 2 likes!

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

Received my gift voucher

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

Add Queue Item using API

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

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 2 likes!

Why this error is showing?

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

This solution provided by @Rahul_Unnikrishnan received 2 likes!

How to connect UiPath studio with Orchestrator?

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

This solution provided by @Rahul_Unnikrishnan received 1 likes!

Getting text from website using OCR

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

---

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

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

[system]

Daily Forum Report | 10 May 2022

Top 3 Topics with Most Views

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

Version question made by @A_Learner with 42 views.

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 80 posts!

@Nithinkrishna made 59 posts!

@ppr made 31 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

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

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

This post made by @jeevith received 2 likes!

Creating error-proof reusable workflows in UiPath

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

This post made by @Yoichi received 2 likes!

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

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

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

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

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

This solution provided by @ppr received 2 likes!

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

have a check with working on immediate panel [grafik]

This solution provided by @Srini84 received 1 likes!

How to add another account to Uipath

@raju_alakuntla It’s better if you add more details to your issue Are you trying to add another Community account like a Tenant? If that is the case, then it won’t be possible in Community Account Hope this may help you Thanks

---

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

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

[system]

Daily Forum Report | 11 May 2022

Top 3 Topics with Most Views

Update column based on pattern made by @Harbansh_Singh with 45 views.

Excel filling made by @alexis.mendoza with 39 views.

「拡張機能を有効化する必要がある」というエラーが出る made by @sakurako_iwado with 37 views.

Top 3 Topics with Most Replies

Time Conversion Issue in Linq made by @Shyam_Pragash with 21 replies.

What kind of scraping method will work in remote desktop SQL application? made by @BlackCurrant with 20 replies.

How to select this one made by @meeraa with 19 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 64 posts!

@postwick made 34 posts!

@Nithinkrishna made 33 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

Trim the string

Hi, Can you try the following expression? System.Text.RegularExpressions.Regex.Match(yourString,"\d{8}\..+$").Value Regards,

This post made by @Iulian_Marin received 2 likes!

UiPath Chrome Manifest V3 Extension Released with 2022.4 Update

UiPath Chrome Manifest V3 Extension Released with 22.4 Update Context The adoption of Manifest V3 represents one of the biggest shifts in the Google Chrome extensions platform since it launched a decade ago. Extensions using Manifest V3 will enjoy enhancements in security, privacy, and performance. The new UiPath Chrome MV3 extension We’ve implemented a completely new extension following the Manifest V3 standard released by Google. This new extension can be installed from both Studio ->Tools…

This post made by @cheez_RPA received 2 likes!

「拡張機能を有効化する必要がある」というエラーが出る

いちど、UiPathの画面からアンインストールのうえ、再インストールをしてみてください。

Top 3 Most Liked Solutions

This solution provided by @william.coulson received 1 likes!

Trim the string

Hi @happyfeat87, Try using Regex to get that item out, and then replace it with nothing: In an assign: RegexItem = In a seperate assign: Filepath = Filepath.Replace(RegexItem,"") If RegexItem is “20220511.zip”, then replacing it with nothing should give you the expected filepath. Edit: Though, if you already have the filepath, you won’t need to manipulate it? You’re already referring to it: Just assign everything before the first & to a variable.

This solution provided by @ppr received 1 likes!

Find "&" mark

please let us know when YourString.Contains("&") is not working for your scenario

This solution provided by @Yoichi received 1 likes!

Split string with decimal places

Hi, I don’t think it’s correct regex pattern. Does this work? If you want to extract decimal number:1000, the following will work. (?<=EB\*C\*IND\*30\*\*\*23\*)[.\d]+(?=\*+Y) 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 | 12 May 2022

Top 3 Topics with Most Views

How to connect orchestrator with a robot and deploy it made by @Sawaira_Nawaz with 37 views.

How to Check if PopUp Selector exists made by @VanjaV with 35 views.

Methods used to deploy nugets from dev environment to prod environment? made by @ydash999 with 33 views.

Top 3 Topics with Most Replies

Print excel file format country code and iban number separately made by @ertan_ay1 with 18 replies.

Methods used to deploy nugets from dev environment to prod environment? made by @ydash999 with 14 replies.

Invoke java method and pass two arguments from uipath made by @sowmya.krishna with 13 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 56 posts!

@ppr made 20 posts!

@Nithinkrishna made 20 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 2 likes!

UiPath Chrome Manifest V3 Extension Released with 2022.4 Update

Hello @Iulian_Marin, These mitigation options are great to know as we are planning to upgrade our instances. Out ot curiosity Does the new extension provide additional benefits ( other than the official support period from Google) ? For others wondering how to get around this behaviour: @Werve and @Mike_Campbell have proposed a working workaround in this thread : Chrome extension malfunction after auto-update to 22.4 - Help / Studio - UiPath Community Forum

This post made by @ppr received 2 likes!

Error in Add Data Row Activity

Lets assume project is set to C#: can your try: new object[]{"test"}; kindly note the closing ;

This post made by @amithvs received 1 likes!

SFTP authentication

Hey @loginerror . Sorry for the late reply. During the time of issue UiPath support provided me with a custom SFTP package with the fix. The team confirmed it is a known issue with the SFTP package and will be resolved by next update. I haven’t tried it after the update, hopefully it’s fixed.

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Error in Add Data Row Activity

Lets assume project is set to C#: can your try: new object[]{"test"}; kindly note the closing ;

This solution provided by @HarishV received 1 likes!

Add Queue Item using API

Hi @john.mari, Please verify the below mentioned format. "{""itemData"": {""Name"": ""Value1"",""Priority"": ""Value2"",""SpecificContent"": {""Data"": ""[{\""Key3\"":\""Test\"",\""Key4\"":\""TES8\"",\""Key5\"":\""Test\"",\""Key6\"":\""1234Street\""}]""}}}" Try this in the “Body” parameter of “HttpRequest” activity. Thanks

This solution provided by @Sam_Abraham received 1 likes!

How to give timeout of 40 mins in integer bcz it's giving issue while running the code? Urgent plz help

Hi @anjasing , It seems there is an additional space comming after "2400000 " . You can use trim cint(in_Config(“TimeoutUltraLongest”).ToString.trim)

---

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

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

[system]

Daily Forum Report | 13 May 2022

Top 3 Topics with Most Views

Document is invalid- Unable to open the Workflow file made by @Dhanush_Naik1 with 48 views.

Input string was not in correct format for NULL value in queue made by @Sathish_Kumar_S with 43 views.

Help me to solve made by @mu_nazza with 37 views.

Top 3 Topics with Most Replies

Create Pivot table in different sheet of same excel made by @Riya1 with 21 replies.

Document is invalid- Unable to open the Workflow file made by @Dhanush_Naik1 with 19 replies.

Filtrado excel made by @alexis.mendoza with 14 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 74 posts!

@jack.chan made 23 posts!

@supermanPunch made 20 posts!

Top 3 Most Liked Posts

This post made by @Nithinkrishna received 2 likes!

Input string was not in correct format for NULL value in queue

Hey @Sathish_Kumar_S I’m assuming technology variable is holding the value either 80 or empty Just reverse the condition, String.IsNullOrEmpty(TechnologyVar) orElse CInt(TechnologyVar) >= 80 Hope this helps Thanks #nK

This post made by @whitestar received 1 likes!

Latest UiPath System/UiAutomation activities Issues

Hi @loginerror We are still using version 21.10.4 for our chrome extension . So it could be why some of the selector are not working anymore with older package version. Before even if we downgrade the packages version we are still able to use the activities at least until version 2021.10 packages. I will discuss together with technical support for this issue as well. Thank You

This post made by @Razvan_Dumitru received 1 likes!

Postman, Swagger showing You are not authenticated!

@Nithinkrishna Swagger Authorize button is tightly coupled with cookie to access token based authentication migration. This feature is currently in rollout phase and it will be available to all users next week.

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 2 likes!

Input string was not in correct format for NULL value in queue

Hey @Sathish_Kumar_S I’m assuming technology variable is holding the value either 80 or empty Just reverse the condition, String.IsNullOrEmpty(TechnologyVar) orElse CInt(TechnologyVar) >= 80 Hope this helps Thanks #nK

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

<Urgent> How to make a selector a variable so that it can only click on the particular date value only?

can you filter your datatable so that its only yesterdays date first? [image] do you have screenshot of what youre trying to click/?

This solution provided by @ashwini.kempraj received 1 likes!

Installing Studio on VM machines

Hi @OzogRPA, You can install uipath community version on many VMs as required. But community version has limited number of licenses - only 3 robots. Hope this helps. Thanks Ashwini Kempraj

---

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

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

[system]

Daily Forum Report | 14 May 2022

Top 3 Topics with Most Views

Option to resize the component JSON window in form designer made by @jeevith with 59 views.

Get Data before special character made by @Abang_Jamuri_Abang_Shoker with 34 views.

Send Exchange Mail Message: Value cannot be null. Parameter name: fileName made by @Sathish_Kumar_S with 33 views.

Top 3 Topics with Most Replies

How to know if queue items are present using studio made by @ydash999 with 10 replies.

HELP PLEASE. Facing a problem with Column “qty” does not belong to table datatable made by @Kai_Xin_Kho with 9 replies.

Run query: ORA-00936: missing expression made by @sushantchanakhekar2299 with 8 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 16 posts!

@Rahul_Unnikrishnan made 15 posts!

@Yoichi made 7 posts!

Top 3 Most Liked Posts

This post made by @Smars received 3 likes!

How to know if queue items are present using studio

“Get Queue Item” is a suitable activity, see the following link for more information:

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

Send Exchange Mail Message: Value cannot be null. Parameter name: fileName

@Sathish_Kumar_S Main.xaml (8.8 KB) define attachmentList variable [image] [image] if not string.IsNullOrEmpty(in_Attachment) then assign attachmentList = in_Attachment.Split(","c).ToList [image] pass attachment list to send outlook mail message attachmentsCollection property [image]

This post made by @Rahul_Unnikrishnan received 2 likes!

HELP PLEASE. Facing a problem with Column “qty” does not belong to table datatable

Hello @Kai_Xin_Kho If your column name is not working you can use the column index to read the data from that particular column Like Currentrow(0).Tostring will read data from the first column. Also it would be better if you can share the screenshot of the excel which you are reading. If you are using column name, then inside the Read Range activity you have to enable “Add Headers” in the property panel. Also make sure “Qty” is a valid column name in that excel.

Top 3 Most Liked Solutions

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

Send Exchange Mail Message: Value cannot be null. Parameter name: fileName

@Sathish_Kumar_S Main.xaml (8.8 KB) define attachmentList variable [image] [image] if not string.IsNullOrEmpty(in_Attachment) then assign attachmentList = in_Attachment.Split(","c).ToList [image] pass attachment list to send outlook mail message attachmentsCollection property [image]

This solution provided by @Yoichi received 1 likes!

Get Data before special character

Hi, FYI, another solution [image] Sample20220514-1.zip (2.4 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 | 15 May 2022

Top 3 Topics with Most Views

How to automate copy selection from body from email to excel file? made by @Wilich with 39 views.

How Can i Select the particular option from menu in Notepad using Click Activity? made by @kishan.savaliya with 33 views.

How to be a junior RPA? made by @esraa_elzoghby with 33 views.

Top 3 Topics with Most Replies

Make this C# code usable in UiPath made by @Dhruvi_Arumugam with 11 replies.

Is there a way to add a Trigger button in the Tableau dashboard to launch the robot to export the dashboard pdf format? made by @Sumit_Yadav_30 with 7 replies.

Why it is showing "studio has detected that your license information is changed" below uipath studio made by @opkushwaha999 with 6 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 31 posts!

@Nithinkrishna made 7 posts!

@Riya1 made 7 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 3 likes!

How to know if queue items are present using studio

Hi @ydash999 and @Divyashreem, Avoid Get Transaction Item if you are only checking for existence of queue items Do not use the Get Transaction Item to check if there are queue items if you are not going to process them at the same time. Get Transaction Item will lock the item to in-progress in the queue. So it tells you there are items, but it can also remove one item from processing and edit its state. Get Queue Items is a safer activity for such checks If you want to check the queue has it…

This post made by @Rahul_Unnikrishnan received 2 likes!

How to wait till process is going on

Hello, Is it resolved?? Else can you give more insight to the requirement.

This post made by @Rahul_Unnikrishnan received 2 likes!

Why to use bulk insert activity that is coming with new database. activities?

Hello @ydash999 Bulk insert can be useful if you have a Datatable to insert into database. So just consider you are getting some values from the web page and you need to insert that to database. One approach is you can Insert to DB in each Iteration using Insert activity. So for each iteraction Uipath will call DB to insert data. But if you are looping and collecting data from webpage and inserting that to a data table. And once all the data get added to the data table you can use Bulk insert…

Top 3 Most Liked Solutions

This solution provided by @jeevith received 3 likes!

How to know if queue items are present using studio

Hi @ydash999 and @Divyashreem, Avoid Get Transaction Item if you are only checking for existence of queue items Do not use the Get Transaction Item to check if there are queue items if you are not going to process them at the same time. Get Transaction Item will lock the item to in-progress in the queue. So it tells you there are items, but it can also remove one item from processing and edit its state. Get Queue Items is a safer activity for such checks If you want to check the queue has it…

This solution provided by @Rahul_Unnikrishnan received 2 likes!

Why to use bulk insert activity that is coming with new database. activities?

Hello @ydash999 Bulk insert can be useful if you have a Datatable to insert into database. So just consider you are getting some values from the web page and you need to insert that to database. One approach is you can Insert to DB in each Iteration using Insert activity. So for each iteraction Uipath will call DB to insert data. But if you are looping and collecting data from webpage and inserting that to a data table. And once all the data get added to the data table you can use Bulk insert…

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

How Can i Select the particular option from menu in Notepad using Click Activity?

@kishan.savaliya refer to this Main.xaml (8.7 KB)

---

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

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

[system]

Daily Forum Report | 16 May 2022

Top 3 Topics with Most Views

Get Largest number out of Array of Strings made by @esakkiappan.b with 53 views.

Delete Lines Text File Issue made by @Abang_Jamuri_Abang_Shoker with 50 views.

How to count the number of leaves,weekends and holidays in a month based on the bot running month made by @Chippy_Kolot with 46 views.

Top 3 Topics with Most Replies

Delete Lines Text File Issue made by @Abang_Jamuri_Abang_Shoker with 11 replies.

Wait Element Vanish Activity is not working Properly made by @kishan.savaliya with 11 replies.

Dependencies Error made by @leandro.medeiros with 10 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 48 posts!

@ppr made 25 posts!

@ashwini.kempraj made 24 posts!

Top 3 Most Liked Posts

This post made by @Jon_G received 2 likes!

Page doesn't load until connect to VM

I found the solution to my own problem. Hope this helps others. in Chrome go to chrome://flags and go to ‘Calculate window occlusion on Windows’ and Disable it from the dropdown box. Relaunch chrome, and it will work. The issue was that with this setting enabled, sometimes Chrome is waiting for the window to be manually ‘focused’ before loading the full page contents. This was causing issues with UiPath for this URL I was trying to navigate as a background process. Hope this hel…

This post made by @ashwini.kempraj received 1 likes!

Update data table coloum with linq

Hi @Harbansh_Singh, From that code snippet, (row(“Col2”).Tostring).Equals(“dummy”) is a condition that returns true or false. Hence it’s updating the boolean value. You may try this: (From row in dttest Let x = new object (){row(“Col1”).Tostring, “dummy”)} Select dtoutput.rows.add(x)). copytodatatable Hope this helps. Thanks, Ashwini Kempraj

This post made by @Harbansh_Singh received 1 likes!

Update data table coloum with linq

@supermanPunch Yes its worked now, instead of col2 in need to give the value which i need to update. Thanks for your explanation

Top 3 Most Liked Solutions

This solution provided by @Jon_G received 2 likes!

Page doesn't load until connect to VM

I found the solution to my own problem. Hope this helps others. in Chrome go to chrome://flags and go to ‘Calculate window occlusion on Windows’ and Disable it from the dropdown box. Relaunch chrome, and it will work. The issue was that with this setting enabled, sometimes Chrome is waiting for the window to be manually ‘focused’ before loading the full page contents. This was causing issues with UiPath for this URL I was trying to navigate as a background process. Hope this hel…

This solution provided by @ashwini.kempraj received 1 likes!

Update data table coloum with linq

Hi @Harbansh_Singh, From that code snippet, (row(“Col2”).Tostring).Equals(“dummy”) is a condition that returns true or false. Hence it’s updating the boolean value. You may try this: (From row in dttest Let x = new object (){row(“Col1”).Tostring, “dummy”)} Select dtoutput.rows.add(x)). copytodatatable Hope this helps. Thanks, Ashwini Kempraj

This solution provided by @Yoichi received 1 likes!

Remove default tittle on charts

Hi, Can you try UpdateChart activity as the following? [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 | 18 May 2022

Top 3 Topics with Most Views

Can Not Type Text in Text Box of Website made by @SimonS with 43 views.

Comparing 2 columns and i am new to automation please give me the full solution made by @sunil.kumar.s.v with 39 views.

Extract data from RegEx and output to csv file made by @John133 with 38 views.

Top 3 Topics with Most Replies

Comparing 2 columns and i am new to automation please give me the full solution made by @sunil.kumar.s.v with 17 replies.

Create pivot table by choosing rows and columns made by @Riya_Sharma with 15 replies.

Persistance must be configured error made by @Andrei_Croitoru with 14 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 51 posts!

@ppr made 44 posts!

@lakshman made 21 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Generic value and object diff

Have a first look here: https://docs.uipath.com/studio/docs/types-of-variables

This post made by @ppr received 2 likes!

How to find the string wont contain particular string

Maybe you are in a hurry, but we would also appreciate it if you close answered topics. Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum We do see the list and also that very quickly new topics are opened. Thanks for support

This post made by @ppr received 2 likes!

Selecting items from drop down menu

lets assume following: indicate item failed with … not supported click on 1 [grafik] replace line [grafik] Save and test

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Selecting items from drop down menu

lets assume following: indicate item failed with … not supported click on 1 [grafik] replace line [grafik] Save and test

This solution provided by @Yoichi received 1 likes!

文字列を1つ目のハイフンで分割したいです

こんにちは ご参考までに別解です。 テキストを左右に分割アクティビティも使えると思います。 [image]

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

Unable to find enviroment feature in orchestrator

you can think of folders as environments configure folders in tenant-> folder. You can create folders by clicking [image] here i have 3 folders uat/PRD/shared . They act the same way as environments in classic folders [image]

---

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

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

[system]

Daily Forum Report | 19 May 2022

Top 3 Topics with Most Views

Type conversion exception problem made by @Priyanka_Jharia with 41 views.

Getting error while trying to get distinct values from database table and covnert to Array made by @MitheshBolla with 38 views.

While Working on Excel Sheet I am getting time also along with Date , How to remove it? made by @Kunal_Jain with 37 views.

Top 3 Topics with Most Replies

While Working on Excel Sheet I am getting time also along with Date , How to remove it? made by @Kunal_Jain with 26 replies.

Retrieve information from an email made by @DimitriLYR with 20 replies.

Getting error while trying to get distinct values from database table and covnert to Array made by @MitheshBolla with 19 replies.

Top 3 Users Who Posted The Most

@postwick made 49 posts!

@Rahul_Unnikrishnan made 31 posts!

@muhammedyuzuak made 31 posts!

Top 3 Most Liked Posts

This post made by @ydash999 received 2 likes!

Split string and keep each character in a datatable

in column separator i only saw the given characters, i didnt try inputing the “-”, so was confused. now solved. thanks bro!

This post made by @ppr received 2 likes!

Getting error while trying to get distinct values from database table and covnert to Array

@MitheshBolla Perfect, it is working May I ask you to flag @supermanPunch for the solution. He supported you and gave you the required hint at first. Thanks

This post made by @supermanPunch received 2 likes!

Error running from orchestrator: Failed to install package. Unable to find package

Hi @jack.chan , Have you Checked the Below Post :

Top 3 Most Liked Solutions

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

Need to copy a particular excel to destination

assign filesArray (Array of string variable) = Directory.GetFiles(folderPath) assign oldestFile (string variable) = filesArray.AsEnumerable().Where(function(file) Datetime.TryParseExact(path.GetFileNameWithoutExtension(file), "dd-MMM-yyyy",nothing, nothing, nothing)).ToArray.AsEnumerable().OrderBy(function(x) cdate(Path.GetFileNameWithoutExtension(x))).first [image]

This solution provided by @supermanPunch received 1 likes!

Split string and keep each character in a datatable

Hi @ydash999 , Maybe you could also Check with Generate Datatable Activity. [image]

This solution provided by @supermanPunch received 1 likes!

Getting error while trying to get distinct values from database table and covnert to Array

Hi @MitheshBolla , Have you tried following the Steps in the Below Post : Also, Do Check if System.Linq is imported in your xaml first by checking in the imports section.

---

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

Top 3 Topics with Most Views

How to divide the 2 datatables from one sheet to different sheet made by @bhanupriya.cb with 45 views.

Comparing two excel columns and updating corresponding values made by @praveenchintu374 with 43 views.

How to Use Element Exists and Excel Application Scope In parallel, for Excels with Pop-up Macro made by @Archie with 43 views.

Top 3 Topics with Most Replies

Compare two datatables and get unique value from dt1 made by @Sahil_Garg1 with 19 replies.

How to divide the 2 datatables from one sheet to different sheet made by @bhanupriya.cb with 18 replies.

Problem with Send Hotkey made by @comdatos with 13 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 52 posts!

@muhammedyuzuak made 28 posts!

@ppr made 20 posts!

Top 3 Most Liked Posts

This post made by @Praga_Vivek received 2 likes!

UiPath Forms Tutorial - Check / Uncheck All Select Boxes

Hi, Recently, I came across a customer requirement where we need to check / uncheck all select boxes in an UiPath form. I am able to come up with a working solution after doing some R&D. I wanted to share the solution for the benefit of others. Below are the steps to build Check/Uncheck All option for select boxes in an UiPath form. Create a form and add a Select box and Button component Add few values to the select boxes and rename the button component like below [formDesign] Edit t…

This post made by @joergen_moeller received 2 likes!

How to learn c#

Hi @Aleem_Khan, There are many tutorials online for C#. Keep in mind that the default language for UiPath processes are VB, because of this a majority of the documentation and syntax shared on the forums are VB. However, I believe a more advanced knowledge in C# will help you regardless as you will develop a broader understanding of the possibilities with C# and .Net. If you want advanced examples on working with Excel in Uipath you can check out this link: For a general approach to C# you c…

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

Click into Details for SAP VA01 Create Sales Order

@jmcheong7 theres a tableRow attribute in the selector [image] 0= 1st row, 1 = second row and so on… you can make it dynamic by using an integer variable e.g. [image] then update tableRow attribute in selector to this tableRow='{{tableRow}}'

Top 3 Most Liked Solutions

This solution provided by @Srini84 received 1 likes!

Save subfolder name to variable

@Jack_Seven_Offsuit You can try as below to get all the folders in the path Declare a String variable let’s say as ListofFolders Use Assign activity and write as below ListofFolders = Directory.GetDirectories(“C:\users\00001”) Use For Each activity and change the TypeArgument to String in properties Inside For Each you can keep a write line message and write as Item.ToString which will give you the all the each directory it contains Hope this may help you Thanks

This solution provided by @Praga_Vivek received 1 likes!

Select all checkbox UiPath.Forms.Activities

Hi @Stephanie_Rimel / @jeevith , This can be implemented using advanced logic. Please find the attached project containing a working example. Sample Project.zip (14.1 KB) I have also created a tutorial for this feature Thanks, Praga

This solution provided by @Yoichi received 1 likes!

What I need to fill for Spreadsheet?

Hi, Can you try Spreadsheet as the following? [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 | 21 May 2022

Top 3 Topics with Most Views

Linq to math round 3 decimals column of string made by @dyuonn.bakker with 41 views.

Cron Expression- Unattended Bot made by @Konda_Sai_Charan_Goud with 38 views.

How to read multiple invoices in subfolders made by @Poojitha with 34 views.

Top 3 Topics with Most Replies

How to read multiple invoices in subfolders made by @Poojitha with 8 replies.

Automated triggering of flows to decrease time gaps made by @saurabhB with 8 replies.

Linq to math round 3 decimals column of string made by @dyuonn.bakker with 7 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 32 posts!

@Rahul_Unnikrishnan made 27 posts!

@muhammedyuzuak made 10 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 2 likes!

How to learn c#

Hi VB.NET CODING IN UIPATH.pdf (4.1 MB) Check this doc with all basic and advanced coding knowledge that is required to implement with UiPath Cheers @Aleem_Khan

This post made by @Palaniyappan received 2 likes!

How to read only specific row from Pivot table and write in another workbook-Sheet1?

Hi We can use GET TABLE RANGE activity where mention the range of table or row and enable Is Pivot Have a view on this for more details Cheers @Prabin_Chand

This post made by @Palaniyappan received 2 likes!

Linq to math round 3 decimals column of string

Hi Hope this expression in assign activity would help you resolve this dtData = (From r In dtData.AsEnumerable let ra = r.ItemArray.Select(Function (x) Convert.ToDecimal(x.ToString.Trim).ToString(“F3”)).toArray() Select dtCorrected.Rows.Add(ra)).CopyToDataTable() Or dtData = (From r In dtData.AsEnumerable let ra = r.ItemArray.Select(Function (x) Math.Round(Convert.ToDecimal(x.ToString.Trim),3)).toArray() Select dtCorrected.Rows.Add(ra)).CopyToDataTable() Cheers @dyuonn.bakker

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 2 likes!

How to learn c#

Hi VB.NET CODING IN UIPATH.pdf (4.1 MB) Check this doc with all basic and advanced coding knowledge that is required to implement with UiPath Cheers @Aleem_Khan

This solution provided by @Palaniyappan received 1 likes!

Create time trigger with two timings to run the job

Hi Welcome to uipath forum To be very simple create two normal schedules One for 8:00 and another 7:30 Let’s not complicate with cron expression here Just two triggers with two timings As simple as that Even if you want to create two schedules with CRON Then for 8:00 AM 0 0 8 ? * * * For 7:30 PM 0 30 19 ? * * * Anyhow it requires two different schedules So rather create with simple schedule Cheers @NavyaKattikireddy

This solution provided by @joergen_moeller received 1 likes!

Issue with replacing value of XML element attribute

Thank you, @Rahul_Unnikrishnan. By reading the last thread you posted I understood that you do not need to specify the schemeID within the namespace. Only refering to EndpointID is sufficient. For anyone that may experience this issue the solution is to exclude the scheme ID within the element name: DeserializedXML.Element(NsCatalogue+"Catalogue").Element(NsCac+"ContractorCustomerParty").Element(NsCac+"Party").Element(NsCbc+"EndpointID").Value

---

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

Top 3 Topics with Most Views

Get similar data repeatedly in loop from within pdf file made by @Rimsha_Aizaz1 with 42 views.

Convert PDF to Excel format made by @dev_rpa with 37 views.

Cannot send email from gmail account to outlook account made by @emshihab with 36 views.

Top 3 Topics with Most Replies

How to open a Excel with a pop up msgbox? made by @JP_Chang with 11 replies.

Assignment 2 - Generate Yearly Report - The robot working fine and produces the required results-Submitted several times but the grade shows Failed made by @Sevuga_Perumal with 9 replies.

Get similar data repeatedly in loop from within pdf file made by @Rimsha_Aizaz1 with 9 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 19 posts!

@Palaniyappan made 16 posts!

@muhammedyuzuak made 16 posts!

Top 3 Most Liked Posts

This post made by @ppr received 1 likes!

How to store file names in a UiPath list variable

[grafik]

This post made by @anandji05 received 1 likes!

Hand Written Data Extraction

@opkushwaha999 You can use ABBYY Flexi Capture. This is a rich OCR tool. But it is paid. You can also integrate it with UiPath. Regards Anand

This post made by @muhammedyuzuak received 1 likes!

Assistant sign in localhost refused to connect

Hi @Pedro_Tibiletti, Go to the default web browser, clear all cookies and try again. Regards, MY

Top 3 Most Liked Solutions

This solution provided by @muhammedyuzuak received 1 likes!

Assistant sign in localhost refused to connect

Hi @Pedro_Tibiletti, Go to the default web browser, clear all cookies and try again. Regards, MY

This solution provided by @Palaniyappan received 1 likes!

How to check if a string is contains english word

Hi Hope the below steps would help you resolve this Let’s take you have a Datatable read from excel and named as dt Now use a FOR EACH ROW ACTIVITY and pass dt as input Inside that activity use a Assign activity like this str_matches = System.Text.RegularExpressions.Regex.Matches(yourRowValueString,“[a-zA-Z]+”) This will give you a list of Match objects ( IEnumerable<Match> ), let’s call it matches , with one element. Let’s call this first match match , so match = matches.FirstAnd …

This solution provided by @Palaniyappan received 1 likes!

Question regarding extracting a portion of a string

Hi There are two ways to do this Let us consider with what you have done already You can use ur current method itself where just use the above expression alone like this in assign activity str_title = System.Text.RegularExpressions.Regex.Match(outputWindow.Selector.ToString.Trim, “(?<=title=\W).*(?=\W\s)”).ToString.Trim As simple as that Another method, a First and most simple thing is with GET ATTRIBUTE activity have the use application/ browser activity and indicate on the applicatio…

---

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

Top 3 Topics with Most Views

File used by another process made by @Sudharsan_Ka with 61 views.

Send email attchment with dynamic name made by @mihai.godeanu with 44 views.

Can we retry business exception in queue after it being failed? made by @ydash999 with 41 views.

Top 3 Topics with Most Replies

Can we retry business exception in queue after it being failed? made by @ydash999 with 24 replies.

Xml reading made by @JOHN_ALEXANDER_Ayure_CO with 20 replies.

Segment and Group Datatable by not grouping item with same transaction ID/item name made by @wonderingnoname with 18 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 41 posts!

@Rahul_Unnikrishnan made 41 posts!

@ppr made 39 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 1 likes!

How to roll back to a older verstion of package?

We can just make them active, any version you want @Umang_Mehta

This post made by @david.jonsson received 1 likes!

Solution Architect requirements

Totally agree with the Pre-Sales part! You need to put someone in front of the customer IT, long before you even start the project, to decide on hosting, security and possible solutions. I did put together a graphical view of how I look at it. But again, all depends on your view and your context. In my opinion uiPath have merged two roles (Solutions Architect & Technical Architect), into one “Solution Architect” [Architect perspecives - uiPath vs Others]

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

Keyboard shortcut for getting list of variables, functions in Expression Editor

ctrl+space

Top 3 Most Liked Solutions

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

Keyboard shortcut for getting list of variables, functions in Expression Editor

ctrl+space

This solution provided by @Yoichi received 1 likes!

Find First Unhidden Sheet Name Of An Excel Using Workbook Activity

Hi, Unfortunately, there is no activity to find hidden/visible sheet in Workbook activity. However, we can achieve it using ClosedXML as the following. Can you try this? [image] workbook.Worksheets.Where(Function(s) s.Visibility=ClosedXML.Excel.XLWorksheetVisibility.Visible).OrderBy(function(s) s.Position).First().Name Sample20220523-5.zip (11.3 KB) Regards,

This solution provided by @Palaniyappan received 1 likes!

Can uipath assistant display action center form tasks?

Hi No it has to be checked only with Action Center Cheers @jack.chan

---

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

Top 3 Topics with Most Views

Data Scrapping from website made by @HeartCatcher with 46 views.

JSON to Datatable convert made by @ravindar.singh with 44 views.

Scroll and take screenshot in SAP & Putty made by @Sathish_Kumar_S with 37 views.

Top 3 Topics with Most Replies

Invoke Code Exception - The name 'HttpContext' does not exist in the current context made by @andre.f.pires with 21 replies.

Data Scrapping from website made by @HeartCatcher with 20 replies.

How to click the hyperlink based on variable that i set in selector made by @user123mem with 18 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 34 posts!

@supermanPunch made 28 posts!

@ppr made 26 posts!

Top 3 Most Liked Posts

This post made by @lakshman received 3 likes!

Edit Selector in Debug mode

Hi Team, Currently we are not able to indicate the UiElement or change the selector in Debug mode because of that we need to stop the entire execution even if we want to change the single attribute value in the selctor. If possible please allow to reindicate the UiElement and change the selector in Debug mode. It will save lot of time to developers.

This post made by @Patrick_Kok received 2 likes!

How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right

Hi Adrian, Your solution is very cools and I didn’t know it can be done this way. Something new to learn and thanks you so much for your solution and it work great! Once again thank you so much.

This post made by @bob.nims received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, My name is Bob. I am new to UiPath and have not done much coding in probably ten years so I am a rusty robot. I have done work with Coldfusion and Tableau visuals in the past. Look forward to learning the new stuff.

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

From Excel Datas to E-mail Html Body

Hi @yigit.aybey , Check the Below Post which helps you in Conversion from Datatable to Html Table format : The Output would be a String which you could then use to append to the body of the mail. The Configuration of the Send Exchange Email Body Activity Should have Property IsBodyHtml Checked (Enabled).

This solution provided by @ankit.saraf received 1 likes!

Query Entity Data giving error

Thank you so much for the input and helping identify that this issue happens when one of the inputs in the list is blank or empty. We will make sure to get this correctly fixed on the backend as well!

This solution provided by @supermanPunch received 1 likes!

Datatable Check Missing Value, Check Expired Date, compare two columns

@hurmet.noka , Could you Show us your Implementation on DataColumn Expression ? This Error Maybe because of the way the date value is formatted in the datatable. Normally the format would be "MM/dd/yyyy HH:mm:ss". Hence, You could Check the Below Expression : datetime.ParseExact(CurrentRow.Item("ExpirationDate").ToString, "MM/dd/yyyy HH:mm:ss",system.Globalization.CultureInfo.InvariantCulture) < Now.AddDays(3) If the above doesn’t work, we would need to know the format of the date value Ei…

---

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

Top 3 Topics with Most Views

Filter dates made by @alan_prakash with 54 views.

Edit PDF file made by @xiaohui.ma with 44 views.

How to check if a button is enabled or disabled if aastate attribute is unavailable in Get attribute activity made by @Deepa_Madkar with 41 views.

Top 3 Topics with Most Replies

How to check if a button is enabled or disabled if aastate attribute is unavailable in Get attribute activity made by @Deepa_Madkar with 23 replies.

Filter dates made by @alan_prakash with 22 replies.

Clicking in half of the process makes a mistake made by @Ozlem_Yigit with 21 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 43 posts!

@postwick made 27 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 3 likes!

How to count the values

Hi @aayushisaxena125 , As you have already provided the Expected Output Table, we could Start by Preparing the Datatable Schema using Build Datatable Activity as shown in your post above. Next, We Perform a GroupBy and Count based on the Values Column like below using Assign Activity : OutputDT = DT.AsEnumerable.GroupBy(Function(x)x("Values").ToString).Select(Function(x)OutputDT.Rows.Add({x.First.Item("Values").ToString,x.Count})).CopyToDatatable Here, OutputDT is the datatable built using B…

This post made by @Sophia_Zhylych received 2 likes!

Feedback wanted -> ready-to-go automations

Hi Forum Users, Last year, we announced an integration between UiPath Marketplace and UiPath Assistant. It gives Assistant users easy access to ready-to-go automations from the Marketplace to help with everyday tasks like taking a screenshot or connecting to a Zoom meeting. Since then, we’ve developed (and continue developing!) dozens of ready-to-go automations that end users can instantly run from Assistant. The Center of Excellence can also download ready-to-go automations from UiPath Market…

This post made by @TimK received 2 likes!

How to get date difference between two date variables? c#

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 3 likes!

How to count the values

Hi @aayushisaxena125 , As you have already provided the Expected Output Table, we could Start by Preparing the Datatable Schema using Build Datatable Activity as shown in your post above. Next, We Perform a GroupBy and Count based on the Values Column like below using Assign Activity : OutputDT = DT.AsEnumerable.GroupBy(Function(x)x("Values").ToString).Select(Function(x)OutputDT.Rows.Add({x.First.Item("Values").ToString,x.Count})).CopyToDatatable Here, OutputDT is the datatable built using B…

This solution provided by @Yoichi received 2 likes!

How to get date difference between two date variables? c#

Hi, We can also use DateDiff in C# as the following. Microsoft.VisualBasic.DateAndTime.DateDiff("d",d1,d2,FirstDayOfWeek.Sunday,FirstWeekOfYear.System) Regards,

This solution provided by @Rahul_Unnikrishnan received 2 likes!

How to deploy project in client's server using citrix or rds?

Hello @ydash999 , You can refer to the below document. You need to install only the robot in the remote machine and need to make a connection with orchestrator.

---

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

Top 3 Topics with Most Views

Is there a way to convert datatable's row datatype? made by @wija with 60 views.

Filter data table in excel made by @Riya1 with 48 views.

[Tutorial] How to build filter query in: Get Exchange Mail Messages to get emails with attachment flag category size etc made by @Adrian_Star with 43 views.

Top 3 Topics with Most Replies

Filter data table in excel made by @Riya1 with 21 replies.

I want to send status message when a process is running in the background of uipath apps made by @Petchi_Paramasivam with 14 replies.

Checking Project for validation errors gets stuck made by @MikeStrike with 14 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 49 posts!

@Veera_Raj made 25 posts!

@postwick made 19 posts!

Top 3 Most Liked Posts

This post made by @Adrian_Star received 5 likes!

[Tutorial] How to build filter query in: Get Exchange Mail Messages to get emails with attachment flag category size etc

Hi, I have prepared a comprehensive compendium of knowledge on how to filter e-mails using KQL queries used in filtering e-mail messages in Get Exchange Mail Messages activity. From the following set of information you will learn how to correctly construct a query syntax. I have tested all the query properties below for correct operation on MS Office 2016 for corporate use. I have marked the ones that didn’t work in my company. The KQL language was used in the queries used, which means: Keyw…

This post made by @Himanshu_Yadav received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

This is Himanshu Yadav, I work as a Global RPA Engineer and always try to find new interesting topic and UiPath Forum is the best place to find new topics as UiPath Developers keep posting new issues/solutions they faces during their development. which is the best way to learn new things. So that’s the reason I am here to learn and share my knowledge with you all Thanks and Happy Automation

This post made by @yigit.aybey received 2 likes!

Get Date in Input Dialog And Control of Date

Thanks for your help guys (@Lak_Ui, @lakshman and @ushu), i appreciate your effort and guidance.

Top 3 Most Liked Solutions

This solution provided by @lakshman received 1 likes!

Get Date in Input Dialog And Control of Date

@yigit.aybey You can mention the required date format to be entered by the user in Label field of Input Dialog activity. Assign the Input Dialog activity output to one string variable named strDate. And then check below conditions to validate whether entered date is correct or not. CInt(strDate.Trim.Split("."c)(0)) > 0 AND CInt(strDate.Trim.Split("."c)(0)) <= 31 CInt(strDate.Trim.Split("."c)(1)) > 0 AND CInt(strDate.Trim.Split("."c)(1)) <=12

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

How to itterate alphabet?

do this instead UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(number) where number is integer variable e.g. number=1 will return A number = 26 returns Z number = 100 returns CV number = 1000 returns ALL and so on…

This solution provided by @StefanSchnell received 1 likes!

Two different selectors for the same SAP element when captured in different PCs

@jack.chan Hello Jack, it seems that the network settings of your Environment 1 is low speed LAN connection. Square brackets in the IDs are a typical sign of this. Let us know your result. Best regards Stefan

---

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.