Forum Engagement Daily Reports

[system]

Daily Forum Report | 28 December 2022

Top 3 Topics with Most Views

Excel data row copy made by @purnima_mandan with 66 views.

Adding two new column at the end of the excel sheet dynamically made by @sshitol with 61 views.

One help from master i want made by @Shubham_Bidwai with 57 views.

Top 3 Topics with Most Replies

One help from master i want made by @Shubham_Bidwai with 19 replies.

Excel data row copy made by @purnima_mandan with 10 replies.

Filter Particular column made by @sharu_priya with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 46 posts!

@Yoichi made 27 posts!

@kirankumar.mahanthi1 made 13 posts!

Top 3 Most Liked Posts

This post made by @dokumentor received 1 likes!

Unable to display PDF in Task

Hi everybody I am testing Action Center functionality, more specifically displaying pdf files in tasks but I see the following message instead of PDF (Orchestrator is not enabled for this tenant …): [image] Then a loading circle icon is shown but no PDF is displayed [image] Steps followed are: Upload PDF using Upload Storage File Add argument to Form: pdf_storage HTML Content control in form with embed code to display pdf: [image] Has anyone experienced same issue?

This post made by @Vinoth_Kumar_N received 1 likes!

If the developer wants the selector to identify the Notepad by everything but the first character, how should title be replaced?

Thank you!

This post made by @Anil_G received 1 likes!

If the developer wants the selector to identify the Notepad by everything but the first character, how should title be replaced?

@Vinoth_Kumar_N Option C [image] Cheers

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Unable to get values after XML deserialization

Hi, Hope the following sample helps you. [image] Sample20221228-1L.zip (3.2 KB) Regards,

This solution provided by @Yoichi received 1 likes!

Previewing DataTables from Locals Panels

Hi, At this time, it seems no ways except manipulate and modify the string… I think it would be good to have a feature like DataSet/DataTable Visualizer of Visual Studio. [image] Regards,

This solution provided by @Anil_G received 1 likes!

여러개의 파일을 COPY할 수 있는 방법이 있을까요..?

@swkwon1 Change the type argument in for loop properties to string Directory.getfiles will give the complete path so you need not append the path again item is enough 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 | 29 December 2022

Top 3 Topics with Most Views

Add DataTable to another DataTable made by @mateusz.wojcik with 77 views.

How to resolve this issue made by @brahmaiahgogula6677 with 53 views.

Error at updating activities package made by @amy93amanda with 45 views.

Top 3 Topics with Most Replies

How to remove special character from excel column made by @Sandhya_Gajare with 17 replies.

How to handle search result made by @Sandhya_Gajare with 17 replies.

UiPath is reading old value from config excel file made by @kashif.ansari417 with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 41 posts!

@sangeethaneelavannan1 made 29 posts!

@Sandhya_Gajare made 16 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Can i filter all types of dates formats in excel? using linq query

@MitheshBolla Yes you can arrFormats = {"MM/dd/yyyy","MM/d/yyyy","M/dd/yyyy","M/d/yyyy"} datevalue = DateTime.ParseExact(closeDate, arrFormats, System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat) You can use tryparseexact as well Cheers

This post made by @rathishseng received 2 likes!

How to write a variable string to particular header column

Hi Thankyou finally found the cell auto increment method. “C”+(linkedindata.Rows.IndexOf(Row)+2).ToString

This post made by @arivu96 received 1 likes!

"Python Scope: The specified Python path is not valid." Error

Hi @Trevor_Alexander , Welcome to UiPath Forum Please check the python installed file location from your machine. [image] like above image check in from your machine for python and update the path. Regards, Arivu

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Using dictionaries without Microsoft.Activities.Extensions package

@k.entwistle As a work around you can use dictionary directly Dict("key")= value New dictionary(of string,string) can be used for initializing Please check this for work around Cheers

This solution provided by @arivu96 received 1 likes!

How to check if zip file exists in folder or not?

Try below method @Muralikrishna_Surve Method 1 [image] Method 2 File.Exists("F:\Arivu\updatedfile.zip") [image] Regards, Arivu

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

Works perfectly when using breakpoint but not while debugging the process

Hi @Shanmathi , I assume you have three values in the excel and you are entering those values one by one using for each row loop in the web application and for each and every value enter your saving by clicking save button in the website am I right. If my understanding is correct then please follow the suggestion below Debugging with breakpoint will slow down your automation execution pace so your getting enough time to click save button so all the three values saving in the website. As sugg…

---

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

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

[system]

Daily Forum Report | 30 December 2022

Top 3 Topics with Most Views

How to allows users add their own asset credentials in orchestrator made by @private_matter with 54 views.

How to add tag for item in queue made by @Anil_Potekar with 49 views.

The given key is not present in the dictionary made by @venkateshcheeni09 with 47 views.

Top 3 Topics with Most Replies

The given key is not present in the dictionary made by @venkateshcheeni09 with 33 replies.

Date time tadk made by @purnima_mandan with 14 replies.

Need Help to construct dynamic Document Object Model (DOM) made by @Prathap001 with 14 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 33 posts!

@Anil_G made 24 posts!

@arivu96 made 15 posts!

Top 3 Most Liked Posts

This post made by @arivu96 received 4 likes!

Merge multiple rows in one row on basis of rule

Hi @Umer_Shahid , Please refer below xaml file to achive your logic New Microsoft Excel Worksheet.xlsx (10.3 KB) Sequence.xaml (23.3 KB) Regards, Arivu

This post made by @Gokul_Jayakumar received 2 likes!

Excelfile

Hello @Surya_Pawar Kindly Refer to this XAML file, You may get some idea Excel_Column_Read_Dynamical.zip (346.8 KB)

This post made by @Anil_G received 1 likes!

How could I trigger 2 times in different hours?

@pprin001 You can create two triggers at two different times that you need and it should work as expected Instead you can give the control out to orchestrator as well by adding an input argument to the main.xaml file …the input argument can be a true or false value …so when the trigger is created at 4:30 send the value as true and when triggering at 5:30 send value as False…then you need not do any checks and also later if the time changes you need not change anything in the bot rather just ch…

Top 3 Most Liked Solutions

This solution provided by @arivu96 received 4 likes!

Merge multiple rows in one row on basis of rule

Hi @Umer_Shahid , Please refer below xaml file to achive your logic New Microsoft Excel Worksheet.xlsx (10.3 KB) Sequence.xaml (23.3 KB) Regards, Arivu

This solution provided by @Anil_G received 1 likes!

How to allows users add their own asset credentials in orchestrator

@private_matter Create a new role and give the asset edit and view permissions and assign the role to the users cheers

This solution provided by @Anil_G received 1 likes!

Trying to click a menu item on a popup menu that only shows on Hover

@benduong86 Good enough…so if you use selector in the above your tag would mostly be A 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 | 31 December 2022

Top 3 Topics with Most Views

Transaction items not getting pick made by @pravin_bindage with 42 views.

Split string from text? made by @Tuannna1 with 39 views.

Question and answer don't make sense (debugging in studio module) made by @benduong86 with 34 views.

Top 3 Topics with Most Replies

Split string from text? made by @Tuannna1 with 14 replies.

Question and answer don't make sense (debugging in studio module) made by @benduong86 with 12 replies.

Transaction items not getting pick made by @pravin_bindage with 12 replies.

Top 3 Users Who Posted The Most

@arivu96 made 14 posts!

@Prabin_Chand made 11 posts!

@marian.platonov made 11 posts!

Top 3 Most Liked Posts

This post made by @arivu96 received 1 likes!

Happy New Year 2023

Hi Friends, ** Happy New Year 2023** [images (16)] Let us celebrate the dates on which we change the world.” “The object of a New Year is not that we should have a new year. It is that we should have a new soul. Cheers to a new year and another chance for us to get it right.” Regards, Arivu

This post made by @benduong86 received 1 likes!

Question and answer don't make sense (debugging in studio module)

Thank you for the documentation on Hit Count. The value in the column ‘First Name’ changes with every iteration through the loop, so if it’s not ‘Alex’ to start off with, then the condition is not satisfied and therefore Hit Count remains 0. The first time the value changed to ‘Alex’ (i.e. 1st hit), Hit Count is incremented to 1, and the second time First Name = ‘Alex’ (i.e. 2nd hit) Hit Count is incremented to 2. That’s why I picked answer D. Thank you so much for looking up the Hit Count docu…

This post made by @Anil_G received 1 likes!

Question and answer don't make sense (debugging in studio module)

@benduong86 May be I confused you a bit there…let me try like this The condition provided should be met for the breakpoint to be hit …i.e.,when first column is Alex the condition is met so that is when break point ahould be activated. Hit count is the value where the breakpoint starts counting how many times the condition is met…so when alex is there in firat column for the second time the condition with given hit count is net…so from the second time the breakpoint gets activated… only…

Top 3 Most Liked Solutions

This solution provided by @ashwin.ashok received 1 likes!

From dictionary value, get files in folder count

Hi @MikeC , Could you give this a try? Directory.GetFiles(Dict1("PdfFolderPath").ToString).Count() If that doesn’t work, then would you be so kind as to include snapshot of the error message please? Kind Regards, Ashwin A.K

This solution provided by @RajKumar_DC received 1 likes!

Split string from text?

Hi @Tuannna1, What about this Input [image] Output [image] get text Split the get text value like below [image] st.Split(Environment.NewLine.ToArray)(1).Trim.Split("TaxID: ")(1) Thanks,

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

@Anil_G received 79 likes for their solutions!

@Yoichi received 56 likes for their solutions!

@Gokul001 received 20 likes for their solutions!

---

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

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

[system]

Daily Forum Report | 01 January 2023

Top 3 Topics with Most Views

How to find the specific value count in excel made by @Raja.G with 40 views.

How to send API call to Azure Language studio made by @Prathap001 with 31 views.

How to get data from action center form and create new form using same data made by @vijayakumar.qed with 31 views.

Top 3 Topics with Most Replies

How to scrap more than 20 rows from a single webpage which does not contain next button made by @keerthana_E_elumalai_S with 11 replies.

How to find the specific value count in excel made by @Raja.G with 7 replies.

"view or change profile" in uipath studiox not visible made by @Ankush_Pandey with 5 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 4 posts!

@arivu96 made 2 posts!

@Santa_Krish made 2 posts!

Top 3 Most Liked Posts

This post made by @Umarawadee_R received 1 likes!

Not able to see recording option into UIPath studio. Please help me to enable that

This works! Thank you.

This post made by @Kaviyarasu_N received 1 likes!

Happy New Year 2023

Hi Friends, [image]

This post made by @arivu96 received 1 likes!

How to find the specific value count in excel

Hi @Raja.G Please follow below steps 1.use for each row 2.create intmatch count variable and assign value as zero 3. Inside for each row use for each and pass dt.Columns to loop the column 4. Use if condition to check date value match Convert.ToString(row(item)).Contains(“01.01.23”) the increate the count as intmatch=intmatch+1 5. Use if condition intmatch after for each to check the intmatch<4 then follow 6 step 6.use one more foreach to loop datacolumn to identify which column is empty …

Top 3 Most Liked Solutions

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

---

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

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

[system]

Daily Forum Report | 02 January 2023

Top 3 Topics with Most Views

List down reasons to shift to RPA with Uipath made by @Vajrang with 72 views.

How to check if any columns are empty in each datatble at the same time made by @sagar.raval with 60 views.

How to get Windows screen size? made by @RVK with 48 views.

Top 3 Topics with Most Replies

List down reasons to shift to RPA with Uipath made by @Vajrang with 16 replies.

Change column value using LINQ made by @Kaviyarasu_N with 16 replies.

How to check if any columns are empty in each datatble at the same time made by @sagar.raval with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 22 posts!

@Kaviyarasu_N made 12 posts!

@marian.platonov made 12 posts!

Top 3 Most Liked Posts

This post made by @ashwin.ashok received 2 likes!

How to check if specific value contains in 'Select Item' or not?

Hi @Muralikrishna_Surve , You can use the Find Children Activity to fetch a UIElement List and then iterate through the items to check if the items you are looking for are present or not. If its not present then throw a Business Exception. If that is too much of a stretch for you, then you could also try encasing the Select Item Activity within a Try-Catch and handle the exception like so, but I wouldn’t recommend this. Its always best to handle known exceptions through conditional logic. K…

This post made by @karthikayini_P received 1 likes!

Happy New Year 2023

Happy New Year

This post made by @hari6 received 1 likes!

An item with the same key has already been added. Key: VisualBasicValue`1_1 error after upgrading to windows

@Yoichi Thank you it worked. Ideally we have to open the Main xaml in notepad and replace the VisualBasicValue 1_1 if there are multiple. Thanks, Harinath

Top 3 Most Liked Solutions

This solution provided by @marian.platonov received 1 likes!

Como funciona el orquestador

With the orchestrator, how many robots can I monitor or run? No limit. If it’s a single orchestrator with x number of tenants, how many robots can I run per tenant? No limit. You can run robots based on the allocated runtimes per tenant. How does the orchestrator license issue work? Should you have one orchestrator per robot? No, you can have multiple robots set in Orchestrator. For more details, read this documentation:

This solution provided by @Lahiru.Fernando received 1 likes!

How can I extract data from different invoice types?

Hi… Just like Anil mentioned, you will need to use AI models for these types of use cases. The UiPath AI Center offers a large number of pre-trained models that you could try using for Invoices. If that doesn’t work, you can also train your own model using AI Center. This link will also help:

This solution provided by @Sanjit_Pal received 1 likes!

The answer to this log level question looks wrong

Hey @benduong86 Your answer would be SrNo Log Level 6 Critical 5 Error 4 Warning 3 Information 2 Trace 1 Verbose Thanks, Sanjit

---

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

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

[system]

Daily Forum Report | 03 January 2023

Top 3 Topics with Most Views

How to use multiple "Filter" in "For Each File in Folder" Activity? made by @wija with 60 views.

I have to update orchestrator from 2019.10 to 2022.4 made by @Vanitha_VS with 58 views.

How to extract different table data from scanned pdf made by @RAKESH_KUMAR_Tiwari with 56 views.

Top 3 Topics with Most Replies

How can i write the value in existing column made by @Sandhya_Gajare with 32 replies.

How to extract different table data from scanned pdf made by @RAKESH_KUMAR_Tiwari with 28 replies.

How to extract particular subjected mails from list of unread mails? made by @Vaishnav_Tej with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 67 posts!

@Vaishnav_Tej made 23 posts!

@Kaviyarasu_N made 19 posts!

Top 3 Most Liked Posts

This post made by @Kaviyarasu_N received 11 likes!

I have to update orchestrator from 2019.10 to 2022.4

Hi @Vanitha_VS To install AI Center on your on-premises system, you will need to follow these steps: Make sure you have a valid UiPath license that includes the AI Center component. Download the AI Center installer from the UiPath website or your account portal. Install the AI Center software on your on-premises system. This will require a machine with Windows 10 or Windows Server 2016 or later, and at least 8 GB of RAM and 8 CPU cores. You will also need to install .NET Framework 4.7.2 or l…

This post made by @Rahul_Unnikrishnan received 2 likes!

UiPath -Insert Chart & Get Chart activity | How to generate charts & send via email?

Hello All, As part of your automation , maybe you will be getting the requirements to make different charts with the data that you are getting and then to send it via email to respective team members. In UiPath there are activities that helps us to achieve this requirement. Sharing the docs and video demo for understanding the concept. [UiPath -Insert Chart & Get Chart activity | How to generate charts & send via email?| Practical Demo] Thanks

This post made by @ashwin.ashok received 2 likes!

Reframework question

Hi @Akbar_Badhusa , In layman terms, the process will stop only after it finishes processing the current transaction i.e. say you uploaded/dispatched 10 items to queue. If the bot is processing transaction number 5 and you hit stop, the bot will complete processing transaction number 5 before coming to a halt - it won’t stop abruptly unless you kill it. Kind Regards, Ashwin A.K

Top 3 Most Liked Solutions

This solution provided by @Kaviyarasu_N received 11 likes!

I have to update orchestrator from 2019.10 to 2022.4

Hi @Vanitha_VS To install AI Center on your on-premises system, you will need to follow these steps: Make sure you have a valid UiPath license that includes the AI Center component. Download the AI Center installer from the UiPath website or your account portal. Install the AI Center software on your on-premises system. This will require a machine with Windows 10 or Windows Server 2016 or later, and at least 8 GB of RAM and 8 CPU cores. You will also need to install .NET Framework 4.7.2 or l…

This solution provided by @ashwin.ashok received 2 likes!

Excel - Get Specific Range

Hi @esakki1612 , Could you give this workflow a try and let us know if it works out for you? [image] [image] //To find row which contains code dt.AsEnumerable().ToList().FindIndex(Function (x) x("Company Codes").toString.Equals("5000")) //Collects rows until next code dt.AsEnumerable(). Skip(int_rowIndex). TakeWhile(Function(tk,i) i=0 OrElse IsNothing(tk(1)) OrElse String.IsNullOrEmpty(tk(1).ToString.Trim)). CopyToDataTable() FetchRowsBasedonCode.xaml (8.3 KB) Book5.xlsx (8.8 KB) Kind…

This solution provided by @Anil_G received 1 likes!

Multiple selection click with key Control pressed

@Ladimir_Abdala Use Select multiple items activity Or You can do a ctrl down([d(ctrl)]) before the activity of click and then after activity do ctrl up([u(ctrl)]) using type into 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 | 04 January 2023

Top 3 Topics with Most Views

Click Dynamic dropdown item made by @nagsai with 48 views.

How to iterate over all columns of an excel sheet and change colour of specific cells made by @nmjvk with 44 views.

Extract a number from string made by @pravin_bindage with 44 views.

Top 3 Topics with Most Replies

Selector stability made by @Mark_Rajkumar with 21 replies.

Send dynamic email attachement made by @rayz1503 with 21 replies.

Headers are not Shown when copy Table made by @firas with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 59 posts!

@Sudharsan_Ka made 45 posts!

@Yoichi made 33 posts!

Top 3 Most Liked Posts

This post made by @Gnanapriya_G received 4 likes!

How to merge two arrays - month and year

Hi @gischethans, What about this arrYer = {“2022”, “2023”} arrMon = {“Jan”, “Feb”, “Mar”, “Apr”, “May”, “Jun”, “Jul”, “Aug”, “Sep”, “Oct”, “Nov”, “Dec”} (From x in arrYer From y in arrMon Let z=x+"-"+y Select(z)).ToArray() Thanks,

This post made by @Anil_G received 2 likes!

Filtering Datatable Using Array of String

@benjiherb Please try with linq query as below dt.AsEnumerable.Where(function(x) arr.Any(function(y) x("ColumnA").ToString.Contains(y))).CopyToDatatable dt is the datatble arr is the array containing your strings cheers

This post made by @jeffsilva received 1 likes!

Database Connect Activity Broken when Migrating to Windows activity

Hi Maciej, Good guess on the driver, for me it was that the issue. Never thought of checking the version because we have been using the 32 bit with legacy and it was setup a long time ago. Did this just happen to be the case with this activity set (UiPath.Database) or are generally all newer activities Net5+ using 64 bits as a default? Just curious. @taxguy33 I have mine setup on the System, however I use the Oracle Client 19c at the machine level. Might not be your setup. Oracle Database 19c…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Filtering Datatable Using Array of String

@benjiherb Please try with linq query as below dt.AsEnumerable.Where(function(x) arr.Any(function(y) x("ColumnA").ToString.Contains(y))).CopyToDatatable dt is the datatble arr is the array containing your strings cheers

This solution provided by @mahmoud.zaky received 1 likes!

Reframework question

you welcome any time and the right choose is C and i added clarification in below screen hope its help you [image]

This solution provided by @allbran received 1 likes!

データテーブル上の値の変数による指定方法

@HANACCHI 使っている箇所とでスコープが違っている まさしくこれでした。まだUiPath歴が浅いもので何も考えずに宣言したスコープが間違っていたようです。

---

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

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

[system]

Daily Forum Report | 05 January 2023

Top 3 Topics with Most Views

How to store variable value into array? made by @hjie30 with 55 views.

How to add 0000 digits in front of a PDF file name that doesnt contain 7 digits? made by @mce with 46 views.

UiPath Assistant connection issue made by @basiscbm with 44 views.

Top 3 Topics with Most Replies

Expression Activity type 'VisualBasicValue`1' requires compilation made by @Shanmathi with 25 replies.

RPA challenge problem made by @RAKESH_KUMAR_Tiwari with 18 replies.

Excel DateTime Data Insert into Database error made by @mavsp8 with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 51 posts!

@Sudharsan_Ka made 44 posts!

@mahmoud.zaky made 22 posts!

Top 3 Most Liked Posts

This post made by @Vajrang received 6 likes!

How to use and Implement Reframe work in uipath?

In reframework we have multiple stages Make an input excel file with feedback details in one column and emails to next column in respective rows in first run add activity read range and read the excel sheet and output must be assigned to dtTransactiondata Add bulk queue items input is dttransaction Data Queuename to which items must be added in process workflow add send email activity to : inTransactionItem.SpecificContent(“emailKey”) Subject: Feedback Body: inTransactionItem.SpecificC…

This post made by @Vajrang received 4 likes!

UiPath Assistant connection issue

Make sure you are connected to the correct orchestrator where licenses are provided. In Licence management of orchestrator you can assign developer/ attended / unattended license Logout of assistant and login again

This post made by @alexandru.iordan received 2 likes!

Automation Ops - Source Control in Preview

Automation Ops aims to provide the tools you need to create more and better automations following automation development best practices. Source Control Source Control is the newest addition to your toolbox. It improves your productivity as it is designed to provide an overview of your automation source code right from within UiPath platform. You can now browse through all your automations source code, see the version history and what has changed from one commit to another. You no longer need t…

Top 3 Most Liked Solutions

This solution provided by @Vajrang received 6 likes!

How to use and Implement Reframe work in uipath?

In reframework we have multiple stages Make an input excel file with feedback details in one column and emails to next column in respective rows in first run add activity read range and read the excel sheet and output must be assigned to dtTransactiondata Add bulk queue items input is dttransaction Data Queuename to which items must be added in process workflow add send email activity to : inTransactionItem.SpecificContent(“emailKey”) Subject: Feedback Body: inTransactionItem.SpecificC…

This solution provided by @Vajrang received 4 likes!

UiPath Assistant connection issue

Make sure you are connected to the correct orchestrator where licenses are provided. In Licence management of orchestrator you can assign developer/ attended / unattended license Logout of assistant and login again

This solution provided by @Anil_G received 1 likes!

How to merge two arrays - month and year

@gischethans Just use .ToArray at the end 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 | 06 January 2023

Top 3 Topics with Most Views

If row contains specifik value, then send that row, to an email made by @christian.bendtsen with 56 views.

Compare 2 datatables problem made by @sophiey with 48 views.

Regex Pattern - Help made by @Manikandasamy with 46 views.

Top 3 Topics with Most Replies

Not taking DataRow item using in_Transaction item made by @Rakesh_Tiwari with 17 replies.

If row contains specifik value, then send that row, to an email made by @christian.bendtsen with 14 replies.

Extract value from Queue using re-framework made by @Sandhya_Gajare with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 56 posts!

@sangeethaneelavannan1 made 25 posts!

@Gokul001 made 18 posts!

Top 3 Most Liked Posts

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

Monthly Forum rewards - December 2022

Congratulations all the winners. Great achievement @Anil_G. All the best for future awards.

This post made by @RajKumar_DC received 6 likes!

Monthly Forum rewards - December 2022

Congratulations to all of you who are a pillar of helping people and Thank you very much for your continued support @Anil_G | @Yoichi | @Gokul001 Special Thanks for your kind help without any encouragement @Yoichi san | @ppr | @postwick

This post made by @Gokul001 received 5 likes!

Monthly Forum rewards - December 2022

Congrats to all the winners Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Sudharsan_Ka received 1 likes!

How to split a 3 letter or a 2 letter city name from a string

Checkout this @bibinthomas City Name System.Text.RegularExpressions.Regex.Replace(System.Text.RegularExpressions.Regex.Match(ZipCode,"^\S.+(?<=\b.[A-Z])").ToString.Trim,".[A-Z]+$]","").Trim [image] State Name System.Text.RegularExpressions.Regex.Match(ZipCode,"[A-Z]+(?=.\b\d)").ToString.Trim [image] Zip Code System.Text.RegularExpressions.Regex.Match(ZipCode,"\d.*$").ToString.Trim [image]

This solution provided by @Gokul001 received 1 likes!

Regexhelp

Alternative method @Arya_Squares You can also try with Split expression split(split("Case : c123456 > flexible",":")(1),">")(0) [image] Regards Gokul

This solution provided by @Yoichi received 1 likes!

個人でのstudio（studio xではなく）の無料使用は今はできないのでしょうか？

こんにちは 可能てすが、恐らく現在Enterprise のFreeプランが適用されていると思われます。以下一連のトピック参照いただき、いったん組織削除後、コミュニティプランで組織を再作成するのが良いように思えます。

---

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

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

[system]

Daily Forum Report | 07 January 2023

Top 3 Topics with Most Views

Add a data column made by @Manju_Reddy_Kanughula with 66 views.

Trying to find date time dynamically made by @Rakesh_Tiwari with 44 views.

CREATE FOLDER in studio made by @purnima_mandan with 36 views.

Top 3 Topics with Most Replies

Trying to find date time dynamically made by @Rakesh_Tiwari with 16 replies.

Issue in copying the excel sheet made by @Cuberoot with 12 replies.

How to filter outlook mail activity based on multiple parameters made by @rameezimtiaz with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 42 posts!

@supermanPunch made 18 posts!

@Rakesh_Tiwari made 15 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 2 likes!

If the maximum number of retries is reached, how the io_RetryNumber and io_TransactionNumber will be set

Hi @Akbar_Badhusa , Could you Check the RetryCurrentTransaction workflow, the Flow Decision activities are used to Check if the Retry Number is reached the Maximum limit. If reached it is reset to 0. The Transaction Number will increase by 1, so that it will move on processing the next transaction. [image]

This post made by @rameezimtiaz received 2 likes!

How to filter outlook mail activity based on multiple parameters

This worked “[Subject] = '”+subjectTitle+“’ AND [SenderEmailAddress] = '”+sender+“'”

This post made by @rikulsilva received 1 likes!

Abandoned Queue Item in Long-running workflow

Hi all I have a process build in Document Understanding Template. I noticed that when we sent validation to Action Center and takes more than 24 hours to human validate it, the Queue Item status changes to Abandoned. Doc attached says If a long-running workflow is attached to queue processing and the workflow is in a suspended state, the queue item will remain in an in-progress state even beyond 24 hours until the workflow sets the transaction status upon resumption. Queue item identifiers wi…

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

If the maximum number of retries is reached, how the io_RetryNumber and io_TransactionNumber will be set

Hi @Akbar_Badhusa , Could you Check the RetryCurrentTransaction workflow, the Flow Decision activities are used to Check if the Retry Number is reached the Maximum limit. If reached it is reset to 0. The Transaction Number will increase by 1, so that it will move on processing the next transaction. [image]

This solution provided by @rameezimtiaz received 2 likes!

How to filter outlook mail activity based on multiple parameters

This worked “[Subject] = '”+subjectTitle+“’ AND [SenderEmailAddress] = '”+sender+“'”

This solution provided by @allbran received 1 likes!

「テキストを取得」アクティビティで元のタブに戻りUI要素を検索してしまう

自分はモダンデザインを使用しているのでアドバイスいただいたとおりに、 「アプリケーションブラウザを使用」アクティビティを使用してタブをアタッチしたところ ばっちりテキスト取得できました。ありがとうございます！

---

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

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

[system]

Daily Forum Report | 08 January 2023

Top 3 Topics with Most Views

How to add multiple txt content to excel made by @koolrc812 with 57 views.

Duplicated row in Append item to collection made by @Hisham_Alshareef with 45 views.

Decrpyt Credentials on Python code made by @2022learncode with 40 views.

Top 3 Topics with Most Replies

Duplicated row in Append item to collection made by @Hisham_Alshareef with 25 replies.

Reading XML files - Deserialize XML activity made by @RPA_Canada with 10 replies.

Is there any date converter which converts AD to BS? made by @Prabin_Chand with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 19 posts!

@Rawan.md made 11 posts!

@koolrc812 made 8 posts!

Top 3 Most Liked Posts

This post made by @Irina_Butu received 3 likes!

Job stopped with an unexpected exit code: 0xE0434352 - WriteRangeActivity SOLVED

Hello, I have been facing this error when trying to create a 18 row excel file from a datatable. I had no problems creating another dummy excel using this activity but with a different format. Also, I digged deep in all the similar issues opened on this topic. Im using the latest stable ExcelActivity version : 2.16.1, and no downgrade did anything good. Also, my Event Viewer looked like this: [image] [SOLUTION] Pay attention to your column types - It seems that when converting Guid column…

This post made by @ppr received 3 likes!

Reading XML files - Deserialize XML activity

Find following starter help: [grafik] typeArguments of the different fore each are set to XElement: item = xDoc.Root.Descendants("node") item.Attribute("id").Value item2 = item.Elements("property") "Name: " & item2.Attribute("name").Value attrName = {"ref","value"}.Where(Function (x) item2.Attributes.Any(Function (a) a.Name.LocalName.Equals(x))).First() attrName + ": " + item2.Attribute(attrName).Value Log: [grafik]

This post made by @Yoichi received 2 likes!

Trying to find expression

Hi, In recent version (at least 2012.12), there is a case something wrong around UiPath.Excel or UiPath.Excel.Helpers namespace. For example, the following error occurs when use UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex method. [1] I did some tries such as importing UiPath.Excel.Helpers manualy, replace new activity , restarting Studio etc, the problem is solved for some reason… (However when I create a new project, there is same issue.) [2] Regards,

Top 3 Most Liked Solutions

This solution provided by @ppr received 3 likes!

Reading XML files - Deserialize XML activity

Find following starter help: [grafik] typeArguments of the different fore each are set to XElement: item = xDoc.Root.Descendants("node") item.Attribute("id").Value item2 = item.Elements("property") "Name: " & item2.Attribute("name").Value attrName = {"ref","value"}.Where(Function (x) item2.Attributes.Any(Function (a) a.Name.LocalName.Equals(x))).First() attrName + ": " + item2.Attribute(attrName).Value Log: [grafik]

This solution provided by @Yoichi received 2 likes!

Trying to find expression

Hi, In recent version (at least 2012.12), there is a case something wrong around UiPath.Excel or UiPath.Excel.Helpers namespace. For example, the following error occurs when use UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex method. [1] I did some tries such as importing UiPath.Excel.Helpers manualy, replace new activity , restarting Studio etc, the problem is solved for some reason… (However when I create a new project, there is same issue.) [2] Regards,

This solution provided by @Balaji_Murugan received 1 likes!

Append multiple Data Tables in to an existing Excel file starting from a specific column

Hi @Sidney_Vogel , If all the data tables follow the same data structure(at least same number of columns), I would suggest to merge the data tables first using Merge Data Table activity and then write to a specific cell using Write Range.

---

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

Top 3 Topics with Most Views

Invoke Python Method goes into errors! made by @Re_Walter with 60 views.

Add multiple datatable in for each loop made by @arina with 55 views.

How can I add to the collection? made by @rudgns99 with 48 views.

Top 3 Topics with Most Replies

Read excel content certain words and email made by @koolrc812 with 22 replies.

Erro Could not find a part of the path ...'\1.0.7\content\project.json' made by @guilherme.dias with 15 replies.

Project Notebookを最前面に出さない方法 made by @11159 with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 65 posts!

@Kaviyarasu_N made 36 posts!

@supermanPunch made 18 posts!

Top 3 Most Liked Posts

This post made by @postwick received 2 likes!

How to Convert string 1234567890 to 123,45,67,890.00 this format

You want to use ToString(“#,#.##”) The 00 in your format will always explicitly put two 0s, not two decimal places.

This post made by @Anil_G received 2 likes!

Read excel content certain words and email

@koolrc812 Did you change the type argument in for loop properties to string? Change that and it should solve that issue…hope this helps Cheers

This post made by @Jacqui_M received 1 likes!

Copy Excel data with all colors and all format

Hey @Merlin_Joseph, welcome to the forum. I would highly suggest installing the BalaReva.Excel.Activities, as mentioned by @balupad14 further up: Copy Excel data with all colors and all format - #8 by balupad14 It works really well and I think it may solve your issue.

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

How to Convert string 1234567890 to 123,45,67,890.00 this format

Hi @Anil_Potekar , Could you Check with the below Expression : CDbl("1234567890").ToString("#,###.00") or CDbl("1234567890").ToString("N",new CultureInfo("hi-IN")) Let us know if this doesn’t work

This solution provided by @supermanPunch received 1 likes!

How to format specific cell in Excel

Hi @nmjvk , Could you try changing the Cell to Range and Check if it works ? Excel.Sheet("Ark1").Range(UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(j+252)+(i+1).ToString+":"+UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(j+252)+(i+1).ToString) If the above works, I would suggest to assign the value to a variable, so as to ease the repeated use of the same value.

This solution provided by @supermanPunch received 1 likes!

How can i convert dd/mm/yyyy to get the day name?

Hi @Rowley101 , Could you Check with the below Expression : DateTime.ParseExact("09/01/2023","dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture).DayOfWeek.ToString

---

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

Top 3 Topics with Most Views

How to find the specific value count in excel using LINQ made by @Raja.G with 62 views.

Get latest email from gmail made by @swapnil.soni with 60 views.

Excel cell value to email body made by @koolrc812 with 50 views.

Top 3 Topics with Most Replies

How to find the specific value count in excel using LINQ made by @Raja.G with 24 replies.

Excel cell value to email body made by @koolrc812 with 23 replies.

For start-up company: how to buy in order to resell UiPath licenses for 1st company client? made by @IPIX with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 80 posts!

@Yoichi made 25 posts!

@sangeethaneelavannan1 made 23 posts!

Top 3 Most Liked Posts

This post made by @Kyleb91 received 3 likes!

Package Download not containing .Xaml files

Hi @sangeethaneelavannan1 yes, now there is a _rels folder and file, a content folder with the project minus the xaml files, lib folder with .dll extension files, and package with metadata. Along with a [Content_Types] XML Doc file and Process NUSPEC File…

This post made by @Hiba_B received 2 likes!

Table extraction is now available in Studio Web

Hi @gheorghestan ! I will add another comment tonight to give feedback on its use with a concrete use case, but here is the first feedback on the launch of extract table: It would be great if all the extracting tools (for studio web but also studio) would use and be compatible with already installed extensions Example: I have the extension 22.4 thanks to UiPath Studio Enterprise, and Studio web wants me to use 22.5. Is it because of technical limits and thus studio web absolutely needs…

This post made by @supermanPunch received 2 likes!

S100:S101 Excel Automation Data Size Limitation

Hi @Harsha_S1 , Could you Check on the below clarification provided : [image] Yes, We should be able to work with Queues without using RE-Framework as well. However, we would need to implement the same logic or transitions as done in an RE-Framework to handle the different scenarios. Also, We could do the operations without using Queues as well, It all depends on whether the Process is well suited for the Queue Design or the normal way of looping data in a Datatable/List/Collection and pro…

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

S100:S101 Excel Automation Data Size Limitation

Hi @Harsha_S1 , Could you Check on the below clarification provided : [image] Yes, We should be able to work with Queues without using RE-Framework as well. However, we would need to implement the same logic or transitions as done in an RE-Framework to handle the different scenarios. Also, We could do the operations without using Queues as well, It all depends on whether the Process is well suited for the Queue Design or the normal way of looping data in a Datatable/List/Collection and pro…

This solution provided by @Kyleb91 received 1 likes!

Package Download not containing .Xaml files

Hey! Found the solution, must tick Include Source Files in the Publish Options when publishing the package!

This solution provided by @Yoichi received 1 likes!

Empty space problem

Hi, Can you try the following expression? Variable.split({","},stringsplitoptions.RemoveEmptyEntries).Select(Function(s) s.Trim()).ToArray() Regards,

---

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

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

[system]

Daily Forum Report | 11 January 2023

Top 3 Topics with Most Views

Extract from https response made by @langsem with 61 views.

Skipping Ads on YouTube made by @URK20RA1037_SAM_ASHWIN with 55 views.

Converting Pdf table to excel made by @Amit_Kumar_Charde with 50 views.

Top 3 Topics with Most Replies

How to read tag from api response made by @Sandhya_Gajare with 23 replies.

Converting Pdf table to excel made by @Amit_Kumar_Charde with 21 replies.

How Can I Read Tag from XML response made by @Sandhya_Gajare with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 54 posts!

@Kaviyarasu_N made 36 posts!

@Sandhya_Gajare made 29 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 3 likes!

How to identify Openforwork people in LinkedIn search

Hi @rathishseng, I have to agree with @Parth_Doshi, try not to get yourself black listed from crawling using UI automation on Linkedin especially, if you are using your own Linkedin credentials. Linkedin can track your public IP and in the worstcase block your entire public IP from accessing linkedin. Just an heads up, it may not happen, but it can happen Do read which bot agents are allowed and which arent. Almost all websites with personal data have strict crawling requirement…

This post made by @Dawid_Nguyen received 2 likes!

Get latest email from gmail

to make this easier. You can create special label in your Gmail that will automatically store all emails from that specific person. Then you can make robot to fetch email from that Label only.

This post made by @charliefik received 2 likes!

Best Practice for interacting with Databases (opening and closing DB connection)

Thanks Anil and Vish. I’ll go with the open in init and close in end process (if using framework)

Top 3 Most Liked Solutions

This solution provided by @marian.platonov received 2 likes!

How to update the Robot Credentials using API for Modern Folders

You can try this approach: Robots Requests [1]

This solution provided by @Piotr_Gajewski received 1 likes!

SQL Run query - Missing provider Error

Hi, so I installed Oracle drivers and also .Net 4.8 drivers but that did not solve the issue, the “Bad IL format” error still exists, however I was experimenting with Connection String and finally I found out that this was a problem! I have used below pattern and it’s worked: “Data Source=IpAddress\optima,PortNumber;Initial Catalog=master;User ID=varDataUser;Password=varDataPassword;Trust Server Certificate=true” where: IpAddress is like: 192.xyz.x.xyz PortNumber is like: 12345 varDataUser:…

This solution provided by @BogdanTod received 1 likes!

How to identify Openforwork people in LinkedIn search

Hi @rathishseng, I found out there is part of the selector that makes difference between the profile pictures that are framed and the ones that are not. This is the selector attribute “url” of regular profile picture: [image] This is the one that has a frame (“Open To Work”): [image] You just need to build appropriate selector to target the ones which have “profile-framedphoto-shrink” word in the src. Regards, Bogdan

---

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

Top 3 Topics with Most Views

How to get file using uipath apps? made by @Vanitha_VS with 44 views.

Flow Decision - Step by step Debug Run - Visual Issue made by @hans.gunnoo with 42 views.

Delete Rows: Exception from HRESULT: 0x800A03EC made by @WICAKSONO_Hanif with 42 views.

Top 3 Topics with Most Replies

How to get the IMAP Gmail port made by @krishna_priya1 with 13 replies.

Use Application/Browser Output made by @prerna.gupta with 13 replies.

Delete Rows: Exception from HRESULT: 0x800A03EC made by @WICAKSONO_Hanif with 13 replies.

Top 3 Users Who Posted The Most

@Sudharsan_Ka made 43 posts!

@Yoichi made 27 posts!

@Gokul001 made 22 posts!

Top 3 Most Liked Posts

This post made by @StefanPrajica received 2 likes!

Select one button/row in ALV grid fails

Hello Laura, I managed to reproduce the scenario and I have the following suggestion for creating the selector to automate this kind of checkboxes (the selector text is in English due to locales but the structure should be the same). I have tried anchoring the checkbox to the Text cell next to it but it does not work since for the checkbox we only have the tableRow attribute exposed. The only reliable working scenario seems to be this: First you should use a Get Attribute activity and indica…

This post made by @private_matter received 2 likes!

Ability To Generate Number Of Cases In Switch Activity

I would like to suggest a useful feature request in the switch activity if we can generate any number of cases for any variable type. I had more than 300 key cases in my project and I literally enter each number manually which took me a lot of time. It would be better if we can set a number and have the cases autogenerated quickly. Thanks for the consideration.

This post made by @nino.dy received 2 likes!

Modern Design: Use Excel File loads very slow

Hello everybody, I am reaching out to the community since I am stuck with this problem: I got several projects which have loading issues when using the ‘Use Excel File’ scope. It takes about 1,5 Minutes to open the Excel Files each time. I don’t understand what is taking Studio so long to open the files. In rare cases it will only take seconds, but mostly it is 1,5 minutes. The problems occur on Version 2021.4 and 2022.x (I would need to check the exact version, but it is not the newest rele…

Top 3 Most Liked Solutions

This solution provided by @StefanPrajica received 2 likes!

Select one button/row in ALV grid fails

Hello Laura, I managed to reproduce the scenario and I have the following suggestion for creating the selector to automate this kind of checkboxes (the selector text is in English due to locales but the structure should be the same). I have tried anchoring the checkbox to the Text cell next to it but it does not work since for the checkbox we only have the tableRow attribute exposed. The only reliable working scenario seems to be this: First you should use a Get Attribute activity and indica…

This solution provided by @marian.platonov received 1 likes!

Not able to see the xaml file from the extracted .nupkg file

It seems that when you published the process from Studio to Orchestrator you didn’t choose the Source files option. [image] Republish the project and then check again. Note: Include Sources - select this option to package all .xaml sources within the published package, including workflows that were previously made private. For Windows - Legacy libraries, the files are saved in the generated assembly file and in the lib\net45 folder in the .nupkg file. For Windows and cross-platform librar…

This solution provided by @Yoichi received 1 likes!

Variable type error

Hi, Can you try the following expression? ID = CInt(CurrentRow("id")) 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 | 13 January 2023

Top 3 Topics with Most Views

Reading an Excel file issue made by @vinjam_likitha with 45 views.

Anyone having solution of my problem made by @Shubham_Bidwai with 44 views.

Error entering email address - 'End of expression expected.' made by @gerry.d.hayes with 42 views.

Top 3 Topics with Most Replies

Folder path can’t be accessed made by @wija with 22 replies.

Reading an Excel file issue made by @vinjam_likitha with 17 replies.

Anyone having solution of my problem made by @Shubham_Bidwai with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 37 posts!

@Yoichi made 27 posts!

@Sudharsan_Ka made 24 posts!

Top 3 Most Liked Posts

This post made by @laura.groeger received 2 likes!

Select one button/row in ALV grid fails

Hi Stefan, perfect - thanks a lot for the fast solution! Your way of handling it worked for me Have a great day/weekend! Laura

This post made by @mahmoud.zaky received 2 likes!

How to Run the Project on the Other System without having Uipath installed

Hi @Akbar_Badhusa, all you need is to install UiPath Assistant on this machine and connect it to your orcastrator 1- Need to publish your project to Orcastrator. 2- Install UiPath Assistant on your machine Windows or MAC. 3- Connect UiPath Assistant to your Orcastrator. 4- Run your process from Assistant. find below URL will help also to do above steps:

This post made by @miwa_yamamoto received 2 likes!

Conversion from string "-" to type 'Integer' is not valid

Yoichi様 お陰様でエラーを抜けることができました。 いつも本当にありがとうございます。

Top 3 Most Liked Solutions

This solution provided by @BCod received 2 likes!

Windows compatibility issues with Windows-Legacy

UPDATE: My problem was solved here: This underscores the importance of having an all-inclusive post that is easy for customers to find. The update from Windows-Legacy to Windows is not a smooth process by any means.

This solution provided by @Yoichi received 1 likes!

Conversion from string "-" to type 'Integer' is not valid

こんにちは 列Column1に不正なデータ：おそらく"-"だけのデータが含まれていると思いますので まずはデータをチェックしてみてください。

This solution provided by @Anil_G received 1 likes!

Skip activity when retry same transaction

@Sathish_Kumar_S You can create condition using it…And that would be available only when you use queues. 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 | 14 January 2023

Top 3 Topics with Most Views

How to find matching values in two excel sheet made by @Raja.G with 38 views.

2 mins time delay made by @Omkar_Shete1 with 33 views.

Function and methods related to Datatable made by @_Anish with 30 views.

Top 3 Topics with Most Replies

2 mins time delay made by @Omkar_Shete1 with 9 replies.

Variable string array not working in Invoke Workflow made by @private_matter with 8 replies.

LINQ Query for matching row from another Excel column and update the Result made by @Shubham_Arora1 with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 25 posts!

@wija made 11 posts!

@supermanPunch made 9 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 1 likes!

Regex results to a 1 column datatable

Hi @Sc100 , Have you tried executing with that settings/Regex Expression ? It does not necessarily indicate always the capturing of all the lines. Check by executing first and let us know if you are still not able to get the results.

This post made by @Sc100 received 1 likes!

Regex results to a 1 column datatable

Hey, that did it. Thank you for the tip! Also, big shout out to Steve for stepping in with the regex pattern! You both helped a ton.

This post made by @Yogesh1 received 1 likes!

How to Run the Project on the Other System without having Uipath installed

You cannot run without UiPath assistant or studio and yes it is available in mac.

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

Regex results to a 1 column datatable

Hi @Sc100 , Have you tried executing with that settings/Regex Expression ? It does not necessarily indicate always the capturing of all the lines. Check by executing first and let us know if you are still not able to get the results.

This solution provided by @wija received 1 likes!

Folder path can’t be accessed

@Yogitha_S1 never mind, because i already have my solution.

---

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

Top 3 Topics with Most Views

PDF to Excel Table Extraction made by @Hardik_Durgam with 35 views.

How to find header data in excel made by @Mohammed_Nawazuddin with 29 views.

How many languages are Re:Infer support? made by @donghai with 26 views.

Top 3 Topics with Most Replies

"Run Spreadsheet Macro" saying that I Cannot run the macro made by @Thomas.Dettmer with 6 replies.

How to find header data in excel made by @Mohammed_Nawazuddin with 6 replies.

PDF to Excel Table Extraction made by @Hardik_Durgam with 4 replies.

Top 3 Users Who Posted The Most

@Anil_G made 25 posts!

@supermanPunch made 5 posts!

@Thomas.Dettmer made 4 posts!

Top 3 Most Liked Posts

This post made by @Thomas.Dettmer received 2 likes!

"Run Spreadsheet Macro" saying that I Cannot run the macro

Hi Anil, I figured it out! I had saved my macros under a certain spreadsheet as opposed to putting them in a Module. I guess I wasn’t being detailed enough with my descriptions. So I should have originally listed my macro as “Sheet1.A_ImportTemplateAndClearOutOldData” instead of “A_ImportTemplateAndClearOutOldData”. for anyone else out there with this issue, if you switch the option to “All open workbooks” like in the screenshot below, you’ll get the proper name you should put into the UiPath…

This post made by @Hiba_B received 1 likes!

"Run Spreadsheet Macro" saying that I Cannot run the macro

That’s great to know: thank you for the tips ! Don’t forget to mention your answer as the solution, so the thread closes and thus helps other users

This post made by @supermanPunch received 1 likes!

PDF to Excel Table Extraction

Hi @Hardik_Durgam , Could you check if the workflow provided in the below post works for your case ?

Top 3 Most Liked Solutions

This solution provided by @Thomas.Dettmer received 2 likes!

"Run Spreadsheet Macro" saying that I Cannot run the macro

Hi Anil, I figured it out! I had saved my macros under a certain spreadsheet as opposed to putting them in a Module. I guess I wasn’t being detailed enough with my descriptions. So I should have originally listed my macro as “Sheet1.A_ImportTemplateAndClearOutOldData” instead of “A_ImportTemplateAndClearOutOldData”. for anyone else out there with this issue, if you switch the option to “All open workbooks” like in the screenshot below, you’ll get the proper name you should put into the UiPath…

This solution provided by @Anil_G received 1 likes!

How to set "Timeout" For email Trigger Activity

@Karam_Abulawi Then why do you need email trigger? You just need to do get emails when needed and check if any email is received….and in properties you have only unread can check it…and when you read the email…check mark as read or move to a different inbox 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 | 16 January 2023

Top 3 Topics with Most Views

How to write full month name from a date? made by @makboga with 45 views.

同じデータで実行しても、不規則にエラーが出る made by @nagahama-digital with 44 views.

7時30分の表記を「7:30」⇒「7.50」に変更する方法はあるでしょうか。 made by @T_Hirao1 with 41 views.

Top 3 Topics with Most Replies

Office 365 email multiple attachments made by @sairama.deepthi with 19 replies.

複数の宛名のメール送信について made by @a.kmni with 17 replies.

Save for later Option made by @YUGAN_NITHISH_KUMAR with 11 replies.

Top 3 Users Who Posted The Most

@ppr made 21 posts!

@Yoichi made 20 posts!

@Anil_G made 20 posts!

Top 3 Most Liked Posts

This post made by @s.bruce received 5 likes!

Jira activites vs. WebAPI activities, RestSharp mismatch

Continuing the discussion from Method not found: 'Void RestSharp.Parameter…ctor(System.String, System.Object, RestSharp.ParameterType)': Staying on WebAPI 1.9.2 is not a suitable solution in our case, as it prevent us from using essential functionality in the later versions (eg. reponse content output). Upgrading WebAPI breaks every one of our Jira scopes on version 2.4.1 of the Jira activities package, rendering our automated ticketing solution useless. Will the Jira package ever be updated t…

This post made by @Niwa received 2 likes!

UiPathアカデミーにログインしようとするとRaven360にリダイレクトされる

先ほど改めてログインしたところ、問題なくマイページに遷移できました。 [image] 実は月初も同じ症状が起きていて、しばらくすると自動的に解消するようになった経緯があります。 UiPathテクニカルサポートにも確認してみます。 @Anil_G Thank you for your comment! @cheez_RPA 岩崎さん、ご回答ありがとうございました。

This post made by @shesherao.patil received 1 likes!

Add data row error lambda expression

yes this is working.

Top 3 Most Liked Solutions

This solution provided by @cheez_RPA received 1 likes!

Manifestのバージョンが上がらない

お使いの端末が組織によってコントロールされているケースでは、個々人の対応のみではアップデートされないケースがあります。 具体的には、グループポリシーによってChrome/Edgeに導入される拡張機能が固定されている可能性があります。情報システムの管理部門等へお問い合わせいただくことをおすすめします。

This solution provided by @Yoichi received 1 likes!

Excelを作成したい

こんにちは 例えば以下になると思います。 [image] 以下の式で会社名の重複のない一覧を文字列配列で作成していますが、繰り返しアクティビティ等で 置き換えることもできます。 companies = dt.AsEnumerable.Select(Function(r) r("会社名").ToString).Distinct.ToArray Sample20230116-2L.zip (16.1 KB)

This solution provided by @Yoichi received 1 likes!

Error BC32017, BC30035, BC30516

Hi, Can you try either of the following? hqnosw.Replace(" "+hqnosw.Split(" "c).Last,"") OR hqnosw.Replace(" "&(hqnosw.Split(" "c).Last),"") Regards,

---

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

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