Forum Engagement Daily Reports

[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.

[system]

Daily Forum Report | 17 January 2023

Top 3 Topics with Most Views

Hi i want solution made by @Shubham_Bidwai with 59 views.

FilePicker control doesnt return full path made by @corinna.robertson with 47 views.

Regex Extractor and new line made by @jjes with 44 views.

Top 3 Topics with Most Replies

Hi i want solution made by @Shubham_Bidwai with 49 replies.

How to click on specific part of an application without worrying about UI element made by @nmjvk with 20 replies.

Regex Extractor and new line made by @jjes with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 50 posts!

@supermanPunch made 34 posts!

@Shubham_Bidwai made 31 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

How can I extract some data from a JSON file?

validating the access path: [grafik] retrievals: [grafik]

This post made by @ppr received 2 likes!

Multiple addresses in the config file

the activity expects the following: [grafik] A string Array which would be similar as hardcoded: {"xyz@gmail.coml","xyz2@gmail.com"} As you mentioned the Config file: we would assume e.g. the config as we are using in REF So we store there a string, seperated with a well known delimiter char, and split it later, to get back the string array: [grafik] e.g.: YourConfigVar("YourKey").toString.Split("|"c)

This post made by @Marius_Stan received 1 likes!

UiPath Chrome Manifest V3 Extension Released with 2022.4 Update

Hello @sishiramishra ! Indeed, Chrome has pushed back the deadline for the MV2 cutoff. What this means for you is that you are no longer forced by Chrome to upgrade to an UiPath version that has MV3 extensions for Chrome/Edge. But eventually Chrome/Edge will force the transition to MV3. And UiPath is prepared for that - all existing and future versions of UiPath will install MV3 extensions for Chrome/Edge.

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

How can I extract some data from a JSON file?

validating the access path: [grafik] retrievals: [grafik]

This solution provided by @ppr received 2 likes!

Multiple addresses in the config file

the activity expects the following: [grafik] A string Array which would be similar as hardcoded: {"xyz@gmail.coml","xyz2@gmail.com"} As you mentioned the Config file: we would assume e.g. the config as we are using in REF So we store there a string, seperated with a well known delimiter char, and split it later, to get back the string array: [grafik] e.g.: YourConfigVar("YourKey").toString.Split("|"c)

This solution provided by @Yoichi received 1 likes!

Vlookup Modern Activity

Hi, Do you have any error? I think it’s not necessary to indicate Range and Column Index should be 2, as the following [image] Sample20230117-3L.zip (9.1 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 | 18 January 2023

Top 3 Topics with Most Views

How to Add Products on Home Page? made by @Vaishnav_Tej with 42 views.

Excel: Execution is very slow made by @pushkar.singh with 41 views.

The given key was not present in the dictionary in process transaction uipath made by @Manoj_sreekanth with 39 views.

Top 3 Topics with Most Replies

The given key was not present in the dictionary in process transaction uipath made by @Manoj_sreekanth with 20 replies.

Regex email from pdf issues made by @MikeC with 14 replies.

Excel: Execution is very slow made by @pushkar.singh with 14 replies.

Top 3 Users Who Posted The Most

@Sudharsan_Ka made 37 posts!

@sangeethaneelavannan1 made 27 posts!

@Anil_G made 26 posts!

Top 3 Most Liked Posts

This post made by @vishnuvarthanp received 3 likes!

Macro excel background

Hi @DimitriLYR it is possible to execute the macro without opening . please use execute macro activity inside excel application scope and provide the macro name in the activity . You need to use the macro name and not the button name. [image]

This post made by @ppr received 3 likes!

New Activity Idea - Comment with Image Data / Informative Screenshot

Idea: extend the comment activity on also storing an image or have an alternate activity Background For several reasons (documentation, knowledge transfer to team members) an illustrating screenshot would help. Extending the comment activity for defining screenshots or offering an additional activity could serve for it. Similar to other activities following functionalities should be offered for manually execution: Take informative screenshot Show Informative screenshot remove Informative s…

This post made by @indra received 2 likes!

Regex email from pdf issues

@MikeC Try this Regex [image]

Top 3 Most Liked Solutions

This solution provided by @vishnuvarthanp received 3 likes!

Macro excel background

Hi @DimitriLYR it is possible to execute the macro without opening . please use execute macro activity inside excel application scope and provide the macro name in the activity . You need to use the macro name and not the button name. [image]

This solution provided by @indra received 2 likes!

Regex email from pdf issues

@MikeC Try this Regex [image]

This solution provided by @indra received 1 likes!

Cannot create cultureinfo variable in Windows mode

@alvaro.nobre If there is any double quotes means remove and add double quotes

---

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

Top 3 Topics with Most Views

How to get the difference in years based on current date made by @Kunal_Jain with 45 views.

I want to loop only one row from excel in flowchart is there any way I can do that just passing number to iterate? made by @Bhushan_Nagaonkar with 39 views.

String to Double Datatable LinQ made by @DimitriLYR with 38 views.

Top 3 Topics with Most Replies

For join data table made by @Shubham_Bidwai with 19 replies.

I want to loop only one row from excel in flowchart is there any way I can do that just passing number to iterate? made by @Bhushan_Nagaonkar with 15 replies.

How to get the difference in years based on current date made by @Kunal_Jain with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 57 posts!

@indra made 18 posts!

@sangeethaneelavannan1 made 17 posts!

Top 3 Most Liked Posts

This post made by @Sushma_Ganapatisa received 2 likes!

You successfully published a package from UiPath Studio to Orchestrator. You did not make any changes to the work, and then published it a second time successfully. When you go into Orchestrator, what will have happened?

Hello Team, Scenario: You successfully published a package from UiPath Studio to Orchestrator. You did not make any changes to the work, and then published it a second time successfully. When you go into Orchestrator, what will have happened? Options are : The package will generate an alert that no changes were made in Orchestrator A new version of the project is sent to Orchestrator only if the Release Notes for the second publish were populated A new version of the project is sent t…

This post made by @vishnuvarthanp received 2 likes!

I want to loop only one row from excel in flowchart is there any way I can do that just passing number to iterate?

Hi @Bhushan_Nagaonkar Please check the below ss: [image]

This post made by @Manoj_sreekanth received 1 likes!

Get only todays files from folder

Facing Error: ‘FileInfo’ is a type and ‘IO’ cannot be used as an expression

Top 3 Most Liked Solutions

This solution provided by @indra received 1 likes!

Check if in string there are 18 digits

@camaro123 You can use regex.ismatch so it will give Boolean result System.Text.RegularExpressions.Regex.IsMatch(str_PdfResult,“(\d{18})”).ToString [image]

This solution provided by @Anil_G received 1 likes!

Unable to Downgrade Package Windows Version Studio

@Kyleb91 This means aome activity needs this specific version of activity to function properly… So first remove the dependecy and then downgrade Cheers

This solution provided by @Anil_G received 1 likes!

SAP-FIORI data table

@dinesh.s1 Use ui explorer and check for static parts in selector 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 | 20 January 2023

Top 3 Topics with Most Views

How to insert variable in open browser link made by @Riya_Bansal with 43 views.

How to split an address to a new life if it is too long? made by @NervousTuber with 42 views.

How to check if a click element is enabled or disabled made by @krishna_r with 41 views.

Top 3 Topics with Most Replies

I have one question and can ane one help me for the solution made by @Shubham_Bidwai with 18 replies.

How to insert variable in open browser link made by @Riya_Bansal with 13 replies.

Where can I find published projects made by @Povilas_Jonikas with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 66 posts!

@Yoichi made 23 posts!

@Sudharsan_Ka made 12 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

How to Extract the fields from pdf using Regex

HI, Can you try the following sample? [image] mc = System.Text.RegularExpressions.Regex.Matches(strData,"^(?<INVREF>\S+)\s+(?<POSTDATE>\d{2}/\d{2}/\d{4}).*?(?<INVDATE>\d{2}/\d{2}/\d{4})\s+(?<GROSSAMOUNT>[-\d.,]+)\s+(?<TDS>[-\d.,]+)\s+(?<AMOUNT>[-\d.,]+)",System.Text.RegularExpressions.RegexOptions.Multiline) Then, set the following at ArrayRow {m.Groups("INVREF").Value,DateTime.ParseExact(m.Groups("POSTDATE").Value,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture),DateTime.Pa…

This post made by @fernando_zuluaga received 2 likes!

How to focus on next tab after click

Hey After clicking that button, use another attach browser activity or use application/browser activity to capture the next page, and then perform your process inside that activity

This post made by @J0ska received 2 likes!

Documentation of uipath

Dear @nora_ziani @ppr wrote you polite and relevant response. In case you want to use such offensive tone pls leave this community. Cheers

Top 3 Most Liked Solutions

This solution provided by @Kalpesh_Chaudhari received 2 likes!

Object reference not set to an instance of object in getText

if still error persists, then try to initialize the variable at start and assign empty string to it.

This solution provided by @Yoichi received 1 likes!

How to split an address to a new life if it is too long?

Hi, Is it no problem if length of 2nd line is greater than 20? If yes, the following regex will work [image] System.Text.RegularExpressions.Regex.Replace(yourString,"^(.{0,20}) ","$1"+vbcrlf) Regards,

This solution provided by @Yoichi received 1 likes!

How to Extract the fields from pdf using Regex

HI, It seems difficult to identify which string should be added to INV.REF string in the previous line. [image] If string to be added always consists of numeric characters at the beginning of the line, the following will work. (However, i suppose it may not work as there are various cases…) [image] Sample20230120-3Lv2.zip (4.6 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.