Forum Engagement Daily Reports

[system]

Daily Forum Report | 02 July 2021

Top 3 Topics with Most Views

I am taking sales order numbers from a variable(array) and I want to put these order numbers into new line in outlook mail body(HTML format)? if anybody can help? made by @anjasing with 38 views.

Power Shell made by @a.ef with 34 views.

Data scraping does not capture the data from the next page made by @R_R with 33 views.

Top 3 Topics with Most Replies

Any regex for alphanumeric extraction in matches activity of uipath? for e.g. to extract this? made by @anjasing with 16 replies.

Power Shell made by @a.ef with 16 replies.

I am taking sales order numbers from a variable(array) and I want to put these order numbers into new line in outlook mail body(HTML format)? if anybody can help? made by @anjasing with 12 replies.

Top 3 Users Who Posted The Most

@ppr made 16 posts!

@anjasing made 14 posts!

@kumar.varun2 made 12 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Any regex for alphanumeric extraction in matches activity of uipath? for e.g. to extract this?

give a try on [A-Z]?\d+ [grafik] [grafik]

This post made by @Yoichi received 1 likes!

How to insert space between each characters given by user

Hi, Can you try the following expression? String.Join("",yourString.Select(Function(c) c+" ")).Trim Regards,

This post made by @ptrobot received 1 likes!

How to insert space between each characters given by user

Another way to do it is to use ToList(). It splits the string to a list of chars that you then can join to a string with a space in between them. String.Join(" ", str.ToList) [image]

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Any regex for alphanumeric extraction in matches activity of uipath? for e.g. to extract this?

give a try on [A-Z]?\d+ [grafik] [grafik]

This solution provided by @prasath_S received 1 likes!

Autofill Excel Function

Hi @Isyraf_Salahudin Please try this, You can read the excel data and store in a data table (dtTable) 2 And in autofill give range as “A2:A” + dtTable.rows.count.tostring Thanks

This solution provided by @LevKushnir received 1 likes!

Bug in UiPath.Core.Activities.SAP.CallTransaction

@Senseo929 Good news! We have no BUGs in our SAP Activities @raduc thanks for investigation @StefanSchnell thanks for confirmation Best regards, Lev

---

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

Top 3 Topics with Most Views

How to get the files from a folder in the same order it is saved? made by @Vignesh_Sahoo with 35 views.

How to Sum Negative and postive values in a single column in Excel made by @surya_teja.k with 30 views.

Internet explorer : “Open Browser: Cannot communicate with Internet Explorer browser” made by @annaa801252 with 29 views.

Top 3 Topics with Most Replies

How to Sum Negative and postive values in a single column in Excel made by @surya_teja.k with 11 replies.

ERROR: 1420, Message - 'Cannot acquire a license.' made by @atoi with 8 replies.

Timeout reached and Unlicensed License status made by @Aleksey_M with 8 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 10 posts!

@surya_teja.k made 6 posts!

@NIVED_NAMBIAR made 5 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

Issue in data filtering

Give a try on: Assign activity leftside: dtFiltered | DataType:DataTable Right side: (From d in YuurDataTableVar.AsEnumerable let acmn = d(yourColNameOrIndex).toString.Trim Where acmn.length = 8 Or acmn.length = 10 Select r=d).CopyToDataTable handling empty filter result can be done with following patterns: [grafik]

This post made by @kumar.varun2 received 2 likes!

Combining while and for each

Hi @ayub_z How about this [image] before for each data row loop initialize the counter as 0

This post made by @ppr received 1 likes!

Issue in data filtering

Currently we are working on rolling out a tutorial series on learning LINQ. Have a look on the first tutorials here: we suggest to start with learning the basics on List/Array base. With some more practice doing LINQ on datatables will be easier and more sucessfully.

Top 3 Most Liked Solutions

This solution provided by @ppr received 3 likes!

Issue in data filtering

Give a try on: Assign activity leftside: dtFiltered | DataType:DataTable Right side: (From d in YuurDataTableVar.AsEnumerable let acmn = d(yourColNameOrIndex).toString.Trim Where acmn.length = 8 Or acmn.length = 10 Select r=d).CopyToDataTable handling empty filter result can be done with following patterns: [grafik]

This solution provided by @kumar.varun2 received 2 likes!

Combining while and for each

Hi @ayub_z How about this [image] before for each data row loop initialize the counter as 0

This solution provided by @kumar.varun2 received 1 likes!

How to Sum Negative and postive values in a single column in Excel

@surya_teja.k try this dt.AsEnumerable.Sum(Function (x) If(x(1).ToString.Replace(" ","").IsNumeric, CDbl(x(1).ToString.Replace(" ", "")), 0 ))

---

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

Top 3 Topics with Most Views

Dealing with the last row of DataTable when using a loop made by @Lior_Ben_Naim with 33 views.

SAP Selector Issues made by @unknownay with 26 views.

Can we create a executable file of UI PATH automation process? made by @Deepak_Gautam with 25 views.

Top 3 Topics with Most Replies

Dealing with the last row of DataTable when using a loop made by @Lior_Ben_Naim with 7 replies.

Academy site doesn't work made by @Isabo with 6 replies.

Add a New Column to the Existing Excel Sheet which is created already made by @Jayavignesh_G with 5 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 9 posts!

@ermanoj3101 made 7 posts!

@RAKESH_KUMAR_BEHERA made 6 posts!

Top 3 Most Liked Posts

This post made by @wasea received 2 likes!

Can we create a executable file of UI PATH automation process?

Hello @Deepak_Gautam , I don’t think this is possible. If you create an automation in UiPath studio, your client should have installed the UiPath robot on his machine. That robot will execute the steps that you configured. You can send your automated process as a package, but not as an executable. I hope that helps. Vasile.

This post made by @ermanoj3101 received 2 likes!

Query - Automation

I don’t think their will be any challenges to automate fb or insta. I have done Automation on FB once to post one image everyday from respective folder. Go ahead and do it😀

This post made by @Bill_Pratt received 1 likes!

Reboot Your Skills Program - Introduce Yourself!

Hi, my name is Bill and I am managing the team that is investigating RPA for use at the Department of Homeland Security. We have a few bots built in a pilot implementation and are gathering use cases from many offices. I will not be doing the work but I want to know enough to be able to speak about it intelligently. My coding skills are about 30-35 years old at this point.

Top 3 Most Liked Solutions

This solution provided by @N2027 received 1 likes!

条件分岐で複数条件がある場合

配列で複数の文字列を条件にすることはできないので、 冗長的ですが、以下のように条件を指定してみてください。 ファイルパス.Contains(“文字列A”) and ファイルパス.Contains(“文字列B”) and ファイルパス.Contains(“文字列C”)

This solution provided by @NIVED_NAMBIAR received 1 likes!

Add a New Column to the Existing Excel Sheet which is created already

Hi @Jayavignesh_G for getting a clear idea, refer this workflow process1.zip (3.4 MB) Mark it as solution if it helps Regards, Nived N Happy Automation

---

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

Top 3 Topics with Most Views

Linking Regx With Excel value made by @Mpumi_Setshedi with 37 views.

Write Cell: Index was outside the bounds of the array made by @BoomBot with 31 views.

How to copy from Collection of DataRows to DataTable if Collection is empty? made by @Pedro_Pais with 30 views.

Top 3 Topics with Most Replies

Linking Regx With Excel value made by @Mpumi_Setshedi with 17 replies.

Get XML Nodes questions? made by @Matthew2 with 9 replies.

"Add Verification" made by @Riphath with 9 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 20 posts!

@ayush_purohit made 10 posts!

@Surya_Narayana_Korivipadu made 9 posts!

Top 3 Most Liked Posts

This post made by @TheTanmay1 received 3 likes!
https://forum.uipath.com/t/173729/772

This post made by @manjula_rajendran received 2 likes!

Extracting product description from Website to excel

@jeevana.nagothu-ext , when you extract the Food name get the URL also. [food] Then run each loop and navigate to the URL. Use Get Text activity to scrap the description. Here i attached the workflow. Check it Note: i used for only 10 records. ForForum.xaml (14.8 KB) Hope it will help you. Thanks, Manjula

This post made by @TheTanmay1 received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, I am Tanmay Agarwal, I am an Android developer and Founder & CEO of TheVirtualBots, Actually from childhood I have a passion for automation, robotics process, etc, but i was not able to find a way to fulfill it, but then recently my friend @Deepak_Gautam , introduced me with the power of UI Path as he showed me how he was able to automate his web scrapping of LinkedIn data using UI Path, I was literally amazed to see the working, so I got curious to check out this wonderful platform and …

Top 3 Most Liked Solutions

This solution provided by @ayush_purohit received 1 likes!

How can i ignore reply and forward mail message and take only the first mail message and its attachment

Whenever you get any reply, normally, you get RE: < Mail Subject > format. One of the simpler solution can be to check the subject line which does not start with RE: and has the required subject line. The other stuff wherein you download the attachment from an email can be done via regular steps. To make the solution more robust, the attachment name can be checked, this re-verifies if the file which bot has downloaded needs to be considered or not.

This solution provided by @ayush_purohit received 1 likes!

Hotkey for excel

Question is not very clear, but if you want to auto width - using Invoke VBA could be an option. Firstly, use write the following code in a txt file: Sub ColumnWidth() Columns("<Col_Name>:<Col_Name>").EntireColumn.AutoFit End Sub e.g, Col_Name = “A” to auto-width A column. Then use Invoke VBA activity in excel application scope. Mention Txt path and methodName = ColumnWidth

This solution provided by @kumar.varun2 received 1 likes!

Linq replacement for select query

Hi @Amrutha.mg Try this DT.AsEnumerable.Where(Function (x) x(str_CurrentVC).ToString.Contains(str_CurrentSCValue)).ToArray Query version (From r in DT Where r(str_CurrentVC).ToString.Contains(str_CurrentSCValue) Select r).ToArray

---

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

Top 3 Topics with Most Views

How to Filter Date Column with #N/A Value made by @surya_teja.k with 49 views.

Index was outside the bounds of array-URGENT made by @mitul_choudhary with 43 views.

How to write data in Excel file without overwriting? made by @1000_Yukino with 42 views.

Top 3 Topics with Most Replies

How to write data in Excel file without overwriting? made by @1000_Yukino with 27 replies.

Index was outside the bounds of array-URGENT made by @mitul_choudhary with 19 replies.

Input string was not in a correct format-Urgent made by @mitul_choudhary with 18 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 23 posts!

@kumar.varun2 made 17 posts!

@prasath17 made 16 posts!

Top 3 Most Liked Posts

This post made by @Max_Herrera received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi everyone, I’m Maximiliano, I have more than two years of developing automation with different tools, recently I started learning UI Path and I think is a great application for automation. Best regards!!!

This post made by @prasath17 received 2 likes!

Check for empty cell in a datatable

@TyraS - Please try this… (From d in dtData.AsEnumerable Let check = d.ItemArray.Any(Function (x) isNothing(x) OrElse String.IsNullOrEmpty(x.toString.trim)) Select check).Any(Function (e) e) Assign the above statement to Boolean variable…

This post made by @ryoko received 2 likes!

Excelにウェブサイトの情報を入力する方法

いらせられませ、ようこそForumへ Webから読み込む情報の項目が決まっているのであれば、 情報.xlsxで読み込んだデータテーブルに追加で入れるのではなく、 Web情報は新規データテーブルに格納し、Excelに追記の方が良いかも？ 以下は情報.xlsxがA1から始まるデータで、ヘッダーが1行の例です。 情報.xlsxから読み込んだデータテーブルを読み込む…データテーブルA ⇒行数取得用。 『データ テーブルを構築』Activityで情報.xlsxと同ヘッダーの新規データテーブルを作成…データテーブルB Webから取得した情報をデータテーブルBに格納 『範囲に書き込み』の開始セルに、列アルファベット+データテーブルAの行数+2を設定。『ヘッダーを追加』はチェックしない。 ⇒例：“A”+(データテーブルA.rows.count+2).tostring ※+2は、ヘッダー1行と最終行オフセット1行の合計 多分これで行けるかと思うのですが、どうでしょ？

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Check for empty cell in a datatable

@TyraS - Please try this… (From d in dtData.AsEnumerable Let check = d.ItemArray.Any(Function (x) isNothing(x) OrElse String.IsNullOrEmpty(x.toString.trim)) Select check).Any(Function (e) e) Assign the above statement to Boolean variable…

This solution provided by @manjula_rajendran received 1 likes!

Issue with Vm with unattended Bot

Hi @Tharusha.fernando , if it is a browser stuff, don’t need to worry. Complete your workflow. Set the Bot and set the scheduler for running. It will work on your VM. Note: If you are using Active Accessibility to scrape the data then it may not work if your screen is not enabled. Handle the situation in Try Catch. Thanks, Manjula

This solution provided by @kumar.varun2 received 1 likes!

Input string was not in a correct format-Urgent

CInt(((CDbl(If(drInvoiceMain.Item("IGST Amount").ToString.Equals(""), "0", drInvoiceMain.Item("IGST Amount").ToString))+CDbl(If(drInvoiceMain.Item("SGST / UT GST Amount").ToString.Equals(""), "0", drInvoiceMain.Item("SGST / UT GST Amount").ToString))+CDbl(If(drInvoiceMain.Item("CGST Amount").ToString.Equals(""), "0", drInvoiceMain.Item("CGST Amount").ToString)))/CDbl(drInvoiceMain.Item("Taxable Value").ToString))*100)=CInt(If(drInvoiceMain.Item("GST Rate").ToString.Equals(""), "0", drInvoiceMain…

---

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

Top 3 Topics with Most Views

String Manipulation- Remove made by @jenkim with 40 views.

Urgent help needed on Updating Values made by @surya_teja.k with 40 views.

Excel Activities for Processing and Filtering made by @jack.chan with 38 views.

Top 3 Topics with Most Replies

How to extract Words from Text that Contains a Given String? made by @hsendel with 12 replies.

String Manipulation- Remove made by @jenkim with 11 replies.

Urgent help needed on Updating Values made by @surya_teja.k with 11 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 28 posts!

@kumar.varun2 made 20 posts!

@Surya_Narayana_Korivipadu made 20 posts!

Top 3 Most Liked Posts

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

Excel Activities for Processing and Filtering

Hi everyone, i’d like to share my new custom activity. Feel free to use it and ask any questions [image] Main Functions include: 1. Batch Delete Rows In Excel - delete specified rows Inputs a. In_rowNumbersToDelete (string) - the row numbers to delete (separated by comma) a. .e.g. “1,3,5,7,9” b. In_excelPath (string) – excel path c. In_sheetName (string) – sheet name 2. Batch Highlight Rows In Excel - highlight specified rows a. In_rowNumbersToHighlight (string) - the row numbers to …

This post made by @petter received 3 likes!

I am struggling with finding a solution to delete all rows in an excel sheet

Hi I am completely new to UiPath, and I have started my first automation project in StudioX. I am struggling with finding a solution to delete all rows in an excel sheet that containing a specific word in a column.

This post made by @Surya_Narayana_Korivipadu received 3 likes!

Generate Yearly Report - transaction item doesnt recognize

Hi. You missed to map value to transaction item. See below screenshot: [image]

Top 3 Most Liked Solutions

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

Click activity in SAP logon automation

use “Select Menu Item” activity from UIAutomation package, after you specify the selector it should give you the option to select any of the items/sub-items in the menu

This solution provided by @Jeroen received 1 likes!

I am struggling with finding a solution to delete all rows in an excel sheet

Hi Petter, Welcome to the forum! I think this is the solution to your problem. Please let me know if it helps or if you need further assistance or explanation. Have you checked out the Academy.uipath.com courses on StudioX? They can teach you all the basics you need to get started with your automations. My workflow: [image] My Excel before: [image] My Excel after (all “Food” entries are gone): [image]

This solution provided by @jishnu.pnair received 1 likes!

How to setup HTTP request where body is form-data (Uploading Files)

Issue Fixed. Dim client As RestClient = New RestClient(“http://xxxxxxxx”) client.Timeout = -1 Dim request As RestRequest = New RestRequest(Method.POST) request.AddParameter(“file”, “abc_1.jpeg”) //request.AddParameter("body param name”, “param value”) request.AddParameter(“userId”, “Jishnu.PNair”) \second param and its values request.AddFile(“file”, “XXXXXXXX\abc_1.jpeg”) \ file that need to be uploaded - param and its value Dim response As IRestResponse = client.Execute(request) Console…

---

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

Top 3 Topics with Most Views

Most efficient way to web data extraction? made by @Rems with 95 views.

When Comparing two Excel getting wrong Output made by @Jayavignesh_G with 79 views.

How to get the weekday out from a string variable that holds a date? made by @Lior_Ben_Naim with 79 views.

Top 3 Topics with Most Replies

Postpone transaction item problem made by @liran.levin with 15 replies.

When Comparing two Excel getting wrong Output made by @Jayavignesh_G with 14 replies.

Most efficient way to web data extraction? made by @Rems with 13 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 41 posts!

@Srini84 made 21 posts!

@kumar.varun2 made 13 posts!

Top 3 Most Liked Posts

This post made by @Foxtrek_64 received 3 likes!

How to extract Words from Text that Contains a Given String?

I’m a bit late here but I feel like regex may be a bit too much here. I would instead suggest using a LINQ query. If you have your text as text, then you can easily do text.Split(' ').Where(x => x.Contains("fo") || x.Contains("in")) to grab all of the words.

This post made by @Yoichi received 2 likes!

Compile Error due to Data Type Int32

Hi, Can you try the following expression? "新規値"+Number.ToString() Regards,

This post made by @Thin_Thitsar received 2 likes!

Compile Error due to Data Type Int32

@Yoichi Thank for your reply. I got it. Kindly Regards, Thinn

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Compile Error due to Data Type Int32

Hi, Can you try the following expression? "新規値"+Number.ToString() Regards,

This solution provided by @Yoichi received 2 likes!

Ending a Do While loop if condition doesn't meet

Hi, Can you try to use Stopwatch class as the following? [img20210708-1] Regards,

This solution provided by @prasath_S received 2 likes!

Sum Column in DataTable based on Regions

@Dimple_Mandal Attached the workflow tested it please use this, Main.xaml (11.4 KB) 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 | 09 July 2021

Top 3 Topics with Most Views

How to save extracted data into one column dynamically made by @Bhagyashree_S with 44 views.

Data Discrepancy Excel- URGENT made by @mitul_choudhary with 35 views.

Adding time using Uipath made by @deguy42 with 32 views.

Top 3 Topics with Most Replies

Adding time using Uipath made by @deguy42 with 20 replies.

How to save extracted data into one column dynamically made by @Bhagyashree_S with 18 replies.

How To Check if String Exists in PDF File? made by @hsendel with 14 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 31 posts!

@Srini84 made 30 posts!

@vikasrawat911 made 23 posts!

Top 3 Most Liked Posts

This post made by @Vibhor.Shrivastava received 9 likes!

UiPath Cloud Masters

UiPath Cloud Masters [UiPath-LinkedIn-09Jul21_weekly_challange] The CLOUD MASTERS challenge is here! Develop your solutions with the help of specific cloud services and you get the chance to win every week! For five weeks long we challenge YOU to build and submit a solution using the unique services of a specified Cloud Provider: Google, AWS, Azure, IBM Cloud and Heroku. You are free to submit your solution to any challenge out of the total 5 opened, or to al…

This post made by @Elya received 3 likes!

How To Check if String Exists in PDF File?

Hello hsendel, → First try to read your pdf by using - UiPath.PDF.Activities. (if your pdf is a scan/ picture you have a ocr activity too) → Your output will be a string. Try somthing like this: For each row in dtexcel - if pdfstring.contain (row(wordtocapture)) (you can use regex instead of contain) Tell me if is it not clear and i will upload a xaml ^^

This post made by @cheez_RPA received 3 likes!

要素を選択できない箇所のクリック方法

違っていたら申し訳ないのですが、このアプリケーションってJavaで動いてませんでしょうか？ もし合っていましたら、Javaの拡張機能を導入することで要素取得できる可能性があります。

Top 3 Most Liked Solutions

This solution provided by @kumar.varun2 received 3 likes!

Get date of the first Sunday and Monday in April

Hi @markosc Use assign activity First Sunday firstSun = Enumerable.Range(1, Date.DaysInMonth(2021, 04)).Select(function (d) New Date(2021, 04, d).ToString("dddd dd/MM/yyyy")).Where(function (x) x.Split()(0).Equals("Sunday")).Take(1)(0).Split()(1) Monday After first Sunday monAftFirstSun = Date.ParseEaxact(firstSun, "dd/MM/yyyy", Nohting).AddDays(1).ToString("dd/MM/yyyy")

This solution provided by @Sali received 2 likes!

External Apps oAuth Scope for Orchestrator Cloud API

It’s OR.execution scope that you need to give, according to the swagger doc. Next time, just check the swagger doc instead as that has the updated scope in it. Hope this helps.

This solution provided by @Yoichi received 2 likes!

Modern Click activity Timeout not working

Hi, It might be Simulate click matter. To isolate the cause, can you try to change input mode from simulate to Hardware or sendWindowMessages? If the above solve this matter, can you try to set parallel activity then put click activities (with simulate click) at each lane. ( It might be need to exchange activities in left side and right side, if it won’t work) 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 | 10 July 2021

Top 3 Topics with Most Views

Python programming language made by @mdashrafrahi086 with 34 views.

BOT not able to fetch the details made by @Rakesh_Tiwari with 34 views.

Delete blank row (fast)? made by @fairymemay with 33 views.

Top 3 Topics with Most Replies

Regex difficult to create made by @Shoebmd with 6 replies.

Build data table and get min date value made by @pjaiphak with 5 replies.

BOT not able to fetch the details made by @Rakesh_Tiwari with 5 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 11 posts!

@GreenTea made 6 posts!

@ermanoj3101 made 4 posts!

Top 3 Most Liked Posts

This post made by @Nipul_Akalanka received 2 likes!

How to link three pc's through orchestrator using uipath enterprise edition

There are 3 PCs. first pc use for developing. second pc use for orchestrator(server pc). third pc use to run the robot(client pc). how to link all 3 PCs and make communication between all three in Uipath enterprise edition. it would be appreciated if you could give me a complete guide on this scenario.

This post made by @kaavya received 2 likes!

How can i download multiple files from website ? and if it navigates to another page then how can it be done?

@Kenneth_Balana above method was not working as i said earlier when i extracted, it doesnt provide me url, so what i did like used actions column under which download options come and tried your way but getting nthg and its not even navigating to another page see this is how i got it [Screenshot (49)] and though my url column doesnt contain aything but still wanted to try so this is what error i received [Screenshot (51)] thanks, kaavya.

This post made by @prasath17 received 2 likes!

How To Check if String Exists in PDF File?

@hsendel …yes possible. In the above post I am looking for word certificate using regex Right…you can use the same logic with some tweak as below… IntCount = system.text.regularexpressions.regex.matches(yourstring,regex pattern).count

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 | 11 July 2021

Top 3 Topics with Most Views

Uipath.MicrosoftOffice365.Activites - Upload files made by @NareshKumar_om with 33 views.

Calculate student age from excel in datatable made by @Tejaswini_Yadav with 33 views.

**URGENT**Can anyone help in converting input excel to expected output excel(u can refer to image)? made by @anjasing with 30 views.

Top 3 Topics with Most Replies

How to extract specific data from an outlook email made by @kaavya with 15 replies.

Calculate student age from excel in datatable made by @Tejaswini_Yadav with 9 replies.

Logs are not visible in Orchestrator from last days made by @tanweer.alammd with 7 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 15 posts!

@Surya_Narayana_Korivipadu made 10 posts!

@prasath17 made 8 posts!

Top 3 Most Liked Posts

This post made by @poorna_nayak07 received 2 likes!

How To Extract Words from Text which has a given Characters ?

@vikasrawat911 Thanks for observing it. @hsendel Please consider the edited/updated version of expression

This post made by @NareshKumar_om received 1 likes!

Uipath.MicrosoftOffice365.Activites - Upload files

Hi All, Please help me. Before posting this question, I have googled a lot but unable to find a direct answer. I am trying to upload PDFs to particular document library on the SharePoint site, Under the “Find Files\Folder” activity. I have provided the site URL for the SharePoint site and tried to provide the document library name on both “Query” as well on on "Drive Name together and also seperate, "First " from this Activity is provided as “Destination” on the “Upload Files” activity. when…

This post made by @NareshKumar_om received 1 likes!

Uipath.MicrosoftOffice365.Activites - Upload files

Yes, the same activity

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 1 likes!

How To Check if String Exists in PDF File?

@hsendel - you have to put that within if statement under then condition…so that it will print only when there is a match… You are reading each page and text is searched on each page…so you get total occurrences on each page. In the given example…Certificate was found in page 1 and page 5…so if you place your assign statement under then condition it will print only 2 times when there is a match. Please see below, it printed only 2 times when there is a match…and the word certificated had 2 oc…

---

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

Top 3 Topics with Most Views

Selector Error getting while running from Orchestrator made by @GovardhanReddy with 44 views.

Finding difference between numbers made by @Stanleycollege with 42 views.

Calculating the time difference between dates when the variables are string made by @Lior_Ben_Naim with 38 views.

Top 3 Topics with Most Replies

Object reference not set to an instance of an object-URGENT made by @mitul_choudhary with 68 replies.

Calculating the time difference between dates when the variables are string made by @Lior_Ben_Naim with 19 replies.

Selector Error getting while running from Orchestrator made by @GovardhanReddy with 16 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 35 posts!

@kumar.varun2 made 17 posts!

@Srini84 made 15 posts!

Top 3 Most Liked Posts

This post made by @mailsmithash received 5 likes!

We have more than 100,000 users, woo-hooo!

Congratulations to Uipath Community members.I have been part of Uipath Community since 2019. Have always received timely and helpful response from fellow community members which have solved most of my Uipath issues. Proud to be part of the Uipath Community and to have earned this badge. Kudos to all Forum Members and Forum Staff.Thanks for timely responses from @Palaniyappan @Lahiru.Fernando @pattyricarte @Pablito @lakshman @supermanPunch and many more.

This post made by @Srini84 received 2 likes!

How the attended bot work on VM?

@Vrushali_Gave As name suggests It’s an Attended bot, that means always you have to be in VM machine, If your client requires to run bot in VM in unattended mode then you have to go with Unattended license not Attended license Hope this may help you thanks

This post made by @LisaBoneta received 2 likes!

What is the difference between High Denisty Robot and Floating Robot?

@Nj42671 Hi Nidhi, we have documentation on high density robots (HDR) here: High-Density Robots This is very useful for understanding more details about HDR and how to implement it in your enviromnent An example of HDR: Let’s say you have a windows server machine in which you can have multiple users running on it. With HDR, you are able to register to a robot per each user on this server. The alternative to this would be spinning up different VMs per user which can be costly and difficult to m…

Top 3 Most Liked Solutions

This solution provided by @prasath_S received 1 likes!

How to add a fill a row based on row value and column head

Hi @Tharusha.fernando Please try this dt.AsEnumerable.Where(function(row) row(“Client”).tostring.tolower = “keyti”).ToList.ForEach(sub(row) row(“Minutes”) = “Present”) dtTable = output from build datatable , use read range instead of build datatable [image] [image] [image] Thanks

This solution provided by @vinithareddyk123 received 1 likes!

How to extract specific data from an outlook email

Hi @kaavya Please try below steps and let me know if its working or not Download the below activity [image] MailMessages is the out of GetOutlookMail activity Result is the out of Extract tables from email activity [image] Thanks

This solution provided by @prasath17 received 1 likes!

How To Search in PDF for Special Characters?

@hsendel - for that situation… First either do ismatch or count… based on that you will know the text is present or not…if the text is present then proceed based your requirement…

---

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

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

[system]

Daily Forum Report | 13 July 2021

Top 3 Topics with Most Views

Check if a variable grabbed from an excel cell with a lot of strings matches with any string from another cell made by @ciaramkm with 41 views.

Date Format In excel made by @supu123 with 40 views.

Filter Data is not working made by @NervousTuber with 38 views.

Top 3 Topics with Most Replies

Filter Data is not working made by @NervousTuber with 17 replies.

Get Visible Text Write Range made by @Pranav_KomandurPK with 16 replies.

How to Split Visible text that uses regex made by @Pranav_KomandurPK with 15 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 47 posts!

@Nithinkrishna made 45 posts!

@MarioHerrmann made 35 posts!

Top 3 Most Liked Posts

This post made by @AndyMenon received 4 likes!

How to Build Browser neutral Automations

If you would like to know how to build Browser neutral automations, this video tutorial series will be useful. Learn the fundamentals of crafting Browser neutral selectors Apply these selectors to your Open Browser and Attach Browser Activities Enhance your practices to build automations that can adapt to become Browser neutral as a matter of guiding principle Reduce the number of rebuild/redeploy iterations in your Application Life Cycle [How to build Browser neutral UiPath Automatio…

This post made by @katharine.hardy received 3 likes!

Orchaestrator execution target

Hi @shetyetejas557 Environment is a group of robots, so you can allow only certain robots to have access to run certain processes. Execution target is the robot on which you want your process to run, so you can select the robots from the list that appears at the bottom of the job “Start Job” screen. If you just want your process to be run on any robot within an environment, you can choose “Allocate dynamically” when starting a job and it will run the process on the first available robot within …

This post made by @AndyMenon received 2 likes!

Out Config file argument after an exception

I’ll give this a shot assuming I have understood this correctly. I’m presuming that “argument of the config file” is path to the config file? First the Config path must flow out of the initialization flow . Therefore you need to modify this flow to have an output string as an argument. Let’s say this argument name is out_ConfigArg You must trap the failure of your flow within a try catch and then set the value of out_ConfigArg in the Catch part to the value that you need. Obviously, in the M…

Top 3 Most Liked Solutions

This solution provided by @katharine.hardy received 3 likes!

Orchaestrator execution target

Hi @shetyetejas557 Environment is a group of robots, so you can allow only certain robots to have access to run certain processes. Execution target is the robot on which you want your process to run, so you can select the robots from the list that appears at the bottom of the job “Start Job” screen. If you just want your process to be run on any robot within an environment, you can choose “Allocate dynamically” when starting a job and it will run the process on the first available robot within …

This solution provided by @AndyMenon received 2 likes!

Out Config file argument after an exception

I’ll give this a shot assuming I have understood this correctly. I’m presuming that “argument of the config file” is path to the config file? First the Config path must flow out of the initialization flow . Therefore you need to modify this flow to have an output string as an argument. Let’s say this argument name is out_ConfigArg You must trap the failure of your flow within a try catch and then set the value of out_ConfigArg in the Catch part to the value that you need. Obviously, in the M…

This solution provided by @Yoichi received 2 likes!

Wordの自動化に関して

こんにちは Get Full Text アクティビティを試してみてください。 セレクターは以下の様に数字部分をアスタリクすにすると良いと思います。 <uia cls='NetUILabel' name='*個の変更箇所' />

---

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

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

[system]

Daily Forum Report | 14 July 2021

Top 3 Topics with Most Views

Input String was not in correct format error made by @dutta.marina with 47 views.

Splitting a single string in one column made by @Pranav_KomandurPK with 38 views.

Error : HTTP Request: Invalid URI: The Uri string is too long made by @Sweety_Girl with 34 views.

Top 3 Topics with Most Replies

Input String was not in correct format error made by @dutta.marina with 35 replies.

Splitting a single string in one column made by @Pranav_KomandurPK with 19 replies.

Error : HTTP Request: Invalid URI: The Uri string is too long made by @Sweety_Girl with 13 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 24 posts!

@dutta.marina made 21 posts!

@MarioHerrmann made 20 posts!

Top 3 Most Liked Posts

This post made by @NareshKumar_om received 2 likes!

Uipath.MicrosoftOffice365.Activites - Upload files

Hi @Nithinkrishna I have found where the problem was. even though i create a new Document library I need to create at least one folder inside the document library for it work. Sharepoint URL is -https://xxxxxxxxxxxxxx.sharepoint.com/sites/DocumentManagementSystem Drive Name - INVOICE2021 (Document Library) Folder name - 2021 then the file correctly uploading to folder 2021 [image]

This post made by @shinji received 2 likes!

Excelに罫線（横）を入れたい

InvokeCodeの引数はこんな感じで、 [image] コードはこんなイメージで。 [image] 参考までにxamlファイルです。 DrawBorder.xaml (12.2 KB) ※ 急いで作ったので、ゴミ変数が入ってました。不要部分は適当に消してくださいませ。

This post made by @shinji received 2 likes!

Excelに罫線（横）を入れたい

.NETで良いなら「InVokeCode」で自由に罫線が引けると思います。

Top 3 Most Liked Solutions

This solution provided by @NareshKumar_om received 2 likes!

Uipath.MicrosoftOffice365.Activites - Upload files

Hi @Nithinkrishna I have found where the problem was. even though i create a new Document library I need to create at least one folder inside the document library for it work. Sharepoint URL is -https://xxxxxxxxxxxxxx.sharepoint.com/sites/DocumentManagementSystem Drive Name - INVOICE2021 (Document Library) Folder name - 2021 then the file correctly uploading to folder 2021 [image]

This solution provided by @shinji received 2 likes!

Excelに罫線（横）を入れたい

InvokeCodeの引数はこんな感じで、 [image] コードはこんなイメージで。 [image] 参考までにxamlファイルです。 DrawBorder.xaml (12.2 KB) ※ 急いで作ったので、ゴミ変数が入ってました。不要部分は適当に消してくださいませ。

This solution provided by @LevKushnir received 2 likes!

Extracting the data from SAP

this is the right format [image]

---

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

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

[system]

Daily Forum Report | 15 July 2021

Top 3 Topics with Most Views

Excel Discrepancy-URGENT made by @mitul_choudhary with 106 views.

Terminal Window Maximize made by @supu123 with 79 views.

Issue with date format from csv to excel made by @Soudios with 54 views.

Top 3 Topics with Most Replies

Issue with date format from csv to excel made by @Soudios with 25 replies.

Excel Discrepancy-URGENT made by @mitul_choudhary with 21 replies.

データテーブルをフィルターアクティビティの不思議な現象について made by @111860 with 20 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 31 posts!

@kumar.varun2 made 25 posts!

@Nithinkrishna made 25 posts!

Top 3 Most Liked Posts

This post made by @dacostri received 3 likes!

Excel Automation-Urgent

I agree with this kind of response. Too many community members are simply asking questions without actually searching for an answer.

This post made by @Yoichi received 3 likes!

Grouping data and add comma

Hi, Hope the following helps you. [img20210715-5] dtResult = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("ID").ToString,r("Code").ToString,r("Usage").ToString,r("Plant Code").ToString,r("Header text").ToString)).Select(Function(g) dt.Clone.LoadDataRow({g.key.item1,g.Key.item2,g.Key.item3,g.Key.item4,g.Key.item5,String.Join(",",g.Select(Function(r) r("doc_number").ToString)) },False)).CopyToDataTable Regards,

This post made by @Ishmeet_Bindra received 2 likes!

UiPath Cloud Masters

Yes Surya, it will be explained!

Top 3 Most Liked Solutions

This solution provided by @StefanSchnell received 2 likes!

Sap easy access issue

Hello Jack, these are different themes, the upper is the Quartz theme and the lower is the SAP Signature theme. Here an example of the differences of the UI elements of the screen 100 of the report SAPLSMTR_NAVIGATION: SAPLSMTR_NAVIGATION_100.zip (1.5 KB) As you wrote, many buttons are missing from Signature to Quartz. This is not an overlay. Check it and configure it at the beginning of your automation workflow which theme to use. Here an example how to check the using SAP theme with an Invo…

This solution provided by @Nithinkrishna received 2 likes!

What us the purpose of 'reset transaction" in edit queue item?

@Elya @ermanoj3101 Reset transaction progress - Let’s say you are retrying a failed item and it comes as New right. But we may not need the old progress messages but just to start fresh. So resetting will be the option to go for. Thanks #nK

This solution provided by @ermanoj3101 received 1 likes!

Excel Automation-Urgent

Hi @mitul_choudhary , You can use below code. I have attached output of this code. test.xaml (10.1 KB) Test.xlsx (7.2 KB)

---

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

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

[system]

Daily Forum Report | 16 July 2021

Top 3 Topics with Most Views

Document Understanding Process - New Studio Template made by @Alexandru-Luca with 107 views.

Regex Extraction Text made by @Mohamed_Hassan1 with 39 views.

Please help. Cannot connect robot to Orchestrator made by @Tony101 with 33 views.

Top 3 Topics with Most Replies

Regex Extraction Text made by @Mohamed_Hassan1 with 22 replies.

Source Contains No Data Rows || Link Query made by @prerna.gupta with 12 replies.

Count folders and files by date modified made by @pmistry with 10 replies.

Top 3 Users Who Posted The Most

@Srini84 made 23 posts!

@sonaliaggarwal47 made 23 posts!

@Palaniyappan made 22 posts!

Top 3 Most Liked Posts

This post made by @Alexandru-Luca received 10 likes!

Document Understanding Process - New Studio Template

Hello everyone! We are very excited to announce the new studio template for Document Understanding. You can find the Document Understanding Process template on the Official template feed - make sure Include Prerelease is checked. To get started, simply create a new project in UiPath Studio and select it. [IncludePrerelease] [image] We recommend to carefully read the enclosed User Guide, even if you’re already familiar with the solution. The Guide can be…

This post made by @kmisko11 received 2 likes!

UiPath Cloud Masters

Great idea! Hope to gain a lot of knowledge from all the participants. It would be great if you could upload all the solutions somewhere, not only the winning ones

This post made by @Kristen received 2 likes!

Bulk Insert Uipath

I know this response is a bit delayed, but I had the same issues and I couldn’t find a good solution on these forums. I was able to get it working using the following: Add the ‘Invoke Code’ Activity Add the following Import: System.Data.SqlClient Add the following arguments: ConnectionString - In - String - "DB CONNECTION STRING" TargetTable - In - String - "TARGET TABLE NAME" DataToInsert - In - DataTable - DTVARIABLE Add the following code: Using SQLConnection As SqlConnection = New SqlC…

Top 3 Most Liked Solutions

This solution provided by @qbrandon received 2 likes!

Does 'Orchestrator HTTP request' activity use OAuth or does it need OAuth feature in future?

The Robot is already authenticated with Orchestrator (to send logs, etc…) The Orchestrator HTTP request is simply re-using this identity (Token) to leverage the Orchestrator API. Robot accounts are not relying on the external application OAuth implementation, but from a security perspective, this is basically equivalent. Of course, the authentication being already taken care of, it is much more convenient to use the Orchestrator HTTP request than not. Please do not worry about the Orchestrat…

This solution provided by @T0Bi received 2 likes!

How to check if any transaction item already exist in the queue

The easiest way is to enforce a unique transaction reference when setting up your queue [image] If this has helped you, please mark this answer as the solution.

This solution provided by @sai_krishna_somisetty received 1 likes!

Dynamic gmail body

[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 | 17 July 2021

Top 3 Topics with Most Views

How to extract PDF Bank statements to Excel made by @Aditya91 with 44 views.

How to calculate rows and add to in Total column made by @THIRU_NANI with 37 views.

What is alternative for delay activity? made by @ashwini.magar92 with 33 views.

Top 3 Topics with Most Replies

How to calculate rows and add to in Total column made by @THIRU_NANI with 19 replies.

How to get text before the amount from Regex? made by @ermanoj3101 with 12 replies.

Exception is not catched made by @Sus_Mi with 11 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 38 posts!

@Palaniyappan made 14 posts!

@THIRU_NANI made 10 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 2 likes!

What is Difference between Global Exception Handler and try-catch block?

Hi @ashwini.magar92, Exception handling in UiPath / RPA tools are a way to catch exceptions at source or the workflows invoking a source workflow. Think of an try catch exception in a project as a layer of an Onion. A project may contain many workflows and therefore many protection layers may be required. As you build your project, a workflow may fail and by using the catch sequence and exception message and exception can be forwarded to a parent workflow and you can keep doing this as many t…

This post made by @Rahul_Tomar1 received 1 likes!

Datatable column transformation

The data is coming from csv file. I tried you [image] [image] It is showing column A is not blong to datatable [image]

This post made by @sruthesanju received 1 likes!

How to find the value in excel

Yes it’s working…thanks

Top 3 Most Liked Solutions

This solution provided by @jeevith received 2 likes!

What is Difference between Global Exception Handler and try-catch block?

Hi @ashwini.magar92, Exception handling in UiPath / RPA tools are a way to catch exceptions at source or the workflows invoking a source workflow. Think of an try catch exception in a project as a layer of an Onion. A project may contain many workflows and therefore many protection layers may be required. As you build your project, a workflow may fail and by using the catch sequence and exception message and exception can be forwarded to a parent workflow and you can keep doing this as many t…

This solution provided by @prasath17 received 1 likes!

How to get text before the amount from Regex?

@ermanoj3101 - Please check this…Only Opening Balance is not correct. See if you can use string manipulation/regex to replace that value… https://regex101.com/r/aNzpnt/3/ I will also try…

---

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

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

[system]

Daily Forum Report | 18 July 2021

Top 3 Topics with Most Views

Read file by regex? made by @fairymemay with 42 views.

Save a file in count form made by @Guilherme_Silva with 36 views.

Data Loss- While writing data in Excel made by @Harshad_Jadhav with 35 views.

Top 3 Topics with Most Replies

Save a file in count form made by @Guilherme_Silva with 24 replies.

Drop-Down Field - Click made by @PaulMo with 14 replies.

Bot is not sending the mail made by @sneha_arbole with 11 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 34 posts!

@ermanoj3101 made 28 posts!

@hsendel made 13 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

Convert String()() to String() In Vb.Net

Hi, Can you try the following expression? arrStr = arrArrStr.SelectMany(Function(a) a).ToArray Note: arrStr is String[] type. arrArrStr is String[][] type. Regards,

This post made by @ppr received 3 likes!

Column Transpose with Condition on its Cells' Values

@hsendel we can do it dynamicly with the help of groupBy, dictionary and LINQ Variables: [grafik] Grouping the data by the the first two letters into a dictionary: [grafik] retrieving the max length for the longest group: [grafik] Preparing the result datatable columnstructure: [grafik] Build datatable with first column (ColName: Key), then we do add the other columns: [grafik] Finaly we use following LINQ for populating the target DataTable: [grafik] LINQ iterates over the Group…

This post made by @StefanSchnell received 2 likes!

A new UI Automation input method: the ChromiumAPI - highlights

@gheorghestan Sounds excellent Gheorghe.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

Convert String()() to String() In Vb.Net

Hi, Can you try the following expression? arrStr = arrArrStr.SelectMany(Function(a) a).ToArray Note: arrStr is String[] type. arrArrStr is String[][] type. Regards,

This solution provided by @ppr received 3 likes!

Column Transpose with Condition on its Cells' Values

@hsendel we can do it dynamicly with the help of groupBy, dictionary and LINQ Variables: [grafik] Grouping the data by the the first two letters into a dictionary: [grafik] retrieving the max length for the longest group: [grafik] Preparing the result datatable columnstructure: [grafik] Build datatable with first column (ColName: Key), then we do add the other columns: [grafik] Finaly we use following LINQ for populating the target DataTable: [grafik] LINQ iterates over the Group…

This solution provided by @Palaniyappan received 2 likes!

Log Message function

Hi @SH_94 Logging is important for three reasons Logs writes the specified diagnostic message at the specified level. Say for example you are using excel activities to read a excel file and you are keeping a log message activity right after the excel activities mentioning as “EXCEL FILE IS READ SUCCESSFULLY” now when bot is executed and if you want to validate whether excel file is read successfully or not, you can check the output panel or the execution log files whether the LOG MESSAGE AC…

---

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

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

[system]

Daily Forum Report | 19 July 2021

Top 3 Topics with Most Views

「チェック」「クリック」アクティビティについて made by @111561 with 35 views.

Check if today is twentieth working day made by @markosc with 35 views.

Split text from string? made by @fairymemay with 34 views.

Top 3 Topics with Most Replies

Need to open the last file in my Folder made by @Soudios with 25 replies.

Checkbox selectors made by @pari_patel with 18 replies.

Read range:Your Stream was neither an OLE2 stream, nor an OOXML Stream made by @Jayavignesh_G with 16 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 48 posts!

@Palaniyappan made 38 posts!

@prasath17 made 23 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 3 likes!

Need to open the last file in my Folder

Hi @Soudios, I would advice you do either draw a simple folder structure schematic OR even better Make a zip of your folder structure (without your required file name and type) This way @prasath17 can guide you easily. A side note : @prasath17 i wonder how many Regex expressions are hidden in that RegexPractice folder of yours!

This post made by @Palaniyappan received 2 likes!

How can I iterate through a dropdown in a desktop application eg. notepad script dropdown

Hi I believe some of the application won’t allow the select that drop down with SELECT ITEM activity due to uielement node attribute and it’s value or missing of SELECT TAG Is there any option to type in that field instead of scrolling and searching for a text So if you have the text to be searched and clicked we can rather type in that text using TYPE INTO activity which is another workaround Cheers @lertsak.n

This post made by @Nithinkrishna received 2 likes!

Excel Discrepancy-URGENT

Hey @ermanoj3101 Great help. @mitul_choudhary I was little away from forum, so not seen your post to help. Sorry for it #nK

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Need to open the last file in my Folder

@Soudios - Below will a array…and your assign statement is string… [image] please read the below again and add .first at the end…

This solution provided by @NIVED_NAMBIAR received 2 likes!

Type into question!

Hi @Dorothy_lee Best way is to Chr(34) to get " see this example i used as input in type into activity [image] Try this way Regards Nived N

This solution provided by @Yoichi received 2 likes!

「チェック」「クリック」アクティビティについて

こんにちは タイミングの問題であれば、対象要素の状態を確認する等の手もありますが、 より全体としての動作を確実にするためには、チェックあるいはクリック等の操作後 その操作が正しく行われたかのチェックを行うことです。 チェックボックスであればGet Attributeアクティビティを ボタンのクリックであれば、次に現れるであろう要素の有無確認 等を使います。 なおリトライスコープを使うとこのあたりの実装を省力化できると思います。 https://docs.uipath.com/activities/lang-ja/docs/retry-scope

---

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

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

[system]

Daily Forum Report | 20 July 2021

Top 3 Topics with Most Views

Link problem made by @sedayngl_sedayngl33 with 42 views.

How to access each item dynamicaaly in Datatable made by @debosree with 35 views.

Excel Reconciliation -URGENT made by @mitul_choudhary with 34 views.

Top 3 Topics with Most Replies

How to sort value in a Cell? made by @Rakesh_Yadav with 18 replies.

Link problem made by @sedayngl_sedayngl33 with 13 replies.

JOB STATE is FAULTED made by @liran.levin with 13 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 36 posts!

@Palaniyappan made 25 posts!

@ganesh4 made 23 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 3 likes!

Comment Out Clarification

Hi @SH_94, It will run the workflow if there are no errors in the first invoked workflow in your case the Try Catch_Updated_Chage. But I see there is an warning message in the Try Catch_Updated_Chage workflow. Since there is a warning sign the robot will not run. Normal Behaviour By default any commented out code will be ignored by UiPath. Only code which is uncommented and linked to the flowchart will be executed at run time.

This post made by @Vinay_Swarnkar received 2 likes!

Taking screen shot and saving to a cell corresponding to web search

hello guys , I would be thankful to you guys , if you can help in checking and suggesting me some steps to do the below task , Reading column A , Open browser - pasting value in search box and enter. (This is working fine) Now need to take screenshot of attachment there in last on the opened page , and save to corresponding column and this activity will loop in may be infinite times until the all column A items end. i have done the process , only problem is Invoke method (copying image…

This post made by @Palaniyappan received 2 likes!

Taking screen shot and saving to a cell corresponding to web search

Hi Use Insert Image at Cell activity under Balareva.Excel.Activities package to do this. Cheers @Vinay_Swarnkar

Top 3 Most Liked Solutions

This solution provided by @jeevith received 2 likes!

Comment Out Clarification

Hi, Not sure what the workflow has within it. You will have to open it and check what the workflow does yourself. If there is some complex logic you can post a screenshot of it in the forum. But by just looking at the workflow we can’t say what it does.

This solution provided by @Joe.Matuch received 2 likes!

Cannot sign into Orchestrator or Studio anymore

It looks like this issue is resolved. When I tried signing into Orchestrator today, I did not have a robot configured. I went to Tenant → Users → clicked on the 3 dots next to my name → Edit → Optional Robot Settings → Clicked to automatically configure an Attended Robot (which also resulted in creating a workspace) Then, when I went to open a .xaml file, Studio had me sign in and choose the version of Studio. Once the file had loaded, it showed that I was connected. I know I had tried this a…

This solution provided by @jeevith received 2 likes!

Delete Empty Excel in Folder

Hi @Yudhisteer_Chintaram1, So you get a NullReferenceException. Do mention what kind of error message you get in your question, it helps a lot to resolve an issue in the forum. All you have to do is to use try-catch activity and look for NullReferenceException type of error. If the error exists then delete file, if not read the content. Here is how you can achieve it. Offcourse, you have to adapt it to your scenario: [image] CheckForEmpySheet.xaml (8.0 KB)

---

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

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

[system]

Daily Forum Report | 21 July 2021

Top 3 Topics with Most Views

If value is not null made by @mitul_choudhary with 36 views.

Get Exact Date format in Excel made by @Vincent_Nuestro with 31 views.

How to extract the data using regex made by @copy_writes with 29 views.

Top 3 Topics with Most Replies

How to extract the data using regex made by @copy_writes with 31 replies.

If value is not null made by @mitul_choudhary with 20 replies.

How to call a HSQLDB stored procedure in Execute query activity? made by @Tamilarasanaccet with 17 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 47 posts!

@ermanoj3101 made 24 posts!

@ppr made 22 posts!

Top 3 Most Liked Posts

This post made by @AndyMenon received 3 likes!

Vote Data Service API - Part 3 | Entity Data Operations

Hello again Community! And here is Part 3 video on getting started with UiPath #dataservice #api on the #rpavanguard channel! [UiPath Data Service APIs - Part 3 | Basic Entity Data Operations] Picking up from where we left off in Part 2, this video will: Confirm that the Refresh token can be used to quickly get a new API Access token Demonstrate the basic Data operations using the Delete, Add and Update API endpoints Show how a token can be refreshed when it expires midway durin…

This post made by @Sathesh_Paramasivam received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, I am currently working as a RPA Developer in Berlin, Having profound experience in Data and Automation Field. Would love to discuss innovative ideas, bug fixes and see if i can be of any help to the community.

This post made by @Alexandru-Luca received 2 likes!

Document Understanding Process - New Studio Template

@carlacarnevali - processing 1 queue item at a time is precisely the intended behaviour; you need to create your own dispatcher mechanism. Please check out the documentation. @RPAForEveryone - Yes. You also need to disable Persistence. Please check out chapter Settings for Attended Processes in the User Guide. @ctutu We played around with various scenarios involving multiple DU queues - including the one you mentioned. We found that debugging/managing/scaling become a nightmare very quickly. S…

Top 3 Most Liked Solutions

This solution provided by @AdityaVN received 2 likes!

How to count the the numbers in the excel cell

Hi @copy_writes If you are holding these numbers (12345678 AND 1234567) in a variable lets say Digits_count Digits_count.ToString.Length will give the number of digits in the number and use IF condition to control the flow in the way it is required Hope this is helpful

This solution provided by @prasath17 received 2 likes!

Getting numbered files with For Each and how to get it in order instead of by the first character

Here you go… Directory.GetFiles("YourFolderName","*.pdf").OrderBy(Function(d) cint(path.GetFileNameWithoutExtension(d))).toarray

This solution provided by @AkshaySandhu received 1 likes!

If value is not null

issue is with your excel file… column B and column D is having negative numbers with the whole column formatted as date. which is overflow change your column type to General.

---

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.