Forum Engagement Daily Reports

[system]

Daily Forum Report | 03 September 2023

Top 3 Topics with Most Views

Code working in studio run but not through orchestrator made by @JOBIN_JOSE with 38 views.

Re framework automation made by @J_Crosby with 33 views.

Problem extracting Data URL made by @hiring.antiquescollectors with 32 views.

Top 3 Topics with Most Replies

How to get string after some character made by @aslam_ali1 with 13 replies.

Excel freeze Panes made by @Luffy with 13 replies.

Re framework automation made by @J_Crosby with 9 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 15 posts!

@postwick made 12 posts!

@Shiva_Nikhil made 11 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 2 likes!

Re framework automation

Oh wow I m right It’s already discussed in forum @J_Crosby

This post made by @J_Crosby received 1 likes!

Re framework automation

@Palaniyappan @Shiva_Nikhil I saw those two questions and doubted the correct options after reading deeply on re-framework, that’s why I asked. Option B is also what I think is right from my research. I just needed a confirmation. Thanks a lot guys for your time Cheers J Crosby

This post made by @Vikas_M received 1 likes!

Good evening, how to use regex in assign please

Hey @Girid , Please refer to already available questions in the forum in order to avoid recurring threads Also, to answer your question U can use System.Text.RegularExpressions.Regex.match(YourString,"\d+\d+.\d+").value Hope it helps you out!

Top 3 Most Liked Solutions

This solution provided by @Vikas_M received 1 likes!

Good evening, how to use regex in assign please

Hey @Girid , Please refer to already available questions in the forum in order to avoid recurring threads Also, to answer your question U can use System.Text.RegularExpressions.Regex.match(YourString,"\d+\d+.\d+").value Hope it helps you out!

This solution provided by @postwick received 1 likes!

Need a linq query to solve this issue

Why bother with an extra variable? Just do it all with an If expression… If(CurrentRow.ItemArray.All(Function(x) x.ToString().Equals(“NoChange”)),"OK","Error")

This solution provided by @Palaniyappan received 1 likes!

Transaction Status

It’s option B @J_Crosby

---

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

Top 3 Topics with Most Views

Errror Compare Two File made by @Muhammad_Taufik_Akbar with 52 views.

How to replace blank cell with 0 using Excel activities made by @lrtetala with 42 views.

UiPath Can't indicate SAP element made by @alvin.c.apostol26 with 40 views.

Top 3 Topics with Most Replies

Conditional formatting made by @E.T.S with 18 replies.

Unable to run app on mobile made by @Mathkar_kunal with 16 replies.

Get queue items -set transaction progress! made by @Hazem_Saleh with 15 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 50 posts!

@supermanPunch made 30 posts!

@ppr made 28 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 5 likes!

How to replace blank cell with 0 using Excel activities

Hi @lrtetala , Could you try using the below value in ValueToFind property and check : Type.Missing Maybe also Match Entire Cell Contents property is needed to be updated : [image]

This post made by @Anuj_Tiwari received 3 likes!

Migrating Legacy Listings to Windows

Hi everyone, You may already be aware that the default compatibility for new projects in latest versions of UiPath Studio is “Windows”. It’s important to know that the number of users using the Windows projects in Studio is increasing rapidly. The Legacy listings won’t support Windows so those users of latest Studio version(s) won’t be able to find and use Legacy listings under default compatibility. Therefore, we strongly ask all of you to complete the transition of your legacy listings to W…

This post made by @Pothanakar_Prabhakar received 2 likes!

How we can install uipath studio on linux server

Thanks for the resolution @Palaniyappan @arjunshenoy

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 5 likes!

How to replace blank cell with 0 using Excel activities

Hi @lrtetala , Could you try using the below value in ValueToFind property and check : Type.Missing Maybe also Match Entire Cell Contents property is needed to be updated : [image]

This solution provided by @Arvind_Kumar1 received 2 likes!

Passing values from one page to another

@Aditi_Jha , as you shown you are not using VB Apps. so please do below steps on legacy app. Set Value on click rule Create app variable In Set value pass the App variable and set value from your custom list. you can use app variable across other page now. Thanks, Arvind

This solution provided by @supermanPunch received 2 likes!

Write the values based on the column name in write cell activity

Hi @tharani.natarajan , Assuming that you have read the Data as a Datatable in Excel sheet, we can check with the below to convert Column Index to Column Letter : columnLetter = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(DT.Columns.IndexOf("MailId")+1) Here, DT is the Datatable variable and columnLetter is a String 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 | 05 September 2023

Top 3 Topics with Most Views

How to hide password in the UiPath Apps made by @karthickrkumaran with 49 views.

UiPathTeam.SharePoint.Activities Authentication exception: The sign-in name or password does not match one in the Microsoft account system made by @Yap_Derek with 42 views.

Need Regex Expression made by @Konda_Sai_Charan_Goud with 40 views.

Top 3 Topics with Most Replies

Delete existing file in download activity made by @E.T.S with 18 replies.

I want to create excel sheet on monthly basis made by @Bhushan_Nagaonkar with 15 replies.

SQL update passing variable made by @Povilas_Jonikas with 14 replies.

Top 3 Users Who Posted The Most

@ppr made 44 posts!

@Palaniyappan made 43 posts!

@postwick made 38 posts!

Top 3 Most Liked Posts

This post made by @Yap_Derek received 2 likes!

UiPathTeam.SharePoint.Activities Authentication exception: The sign-in name or password does not match one in the Microsoft account system

Hi All, I am using the UiPathTeam.SharePoint.Activities on a windows legacy project to connect to SharePoint and I experiencing this authentication error. The bot has been running fine using this method for a long time until it failed yesterday. [image] Here are some additional details: Studio Version 2022.10.5 Robot is running on Window Server 2019 Account used does not have MFA enabled. I am using the latest version of the package which is version 1.7.0 I have doubled check and the login…

This post made by @Palaniyappan received 2 likes!

Duration process

Hi once the job run is over for a process, you can open Automation - > JOBS tab and click on " i " symbol to that run it shows the start time and end time like this [image] @Khoa_Automation-Factory

This post made by @Anil_G received 2 likes!

UiPathTeam.SharePoint.Activities Authentication exception: The sign-in name or password does not match one in the Microsoft account system

@Yap_Derek This has been an open issue…workaround or better solution would be to move to office 365 activities Cheers

Top 3 Most Liked Solutions

This solution provided by @arjunshenoy received 2 likes!

Is it necessary to pass UiRPA before taking UiARD?

Hi @postwick If you have sufficient functional experience & knowledge of the UiPath tools, you can just skip the UiRPA & directly take up the UiARD examination, as I did. Hope this helps, Best Regards.

This solution provided by @postwick received 2 likes!

Object reference error plz solve

Check the arguments and variables. If this happens right when you try to run a process, it can mean you have something defined that doesn’t exist yet. For example, you cannot reference one variable in another variable’s default.

This solution provided by @Nitya1 received 2 likes!

Setting smart queue/time triggers

Hi @olgu Managing job triggers and ensuring that they don’t interfere with scheduled machine maintenance can be a challenging task in UiPath Orchestrator. Here are some suggestions to handle this scenario: Check Time Inside Workflow: As you mentioned, you can add logic within your workflow to check the current day and time. If it’s close to the scheduled maintenance window, you can gracefully end the job, making sure to complete any necessary cleanup tasks. Queue Trigger Time Window: W…

---

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

Top 3 Topics with Most Views

For each activity property missing made by @Jeeru_venkat_Rao with 45 views.

For Each Row in Data Table fail. Why? made by @Norbi_V with 42 views.

Multiple attribute in selector using OR operator made by @Akshat_Sharma1 with 40 views.

Top 3 Topics with Most Replies

Guide me how can i download the several file from the website made by @Akash5 with 23 replies.

Using browser in a loop error made by @Povilas_Jonikas with 15 replies.

For each activity property missing made by @Jeeru_venkat_Rao with 13 replies.

Top 3 Users Who Posted The Most

@postwick made 31 posts!

@Palaniyappan made 29 posts!

@ppr made 26 posts!

Top 3 Most Liked Posts

This post made by @nikhil.girish received 2 likes!

Help me with coding uipath best practices

Hi @Rishab2 Check this out Hope this helps

This post made by @Yap_Derek received 2 likes!

UiPathTeam.SharePoint.Activities Authentication exception: The sign-in name or password does not match one in the Microsoft account system

Thanks for your answer @sonaliaggarwal47. I have not upgraded to v2020.10.x recently. When I started working on UiPath projects, the studio version I work with is already version 2022.10.5 and we have been running this version for the past 7-8 months. I will look into the o356 activities as suggested. Thanks

This post made by @Akshat_Sharma1 received 1 likes!

Multiple attribute in selector using OR operator

Hi Community, Recently I came across an automation problem. I am using element exist activity using aaname to detect a text. Now in some cases with aaname its not able detect element but with visible innertext its able to detect. Is there any way we can use put both and if value matches with either aaname or visible innertext then element exist returns true value. Thanks

Top 3 Most Liked Solutions

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

Help me with coding uipath best practices

Hi @Rishab2 Check this out Hope this helps

This solution provided by @Karthik_Reddy_A received 1 likes!

For each row in Excel file

@E.T.S hi use for each row in datatable inside use two assign activities variable1=currentrow(“ColumnName”).tostring variable2=currentrow(“ColumnName”).tostring columnname you can mention your column Names cheers

This solution provided by @Vikas_M received 1 likes!

I have 2 excel with same headers

Hey @Girid Please refer below website https://docs.uipath.com/activities/other/latest/workflow/merge-data-table Also please refer below video [UiPath Tutorial | Merge Data table & Join Data tables activity | Comparison and property explanation] Hope it helps you!

---

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

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

[system]

Daily Forum Report | 07 September 2023

Top 3 Topics with Most Views

Unable to resolve Object reference error at startup made by @theEmailRobot with 52 views.

[Solved] UiPath to show timestamp in message box made by @Sathish_Ashokan with 45 views.

UiPath Action Center help needed made by @Ritaman_Baral with 43 views.

Top 3 Topics with Most Replies

Unable to resolve Object reference error at startup made by @theEmailRobot with 26 replies.

Renaming file with current date and time made by @E.T.S with 18 replies.

Can i paste value in variable? made by @Samraat_Maharjan1 with 16 replies.

Top 3 Users Who Posted The Most

@postwick made 40 posts!

@Palaniyappan made 37 posts!

@ppr made 27 posts!

Top 3 Most Liked Posts

This post made by @ppr received 1 likes!

Convert HTTP Response with nested JSON to DataTable

For some dynamics we can have a look at this longer oneliner: [grafik] And can break the idea down to smaller parts and/or decompose it to essential activities myRowJOs | List(Of JObjects) = myJObject("d")("results").Cast(of JObject).Select(Function (x) new JObject(x.Properties.Where(Function (p) Not p.Name.Equals("__metadata")))) we constructed new JObjcets where we removed the __metadata property (could be extended by a block list approach as well) then we convert it to a DataTable: d…

This post made by @Yoichi received 1 likes!

[Solved] UiPath to show timestamp in message box

HI, What format do you need? The simplest is just Now as the following. [image] Regards,

This post made by @vinitha_yachamaneni received 1 likes!

Unattended Robot doesn't work in a different location

Hi @Carla_Munoz If your Unattended Robot is not running when your laptop is outside your home location, it’s likely because the Orchestrator is unable to connect to your laptop due to network or firewall restrictions Also Ensure that your laptop has a consistent way to be reached from Orchestrator, even when it’s outside your home network. This can be done by setting up a static IP address or configuring dynamic DNS (DDNS) if your laptop’s IP address changes when you move

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Convert HTTP Response with nested JSON to DataTable

For some dynamics we can have a look at this longer oneliner: [grafik] And can break the idea down to smaller parts and/or decompose it to essential activities myRowJOs | List(Of JObjects) = myJObject("d")("results").Cast(of JObject).Select(Function (x) new JObject(x.Properties.Where(Function (p) Not p.Name.Equals("__metadata")))) we constructed new JObjcets where we removed the __metadata property (could be extended by a block list approach as well) then we convert it to a DataTable: d…

This solution provided by @Yoichi received 1 likes!

変数に1000を掛けたい

こんにちは 変数の型をそろえる必要があるかと思います。基本的には以下の様になります。 [image] 変数A(Int型)で取得した値12.000 整数型は小数点以下を扱えませんので、代入は12になるかと思います。 エラー内容：Option Strict On で ‘String’ から ‘Double’ への暗黙の型変換はできません 型があっていないと思います。変数BがString型ではないでしょうか？ その場合、(変数A*1000).ToString の様にする必要があります。

This solution provided by @Yoichi received 1 likes!

Need to extract data from textfile

HI, How about the following expression? This extract numeric characters which exists at the end of the next line of “PO NUMBER” (Because I guess it’s PO NUMBER) [image] System.Text.RegularExpressions.Regex.Match(strData,"(?<=PO NUMBER[\s\S]+?)\d+(?=\r?\n|$)").Value Sample20230907-3L.zip (14.4 KB) Regards,

---

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

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

[system]

Daily Forum Report | 08 September 2023

Top 3 Topics with Most Views

https://forum.uipath.com/t/580731 made by @wwls with 42 views.

https://forum.uipath.com/t/580901 made by @Kunal_Jain with 41 views.

https://forum.uipath.com/t/580691 made by @Tri_Vu with 41 views.

Top 3 Topics with Most Replies

https://forum.uipath.com/t/580836 made by @E.T.S with 20 replies.

https://forum.uipath.com/t/580834 made by @rishiathawale with 16 replies.

https://forum.uipath.com/t/580954 made by @E.T.S with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 54 posts!

@Palaniyappan made 25 posts!

@postwick made 24 posts!

Top 3 Most Liked Posts

This post made by @Kartheek_Battu received 3 likes!
https://forum.uipath.com/t/580715/4

This post made by @Shiva_Nikhil received 2 likes!
https://forum.uipath.com/t/580718/4

This post made by @mpraveen1902 received 2 likes!
https://forum.uipath.com/t/580715/3

Top 3 Most Liked Solutions

This solution provided by @mpraveen1902 received 2 likes!
https://forum.uipath.com/t/580715/3

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

This solution provided by @Shiva_Nikhil received 1 likes!
https://forum.uipath.com/t/580718/2

---

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

Top 3 Topics with Most Views

DataRow Item Array Convert into Datatable made by @Shyam_Pragash with 38 views.

Error Downloading Monthly Report from Microsoft Edge - REF Assignment made by @Vishnu_Vardhan_Addagada with 31 views.

Error in variable when placed as integer in scope made by @Smit_Jain with 31 views.

Top 3 Topics with Most Replies

Error in variable when placed as integer in scope made by @Smit_Jain with 18 replies.

Unable to Copy the color of filter cells made by @Cuberoot with 13 replies.

How to Delete the folder which has yesterday's date in lt made by @Girid with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 17 posts!

@Nitya1 made 17 posts!

@Smit_Jain made 11 posts!

Top 3 Most Liked Posts

This post made by @Cuberoot received 2 likes!

Unable to Copy the color of filter cells

input file is in Sheet1 and output file is in Sheet2. Thanks

This post made by @Shiva_Nikhil received 2 likes!

Have created an automation to add data row to data table but showing some error,thanks for any help

@Sai_Kumar_111 Hi [image] [image] [image] cheers

This post made by @Anil_G received 1 likes!

Error Downloading Monthly Report from Microsoft Edge - REF Assignment

@Vishnu_Vardhan_Addagada Are you not able to indicate? If so did you happen to try changing the mode to active accessibility and try? Ideally you should get some selector like below <wnd app=‘msedge.exe’ cls=‘Chrome_WidgetWin_1’ title=‘* Microsoft​ Edge’ /> <ctrl name='Save As' role=‘push button’ /> Cheers

Top 3 Most Liked Solutions

This solution provided by @Shiva_Nikhil received 2 likes!

Have created an automation to add data row to data table but showing some error,thanks for any help

@Sai_Kumar_111 Hi [image] [image] [image] cheers

This solution provided by @Anil_G received 1 likes!

Error Downloading Monthly Report from Microsoft Edge - REF Assignment

@Vishnu_Vardhan_Addagada Are you not able to indicate? If so did you happen to try changing the mode to active accessibility and try? Ideally you should get some selector like below <wnd app=‘msedge.exe’ cls=‘Chrome_WidgetWin_1’ title=‘* Microsoft​ Edge’ /> <ctrl name='Save As' role=‘push button’ /> Cheers

This solution provided by @Vikas_M received 1 likes!

How to Delete the folder which has yesterday's date in lt

@Girid , Please refer below file BlankProcess.zip (8.5 KB) Hope it helps you!

---

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

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

[system]

Daily Forum Report | 10 September 2023

Top 3 Topics with Most Views

Regex and Delay not working made by @Ritaman_Baral with 38 views.

I get this error “Excel Application Scope” after I clicked “Run”? made by @Sara_Piana with 36 views.

Build your first automation studio made by @Vincent_Shoshin with 31 views.

Top 3 Topics with Most Replies

I get this error “Excel Application Scope” after I clicked “Run”? made by @Sara_Piana with 15 replies.

Regex and Delay not working made by @Ritaman_Baral with 12 replies.

About extraction of invoice details using document understanding made by @Nithin_Thatikonda with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 23 posts!

@Sara_Piana made 13 posts!

@Palaniyappan made 12 posts!

Top 3 Most Liked Posts

This post made by @Shubham_Varshney received 1 likes!

Wipro - UiPath Test Suite - Across Country - India - Full Time

Job title: UiPath Test Suite Job role: RPA Developer Country: India City: Across Country Company name: Wipro Employment Type: Full Time Seniority level: Associate 3 to 5 years Job Description: Looking for 2-8 years of person with Experience in UiPath Test Suite. Preference to short notice period Candidates Apply here: shubham2712@gmail.com

This post made by @lrtetala received 1 likes!

I get this error “Excel Application Scope” after I clicked “Run”?

Hi @Sara_Piana Please check on this thread it might be helps you

This post made by @Yoichi received 1 likes!

How to debug error using wildcard?

Hi, Can you try to replace unfixed string with asterisk in SendHotKey activity as same as AttachWindow? name='*File_*.txt - Notepad' [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to debug error using wildcard?

Hi, Can you try to replace unfixed string with asterisk in SendHotKey activity as same as AttachWindow? name='*File_*.txt - Notepad' [image] Regards,

This solution provided by @Palaniyappan received 1 likes!

Hi, I have some big values to save and process like -10,00,00,00,30,29,601 (+ve as well as -Ve) and -118.1966670 (with high decimal precision) which data type I should use to process such data?

Hi For large values, you should use the Int64 data type. The Int64 data type can store values up to 9,223,372,036,854,775,807. This is more than enough to store the values you mentioned. For values with high decimal precision, you should use the Double data type. The Double data type can store values up to 15 decimal places. This is enough to store the value -118.1966670. If you are not sure which data type to use, you can always use the String data type. The String data type can store any ty…

This solution provided by @Anil_G received 1 likes!

Creating an automation for some process and getting error while assigning to variables

@Sai_Kumar_111 Ideally it would work…i hope this is inside for each row in datatable activity…sometimes the columns are casted as objects…and at that time we need to add .ToString Hope this helps Cheers

---

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

Top 3 Topics with Most Views

Apps - Attended Real time Communication made by @Venkata_Rajendran with 176 views.

How to combine 2 rows(with header) into a single row header? made by @angush.st with 66 views.

How to Split the Rows in a Data Table into multiple Data Tables? made by @Vishnu_Vardhan_Addagada with 51 views.

Top 3 Topics with Most Replies

Write Cell Workbook not allowing me to update Excel without closing it first made by @Ampra with 25 replies.

I want to take first row data column 3 to column 12 other all below data will be delete which has duplicate ID and Duplicate Address value made by @Garyy with 14 replies.

How to Run SAP scripting made by @Learner007 with 13 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 43 posts!

@Nguyen_Van_Luong1 made 23 posts!

@postwick made 22 posts!

Top 3 Most Liked Posts

This post made by @Venkata_Rajendran received 11 likes!

Apps - Attended Real time Communication

We are very excited to release our latest feature of Apps- Attended Robot real-time communication. This capability allows you to communicate between Apps and attended robots in real time. With this feature, we will be solving the performance issue of starting a new process every time, there is a need to communicate between Apps and Attended robots. Using this capability, an App can start a process and communicate with the process any number of times by invoking various XAMLs in the process. Th…

This post made by @Ampra received 2 likes!

Write Cell Workbook not allowing me to update Excel without closing it first

I was able to apply the fix!! I can now write to the file I wanted I just want to say- I am terribly sorry for how drawn-out this became. I am trying to follow along in the UiPath course but the version in the videos are outdated and different from mine. It is making this process of learning very difficult, but your support has been the only thing keeping me going. Thank you so very much for your patience and advice with help. You are truly rockstars <3 @Parvathy @Palaniyappan -Ampr…

This post made by @neha.upase received 2 likes!

How to get count of empty columns in the excel

Hi, Try this emptyRowCount = YourDataTable.AsEnumerable().Where(Function(row) Not String.IsNullOrEmpty(row.Field(Of String)(“ColumnA”)) AndAlso String.IsNullOrEmpty(row.Field(Of String)(“ColumnC”))).Count()

Top 3 Most Liked Solutions

This solution provided by @Jeroen_van_Loon received 1 likes!

Outlook shared mailbox synchronization takes too long

Common problem indeed. A few tips I’ve used in the past in different environments: you can leave outlook open if your VDI’s are persisten validate the status bar, and look for something like ‘all folders up to date’ and wait for that dynamically when opening outlook. When you use your get mail messages activities, be sure that it is set up to get enough messages. Know that if you use filters in this activity, the filters are applied ‘after’ getting the messages. Example: your mailbox contain…

This solution provided by @Nguyen_Van_Luong1 received 1 likes!

How to Split the Rows in a Data Table into multiple Data Tables?

Hi, @Vishnu_Vardhan_Addagada my code Main.xaml (21.9 KB) my input Test.xlsx (9.9 KB) my output in csv output.zip (1.3 KB) full path Split Data.zip (24.5 KB) regards,

This solution provided by @Palaniyappan received 1 likes!

How to copy a text from a textbox and paste it to another textbox using UiPath StudioX?

Hi Welcome to UiPath forum hope the below steps would help you resolve this use GET ATTRIBUTE activity to get the text VALUE of an attribute https://docs.uipath.com/activities/other/latest/ui-automation/get-attribute#:~:text=Retrieves%20the%20value%20of%20a,the%20aastate%20attribute%2C%20for%20example. then use TYPE INTO ACTIVITY and indicate the field where you want to paste it along with the value obtained from above activity mention the variable and then press PLUS button to include…

---

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

Top 3 Topics with Most Views

Creating a Workday connection in Integration Service made by @Samrat_Dutta with 69 views.

How to update the status made by @anjani_priya with 46 views.

How to Install Teams Packages made by @wsinten with 43 views.

Top 3 Topics with Most Replies

How to update the status made by @anjani_priya with 12 replies.

How to Install Teams Packages made by @wsinten with 11 replies.

Forms made by @Rohit_Nandwani with 10 replies.

Top 3 Users Who Posted The Most

@Nguyen_Van_Luong1 made 56 posts!

@Palaniyappan made 33 posts!

@postwick made 30 posts!

Top 3 Most Liked Posts

This post made by @Samrat_Dutta received 2 likes!

Creating a Workday connection in Integration Service

Step One: Create an Integration System User (ISU) In your Workday portal, log into the Workday tenant. In the Search field, type Create Integration System User. Select the Create Integration System User task. [image] On the Create Integration System User page, in the Account Information section, enter a user name, and enter and confirm a password. Click OK. [image] Note: due to xml encoding, “&”, “<”, and “>” cannot be included in the password. Note: Make sure Require New P…

This post made by @Palaniyappan received 2 likes!

UiPath Spotlight Directory: Amplify Your Presence

This is fantastic

This post made by @ppr received 1 likes!

Extract the specific value from the JSON object

in Addition to above: [grafik] output - myJObject | DataType: JObject [grafik] Kindly note: the property keys are case sensitive when using it

Top 3 Most Liked Solutions

This solution provided by @Nguyen_Van_Luong1 received 1 likes!

Update Datatable column name when it contain certain word?

Hi @winnie_toh , You can use if check contains then assign yourDT.Columns(index).ColumnName = “New Column Name” can you share your file and conditions regards,

This solution provided by @Yoichi received 1 likes!

Data table filter wizard unable to filter column name that contain line breaks

Hi, How about the following? [image] "Sep TTL"+vblf+"Allo" OR "Sep TTL"+vbcrlf+"Allo" Sample workflow Sample20230912-1L.zip (8.3 KB) Regards,

This solution provided by @Nguyen_Van_Luong1 received 1 likes!

Tooltip in Argument Panel

Hi @irahmat , You can right click to argument then select design properties [image] [image] [image] [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 | 13 September 2023

Top 3 Topics with Most Views

Filter Data Table from excel made by @ainaasyhda with 51 views.

Extract table of contents + Word document made by @Sairam_RPA with 44 views.

繰り返し(並列)アクティビティについて made by @norihiko.okubo0201 with 41 views.

Top 3 Topics with Most Replies

Lookup data table not configured correctly made by @E.T.S with 49 replies.

Read txt file and Split Each Row made by @prerna.gupta with 15 replies.

Correct format issue made by @aya_lajili1 with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 36 posts!

@postwick made 30 posts!

@E.T.S made 25 posts!

Top 3 Most Liked Posts

This post made by @nikhilesh578 received 6 likes!

Monthly Forum Rewards - August 2023

Hearty Congratulations Everyone Well done @Anil_G , @Shiva_Nikhil , @mkankatala , @Usha_Jyothi , @neha.upase …keep going Cheers, Nikhilesh Sathyavarapu

This post made by @Dinesh_Guptil received 3 likes!

Monthly Forum Rewards - August 2023

Hi @loredana_ifrim @UiPath_Community Can you please confirm with the proper name of 5th candidate that is actually @Shiva_Nikhil Regards, Dinesh

This post made by @Anil_G received 2 likes!

Monthly Forum Rewards - August 2023

Congratulations everyone cheers

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Extract table of contents + Word document

Hi, How about the following sample? [image] Sample20230913-2L.zip (15.5 KB) Regards,

This solution provided by @Shiva_Nikhil received 1 likes!

Read txt file and Split Each Row

@prerna.gupta taskforum.zip (2.8 KB) check this

This solution provided by @ppr received 1 likes!

The source contains no datarows fixes?

General pattern to handle it defensive: [FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum

---

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

Top 3 Topics with Most Views

In Chrome and Edge v117 the Active Accessibility support is broken for IFRAMEs and PDFs made by @Luiza_Surdu-Bob with 107 views.

Extracting Post code from address made by @duaine.b with 40 views.

Error appear regarding use excel file made by @Nur_Amin with 39 views.

Top 3 Topics with Most Replies

Pick out unique email addresses from 2 columns and paste the unique email addresses in the BCC field of send smtp activity made by @ayushi_jain3 with 20 replies.

Regex to find first word that contains number made by @Suastrian_Dika with 15 replies.

Addition not working made by @Kamalesh_Chunekar with 14 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 57 posts!

@Anil_G made 33 posts!

@postwick made 28 posts!

Top 3 Most Liked Posts

This post made by @raghu30691 received 3 likes!

Monthly Forum Rewards - August 2023

Hearty Congratulations Forum Leaders… @Anil_G , @Shiva_Nikhil Cheers

This post made by @Anil_G received 3 likes!

Need to capture value from this complex JSON

@c3f1e68294fdcf4a1f0a817ca first use a deserialize json activity and then from output use for for loop jobj("users")(0)("memberships").Cast(Of JObject) and inside loop use currentJObject("status").ToString currentJObject("permission_profile")("id").ToString currentJObject("permission_profile")("name").ToString Implementation [image] output [image] Hope this helps cheers

This post made by @mukeshkala received 2 likes!

Exciting News: Introducing New Improvements to our UiPath Community Forum Platform!

The UiPath emoji is awesome

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 3 likes!

Need to capture value from this complex JSON

@c3f1e68294fdcf4a1f0a817ca first use a deserialize json activity and then from output use for for loop jobj("users")(0)("memberships").Cast(Of JObject) and inside loop use currentJObject("status").ToString currentJObject("permission_profile")("id").ToString currentJObject("permission_profile")("name").ToString Implementation [image] output [image] Hope this helps cheers

This solution provided by @Anil_G received 2 likes!

Lookup data table not configured correctly

@E.T.S If you need the whole row use thsi dt.AsEnumerable.Where(function(x) Regex.Replace(x(0).ToString,"(\r?\n)*","").ToLower.Contains(Regex.Replace(YourStringVariable,"(\r?\n)*","").ToLower)).FirstOrDefault And if you need it as datatable and all the matched rows if there are multiple…then bettern first check if any thing is matching using if and then use copyto datatable To check matched dt.AsEnumerable.Where(function(x) Regex.Replace(x(0).ToString,"(\r?\n)*","").ToLower.Contains(Regex.Re…

This solution provided by @Gokul_Jayakumar received 1 likes!

Transpose excel data

@suraj.l Refer to this Xaml file you may get some idea. Transpose.xaml (11.4 KB) [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 September 2023

Top 3 Topics with Most Views

How to insert data dynamically into column in excel made by @panguluri_saritha with 51 views.

Unable to convert the Jsonobject to Json array made by @srinusoft37 with 40 views.

Orchestrator webhook not sending Notification to Microsoft team channel made by @mallikarjun411 with 40 views.

Top 3 Topics with Most Replies

Content placeholder in add to text slide PowerPoint activity made by @E.T.S with 18 replies.

Can anyone help me how to download pdf uipath associate certificate from CertMetrics account made by @PriyaReddy with 17 replies.

How to insert data dynamically into column in excel made by @panguluri_saritha with 13 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 44 posts!

@ppr made 29 posts!

@Praveen_Mudhiraj made 24 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 2 likes!

Exciting News: Introducing New Improvements to our UiPath Community Forum Platform!

Cool features @loredana_ifrim

This post made by @LamaX received 2 likes!

How to use project's folder without using hard code?

This is a very cool expression. I just mentionned the folder name like “Initialisation” in the ‘path field’ and he recognized it as a folder and used it as a full path. It’s amazing. Thank you also @Palaniyappan and @ppr !

This post made by @seonghyeon_pak received 2 likes!

UiPath studio 설치문의

좌측 하단을 보니… 계정이 커뮤니티 라이선스인지… 확인이 필요할 것 같습니다. cloud.UiPath.com으로 이동하시면 좌측에 버튼이 있을 겁니다. 누르시면 아래와 같은 화면이 나올텐데요 [image] 관리자 혹은 admin 선택해주시고 아래와 같이 license 창 아래에 커뮤니티 플랜인지 먼저 확인해주세요. [image] 만약, 커뮤니티 플랜이 아니라면 커뮤니티 계정을 새로 만드시는 것이 좋을 것 같습니다. 가입을 누르시면 아래와 같이 좌측에 창이 나올 텐데요 [image] 바로 가입을 하지 마시고 커뮤니티용 automation cloud 사용하기를 눌러서 아래와 같은 창이 나올 때 가입을 진행해주시면 됩니다. [image] 가입을 하시면 studio에 새로운 아이디를 연결하셔야할텐데… studio 우측 상단에 보시면 자기 계정의 이니셜 모양의 버튼이 있을 겁니다. [image] 로그아웃 해주시고 새로 연결해주시면 되겠습니다.

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

I have csv file data i want to duplicate row according to duplicate ID and Member only take one row of one duplicate id and member column

@suyog79 Try this Dt.AsEnumerable.GroupBy(function(x) x(0).ToString+x(1).ToString+x(5).ToString).Select(function(x) x.First).GroupBy(function(x) x(0).ToString+x(1).ToString).SelectMany(function(x) If(x.Count>1,x.Where(function(y) Not String.IsNullOrEmpty(y(5).ToString)),x)).CopyToDataTable Hope this helps Cheers

This solution provided by @ppr received 1 likes!

Unable to convert the Jsonobject to Json array

we could do directly: [grafik] Can iterate dynamically over all Properties: [grafik] Maybe you can tell more about the final goal / use case

This solution provided by @Yoichi received 1 likes!

リトライスコープで、BusinessRuleExceptionの場合だけ、リトライせずにスローしたい

こんにちは 例えば リトライスコープ内部でTryCatchを配置 CatchでBusinessRuleExceptionはその内容だけを外に渡せるようにして、正常終了させる その他のExceptionはRethrow でいかがでしょうか？以下実装イメージです。 [image]

---

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

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

[system]

Daily Forum Report | 16 September 2023

Top 3 Topics with Most Views

Selectors issue on item made by @vineelag with 38 views.

String was not recognized as a valid DateTime like "45175" made by @anh.nguyen with 37 views.

How to export data from Orchestrator Queue made by @divya.17290 with 37 views.

Top 3 Topics with Most Replies

Match skills using chatgpt made by @ydhanabalan with 14 replies.

How to convert iEnumerable into datatable made by @divya.17290 with 10 replies.

Is it possible deserialize json from excel made by @divya.17290 with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 17 posts!

@Palaniyappan made 12 posts!

@divya.17290 made 12 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 1 likes!

Selectors issue on item

Hi You can try with Regex selector Here in your selector mention instead of idx attribute mention like this Idx=‘(11|12)’ matching:idx=‘regex’ Refer this doc for more details https://docs.uipath.com/studio/standalone/2023.10/user-guide/regex-search Cheers @vineelag

This post made by @Madhu_Maurya received 1 likes!

Captcha2

[image] [image] hello all, see in first image actually i am trying to scrap name and then click refresh and from the next page again ,I want to scrap name but in between captcha come(see in second image) so how to deal with captcha and go next page and scrap again name, plz guide me

This post made by @raven received 1 likes!

Desktop outlook app error

“Use Desktop Outlook App” activity and inside “Send Email” activity. When “Save as draft” is checked no account is selected in Outlook (it just states “Outlook” and manually I have to select the account). When “Save as draft” is not selected I get the error System.Runtime.InteropServices.COMException. So for some reason the choosen account in the dropdown from “Use Desktop Outlook App” activity is not working. I have tried searching the Forum for solutions but nothing works. I do not understand …

Top 3 Most Liked Solutions

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

Difference bw studio and studio x

Hi @keerthi65a Welcome to community Check the above link

This solution provided by @Palaniyappan received 1 likes!

Replace multiples words in text file

Hi Use read text file activity and get the output as a string named Strinput Now use a assign activity like this Strinput = Strinput.ToString.Replace(“_Name”,”your new word”).Replace(“TicketNumber”, “your new number”) If you want to make it dynamic u can place a placeholder in those places in the text file Refer this for more idea on that Cheers @Kumar_Sahu_Sameer

This solution provided by @neha.upase received 1 likes!

String was not recognized as a valid DateTime like "45175"

Hi, You can use the following expression to convert an Excel date value (e.g., 45175) to a formatted date string: DateTime.FromOADate(CDbl(ngayhd)).ToString(“dd/MM/yyyy”) [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 September 2023

Top 3 Topics with Most Views

Regarding excel calculation made by @ramshiva_reddy with 37 views.

Need RegEx help please made by @chrystine.h with 34 views.

I cannot go beyond the For Each DataTable activity in the REF template made by @tolgademir with 33 views.

Top 3 Topics with Most Replies

Issue with Shift_F5 on As-400 Application? made by @Salman_Faries with 9 replies.

Downgrading Studio made by @J_Crosby with 6 replies.

I cannot go beyond the For Each DataTable activity in the REF template made by @tolgademir with 6 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 13 posts!

@Anil_G made 13 posts!

@ppr made 8 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 3 likes!

Need RegEx help please

Hi There is a knowledge base in UiPath forum on all functionalities of datatable Have a view on this for more insights For your scenario This is with normal IsNullOrEmpty method dt1 = dt1.AsEnumerable().Where(Function(a) NOT String.IsNullOrEmpty(a(“Email”).ToString.Trim) ).CopyToDatatable() If you want to remove with the Regex dt1 = dt1.AsEnumerable().Where(Function(a) NOT System.Text.RegularExpressions.Regex.IsMatch(a(“Email”).ToString.Trim, “[\W|\w]").CopyToDatatable() Hope this helps …

This post made by @Chirag12 received 2 likes!

Monthly Forum Rewards - August 2023

Thank you @Anil_G and @Vikas_M , You both have been helping me a lot lately Well deserved!

This post made by @Sudarshana_Sharma_P received 2 likes!

Exciting News: Introducing New Improvements to our UiPath Community Forum Platform!

Awesome. I like all the smiley’s. Good effort to enhance the conversations

Top 3 Most Liked Solutions

This solution provided by @neha.upase received 1 likes!

Need RegEx help please

Use an “Assign” activity to create a new data table that contains only the rows you want to keep. Let’s call this new data table filteredDt. In the “Value” field of the “Assign” activity, use LINQ to filter the rows of dt1 based on the condition that the “Email” column is not null or whitespace. You can use the Where method with a lambda expression to achieve this. Here’s the code for the “Value” field: filteredDt = dt1.AsEnumerable().Where(Function(row) Not String.IsNullOrWhiteSpace(row(“Emai…

This solution provided by @Anil_G received 1 likes!

If activity - Message Box not popping up after user input

@OGunnarsson Welcome to the community The problem is your while condition The if condition is not placed inside the while loop…so the while loop will end only when you give the correct answer…hence the if condition is executing only correct one… Try to move your if condition into the while loop then for each loop or guess you will get the message pop up as needed Cheers

---

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

Top 3 Topics with Most Views

Get form tasks activity made by @Aditi_Jha with 45 views.

Uipath use regex to extract first string from each line made by @voxter with 37 views.

Downloading file from a website made by @Priyesh_Shetty with 36 views.

Top 3 Topics with Most Replies

Get form tasks activity made by @Aditi_Jha with 28 replies.

Downloading file from a website made by @Priyesh_Shetty with 15 replies.

Select Item activity won't work made by @Anelisa_Bolosha1 with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 47 posts!

@Palaniyappan made 35 posts!

@ppr made 34 posts!

Top 3 Most Liked Posts

This post made by @firas received 2 likes!

Prompting for credintials while running a Query inside Excel

Thank you @Roman-Routinuum , @Palaniyappan and @Anil_G I will review those great suggestion and see which one will better work on my project I really appreciate your prompt assistance!

This post made by @mRob received 2 likes!

User rights - Read only access to Triggers & Logs

Thanks for the answers, il give those a go !

This post made by @Nguyen_Van_Luong1 received 1 likes!

Exciting News: Introducing New Improvements to our UiPath Community Forum Platform!

Awesome @loredana_ifrim I like UiPath emoji search bar and similar topic help me find solution faster to help your self and other developer Thanks !

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 1 likes!

AWS server instance

Though haven’t tried I have seen my infra team working on this it is possible to install 4 copies of UiPath on an AWS server instance with 4 user profiles. Each user profile will have its own copy of UiPath installed. Create 4 user profiles on the AWS server instance. Connect to each user profile using a remote desktop connection. On each user profile, download and install UiPath. Configure UiPath on each user profile. Once you have completed these steps, you will have 4 copies of UiPath in…

This solution provided by @Palaniyappan received 1 likes!

How open PDF file

Fine then Developer option is not enabled I believe In use application activity mention the filepath in this property Arguments - If the application is not a web browser, you can specify parameters to pass to the target application at startup. You can use this property to open a specific file with the application. For example, if the target application is Acrobat Reader, you can open a specific workbook by providing the full path to the file. To open the file C:\Sample.pdf, enter "C:\Sample.p…

This solution provided by @Anil_G received 1 likes!

User rights - Read only access to Triggers & Logs

@mRob Welcome to the community Please create roles that you need as per the access you need. Always its better to create the roles as you need…specifically you need view on logs and triggers…which can be created…the predefined roles are some basic ones which will help you understand how to bifurcate [image] [image] cheers

---

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

Top 3 Topics with Most Views

Split Excel to multiple Excels made by @praneeth.v.c with 41 views.

Read Particular column made by @Gokul_Murali with 39 views.

Need to write in excel sheet on the basis of different value in the row made by @office_use with 39 views.

Top 3 Topics with Most Replies

Having Problems Connecting my UIPath Studio to my Outlook made by @M_F with 22 replies.

Output data table - cannot get values of data table made by @E.T.S with 21 replies.

Need to write in excel sheet on the basis of different value in the row made by @office_use with 18 replies.

Top 3 Users Who Posted The Most

@postwick made 35 posts!

@Nguyen_Van_Luong1 made 33 posts!

@Anil_G made 33 posts!

Top 3 Most Liked Posts

This post made by @andreus91 received 2 likes!

Convert date to desired format

if you might have different input date formats, I recommend always using parse exact, but providing various date patterns in an input array. var_datetime = DateTime.ParseExact(Strinput.ToString, arr_formats, System.Globalization.CultureInfo.InvariantCulture, DateTimeStyles.None) arr_formats = {“yyyyMMdd”, “MM/dd/yyyy”, “dd/yy”} I hope it helped you

This post made by @Dillon_Marius received 1 likes!

UiPath Certified RPA Associate (UiRPA) and UiPath Certified Advanced RPA Developer (UiARD) - Update

Hi Quick question, I’m in the middle of the taking the current curriculums and its modules. From my understanding of the above, the modules will later on take out classic related modules? cmiiw. Also, will there be additional new modules for modern design or they stay just as is? But yeah on a more high level, I’m wondering how the curriculum and modules will change. Cheers, Dillon

This post made by @wsinten received 1 likes!

How to write text by time

hi @Nguyen_Van_Luong1 @Parvathy @Anil_G , thank you for helping. the above problem has been solved. Thank You

Top 3 Most Liked Solutions

This solution provided by @Nguyen_Van_Luong1 received 1 likes!

엑셀의 특정 열의 텍스트를 한꺼번에 인터넷에 조회 하는 방법

Hi @doosanhero6 , My step 1-read file to get data table [image] 2-use open browser use for each row in data table type into row value to website send hot key with key enter to down line [image] hope it help,

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

Convert date to desired format

Hi @Tanu_G Check this out Datetimevar= DateTime.ParseExact(“20230919”,“yyyyMMdd”,System.Globalization.CultureInfo.InvariantCulture). ToString(“MM/yyyy/dd”) Hope this helps

This solution provided by @Yoichi received 1 likes!

Need to remove one row or more row based on condition

Hi, How about the following? [image] dt.AsEnumerable.GroupBy(Function(r) r("ref ord no").ToString).SelectMany(Function(g) g.Select(Function(r) r).GroupBy(Function(r) r("material").ToString).SelectMany(Function(g2) if(g2.Key="Not Found in Master Regular" AndAlso g.Count>g2.Count,New DataRow() {},g2.Select(Function(r2) r2)))).CopyToDataTable() Sample20230919-1L.zip (11.5 KB) Regards,

---

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

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

[system]

Daily Forum Report | 20 September 2023

Top 3 Topics with Most Views

Hypelrink Excel Uipath made by @Ritaman_Baral with 87 views.

Enhancing Video Recording with Queue Recording made by @Adrian_Tamas with 67 views.

Date Type error, Date with year 1999 is not working but working on date with year 2000 made by @Anelisa_Bolosha1 with 66 views.

Top 3 Topics with Most Replies

Date Type error, Date with year 1999 is not working but working on date with year 2000 made by @Anelisa_Bolosha1 with 28 replies.

Hypelrink Excel Uipath made by @Ritaman_Baral with 24 replies.

https://forum.uipath.com/t/597667 made by @xxGoRpa with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 52 posts!

@Nguyen_Van_Luong1 made 45 posts!

@ppr made 28 posts!

Top 3 Most Liked Posts

This post made by @Adrian_Tamas received 9 likes!

Enhancing Video Recording with Queue Recording

Hi there, UiPath Community! On behalf of all teams involved, I’m excited to announce a new feature meant to improve your automation workflow, especially when dealing with queue item execution. We are always listening to your feedback, and we understand that identifying the root cause of failed transactions can be a real challenge. Therefore, on top of the existing video recording capabilities, we have just released Queue Recording. Queue Recording is an integrated video recording feature that …

This post made by @ppr received 2 likes!

JSON array adding new values issue

Cross reference: We do have a few options, as also mentioned in the other thread: constructing the Structure with the help of e.g. Dictionaries, Arrays… and convert it to JSON afterwards Constructing JSON by the scratch illustrating, from where the FOR EACH would be fed or what is sent in, would be helpful. Maybe a less generic sample data will let us better understand However also have a look at this: For each Activity | item in CollectionOfManyJObjects | TypeArguement: JObject Invoke…

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

Orchestrator - Resources in Classic Folders will be removed in October 2023

Hello everyone, As we approach release 2023.10, we’d like to remind you that Classic Folders will soon be completely removed, in accordance with our previously announced deprecation plan. Starting with the 2023.10 release of the UiPath Business Automation Platform, we will remove all resources in Classic Folders. To be clear, this means that all resources not migrated to Modern Folders before release 2023.10 is deployed will no longer be available in any workflow. Automation Cloud customers ne…

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

JSON array adding new values issue

Cross reference: We do have a few options, as also mentioned in the other thread: constructing the Structure with the help of e.g. Dictionaries, Arrays… and convert it to JSON afterwards Constructing JSON by the scratch illustrating, from where the FOR EACH would be fed or what is sent in, would be helpful. Maybe a less generic sample data will let us better understand However also have a look at this: For each Activity | item in CollectionOfManyJObjects | TypeArguement: JObject Invoke…

This solution provided by @supermanPunch received 1 likes!

Negative look ahead

Hi @A_Learner , I believe there must be a slight change in the Expression : ((?<!Payment(s)?\s*)Received)(((\b(?:[A-Za-z]{3,9} \d{1,2}, \d{4})\b)|(\s?\d+/\d+/\d+))(?=(.*)?)) [image] As it should be a Negative Look behind not ahead.

This solution provided by @Anil_G received 1 likes!

Date Type error, Date with year 1999 is not working but working on date with year 2000

@Anelisa_Bolosha1 As per message box this is what you need to use inceptiondt2 = Datetime.ParseExact(inceptiondate,"MM/dd/yyyy HH:mm:ss",System.Globalization.CultureInfo.InvariantCulture).ToString("MM/dd/yyyy") cheers

---

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

Top 3 Topics with Most Views

Dev Dives: Mastering AI-powered Document Understanding made by @Lahiru.Fernando with 48 views.

Problem with IfElseIf activity made by @Robert.Oslanec with 40 views.

Run uipath process from cmd line made by @parvathi_ayanala with 39 views.

Top 3 Topics with Most Replies

Excel Automation> Comparing 2 column and write final value in another column made by @anjasing with 20 replies.

Join datatable activity error made by @chandrakala.productanalys with 20 replies.

Send 10 outlook mails made by @anjani_priya with 19 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 51 posts!

@Nguyen_Van_Luong1 made 33 posts!

@Anil_G made 24 posts!

Top 3 Most Liked Posts

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

Dev Dives: Mastering AI-powered Document Understanding

Hi UiPath Community, Are you eager to supercharge your document processing with the powerful duo of automation and AI? If so, mark your calendars for September 28 because you won’t want to miss the next Dev Dives episode! I’m Lahiru Fernando, Country Director/ RPA Lead (APAC)/ Practice Lead for Document Understanding & AI at Boundaryless Group and UiPath MVP. I’m excited about the upcoming Dev Dives session, where I’ll be sharing my insights and experiences with Document Understanding. Togeth…

This post made by @jjes received 3 likes!

Enhancing Video Recording with Queue Recording

A minute ago this didn’t exist, and now I can’t live without it

This post made by @Praveen_Mudhiraj received 2 likes!

UiPath - Flex - Attended - Named User

H! @Ankit_shukla If you purchase the “UiPath - Flex - Attended - Named User” license, you can use UiPath Studio to create automation workflows using C# and run attended automation processes. This license is suitable for users who actively participate in the automation development process and execute attended automations.

Top 3 Most Liked Solutions

This solution provided by @Praveen_Mudhiraj received 2 likes!

UiPath - Flex - Attended - Named User

H! @Ankit_shukla If you purchase the “UiPath - Flex - Attended - Named User” license, you can use UiPath Studio to create automation workflows using C# and run attended automation processes. This license is suitable for users who actively participate in the automation development process and execute attended automations.

This solution provided by @Praveen_Mudhiraj received 2 likes!

Excel matching data from another excel file

HI ! Can you try this Xaml…for your process hope it may help for you Xaml : - Excel matching data from another excel file.zip (2.4 KB) let me know its working or not @ISBS_ROBOT

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

Remove a certain column from excel

hi @Tanu_G kindly use remove data column activity and give the name you want to remove …and then write the data to excel

---

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

Top 3 Topics with Most Views

How to fetch specific values in excel file using LINQ? made by @Soundarya_Guduri1 with 49 views.

Excel Automation writing sheets data into a single sheet made by @Suthari_RohithReddy with 49 views.

マシンフリーズ時の対応方法 made by @h.yasuda with 47 views.

Top 3 Topics with Most Replies

Excel Automation writing sheets data into a single sheet made by @Suthari_RohithReddy with 25 replies.

Argument passing in python script made by @devanshi with 15 replies.

How to fetch specific values in excel file using LINQ? made by @Soundarya_Guduri1 with 12 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 34 posts!

@Praveen_Mudhiraj made 30 posts!

@Yoichi made 18 posts!

Top 3 Most Liked Posts

This post made by @Praveen_Mudhiraj received 2 likes!

How to share the Studio Process to client?

@yeshwanth To share a UiPath automation with a client without providing them with the Studio project file, you can publish the project to Orchestrator and then share it with the client. Here are the steps to do this: Publish the Project to Orchestrator: A. Click on the “Publish” button in the Studio ribbon. B. Choose your Orchestrator instance from the list (you should be connected to Orchestrator). C. Configure the publishing settings, such as the package version and release notes. D. Cli…

This post made by @Praveen_Mudhiraj received 2 likes!

How to share the Studio Process to client?

Ensure that you have the necessary permissions to view and manage environments. Orchestrator permissions are typically assigned by administrators, so contact them if you believe you should have access. @yeshwanth

This post made by @h.yasuda received 1 likes!

マシンフリーズ時の対応方法

URを使用しエラーが出た場合Orchestratorにアラート追加を行いたいと考えております。 その中でマシンがフリーズした場合どのような動作になるのか教えていただきたいです。 ①アクティビティのタイムアウトは機能しますでしょうか？ ②Orchestratorのプロセスタイムアウトの設定以外の方法ありますでしょうか？

Top 3 Most Liked Solutions

This solution provided by @Praveen_Mudhiraj received 1 likes!

.ByField in Excel Question

1.In UiPath’s “Excel Automation” activities, the .ByField property is used to specify how you want to filter or select specific cells or ranges within an Excel sheet. The term “field” here does indeed refer to individual cells or ranges in the Excel worksheet, not necessarily the same as a database field. 2.When you set the .ByField property to a specific value, you’re telling UiPath which criteria to use for selecting cells or ranges. It allows you to interact with Excel data more precisely. T…

This solution provided by @supermanPunch received 1 likes!

How to keep data and the blank rows between data

@Suastrian_Dika , In that case, Maybe you could check the below : DT = DT.AsEnumerable.Skipwhile(Function(x)String.IsNullOrWhiteSpace(x(0).ToString)).CopyToDatatable DT = DT.AsEnumerable.Reverse.Skipwhile(Function(x)String.IsNullOrWhiteSpace(x(0).ToString)).Reverse.CopyToDatatable Debug Panel : [image]

This solution provided by @Yoichi received 1 likes!

マシンフリーズ時の対応方法

こんにちは UiPathが動作しているマシンがフリーズしている状況でしょうか？ ①アクティビティのタイムアウトは機能しますでしょうか？ 期待しない方が良いかと思います。（状況によっては動作するかもしれませんが） ②Orchestratorのプロセスタイムアウトの設定以外の方法ありますでしょうか？ その端末動作は信頼できないと思いますので、何らかの外部の仕組みに頼ることになると思います。

---

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.