Forum Engagement Daily Reports

[system]

Daily Forum Report | 08 April 2022

Top 3 Topics with Most Views

I need your help made by @momo10 with 49 views.

How to split string value with space made by @yash_p with 45 views.

Vulgarisation – Méthodologie - AGILE - Episode 11 made by @oumayma_lajili2 with 44 views.

Top 3 Topics with Most Replies

There is no option to add a robot in the Orchestrator page made by @mail4bobbysam with 18 replies.

Covert String to Date time made by @Sairam_RPA with 16 replies.

How to split string value with space made by @yash_p with 15 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 49 posts!

@ushu made 25 posts!

@supermanPunch made 23 posts!

Top 3 Most Liked Posts

This post made by @oumayma_lajili2 received 5 likes!

Vulgarisation – Méthodologie - AGILE - Episode 11

Bonjour chère Communauté Aujourd’hui on va aborder un sujet qui me tient à coeur : La Méthodologie des projets RPA. Cet article est un début d’une série d’articles sur les centres d’excellence. 1. Méthodologie de travail fonctionnelle Comme tu le sais, grâce à la RPA les entreprises peuvent avoir des optimisations en terme de délais, coûts importants et économies ROI. En plus, on obtient une précision améliorée des processus et des employés…

This post made by @ppr received 3 likes!

LINQ Update Data Issue

your result comes from the nature of the cartesian product. You case looks similar to a side by side merge we can do it by writing out excel2 with an offset or LINQ (From x in Enumerable.Range(0, dt1.Rows.Count) Let r1 = dt1.Rows(x) Let r2 = dt2.Rows(x) Let ra = new Object(){r1(0), r1(1), r2(0)} Select row=dtResult.Rows.Add(ra)).CopyToDatable

This post made by @supermanPunch received 2 likes!

Covert String to Date time

@Sairam_RPA , Could you try the Below Approach : Assuming that there are hidden Characters in the String. We will first remove them : dateString = System.Text.RegularExpressions.Regex.Replace(dateString, "[^\x20-\x7F]", "") Next, Check with your original Expression : DateTime.ParseExact(dateString,arr_strFormats,System.Globalization.CultureInfo.InvariantCulture,DateTimeStyles.None) Let us know if it doesn’t work

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

Covert String to Date time

@Sairam_RPA , Could you try the Below Approach : Assuming that there are hidden Characters in the String. We will first remove them : dateString = System.Text.RegularExpressions.Regex.Replace(dateString, "[^\x20-\x7F]", "") Next, Check with your original Expression : DateTime.ParseExact(dateString,arr_strFormats,System.Globalization.CultureInfo.InvariantCulture,DateTimeStyles.None) Let us know if it doesn’t work

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

Click activity denied

Yes there is. In the project settings you can just disable the modern activities and that’s it. [image] Thanks, Athira

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

How Can I Add Color in Outlook Mail Body

something like this "<p style='color:blue'>"+ row(“Mail Body1”).ToString+" “+ row(“İsim Soyisim”).ToString+”,"+" "+" "+row(“Mail Body2”).ToString+" "+" "+row(“Mail Body3”).ToString+" "+" "+row(“Mail Body4”).ToString+" "+" "+row(“Mail Body5”).ToString + "</p>" then in send email activity tick “isBodyHTML” [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 | 09 April 2022

Top 3 Topics with Most Views

Option to choose variables at the time of removing unused variables made by @lakshman with 45 views.

Manipulate complex excel made by @aqiff with 40 views.

Automate Sending LinkedIn Messages made by @Antoinette_Smith with 39 views.

Top 3 Topics with Most Replies

How to check if application loads data made by @koppikaranjali with 11 replies.

Option to choose variables at the time of removing unused variables made by @lakshman with 10 replies.

Regex capture without surrounding white spaces made by @MikeC with 10 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 31 posts!

@lakshman made 12 posts!

@mail4bobbysam made 9 posts!

Top 3 Most Liked Posts

This post made by @Navya_Kattikireddy received 2 likes!

Terminate a workflow with exception and Execute the next one

Hey I encased individual workflows into try catch and in catch used log message : exception.message to know the exception. It skipped the workflow with exception and jumped to the next!! Finally, my problem solved. Thank you

This post made by @lakshman received 2 likes!

Option to choose variables at the time of removing unused variables

Hi Team, It would be good if you can provide an option to choosing the variables to delete instead of deleting all variables at the time of removing unused variables. [image] [image]

This post made by @ashwin.ashok received 2 likes!

Option to choose variables at the time of removing unused variables

Hi @lakshman , I agree, it would be great if there was a list of unused variables with checkboxes next to them which we can select/deselect in order to delete/keep the variables. Kind Regards, Ashwin A.K

Top 3 Most Liked Solutions

This solution provided by @ashwin.ashok received 1 likes!

Terminate a workflow with exception and Execute the next one

Hi @Navya_Kattikireddy , You can encase all the Workflows inside of a Try-Catch, which will log the exception and automatically move onto the next Activity. Make sure you toggle the Catch to Exception and Log the Message so that in case a System Exception not related to the URL issue pops up, we will know about it from the Logs. [image] Could you give that a try and let us know if it works out for you? Kind Regards, Ashwin A.K

This solution provided by @Ilie_Dercaci received 1 likes!

Convert to google workspace file type

I soled the problem. I was using an older version of gsuite package. Thanks.

This solution provided by @ashwin.ashok received 1 likes!

Manipulate complex excel

Hi @aqiff , I’m not entirely sure if this works, but could you give it a try? FormatComplexExcelData.xaml (20.7 KB) Invoice_Input.xlsx (12.1 KB) Kind Regards, Ashwin A.K

---

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

Top 3 Topics with Most Views

Combination of classic and modern made by @Zack_Gef with 47 views.

Read cell in exel made by @pl.rusinov with 42 views.

Download multiple PDFs from webpage made by @Katrina with 40 views.

Top 3 Topics with Most Replies

Combination of classic and modern made by @Zack_Gef with 15 replies.

Regex Match For / made by @RPA-botDev with 11 replies.

Read cell in exel made by @pl.rusinov with 10 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 16 posts!

@Palaniyappan made 15 posts!

@supermanPunch made 11 posts!

Top 3 Most Liked Posts

This post made by @kimjinseong received 2 likes!

디자인>데이터 스크래핑 탭 기능이 없을 때 생성 방법이 있을까요?

안녕하세요 [최신 디자인 환경]이 예로 되있을경우 데이터 스크래핑 기능이 안보이기 때문에 밑에 그림처럼 아니요로 설정을 변경해주시면 됩니다. 프로젝트 >설정⚙>일반>최신 디자인 환경설정을 아니요로 설정 [image]

This post made by @beepd1012 received 2 likes!

디자인>데이터 스크래핑 탭 기능이 없을 때 생성 방법이 있을까요?

안녕하세요 하루종일 데이터 스크래핑 기능의 부재로 스트레스 받았는데 도움 주셔서 감사합니다!! 정말로 감사합니다

This post made by @Palaniyappan received 2 likes!

Download multiple PDFs from webpage

Hi It’s possible with two ways in general If we want to do without UI interaction then check whether that web app has API Integration If yes then it’s very easy Or If there is no api integration then there is no other go that we have to try with UI Interaction But there are multiple ways to do this without multiple clicks With Data Scrapping method we can For sample workflow Cheers @Katrina

Top 3 Most Liked Solutions

This solution provided by @kimjinseong received 2 likes!

디자인>데이터 스크래핑 탭 기능이 없을 때 생성 방법이 있을까요?

안녕하세요 [최신 디자인 환경]이 예로 되있을경우 데이터 스크래핑 기능이 안보이기 때문에 밑에 그림처럼 아니요로 설정을 변경해주시면 됩니다. 프로젝트 >설정⚙>일반>최신 디자인 환경설정을 아니요로 설정 [image]

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

Help to schedule my bot to run only on 1 st day of every month

Hi @Peter_D Kindly try this CRON expression with advanced option in TRIGGERS We can use this expression 0 0 0 ? 1/1 * Which will run at first day of every month Thanks

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

Combination of classic and modern

Hi @Zack_Gef Yes of course you can have a combination of classic and modern activities in your project. If at all you feel there is a necessity of combination

---

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

Top 3 Topics with Most Views

UiPath HTTP Request - 405 - Requested operation requires publish permissions on the runbook made by @Sai_Santhosh_Kumar_Batch1 with 56 views.

Open a password protected Excel file made by @Shikhar_Tandon with 52 views.

Starting Soon! Reboot Work Festival 2022 made by @Bianca_Simionescu with 44 views.

Top 3 Topics with Most Replies

Open a password protected Excel file made by @Shikhar_Tandon with 18 replies.

Retry Database conenction made by @PALKUMARI_PATEL with 15 replies.

How can i get a value from a csv file made by @guilherme.dias with 15 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 49 posts!

@ushu made 30 posts!

@Nithinkrishna made 28 posts!

Top 3 Most Liked Posts

This post made by @Bianca_Simionescu received 3 likes!

Starting Soon! Reboot Work Festival 2022

[image] Why miss your virtual seat at this year’s biggest automation festival? Hear from our keynote speakers, such as Azeem Azhar (Founder, “Exponential View”) in the Big Tent; Meet live with UiPath experts in more than 20 virtual booths covering automation products, services, and industry solutions as you explore Expertsville; Get inspired by stories from automation pioneers such as Xerox, Cisco, Siemens and many others in the virtual Amphitheater; …and much more! Mark your cal…

This post made by @deranker received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, you can call me rob, and I am nothing more than an ordinary programmer. I joined this community as I am relatively new to RPA and need more guidance for issues that I may not understand.

This post made by @Archie received 2 likes!

Type into activity types from the start again

Tried this and somehow, the problem doesn’t show anymore. Thanks for the help.

Top 3 Most Liked Solutions

This solution provided by @Sai_Santhosh_Kumar_Batch1 received 1 likes!

UiPath HTTP Request - 405 - Requested operation requires publish permissions on the runbook

Hi All, The issue is resolved now after modifying the input xml character casing as per the sample input xml and accept property as any. Kind Regards, Sai Santhosh Kumar Batchu

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

Unable to write into Excel Cell

what if you remove the quotation marks from A9?

This solution provided by @suraj.setty received 1 likes!

Download pdf files from popup window

Hi @Emilia_Daian Did you try using Click Image Activity. 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 | 12 April 2022

Top 3 Topics with Most Views

📢 Reboot Your Skills – Automation Starter: Discover Automation in Just 10 Days for FREE! made by @cristina.vidu with 61 views.

Need LINQ for a requirement made by @micheal1 with 51 views.

変数を使用した条件の書き方について made by @UedaKorai with 39 views.

Top 3 Topics with Most Replies

Type into "Save as dialog" does not work with simulate made by @MaxDS1 with 17 replies.

Error loading Feeds made by @Debojyoti_chanda with 16 replies.

Need LINQ for a requirement made by @micheal1 with 16 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 57 posts!

@Nithinkrishna made 41 posts!

@supermanPunch made 31 posts!

Top 3 Most Liked Posts

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

Reboot Your Skills – Automation Starter: Discover Automation in Just 10 Days for FREE!

Hello, UiPath Community! We’d like to invite you to Reboot Your Skills - Automation Starter! Over the last couple of months, we’ve heard more and more companies share that they are looking to grow automation awareness internally . And we’re committed to help them! Starting May 2nd, throughout 10 days, participants will gain access to content that explains what RPA and Automation are, and will walk through two RPA tutorials. :teacher:t2…

This post made by @Alexandru_Szoke received 3 likes!

Orchestrator in Automation Cloud™ - Data Retention and Archiving for QueueItems

Hello, UiPath Community! Some of your inquiries regarding Orchestrator cloud accounts overall performance have been heard. We acknowledge the need for a faster environment, in which operations happen in the blink of an eye. For that, we will be introducing Data Retention and Archiving policies for queue items in Orchestrator, which ensures built-in data off-loading capabilities. We are relying on your collaboration to strengthen operational performance of your cloud Orchestrator. This change …

This post made by @loredana_ifrim received 2 likes!

Reboot Your Skills – Automation Starter: Discover Automation in Just 10 Days for FREE!

Awesome journey

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Text to Column using Width

Hi, Thanks for sharing. How about the following? [img20220412-4] [image] Sample20220412-3.zip (7.6 KB) Regards,

This solution provided by @supermanPunch received 2 likes!

Copy Sheet from One Excel to Another

Hi @Shikhar_Tandon , Try Checking the Below Workflow : Excel_CopySheet_ToAnotherExcel.xaml (7.6 KB) It does take time for a Sheet containing Large Data.

This solution provided by @Bogdan_Zavera received 2 likes!

UiPath Marketplace is not very user friendly - ADD OPENING LINKS IN NEW TABS

Hello Oscar. Thank you for bringing this up. Both of the issues you mentioned were fixed and are in production. Anytime you have other issues, ideas or feedback do not hesitate to post on the forum or use the e-mail address provided during our short discussion.

---

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

Top 3 Topics with Most Views

Leading 0s get eliminated while opening the CSV file in excel after writing to CSV made by @geetishree.rao with 45 views.

Read first sheet of Excel made by @mateo.drouillard with 44 views.

How to verify a documents based on Excel data? made by @raju_alakuntla with 35 views.

Top 3 Topics with Most Replies

Leading 0s get eliminated while opening the CSV file in excel after writing to CSV made by @geetishree.rao with 15 replies.

Multiple values in single column to queue made by @Sathish_Kumar_S with 13 replies.

Data scrape in data scraping on the website made by @Ozlem_Yigit with 12 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 40 posts!

@ushu made 28 posts!

@Palaniyappan made 23 posts!

Top 3 Most Liked Posts

This post made by @diana.gray received 4 likes!

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

In this event, you’ll learn about the web version of Studio, “Studio Web,” the newest member of the Studio family, along with UiPath IT Automation activities, which are now available in Studio Web. Find out about the Activity packs that can be included in your projects, which you may be familiar with from Studio Desktop, so everything you know about using them still applies. Even more, you can download any Studio web project built with these activities and open it in…

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

Unattendedで実行するとAssistantが画面上に立ち上がるのを阻止したい。

Hello @Amimn , Please check this solution: Thanks! Athira

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

Get file path from an excel sheet and use that in Send SMTP Mail Message activity to send attachments

Hello @Vijay_Manimaran , You can give the path like this in AttachmentsCollection property: {“C:\Documents\abc.pdf”} If more than one attachment is present, give path as comma-seperated values. Thanks! Athira

Top 3 Most Liked Solutions

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

Unattendedで実行するとAssistantが画面上に立ち上がるのを阻止したい。

Hello @Amimn , Please check this solution: Thanks! Athira

This solution provided by @geetishree.rao received 2 likes!

Leading 0s get eliminated while opening the CSV file in excel after writing to CSV

Hi All… Thanks … I found a way to resolve this and thought of sharing ,it may help others. If we add a TAB +convert(VARCHAR(10),Char(9)) at the end of the column value then it will not eliminate leading zeroes when csv is opened in excel and will not add qoutes as well when opened in notepad. I did this from the sql side. Thanks and Regards, Geetishree Rao

This solution provided by @Yoichi received 1 likes!

I have problem to convert text into datatable from specific condition

Hi, Another approach using Matches method : [img20220413-2] mc = System.Text.RegularExpressions.Regex.Matches(strData,"CodeNumber : (?<CodeNumber>\d+) NumberPage : (?<PageNumber>\d+)\r?\n\r?\n(?<TABLE>[\s\S]+?)(?=\r?\n\r?\n|\s*$)") Sample20220413-3.zip (3.0 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 | 14 April 2022

Top 3 Topics with Most Views

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

Avoid ip blocking made by @Patel_Piyush1878 with 43 views.

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Nithinkrishna made 57 posts!

@supermanPunch made 35 posts!

@lakshman made 33 posts!

Top 3 Most Liked Posts

This post made by @asha_jyothi received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

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

This post made by @AndyMenon received 2 likes!

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

Just signed up!

This post made by @aalaghbari received 2 likes!

Text to Columns Google Sheet

Thanks a lot.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to get String within a String with Regex

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

This solution provided by @Nithinkrishna received 1 likes!

Capitalize first letter of a string for Composed words

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

This solution provided by @supermanPunch received 1 likes!

How to get output from a powershell activity?

Hi @kkpatel , I am able to get the Output using a return provided the TypeArgument is a String : [image]

---

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

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

[system]

Daily Forum Report | 15 April 2022

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Nithinkrishna made 33 posts!

@ushu made 21 posts!

@jack.chan made 18 posts!

Top 3 Most Liked Posts

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

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

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

This post made by @jeevith received 2 likes!

For each loop in group wise

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

This post made by @jeevith received 2 likes!

Storing the values in JSON output to Data table

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

Top 3 Most Liked Solutions

This solution provided by @jeevith received 2 likes!

Storing the values in JSON output to Data table

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

This solution provided by @grosner received 2 likes!

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

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

This solution provided by @jeevith received 2 likes!

Deleting rows in a Data Table

Hi @RPA_Path, I would recommend you use the Filter Datatable Activity. Compare dates and where Date column is equal to your comparision, choose to remove that row. Finally, save the filtered datatable to the same variable as your input datatable. Essentially, you are filtering your input datatable. [image]

---

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

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

[system]

Daily Forum Report | 16 April 2022

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Palaniyappan made 18 posts!

@jack.chan made 11 posts!

@Nithinkrishna made 9 posts!

Top 3 Most Liked Posts

This post made by @sssi received 1 likes!

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

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

This post made by @Jesmine received 1 likes!

For each loop in group wise

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

This post made by @Nithinkrishna received 1 likes!

For each loop in group wise

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

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 1 likes!

The rpc server is unavailable

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

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

How to open recently downloaded Excel file while getting errors?

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

---

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

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

[system]

Daily Forum Report | 17 April 2022

Top 3 Topics with Most Views

Browser click made by @A_Learner with 40 views.

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Nithinkrishna made 16 posts!

@mail4bobbysam made 12 posts!

@Mystical_Devices made 9 posts!

Top 3 Most Liked Posts

This post made by @A_Learner received 2 likes!

Browser click

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

This post made by @mail4bobbysam received 2 likes!

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

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

This post made by @lakshman received 1 likes!

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

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

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

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

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

This solution provided by @Yoichi received 1 likes!

Generate Data Table from Clipboard

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

---

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

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

[system]

Daily Forum Report | 18 April 2022

Top 3 Topics with Most Views

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

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

UI Selector made by @dylankiu with 36 views.

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Palaniyappan made 36 posts!

@Nithinkrishna made 31 posts!

@lakshman made 29 posts!

Top 3 Most Liked Posts

This post made by @Nithinkrishna received 4 likes!

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

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

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

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

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

This post made by @Byra_Padha_Saradhi received 3 likes!

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

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

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 3 likes!

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

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

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

Filter DataTable activity?

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

This solution provided by @Palaniyappan received 2 likes!

Pros and cons of using 365 activities over excel activities

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

---

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

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

[system]

Daily Forum Report | 19 April 2022

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Nithinkrishna made 42 posts!

@jack.chan made 29 posts!

@ppr made 23 posts!

Top 3 Most Liked Posts

This post made by @happyfeat87 received 3 likes!

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

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

This post made by @jordanhaggett received 2 likes!

Issue in send smtp mail message

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

This post made by @Marius_Puscasu received 2 likes!

100% retry rate means 0 retries?

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

Top 3 Most Liked Solutions

This solution provided by @happyfeat87 received 3 likes!

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

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

This solution provided by @Yoichi received 1 likes!

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

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

This solution provided by @lakshman received 1 likes!

Filter by use Directory.GetFiles?

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

---

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

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

[system]

Daily Forum Report | 20 April 2022

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Nithinkrishna made 47 posts!

@lakshman made 46 posts!

@supermanPunch made 33 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 3 likes!

Error with SAP logon and parameter

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

This post made by @LevKushnir received 3 likes!

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

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

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

Error with SAP logon and parameter

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

Top 3 Most Liked Solutions

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

Error with SAP logon and parameter

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

This solution provided by @Nithinkrishna received 2 likes!

Help with regex to extract number following a particular word

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

This solution provided by @Arvind_Kumar1 received 2 likes!

How to change the date format from datepicker control

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

---

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

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

[system]

Daily Forum Report | 21 April 2022

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@lakshman made 48 posts!

@Nithinkrishna made 37 posts!

@Rahul_Unnikrishnan made 25 posts!

Top 3 Most Liked Posts

This post made by @ptrobot received 3 likes!

Ignore Folders from Publish

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

This post made by @lakshman received 3 likes!

Ignore Folders from Publish

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

This post made by @lakshman received 2 likes!

Ignore Folders from Publish

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

Top 3 Most Liked Solutions

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

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

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

This solution provided by @ppr received 2 likes!

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

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

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

Optimize your robot

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

---

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

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

[system]

Daily Forum Report | 22 April 2022

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@lakshman made 48 posts!

@Rahul_Unnikrishnan made 38 posts!

@Nithinkrishna made 30 posts!

Top 3 Most Liked Posts

This post made by @LevKushnir received 3 likes!

SAP logon using UiPath accelerators

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

This post made by @Nithinkrishna received 2 likes!

SAP logon using UiPath accelerators

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

This post made by @LevKushnir received 2 likes!

SAP automation - selector query - very big selectors

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

Top 3 Most Liked Solutions

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

Password is not able to retrieve using get asset

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

This solution provided by @Yoichi received 1 likes!

Regex Match issue

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

This solution provided by @lakshman received 1 likes!

Get last 3 characters from string excepting the last 1 character

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

---

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

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

[system]

Daily Forum Report | 23 April 2022

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 19 posts!

@MikeC made 16 posts!

@athira.somasekharan made 10 posts!

Top 3 Most Liked Posts

This post made by @opkushwaha999 received 2 likes!

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

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

This post made by @Mike_Campbell received 1 likes!

Chrome extension malfunction after auto-update to 22.4

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

This post made by @Nithinkrishna received 1 likes!

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

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

Top 3 Most Liked Solutions

This solution provided by @Mike_Campbell received 1 likes!

Chrome extension malfunction after auto-update to 22.4

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

This solution provided by @Nithinkrishna received 1 likes!

Filter email (Subject)

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

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

2 output to message box help

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

---

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

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

[system]

Daily Forum Report | 24 April 2022

Top 3 Topics with Most Views

Manipulation of excel made by @manoj_verma1 with 40 views.

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 19 posts!

@jack.chan made 11 posts!

@Nithinkrishna made 11 posts!

Top 3 Most Liked Posts

This post made by @ptrobot received 2 likes!

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

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

This post made by @MasterOfLogic received 1 likes!

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

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

This post made by @jon4378 received 1 likes!

HTTP Request: Passing Parameters in Body

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

Top 3 Most Liked Solutions

This solution provided by @ptrobot received 2 likes!

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

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

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

Select file activity shows error

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

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

I cant import web data to excel

can you try this? i just added some retry logic in case it fails because its working fine for me DergiPark.xaml (27.2 KB)

---

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

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

[system]

Daily Forum Report | 25 April 2022

Top 3 Topics with Most Views

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

Dt issue made by @manoj_verma1 with 46 views.

Logic related question made by @meeraa with 41 views.

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@ushu made 40 posts!

@Nithinkrishna made 38 posts!

@lakshman made 28 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Getting List of Duplicate Rows with Unique Multiple Columns - LINQ

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

This post made by @Ioana_D received 2 likes!

Extract entire line containing keyword

That works, thanks a lot!

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

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

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

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Getting List of Duplicate Rows with Unique Multiple Columns - LINQ

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

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

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

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

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

Error Input string was not in a correct format?

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

---

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

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

[system]

Daily Forum Report | 26 April 2022

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 43 posts!

@jack.chan made 32 posts!

@ushu made 24 posts!

Top 3 Most Liked Posts

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

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

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

This post made by @ashutoshkhantwal received 1 likes!

Distinct values in a datatable

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

This post made by @kiarodelalune received 1 likes!

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

THIS IS THE BEST SOLUTION.

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

FileInfo Argument don't pass

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

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

Add automatic item in dispatcher queue

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

This solution provided by @Nithinkrishna received 1 likes!

Assets failing

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

---

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

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

[system]

Daily Forum Report | 27 April 2022

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@jack.chan made 32 posts!

@lakshman made 32 posts!

@Nithinkrishna made 28 posts!

Top 3 Most Liked Posts

This post made by @ppr received 10 likes!

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

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

This post made by @user123mem received 2 likes!

How to read and open folder files path inside Excel

Hi this works ! Thanks !!

This post made by @kali received 2 likes!

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

It’s there for me. [image]

Top 3 Most Liked Solutions

This solution provided by @postwick received 2 likes!

Click on Specific name, fetching from Queue

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

This solution provided by @Nithinkrishna received 1 likes!

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

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

This solution provided by @kali received 1 likes!

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

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

---

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

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