Forum Engagement Daily Reports

[system]

Daily Forum Report | 20 December 2021

Top 3 Topics with Most Views

Add maximum retry count to 1 without deleting the existing queue made by @charan.singh with 51 views.

UiPath Academy site not working made by @aditaga with 43 views.

IE11→Edge切り替え ダウンロード通知のセレクター選択ができない件について made by @HANAKO with 33 views.

Top 3 Topics with Most Replies

In/Out argument goes back to in value made by @Suldarie with 21 replies.

UiPath Academy site not working made by @aditaga with 17 replies.

Object reference not set to an instance of an object while invoking workflow made by @Sachin_P_K with 13 replies.

Top 3 Users Who Posted The Most

@Jobin_Joy made 56 posts!

@kirankumar.mahanthi1 made 28 posts!

@ppr made 17 posts!

Top 3 Most Liked Posts

This post made by @pavithra_pavi received 5 likes!

Hide Excel Sheet

Hide the Particular Excel Sheet using UiPath Hi everyone, I’m here with another interesting scenario where we want to hide particular excel sheet… There are 2 ways to achieve this 1. Using VB.NET Code 2. Using Macro in excel and calling the macro in UiPath. Watch the video to know how we can achieve these 2 and also get the code. [Hide Excel sheet using UiPath | Macro]

This post made by @Vishal_Kalra received 3 likes!

UiPath NetIQ eDirectory Activities are now in Public Preview

Great @andreioros , thanks for confirming!

This post made by @shreyash_shirbhate received 3 likes!

How to kill only the Chrome Browser session inside PiP with kill Process?

Hey @praveengogula , Can you please see below links? Try to see if you can enable the below option. [image]

Top 3 Most Liked Solutions

This solution provided by @Jobin_Joy received 2 likes!

How to hide the multiple excel sheets

Hi @gopal_ram Here is the sample for getting sheet names from an excel file. Code: hide sheet.xaml (6.9 KB) Test.xlsx (10.9 KB) Then you can follow the steps mentioned by @pavithra_pavi Thank you.

This solution provided by @Yoichi received 2 likes!

How to get the workflow name in catch block for unknown execption

Hi, Can you try the following in the catch state? faultedDetails = exception.Data("FaultedDetails") workflowName = faultedDetails.GetType().GetProperty("WorkflowFile").GetValue(faultedDetails, Nothing).ToString Note: faultedDetails is object type Regards,

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

Unable to click on 'Don't Update' on Excel Pop Up

you need to use parallel with "isolated property in order to open a separate thread to handle the popup, otherwise it wont work, because that popup is like a message box in uipath - it pauses execution until you press it manually use my snippet steps open handle popup in process -main xaml drag your sequence here [image] open this sequence [image] update this selector to that of your “Dont update links” button [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 | 21 December 2021

Top 3 Topics with Most Views

How to convert Dec-21 into 31.12.2021 made by @rsr.chandu with 37 views.

Understanding the LINQ made by @pavithra_pavi with 34 views.

How to add integer value while the comma inbetween that (Ex. 16,000) made by @Rajiduraikannu_Santhosh_G with 34 views.

Top 3 Topics with Most Replies

If Function for login webpage made by @pdm with 24 replies.

How to access active directory using RDP connection? made by @Vrushali_Gave with 13 replies.

Unable to add library i created in studio made by @ashritha with 12 replies.

Top 3 Users Who Posted The Most

@kirankumar.mahanthi1 made 35 posts!

@Srini84 made 24 posts!

@Yoichi made 21 posts!

Top 3 Most Liked Posts

This post made by @pavithra_pavi received 4 likes!

Understanding the LINQ

I started to learn in depth about the LINQ query. and i thought why not make a video while i study and help some who is also wanted to learn this concept. Check out the Part 1 of Understanding the LINQ concept. [LINQ tutorial Part1 | UiPath] Understanding the LINQ Part 2 In this video, i explained about LINQ Method syntax and examples. I wanted to cover the topic of Standard query operator which we will be using to perform all the filtration or sorting etc. But i couldn’t cover a…

This post made by @codemonkee received 3 likes!

Cron Expression: 1st Day of Every Month

To expand on why this is the correct solution for anyone that would stumble on it UiPath Orchestrator uses Quartz.NET Framework for its Cron Expressions. This is expecting the following (6 to 7) fields in the expression with the last one year being optional. If you come from other non-compatible expression parsing, you might be used to only 5 fields where seconds is not supported. * * * * * * * | | | | | | | | | | | | | +-- Year (range: 1970-2099) | | | | | +---- Day of the Week…

This post made by @codemonkee received 2 likes!

Log4j critical vulnerability: CVE-2021-44228

The Security Advisor page linked about was updated to include this CVE.

Top 3 Most Liked Solutions

This solution provided by @pikorpa received 2 likes!

Json parsing and looping

That’s right. When I wrote expression, I missed closing “]” ¯_(ツ)_/¯ parsedJson.SelectToken(“outputValues.json-output[” + i.ToString + “].tax”).ToString

This solution provided by @Yoichi received 1 likes!

RPA developer vs Automation developer

Hi, in the latest version (21.10), license for developer is Automation developer as the following document. https://licensing.uipath.com/ In version 20.10, 20.10, and 21.4, there are 2 types developer license : RPA developer license and RPA developer Pro license which is for Pro profile(C# support, test function etc). In 21.10, Studio profile and Studio Pro profile are unified to Studio profile. So there is no difference in the latest version. However, RPA developer might be discontinued in …

This solution provided by @ppr received 1 likes!

How to add integer value while the comma inbetween that (Ex. 16,000)

using the immediate panel we can prototype and check our statements. Refering to the screenshots we do see, that the statement is valid. Now we can check for the values, which are not parseable [grafik] Similar to the example, done with a list we can do it with datatables set a brekapoint debug and get paused open immediate panel use the statement: DTPlant.AsEnumerable.Where(Function (x) Not Double.TryParse(x(“Good Parts”).toString)).toList we will get back a list of datarows with all r…

---

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 December 2021

Top 3 Topics with Most Views

Automate UiPath project documentation using PowerShell made by @jeevith with 99 views.

SQL data extraction made by @siva_sankar with 62 views.

How to remove all spaces from the string except newline made by @chauhan.rachita30 with 52 views.

Top 3 Topics with Most Replies

SQL data extraction made by @siva_sankar with 12 replies.

Apps checkbox test in if condition made by @avasiliu with 12 replies.

How to remove all spaces from the string except newline made by @chauhan.rachita30 with 10 replies.

Top 3 Users Who Posted The Most

@Yoichi made 36 posts!

@kirankumar.mahanthi1 made 21 posts!

@pikorpa made 17 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 3 likes!

Automate UiPath project documentation using PowerShell

Target audience: CoE’s, RPA Solution Architects / Leads and RPA Developers Technical Design Document (TDD) contains details of the design as implemented by the development team. In other words, this document is a detailed manual of the delivered solution and is quite an important resource for those who maintain software / robots in production. The usefulness of this document is only realised when there is a knowledge gap in the team, which would mean that other developers need to quickly unde…

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

The UiPath Community Winter Wonderbeats!

Thank you all for your submissions and votes! The challenge is closed and we’ll update the post tomorrow with the playlist. Hope you’ll all enjoy listening to this small compilation put together by our community peers while having a well deserved rest and a wonderful time with your loved ones!

This post made by @jeevith received 2 likes!

Automate UiPath project documentation using PowerShell

Hi @JDoshi, Sure. If your invoked workflows are of similar structure, you will not need to edit much in the code. Else, you might have to adapt the code accordingly to extract key/values. If you have any challenges, post them here and I can try to help you out.

Top 3 Most Liked Solutions

This solution provided by @cristina.vidu received 2 likes!

The UiPath Community Winter Wonderbeats!

Thank you all for your submissions and votes! The challenge is closed and we’ll update the post tomorrow with the playlist. Hope you’ll all enjoy listening to this small compilation put together by our community peers while having a well deserved rest and a wonderful time with your loved ones!

This solution provided by @Yoichi received 2 likes!

テキストファイル(○○.txt)の排他制御

こんにちは UiPathのアクティビティで実現しようするのでしたら、 例えば、一旦ローカルにテキストファイルを書き出しておいて ファイルをコピーアクティビティで上書きしない設定にしておけば 既存ファイルがあれば例外となると思います。 https://docs.uipath.com/lang-ja/activities/docs/copy-file あるいは.netのクラス使えば細かい制御ができると思うので、そちらのアプローチをとる案もあるかもです。

This solution provided by @pravin_calvin received 2 likes!

SQL data extraction

Hi @siva_sankar How about Using below! —> To take 13 datarows DT.AsEnumerable.Take(13).CopyToDatatable ---->To take last five datarows DT.AsEnumerable.skip(DT.Rows.count-5).CopyToDatatable** Regards

---

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

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

[system]

Daily Forum Report | 23 December 2021

Top 3 Topics with Most Views

File name made by @Seema_Jethe with 50 views.

Working on web application (HTML) type made by @mittal.abhishek with 47 views.

How to convert string to date time? made by @Sirimalla_Karthik_Chandra with 42 views.

Top 3 Topics with Most Replies

Regular expression to get Boolean values made by @chauhan.rachita30 with 19 replies.

File name made by @Seema_Jethe with 18 replies.

Working on web application (HTML) type made by @mittal.abhishek with 12 replies.

Top 3 Users Who Posted The Most

@kirankumar.mahanthi1 made 32 posts!

@Robinnavinraj_S made 12 posts!

@Srini84 made 11 posts!

Top 3 Most Liked Posts

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

The UiPath Community Winter Wonderbeats!

Our gift IS HERE!! As promised, a beautiful piece of our community’s human side and a shared moment of TOGETHERNESS. HIT PLAY and let’s imagine this bright season in our big, global, community house !! Links below Spotify Gaana YouTube

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

Handle popups such as update links popup

Hi everyone, i’d like to share my new custom activity. Feel free to use it and ask any questions This snippet lets you handle popups that block execution. These pop-ups cannot be handled normally because they block UiPath execution until the user manually clicks on them. This snippet handles them with a parallel thread with the “isolated” property. Examples of these popups: 1) [image] 2) [image] 3) [image] How to use? steps open handle popup in process -main xaml drag your sequence…

This post made by @jeevith received 3 likes!

How to get the correct value from get text

Hi @BHARAT_NAGAR, I am not sure what your reasons for scraping linkedin is, but you should know that this is something Linkedin does not want people doing in its platform. UiPath forum should not therefore help queries which can promote such scrappers. If this is your PoC or a personal project you should be fine for certain number of requests / profile scrapes, later your IP (not just your host pc IP but the entire LAN from your ISP) can be easily flagged by their servers and then blocked. In…

Top 3 Most Liked Solutions

This solution provided by @cristina.vidu received 7 likes!

The UiPath Community Winter Wonderbeats!

Our gift IS HERE!! As promised, a beautiful piece of our community’s human side and a shared moment of TOGETHERNESS. HIT PLAY and let’s imagine this bright season in our big, global, community house !! Links below Spotify Gaana YouTube

This solution provided by @kirankumar.mahanthi1 received 2 likes!

Is "Invoke VBA" activity has disappeared in UiPath.Excel.Activities v.2.11.4

Hi @pondyondaime , For this excel package version 2.11.4 we have to select the filter in the activities panel like below to enable the invoke vba activity since it is coming under classic activities. please refer the below screenshots. Pls try and let us know. thanks. [image] [image]

This solution provided by @tainan.ramos received 1 likes!

Cosultas a snowflake

Olá, Por algum motivo que não sei explicar, quando você faz uma quebra de linha, é preciso fechar as aspas duplas no final da linha e adicionar o sinal de mais(+) para concatenar a string subsequente. Exemplo: " select * from tabela "+ " where campo1 = 'teste' "+ " and campo2 = 123 " Ou manter todo o script em uma única linha.

---

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 December 2021

Top 3 Topics with Most Views

How to split excel value string made by @Learner007 with 39 views.

How to Map columns heading of two sheets made by @Tabbu with 39 views.

Publish New Version But Isn't Update in the Orchestrator made by @henokhbrian with 36 views.

Top 3 Topics with Most Replies

Need help in excel automation made by @Rana_Reddy with 17 replies.

UNable to find else if activity and uipath core activities made by @Seema_Jethe with 15 replies.

Error: can not open application snippingtool - does not refer to an existing file made by @philip2 with 13 replies.

Top 3 Users Who Posted The Most

@kirankumar.mahanthi1 made 27 posts!

@Yoichi made 14 posts!

@Hiba_B made 11 posts!

Top 3 Most Liked Posts

This post made by @drjordansudberg received 2 likes!

Dr. Jordan Sudberg about RPA

Dr. Jordan Sudberg, I love UiPath gives extensive guides and tutorials for consumers which makes it a lot easier to understand its processes and integration with your present software.

This post made by @pravin_calvin received 2 likes!

How to split excel value string

Hi @Learner007 Use the below expression to split! InputString.Split("-"c) And Use For each to iterate the string values Regards

This post made by @Hiba_B received 2 likes!

How to split excel value string

Hi @Learner007 ! Welcome to UiPath Community Here is a suggestion: Split data.xaml (8.0 KB)

Top 3 Most Liked Solutions

This solution provided by @kirankumar.mahanthi1 received 2 likes!

Publish New Version But Isn't Update in the Orchestrator

Hi @henokhbrian , Could you check whether you are publishing the process to orchestrator or given any custom url to publish the process. When you are deploying from studio click next and select the deploy option in that screen select the publishing option to orchestrator not custom url. Sometimes this may cause the issue. Pls double check. Thanks.

This solution provided by @kirankumar.mahanthi1 received 1 likes!

How to specify from which particular email account you wanna download attachment in Email Attachment

Hi, Sample like you want to filter the emails with the subject. item.subject.contains(“Your email subject or partial subject”) or if you want email from specific email id. item.From.contains(“Kirnakumar@gmail”) Or if we want to search fixed email id we could use expression like below item.From.Equals(" Email adress ")

This solution provided by @kirankumar.mahanthi1 received 1 likes!

My Outlook is always asking Permissions, While sending Mail. How to Disable it?

Hi @Bhagyaraj_Digumarthi , It is generic issue in outlook when your antivirus is out of date or inactive mode. If you wish you can disable through some outlook settings. Please refer the below documentation from Microsoft would guide 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 | 25 December 2021

Top 3 Topics with Most Views

I am facing a error while using UIPath studio made by @sharvesh_pareek with 38 views.

When I open a xaml file. I am getting this error. 'HintSize' property has already been set on 'Delay' made by @Sus_Mi with 31 views.

Write data_scraping data into excel one below other made by @Mahimahi with 30 views.

Top 3 Topics with Most Replies

Write data_scraping data into excel one below other made by @Mahimahi with 15 replies.

I am facing a error while using UIPath studio made by @sharvesh_pareek with 9 replies.

Business Rule Error in REFramework made by @Bhagyashri_Wani with 7 replies.

Top 3 Users Who Posted The Most

@Jobin_Joy made 12 posts!

@kirankumar.mahanthi1 made 8 posts!

@Srini84 made 6 posts!

Top 3 Most Liked Posts

This post made by @Jobin_Joy received 2 likes!

SharePoint List to Excel resulting Web query file

Hi @Robotman Can you try the below? Just save the iqy file locally and then point to the iqy file in the Excel Application Scope. Then you can use Read Range to pull the table. Usually it should automatically refreshes the query every time we run it. Note: Based on the data load/no.of records, there might be a delay in response from server. If this is not working, try whatever @kirankumar.mahanthi1 mentioned. Hope this will be helpful. Thank you.

This post made by @Divyamani received 1 likes!

Unable to Click on Save button

Thanks!!

This post made by @HANAKO received 1 likes!

IE11→Edge切り替え ダウンロード通知のセレクター選択ができない件について

Yoichiさん いつもコメントありがとうございます。 UiAutomation.Activites Packageのバージョンアップをしたところ改善されました。 ありがとうございました。

Top 3 Most Liked Solutions

This solution provided by @Jobin_Joy received 2 likes!

SharePoint List to Excel resulting Web query file

Hi @Robotman Can you try the below? Just save the iqy file locally and then point to the iqy file in the Excel Application Scope. Then you can use Read Range to pull the table. Usually it should automatically refreshes the query every time we run it. Note: Based on the data load/no.of records, there might be a delay in response from server. If this is not working, try whatever @kirankumar.mahanthi1 mentioned. Hope this will be helpful. Thank you.

---

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 December 2021

Top 3 Topics with Most Views

Uipath lagging/freezing and slowdown made by @Munish_Jain1 with 42 views.

How to open dynamic URLs one by one coming from a Filtered Data Table made by @hacback17 with 34 views.

How to delete all the written rows in Excel made by @Dmitri00007 with 32 views.

Top 3 Topics with Most Replies

How to extract the amount from string made by @varun_sai with 19 replies.

Unattended Robot with SAP made by @Cari with 13 replies.

Uipath lagging/freezing and slowdown made by @Munish_Jain1 with 11 replies.

Top 3 Users Who Posted The Most

@Robinnavinraj_S made 22 posts!

@Jobin_Joy made 13 posts!

@kirankumar.mahanthi1 made 12 posts!

Top 3 Most Liked Posts

This post made by @Robinnavinraj_S received 2 likes!

Write data_scraping data into excel one below other

Hi @kirankumar.mahanthi1 Can we use two data scrapping activities based on iterations like if (index =1) { scrape both the columns(data scrapping ) } if(index >1) { Scrape only column2 (data scrapping) } Thanks,

This post made by @Jobin_Joy received 1 likes!

SharePoint List to Excel resulting Web query file

Yes. It will refresh the data from the server based on the predefined query. Thank you.

This post made by @yulya received 1 likes!

Error "Add to Collection"

[list] Hello, please tell me what the error is, I create a list, initialize it, but the robot writes that there is an error [error] [properties]

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 1 likes!

Error "Add to Collection"

You are almost done Just we need to initialise that list variable like this Go to Variable panel → in default column mention any of the below If you have a pre defined value then it has to be defined like this New List(of String) from {“value1”, “value2”,….,”value n”} Or If you just want to initialise without any value then mention this New List(of String) Note: Whenever you are initiating a collection variable like List or dictionary we need to initialise with default value For exam…

---

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 December 2021

Top 3 Topics with Most Views

How to link between published package and source code repository / パッケージと、ソースの連携 made by @Risa with 48 views.

Search Events: String was not recognized as a valid DateTime when trying to get the exact date made by @Zeid_Abawi_MiddleEast with 44 views.

Append excel from column two made by @Mahimahi with 40 views.

Top 3 Topics with Most Replies

Search Events: String was not recognized as a valid DateTime when trying to get the exact date made by @Zeid_Abawi_MiddleEast with 20 replies.

How to add Polish language in Tesseract OCR made by @mkriznjak with 19 replies.

Existing licence key extended for one week made by @vivek.gupta with 18 replies.

Top 3 Users Who Posted The Most

@Jobin_Joy made 34 posts!

@kirankumar.mahanthi1 made 32 posts!

@pikorpa made 23 posts!

Top 3 Most Liked Posts

This post made by @RAKESH_KUMAR_BEHERA received 3 likes!

Differences between Send Windows Message and Simulate Click Activity

There may be mutlitiple questions around UiPath Input Methods? For a UiPath Learner it is important to note and understand the diffrences between Send Windows Message and Simulate Type input methods. We need to understand as to how the activities respond differently when these options are selected? Let us face this UiPath Certification Practice Test Question and understand the real differences between Send Windows Message and Simulate Type Input Methods in UiPath. Kindly Click on VOTE (Left T…

This post made by @pikorpa received 3 likes!

How to add Polish language in Tesseract OCR

Hey @mkriznjak , I think I found the solution. On my PC it worked well So, firstly you have to go here: C:\Users\ userName \ .nuget\packages\uipath.vision\3.1.4\build\net461\tessdata and you have to copy polish language: pol.zip (8.6 MB) Next you have to restart you UiPath Studio and everything should works fine [image] [image] I hope it helps you

This post made by @Dr_Raza_Abidi_PhD received 2 likes!

How to trim whitespaces from column names in datatable

@Jobin_Joy : I am really sorry, I have thoroughly tried to mark this post as solution but could not do so. But, I have categorially tried to give you credit as much as possible at discussion. Many thanks,

Top 3 Most Liked Solutions

This solution provided by @pikorpa received 3 likes!

How to add Polish language in Tesseract OCR

Hey @mkriznjak , I think I found the solution. On my PC it worked well So, firstly you have to go here: C:\Users\ userName \ .nuget\packages\uipath.vision\3.1.4\build\net461\tessdata and you have to copy polish language: pol.zip (8.6 MB) Next you have to restart you UiPath Studio and everything should works fine [image] [image] I hope it helps you

This solution provided by @Jobin_Joy received 2 likes!

While Add queue Item in queue how to avoid duplicate data in queue

If you want add item(s) which are not added before means, simply set the unique reference error exception as nothing instead of throwing errorthat so the BOT will add the missed items to the queue. Basically, error will be there but you are not taking any action since it is excepted one in your case. Thank you.

This solution provided by @Jeroen_van_Loon received 2 likes!

Create Datatable with 3 Columns, 2 Columns from another datatable

There is an activity to do this much simpler: [image] This adds an empty column named AddedColumnName to the existing DT called MyOldDT. No need to mess around with code…

---

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

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

[system]

Daily Forum Report | 28 December 2021

Top 3 Topics with Most Views

VBA Code-- Help made by @Anjali_Rani with 50 views.

RegEx: Extact keywords from document made by @Yudhisteer_Chintaram1 with 42 views.

Filtering big data tables made by @yulya with 38 views.

Top 3 Topics with Most Replies

RegEx: Extact keywords from document made by @Yudhisteer_Chintaram1 with 14 replies.

Nested for each: Excel file being used by another process made by @m1k9801 with 13 replies.

VBA Code-- Help made by @Anjali_Rani with 12 replies.

Top 3 Users Who Posted The Most

@Sudharsan_Ka made 25 posts!

@Robinnavinraj_S made 22 posts!

@kirankumar.mahanthi1 made 22 posts!

Top 3 Most Liked Posts

This post made by @alexdjerassi received 3 likes!

Alex Djerassi

Alex Djerassi from the united states, We use UiPath in our organization. Unipath tool has many commands with which we can automate most manual functions, we can also customize the orders to fit our requirements, the evolution of the platform. it also helps users in a high execution of processes and reduces the expenses of automation of their organizations, also this application can also be used to improve the client experience, the execution of SQL queries helps to access the database easily,

This post made by @kirankumar.mahanthi1 received 3 likes!

Merge two datatables and place it in one sheet

Hi @Tabbu , Merge data table activity have two input arguments one is source data table and destination datatable. the mechanism of the merge is destination will come first and source come second. So use the data table you want first in the destination and second should be in source. the main point is for merging data table you should have same column names. thanks

This post made by @shreyash_shirbhate received 2 likes!

How to publish in document understanding folder

Hey @SH_94, Just select the folders in UiPath Studio in which you want to publish the package. Like below. [image] Also, while creating the folder on Orchestrator, make sure you select Create a new package feed option as below. [image] I hope this will help you! Thanks!

Top 3 Most Liked Solutions

This solution provided by @shreyash_shirbhate received 2 likes!

How to publish in document understanding folder

Hey @SH_94, Just select the folders in UiPath Studio in which you want to publish the package. Like below. [image] Also, while creating the folder on Orchestrator, make sure you select Create a new package feed option as below. [image] I hope this will help you! Thanks!

This solution provided by @Robinnavinraj_S received 2 likes!

While extracting the data trough document understing .i had used export extraction result, and writing to excel. i am getting data twice (simplefiled and simple field formated). how to avoid simple field format?

Hi @Mithesh_Reddy_Bolla You can directly gave tables in write range Ex:Dataset_var.Tables(0)- Non table values Dataset_var.Tables(2)- table values Kindly refer the below image for reference [example] Thanks, Robin

This solution provided by @Yoichi received 1 likes!

Filtering big data tables

Hi, Can you try the following sample? [img20211228-a1] dtKeep = dt2.AsEnumerable.Where(Function(r) dt1.AsEnumerable.Select(Function(r2) r2("Filtering Column").ToString).Contains(r("NoDoc").ToString)).CopyToDataTable() dtRemove = dt2.AsEnumerable.Where(Function(r) not dt1.AsEnumerable.Select(Function(r2) r2("Filtering Column").ToString).Contains(r("NoDoc").ToString)).CopyToDataTable() Sample20211228-a1.zip (18.2 KB) Note : This workflow outputs 2 datatable : one is to keep record which exi…

---

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

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

[system]

Daily Forum Report | 29 December 2021

Top 3 Topics with Most Views

Help required in RE Framework made by @Learner007 with 89 views.

Extraction Net Amount using Regex Based Extractor made by @SH_94 with 62 views.

All about Datatable - UiPath made by @Palaniyappan with 59 views.

Top 3 Topics with Most Replies

After find children activity how to click on ui element which is not visble on screen made by @Alok_Dwivedi with 19 replies.

Help required in RE Framework made by @Learner007 with 18 replies.

All about Datatable - UiPath made by @Palaniyappan with 15 replies.

Top 3 Users Who Posted The Most

@Robinnavinraj_S made 26 posts!

@kirankumar.mahanthi1 made 25 posts!

@postwick made 24 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 14 likes!

All about Datatable - UiPath

Hi All, Datatable - variable type is the most commonly used variable type by all UiPath users And it’s been the most often asked queries in forum especially on its manipulation So I would like to have this post as a repository for those who are looking for expressions related to Datatable Let’s go one by one keeping dt as name of datatable variable 1. Get number of rows in a datatable dt dt.Rows.Count (output - int32 type) 2. Get number of columns in a datatable dt dt.Columns.Count (output…

This post made by @kirankumar.mahanthi1 received 4 likes!

All about Datatable - UiPath

Great content. Very helpful. Thanks for sharing.

This post made by @Jeroen_van_Loon received 4 likes!

All about Datatable - UiPath

Excelent set of tutorials! Pin this on top and half of the forum questions are answered. There are a few options you mention though, using vb code to solve which can also be directly done by using the native UiPath activities. I see that a lot on the forum lately, everybody trying to solve things with code. While powerfull, the fact that these questions are so often returned here are that a lot of RPA devs have limited code knowledge, and rely heavily on the click and drag activities availabl…

Top 3 Most Liked Solutions

This solution provided by @pikorpa received 3 likes!

Error encountered prossecing expression

Hey, You should save Excel output to the datatable variable. The error which you get is saying that you are trying to assign a string value to datatable.

This solution provided by @Sudharsan_Ka received 2 likes!

Extraction Net Amount using Regex Based Extractor

both the values have been matched [image] The 3 and 5 values need to use split method to get the appropriate value Can you try this split(Value 3," ")(2) [image] Regards Sudharsan

This solution provided by @Srini84 received 2 likes!

Add column with condition without loop

@SakshiGupta Use Write Cell activity and use this formula [image] After that you can use Fill Range and pass the Range to fill the above formula 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 | 30 December 2021

Top 3 Topics with Most Views

Hardware and Software requirement Space related made by @Majunu09 with 58 views.

Bookmark of Bookmarksss… Let’s cherish 2021 made by @Palaniyappan with 48 views.

How to trim column cell values in For Each Loop made by @Dr_Raza_Abidi_PhD with 46 views.

Top 3 Topics with Most Replies

How to trim column cell values in For Each Loop made by @Dr_Raza_Abidi_PhD with 23 replies.

copytoDataTable not working for LINQ query select menthod made by @Shoebmd with 16 replies.

Hardware and Software requirement Space related made by @Majunu09 with 15 replies.

Top 3 Users Who Posted The Most

@kirankumar.mahanthi1 made 26 posts!

@Srini84 made 20 posts!

@Robinnavinraj_S made 18 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 11 likes!

Bookmark of Bookmarksss… Let’s cherish 2021

Hi All, Hope everyone is eagerly waiting for the new years eve. It’s very obvious that one wouldn’t have got a chance to go through every topic in our forum. It would be exciting for a forum member to go through a topic that has been interesting for many. So Let’s start our journey for 2022, by sharing some of our favourite topics, post, bookmarks made during this year or previous years, in our forum. To start with, here’s the link to my favourites 1. Basic for any new user https://forum.u…

This post made by @jeevith received 8 likes!

Bookmark of Bookmarksss… Let’s cherish 2021

My picks with no specific order: Let SQL dispatch! @KanadMehta for is very easy and powerful way to avoid using a dispatcher process. Since the source code is open, it was refershing to see how one can avoid using a dispatcher process when the data already exists in SQL. Tutorial: Call UiPath Orchestrator API from SQL Server Get that name! @Yoichi for his gem of a find, which can return the workflow name when an exception occurs from the catch block. How to get the workflow name in catch b…

This post made by @pravin_calvin received 4 likes!

Find and replace didn't replace(Balareva)

Hi @Sa_Ge Refer to the xaml below ! Find and replace test.xaml (7.9 KB) Hope the above solves your problem! Regards

Top 3 Most Liked Solutions

This solution provided by @pravin_calvin received 4 likes!

Find and replace didn't replace(Balareva)

Hi @Sa_Ge Refer to the xaml below ! Find and replace test.xaml (7.9 KB) Hope the above solves your problem! Regards

This solution provided by @Sudharsan_Ka received 2 likes!

Regex Based Extractor - Ticket Number

If it is a spelling mistake Here is the expression try this If not Take this expression Regards Sudharsan

This solution provided by @Yoichi received 2 likes!

Count pdf attachment in email

Hi, The following expression returns count of pdf files. [img20211230-5] count = item.Attachments.Cast(Of Attachment).Count(Function(a) System.IO.Path.GetExtension(a.Name).ToLower=".pdf") Note: item is MailMessage type. Hope this helps you. 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 | 31 December 2021

Top 3 Topics with Most Views

How to add rows in existing datatable made by @Tabbu with 39 views.

Whats wrong in my project,? made by @ankur_kaushik2 with 38 views.

Get a particular record in a datatable made by @jhivesh.subron with 37 views.

Top 3 Topics with Most Replies

ブラウザ内の処理が終わった後のアプリ移行 made by @user173 with 16 replies.

Formating the text file made by @ANewLearner with 12 replies.

How to copy same values into different sheet? made by @Vinit_Mhatre with 11 replies.

Top 3 Users Who Posted The Most

@postwick made 34 posts!

@Yoichi made 17 posts!

@kirankumar.mahanthi1 made 15 posts!

Top 3 Most Liked Posts

This post made by @Sudharsan_Ka received 4 likes!

Happy New Year 2022

Hello Everyone! Wish you and your family a Happy New Year Hoping that the new year brings us lots of new and exciting opportunities in our lives.This new year will be our year. so glad we’re able to spend time together after a whole year! [image]

This post made by @kirankumar.mahanthi1 received 4 likes!

Happy New Year 2022

Wish you the same @Sudharsan_Ka

This post made by @Steven_McKeering received 4 likes!

Happy New Year 2022

Happy New Year @Sudharsan_Ka. All the very best to you and everyone for 2022!

Top 3 Most Liked Solutions

This solution provided by @kirankumar.mahanthi1 received 2 likes!

Find First/Last row Activity - Excel.Activities - Error

Hi @kashif_nasar , We have to create variables for First row index and Last row index for the activity Find First/Last row activity. if we create variables to store the indexes this error will go away. please refer the below screenshot for reference. thanks. [image] And also use the expression like following BankStatement.Sheet(“Sheet1”)

This solution provided by @Jeroen_van_Loon received 1 likes!

Whats wrong in my project,?

Your workflow works, though since you have your messageboxes within the loop they popup each time. Since the max value 9 is at the end of the array, it is determened only at the end of your loop, and untill then it pops up 7 as max 4 times. If you move the 2 messageboxes outside your loop you won’t get those in-between messages anymore, and only the final result with 9 as max, and 2 as min.

This solution provided by @jeevith received 1 likes!

Setting the File Path in Select File Activity

So you already have a variable which has the stored path string. That string can be set as arguments to other workflows and places you invoke workflows you can provide the SelectedFilePath. Read range activity can then use this SelectedFilePath with or without custom range values.

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

@pikorpa received 54 likes for their solutions!

@ppr received 51 likes for their solutions!

@Yoichi received 50 likes for their solutions!

---

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

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

[system]

Daily Forum Report | 01 January 2022

Top 3 Topics with Most Views

How to use this type into activity made by @shiva_raj1 with 38 views.

Unable to find ML Skills in the orchestrator page made by @weipingtong128 with 26 views.

I want to filter datatable dynamically made by @nidhanshu with 25 views.

Top 3 Topics with Most Replies

How to use this type into activity made by @shiva_raj1 with 11 replies.

あるウィンドウで、クリックやホットキーが反応しない made by @nice-guy with 8 replies.

How to read, write into same excel? made by @rahul_gola with 6 replies.

Top 3 Users Who Posted The Most

@kirankumar.mahanthi1 made 8 posts!

@Yoichi made 7 posts!

@galinamorskayapexota made 4 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 6 likes!

Happy New Year 2022

Thank you to all. Happy New Year for the Community and the UiPath Team. Stay all healthy, look forward to an eventful 2022.

This post made by @lakshman received 4 likes!

Happy New Year 2022

Happy New Year to all of you

This post made by @arivu96 received 3 likes!

Happy New Year 2022

[IMG-20220101-WA0071]

Top 3 Most Liked Solutions

This solution provided by @Robinnavinraj_S received 1 likes!

About IMAP Email

Pass the output of get imap mail message activity to For each activity and set type argument as “system.net.mail.message” use if activity to filter email Example item.From.Equals(“test@gmail.com”) or else you can use for each email activity and click additional filters [image] hope its solves your issue Thanks, Robin

This solution provided by @user173 received 1 likes!

ブラウザ内の処理が終わった後のアプリ移行

スケジューリングモードを一回にしたら直りました！！ 本当にありがとうございます！！

---

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

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

[system]

Daily Forum Report | 02 January 2022

Top 3 Topics with Most Views

How Extract String made by @Teaf with 48 views.

How to match the text with selction of dropdown list made by @lokesh_segu with 32 views.

Looking Assistance for Python made by @Jesmine with 31 views.

Top 3 Topics with Most Replies

How Extract String made by @Teaf with 11 replies.

Looking Assistance for Python made by @Jesmine with 9 replies.

Upload files to FTP based on mapping sheet made by @Dmitri00007 with 8 replies.

Top 3 Users Who Posted The Most

@kirankumar.mahanthi1 made 8 posts!

@Wariful_Zia made 5 posts!

@supermanPunch made 4 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 3 likes!

How Extract String

Hi @Teaf , Based on the Inputs you have provided, there seems to be a Space before a Number and the data before the Space constitutes to your Required Data to be extracted. Keeping this mind, I think you can test with the below Expression : (.*)\s\d (.*) is your required data, which in the Expression is a Group. Hence, You would need to get the First Group from the Result Match in the below way. System.Text.RegularExpressions.Regex.Match(InputStr,"(.*)\s\d").Groups(1).ToString.Trim InputSt…

This post made by @arivu96 received 1 likes!

How Extract String

Hi @Teaf , Use Below pattern and take only first occurrence .*?([0-9]) Regards, Arivu

This post made by @Srini84 received 1 likes!

About IMAP save Email

@Tejaswini_Yadav You can try with below activity [image] Hope this may help you Thanks

Top 3 Most Liked Solutions

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

---

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

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

[system]

Daily Forum Report | 03 January 2022

Top 3 Topics with Most Views

Selection of a tab not working in UI path made by @Karthikeyan_B with 41 views.

WHAT IS UIPATH made by @Abd_Hggf with 40 views.

After upgrade, column '' does not belong to table DataTable made by @golden_huang with 39 views.

Top 3 Topics with Most Replies

Object reference is not set to an instance of an object in Assign Activity made by @Tabbu with 19 replies.

After upgrade, column '' does not belong to table DataTable made by @golden_huang with 18 replies.

Selection of a tab not working in UI path made by @Karthikeyan_B with 17 replies.

Top 3 Users Who Posted The Most

@arivu96 made 23 posts!

@Sudharsan_Ka made 22 posts!

@Robinnavinraj_S made 19 posts!

Top 3 Most Liked Posts

This post made by @arivu96 received 2 likes!

WHAT IS UIPATH

Hi @Abd_Hggf Welcome to UiPath Forum One of the best Automation tool in Market. UiPath is one of the most popular RPA tools that offers end-to-end solutions to help organizations effectively automate repetitive and redundant tasks. UiPath is a leading [RPA] provider in the industry, providing advanced robotic power capabilities to organizations to automate their recurring business processes. Refer below link for learning UiPath Academy Regards, Arivu

This post made by @Sudharsan_Ka received 2 likes!

WHAT IS UIPATH

HI @Abd_Hggf Uipath has a learning platform Here you can learn various things on the UIpath Regards Sudharsan

This post made by @pravin_calvin received 2 likes!

Search for a specific URL in browser

Hi @Tobias07 I have created a sample work flow based on your workflow! Refer to the xaml below! Main.xaml (13.8 KB) Regards

Top 3 Most Liked Solutions

This solution provided by @pravin_calvin received 2 likes!

Search for a specific URL in browser

Hi @Tobias07 I have created a sample work flow based on your workflow! Refer to the xaml below! Main.xaml (13.8 KB) Regards

This solution provided by @supermanPunch received 1 likes!

Why invoke method isnt working in my project?

Hi @ankur_kaushik2 , It is because you haven’t passed the Parameters in Invoke Method Activity. [image]

This solution provided by @Sudharsan_Ka received 1 likes!

Please help me correct this Id Statement If (NewVal IsNothing , Checkq = "New Val Is Nothing" , Checkq = "NewVal is not Nothing" )

Okay what is your assign variable Checkq right? If yes you use like this is will assign as per the condition Checkq = If (NewVal IsNothing ,“New Val Is Nothing” ,“NewVal is not Nothing” ) Regards Sudharsan

---

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

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

[system]

Daily Forum Report | 04 January 2022

Top 3 Topics with Most Views

Practice with ReFramework made by @sks with 59 views.

I got error when using "Compress files" made by @opas1216 with 38 views.

[Question] issue when using MsgReader in process base C# made by @sanggait1996 with 37 views.

Top 3 Topics with Most Replies

Practice with ReFramework made by @sks with 17 replies.

I want to delete the process made by @user118 with 15 replies.

[Question] issue when using MsgReader in process base C# made by @sanggait1996 with 14 replies.

Top 3 Users Who Posted The Most

@kirankumar.mahanthi1 made 25 posts!

@shreyash_shirbhate made 17 posts!

@Yoichi made 15 posts!

Top 3 Most Liked Posts

This post made by @viniciussm received 2 likes!

All about Datatable - UiPath

Awesome list, @Palaniyappan! One thing though, the header or code in items “11. Get Minimum value of a column in datatable” and “12. Get Maximum value of a column in datatable” might be swapped.

This post made by @Palaniyappan received 2 likes!

All about Datatable - UiPath

Thanks @viniciussm Changes updated

This post made by @ppr received 2 likes!

How to remove the duplicate key from json array

May we ask you to share some sample data with us. Thanks

Top 3 Most Liked Solutions

This solution provided by @THIRU_NANI received 2 likes!

Attach Window activity si missing

Hi! Can you turn off the modern design experience inside the project panel [Modern] Regards, NaNi

This solution provided by @arivu96 received 2 likes!

I want to delete the process

Change the interval to ALL and do the filter again. Regards, Arivu

This solution provided by @pravin_calvin received 1 likes!

Extracting 4 or more digit string from random string

Hi @tomaz Refer to the screenshot below! [image] [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 | 05 January 2022

Top 3 Topics with Most Views

How to ignore case sensitive selector for aaname made by @Archie with 78 views.

Substracting Substring for a String made by @tomaz with 46 views.

Read Dynamic Sheet in excel , but only particular sheets made by @kavya.s16 with 40 views.

Top 3 Topics with Most Replies

How do I check if a Variable exists in a Dictionary (Key, Value)? made by @andrea.ong with 15 replies.

Read Dynamic Sheet in excel , but only particular sheets made by @kavya.s16 with 14 replies.

How to ignore case sensitive selector for aaname made by @Archie with 9 replies.

Top 3 Users Who Posted The Most

@Yoichi made 28 posts!

@THIRU_NANI made 21 posts!

@Srini84 made 13 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

How to convert column values into an array

Hi Can you try the following expression? arrStr = dt.AsEnumerable.Select(Function(r) if(r("Quantity") isnot Nothing, r("Quantity").ToString(),"")).ToArray() Regards,

This post made by @Praw1n received 2 likes!

How to convert column values into an array

Thanks a lot @Yoichi It is working…

This post made by @Yoichi received 2 likes!

How to ignore case sensitive selector for aaname

Hi, It would be as the following. Can you try this? <webctrl aaname='*required' parentid='form-no-1' tag='SPAN' casesensitive:aaname='false' /> Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to ignore case sensitive selector for aaname

Hi, It would be as the following. Can you try this? <webctrl aaname='*required' parentid='form-no-1' tag='SPAN' casesensitive:aaname='false' /> Regards,

This solution provided by @Yoichi received 2 likes!

Strange difference with latest uiautomation activities

Hi, it’s modern/classic design matter. Can you try to turn on at ModernDesignExperience in ProjectSettings , as the following? [img20220105-9] We can also change default settings of project at Home- Settings - Design. Regards,

This solution provided by @ppr received 2 likes!

I want to choose a string which repeates more number of times in array or list

As an alternate we can do with LINQ: [grafik] (From x In arrValues Group x By k=x Into grp=Group Order By grp.Count Select s=k).Last() [grafik] Find starter help here: Array_GetItemWithMaxOcccurence.xaml (5.2 KB) Also Have a look here:

---

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

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

[system]

Daily Forum Report | 06 January 2022

Top 3 Topics with Most Views

Assign: Syntax error: Missing operand after 'O' operator made by @Praw1n with 52 views.

Filter data (Excel) made by @fairymemay with 49 views.

How to check dup rows (excel)? made by @fairymemay with 35 views.

Top 3 Topics with Most Replies

Assign: Syntax error: Missing operand after 'O' operator made by @Praw1n with 18 replies.

Selectors Issue made by @ashish.pandey0920 with 13 replies.

How to manipulate the data that needs to be passed in http request made by @sneha_arbole with 10 replies.

Top 3 Users Who Posted The Most

@arivu96 made 23 posts!

@postwick made 20 posts!

@Yoichi made 17 posts!

Top 3 Most Liked Posts

This post made by @ChenKai received 3 likes!

Happy New Year 2022

Happy New Year everyone

This post made by @kirankumar.mahanthi1 received 3 likes!

Split a string in a format of pdf get full text

Hi @siva_sankar , Could you pls try like below. the below expression provides you the desired result. thanks. System.text.RegularExpressions.RegEx.split(InputString, “\n”)(0)

This post made by @pravin_calvin received 2 likes!

ROI calculation

Hi @dennishpaul Check with the documentation below! Regards

Top 3 Most Liked Solutions

This solution provided by @kirankumar.mahanthi1 received 3 likes!

Split a string in a format of pdf get full text

Hi @siva_sankar , Could you pls try like below. the below expression provides you the desired result. thanks. System.text.RegularExpressions.RegEx.split(InputString, “\n”)(0)

This solution provided by @pravin_calvin received 2 likes!

ROI calculation

Hi @dennishpaul Check with the documentation below! Regards

This solution provided by @pravin_calvin received 2 likes!

How can i change date format from data table

Hi @Soudios I think you have missed the loop ! Use for each row in datatable And then assign the CurrentRow(“Date Piece”) = DateTime.ParseExact(row("Date Piece ").ToString,dd.MM.yyyy”, System.Globalization.CultureInfo.InvariantCulture).toString(“yy/MM/dd”) Regards

---

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

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

[system]

Daily Forum Report | 07 January 2022

Top 3 Topics with Most Views

Government of Canada - RPA Developer for HR staffing function - Anywhere in Canada - Canada - Contract made by @diego.ruiz with 43 views.

Error "Could not find a part of the path " thrown irregularly made by @l.m.heuijerjans with 38 views.

Looking for Linq Query made by @Shriswaroop_Joshi with 38 views.

Top 3 Topics with Most Replies

How To Use Switch Statement to check if Values from Excel Column belongs to one Liste? made by @hsendel with 17 replies.

UiPath.WebApi 12.0 - Orchestrator authentication deprecated made by @thapelo with 8 replies.

Get and count made by @Cari with 7 replies.

Top 3 Users Who Posted The Most

@Yoichi made 10 posts!

@hsendel made 9 posts!

@postwick made 8 posts!

Top 3 Most Liked Posts

This post made by @diego.ruiz received 2 likes!

Government of Canada - RPA Developer for HR staffing function - Anywhere in Canada - Canada - Contract

Job title: RPA Developer for HR staffing function Job role: RPA Developer Country: Canada City: Anywhere in Canada Company name: Government of Canada Employment Type: Contract Seniority level: Associate 3 to 5 years Job Description: We are looking to provide a 90 day work contract to a qualified individual experienced in RPA development using Uipath, ideally in HR staffing functions. You must be located in and be legally able to work in Canada. You must also meet a reliability level sec…

This post made by @ignasi.peiris received 2 likes!

How To Use Switch Statement to check if Values from Excel Column belongs to one Liste?

Hi @hsendel The Switch activity does not really allow you to work that way, nevertheless, you can “trick” it with an if nested inside the condition, and make it work as you want! What you want to do is the following expression, but a bit more complex: if(Condition,ValueIfTrue,ValueIfFalse) You can use this expression inside the Switch condition, and assign values like numbers to “ValueIfTrue” or “ValueIfFalse” to reach your goal: 1- Define Arrays [image] 2- Switch with Int32 Type (in my …

This post made by @codemonkee received 2 likes!

UiPath.WebApi 12.0 - Orchestrator authentication deprecated

Some additional helpful references. Afaik Basic Auth has not been publically depricated yet, but NTLM has. OAuth for External Applications for On-Prem is available as of 2021.4 https://docs.uipath.com/orchestrator/reference/authenticating

Top 3 Most Liked Solutions

This solution provided by @ImPratham45 received 1 likes!

Problem with paths in activity "Move file"

Try Like This : Variable1+" \ "+Variable2 Tardias_Por_Cliente_ruta1+" \ "+OldName2 Note: Dont Use space Before and after \ . I used just to print in this chat.

This solution provided by @Yoichi received 1 likes!

フロー実行中にどの処理を行っているかをログに書き出したい

こんにちは そうであればポイントポイントでログは出力しておいて、以下併用ではいかがでしょうか？

This solution provided by @ppr received 1 likes!

Get only unique rows

Give try in following Assign Activity Lhs: dtResult Rhs (From d in yourdatatablevar.asenumerable Group d by k=d(yourcolnameorindex).tostring.trim Into grp=group Where grp.Count=1 Select r=grp.first()).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 | 08 January 2022

Top 3 Topics with Most Views

A question about circular entry of Excel data made by @Uddynitjh with 34 views.

Find Distinct elements and its corresponding row from Data Table made by @JITU99 with 33 views.

Loop sheet for copy data? made by @fairymemay with 32 views.

Top 3 Topics with Most Replies

A question about circular entry of Excel data made by @Uddynitjh with 18 replies.

Find Distinct elements and its corresponding row from Data Table made by @JITU99 with 7 replies.

Manipulation on Datatable -help made by @Anjali_Rani with 5 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 15 posts!

@ppr made 6 posts!

@Uddynitjh made 5 posts!

Top 3 Most Liked Posts

This post made by @Nithinkrishna received 2 likes!

Storage bucket for dataset machine learning

Hey @SH_94 You need to kindly make sure two things, Robot user should be added to that folder which has the bucket configured (under settings or users tile from folder dashboard) Make sure the role provided to the robot has the necessary permissions on the action you are trying to perform Hope this helps. Thanks #nK

This post made by @Nithinkrishna received 2 likes!

"Service username" does not appear in the orchestrator

Hey @Lynx Kindly check whether you have installed the robot in Service Mode in the virtual machine. This issue normally occurs if the robot service is getting disconnected from the orchestrator. Thanks #nK

This post made by @SH_94 received 1 likes!

Storage bucket for dataset machine learning

Dear community, I would like to ask how can we know whether we have provided the robot access to data buckets in that folder as i have the error below: [image] [image] Many thanks again for the help

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 2 likes!

Storage bucket for dataset machine learning

Hey @SH_94 You need to kindly make sure two things, Robot user should be added to that folder which has the bucket configured (under settings or users tile from folder dashboard) Make sure the role provided to the robot has the necessary permissions on the action you are trying to perform Hope this helps. Thanks #nK

This solution provided by @Nithinkrishna received 2 likes!

"Service username" does not appear in the orchestrator

Hey @Lynx Kindly check whether you have installed the robot in Service Mode in the virtual machine. This issue normally occurs if the robot service is getting disconnected from the orchestrator. Thanks #nK

This solution provided by @ppr received 1 likes!

String to datetime

[grafik] DateTime.ParseExact("20180730", "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture) [07/30/2018 00:00:00] DateTime.ParseExact("20180730", "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture).GetType [System.DateTime] DateTime.ParseExact("20180730", "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture).toString("MM/dd/yyyy") "07/30/2018"

---

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.