Forum Engagement Daily Reports

[system]

Daily Forum Report | 15 July 2023

Top 3 Topics with Most Views

I can't click on the print dialog made by @Natan_Crespo with 48 views.

How to transfer value from one excel workbook to another excel workbook? made by @helpplease with 41 views.

Click activity not working in Selector Issues made by @marina.dutta with 39 views.

Top 3 Topics with Most Replies

How to transfer value from one excel workbook to another excel workbook? made by @helpplease with 30 replies.

I can't click on the print dialog made by @Natan_Crespo with 22 replies.

API - DeSerialize JSON -UiPath Studio made by @Salman_Faries with 19 replies.

Top 3 Users Who Posted The Most

@lrtetala made 32 posts!

@vrdabberu made 29 posts!

@raja.arslankhan made 17 posts!

Top 3 Most Liked Posts

This post made by @Ameeruddin_Syed received 2 likes!

I am just entering Details in sequence and I am confronting these erroes

Thank you forum members for giving replies with love. At first I’m afraid that I would be scolded alike in StackOverflow. I am delighted that this forum treats rookies with respect…

This post made by @mkankatala received 1 likes!

I can't click on the print dialog

Hi @Natan_Crespo For click activity that you are using to click on save button make the input mode to hardware events, you can find the input mode option in click activity properties. Why because when you click on print it will open a window which is the desktop application for the desktop applications we have to use the hardware events as input mode of any UI activity. Hope it helps!!

This post made by @ty4 received 1 likes!

Lesson2_DoubleUIについて(動画1:34)

@lrtetala Thank you for your kind attention! It’s done, and I appreciate it! [image]

Top 3 Most Liked Solutions

This solution provided by @vrdabberu received 1 likes!

How to open Outlook

Hi @siddhi Use the start process activity and pass the path as mentioned and it will open the outlook automatically [image] Regards

This solution provided by @lrtetala received 1 likes!

API - DeSerialize JSON -UiPath Studio

@Salman_Faries Newtonsoft.Json.Linq.Jobject [image]

This solution provided by @EarlA received 1 likes!

No Row At Position 0

My suspicion that UiPath was attempting to create the variable at the beginning of the sequence before the table has been created was correct. I added an If activity to the sequence which I used to work with the first and second cells in the table and it worked properly. Just part of learning the ropes. I have managed to complete my first fully functional script. @raja.arslankhan and @postwick, thank you for your assistance.

---

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 2023

Top 3 Topics with Most Views

UI questions made by @Latifa with 42 views.

Acme-test.uipath.com is not responding made by @Diana_Dinh-Andrus with 37 views.

Process Next Transaction Item In Case Of Business Rule Exception made by @marina.dutta with 35 views.

Top 3 Topics with Most Replies

Cannot communicate with browser u made by @Yazan_Otaibi with 27 replies.

Process Next Transaction Item In Case Of Business Rule Exception made by @marina.dutta with 22 replies.

Acme-test.uipath.com is not responding made by @Diana_Dinh-Andrus with 14 replies.

Top 3 Users Who Posted The Most

@lrtetala made 37 posts!

@Anil_G made 27 posts!

@mkankatala made 23 posts!

Top 3 Most Liked Posts

This post made by @170290064 received 2 likes!

How to change Queue reference?

[image] Done [image] I’m still at the basic level. Thanks for answers. I appreciate you all. @lrtetala @Anil_G @supermanPunch @vrdabberu @Parvathy

This post made by @lrtetala received 1 likes!

Extraction of table data from pdf

@Amit_Kumar_Charde Can you provide sample pdf how it looks then we will understand how to do. Try with Document Understanding

This post made by @Anil_G received 1 likes!

Performer n Dispatcher

@Latifa Think like this whatever needs to happen till adding queue items generally happen in the fispatcher part…So thinking on these lines decide your answer…As you wanted help only in thinking I am not giving you the answer. Hope this helps Cheers

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 1 likes!

Performer n Dispatcher

Hi @Latifa The answer would be Option A It will retrieve the mails from Outlook account and extract the rental reservation data from current mail and add it to queue, Regards

This solution provided by @lrtetala received 1 likes!

Issue with preview on HTTP Request Activity

@Salman_Faries 1.Once upgrade the package then try 2.Ensure that you are using the latest version of UiPath Studio and any relevant packages related to HTTP activities. Updating to the latest version may resolve any known issues or bugs. 3.Check the internet connection: Ensure that your computer has a stable internet connection. Test accessing other websites or resources to confirm that your internet connection is working properly. I hope it helps!!

---

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 2023

Top 3 Topics with Most Views

Replying to problem made by @dolx with 55 views.

Bot failing in RDP session made by @logesh_kumar1 with 55 views.

Convert Datetime to Date made by @ManjunathReddy with 52 views.

Top 3 Topics with Most Replies

Replying to problem made by @dolx with 41 replies.

Transaction item failed? made by @170290064 with 36 replies.

How to move/copy latest downloaded excel files? made by @Muhamad_Izwan_Bin_Hamran with 27 replies.

Top 3 Users Who Posted The Most

@Anil_G made 140 posts!

@mkankatala made 68 posts!

@vrdabberu made 51 posts!

Top 3 Most Liked Posts

This post made by @marian.platonov received 2 likes!

What are the usecase of Orchastrotor on premisse

Both are the same product. The difference is on-prem Orchestrator needs to be deployed on your own server which you will need to configure and prepare from scratch. Cloud one is already deployed and you just need to set it up for your company and allow the traffic to go through it so robots can work like they should. More details can be found here: https://docs.uipath.com/overview/other/latest/overview/orchestrator-differences On-Premise and Cloud Orchestrators both have their own advantages …

This post made by @Povilas_Jonikas received 2 likes!

Http request Wizard parameters with the same name

Both @Anil_G and @lrtetala were crucial with their knowlage towards my problem. Both of u guys are legends. Thanks!

This post made by @pere received 1 likes!

How to Identify whether Windows application already running or not

Hi, I’d wish to know what’s that “element exist activity” you’re talking about, as I can’t find any activity with that name. Thanks

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Http request Wizard parameters with the same name

Hi @Povilas_Jonikas To construct the URL-encoded query string, you can use the String.Format method or string concatenation to build the body as a string. Here’s an example: "username=signeda" + "&password=" + Uri.EscapeDataString("aaaaaaaaaaa") + "&user_token=" + Uri.EscapeDataString("aaaaaaaaaaaaaaaa") + "&car_id=" + Uri.EscapeDataString(CurrentRow.Item("car_id").ToString) + "&category_id=" + Uri.EscapeDataString(CurrentRow.Item("category_id").ToString) + "&quality=" + Uri.EscapeDataString(C…

This solution provided by @Irene received 1 likes!

Extracting and Saving Multiple IDs from a Single Cell in UiPath

Hi, if you’re expecting a fixed number of variables, then you can just keep it simple and use a multi-assign statement instead, in which you can set the variables as: ID1 = arrValue (0) ID2 = arrValue (1) ID3 = arrValue (2) I don’t see the benefit of using a loop if ultimately you always have a fixed amount of values. The loop makes sense if you want to make your procedure more dynamic (for example, if the number of values changes, or if you want to apply the same exact behavior in the b…

This solution provided by @mkankatala received 1 likes!

Variable or argument is not defined in the current scope- while making selector dynamic

@Sami_Rajput bro delete that activity and place the activity, then indicate the element and pass the variable in the attributes in selector options window. Make sure to check the override default value option when pass variable to selector. It’s working when doing this, already tried this it worked

---

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 2023

Top 3 Topics with Most Views

Excel Filter Question! made by @170290064 with 54 views.

I want to loop through and log message check or uncheck made by @Bhushan_Nagaonkar with 53 views.

Questions about UiPath Pro made by @aquinn with 53 views.

Top 3 Topics with Most Replies

I want to loop through and log message check or uncheck made by @Bhushan_Nagaonkar with 39 replies.

Excel Filter Question! made by @170290064 with 37 replies.

How to work with Remote debugging made by @divya.17290 with 20 replies.

Top 3 Users Who Posted The Most

@Anil_G made 65 posts!

@mkankatala made 53 posts!

@Vikas_M made 51 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Data Group and Filter Problem

Hi, How about the following sample? [image] Sample20230718-1aL.zip (21.0 KB) Regards,

This post made by @Anil_G received 1 likes!

Get Attribute: Attribute not supported by the current UiNode in dropdown select (Help)

@gustavo.souza What is the selector ? and what are you trying to get? if it is the select item value…then may be in your selector you are using some aaname or innertext which changes for each select cheers

This post made by @Quenton_Wayne_Rebello received 1 likes!

Comparing values and adding data to one data table

yes it will give both matched and unmatched as per the sheet given

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to convert String to dictionary

HI, How about the following? [image] dict = System.Text.RegularExpressions.Regex.Matches(yourString,"(?<={"")([^{}]*?)"",""([^{}]*?)(?=""})").Cast(Of System.Text.RegularExpressions.Match).ToDictionary(Function(m) m.Groups(1).Value,Function(m) m.Groups(2).Value) Sample20230817-4L.zip (2.6 KB) Regards,

This solution provided by @raja.arslankhan received 1 likes!

Parsing question

@A_Learner Try Through Regex: [image]

This solution provided by @Anil_G received 1 likes!
https://forum.uipath.com/t/564088/4

---

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 2023

Top 3 Topics with Most Views

Anyone knows why I am experiencing this? made by @attkren1 with 61 views.

LINQ query error made by @yash.choursia with 53 views.

Find largest prime number in a given set of numbers . Can anyone help me please how to do made by @sandhyareddy with 46 views.

Top 3 Topics with Most Replies

How to solve this error issue? made by @attkren1 with 28 replies.

Loop through all excel workbook sheets and write data in to each subfolders sheet by sheet made by @POOJA_MARUTI_BALIGIDE with 25 replies.

I am getting this error, please help me , how to made by @munichandra_kuppani with 23 replies.

Top 3 Users Who Posted The Most

@supriya117 made 76 posts!

@mkankatala made 63 posts!

@lrtetala made 55 posts!

Top 3 Most Liked Posts

This post made by @Quenton_Wayne_Rebello received 3 likes!

Excel Filter Question!

To get the data in the format mentioned you can use the linq, (From row In dtInput.AsEnumerable() Group row By ModelPrefix = If(row(“Model”).ToString().Length >= 4, row(“Model”).ToString().Substring(0, 4), row(“Model”).ToString()) Into Group Let GroupedYıl = String.Join(“,”, Group.Select(Function(r) r(“Yıl”).ToString())) Let GroupedKM = String.Join(“,”, Group.Select(Function(r) r(“KM”).ToString())) Let GroupedFiyat = String.Join(“,”, Group.Select(Function(r) r(“Fiyat”).ToString())) Select …

This post made by @supermanPunch received 2 likes!

Regex everything between 9 digit numbers

Hi @JenJen , Could you check with the below Regex Expression : (?<=\d{9})[\s\S]+?(?=\d{9}|Page) [image] Here, An assumption is also made that the Page keyword will always be present after the last address data. Let us know if it is not the case, we can identify a separate limiter.

This post made by @supriya117 received 2 likes!

Copy the data from body of the browser outlook & save it in a variable

@Somanath_Somu Use the “Send Hotkey” activity to simulate pressing Ctrl+A (select all) Use the “Send Hotkey” activity again to simulate pressing Ctrl+C (copy) Use the “Get from Clipboard” activity to retrieve the copied text from the clipboard and store it in a variable.

Top 3 Most Liked Solutions

This solution provided by @Quenton_Wayne_Rebello received 3 likes!

Excel Filter Question!

To get the data in the format mentioned you can use the linq, (From row In dtInput.AsEnumerable() Group row By ModelPrefix = If(row(“Model”).ToString().Length >= 4, row(“Model”).ToString().Substring(0, 4), row(“Model”).ToString()) Into Group Let GroupedYıl = String.Join(“,”, Group.Select(Function(r) r(“Yıl”).ToString())) Let GroupedKM = String.Join(“,”, Group.Select(Function(r) r(“KM”).ToString())) Let GroupedFiyat = String.Join(“,”, Group.Select(Function(r) r(“Fiyat”).ToString())) Select …

This solution provided by @supermanPunch received 2 likes!

Regex everything between 9 digit numbers

Hi @JenJen , Could you check with the below Regex Expression : (?<=\d{9})[\s\S]+?(?=\d{9}|Page) [image] Here, An assumption is also made that the Page keyword will always be present after the last address data. Let us know if it is not the case, we can identify a separate limiter.

This solution provided by @supriya117 received 2 likes!

Copy the data from body of the browser outlook & save it in a variable

@Somanath_Somu Use the “Send Hotkey” activity to simulate pressing Ctrl+A (select all) Use the “Send Hotkey” activity again to simulate pressing Ctrl+C (copy) Use the “Get from Clipboard” activity to retrieve the copied text from the clipboard and store it in a variable.

---

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 2023

Top 3 Topics with Most Views

Unable to Trigger made by @sathya_auto with 43 views.

Add Data Column Error like in the following made by @170290064 with 42 views.

バッググラウンド実行でのChromeの印刷について made by @y.c with 42 views.

Top 3 Topics with Most Replies

I am trying to copy CSV file into excel file? How can I do? made by @Samraat_Maharjan1 with 49 replies.

Rename File: Could not find a part of the path made by @gustavo.souza with 30 replies.

Clicking next on Dynamic selector and extract data for each "Name" made by @Irfan_Musa with 21 replies.

Top 3 Users Who Posted The Most

@mkankatala made 60 posts!

@lrtetala made 55 posts!

@postwick made 53 posts!

Top 3 Most Liked Posts

This post made by @B_H_Akshatha_Pai received 2 likes!

Clicking next on Dynamic selector and extract data for each "Name"

@Irfan_Musa try deleting the content of aaname in the selector , also keep the text as “ignore text”

This post made by @B_H_Akshatha_Pai received 2 likes!

Scope of Read Range Excel Activity

Hey there ! Just change the scope of the variable in the variable pannel such that it is available in the entire scope [Screenshot (10)] Keep the scope to the lower most process Regards,

This post made by @mkankatala received 2 likes!

Type into: Indicate in Excel failed, cannot attach to document

Hi @jan.alemany Use the two read range workbook activity to read the two sheets in the excel. In first read range workbook give the sheet name of first sheet name, store it to dt1 and in second read range workbook give the sheet name of second sheet, store it to dt2. Use for each row in datatable activity to iterate the dt1 inside this activity use another for each row in datatable activity to iterate the dt2. Inside second for each take If activity in that activity write the condition which…

Top 3 Most Liked Solutions

This solution provided by @B_H_Akshatha_Pai received 2 likes!

Scope of Read Range Excel Activity

Hey there ! Just change the scope of the variable in the variable pannel such that it is available in the entire scope [Screenshot (10)] Keep the scope to the lower most process Regards,

This solution provided by @mkankatala received 2 likes!

Type into: Indicate in Excel failed, cannot attach to document

Hi @jan.alemany Use the two read range workbook activity to read the two sheets in the excel. In first read range workbook give the sheet name of first sheet name, store it to dt1 and in second read range workbook give the sheet name of second sheet, store it to dt2. Use for each row in datatable activity to iterate the dt1 inside this activity use another for each row in datatable activity to iterate the dt2. Inside second for each take If activity in that activity write the condition which…

This solution provided by @vrdabberu received 1 likes!

Regex Date help

@A_Learner You can use the below regex if you want to avoid the open date ([A-Z]+[a-z]+\s?\d+\,?\s+\d+)|(\d{2}\/\d+\/\d+) [image] Regards

---

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

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

[system]

Daily Forum Report | 21 July 2023

Top 3 Topics with Most Views

Assistantでロボットインストールエラーについて made by @kimjinseong with 51 views.

If activity Suggestion made by @yeshwanth with 50 views.

Deleting rows of a datatable using starting index and ending index made by @yash.choursia with 46 views.

Top 3 Topics with Most Replies

If activity Suggestion made by @yeshwanth with 27 replies.

How to find max and min price in the table with linQ method? made by @170290064 with 22 replies.

Excel appears to be busy - but I have kill actvity before made by @anon40731888 with 20 replies.

Top 3 Users Who Posted The Most

@lrtetala made 50 posts!

@Anil_G made 41 posts!

@supriya117 made 36 posts!

Top 3 Most Liked Posts

This post made by @lrtetala received 2 likes!

Deleting rows of a datatable using starting index and ending index

Hi @yash.choursia Use Remove Data Row activity to remove rows [image] If you want to delete the columns use Remove Data Column activity [image] or use [image] I hope it helps!!

This post made by @Yoichi received 2 likes!

Gmail のメールのリストを取得アクティビテイ

こんにちは 一番手っ取り早い方法は、当該プロパティを選択して編集状態にして Ctrl+Kとして変数名を入力すると、自動的にその型の変数が生成されます。 あるいは変数パネルでBrowseForTypeを選択し、まずはList<と入力し、表示されるプルダウンから再度BrowseForTypeを選択してから、GmailMEssageを選択してください。 [image]

This post made by @nicklys received 1 likes!

UiPath Community HyperHack 2023 is LIVE! Register Now!

Thank you very much, it has been approved. Please have a nice day.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Gmail のメールのリストを取得アクティビテイ

こんにちは 一番手っ取り早い方法は、当該プロパティを選択して編集状態にして Ctrl+Kとして変数名を入力すると、自動的にその型の変数が生成されます。 あるいは変数パネルでBrowseForTypeを選択し、まずはList<と入力し、表示されるプルダウンから再度BrowseForTypeを選択してから、GmailMEssageを選択してください。 [image]

This solution provided by @B_H_Akshatha_Pai received 1 likes!
https://forum.uipath.com/t/565279/3

This solution provided by @supriya117 received 1 likes!

How to pick each one value from an array

@Sudheer_Kumar_S If it’s an array try like this: res = MyArray.Last If it’s string: res = MyStr.Split(" ").Reverse()(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 | 22 July 2023

Top 3 Topics with Most Views

Send Status Email made by @marina.dutta with 45 views.

Date changed after I transpose table made by @helpplease with 42 views.

How do I add headers to all my excel sheets made by @Conning with 35 views.

Top 3 Topics with Most Replies

Send Status Email made by @marina.dutta with 21 replies.

UiElement cannot be converted to 'String' Error made by @170290064 with 17 replies.

I cannot print some data while printing data made by @tolgademir with 15 replies.

Top 3 Users Who Posted The Most

@lrtetala made 16 posts!

@Vikas_M made 15 posts!

@Anil_G made 15 posts!

Top 3 Most Liked Posts

This post made by @helpplease received 1 likes!

Date changed after I transpose table

ok, thank you for the explanation.

This post made by @tolgademir received 1 likes!

I cannot print some data while printing data

I want to make a correction. When I formatted the cells in my Excel table as strings, the problem was solved without the need for other methods. Previous data format was general format [Adsız]

This post made by @fernando_zuluaga received 1 likes!

For Each Excel Row I get error

Hi @Favarelaa For Each Excel row will loop through your excel rows For Each Row in Data Table will loop through yout datatable items based on that to loop with excel you should use this expression [image] Excel.Sheet("Sheet").Range("") Regards!

Top 3 Most Liked Solutions

This solution provided by @fernando_zuluaga received 1 likes!

For Each Excel Row I get error

Hi @Favarelaa For Each Excel row will loop through your excel rows For Each Row in Data Table will loop through yout datatable items based on that to loop with excel you should use this expression [image] Excel.Sheet("Sheet").Range("") Regards!

This solution provided by @Yoichi received 1 likes!

スプレッドシートの範囲を読み込み

こんにちは 「範囲」の指定が正しいか確認できますでしょうか？ プルダウンから選択しましたか？あるいは詳細エディタで入力していますか？後者の場合特に注意が必要かと思います。

---

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

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

[system]

Daily Forum Report | 23 July 2023

Top 3 Topics with Most Views

ElementExists timed out made by @rpn_mail with 43 views.

How to fasten vlookup made by @Nur_Amin with 42 views.

Cant find the Inject JS Script Activity made by @Hugen_Dugen with 42 views.

Top 3 Topics with Most Replies

Practice - Book Sales Report made by @kimberly.lin with 27 replies.

How to fasten vlookup made by @Nur_Amin with 25 replies.

Cant find the Inject JS Script Activity made by @Hugen_Dugen with 16 replies.

Top 3 Users Who Posted The Most

@lrtetala made 26 posts!

@Anil_G made 26 posts!

@Parvathy made 11 posts!

Top 3 Most Liked Posts

This post made by @lrtetala received 1 likes!

Windows Exploeer: Get file path, file name and creation date from folder and all subfolders into an Excelfie

@hagen [image] [image] [image] Is it okay

This post made by @vrdabberu received 1 likes!

Can someone explain how to do lookup from one excel to another excel

@madhav_ravi Please refer the below attached xaml file it might help you. sample.xaml (67.3 KB) test (2).xlsx (10.4 KB) Hope it works!!

This post made by @Vikas_M received 1 likes!

Add Headers of Data Table in HTML Editor Send Email Activity (Adding DataTable in Email Body)

@marina.dutta While writing the data table to Excel u have to check the add headers property And while reading it from excel uncheck add headers, and check the Preserve Format Property And then pass that DT variable to HTML content , You will get headers in your output [image] [image] bELOW IS THE OUTPUT [image] Note: Dont forget to Map the New DT in your HTML content Happy Automation!

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Windows Exploeer: Get file path, file name and creation date from folder and all subfolders into an Excelfie

@hagen [image] [image] [image] Is it okay

This solution provided by @vrdabberu received 1 likes!

Can someone explain how to do lookup from one excel to another excel

@madhav_ravi Please refer the below attached xaml file it might help you. sample.xaml (67.3 KB) test (2).xlsx (10.4 KB) Hope it works!!

---

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

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

[system]

Daily Forum Report | 24 July 2023

Top 3 Topics with Most Views

Edge Extension not working - Could not communicate made by @Daniel_H-E with 251 views.

The robots couldn't communicate with Private mode of MS Edge browser made by @Mohammed_Bakr with 98 views.

🎯 UiPath Tutorial: Using the Pick Activity made by @ManFrancko with 53 views.

Top 3 Topics with Most Replies

3 Excel Reading made by @Gokul_Murali with 43 replies.

Unable to read unread mail made by @Mathkar_kunal with 25 replies.

Write Cell: Object reference not set to an instance of an object. Error made by @HENG_JUN_YING_AARON with 23 replies.

Top 3 Users Who Posted The Most

@mkankatala made 68 posts!

@Anil_G made 57 posts!

@lrtetala made 52 posts!

Top 3 Most Liked Posts

This post made by @Vikas_M received 3 likes!

Managing Data Table columns

Hey @Luis_Fernando , If you want to add only specified columns to Orchestrator then follow below steps Input datatable snapshot [image] Filtered Datatable snapshot (I removed AGE and SALARY columns) [image] Below is the Output of Filter Datatable [image] After filtering you can add the filtered Datatable to "Bulk Add Queue Items " Below is the Workflow Snapshot [image] Hope it helps You! Happy Automation!

This post made by @Mohammed_Bakr received 2 likes!

The robots couldn't communicate with Private mode of MS Edge browser

Hi after the last update of MS Edge, there is an issue with the extension of UiPath… the extension is installed and enabled but still, the robot is not able to communicate with the browser in Private mode… I tried to: disable and enable the extension. reinstall the extensions uninstall and reinstall the studio but unfortunately same issue … after a lot of investigation, I found that when the robot is opening Edge in normal mode there is an application called (Chrome Native Messaging Hos…

This post made by @Quenton_Wayne_Rebello received 2 likes!

FIlling excel using LINQ

Dim previousColumn7 As String = "" Dim previousColumn9 As String = "" For Each row As DataRow In dataTable.Rows Dim column7Value As String = If(String.IsNullOrEmpty(row("Column7").ToString()), previousColumn7, row("Column7").ToString()) Dim column9Value As String = If(String.IsNullOrEmpty(row("Column9").ToString()), previousColumn9, row("Column9").ToString()) row("Column7") = column7Value row("Column9") = column9Value previousColumn7 = column7Value previousColumn9 = col…

Top 3 Most Liked Solutions

This solution provided by @Quenton_Wayne_Rebello received 2 likes!

FIlling excel using LINQ

Dim previousColumn7 As String = "" Dim previousColumn9 As String = "" For Each row As DataRow In dataTable.Rows Dim column7Value As String = If(String.IsNullOrEmpty(row("Column7").ToString()), previousColumn7, row("Column7").ToString()) Dim column9Value As String = If(String.IsNullOrEmpty(row("Column9").ToString()), previousColumn9, row("Column9").ToString()) row("Column7") = column7Value row("Column9") = column9Value previousColumn7 = column7Value previousColumn9 = col…

This solution provided by @pravallikapaluri received 1 likes!

Activities in version 2023

Hi @Pratik_Chaudhari1 Install the UiPath.excel.Activities [image] Hope it helps!!

This solution provided by @Yoichi received 1 likes!

Regex match question

Hi, According to your pattern, you want to match not only MM/dd/yyyy style but also MMMM/dd/yyyy style (such as July 25,2023) don’t you? If so, the following pattern will work. System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Statement\s+(Issued\s+)?)(Jan(uary)?|Feb(ruary)?|Mar(ch)?|Apr(il)?|May|Jun(e)?|Jul(y)?|Aug(ust)?|Sep(tember)?|Oct(ober)?|Nov(ember)?|Dec(ember)?)\s?\d+,?\d+|(\d{1,2}/\d{1,2}/\d{2,4}|\d{1,2}-(Jan(uary)?|Feb(ruary)?|Mar(ch)?|Apr(il)?|May|Jun(e)?|Jul(y)?|Aug(ust)?…

---

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

Top 3 Topics with Most Views

MV3 browser extensions are broken when starting Edge v115 with InPrivate option made by @Luiza_Surdu-Bob with 131 views.

Edge extension not working in Incognito mode made by @Oana_Georgiana_Vasile with 66 views.

Error when Open Browser in private : Cannot communicate with the browser, please check the UiPath extension made by @marc.loppion with 50 views.

Top 3 Topics with Most Replies

Excel Extension made by @Kuldeep_Pandey with 27 replies.

Delete Sheet Item made by @Shivam_Rana with 25 replies.

How to store the extracted tables data in an excel sheet made by @raju_alakuntla with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 62 posts!

@lrtetala made 50 posts!

@mkankatala made 45 posts!

Top 3 Most Liked Posts

This post made by @Luiza_Surdu-Bob received 3 likes!

MV3 browser extensions are broken when starting Edge v115 with InPrivate option

The latest Microsoft Edge browser update to version 115.0.1901.183 introduced a bug regarding the initialization of MV3 extensions for Edge started “InPrivate” mode. This issue affects all MV3 extensions, not just the UiPath Extension for Microsoft Edge. We have reported this issue to Microsoft as an Edge bug and are waiting for their review. Observed behavior When Microsoft Edge browser is started using: the Open Browser activity with Options → Private property set to True or the Use Appl…

This post made by @RAKESH_KUMAR_BEHERA received 2 likes!

Developing a Star Rating Design using UiPath Apps

[Developing a Star Rating Design using UiPath Apps]

This post made by @Manish540 received 2 likes!

How to use Success Factor Activities

Hi @Deeipauk , Check this below link, https://docs.uipath.com/activities/other/latest/legacy-integrations/successfactors-scope Hope this might help you

Top 3 Most Liked Solutions

This solution provided by @MohammedKher_Kibabi received 1 likes!

Can't open UiPath Orchestrator - it's hanging and entering into redirect loop

Welcome @Filipe_Vitorino1 I resolved this issue by synchronize the PC Time from the control panel → time zone settings

This solution provided by @lrtetala received 1 likes!

Linq for joining 2 columns

Hi @yashchoursia25 Please try this (From d In InputFile.AsEnumerable() Group d By k1 = d(6).ToString().Trim(), k2 = d(8).ToString().Trim() Into grp = Group Let s13 = String.Join(",", grp.Select(Function(x) x(13).ToString())) Let s12 = String.Join(",", grp.Select(Function(x) x(12).ToString())) Let ra = New Object() {k1, k2, s12, s13} Select joiningDT.Rows.Add(ra)).CopyToDataTable() Regards,

This solution provided by @vrdabberu received 1 likes!

Checking Excel calculation is complete before extracting data

@clark.coleman Use the “Excel Application Scope” activity to open the Excel file and perform operations on it. After pressing F9 (manually or programmatically), use the “Send Hotkey” activity to send the F9 key to Excel. This will trigger the recalculation of the spreadsheet. Use the “Delay” activity to introduce a wait time after sending the F9 key. The duration of the delay depends on the complexity of your spreadsheet and the time it takes to finish calculating. You may need to experiment …

---

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

Top 3 Topics with Most Views

Important updates in Orchestrator roles and permissions made by @sebastian.ungureanu with 415 views.

How to get the date from a specific day till today? made by @connect360 with 49 views.

Comparing Excel Row Values made by @marina.dutta with 42 views.

Top 3 Topics with Most Replies

Group by column and add other columns accordingly made by @tharaninatarajan1901 with 38 replies.

How to get the date from a specific day till today? made by @connect360 with 27 replies.

Need only classic activities made by @T_Y_Raju with 26 replies.

Top 3 Users Who Posted The Most

@mkankatala made 55 posts!

@Anil_G made 51 posts!

@lrtetala made 49 posts!

Top 3 Most Liked Posts

This post made by @sebastian.ungureanu received 6 likes!

Important updates in Orchestrator roles and permissions

Hello, UiPath community! We’ve been collecting your feedback around setting up roles and permissions in Orchestrator, and are pleased to announce a few upcoming improvements in the initial setup experience, as well as some important changes to the Automation User role. When creating a new tenant, you will notice a better separation of group roles by default. The changes to the default seeding are as follows: Updated group: Automation Users will no longer be able to access the Orchestrator UI…

This post made by @rameshrangaraj1970 received 2 likes!

How do I simulate the keystrokes of keeping the "SHIFT" button pressed and simultaneously pressing "TAB"?

Thanks much All for your very quick reply. My problem got solved. Thanks once again!

This post made by @Yoichi received 2 likes!

How to get 2 words in both sides of some word

How about the following? System.Text.RegularExpressions.Regex.Replace(yourString,"^[\s\S]*\s+(\w+)\W+овогтой\W+(\w+)[\s\S]*$","$1 $2") Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to get 2 words in both sides of some word

How about the following? System.Text.RegularExpressions.Regex.Replace(yourString,"^[\s\S]*\s+(\w+)\W+овогтой\W+(\w+)[\s\S]*$","$1 $2") Regards,

This solution provided by @Yoichi received 2 likes!

Get text gives me thousand separator with coma and I need it with dot

HI, How about using Replace method as the following? PR.Replace(",","_").Replace(".",",").Replace("_",".") This assumes there is no _ in the string. Regards,

This solution provided by @ppr received 1 likes!

In a list of string identify those with 3 out of 4 characters similar to each other

maybe this Quick dirty approach can help: uncommon [grafik] common [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 | 27 July 2023

Top 3 Topics with Most Views

How do I count the number of rows with same variable? made by @helpplease with 58 views.

Column not found made by @helpplease with 53 views.

Different date format made by @helpplease with 53 views.

Top 3 Topics with Most Replies

Compare two sheets and change color in both or any one of sheets made by @Bhushan_Nagaonkar with 30 replies.

How to insert images into excel cells made by @alexis.mendoza with 30 replies.

Need to find index of array value in text file made by @Anil_Rajavarapu with 29 replies.

Top 3 Users Who Posted The Most

@mkankatala made 67 posts!

@lrtetala made 58 posts!

@vrdabberu made 50 posts!

Top 3 Most Liked Posts

This post made by @helpplease received 3 likes!

What exactly are special keys?

Thank you all for the explanations! I really appreciate them

This post made by @brian.oberman received 2 likes!

Change Scheduled Delivery of Reports to be globally and centrally set up and managed

Today, you can schedule delivery of reports via email in Insights. However, ONLY the person/user that set up the schedule and see/change their own schedules. This is a problem. First, if the person that set up the report delivery leaves your organization, you cannot change/update/view the report without UiPath assistance. (Per UiPath documentation: " Schedules are user-specific and can only be viewed by the user that created them in the Schedule/Alert Settings section." Second, it creates th…

This post made by @Felix_Rech1 received 2 likes!

Add Collection argument to 'Add Log fields' Activity

Hey UiPath Team, please consider adding a new input argument to the ‘Add Log Fields’ activity that allows users to hand in a collection Object (dictionary) as an alternative to adding the fields manually one by one, similar to how the ‘Add Queue Item’ activity allows users to supply a variable/argument of type ‘Dictionary(String,Object)’ instead of adding the required fields manually (ItemInformation vs. ItemInformationCollection). This is currently not possible with the ‘Add log Fields’ activ…

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

How to saperate json

@Mathkar_kunal , Apologies as I could not get the separate term intially in your Query. The concentration was more towards the last line of the query. Even for the Expected Results provided by you, we could use the Same Expression : To retrieve results other than 1322 : jArr1 = JArray.FromObject(jArr.Where(Function(x)Not x("testExecKey").toString.Equals("TEST81313-1322"))) To retrieve results with 1322 : jArr2 = JArray.FromObject(jArr.Where(Function(x)x("testExecKey").toString.Equals("TES…

This solution provided by @pravallikapaluri received 1 likes!

Read every PDF files with OCR

Hi @Temuulen_Buyangerel [image] [image] Hope it helps!!

This solution provided by @lrtetala received 1 likes!

Round off to a decimal number

Hi @adishjain Math.Ceiling(Var1 * Math.Pow(10, Round)) / Math.Pow(10, Round) [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 | 28 July 2023

Top 3 Topics with Most Views

I tried to open chrome browser but I can't open made by @Krishnendu_Paul with 53 views.

What are the RPA Tools that are getting rapid popularity Recently made by @hikumar with 52 views.

Date and time formate chnaging after reading json and appending to new text file made by @Mathkar_kunal with 50 views.

Top 3 Topics with Most Replies

How to convert to number in excel? made by @Priyesh_Shetty1 with 31 replies.

Excel “printer setup” popup made by @wija with 26 replies.

Date and time formate chnaging after reading json and appending to new text file made by @Mathkar_kunal with 24 replies.

Top 3 Users Who Posted The Most

@mkankatala made 67 posts!

@lrtetala made 60 posts!

@pravallikapaluri made 33 posts!

Top 3 Most Liked Posts

This post made by @hikumar received 6 likes!

What are the RPA Tools that are getting rapid popularity Recently

Give me a list of RPA Tools that are getting rapid popularity recently, that do the robotic process automation work similar to RPA UiPath

This post made by @AndyMenon received 3 likes!

How to Filter Data in Dropdown Lists - UiPath Apps Tutorial Part 01

Hello Community, If you want to know how to build UiPath Apps that lets users filter data in multi-select dropdown lists, then you may find this video interesting. In this session we use a series of multi-select dropdown lists. Setting the filter criteria in the first dropdown results in data being filtered in the second! You will experience how minimal configuration and a bit of practice with UiPath Apps Functions and Expressions can help build powerful features into your Apps! NOTE: If y…

This post made by @Quenton_Wayne_Rebello received 2 likes!

How to add only a particular column using LINQ

(From row in dt.AsEnumerable Select dt.Clone.Rows.Add({row(“ColumnName”)})).CopyToDataTable Then use invoke code and remove unnecessary column names where target object is dt2.Columns and method is RemoveAt [tmp_149e8431-3648-4194-a50b-cfd72af2e226]

Top 3 Most Liked Solutions

This solution provided by @Quenton_Wayne_Rebello received 2 likes!

How to add only a particular column using LINQ

(From row in dt.AsEnumerable Select dt.Clone.Rows.Add({row(“ColumnName”)})).CopyToDataTable Then use invoke code and remove unnecessary column names where target object is dt2.Columns and method is RemoveAt [tmp_149e8431-3648-4194-a50b-cfd72af2e226]

This solution provided by @lrtetala received 1 likes!

Regex matching help

Hi @A_Learner Try this (?<=Last PAY Amount\s)[\s\S]*(?=Adjustments) [image] I hope it helps!!

This solution provided by @wija received 1 likes!

Excel “printer setup” popup

actually i also in the process of trying this solution in this link (possibility 2 section): my excel template that used by my RPA to process excel, is in page-break preview state, i change it to normal preview and save. hope this will also works.

---

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

Top 3 Topics with Most Views

Explain transpose table made by @helpplease with 33 views.

Have Question about the Linq and 1 line assign made by @kuku_uu with 31 views.

I want to write in excel from specific cell made by @Bhushan_Nagaonkar with 30 views.

Top 3 Topics with Most Replies

How to use string expressions with Write Range Workbook made by @emir_ozsimsir with 17 replies.

I want to write in excel from specific cell made by @Bhushan_Nagaonkar with 13 replies.

How I can paste the text inside text-inputs instead of typing it? made by @Sami_Rajput with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 38 posts!

@mkankatala made 28 posts!

@Parvathy made 20 posts!

Top 3 Most Liked Posts

This post made by @Pranay_Kumar_Bose received 2 likes!

Raname sheets

@Yoichi @vrdabberu Thanks for the solution. Both the solution are easier to understand and fulfills my requirement, but marking only one as solution for thread closure.

This post made by @Parvathy received 2 likes!

Date time format error

Hi @Harsh_Garg Try this syntax: DateTime.Now.Tostring("dd-MMM-yyyy") The above syntax will print first 3 letters of Month name. Refer the image: [image] DateTime.Now.Tostring("dd-MMMM-yyyy") The above syntax will print with whole Month name. Refer the image: [image] Hope it helps!! Regards,

This post made by @lrtetala received 2 likes!

Issue sorting by time in Excel

Hi @tmcwade12 Use Format Cells activity [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 2 likes!

Issue sorting by time in Excel

Hi @tmcwade12 Use Format Cells activity [image] Regards,

This solution provided by @Parvathy received 1 likes!

Google drive file upload

Hi @Harsh_Garg You may not get videos regarding latest version og Gsuite. By watching below videos you can similarly try with the latest one. [Google Drive automation using UiPath | How to use Google Drive Activities in UiPath?] [UiPath Drive Activities in Google Workspace - Part 1 | Google Workspace Activites |#coderslobby] [UiPath Drive Activities in Google Workspace - Part 2 | Google Workspace Activities | @robobix] Hope it helps!!

This solution provided by @vrdabberu received 1 likes!

Read Range gives only DataTable text as output

@emir_ozsimsir Use the output data table activity and pass the dt variable into that activity and pass the ouput of the output data table activity into the message box [image] [image] Hope it helps!!

---

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

Top 3 Topics with Most Views

Take screenshot send mail made by @suraj_gaikwad with 41 views.

Write list of integers into excel horizontally made by @Joecom101 with 31 views.

Vba entry paramyer value for a vba code made by @Demo_User with 31 views.

Top 3 Topics with Most Replies

Reduce Fetched Data after API Input made by @Hugen_Dugen with 30 replies.

Fetching just a particular part of a json row made by @Hugen_Dugen with 26 replies.

Take screenshot send mail made by @suraj_gaikwad with 24 replies.

Top 3 Users Who Posted The Most

@lrtetala made 41 posts!

@Hugen_Dugen made 19 posts!

@Anil_G made 18 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

How to sum and average the whole column

When the localization plays a role (dot is group seperator) we can do Int32.Parse(YourString, System.Globalization.CultureInfo.CreateSpecificCulture("tr-TR")) Double.Parse(YourString, System.Globalization.CultureInfo.CreateSpecificCulture("tr-TR"))

This post made by @Parvathy received 2 likes!

How to Remove a Newline from an Excel cell using UiPath

Hi @tmcwade12 Use “Read Range WorkBook” activity and read the excel and store it in an data table say dtExcel. Use “For Each Row in Data Table” activity to iterate through each row in excel. Use the below two syntax in assign activity: CurrentRow("Departure Time")= CurrentRow("Departure Time").ToString.Replace(vbLf, " ").Replace(vbCr, "") CurrentRow("Arrival Time")= CurrentRow("Arrival Time").ToString.Replace(vbLf, " ").Replace(vbCr, "") Use “Write Range Workbook” activity to write the dat…

This post made by @lrtetala received 2 likes!

How to Remove a Newline from an Excel cell using UiPath

Hi @tmcwade12 Try this Input.ReplaceLineEndings(" ") [image] I hope it helps!!

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 2 likes!

How to Remove a Newline from an Excel cell using UiPath

Hi @tmcwade12 Use “Read Range WorkBook” activity and read the excel and store it in an data table say dtExcel. Use “For Each Row in Data Table” activity to iterate through each row in excel. Use the below two syntax in assign activity: CurrentRow("Departure Time")= CurrentRow("Departure Time").ToString.Replace(vbLf, " ").Replace(vbCr, "") CurrentRow("Arrival Time")= CurrentRow("Arrival Time").ToString.Replace(vbLf, " ").Replace(vbCr, "") Use “Write Range Workbook” activity to write the dat…

This solution provided by @supermanPunch received 1 likes!

Write list of integers into excel horizontally

Hi @Joecom101 , You could also maybe check with the below Expression : DT = (From i In Enumerable.Range(0,CInt(integerList.Count/4)).Select(Function(x)x*4).ToArray Let ra = integerList.Skip(i).Take(4).Cast(Of Object).ToArray Select dt.Clone.Rows.Add(ra)).CopyToDatatable Implementation : [image] Debug Visuals : [image]

This solution provided by @lrtetala received 1 likes!

How to sum and average the whole column

Hi @emir_ozsimsir Please find below xaml for your reference BlankProcess5.zip (164.0 KB) O/P Excel: FORD.xlsx (14.2 KB) I hope it helps!!

---

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

Top 3 Topics with Most Views

How do i get specific value from JSON string made by @Goku with 49 views.

Get Sheetname if condition is True made by @WS_Chai with 45 views.

Get dates till today in a provided format and loop through from that list made by @connect360 with 44 views.

Top 3 Topics with Most Replies

Pick the latest date in datatable made by @Nikhil_Katta with 26 replies.

Reading Data Table from website and comparing with an excel doc made by @R_Wolff with 25 replies.

Get Sheetname if condition is True made by @WS_Chai with 23 replies.

Top 3 Users Who Posted The Most

@mkankatala made 60 posts!

@rlgandu made 41 posts!

@lrtetala made 40 posts!

Top 3 Most Liked Posts

This post made by @Mason_Turvey_Silver received 2 likes!

UiPath HyperHack 2023 Finalist Teams

Thanks so much Cristina! I also had two other members in my team @Srinivas k and @Vishal Kalra, id there’s a specific invite or anything make sure they get it as well. Hyped to present our solution Thank you, Mason S Turvey Aerospace Engineer Systems Architect Automation Evangelist https://www.linkedin.com/in/mason-turvey-785180128

This post made by @suraj_gaikwad received 2 likes!

Error while sending hot key in window 7

Issue solved I use just again element exist and I sent again send hot key as a escape if pop up available it’s escape that otherwise process move forward Thank you guys,

This post made by @Salman_Faries received 2 likes!

ShouldMarkJobAsFaulted

Thank you all for explaining this much detailed!

Top 3 Most Liked Solutions

This solution provided by @suraj_gaikwad received 2 likes!

Error while sending hot key in window 7

Issue solved I use just again element exist and I sent again send hot key as a escape if pop up available it’s escape that otherwise process move forward Thank you guys,

This solution provided by @supriya117 received 1 likes!

Perform mathematical calculation on a two Lists

Hi @shikharno.7 Try this: listResult = listActual.Zip(listBudget, Function(a, b) a - b).ToList()

This solution provided by @mkankatala received 1 likes!

Split string into 3 sections

Hi @balt-ochir.g CurrentFile.Name.Split(“-”)(1) When we use split function the output will be stored as a collection. We can use the index to get the value what we want. Check the below one for better understanding. [image] Hope it helps!!

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

@Yoichi received 54 likes for their solutions!

@Anil_G received 50 likes for their solutions!

@raja.arslankhan received 31 likes for their solutions!

---

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

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

[system]

Daily Forum Report | 01 August 2023

Top 3 Topics with Most Views

Role Based Access Control for Document Understanding - coming August 8th made by @alexcabuz with 49 views.

Removed made by @gorby with 45 views.

How can I extract the Dynamic hyperlink text from the Gmail body? made by @chandrakala.productanalys with 42 views.

Top 3 Topics with Most Replies

How can I extract the Dynamic hyperlink text from the Gmail body? made by @chandrakala.productanalys with 55 replies.

How to download files from portal for specific date made by @connect360 with 25 replies.

How to add String to excel sheet made by @mironb with 22 replies.

Top 3 Users Who Posted The Most

@vrdabberu made 41 posts!

@lrtetala made 33 posts!

@mkankatala made 33 posts!

Top 3 Most Liked Posts

This post made by @alexcabuz received 5 likes!

Role Based Access Control for Document Understanding - coming August 8th

Hello all! Role Based Access Control in Document Understanding is finally here! Users in large organizations with complex compliance requirements have been confined to using AI Center to access Document Understanding capabilities due to Document Understanding itself not having Role Based Access Control capabilities. Not anymore! Starting August 8th you will be able to control at a Tenant level and at a Project level who can do what, and most importantly, who can see what data, in the Document …

This post made by @lrtetala received 2 likes!

Reading Data Table from website and comparing with an excel doc

Hi @R_Wolff Please remove double quotes and reassign double quotes

This post made by @esongi_park received 1 likes!

Attended robot , 어텐디드 봇 관련 문의

안녕하세요 attended robot 과 unattended robot 의 차이점이 다양히 있겠지만, 트리거(스케쥴)은 unattended robot 만 가능한데, attended robot 은 해당 pc에서 어시스턴트로 수행가능 한 걸로 알고 있는데, 오케스트레이터를 통해서 job start 도 가능한지 궁금합니다.(예전에 온프레미스 오케스트레이터로는 불가능했습니다.현재 클라우드 오케스트레이터 사용중입니다)

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

Attended robot , 어텐디드 봇 관련 문의

Hi @esongi_park You can trigger both attended and unattended robots. Attended robots will be run in the foreground, Unattended robots will be run in the background. You can run the attended robot from orchestrator from the process tab. Note - While Trigger the attended robot at the trigger time the local machine has to be in the on position, no lock and no shutdown position. Hope it helps!!

This solution provided by @lrtetala received 1 likes!

Type into press enter

@Povilas_Jonikas Try this [image] It is working

This solution provided by @ppr received 1 likes!

Issue while sending string variable with special characters through send secure SMTP mail

We can escape the string option 1: [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 | 02 August 2023

Top 3 Topics with Most Views

Contains is not a member of datatable made by @WS_Chai with 49 views.

I want to remove entire column if balank header or entire column blank then have to remove entire column without knowing the index made by @shaik.muktharvalli1 with 45 views.

How to Remove Blank Lines from a string? made by @Nitesh_Rajput with 40 views.

Top 3 Topics with Most Replies

I want to remove entire column if balank header or entire column blank then have to remove entire column without knowing the index made by @shaik.muktharvalli1 with 26 replies.

The robot is entering the wrong date format made by @sullivanne with 14 replies.

Getting error while using "Type into" activity : Could not find the user-interface (UI) element for this action made by @sid04 with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 44 posts!

@ppr made 35 posts!

@Parvathy made 31 posts!

Top 3 Most Liked Posts

This post made by @Mohammed_Ismail_Rahid received 2 likes!

Find the file in folder

BlankProcess2.zip (2.6 KB) try this…

This post made by @ppr received 2 likes!

Check if Day is between 20th and 5th of any month

one of many options [grafik]

This post made by @miwa_yamamoto received 2 likes!

セレクターへの変数設定について

Yoichi様 ありがとうございます。 レコーディングし直すと、動きました！ 本当にありがとうございました。 初期値が必要である件、初めて知り、大変勉強になりました。

Top 3 Most Liked Solutions

This solution provided by @Vikas_M received 1 likes!

How to swap details

@Kira You can use invoke code activity and then write the below code EmployeeDT.AsEnumerable().ToList.foreach(Sub(row) row(“Gender”)= If((row(“Gender”).tostring = “Male”), “Female”, If((row(“Gender”).tostring = “Female”), “Male”, “”)) End Sub) And pass the datatable as an argument Hope it helps you out

This solution provided by @Yoichi received 1 likes!

セレクターへの変数設定について

こんにちは これは表示されているメッセージがあまり良くないです。 どちらかというと、その変数のデフォルト値が設定されていない（そのために要素検証ができない）意図なので、その変数のデフォルト値（規定値）を設定すると解消すると思います。（あるいは無視しても動作自体には影響ないと思います。） 以下の様に昨年改善要望のトピックは上げたのですが、なかなか修正されません… https://forum.uipath.com/t/dynamic-selector-appear-message-variable-is-not-defined-in-the-current-scope-even-if-its-defined/471283?u=yoichi

This solution provided by @Yoichi received 1 likes!

UI Explorerで色の判別を取得できる方法がわかりません

こんにちは 基本的に色情報をセレクターから直接取得することはできないので、 間接的にCSS等が指定されているCLASSや各HTML要素を特定し、 その差異で識別する方法が考えられます。（属性取得アクティビティで取得します） あるいは要素を画像として取得して、その色情報を取得する方法もあるかもしれませんが、まずは前者かと思います。

---

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 August 2023

Top 3 Topics with Most Views

Announcing the General Availability of Snowflake Connector and Activity Package in Integration Service made by @Samrat_Dutta with 85 views.

Public Preview: Automation Cloud™ Robots – Automated Domain Join made by @Chetak_Shankar with 50 views.

Problem in installing packages made by @Mariam_Saeed with 49 views.

Top 3 Topics with Most Replies

How to Resolve Duplicate elements Found Issue made by @Muhammad_Anas_Baloch with 19 replies.

Faster UiPath Automation made by @Naman_Arora with 19 replies.

I have csv data Want to update value in Name column from Id column made by @Garyy with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 54 posts!

@ppr made 37 posts!

@Nguyen_Van_Luong1 made 37 posts!

Top 3 Most Liked Posts

This post made by @Jon_Smith received 3 likes!

Make automatic detection of TypeArgument in ForEach optional

Can I make a suggestion that with alot of these new stuff you try out, that you typically make it something that can be ‘overidden’ or reverted? I realise that can mean dragging along some legacy stuff (like having classic activities still be a thing even though Modern Design in the intended way to use Ui Automation now) but I think its better at least at the beginning to allow bugs and issues to not be chronic. Certain things I think just make sense to be optional. Like the If layout being ver…

This post made by @Vikas_M received 3 likes!

Monthly Forum Rewards - July 2023

Kudos to everyone!

This post made by @famastyle received 3 likes!

How to scrap multiple pages with many buttons page

I solved thanks to @supriya117 who made for me a while cycle to scrap all 52 pages! thank so much to everyone whom answered with patience to me! @rlgandu @B_H_Akshatha_Pai @mkankatala @raja.arslankhan @Veera_Raj

Top 3 Most Liked Solutions

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

How to check if a value is already present as the reference of any of the existing queue item in orchestrator?

Hi @Harsha_Vemula try to pass a date stamp in the queue as a reference with employee Id (append) Once your are passing Datestamp as well with emp I’d as reference, enforce unique reference property…that would solve ur issue

This solution provided by @rlgandu received 1 likes!

Getting error while using "Type into" activity : Could not find the user-interface (UI) element for this action

@sid04 Use Set text activity instead of Type into

This solution provided by @vrdabberu received 1 likes!

Uipath Regex not taking data if it is 1 decimal point

@Irfan_Musa use the below regex expression in Find Matching Pattern activity and then use the for each (?<=\):\s+)\d+.\d+ or use the below syntax in assign activity and use the for each System.Text.RegularExpressions.Regex.Matches(input,"((?<=\):\s+)\d+.\d+)") [image] Hope it helps!!

---

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.