Forum Engagement Daily Reports

[system]

Daily Forum Report | 13 December 2022

Top 3 Topics with Most Views

How to convert data variable get from "for each ui element" into datatable for database insertion? made by @hjie30 with 43 views.

Need help in sending API request made by @Learner007 with 41 views.

Compare string with excel column values made by @pravin_bindage with 39 views.

Top 3 Topics with Most Replies

Need help in sending API request made by @Learner007 with 24 replies.

How to convert data variable get from "for each ui element" into datatable for database insertion? made by @hjie30 with 18 replies.

Adding data into data table made by @Abdul_Khaliq1 with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 104 posts!

@Yoichi made 37 posts!

@sangeethaneelavannan1 made 30 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

Selectors are not editable

Hi, It’s because you use this inside OpenBrowser or AttachBrowser activity and top level selector is inherited from the activity. if you need to edit this, can you try to put the activity outside OpenBrowser or AttachBrowser, and indicate the target element, then edit. Regards,

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

Document understanding error while copying to a stream

i tried using machine learning extractor on a 27-page pdf and it threw this exception after a minute of waiting [image] but it works fine for smaller pdfs e.g. 1-10 pages

This post made by @Anil_G received 1 likes!

Document understanding error while copying to a stream

Hi @jack.chan It has some limitations. Please check this [image] cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Document understanding error while copying to a stream

@jack.chan Please check this…This can be thrown when the size is huge as well And also there is a per page pixel limit which might be exceeded as well. if you are getting the same exception multiple times …then try checking with lesser pages .That would give you an idea on the limit… If it occurred only once there might be some connection issues cheers

This solution provided by @Anil_G received 1 likes!

How to get numbers in correct format

Hi @mohamedalthaf Please check this cheers

This solution provided by @Anil_G received 1 likes!

Repeated files when using ForEachFileX activity

@camilacalderon I guess Include sub folders is checked both in foreachFolderX and in foreachfileX which makes each folder traverse twice…Please uncheck Include subfolders in FOreachFolderx loop and if you need check it only in the FOrEachFileX that way each folder is traversed only once [image] This the case where multiple files are coming 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 December 2022

Top 3 Topics with Most Views

Get all against unique value in row made by @sshitol with 41 views.

How to get Specific value using Matches activity? made by @Vaishnav_Tej with 38 views.

How to automate Captcha made by @Sankaraveni_M with 38 views.

Top 3 Topics with Most Replies

Each excel row activity made by @Nur_Amin with 18 replies.

OmniPage package error: made by @krishna_priya with 17 replies.

Get all against unique value in row made by @sshitol with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 81 posts!

@Yoichi made 41 posts!

@Gokul001 made 29 posts!

Top 3 Most Liked Posts

This post made by @Gokul_Jayakumar received 2 likes!

How to get Specific value using Matches activity?

Dowload the packages from manage packages UiPath.pdf.activities [image]

This post made by @Anil_G received 2 likes!

Is this available to automate this kind of workflow?

Hi @pprin001 Yes it is possible You can use table extraction to extract all the data as is from the website into a datatable Read the excel data into another datatble Run a loop on website datatable(dtweb)(in arguments assign index variable) Check if the index < dtexcel.rowcount-1 On then side check if data is present in excel daatatable by using if condition to check currentrow(0).tostring.trim.equals(dtexcel.rows(index).tostring this condition is for checking first column similarly you can…

This post made by @Anshdeep_Tyagi received 1 likes!

Activity Creator with .NET 6 Support is now released

Hi @mdiv Thankyou it is working fine now.

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Is this available to automate this kind of workflow?

Hi @pprin001 Yes it is possible You can use table extraction to extract all the data as is from the website into a datatable Read the excel data into another datatble Run a loop on website datatable(dtweb)(in arguments assign index variable) Check if the index < dtexcel.rowcount-1 On then side check if data is present in excel daatatable by using if condition to check currentrow(0).tostring.trim.equals(dtexcel.rows(index).tostring this condition is for checking first column similarly you can…

This solution provided by @Gokul_Jayakumar received 1 likes!

How to get Specific value using Matches activity?

Hello @Vaishnav_Tej Based on your input, we need to frame the regex condition. The document also should be in the desired format. For Regex need, share your input and expected output, it help us to provide you a better solution Kindly refer to this link, it may help you

This solution provided by @Anil_G received 1 likes!

Convert Word Files into PDFs without using Word Application Scope

Hi @DarDarSara Try using this [image] Dim MyApp As New Microsoft.Office.Interop.Word.Application MyApp.Visible = False Dim MyDoc As Microsoft.Office.Interop.Word.Document = MyApp.Documents.Open(InputFile.ToString) Mydoc.SaveAs(OutputFile.ToString, Microsoft.Office.Interop.Word.WdSaveFormat.wdFormatPDF) Mydoc.Close(Microsoft.Office.Interop.Word.WdSaveOptions.wdDoNotSaveChanges) MyApp.Quit() If you have all the word docs in Same folder and the destination filename is same as source filena…

---

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 December 2022

Top 3 Topics with Most Views

How to file type made by @manoj_verma1 with 48 views.

Scarping data from table made by @Shubham_Bidwai with 43 views.

No xaml files available when extracting from the nupkg package made by @Karthikeyan_CS with 41 views.

Top 3 Topics with Most Replies

Scarping data from table made by @Shubham_Bidwai with 24 replies.

ERROR HRESULT: 0x800700c1. open java application made by @Aguirre with 22 replies.

How to file type made by @manoj_verma1 with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 55 posts!

@sangeethaneelavannan1 made 36 posts!

@Gokul001 made 33 posts!

Top 3 Most Liked Posts

This post made by @sharon.palawandram received 3 likes!

UiPath is launching a new initiative: UiPath Digital Credentials

Saw many badges on LinkedIn and it looks awesome, another great initiative done!

This post made by @Anca_Bolca received 1 likes!

Definition & Execution of Business Rules for Fields (mandatory, possible values & fixed format rules)

Hello @sharon.palawandram Next to the search box you have a filter icon and from what I notice the “Include Prerelease” is not selected for you. Once you tick that filter you should be able to see and use our preview packages

This post made by @KavinduPerera received 1 likes!

UiPath Dev Dives - 2023 webinar series for developers

Cheers Very Excited to Join

Top 3 Most Liked Solutions

This solution provided by @arivu96 received 1 likes!

Converting Word File To PDF without using Word Application Scope

Hi @chilled_lad , Only those two option is there to convert word to pdf. you can create custom activity also but again the same code you are going to use to convert the word to pdf file. Regards, Arivu

This solution provided by @arivu96 received 1 likes!

How to find/match specific values in notepad?

Hi @Muralikrishna_Surve , Please use below xaml to extract the value. MultiplefilesRegex.xaml (7.6 KB) [image] Regards, Arivu

This solution provided by @Yoichi received 1 likes!

DTの集約について（任意の列の文字列が一致する行の合計）

こんにちは 空欄を0扱いにしてよいなら dt.AsEnumerable.GroupBy(Function(r) r("果物").ToString()).Select(Function(g) dt.Clone.LoadDataRow({cobj(g.Key)}.Concat(dt.Columns.Cast(Of DataColumn).Skip(1).Select(Function(dc) cobj(g.Sum(Function(r) if(Int32.TryParse(r(dc.ColumnName).ToString, new int32),CInt(r(dc.ColumnName).ToString),0))))).ToArray,False)).CopyToDataTable() になります。ただし上記はシート上０と表示されます。0の部分を空欄にする必要ありますでしょうか？

---

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

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

[system]

Daily Forum Report | 16 December 2022

Top 3 Topics with Most Views

Plz check screen shot made by @Shubham_Bidwai with 46 views.

Uipath Studio is not opening made by @Vaishnav_Tej with 43 views.

Bulk Add Queue Items - squares the number of Queue items made by @Sisay_Dinku with 39 views.

Top 3 Topics with Most Replies

How to mail the scraping data through SMTP made by @Shubham_Bidwai with 19 replies.

Plz check screen shot made by @Shubham_Bidwai with 18 replies.

Getting the Error for a null value for drive item made by @Kunal_Jain with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 51 posts!

@Yoichi made 39 posts!

@Rahul_Unnikrishnan made 35 posts!

Top 3 Most Liked Posts

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

Check App State and Statements to retry

actually if you simply want to retry this click activity if it fails you dont have to do all that simply do this enable verify result in click activity [image] indicate verification target, this is the element robot needs to see to verify that the click is successful, in your case you can select a button you see after login is successful [image] change the properties so that retry = True and timeout = “3” meaning if robot doesnt see verification target in 3 seconds, it will retry …

This post made by @TheSupremeRobot received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Brand new Robo Jurney starts here. I am so excited to grow and solve problems without human touch. The future waits for all of us.

This post made by @Gokul_Jayakumar received 1 likes!

DateTime.now command help

Hello @Povilas_Jonikas ., Try this DateTime.Now.Adddays(-3).ToString(“yyyy.MM.dd”)

Top 3 Most Liked Solutions

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

Check App State and Statements to retry

actually if you simply want to retry this click activity if it fails you dont have to do all that simply do this enable verify result in click activity [image] indicate verification target, this is the element robot needs to see to verify that the click is successful, in your case you can select a button you see after login is successful [image] change the properties so that retry = True and timeout = “3” meaning if robot doesnt see verification target in 3 seconds, it will retry …

This solution provided by @Gokul001 received 1 likes!

DateTime.now command help

Hi @Povilas_Jonikas Try this expression DateTime.Now.AddDays(-3).ToString("yyyy.MM.dd") Regards Gokul

This solution provided by @postwick received 1 likes!

Command to connect Robot to Orchestrator

No. You’re configuring a setting. The setting stays configured.

---

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 December 2022

Top 3 Topics with Most Views

Anyway to find out made by @manoj_verma1 with 38 views.

Try Catch and Debug mode made by @philwaller with 37 views.

Unattended SAP Process - Hotkey in background made by @moon_amlet with 32 views.

Top 3 Topics with Most Replies

SharePoint issu made by @Cuberoot with 9 replies.

How to enable or create Unattend robot made by @BNK with 9 replies.

LINQ expression for Data Table agregation made by @SONYC with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 22 posts!

@Rahul_Unnikrishnan made 9 posts!

@Yoichi made 8 posts!

Top 3 Most Liked Posts

This post made by @ppr received 12 likes!

Yoichi 3000th Solution Flag Celebration

@Yoichi Congratulations on reaching the 3000th Solution Flag. We would like to say thank you for your valuable work and support. Especially we would like to mention your help with the migration from Legacy to Windows Target framework. Let’s celebrate this milestone together

This post made by @Yoichi received 5 likes!

Yoichi 3000th Solution Flag Celebration

@ppr @jeevith @kirankumar.mahanthi1 Thank you for your kind messages. I’m happy to be able to contribute some my activities to this great community. As UiPath is one of the rapid evolving platform, collective knowledge by the community is important more and more, I think. Let’s keep to do our best. Best regards, Yoichi

This post made by @jeevith received 4 likes!

Yoichi 3000th Solution Flag Celebration

Thank you @Yoichi for your dedication and efforts. We learn a lot from your answers. We wish you good health and continued success. Thank you @ppr for the thread

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Anyway to find out

Hi, Can you try the following sample? [image] Jo("Store")(0)("enduser").Count OR ja = CType(Jo("Store")(0)("enduser"),JArray) Then ja.Count Sample20221215-6v4.zip (3.4 KB) Regards,

This solution provided by @Anil_G received 1 likes!

How to merge the duplicate values and unique values of same duplicate no

@smarthari1997 In place of x("Date").ToString() please use x("Date").ToString.Trim.Split({" "},stringsplitoptions.RemoveEmptyEntries)(0) Cheers

This solution provided by @Anil_G received 1 likes!

Compilation Error in Studio

Hi @tilarapiyush It typically is a corrupted project file…it gets recreated if removed… so i asked you to rename so that you have a backup (project.json.old)…you can delete it now… project.json is enough now…this is what you need 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 | 18 December 2022

Top 3 Topics with Most Views

Uipath not open made by @Ma_athir_AL-Saidi with 33 views.

Use For Each Row made by @anmita with 32 views.

Search Complete Data table and get first Column Data made by @CGhoST with 31 views.

Top 3 Topics with Most Replies

Excel and word files are not working made by @Ravi_Rawal with 14 replies.

Googledriveにあるファイルのループ処理 made by @r-takagi with 13 replies.

Word Application Scope: Error opening document, make sure Word application is installed. If already installed made by @Ravi_Rawal with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 26 posts!

@Rahul_Unnikrishnan made 8 posts!

@Ravi_Rawal made 5 posts!

Top 3 Most Liked Posts

This post made by @Rahul_Unnikrishnan received 3 likes!

Yoichi 3000th Solution Flag Celebration

Congratulations @Yoichi , You are a true inspiration to all the community members. Thank you @ppr for sharing this. Thanks

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

Yoichi 3000th Solution Flag Celebration

congrats @Yoichi you are an inspiration

This post made by @Yoichi received 1 likes!

Yoichi 3000th Solution Flag Celebration

@Rahul_Unnikrishnan @loginerror @jack.chan Thank you!

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

GraphQL API Query Syntax Error when using filter

@Oscar_Ram_Kalia I guess this is what is valid json…can you try this please. Escaped "(double quotes) with \(backslash) { "query": "query {recentTransactions(last: 100, filter: {createdAt_gte: \"2022 - 12 - 12 T00: 00: 00\"}) {edges {node {createdAt transactionHeader {postedDate transactionNumber}text account {code}amount}}}}" } cheers

---

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

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

[system]

Daily Forum Report | 19 December 2022

Top 3 Topics with Most Views

How to save the extracted dynamic match values into excel sheet made by @_Bhagyashree with 56 views.

Error When Writing Directory.GetFiles in Assign Activity 'Directory' is ambiguous, imported from the namespaces or types 'System.IO, Microsoft.Graph' made by @hb61 with 42 views.

For Each: Specified cast is not valid. While using For Each made by @zaid.ahmad with 42 views.

Top 3 Topics with Most Replies

How to save the extracted dynamic match values into excel sheet made by @_Bhagyashree with 31 replies.

For Each: Specified cast is not valid. While using For Each made by @zaid.ahmad with 27 replies.

Check string to see if it DOES NOT start with "x" Check string to see if it DOES NOT start with "x" made by @nmjvk with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 49 posts!

@sangeethaneelavannan1 made 36 posts!

@Gokul001 made 23 posts!

Top 3 Most Liked Posts

This post made by @Daniel_Caldararu received 2 likes!

Invoke PowerShell with ActiveDirectory module not working

I’ve checked again. Sorry. The first one I’ve put the script under quotation marks. My bad. I’ve ran it again and surprise. It works! Can’t believe after massively googling this issue and a lot of people complaining finally found a solution. It’s a bit disappointing that in order to get the same result as in Windows Legacy where you just input the powershell command, here you need to input additional steps to make it work. Maybe this issue can go to development team to understand it and make i…

This post made by @Yoichi received 1 likes!

Yoichi 3000th Solution Flag Celebration

@ShumpeiWatanabe ありがとうございます！

This post made by @ptrobot received 1 likes!

Invoke PowerShell with ActiveDirectory module not working

Ok, that’s strange. Have you tested to add “Set-ExecutionPolicy” to your ps1-file? E.g. test1.ps4: Set-ExecutionPolicy Unrestricted -Scope CurrentUser get-ADUser -filter {employeeid -eq 0000} -Properties * | select employeeid, mail | Export-Csv C:\Test\output.csv -NoTypeInformation

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Orchestrator scheduling working inappropriately

@Riya_Bansal Give only one machine to it…then the second job will wait for the first one to complete and then start. And debug time is more than execution time from orchestrator…but while running feom orchestrator it takes some time for login to machine as well And what do you mean two broswers…botht he bots wont run at the same time on same machine unless it is a background job Cheers

This solution provided by @Sudharsan_Ka received 1 likes!

Orchestrator Scenario Based Concept

Hi @Harsha_S1 We can able to do that . We can able to start the attended robot from only Assistant. Regards Sudharsan

This solution provided by @ppr received 1 likes!

Substring manipulation of path

One of many options: [grafik] new DirectoryInfo(YourFolderPathVar).Parent.Parent.FullName

---

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 December 2022

Top 3 Topics with Most Views

Add a manipulated datatable to a dataset made by @sharon.palawandram with 56 views.

UiPath Perth EOY Customer Connect made by @Andrew_Rosson with 48 views.

Check every column in data table if a cell contains letters made by @nmjvk with 45 views.

Top 3 Topics with Most Replies

After table extraction and send through gamil made by @Shubham_Bidwai with 34 replies.

How to check if the filename is same on the other filename in the other folder? made by @fniedez with 27 replies.

Check every column in data table if a cell contains letters made by @nmjvk with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 54 posts!

@Rahul_Unnikrishnan made 34 posts!

@Shubham_Bidwai made 28 posts!

Top 3 Most Liked Posts

This post made by @VanjaV received 2 likes!

UiPath Windows based - write line item(0).toString

Thank you very much: @Gokul001 / @Anil_G / @Yoichi / @Rahul_Unnikrishnan it is working both ways: [image] Kind Regards, Vanja

This post made by @Supercastor received 1 likes!

How to use a nupkg file in my Studio project ?

Test : If I create a Windows-Legacy project, then I see all packages from the marketplace and local repo. Many Thanks Hiba, you pointed out the reason. Best regards

This post made by @xoduzen received 1 likes!

Delete Duplicate Rows that and keeping the row with the newest date

Hello There, You can try adjusting the following. It worked for me. dtRaw.AsEnumerable.GroupBy(Function(r) r(“Name”).ToString).Select(Function(g) g.OrderBy(Function(r) DateTime.ParseExact(r(“Date”).ToString, “MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture )).Last).CopyToDataTable() Best, Ozzy

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 1 likes!

UiPath Windows based - write line item(0).toString

HI @VanjaV have you tried like this row("Column name").tostring Regards Gokul

This solution provided by @Yoichi received 1 likes!

ファイルが破損している、ファイルが既に別のプロセスで使用されている、またはファイルを開く権限がない。

こんにちは Excelアプリケーションスコープはプロセスの制御が下手なので、可能であれば モダンエクセルのエクセルプロセススコープをループの外側において、 ループの内側、エクセルアプリケーションスコープの代わりに エクセルファイルを使用アクティビティを使う方が良いかと思います。 なお実行までにexcelのゾンビプロセスがいるかもしれませんので タスクマネージャーの詳細画面から不要なexcelを削除する（あるいはOSの再起動）等を しておいた方が良いかもしれません。

This solution provided by @Yoichi received 1 likes!

Add a manipulated datatable to a dataset

Hi, in this case, we need to use InvokeMethod activity as the following. [image] Can you try this? Regards,

---

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

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

[system]

Daily Forum Report | 21 December 2022

Top 3 Topics with Most Views

Give me list of all activities in uipath made by @Vajrang with 100 views.

How does StudioX treat files added to a folder during execution of its "For each file in a folder" made by @murray.trim with 47 views.

Issue with datarow adding made by @Learner007 with 47 views.

Top 3 Topics with Most Replies

Give me list of all activities in uipath made by @Vajrang with 74 replies.

Issue with datarow adding made by @Learner007 with 22 replies.

Not able to run process using orchestrator made by @RAKESH_KUMAR_Tiwari with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 52 posts!

@Kaviyarasu_N made 36 posts!

@sangeethaneelavannan1 made 29 posts!

Top 3 Most Liked Posts

This post made by @Kaviyarasu_N received 2 likes!

DATTABLE / EXCEL Add column with value

Hi @Manikandasamy To add a new column in an Excel file using UiPath, you can use the Add Data Column activity. Here’s an example of how to use this activity: First, drag and drop the Add Data Column activity from the Activities panel onto the Designer panel. Next, specify the input for the activity by setting the properties in the Properties panel. In the DataTable property, specify the data table that you want to add the new column to. In the ColumnName property, specify the name of the ne…

This post made by @AhmedEmad2024 received 1 likes!

Yoichi 3000th Solution Flag Celebration

Congratulations @Yoichi I wish you more and more .

This post made by @Kaviyarasu_N received 1 likes!

PNG to TIFF image converting

Hi @Jerry1 Drag and drop the “Save Image” activity into the designer panel. In the “InputImage” field, specify the file path and name of the PNG image that you want to convert. For example, “C:\Images\Input.png” In the “OutputImage” field, specify the file path and name of the TIFF image that you want to create. For example, “C:\Images\Output.tiff” Run the workflow and the PNG image will be converted to TIFF and saved at the specified location.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to initialize array of Datatables

Hi, How about DataSet and DataTableCollection class? We can iterate multiple DataTables as the following. [image] Sample20221221-2aL.zip (3.0 KB) Regards,

This solution provided by @Sudharsan_Ka received 1 likes!

How to avoid alphanumeric and pick only numeric using regex

HI @Raja.G Checkout this expression System.Text.Regex.RegularExpression.Match(YourString,"(?<=\S\s)\d+(?=\s\S)").Tostring [image] Regards Sudharsan

This solution provided by @Kaviyarasu_N received 1 likes!

SharePoint Upload file Size - Office 365 Activities

Hi @AdityaVN There is a file size limit for uploading files to SharePoint using the O365 activities in UiPath. The maximum file size that can be uploaded to SharePoint using the O365 activities is 15 GB. If you are trying to upload a file that is larger than 15 GB, you will need to use a different method to upload the file. If you are experiencing timeouts when uploading files to SharePoint using the O365 activities, there could be a few reasons for this. Here are some things you can try to t…

---

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

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

[system]

Daily Forum Report | 22 December 2022

Top 3 Topics with Most Views

Issue in Assign: Exception has been thrown by the target of an invocation made by @_Bhagyashree with 73 views.

JIT compilation is disabled for non-Legacy projects made by @Doneparthi_Chaitanya with 58 views.

How to Merge Two Data table made by @Peace_Maker with 47 views.

Top 3 Topics with Most Replies

Issue in Assign: Exception has been thrown by the target of an invocation made by @_Bhagyashree with 29 replies.

Help on regex statement needed made by @eric.atwood with 19 replies.

Any one help me for the output error (package is missing for (package is invalid ) made by @Shubham_Bidwai with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 57 posts!

@Yoichi made 44 posts!

@Rahul_Unnikrishnan made 38 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 4 likes!

How to Merge Two Data table

Hi, Hope the following sample helps you. [image] dtA = dtA.AsEnumerable.Zip(dtB.AsEnumerable,Function(r1,r2) dtA.Clone.LoadDataRow(r1.ItemArray.Zip(r2.ItemArray,Function(v1,v2) if(String.IsNullOrEmpty(v1.ToString),v2,v1)).ToArray,False)).CopyToDataTable Sample20221222-3aL.zip (2.9 KB) Regards,

This post made by @ppr received 2 likes!

Data extraction in the menu is not available

In Addition to above: Back stage option: [grafik] Is connfiguring for new projects Switching a project to classic / modern we do it on the project settings: [grafik]

This post made by @arivu96 received 1 likes!

Yoichi 3000th Solution Flag Celebration

Thank you for all your contributions @Yoichi.Your dedication to helping others is realy inspiring and breaking 3000 solutions is an amazing achievement.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 4 likes!

How to Merge Two Data table

Hi, Hope the following sample helps you. [image] dtA = dtA.AsEnumerable.Zip(dtB.AsEnumerable,Function(r1,r2) dtA.Clone.LoadDataRow(r1.ItemArray.Zip(r2.ItemArray,Function(v1,v2) if(String.IsNullOrEmpty(v1.ToString),v2,v1)).ToArray,False)).CopyToDataTable Sample20221222-3aL.zip (2.9 KB) Regards,

This solution provided by @ppr received 2 likes!

Data extraction in the menu is not available

In Addition to above: Back stage option: [grafik] Is connfiguring for new projects Switching a project to classic / modern we do it on the project settings: [grafik]

This solution provided by @amit4 received 1 likes!

JIT compilation is disabled for non-Legacy projects

Hi, For me, updating the UiPath.System.Activities to latest version helped resolve the issue which was occurring only at runtime (not while debugging) Hope this helps!

---

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

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

[system]

Daily Forum Report | 23 December 2022

Top 3 Topics with Most Views

How to overcome the limitations of Add Data Row made by @Pravin_Mandadi with 53 views.

Take an url with specific text in it made by @Povilas_Jonikas with 42 views.

Add bulk queue items made by @sharu_priya with 42 views.

Top 3 Topics with Most Replies

Table Extraction in preview i could see data but im unable copy same to excel or messagebox made by @niranjan.kummara with 21 replies.

Xml file reading and extracting some information from it made by @RAKESH_KUMAR_Tiwari with 20 replies.

Code is not running completely with action centre made by @Learner007 with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 74 posts!

@Rahul_Unnikrishnan made 61 posts!

@Yoichi made 19 posts!

Top 3 Most Liked Posts

This post made by @uio received 2 likes!

How do I change the format of the date?

Thanks a lot. It worked.

This post made by @Rahul_Unnikrishnan received 1 likes!

Ui Interaction with Microsoft Dynamics Navision 2018

Hello @anaskhan Can you raise it as new topic and share your concern with some screenshot there. Thanks

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

Extract Multi-Language PDF Files using Document Understanding

Hi, You can find the languages supported by DU components here:

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

安定版を選択したのにbeta版に更新される

こんにちは 残念ながら、今回(2022/12)のリリースより更新チャネルが一本化され、 必ず最新版が提供されるようになりました。そのため現時点ではCommunity版については 2022.12-betaを使う以外の選択肢はないようです。 [image]

This solution provided by @Anil_G received 1 likes!

Add AD group to have modify permission on folder

@Zehra Please try this Dim FolderInfo As IO.DirectoryInfo = New IO.DirectoryInfo(FolderPath) Dim FolderAcl As System.Security.AccessControl.DirectorySecurity = FolderInfo.GetAccessControl() FolderAcl.AddAccessRule(New System.Security.AccessControl.FileSystemAccessRule(UserAccount, System.Security.AccessControl.FileSystemRights.Modify, System.Security.AccessControl.InheritanceFlags.ContainerInherit Or System.Security.AccessControl.InheritanceFlags.ObjectInherit, System.Security.AccessControl.P…

This solution provided by @jcb received 1 likes!

Audit logs - Upload package and Update process

Hey @Damian_Schapiro This feature is available to an extent at Tenant Audit level; [image] Unfortunately it doesn’t offer as rich insights as you have requested on the summary page, IE you can only see “Updated 1 Process(es)”. You can click the info button far right to see exactly what process you have updated, but I agree it would be useful to see this info on the actual audit tab rather than having to click into each: [image]

---

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

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

[system]

Daily Forum Report | 24 December 2022

Top 3 Topics with Most Views

Add to queue made by @Rajesh_Rao with 58 views.

Variables to add in Add Data Row activity made by @Ram_Shiva_Reddy with 42 views.

How to get windows screen scale and layout value made by @RK_0 with 34 views.

Top 3 Topics with Most Replies

The problem of web site substitution，thank made by @Uddynitjh with 8 replies.

Compare two number with tolerance in % made by @l.sambinelli with 7 replies.

Problem with Custom Activity in package manager uipath studio.Please help me to resolve made by @BReddy_m with 7 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 17 posts!

@Yoichi made 10 posts!

@Anil_G made 9 posts!

Top 3 Most Liked Posts

This post made by @Rahul_Unnikrishnan received 1 likes!

How to master VB.Net code & LINQ for implementing any type of scenarion Using UIPath?

Hello @Ritesh_Burman You can watch the video on the community session regarding the LINQ in UiPath. Also there are courses available in different portals like udemy to learn it. Thanks

This post made by @sunilch received 1 likes!

Compare two number with tolerance in %

Hi @l.sambinelli you can use the same condition how you calculate val = ((dbl_2 - dbl_1)/dbl_1)*100 maxVal = 5 If ( val < maxVal) acceptable value Else Not acceptable

This post made by @Yoichi received 1 likes!

Compare two number with tolerance in %

Hi, FYI, if your tolerance means ±5%, Math.Abs method will help you as the following. [image] 100*Math.Abs(dbl_1-dbl_2)/dbl_1<5 Regards,

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 | 25 December 2022

Top 3 Topics with Most Views

Request Credentialアクティビティを使ってサイトにログインしたい made by @gorby with 38 views.

Dynemic selector write in excelfile made by @purnima_mandan with 37 views.

Select Checkbox as per excel row made by @Omkar_Shete1 with 30 views.

Top 3 Topics with Most Replies

Request Credentialアクティビティを使ってサイトにログインしたい made by @gorby with 12 replies.

How to find color in particular cell value made by @Raja.G with 8 replies.

"Select Item " activity not working made by @Sami_Rajput with 6 replies.

Top 3 Users Who Posted The Most

@gorby made 9 posts!

@Anil_G made 8 posts!

@Rahul_Unnikrishnan made 6 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

Error Saving Word Document to PDF

@Nora_Almulla I beleive you are pasing extra double quotes…please remove and try it. Cheers

This post made by @sangeethaneelavannan1 received 1 likes!

"Select Item " activity not working

@Sami_Rajput As a workaround,Please use the click activity. Click on the drop and next Click the number using aaname as dynamic attribute and pass that number as variable inside the selector

This post made by @Rahul_Unnikrishnan received 1 likes!

"Select Item " activity not working

Hello @Sami_Rajput Selevt item activity will not support all the dropdowns. I hope the element that you tring to select doesnt support select item activity. Instead go with the click activity. Thanks

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 | 26 December 2022

Top 3 Topics with Most Views

Minmax made by @purnima_mandan with 50 views.

Add multiple datatables into single datatable made by @Shyam_Pragash with 41 views.

Need to Extractor Amount in below text using REGEX made by @Vicky_K with 38 views.

Top 3 Topics with Most Replies

Minmax made by @purnima_mandan with 15 replies.

Options strict on disallows implicit conversions from ‘attachment’ to ‘Iresource’ made by @Vijay_Singh with 12 replies.

Checking all rows if specific column contains value of "A" if contains value of "A" it will filter the data table get all the rows that have value of "A" made by @ldiaz with 11 replies.

Top 3 Users Who Posted The Most

@sangeethaneelavannan1 made 30 posts!

@Anil_G made 29 posts!

@Rahul_Unnikrishnan made 28 posts!

Top 3 Most Liked Posts

This post made by @humvale received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello Everyone! My name is Humberto. I have a marketing background and I’m starting my journey on RPA. The Forum looks like a great collaboration tool! Looking forward to having a great experience with IiPath.

This post made by @syed.ali.hasnat06 received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Thanks for providing us with the opportunity to introduce ourselves so that we’ll know about other people. I am Hasnat from Pakistan, graduated in the field of computer science and currently, I am working as a freelance. I was searching for outlook errors then this forum appears in the search engine and I decided to get the knowledge from UiPath, this was the journey.

This post made by @cprima received 1 likes!

2022-wk51 Last week in RPA on YouTube

What happened in the #uipath channels on YouTube last week? Here are videos released from 2022-12-19 thru 2022-12-25 by various creators. Find a YouTube playlist at https://www.youtube.com/playlist?list=PLruuV36qJJXfPBFCsZATiEHLRZI2A18YV … UiPath Job Offer | UiPath Training | RPA Dev In 30 Days | Best rpa projects 21 How to Use the UiPath Attended Framework Full Tutorial 27:34 How to use UiPath Action Center - Full Tutorial 20:04 Want a UiPath Job? Solve This Job Interview…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Error Saving Word Document to PDF

@Nora_Almulla Use path.Combine(var1,var2,var3) This will combine the path…and use a log message to check if you have given it properly Cheers

This solution provided by @Rahul_Unnikrishnan received 1 likes!

Kill Process - in Windows mode not working

@VanjaV You can provide as below. [image] Thanks

This solution provided by @RajKumar_DC received 1 likes!

Palindrome Scenario Based

Hi @Harsha_S1 , Plz refer this site Thanks, Rajkumar

---

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

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

[system]

Daily Forum Report | 27 December 2022

Top 3 Topics with Most Views

Add two column in last made by @sshitol with 74 views.

Data excel made by @purnima_mandan with 49 views.

How to find whether string contains any number in it or not made by @sshitol with 45 views.

Top 3 Topics with Most Replies

Get form task returning empty made by @user928 with 22 replies.

データテーブルをフィルタで抽出 made by @autopc01 with 19 replies.

Error is displayed when trying to create 16 digit fixed length random number made by @Deepa_Madkar with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 62 posts!

@sudheern made 33 posts!

@Yoichi made 32 posts!

Top 3 Most Liked Posts

This post made by @111860 received 2 likes!

ICollection<T>とList<T>の使い分け

ありがとうございます。 これまでぼんやり理解していたものが明確になりました。 端的にご説明いただきありがとうございます。

This post made by @Yoichi received 1 likes!

ICollection<T>とList<T>の使い分け

List<T> はICollection<T>を実装していますので、多くの場合List<T>使っておけば 問題は少ないと思います。

This post made by @muuuuuu received 1 likes!

リモートデスクトップ越しのオーケストレーターからの実行について

Thank You！ ありがとうございます！ そちらの設定にて、画面が小さくならずにアプリを起動することができました。

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

ICollection<T>とList<T>の使い分け

List<T> はICollection<T>を実装していますので、多くの場合List<T>使っておけば 問題は少ないと思います。

This solution provided by @Anil_G received 1 likes!

Get Activity Name for Get Row Item

@SIM_KAI_YI If the error occurs on that specific activity then it would give the name of that activity only Exception.Source would give the details cheers

This solution provided by @J0ska received 1 likes!

DataTable match only rows with 6 digits in Column0

Better like this: dt = dt.AsEnumerable().Where(Function (row) System.Text.RegularExpressions.Regex.IsMatch(row("Column0").ToString,"[0-9]{6}$")). CopyToDataTable() And alos check this post 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 | 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.