Forum Engagement Daily Reports

[system]

Daily Forum Report | 24 October 2021

Top 3 Topics with Most Views

Where we will use index in excel made by @Subha_Sundara_moorthi with 29 views.

Extracting specific rows from data table: "Source contains no data rows" made by @Westfield with 27 views.

Hello everyone, i a, stuck in situation where i want to write data to exel workbook in a from a datatable row by row in a specific column.I am shareing a screen shot of this format.I have to write data row in B2 and then C2 .......please help me otta this made by @Trinity_Piyush with 27 views.

Top 3 Topics with Most Replies

Can't find "excel application scope" activity made by @Bassel_Ali with 8 replies.

Error Handling with Try Catch with excel output message made by @Daffodil with 7 replies.

How to solve the HRESULT E_FAIL made by @Veera_Raj with 7 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 14 posts!

@rahulsharma made 13 posts!

@Yoichi made 12 posts!

Top 3 Most Liked Posts

This post made by @katara received 1 likes!

Info: How Excel PDF Exported Files Stores Table Data

thanks document.pdf (109.8 KB)

This post made by @katara received 1 likes!

Create a Chatbot Using UiPath API Documentation and Tools like Snatch Bot and Integromat

thanks [1]

This post made by @Palaniyappan received 1 likes!

Error Handling with Try Catch with excel output message

Fine Make sure these are correct Columns are correct in that case use column index like this CurrentRow(0) - for first column CurrentRow(1) - for second column @Daffodil As column index starts with 0 for first column This multi assign activity is inside FOR EACH ROW activity And finally Try upgrading your activity package to latest version Go to Design tab → Manage Packages-> project dependencies-> upgrade all the packages Cheers @

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Error Handling with Try Catch with excel output message

Hi, It’s because your 1st column name in your Excel sheet is "Username ". (Extra whitespace exists at the end of the string.) Please remove the extra space in your excel sheet or modify column name in your assign to "Username " In addition Password and Status also has extra space. So correct them as same way. Regards,

This solution provided by @Palaniyappan received 1 likes!

Removing the first row and first 2 columns from an excel file

Hi Hope the below steps would help you resolve this To read .xls file always use EXCEL activity where use a excel application scope and pass the file path as input Inside the scope use a READ RANGE activity and there mention the range like this “C2” and get the output as dt If you are facing issue again then try upgrading the excel package Go to Design tab → Manage Packages → Project Dependencies → Upgrade UiPath.Excel.Activities Now to remove that empty row use this activity Rem…

This solution provided by @lakshman received 1 likes!

How get the first month of the invoice date

@copy_writes Try below expression. Input = “10/24/2021” Output = "01/"+CDate("10/24/2021").ToString("dd/")+CDate("10/24/2021").ToString("yyyy")

---

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

Top 3 Topics with Most Views

UiPath Forms - Conditions | Simple & Advanced using JavaScript made by @rahulsharma with 143 views.

How to iterate the dictionary made by @brindhaS with 42 views.

For Each Row only when Column="text" made by @sidb with 32 views.

Top 3 Topics with Most Replies

For Each Row only when Column="text" made by @sidb with 27 replies.

Check List made by @dcmf with 16 replies.

When running the UiPath, Error opening workbook. Make sure Excel is installed made by @SH_94 with 14 replies.

Top 3 Users Who Posted The Most

@postwick made 27 posts!

@rahulsharma made 24 posts!

@Yoichi made 19 posts!

Top 3 Most Liked Posts

This post made by @rahulsharma received 14 likes!

UiPath Forms - Conditions | Simple & Advanced using JavaScript

UiPath Form is a great feature mainly for Attended Automation. The input stage can be transformed to be extremely interactive and easy to use with this amazing feature. I have been fortunate enough to have hands-on this feature since the very beginning and in this tutorial, we will see how can one add a simple and advanced condition using JavaScript on a component. What are Conditions in UiPath Form Conditions are the rules we want to apply to a component to alter its property. The condition…

This post made by @Dawodm received 2 likes!

LINQ Tutorial - From A to Z - Learn LINQ

Do you want to learn LINQ in UiPath from A to Z ? What is LINQ Query? Which Parts is a LINQ query consists of? LINQ Query Examples about: Arrays, DataTables, XML String LINQ Functions: Group, Order, Join Here is the video, where you can learn that: [UiPath | LINQ Training | Learn LINQ for UiPath from A to Z | LINQ Query Structure | LINQ Query Parts] Have fun!

This post made by @rahulsharma received 2 likes!

UiPath Form Designer - Validate 2 passwords

You can do it by adding a text field which has the error message, mark it as hidden by default and showcase that error message whenever the text of these two components are not matched. you can do this comparison with the help of Advanced condition option using JavaScript. You can put the condition on the submit button to be disabled, if that text box component is visible I posted a tutorial on how to use condition. I am sure this will help, do try it out.

Top 3 Most Liked Solutions

This solution provided by @rahulsharma received 2 likes!

UiPath Form Designer - Validate 2 passwords

You can do it by adding a text field which has the error message, mark it as hidden by default and showcase that error message whenever the text of these two components are not matched. you can do this comparison with the help of Advanced condition option using JavaScript. You can put the condition on the submit button to be disabled, if that text box component is visible I posted a tutorial on how to use condition. I am sure this will help, do try it out.

This solution provided by @Greg_Jacobson received 2 likes!

For Each Row only when Column="text"

Got it. I think a better plan would be to use the filter data table activity into a temporary datatable, and iterate through that. See the attached .xaml for guidance. It’s filtering the table 3 times, one for each letter. Then you can use the switch for any activities unique to the particular letter Sand.xaml (8.6 KB)

This solution provided by @JithinKP received 1 likes!

UiPathOrchestrator.msi 2021.4 download

If you feel like all of these are taking time, you can construct the download url by yourself. Check the release notes to find out what’s the latest version available 2021.4.3 Construct the URL as below: https://download.uipath.com/versions/{version_no}/UiPathOrchestrator.msi Current version available is 21.4.3, so you can try the below URL for msi file. https://download.uipath.com/versions/21.4.3/UiPathOrchestrator.msi

---

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

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

[system]

Daily Forum Report | 26 October 2021

Top 3 Topics with Most Views

Having a problem in creating a process made by @Pankaj_Kumar with 47 views.

How to filter multi condtion with multi column made by @ashishmani with 42 views.

Convert the data type of column of datatable made by @Ritika_Singh with 33 views.

Top 3 Topics with Most Replies

Having a problem in creating a process made by @Pankaj_Kumar with 23 replies.

How to filter multi condtion with multi column made by @ashishmani with 21 replies.

How to add link to Local Folder Path in Outlook Email made by @Archie with 17 replies.

Top 3 Users Who Posted The Most

@ppr made 23 posts!

@Yoichi made 21 posts!

@rahulsharma made 18 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

How to sum up times in an excel, taking the last cell with time as dynamic

Hi, Your data in E2:E9 seems not datetime type but string type. So can you try the following? [img20211026-5] new TimeSpan(dt.AsEnumerable.Select(Function(r) r("Process Duration").ToString).Where(Function(t) TimeSpan.TryParse(t,New TimeSpan)).Sum(Function(ts) TimeSpan.Parse(ts).Duration.Ticks)).ToString Note: please check PresrveFormat option in ReadRange Regards,

This post made by @rahulsharma received 2 likes!

How to run a BOT from one folder to another (multiple) folder with deployment in one folder - in modern folder

process was created with the help of package in that folder? then it will stay only in that folder again stating this, folder structure is there to restrict one folder’s entity to be accessed by other folder may be someone else can comment too, and correct me if I am wrong, looping few I think might be able to suggest something @ppr @Yoichi @Palaniyappan @codemonkee

This post made by @n_matsuda received 2 likes!

「Excel_アプリケーションスコープ_」がない

アプリケーションスコープ表示されました。ありがとうございます。

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Data scraping image links not returning correct output

Hi, it’s because you try to attach other page at AttachBrowser activity. [img20211026-3] In this case, you can remove this AttachBrowser activity as the following, as it’s already inside container :OpenBrowser. [img20211026-4] Regards,

This solution provided by @Robert_Russell_Monsalud received 1 likes!

Identifying multiple column names that do not exist in an excel file

According to @Yoichi, it is one of the solutions [img20211026-1] First, create string array named names which has column names which is checked. Then condition of IF is names.All(Function(s) dt.Columns.Contains(s)) And in Else, we can get missing column name from String.Join(",",names.Where(Function(s) not dt.Columns.Contains(s)))

This solution provided by @Yoichi received 1 likes!

Selecting Latest Year and Latest Month, and Oldest Year and Oldest Month(LINQ)

Hi, Can you try the following expression? Oldest dt.AsEnumerable.OrderBy(Function(r) new DateTime(Int32.Parse(r("Year").ToString),Int32.Parse(r("Month").ToString),1)).Select(Function(r) r("Year").ToString+":"+r("Month").ToString).First() Latest dt.AsEnumerable.OrderBy(Function(r) new DateTime(Int32.Parse(r("Year").ToString),Int32.Parse(r("Month").ToString),1)).Select(Function(r) r("Year").ToString+":"+r("Month").ToString).Last() Regards,

---

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

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

[system]

Daily Forum Report | 27 October 2021

Top 3 Topics with Most Views

Validation of headers in an excel file made by @jayanth_moguluri with 38 views.

Could not find the user interface element for this action made by @n-kumar4 with 37 views.

Compare both sheet in excel and filter the sheet made by @Asitabha_Deb_asitabhad with 34 views.

Top 3 Topics with Most Replies

Could not find the user interface element for this action made by @n-kumar4 with 27 replies.

Compare both sheet in excel and filter the sheet made by @Asitabha_Deb_asitabhad with 23 replies.

クリック出来なかった場合の処理について made by @youkey1027 with 15 replies.

Top 3 Users Who Posted The Most

@postwick made 27 posts!

@Yoichi made 21 posts!

@Palaniyappan made 21 posts!

Top 3 Most Liked Posts

This post made by @Voinalovych_Andrii received 5 likes!

RPA Developer Roadmap 2021

:robot:Good afternoon, RPA community! Today, I want to present you the v1.0 RPA Developer Roadmap (UiPath based) that was created BY developers and FOR developers. :star:By developing this project, we believe that it can bring together the knowledge of best specialists in the field! :wave:t2:This repository will be complemented by me and my colleagues, but you can also participate in its development and show your professional vision, as the repository is open for changes via pull request (Con…

This post made by @Lahiru.Fernando received 2 likes!

Facing issue with AI Center

Hello bro @Palaniyappan This error occur when you try to publish the Skill before training the package as explained by @rahulsharma Some models do allow publishing without training, however the others do not. May i know which model you are trying to deploy?

This post made by @kano received 2 likes!

ダウンロードを待機 (Wait for Download)が使えません

Yoichi様 Uipath.System.Activitiesをアップデートしたら出てきました。 有り難うございました！！！

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

How to Sort and get the files in Oder

new DirectoryInfo(YourDir).GetFiles().OrderBy(Function (x) x.Name).Select(Function (x) x.FullName).toArray But check its failling on lexically ordering [grafik] if we can rely on this page number token pattern we can do: (From fi In New DirectoryInfo("C:\_demo\DemoOrder").GetFiles() Let pns = Regex.Match(fi.Name,"(?<=page)\d+").toString Order By CInt(pns) Select f=fi.FullName).toArray if its coming from a splitting job, then maybe a sort on creation time can help new DirectoryInfo(YourDi…

This solution provided by @lucas.stern received 1 likes!

Table AuditLog and its Relations

Hi Stefan, I dont know how to answer your question, but in my opinion, what you are trying to do should be easir using the orchestrator API, since in the swagger docs they are more or less answering you questions, look: [image] [image] Im not sure, but I think that you can use the second image to answer your questions about the action enum. Regards.

This solution provided by @AdityaVN received 1 likes!

How to sum up times in an excel, taking the last cell with time as dynamic

Hi @Neha_Kumari1 variable time is GenericValue, we need to convert that to TimeSpan type and then use .Add() method to add the time more details after Format value activity create a variable of System.TimeSpan type, lets say TempTime assign TempTime = TimeSpan.Parse(time) this converts the GenericValue of time to TimeSpan type create another variable lets say total_time of TimeSpan type, assing value 0 before the For Each Row. Now within the for loop assing total_time = total_time.Add(Temp…

---

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

Top 3 Topics with Most Views

Generate Advanced Excel Report using Pivot Charts made by @rahulsharma with 99 views.

How to use PowerShell Core in a Cross-Platform Automation Workflow made by @StefanSchnell with 52 views.

How to solve this? made by @keerthi_arumugam with 51 views.

Top 3 Topics with Most Replies

Error while using merge Data table activity made by @shekhawat.arjun1307 with 21 replies.

How to add two different datatables in one common queue made by @Tarif_Mohammad with 18 replies.

Adding the rows in to the excel made by @HeartCatcher with 17 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 54 posts!

@postwick made 49 posts!

@Yoichi made 37 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 4 likes!

How to use PowerShell Core in a Cross-Platform Automation Workflow

This morning I tried my first cross-platform automation workflow. In this context I tested the use of PowerShell Core. I have used an Invoke Code activity for this. This activity is encapsulated in a separate workflow for reuse. The workflow has the following parameters: [image] Here the code: //-Begin---------------------------------------------------------------- if(FilePath == string.Empty) { ReturnMessage = "Error: FilePath missing"; return; } string PwshExe = "pwsh.exe"; if(PwshPa…

This post made by @AlokShrivastava received 4 likes!

Announcing UiPath Visionary Educator 2021 Recognitions

More than 1,600 educators from around the world took initiative to bring RPA knowledge and skills to over 240,000 students in the last 4 semesters! We take pride in recognizing the top 12 of them for their creativity and commitment to help build the future of their students. They learned, motivated, and taught their students to prepare for the future of work. Learn from their stories - please view the recording of the recognition webinar. [Visionary_Educator_of_the_Year_2021_Summary]

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

UiPath Technology Series 3 coming up this November!

Hello everyone! UiPath Community and Tech Alliance are continuing the Tech Integrations Series throughout Nov and Dec!!! It’s high-time to power up enterprise technology through automation! Please see promo details below and help us promote these strategic events showcasing UiPath integrations capacities. UiPath RPA has all the benefits of a versatile platform that can be used alongside many other technologies to achieve desired results. To help y…

Top 3 Most Liked Solutions

This solution provided by @AdryGL.96 received 2 likes!

How to remove "€" from string

Hi, You can use replace method: In_strNetTotal.Replace("€", "") Will return the string without the “€” Regards

This solution provided by @Palaniyappan received 1 likes!

Adding Data To Queue For Every Scheduled Time

Hi Did we try with queue trigger option that whenever a new queue item is added it triggers the bot say your Performer bot Or You can change the status of the queue item before adding new queue items, using GET QUEUE ITEM or GET TRANSACTION ITEM followed by SET TRANSACTION STATUS where mention as successful Cheers @Rishik_Chowdary

This solution provided by @postwick received 1 likes!

How does UiPath get the XML file of the program?

They aren’t .exe files. They’re applications running. Everything is an object, a UI element. Every open window, every button, every menu, every menu item, every web page title, link, button, every every little thing is an object to Windows. UiPath is just getting the properties of those objects from Windows. Windows also provides ways to interact with the ui elements either by controlling mouse/kb or “under the hood.” A selector is a path to an object, stated in XML format.

---

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

Top 3 Topics with Most Views

Not able to pick values from suggestion dropdown made by @Gopalakrishnan_K with 52 views.

Desktop Application made by @venkateshcheeni09 with 40 views.

Reply to Outlook Email with Different Subject made by @mnlatam with 35 views.

Top 3 Topics with Most Replies

Excel random click and delete on type into made by @Emilia_Daian with 19 replies.

How to Check For Null or Empty value in a Particular Column made by @mohamedalthaf with 13 replies.

Not able to pick values from suggestion dropdown made by @Gopalakrishnan_K with 13 replies.

Top 3 Users Who Posted The Most

@rahulsharma made 32 posts!

@sonaliaggarwal47 made 25 posts!

@Yoichi made 24 posts!

Top 3 Most Liked Posts

This post made by @cmiles received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

I am a college accounting professor introducing my student to RPA and UiPath is our chosen platform.

This post made by @ovidiu.iliescu received 2 likes!

UiPath Integration Service Public Preview is Now Available!

Hi Andy. You are not using the reference from step 1 properly. That is, once you have a reference to an object, there’s no need to use Get File/Folder - just use it directly. Most activities that create an object also output that object so that it can be directly used later. See this example: [image] Enter ID is for situations where you know the ID of an item but you don’t yet have a reference to it and want to obtain one. You use it to enter an ID (from a string variable or saved value or…

This post made by @Srini84 received 2 likes!

Regular expression to get only numbers from string

@Sarah_Tang Check below for your reference as an alternative Do a Replace as StringVariable.Replace(",","") Now use below system.Text.RegularExpressions.Regex.Match(ColumnData,"\d+") [image] [image] Hope this may help you Thanks

Top 3 Most Liked Solutions

This solution provided by @rahulsharma received 2 likes!

Regular expression to get only numbers from string

you can also replace anything else except numbers with nothing, which will give you a plane number string that can be converted into an integer. Syntax below System.Text.RegularExpressions.Regex.Replace(“strTextTobBeTreated”,"\D","") make sure to add the namespace System.RegularExpressions

This solution provided by @sonaliaggarwal47 received 1 likes!

Understanding potential risks for RPA projects

Hey guys, Adding some more to the list as below: uncontrolled exposing of confidential data through logs. ->Consider avoiding logging of sensitive data. uncontrolled exposing of confidential data through transactions in queues. ->Consider masking of sensitive data before saving on queue. Robot ID Stealing risk analysis Regards Sonali

This solution provided by @Yoichi received 1 likes!

How to Extract Regex Match n group n diynamicly

Hi, Can you try the following expression? resultArray = System.Text.RegularExpressions.Regex.Matches(yourString,yourPattern).Cast(Of System.Text.RegularExpressions.Match).Select(Function(m) m.Groups(1).Value).ToArray 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 | 30 October 2021

Top 3 Topics with Most Views

Where is my created file? made by @Michal_Podlasin with 30 views.

HTTP request fail: Method not found: ‘System.String RestSharp.Extensions.MiscExtensions.AsString(Byte[])’ made by @vikram_Rajpurohit with 29 views.

How to upgrade my uipath studio from 2019 to 2020? made by @kalees_waran with 29 views.

Top 3 Topics with Most Replies

Moving files to another location reading excel made by @Sameer_S with 7 replies.

Data Scaping stopped prematurely made by @Zheng_Haiming with 5 replies.

How to get the index of the column where value says "Y" made by @Shreeja with 5 replies.

Top 3 Users Who Posted The Most

@Yoichi made 15 posts!

@rahulsharma made 10 posts!

@RAKESH_KUMAR_BEHERA made 10 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

取得した要素をエクセルに書き込みする方法について（繰り返し）

こんにちは セルの書き込みの直後に代入アクティビティで 左辺 row 右辺 row+1 を設定してください。 別解として、繰り返しアクティビティのインデックスプロパティにInt32変数をセットすると 自動的にインクリメントしてくれるので、そこにrowをセットしたとすると、書き込むセル側で "A"+(row+2).ToString() とする手もあります。

This post made by @nagarjun_kumarnaik received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

I AM NAGARJUN FROM INDIA I AM HAPPY TO LEARN AND USE THIS TOOL I HAPPY TO JOIN UI PATH COMMUNITYAND IT’S A FUTURE AND FUTURE IS UIPATH MY QUALIFICATION IS MCA(Master of Computer Application)

This post made by @Palaniyappan received 1 likes!

Running jobs without PC switched on

Hi Locking a system is fine bot will try to login and run But while shutdown robot won’t work that When the machine is switched off, it will try to run the job, but it will fail because there is no machine available to run the process. And for this First to analyse, this process can be done in unattended mode So try in that way like use a REMOTE SERVER which willl get connected with a credential That is in locked or sleep mode But not in shutdown mode Hope this clarifies your query Ch…

Top 3 Most Liked Solutions

This solution provided by @lakshman received 1 likes!

A hash in a ID element

@Caetano777 Welcome to our UiPath community. Use wild card star in id part and it should be like this. id='Login*'

This solution provided by @Yoichi received 1 likes!

Data Scaping stopped prematurely

Hi, Can you try to change 100 to 0 at MaxNumberOfResult property of Extract Structured Data activity? Regards,

This solution provided by @rahulsharma received 1 likes!

Unable to locate newly created machine in UIPath Orchestrator

that folder should have access to the machine you created. Go to your folders tab and then edit the permissions for the particular folder Give a required role so that it can inherit the machine from tenant

---

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

Top 3 Topics with Most Views

Orchestrator Job Stuck in Pending Status After Update from 21.4.4 to 21.10.3 made by @cbnetworks with 35 views.

Sorted datatable is getting incorrectly made by @personal_mail with 29 views.

Want to apply tab made by @rutuja.y with 26 views.

Top 3 Topics with Most Replies

Bot didnot run after showing 'command sent" made by @ydash999 with 13 replies.

Orchestrator Job Stuck in Pending Status After Update from 21.4.4 to 21.10.3 made by @cbnetworks with 8 replies.

Sorting Table is getting incorrect made by @personal_mail with 6 replies.

Top 3 Users Who Posted The Most

@rahulsharma made 16 posts!

@Yoichi made 11 posts!

@sonaliaggarwal47 made 10 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 2 likes!

Running jobs without PC switched on

Interesting but I feel like this requires one more license to run a robot and send the signal and the respective machine is like on sleep mode The message is usually sent to the target computer by a program executed on a device connected to the same local area network If it’s in sleep mode it is still possible But being at shutdown is like machine is turned off - no power transmitted Which will eventually fail when orchestrator searches for it as a robot Cheers @Yoichi @Michal_Podlasin

This post made by @murray.trim received 1 likes!

SAP -Element misaligned with actual when mapping fields

Hi Stefan All good, thanks for your input. kind regards Murray

This post made by @rutuja.y received 1 likes!

Want to apply tab

Means I need to declare 4 separate variable to store value right?

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Error En Añadir Fila de Datos

Hi, Can you try to add new object[] at the beginning of the expression like new object[] {var1,var2,var3}? Regards,

This solution provided by @sonaliaggarwal47 received 1 likes!

Get orchestrator asset does not work with assets of type credential

Hi @Hima, This because get asset activity can’t fetch assets of type credentials. It can only fetch assets of type string,into,bool etc To fetch credentials from orchestrator asset, please use ‘Get Credentials’ activity. Also please note that currently you have defined credential asset name under asset sheet in config file. So please remove that row from there and keep in settings or constants sheet. Alternatively you can consider creating new sheet names Credentials but for that you will ha…

---

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

Top 3 Topics with Most Views

Issue with Find Children made by @Radap with 35 views.

Need to click on dynamic file name made by @shekharhimanshu627 with 34 views.

Click on SAP check box based on data in Sheet 3 made by @Asitabha_Deb_asitabhad with 32 views.

Top 3 Topics with Most Replies

Scraping the body of an email as text made by @dr1992 with 21 replies.

How to read multiple text files and extract each text file data moved to excel file made by @tejaswi_nerella with 11 replies.

Issue with Find Children made by @Radap with 11 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 20 posts!

@Yoichi made 17 posts!

@pravin_calvin made 14 posts!

Top 3 Most Liked Posts

This post made by @Srini84 received 9 likes!

Monthly Forum rewards - October 2021

Hello Everyone, Congrats @rahulsharma @Palaniyappan @Yoichi @ppr @StefanSchnell @sonaliaggarwal47 @lakshman @postwick @pravin_calvin Regards, Srini

This post made by @lakshman received 9 likes!

Monthly Forum rewards - October 2021

Congratulations guys @rahulsharma @Palaniyappan @Yoichi @ppr @StefanSchnell @sonaliaggarwal47 @postwick @Srini84 @pravin_calvin

This post made by @arivu96 received 8 likes!

Monthly Forum rewards - October 2021

Congratulations!!! Monthly forum award winners Regards, Arivu

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 1 likes!

How to Extract text Ahead from Textfile

Hi Welcome to UiPath forum Use a assign activity like this Let’s take you have your string input in a variable named Strinput Stroutput = Split(Strinput.ToString.Trim,”EMI(month):”)(1).ToString.Trim Cheers @Sriram_Gatla

This solution provided by @sonaliaggarwal47 received 1 likes!

How to access Json Attribute which has space in its name

Hi @Tracerecart, Can you share the screenshots ? what error does it throw? Can you try giving like below instead ? jsonObject.SelectToken("[‘Sells <$100’]") REgards Sonali

This solution provided by @Greg_Jacobson received 1 likes!

Elements that match a regular expression in a datatable

Here’s how you can do it in one line using an assign activity. The result of the below code is a boolean, true if every row in column 0 (1st column) matches a regex expression. You’ll need to add System.Text.RegularExpressions on your import list to avoid making this look too messy: dt.AsEnumerable.All(function(r) regex.isMatch(r(0).ToString, "myRegexPattern"))

---

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

Top 3 Topics with Most Views

Having trouble in working with Excel made by @Zen_Ahmed with 44 views.

How to use IronPython made by @StefanSchnell with 42 views.

Find Duplicates and Sum the values and update in Status Column made by @Srividya_N with 38 views.

Top 3 Topics with Most Replies

Dynamically add data into Data Table? made by @marsaandari with 11 replies.

Having trouble in working with Excel made by @Zen_Ahmed with 10 replies.

Filter DT based on Date Time made by @rjackson12 with 10 replies.

Top 3 Users Who Posted The Most

@ppr made 24 posts!

@rahulsharma made 21 posts!

@venkateshcheeni09 made 16 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 3 likes!

How to use IronPython

IronPython is an implementation of Python programming language for dotNET. The seamless integration of Python into the dotNET environment promises many advantages. The latest stable version is compatible with Python 2.7, but also is a preview available which is compatible with Python 3.4. In this post I will show how to use version 2.7. Preparations The first step is to download three NuGet packages: IronPython DynamicLanguageRuntime IronPython Standard Library After adding the packages to t…

This post made by @StefanSchnell received 2 likes!

Monthly Forum rewards - October 2021

Congratulations to all, the winners and the Community for these active members.

This post made by @ediongson received 2 likes!

Orchestrator Manager issue on "Unable to get access token due to failed authentication."

Hello, Sorry for the late response. I know the issue now. It is the SSL certificate. We generated a new certificate and the robot is now working perfectly. Thank you @ryota.okuji @Lakshay_Verma for your responses.

Top 3 Most Liked Solutions

This solution provided by @ediongson received 2 likes!

Orchestrator Manager issue on "Unable to get access token due to failed authentication."

Hello, Sorry for the late response. I know the issue now. It is the SSL certificate. We generated a new certificate and the robot is now working perfectly. Thank you @ryota.okuji @Lakshay_Verma for your responses.

This solution provided by @Yoichi received 2 likes!

Version 2021.10.3 missing Open Browser

Hi, The following helps you. Regards,

This solution provided by @Srini84 received 2 likes!

How to Replaces header in word

@Tharusha.fernando Check below for your reference 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 | 03 November 2021

Top 3 Topics with Most Views

Preparing for UiPath Certified Professional Exams - Join our FREE CertPrep Sessions made by @Rajesh_Nambiar with 34 views.

Text exist - eliminate whitespace importance made by @Michal_Podlasin with 33 views.

The Job is always pending on community Orchestrator made by @Aaron_Lao with 32 views.

Top 3 Topics with Most Replies

The asset does not have a value associated with this robot. Error code: 1503 made by @Nfs with 19 replies.

Text exist - eliminate whitespace importance made by @Michal_Podlasin with 13 replies.

Is it possible to read values from below mentioned 2 xml documents using same code? made by @anjasing with 13 replies.

Top 3 Users Who Posted The Most

@THIRU_NANI made 27 posts!

@ppr made 25 posts!

@Palaniyappan made 19 posts!

Top 3 Most Liked Posts

This post made by @Rajesh_Nambiar received 4 likes!

Preparing for UiPath Certified Professional Exams - Join our FREE CertPrep Sessions

[UiPath-LinkedIn-11Oct21 (2)] If you are ready to take the next step in your career by becoming a UiPath Certified Professional, you should attend this webinar. During this FREE webinar, a UiPath Instructor will lead a review of the exam objectives and will reinforce key topics you will need to know.

This post made by @Voinalovych_Andrii received 2 likes!

Cloud Automation Applies to RPA

Cloud computing is the process of running workloads in the clouds – IT environments that abstract, aggregate, and share scalable resources across the network. Neither cloud computing nor clouds are technologies in and of themselves. And this application of automation has not bypassed RPA. Many companies see and understand the need to implement robotic process automation (RPA). And this is logical since it will allow them to increase the efficiency of their activities, regardless of their global…

This post made by @lakshman received 2 likes!

How to make a specific Row as Header Row in Excel?

@mohamedalthaf Use LookUp Range activity and search for Date Of Birth value and it will give output as matching cell value. And pass that cell range to Read Range activity to read values from that cell onwards and also check Add Headers option in it.

Top 3 Most Liked Solutions

This solution provided by @lakshman received 2 likes!

How to make a specific Row as Header Row in Excel?

@mohamedalthaf Use LookUp Range activity and search for Date Of Birth value and it will give output as matching cell value. And pass that cell range to Read Range activity to read values from that cell onwards and also check Add Headers option in it.

This solution provided by @Palaniyappan received 2 likes!

Compare complete rows of two datatables

Hi Welcome to uipath forum Hope this expression would help you resolve this Common Values dt_CommonRows = dt1.AsEnumerable().Intersect(dt2.AsEnumerable(),System.Data.DataRowComparer.Default).CopyToDataTable UnCommon Values dt_UnCommonRows = dt1.AsEnumerable().Except(dt2.AsEnumerable(),System.Data.DataRowComparer.Default).CopyToDataTable Cheers @jbode

This solution provided by @ppr received 2 likes!

Delete Duplicate Excel Rows Based On One Column

[grafik] give a try on deleting the assign activity and rebuild it from new (we do it when the validation message is not making sense) - feel free to run the xaml stepwise for triggering a compliation before rebuilding. ensure following: [grafik]

---

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

Top 3 Topics with Most Views

UiPath Programming Languages Integrations Scenarios made by @StefanSchnell with 145 views.

How to snapshot table in excel to picture? made by @Maria99 with 36 views.

How to utilize an array of string variables? made by @kaiji_San with 35 views.

Top 3 Topics with Most Replies

How to utilize an array of string variables? made by @kaiji_San with 15 replies.

Assign Activity - Splitting Strings made by @mahrie with 13 replies.

Check of attended deployment with assistant made by @Craig1 with 9 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 33 posts!

@Yoichi made 23 posts!

@artur.stepniak made 16 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 3 likes!

UiPath Programming Languages Integrations Scenarios

The UiPath RPA platform offers many possibilities to realize automation workflows. One aspect is the integration of existing programs created with different programming languages. In this post I would like to pick out exactly this perspective. A kind of backward view of which programming languages can be used seamlessly with UiPath. The Programming Languages [Languages] For the arrangement of the programming languages I followed the current Tiobe index of October 2021. I was able to identify…

This post made by @Corina_Gheonea1 received 2 likes!

Become the next UiPath Community MVP for 2022 - Applications Open

Hi @irahmat The deadline to apply to become MVPs is Dec 5. You can be contacted any time in the coming weeks or in the coming 2 weeks after the term. Hope this helps! Corina

This post made by @LevKushnir received 2 likes!

SAP -Element misaligned with actual when mapping fields

Hi @murray.trim Then it is all super clear. The root cause is that SAP has introduced Multi Monitor Scaling support :(( It has nothing to do with UiPath. There are a plenty of issues with SAP WInGUI 7.70 und Multi scaling, feel free to check it our here: https://launchpad.support.sap.com/#/notes/2985351 In your case the solution would be Close all SAP windows incl. SAP Logon itself Set the DPI scaling of ALL your monitors to 100% (means, no scaling) in Windows display setting. Restart SAP…

Top 3 Most Liked Solutions

This solution provided by @LevKushnir received 2 likes!

SAP -Element misaligned with actual when mapping fields

Hi @murray.trim Then it is all super clear. The root cause is that SAP has introduced Multi Monitor Scaling support :(( It has nothing to do with UiPath. There are a plenty of issues with SAP WInGUI 7.70 und Multi scaling, feel free to check it our here: https://launchpad.support.sap.com/#/notes/2985351 In your case the solution would be Close all SAP windows incl. SAP Logon itself Set the DPI scaling of ALL your monitors to 100% (means, no scaling) in Windows display setting. Restart SAP…

This solution provided by @Yoichi received 1 likes!

How to utilize an array of string variables?

Hi, Can you try as the following? [img20211104-7] Regards,

This solution provided by @Yoichi received 1 likes!

Sum if the cost value column larger than 0

Hi, Hope the following helps you. [img20211104-2] dtResult = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("item").ToString,r("code").ToString)).Select(Function(g) dt.Clone.LoadDataRow({g.key.item1,g.key.item2,g.Where(Function(r) Int32.Parse(r("cost").ToString)>=0).Sum(Function(r) Int32.Parse(r("cost").ToString))},False)).CopyToDataTable dtResult = dtResult.AsEnumerable.Concat(dt.AsEnumerable.Where(Function(r) Int32.Parse(r("cost").ToString)<=0)).CopyToDataTable Sample20211104-2.zip (…

---

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

Top 3 Topics with Most Views

Orchestrator API Usage - External Application made by @Saksham with 37 views.

Table Extraction not work made by @felix.guan with 35 views.

Error using Get Outlook Mail Message from Outbox made by @KevinE with 35 views.

Top 3 Topics with Most Replies

Unable to paste data from excel made by @Praveen_Vs with 12 replies.

Date filtering in Excel made by @Nightowl_music with 12 replies.

Join multiple index in an array to form a new variable made by @Kerby with 11 replies.

Top 3 Users Who Posted The Most

@Yoichi made 41 posts!

@Palaniyappan made 34 posts!

@artur.stepniak made 25 posts!

Top 3 Most Liked Posts

This post made by @xxGoRpa received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello everyone I am currently using my personal email after i have finish my intern using RPA as a developer currently i am self studying to improve my automation using RPA Nice to meet you all Thank you

This post made by @ppr received 2 likes!

Use Try Catch in-line (not activity)

have a check below: [grafik]

This post made by @LisaBoneta received 1 likes!

Automation ops availability for on-prem users?

Hi @sonaliaggarwal47, hope you’re doing well! Automation Ops is now available on-premise, delivered as part of the 2021.10 release of Automation Suite. The release notes can be found here. For more information on Automation Ops on-premise, please visit here. Let me know if you have any questions! All the best, Lisa Boneta

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Use Try Catch in-line (not activity)

have a check below: [grafik]

This solution provided by @Palaniyappan received 1 likes!

Text exist - eliminate whitespace importance

Fine May be i will mention a simple way to achieve this First use a GET ATTRIBUTE activity where indicate the element and get the attribute aaname and save it to a string variable named Strinput Now use a IF activity and mention the condition like this Strinput.ToString.ToUpper.Contains(“DOGE”) If the value is true it will go to THEN block where use a MESSAGE BOX activity Here if you see you got to hold the value of “DOGE” in a string variable and also it is getting validated with …

This solution provided by @Yoichi received 1 likes!

レコーディングとアプリ/webレコーダーの違い

こんにちは 上記ですと最新ですね。 プロジェクト設定のモダンデザインエクスペリエスをオフにすると、古いレコーダーになると 思います。 レコーダーだけではなく、モダンの方は、ブラウザを開くやブラウザにアタッチの 代わりにアプリケーション／ブラウザを使うになっている等、使えるアクティビティが かなり違います。（フィルタ設定で他のカテゴリのものも出せますが）総合的にどちらを 使うかを判断したほうが良いかと思います。 なおStudio自体の設定に、新しいプロジェクトにモダンを使うの設定があるので ここをオフにしておくと、新規に作成した際にクラシックになります。 [img20211105-5]

---

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

Top 3 Topics with Most Views

HOW DO I MAKE MY PATH RELATIVE SO THAT ANY USER CAN USE THE ROBOT ONCE I PUBLISH IT made by @Dimple_Mandal with 39 views.

For Each Row making multipule entries? made by @shannon1 with 37 views.

Orchestrator very slow when run process made by @Mr.H with 35 views.

Top 3 Topics with Most Replies

HOW DO I MAKE MY PATH RELATIVE SO THAT ANY USER CAN USE THE ROBOT ONCE I PUBLISH IT made by @Dimple_Mandal with 14 replies.

How to save links attached in mail body made by @Kedar_Tawal with 7 replies.

Find Duplicates in a datatable using Filter Datatable activity in Uipath made by @Srividya_N with 5 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 15 posts!

@sonaliaggarwal47 made 7 posts!

@Dimple_Mandal made 6 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 2 likes!

Orchestrator very slow when run process

Hi @Mr.H, Duplicating the same issue won’t get you an answer sooner. Best practice is to continue your troubleshooting in the same thread, that way forum members who are trying to help you can read responses from other members. This question is a duplicate of : Run project from the orchestrator very slow - But run code directly on the local machine fast

This post made by @Yoichi received 2 likes!

I can't create a List<T>

Hi, Hope the following helps you. [img20211106-2] Regards,

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

Monthly Forum rewards - October 2021

Congratulations all the winners.

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 | 07 November 2021

Top 3 Topics with Most Views

UiPath Studio is not opening in Windows 11 made by @Chitra_Sharma with 39 views.

Hello guys, how to find data from DataTable that have same values; ex: people that have same address? made by @Shamsa_Abd with 37 views.

Auto-Testbook creation! made by @m.mezzacapo with 36 views.

Top 3 Topics with Most Replies

Hello guys, how to find data from DataTable that have same values; ex: people that have same address? made by @Shamsa_Abd with 7 replies.

Anyone know, why it is showing two red borders upon highlighted made by @vinodkumar.kalkumbe with 6 replies.

Copy sheet exception: HRESULT 0x800A03EC only on a specific sheet made by @Archie with 5 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 7 posts!

@Yoichi made 6 posts!

@Shamsa_Abd made 4 posts!

Top 3 Most Liked Posts

This post made by @Raviteja_N received 1 likes!

How to copy Past text from WebSite then paste it in NotePad

Hey, you can use “get text” activity to get the required text from website and use “type into” activity to write it down in notepad.

This post made by @prasath_S received 1 likes!

How to copy Past text from WebSite then paste it in NotePad

Hi @Nas Scrape the data from web page by using any of the following methods, Get text activity 2. Get full text activity 3. Get Ocr text activity 2. Screen scrapping in the ribbon And then for pasting we can use write text file activity. https://docs.uipath.com/activities/docs/write-text-file Thanks

This post made by @Brandon_Cunningham received 1 likes!

Convert to date time

I would change your condition isdate(CurrentRow.item(“Expiry”).ToString) Let me know if this helps. [image]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Hello guys, how to find data from DataTable that have same values; ex: people that have same address?

Hi, How about the following? [img20211107-5] Sample20211107-1v2.zip (3.3 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 | 08 November 2021

Top 3 Topics with Most Views

Monthly Forum Rewards - Sit Out the Game made by @StefanSchnell with 42 views.

Assign error? made by @Maria99 with 42 views.

[CheatSheet] - Filesystem APIs made by @ppr with 41 views.

Top 3 Topics with Most Replies

Fill data in a column based on 2 condition made by @Shilpa_Mohanty with 25 replies.

Assign: startIndex cannot be larger than length of string. Parameter name: startIndex1 made by @raja_ias with 19 replies.

Assign error? made by @Maria99 with 19 replies.

Top 3 Users Who Posted The Most

@sonaliaggarwal47 made 27 posts!

@prasath_S made 25 posts!

@Yoichi made 25 posts!

Top 3 Most Liked Posts

This post made by @ppr received 8 likes!

[CheatSheet] - Filesystem APIs

This CheatSheet introduces the basic use of available functionalities provided by the .Net API in order to deal with the filesystem. With further examples also special cases are presented. Basic Usage System.IO.Directory Directory offers some static methods for basic operations on folder and subfolders arrFullFilePaths | String() = Directory.GetFiles("C:\_demo\FileSystem\SubfolderA")

Visuals

[grafik] [grafik] [grafik]

System.IO.DirectoryInfo The DirectoryInfo class offers instance metho…

This post made by @StefanSchnell received 5 likes!

Monthly Forum Rewards - Sit Out the Game

@loginerror Hello UiPath Community Team, hello community, in my opinion there should be more movement of names in the monthly forum reward. So I suggest that someone who has been in the top ten for three months should sit out for three months, regardless of whether that is without or with interruptions. That means that he/she will not receive a nomination for three months, regardless of his activities during that time. I think that on this way there will be a little more motivation to share kn…

This post made by @Parth_Doshi received 3 likes!

Apps + Data Service Integration: Public Preview

This is awesome!!! UiPath Community find the complete tutorial here for the above feature: Apps + Data Service Integration: UiPath New Feature Update - YouTube

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to change 3 different date Format String value to DateTime

Hi, Hope the following helps you [img20211108-4] Sequence1.xaml (10.1 KB) Regards,

This solution provided by @marci080 received 2 likes!

Assign error?

Hi @Maria99 When you newly create or open an xaml in UiPath Studio, there are some folders and files generated automatically. Amongst them is the project json file. (Just like what happened when I opened your Reconcile.xaml file in my Downloads folder.) [image] You may learn more about it here Though I personally do not recommend manually editing the json file because some activities may not work/appear properly and will make debugging more complicated. Anyways, to address …

This solution provided by @StefanSchnell received 1 likes!

Unable to select elements in SAP 770 client

@urweeraratne Hello Udani, please look at this post from @LevKushnir. Lev describes in his answer the solution to a similar problem, or perhaps the same one. Best regards Stefan

---

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

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

[system]

Daily Forum Report | 09 November 2021

Top 3 Topics with Most Views

Error: Send Outlook Mail Message timed out made by @Maria_Carlao with 38 views.

Scheduling multiple jobs all from the same processes, but with different parameters made by @rogerfries with 38 views.

Rotate the column values one by one made by @dhanashree22 with 37 views.

Top 3 Topics with Most Replies

How to open folder and extracts data from the file and paste it in excel made by @Tabbu with 21 replies.

How to save my output row by row into excel made by @Xian with 16 replies.

Extract text from website made by @raja_ias with 16 replies.

Top 3 Users Who Posted The Most

@prasath_S made 38 posts!

@postwick made 23 posts!

@Yoichi made 22 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 3 likes!

Our Community is nominated at the CMX Community Industry Awards 2022!

@Vibhor.Shrivastava @cristina.vidu @DeaTo @Corina_Gheonea1 Voted, keep my fingers cross for you.

This post made by @Robinnavinraj_S received 3 likes!

Unable to create a new row in a datatable by using index

Thanks @Yoichi @prasath_S both of your solution works fine

This post made by @prasath_S received 3 likes!

Copy file activity not working for directory length more than 248 characters

Hi @Ritika_Singh Just a quick suggestion though I don’t know if it will work, if the error is due to the file name character count why can’t we rename the file before coy file activity and make to its original name after that. Thanks

Top 3 Most Liked Solutions

This solution provided by @Boopathi.M received 2 likes!

How to call datatable from config file

Hi @Raja.G Just assign the data table to dictionary and again retrieve datatable in process state by converting back that to DT. Thanks, Boopathi.ExtractDTfromConfig.zip (9.0 KB)

This solution provided by @prasath_S received 2 likes!

Unable to create a new row in a datatable by using index

Hi @Robinnavinraj_S Please try invoke code, pass the datatable (argument type in/out),datarow and position in arguments [image] Thanks

This solution provided by @balupad14 received 1 likes!

BALAREVA how to unhide all rows

Hi @berkaykor , Find the last row index by using this https://forum.uipath.com/t/read-last-row-excel-and-write-data-in-other-excel/308387/2?u=balupad14 And you can mentioned array row like this “Enumerable.Range(1,intLastRowIndex).ToArray()”. Here is the screenshot. [image] test.zip (28.0 KB) Regards Balamurugan.S

---

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

Top 3 Topics with Most Views

Select item from dropdow made by @nidhi.kowalli with 41 views.

Build data table column names not working correctly made by @Westfield with 37 views.

Get Min / Max Date from DataTable made by @Shilpa_Mohanty with 36 views.

Top 3 Topics with Most Replies

条件が複数ある場合の条件分岐について made by @marita with 15 replies.

Regex match pattern up to but exclude optional made by @lynnsong986 with 11 replies.

Initializing a JObject with key value pair made by @spidey with 10 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 74 posts!

@Yoichi made 18 posts!

@Jeroen_van_Loon made 11 posts!

Top 3 Most Liked Posts

This post made by @wasea received 3 likes!

Our Community is nominated at the CMX Community Industry Awards 2022!

done.

This post made by @nikita.kalra received 3 likes!

SirionLabs - SSE/Lead - RPA - Gurgaon - India - Full Time

Job title: SSE/Lead - RPA Job role: RPA Lead Country: India City: Gurgaon Company name: SirionLabs Employment Type: Full Time Seniority level: Senior more than 5 years Job Description: About SirionLabs: SirionLabs - SaaS Product firm | is looking for people who are driven to make a difference.Bringing together leading innovation, unrivaled Contract Lifecycle Management expertise, and a deep commitment to customer success, SirionLabs helps the world’s leading businesses contract smarter. …

This post made by @balupad14 received 2 likes!

Unprotect excel workbook

Hi @Airun , in the below link., you can get protect and unprotect the individual sheets. https://forum.uipath.com/t/balareva-excel-activities/38367/14?u=balupad14 Regards Balamurugan.s

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 1 likes!

Date conversion not working

Hi Welcome to uipath forum You are almost done If the input variable of string named strinput is of this format Then use a assign activity like this stroutput = DateTime.ParseExact(strinput.ToString.SubString(0,10).ToString.Trim, “yyyy-MM-dd”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”) Cheers @Rilna_Rilna

This solution provided by @Jeroen_van_Loon received 1 likes!

Initializing a JObject with key value pair

Main.xaml (8.5 KB) Roughly the same, in a working example including the datatables.

This solution provided by @VIDHATHA_THADURI received 1 likes!

Write value in cell dynamically

Hi, @Dev2 please find the soluton xlsx below… Main.xaml (11.1 KB) New Microsoft Excel Worksheet.xlsx (9.3 KB) sheet 1 >> input sheet2 >> output

---

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

Top 3 Topics with Most Views

Output Contains my keyword made by @raja_ias with 37 views.

Should queue items be uploaded manually or using a dispatcher for large volume of data to be fetched from a single CSV file made by @fardeen.shaikh.91 with 36 views.

Use vlookup formula in uipath made by @supu123 with 35 views.

Top 3 Topics with Most Replies

How to Filter Column based on first 5 dates made by @Dev2 with 14 replies.

How to use string manipulation made by @Priyanka_Jadhav1 with 13 replies.

Use vlookup formula in uipath made by @supu123 with 12 replies.

Top 3 Users Who Posted The Most

@Yoichi made 33 posts!

@Palaniyappan made 31 posts!

@Jeroen_van_Loon made 15 posts!

Top 3 Most Liked Posts

This post made by @PeCour received 2 likes!

Apps + Data Service Integration: Public Preview

@evan.cohen I have a suggestion for the UiPath Forum and the latest learn / use cases page ( Latest Learn/Use Cases Repository topics - UiPath Community Forum). When announcing such a great new feature it would be very interesting for which use cases other companies use the new feature. The new feature significantly expands the functional scope of the apps. For example, recently the feature file control has been added and I could immediately tell for which use cases we applied it since we have…

This post made by @Hiba_B received 2 likes!

Mon Ruban Studio - Débogage - Episode 9

Tu t’es déjà servi de toutes les options du ruban Studio (version Classic) ? Personnellement non, que les trucs que j’appelle “de survie en mode dev” (Debug, next step, highlight, run et voilà) Alors je me suis dit que c’était une super occasion de les découvrir ensemble ! Je propose qu’on commence par la partie Debug, vu les éléments qu’il y a A quoi sert le debug ? Une bonne pratique pendant le développement reste de tester…

This post made by @Yoichi received 2 likes!

文字列の抜き出し

こんにちは 式はどちらか一方で良いです。（同じ結果が返ります。） 実装イメージは例えば以下になります。 [img20211111-7]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

文字列の抜き出し

こんにちは 式はどちらか一方で良いです。（同じ結果が返ります。） 実装イメージは例えば以下になります。 [img20211111-7]

This solution provided by @Palaniyappan received 1 likes!

Can I use attended license without an orchestrator?

Hi Yes you can use @111617 It is not mandatory to have UiPath Orchestratorwhen running attended robots. However, having UiPath Orchestrator also adds value to attended robot deployments. Here are some of the additional value: Automation Lifecycle Management - after developing the automation on Studio, you can publish the automation in Orchestrator. From Orchestrator, you then distribute the automation to all the attended robot users that need to run that automation. Succeeding updates to the…

This solution provided by @Yoichi received 1 likes!

How to Filter Column based on first 5 dates

Hi, Can you try as the following? [img20211111-f] arrDr =dt.AsEnumerable.Where(Function(r) DateTime.Parse(r("DateColumn").ToString)>=new DateTime(Now.Year,Now.Month,1) AndAlso DateTime.Parse(r("DateColumn").ToString)<new DateTime(Now.Year,Now.Month,6)).ToArray Note: arrDr is DataRow Array type. Regards,

---

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

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

[system]

Daily Forum Report | 12 November 2021

Top 3 Topics with Most Views

🌟 Join us to learn what's new in UiPath 2021.10! made by @judylee with 50 views.

Internal links not working in body of Send Outlook mail made by @Ish_Pandey with 33 views.

Save as problem made by @legiw18734 with 32 views.

Top 3 Topics with Most Replies

How to upload multiple zip files made by @kailas_jadhav with 23 replies.

Create multiple xml file made by @Cristian_Ionita with 9 replies.

Internal links not working in body of Send Outlook mail made by @Ish_Pandey with 8 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 29 posts!

@Yoichi made 23 posts!

@ppr made 11 posts!

Top 3 Most Liked Posts

This post made by @judylee received 5 likes!

Join us to learn what's new in UiPath 2021.10!

:wave:Hi UiPath Community! Are you excited to learn about our platform’s freshest capabilities? The new UiPath 2021.10 is packed with over 100 new features to help you accelerate productivity and elevate the definition of what’s possible with automation. Join the virtual event on November 18 in your time zone at 11am EST, 10am GMT, or 2pm AEDT where we will show you in real time what you can do with the new capabilities. Hear from UiPath CPO Param Kahlon for an overview of the key…

This post made by @tomasz.gaczynski received 2 likes!

SAP QUERY RFC_READ_TABLE

Hi Stefan, I always stick to YYYYMMDD but I know some RFC functions actually receive date as string and apply conversion exits to it, and then, user specific date format matters. This is horrible implementation practice but I’ve seen variety of horrible programming practices in SAP code In short: when dealing with SAP date, format YYYYDDMM is my first choice. If it doesn’t work, I become worried. Cheers

This post made by @Yoichi received 2 likes!

Null value is not considering in dt.select not equal filter

Hi, I think it’s better to use LINQ as @prasath_S shows. However if you want to use DataTable.Select method, the following will work. dt.Select("[ID1]<>[ID2] OR ([ID1] IS NULL AND NOT([ID2] IS NULL)) OR (NOT([ID1] IS NULL) AND [ID2] IS NULL)") Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Null value is not considering in dt.select not equal filter

Hi, I think it’s better to use LINQ as @prasath_S shows. However if you want to use DataTable.Select method, the following will work. dt.Select("[ID1]<>[ID2] OR ([ID1] IS NULL AND NOT([ID2] IS NULL)) OR (NOT([ID1] IS NULL) AND [ID2] IS NULL)") Regards,

This solution provided by @l.sambinelli received 1 likes!

SAP QUERY RFC_READ_TABLE

Hello everybody! my date has this string format datetime_lastMonday.ToString(“yyyyMMdd”) i found a solution to delete bracket and finally the query give me the right results! [image] thanks for your precious help

This solution provided by @Yoichi received 1 likes!

Uipath 디자인 메뉴 관련 문의

Hi, Can you try to turn off at ModernDesignExperience in ProjectSettings as the following? [img20211112-4] 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.