Forum Engagement Daily Reports

[system]

Daily Forum Report | 01 February 2024

Top 3 Topics with Most Views

DataTable: Get the Unique datatable and Dupliacte datatable made by @copy_writes with 52 views.

Extract the data from images made by @vignesh.manohar with 48 views.

How to get Queues data as report made by @Rreddy with 46 views.

Top 3 Topics with Most Replies

Doubt in pdf automation made by @anjani_priya with 34 replies.

DataTable: Get the Unique datatable and Dupliacte datatable made by @copy_writes with 21 replies.

How to get Queues data as report made by @Rreddy with 20 replies.

Top 3 Users Who Posted The Most

@mkankatala made 35 posts!

@vrdabberu made 31 posts!

@rlgandu made 29 posts!

Top 3 Most Liked Posts

This post made by @silviu_tanasie received 7 likes!

Studio Web now supports multifile projects!

We are thrilled to announce that Studio Web now supports multifile projects! You can now create Studio Web projects with multiple workflows. This enables you to split larger projects into smaller files, making it easier to organize your automations and test workflows separately. Use the Invoke Workflow File activity to link the workflows to the main workflow: [image] You can manage the workflows from the new Project explorer available in your projects: [image] For more information, see Man…

This post made by @vrdabberu received 3 likes!

Select dynamics button

Hi @Gabriele_Radici Here is the sample workflow: [image] As you can see in the above image I have given the click for the community but I have assigned the str_Variable with Academy so when I execute the code it should go and click on the Academy which is beside the community tab. For that I have done the below steps: Click on the 3 dots beside the plus symbol as shown in the below image. [image] After clicking the 3dots the popup arises as shown below [image] Make sure that you have …

This post made by @Praharsha_Kanaparthi2 received 1 likes!

What is the variable type of the "Output Data Table" activity?

What is the variable type of the “Output Data Table” activity? List. Array. Dictionary. String. please answer and explain

Top 3 Most Liked Solutions

This solution provided by @vrdabberu received 1 likes!

Deleting Empty Rows Using LINQ Cast Function

Hi @NILESH.BOT369 Can you try the below syntax: DT.AsEnumerable().Where(Function(row) Not row.ItemArray.All(Function(cell) cell Is DBNull.Value OrElse cell.Equals(""))).CopyToDataTable() Input: [image] Output: [image] [image] Regards

This solution provided by @vrdabberu received 1 likes!

How to solve this error!

Hi @Kancharla_Mahija If you using Read Range Workbook there is option in properties panel, Preserve Format option enable that and give the below syntax: DateTime.ParseExact ("11/20/23", "MM/dd/yy", System.Globalization.CultureInfo.InvariantCulture) Or else for your condition also please check below DateTime.ParseExact("21-Nov-23 00:00:00","dd-MMM-yy HH:mm:ss" , System.Globalization.CultureInfo.InvariantCulture) Please check the below image the output extracted perfectly [tmp_d74421ef-46a0…

This solution provided by @vrdabberu received 1 likes!

Element Exists true issue

Hi @A_Learner ->Then give the element Exists for the element in window2 also and take the Boolean value and place in the IF condition. ->In Else sequence of the IF condition place the Element Exists of Window1 and other activities. So by this you can confirm whether the Window2 is closed or not. 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 | 02 February 2024

Top 3 Topics with Most Views

Having issues with Click activity made by @Test11 with 59 views.

How to extract specific data based on input frequency made by @Baby123 with 46 views.

How to write all RegEx currentitems in one row order? made by @paultech5 with 40 views.

Top 3 Topics with Most Replies

Regex.Replace error help made by @22222222asas with 21 replies.

Empty extension made by @shanti_18 with 18 replies.

Having issues with Click activity made by @Test11 with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 77 posts!

@lrtetala made 26 posts!

@rlgandu made 25 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

Adding blank rows in an excel

Hi, FYI, another approach: dt = dt.AsEnumerable.GroupBy(Function(r) r("Ranking").ToString).SelectMany(Function(g) g.Concat({dt.NewRow})).CopyToDataTable [image] Sample Sample20240202-2.zip (8.6 KB) Regards,

This post made by @indiedev91 received 3 likes!

A Simple Method to View DataTables in a Table Format within UiPath (Activity)

Hello everyone, I’m excited to share my first activity with the community. This activity, designed with developers in mind, is called DataTable Visualizer. It provides a convenient table view for DataTables, allowing you to quickly inspect the values within. It’s important to note that this activity is specifically made for development environments. It will disrupt the automation flow, making it unsuitable for production use. However, it can be beneficial in attended bot scenarios where users n…

This post made by @Anil_G received 2 likes!

Monthly Forum Rewards - January 2024

Congratulations everyone

Top 3 Most Liked Solutions

This solution provided by @ppr received 3 likes!

How to get inline image in the mail body!Error

give a try at: strFilePath = FullFilePathToTheImage Assign Activity: strB64 = Convert.ToBase64String(File.ReadAllBytes(strFilePath)) Keep in mind: strB64 is only the part: [grafik] the red part you would handle e.g. by prepending or within the html part It can fail, when done this the first time. But just focus on the correct red handle part, then it it will work

This solution provided by @vrdabberu received 2 likes!

Tableau Screenshot

Hi @max.eknigk Please use an check app state activity and indicate the element that is present in the Table. In the Target Appears Sequence use the Take Screenshot Activity. Regards

This solution provided by @pikorpa received 2 likes!

Orchestrator queue - prevent duplicates

Hey @A_Learner you can use queue’s option: [image] It will help you ensure that data in the queue is not duplicated or overwritten.

---

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 February 2024

Top 3 Topics with Most Views

Date comparison error _Panel made by @marina.dutta with 47 views.

PowerShell script not working made by @z9293493 with 44 views.

How to give border by using uipath dynamically made by @anjani_priya with 39 views.

Top 3 Topics with Most Replies

Date comparison error _Panel made by @marina.dutta with 50 replies.

Custom connector in studio made by @sreedutta14 with 11 replies.

How to save filepath in a variable made by @anjani_priya with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 34 posts!

@vrdabberu made 27 posts!

@marina.dutta made 22 posts!

Top 3 Most Liked Posts

This post made by @A_Learner received 2 likes!

Adding queue items - bad request errorr

Thank you @Anil_G @rlgand @vrdabberu @shantanu_chande @postwick All of your answers educated me and made corrections. Much appreciated.

This post made by @Emmanuella_Fosu_Nketia received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

I am Emmanuella Fosu Nketia, a highly motivated Electrical and Electronic Engineering graduate from Ashesi University in Ghana. I am currently undergoing a three-month intensive training for the UiPath Automation Developer Advanced Certification exam to become a fully certified RPA Developer. I am seeking opportunities to contribute to innovative automation solutions in a professional environment. I also have some expertise in electrical engineering, project leadership, and community engagement. …

This post made by @Praharsha_Kanaparthi2 received 1 likes!

What is a characteristic of an Orchestrator Asset?

What is a characteristic of an Orchestrator Asset? All values from any Asset type are encrypted. Assets can store complete DataTable variables. Asset values can be specified for each user. Asset types can be modified after the asset is created.

Top 3 Most Liked Solutions

This solution provided by @Brian_Mathew_Maben received 3 likes!

Need regex for below file name extract number in starting name

Hey @Vicky_K , try using this regex: \d+(?=_) [image] You can try using this: System.Text.RegularExpressions.Regex.Matches((“String Containing file names”),“\d+(?=_)”)

This solution provided by @mkankatala received 2 likes!

Select Item 'DIV': Error HRESULT E_FAIL has been returned from a call to a COM component

I have done the Workflow for you, check the below one, Regex_Practice.xaml (66.9 KB) [Regex_Practice] I have modified the Input data in the Excel according to the data in the Naukari website, check the below input file, New Microsoft Excel Worksheet.xlsx (8.3 KB) Hope it helps!!

This solution provided by @ppr received 2 likes!

Add Data Column - Error Message: Object reference not set to an instance of an object

ensure that the datatable is initialized e.g. set on the variable panel a default value like new DataTable()

---

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 February 2024

Top 3 Topics with Most Views

Update excel file in multi bot architecture made by @learning_sourav with 39 views.

Catch unknown exceptions made by @jhong with 37 views.

Click on respective ID made by @BHUSHAN_NAGAONKAR1 with 34 views.

Top 3 Topics with Most Replies

How to extract previous Month date value from Excel made by @manjusree_R_N_manju with 10 replies.

UiPath Outlook filter made by @Ritaman_Baral with 10 replies.

Queue item reference question made by @A_Learner with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 16 posts!

@vrdabberu made 15 posts!

@Yoichi made 11 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Click on respective ID

@BHUSHAN_NAGAONKAR1 You can create a selector with the binder id as the innertext so that even if anything changes based on binder id it would pick Eg: <webctrl tag='TD' tablecol='5' innertext='{{binderidvariable}}' /> <nav-up='1' /> <webctrl tag='TD' tablecol='2' /> Or <webctrl tag='TR' innertext='*{{binderidvariable}}*' /> <webctrl tag='TD' tablecol='2' /> Assuming binder id column is 5 and the folder click column is 2 Selectors are for reference…use ui explorer and find the selectors…n…

This post made by @Parvathy received 2 likes!

Data table to dictionary, Dictionary key based on column names

Hi @Akhil_Raveendran → Read Range Workbook: [image] Output-> dt → Use Below syntax in assign: outputDict= dt.Columns.Cast(Of DataColumn)().ToDictionary(Function(col) col.ColumnName, Function(col) dt.Rows(0)(col)) outputDict is of DataType System.Collections.Generic.Dictionary(System.String,System.Object) → Use For Each loop For Each kvp in outputDict Log Message-> kvp.Key + ": " + kvp.Value.ToString End For Each Output: [image] Sequence.xaml (9.2 KB) [image] Hope it helps!…

This post made by @Anil_G received 1 likes!

Click on respective ID

@BHUSHAN_NAGAONKAR1 Yes it can …even if it refreshes the number we are using is same right…so vhange the tablecol value as you need Cheers

Top 3 Most Liked Solutions

This solution provided by @olgu received 2 likes!

How to pass variables

This is working, if anyone would have similar issue: [image]

This solution provided by @mkankatala received 2 likes!

Removing Subtotals from Pivots

In which activity you are using this code @yash.choursia You have to use this code in Invoke VBA Activity which is the Excel activity, you have to use this activity inside the Use excel file activity. Store the code in .txt file (Notepad file) and pass the the path of the .txt file in Code file path field. Pass the Method name in the Entry Method Name field. Check the below image for better understanding, [image] Notepad file - Working on Pivot Tables.txt (547 Bytes) Hope you understand…

This solution provided by @postwick received 2 likes!

Get value of data row variable

A DataRow is a complex object, you can’t just convert it to string. If you want to see the values in the DataRow you use the ItemArray property and Join it into a string: String.Join(",",drCorrespondingRow.ItemArray)

---

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 February 2024

Top 3 Topics with Most Views

Require to retrieve a link from an email made by @SAMANTA_COTTACKAL1 with 54 views.

How to configure the bot to get files by itself? made by @pabaleloh with 53 views.

How to remove data from sheet without headers? made by @suraj_gaikwad with 50 views.

Top 3 Topics with Most Replies

Doubt in pdf automation selectors made by @anjani_priya with 41 replies.

Unable to find the Files/Folder in SharePoint made by @Anitha_Anandhan with 33 replies.

<Regex> Want to extract value of invoice number from below mentioned text made by @anjasing with 25 replies.

Top 3 Users Who Posted The Most

@Anil_G made 57 posts!

@mkankatala made 32 posts!

@ABHIMANYU_THITE1 made 20 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

Help creating aggregate report - group by count

HI, Can you try the following sample? dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r(0).ToString,r(1).ToString,r(2).ToString,r(3).ToString)).Select(Function(g) dtResult.LoadDataRow({g.Key.Item1,g.Key.Item2,g.Key.Item3,g.Key.Item4,g.Any(Function(r) r("Class Finals").ToString.ToLower="true" ),g.Count(Function(r) not String.IsNullOrWhiteSpace( r("Subject").ToString)),g.Any(Function(r) r("Due Resits").ToString.ToLower="true")},False)).CopyToDataTable Sample20240127-1aV2.zip (15.7 KB) Regards…

This post made by @Samrat_Dutta received 2 likes!

Expanding Horizons: UiPath's New Google Maps and FreshBooks Connectors in Integration Service

Hey @Manoj_Batra , Thanks for bringing this to our notice and looks like something changed off late-the links have been updated now. Here you go: Google Maps FreshBooks Looking forward to getting your feedback

This post made by @rikulsilva received 2 likes!

Queue unique reference

Hi @A_Learner The attached workflow contains both strategies DuplicateReference.zip (4.7 KB)

Top 3 Most Liked Solutions

This solution provided by @vrdabberu received 3 likes!

Select dynamics button

Hi @Gabriele_Radici Here is the sample workflow: [image] As you can see in the above image I have given the click for the community but I have assigned the str_Variable with Academy so when I execute the code it should go and click on the Academy which is beside the community tab. For that I have done the below steps: Click on the 3 dots beside the plus symbol as shown in the below image. [image] After clicking the 3dots the popup arises as shown below [image] Make sure that you have …

This solution provided by @jose.ordonez1 received 2 likes!

Training Pipeline is getting failed for Custom Named Entity model

Hi Suman, Please check the Pipeline logs to check who is causing the error. In my opinion this problem is asociated to Data Labeling. Please confirm if all the input documents(trainning and validation set) are labeled correctly. Remember that all the trainning and validation documents are together part of trainning datasets used by trainning pipelines. Cheers!

This solution provided by @mkankatala received 2 likes!

Date in input field to last month (web application)

Hi @Markus_Reimer Check the below expression for From field, - Assign -> FromDate = DateTime.ParseExact(Now.ToString("MMMM yyyy"),"MMMM yyyy",System.Globalization.CultureInfo.InvariantCulture).AddMonths(-1).ToString("dd/MM/yyyy") Check the below expression for To field, - Assign -> ToDate = DateTime.ParseExact(Now.ToString("MMMM yyyy"),"MMMM yyyy",System.Globalization.CultureInfo.InvariantCulture).AddDays(-1).ToString("dd/MM/yyyy") Hope it helps!!

---

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

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

[system]

Daily Forum Report | 06 February 2024

Top 3 Topics with Most Views

Move first row to last row made by @craigmartin with 51 views.

How to extract integer from text made by @Smitesh_Aher2 with 49 views.

How to copy a csv file data including the headers into an excel file made by @rnahasnahasuddin with 43 views.

Top 3 Topics with Most Replies

Download a large file in StudioX made by @teslyak9437 with 22 replies.

How to extract integer from text made by @Smitesh_Aher2 with 19 replies.

Deserialize CSV to Data Table made by @Naman_Arora with 17 replies.

Top 3 Users Who Posted The Most

@vrdabberu made 52 posts!

@Anil_G made 51 posts!

@rlgandu made 23 posts!

Top 3 Most Liked Posts

This post made by @postwick received 2 likes!

Forum search is gone?

Am I crazy or is the forum search button gone? [image]

This post made by @inno received 2 likes!

Random Date in a Computer Vision input

Thanks vrdabberu @rlgandu @lrtetala it worked now it puts in the random Birth year in the field with computer vision!

This post made by @ppr received 2 likes!

How to write a query in UiPath.MocrosoftOffice365.Activities.Mail.Getmail to get conditioned emails

is similar to @Yoichi rigth? so @l.wang give a try and keep in mind that the UTC DateTime is to use [grafik]

Top 3 Most Liked Solutions

This solution provided by @pikorpa received 3 likes!

Not Able to get Attribute having specific element from XML file, using LINQ

Hey @sahilbaglat you can try use: (From el In xDOC.Descendants("Batch") Where el.Element("BatchID") IsNot Nothing AndAlso el.Element("BatchID").Value.Equals(str_Batch) Select el.Attribute("ProductionDate")).ToList() [image] [image] List<XAttribute>(1) { [ProductionDate="2024-01-23"] }

This solution provided by @mkankatala received 2 likes!

How to split text file's content based on blank lines?

Hi @surypratap.r → Store the input in a variable called Input. → Take for each activity to iterate the split text’s, give the below expression, System.Text.RegularExpressions.Regex.Matches(Input,"([\s\S]*?[A-Za-z]+[\s\s]+)(?=\s+[A-Za-z]+)|((?<=\s+)([A-Za-z]+[\s\S]+))") → Inside for each insert the Write Text file activity to write the each split item to each file. → Give the name of the file and increase the count to change the name for each file. Check the below workflow for better un…

This solution provided by @Yoichi received 2 likes!

Regex.Replace error help

Hi, Did you check it at locals panel? As it’s C# syntax , we can ignore it. (It’s not content of the variable) Can you also check it using MessageBox etc? The following may also help you. 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 | 07 February 2024

Top 3 Topics with Most Views

Dev Dives: Leverage APIs and Gen AI to power automations for RPA and software testing made by @robert.wagner with 72 views.

Add every 1000 row in one queue item made by @Hazem_Saleh with 65 views.

ブラウザ上にある複数のﾎﾞﾀﾝで同じ処理を繰り返す方法 made by @yuuki_inoue with 51 views.

Top 3 Topics with Most Replies

Need regex to find number or decimal in text made by @Deepak_Chawla with 18 replies.

Error with Upload File and Upload Files made by @Airun with 16 replies.

How to use the "Filter Table" from UiPath.Excel.Activities to filter for values that don't contain a string made by @Krithi1 with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 54 posts!

@rlgandu made 30 posts!

@mkankatala made 25 posts!

Top 3 Most Liked Posts

This post made by @robert.wagner received 3 likes!

Dev Dives: Leverage APIs and Gen AI to power automations for RPA and software testing

Hello UiPath Community! Eager to explore how APIs orchestrate seamless communication between different software applications? Ready to dive into the world of Gen AI and understand how it’s transforming automation with intelligent decision-making and adaptability? I’m Robert Wagner, Sr. Product Manager at UiPath and I am thrilled to invite you to our next Dev Dives session on February 22nd. In this session, we’ll discuss how APIs and Gen AI revolutionize RPA and testing automation. Join me to d…

This post made by @ppr received 3 likes!

[FirstAid] O365 Classic - Microsoft 356 Scope - GeneralException

This FirstAid Tutorial will describe how a generalException EXCEPTION thrown by / within a Microsoft O365 Scope can be handled. Introduction If the package UiPath.MicrosoftOffice365.Activities is updated or remodelled from a previous version, one of the Microsoft 356 Scope / O365 related activities used below may throw a generalException. RnD and Replication Scenario Microsoft 365 Scope | Configured Authentication Type: ApplicationIdAndSecret Get List Info

Visuals

[grafik]

Exception Det…

This post made by @lucas.stern received 2 likes!

Request: Shortcut to create a new variable in the upper most scope

Currently, when wanting to quick create a variable, we can use “Ctrl+K” shortcut. But this shortcut only create the variable in the local scope. If we want this variable in the upper most scope (workflow), then we have to manually change the scope in the Data Manager. I suggest a new shortcut that enable us to quick create a new variable in the workflow scope. (Maybe using the same behavior of compound shortcut like Microsoft Visual Studio where you press Ctrl+K and then another shortcut ) Whi…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Date comparison error _Panel

@marina.dutta As mentioned above if nssd and acm are datetime variables then directly use Nssd >= acm Or use DateTime.Compare(nssd,acm)>0 this gives true if nssd is greater Cheers

This solution provided by @Parvathy received 2 likes!

How to write all RegEx currentitems in one row order?

Not needed at all @paultech5 You can use the below syntax condiiton directly in Write Text File activity After both FInd Matching Patterns: "WorkshopItems="+String.Join(", ", RegExModID.Cast(Of Match)().Select(Function(m) m.Value.Trim()))+ Environment.NewLine + "Mods="+String.Join(", ", RegExModName.Cast(Of Match)().Select(Function(m) m.Value.Trim())) Hope it helps!!

This solution provided by @rlgandu received 1 likes!

Reading and Appending the Excel File

@NiraliPatel \Mac\Home\Documents\UiPath\Excel Reports\Daily Reports~$Shop1.xlsx. please close this file before running .Or simply Use Kill process activity in your workflow for killing Excel Process. [image] Check the package version of excel activitiy and reinstalled it again

---

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 February 2024

Top 3 Topics with Most Views

Replacing a word in a string during run time made by @raygandhit with 62 views.

...because it is being used by another process made by @anamariavioleta.dinca with 52 views.

Remove the character if that starts with the value of particular column in excel made by @learning_sourav with 47 views.

Top 3 Topics with Most Replies

Navigate to url if browser got no internet it went to next url. how can i throw system exeption in uipath made by @LOHITH_KUMAR_SAKA with 21 replies.

Issue while setting variable in Properties panel made by @Anagha_B with 20 replies.

Remove the character if that starts with the value of particular column in excel made by @learning_sourav with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 53 posts!

@Parvathy made 34 posts!

@postwick made 33 posts!

Top 3 Most Liked Posts

This post made by @ruchirmahajan received 2 likes!

Join us at DevCon Replay

Attending UiPath DevCon in person is exciting! Plus, having on-demand recordings is great for catching up if you miss anything. I can’t wait to learn, grow and network!

This post made by @rlgandu received 2 likes!

Remove duplicate rows in data table

@E.T.S Assign activity: combinedRows = dt1.AsEnumerable().Union(dt2.AsEnumerable(), DataRowComparer.Default).CopyToDataTable()

This post made by @supriya117 received 2 likes!

...incompatible with project's language

Hi @anamariavioleta.dinca Check this:

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

How to extract previous Month date value from Excel

@manjusree_R_N_manju , Apologies again . Could you check with the below : DT1 = DT.AsEnumerable.Where(Function(x)Not String.IsNullOrWhitespace(x("Month").ToString) andAlso CDate(x("Month").ToString).ToString("MMMyyyy") = Now.AddMonths(-1).ToString("MMMyyyy")).CopyToDatatable Do also check with other Solutions what @Shiva_Nikhil and @pikorpa provided as I believe it does have the implementation correct.

---

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 February 2024

Top 3 Topics with Most Views

UiPath Studio Web: A Beginner's Guide to Automation made by @Narender_Kalal with 40 views.

ChatGPTアクティビティの使い方について made by @kiki1 with 40 views.

UiPath Guid LINQ Query made by @Ritaman_Baral with 38 views.

Top 3 Topics with Most Replies

Project won't publish because of a deleted workflow made by @adext with 14 replies.

Selecting an element using idx made by @808101909 with 10 replies.

How to divide the 2 values when the type of the 2 values are double made by @Bhagyashree_S with 10 replies.

Top 3 Users Who Posted The Most

@vrdabberu made 41 posts!

@Anil_G made 28 posts!

@rlgandu made 27 posts!

Top 3 Most Liked Posts

This post made by @rlgandu received 1 likes!

Remove duplicated rows - in selected range

@E.T.S Sequence6.zip (2.0 KB) Please find the attached process hope it works for you

This post made by @nkdesai received 1 likes!

Run Command Insert statement have syntax error

Thank you @Parvathy for the solution

This post made by @Parvathy received 1 likes!

How to Select from within Array of Dictionary

Hi @toni.korhonen Try this syntax: selectedDict= array.FirstOrDefault(Function(x) x.ContainsKey("id") AndAlso x("id") = "123") Hope it helps!!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

Help creating aggregate report - group by count

HI, Can you try the following sample? dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r(0).ToString,r(1).ToString,r(2).ToString,r(3).ToString)).Select(Function(g) dtResult.LoadDataRow({g.Key.Item1,g.Key.Item2,g.Key.Item3,g.Key.Item4,g.Any(Function(r) r("Class Finals").ToString.ToLower="true" ),g.Count(Function(r) not String.IsNullOrWhiteSpace( r("Subject").ToString)),g.Any(Function(r) r("Due Resits").ToString.ToLower="true")},False)).CopyToDataTable Sample20240127-1aV2.zip (15.7 KB) Regards…

This solution provided by @pikorpa received 2 likes!

GetQueue items

Hey @A_Learner Yes, you can use LINQ to query the data obtained from “Get Queue Items” and count items by their status. These few examples should works fine queueItems.Count(Function(item) item.Status = QueueItemStatus.Successful) queueItems.Count(Function(item) item.Status = QueueItemStatus.Failed) queueItems.Count(Function(item) item.Status = QueueItemStatus.New) queueItems.Count(Function(item) item.Status = QueueItemStatus.InProgress)

This solution provided by @Yoichi received 1 likes!

Filtering Between Duplicates

Hi, FYI, another approach: dt = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("ID").ToString,r("Name").ToString)).Select(Function(g) dt.Clone.LoadDataRow(g.OrderByDescending(Function(r) CInt(r("Level"))).ThenBy(Function(r) CDate(r("Date"))).First.ItemArray,False)).CopyToDataTable [image] Sample Sample20240205-1.zip (9.9 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 | 10 February 2024

Top 3 Topics with Most Views

How to replace the blanks in a particular range made by @anjani_priya with 34 views.

Help Needed: SQL Query Against Excel with Special Characters in Column Names made by @TonyO with 33 views.

Javascript - select tag with specific criteria made by @bs113256 with 26 views.

Top 3 Topics with Most Replies

How to replace the blanks in a particular range made by @anjani_priya with 21 replies.

How to replace some values with other in multiple sheets at a time made by @anjani_priya with 8 replies.

Connecting uipath to Google Bigquery made by @3175472466 with 5 replies.

Top 3 Users Who Posted The Most

@Anil_G made 28 posts!

@anjani_priya made 16 posts!

@mkankatala made 10 posts!

Top 3 Most Liked Posts

This post made by @mikemanand received 1 likes!

Python Scope activity requires you to install the .NET Desktop Runtime 5.0.17

Hi @loginerror When we should expect this? Isn’t it possible to upgrade to .NET 8? I think that is the current latest version.

This post made by @AndyMenon received 1 likes!

Forms Designer - Columns Component: Styling renders items nearly invisible for Dark themes

Excellent! Thank You, Man from the Future!

This post made by @Hector1 received 1 likes!

Table extraction wizard doesn't fit with the Tables Pattern I need to scrap

It was usefull. It helped me to solve my asssign. Thank You!

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Read cell with numeric value in Excel

@E.T.S you can use preserve format …ideally it reads the backend value…may be your excel cell is formatted to display as currency as said change variable to genericvalue and use preserve format cheers

This solution provided by @mkankatala received 1 likes!

How can i get and seperate this text in 3 different variables from a website?

Hi @170290064 First, use the Get text activity to extract the data and store in a Variable called Input_Str. - Assign -> ClientID [String Datatype] = System.Text.RegularExpressions.regex.Match(Input_Str.toString,"(?<=Client ID:\s+).*").Value - Assign -> ClientName [String Datatype] = System.Text.RegularExpressions.regex.Match(Input_Str.toString,"(?<=Client Name:\s+).*").Value - Assign -> ClientCountry [String Datatype] = System.Text.RegularExpressions.regex.Match(Input_Str.toString,"(?<=Clie…

This solution provided by @Anil_G received 1 likes!

Doubt in pdf automation selectors

@anjani_priya Should get ocr text activity with try cacth…by placing it in try block…and in catch block add a exception…so that when ever there is a empty string the exception is caught and we can move to next file Cheers

---

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

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

[system]

Daily Forum Report | 11 February 2024

Top 3 Topics with Most Views

Wrong format of decimal numbers when reading csv - possibly bug made by @dhubak with 43 views.

C sharp made by @Madhuri_kushwaha1 with 35 views.

How to upload Zip file one by one? made by @Samraat_Maharjan1 with 34 views.

Top 3 Topics with Most Replies

Wrong format of decimal numbers when reading csv - possibly bug made by @dhubak with 24 replies.

https://forum.uipath.com/t/718819 made by @neco with 14 replies.

How to upload Zip file one by one? made by @Samraat_Maharjan1 with 12 replies.

Top 3 Users Who Posted The Most

@Yoichi made 16 posts!

@dhubak made 12 posts!

@vrdabberu made 11 posts!

Top 3 Most Liked Posts

This post made by @Parvathy received 1 likes!
https://forum.uipath.com/t/718819/5

This post made by @Yoichi received 1 likes!

How to save the excel file as other file

Hi, If you want to the file named AppNum, can you try to add “.xlsx” as the following in MoveFile activity? "D:\User\Desktop\RPA_Tier2\Completed"+"\"+AppNum+".xlsx" Or if you want to move the file in AppNum folder, can you try to create the folder in advance? [image] Regards,

This post made by @Yoichi received 1 likes!

Wrong format of decimal numbers when reading csv - possibly bug

Hi, Which WriteRange activity do you use? At least, WriteRangeWorkbook seems to work well. How about using this? Regards,

Top 3 Most Liked Solutions

This solution provided by @ABHIMANYU_THITE1 received 2 likes!

Types of Exceptions

Hi @E.T.S System.ArgumentException: This exception occurs when an invalid argument is passed to a method or activity in UiPath. For example, if you try to pass a null value to a method that doesn’t accept null arguments, you might encounter this exception. System.NullReferenceException: This exception occurs when you try to access or manipulate an object that is null. In UiPath, this might happen if you’re trying to use an activity or variable that hasn’t been properly initialized or assig…

This solution provided by @vrdabberu received 1 likes!

Find empty column name in datatable

Hi @Arettu63 → Read Range Workbook Output-> dt → Use below syntax in Assign columnsToCheck= {"Name","Age","City"} List= (From row In dataTable.AsEnumerable() Let index = dataTable.Rows.IndexOf(row) Let emptyColumns = columnsToCheck.Where(Function(col) String.IsNullOrEmpty(row(col).ToString())).ToList() Where emptyColumns.Count > 0 Select "Index " & index.ToString() & ", columns " & String.Join(",", emptyColumns)).ToList() col…

This solution provided by @rlgandu received 1 likes!

Division Formula_LINQ

@Balachander_Pandian (From row In Dt.AsEnumerable() Let IGST_CGST = Convert.ToDouble(row("IGST_CGST")) Select Dt.Clone().Rows.Add(row.ItemArray.Take(2).ToArray().Concat({IGST_CGST / 2}).ToArray())).CopyToDataTable() [image] [image]

---

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

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

[system]

Daily Forum Report | 12 February 2024

Top 3 Topics with Most Views

Ui Path Studio Issue made by @Progressive_RA_DC with 54 views.

LINQ - Split data made by @Vandekamp with 54 views.

HTTP request with XML input made by @Povilas_Jonikas with 44 views.

Top 3 Topics with Most Replies

Generate data table with row index of duplicate rows in table and number of duplicates in table made by @E.T.S with 21 replies.

Regex code to get the ISIN number made by @Priyesh_Shetty with 15 replies.

Recent Date made by @0bb4628e217fd43ac86ac9294 with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 38 posts!

@ppr made 23 posts!

@rlgandu made 22 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Json limitation

Perfect so the topic can be closed Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum

This post made by @RobotReader received 1 likes!

How to use LINQ for Processing an Array?

This video may be useful: Using LINQ with Array in UiPath

This post made by @mkankatala received 1 likes!

Regex for Date- Uipath activity

Hi @Anjali_Rani Check the below one, \d+\s*\w+\s*\d+ Check the below image for better understanding, [image]

Top 3 Most Liked Solutions

This solution provided by @pikorpa received 2 likes!

AsEnumerable Data Table - Count rows

hey @Ruy_Codo dtTransactionData.AsEnumerable().Count(Function(row) row("Ref. to other vendor").ToString.Length = 5).ToString() dtTransactionData.AsEnumerable().Count(Function(row) row("Ref. to other vendor").ToString.StartsWith("9")).ToString() dtTransactionData.AsEnumerable().Count(Function(row) Not row("Ref. to other vendor").ToString.StartsWith("9") AndAlso row("Ref. to other vendor").ToString.Length <> 5).ToString()

This solution provided by @Yoichi received 1 likes!

Remove the character if that starts with the value of particular column in excel

Hi, Can you try the following sample? [image] dt.AsEnumerable.Where(Function(r) r("Ref_ID").ToString.StartsWith("9")).ToList().ForEach(Sub (r) r("Ref_ID")=r("Ref_ID").ToString.SubString(1) End Sub ) Sample20240208-1.zip (11.5 KB) Regards,

This solution provided by @postwick received 1 likes!

Time difference queue activities

No, Reference isn’t part of SpecificContent. It’s part of the queue item object itself. You get it with yourQueueItemVar.Reference For any variable you can always just type it into an expression box and then type a . at the end to see all the properties. [image] But the real point to the Reference is you can use it for filtering with Get Transaction or Get Queue Items, and also enforce unique reference on the queue itself (setting in Orchestrator) so that duplicate items cannot be added 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 | 13 February 2024

Top 3 Topics with Most Views

Get text doesnt detect right target element (selectors) made by @Harish_saravanan_R with 57 views.

Continue activity error-'activity can only be place inside a loop' made by @Anelisa_Bolosha1 with 50 views.

Attachment name save made by @Anelisa_Bolosha1 with 48 views.

Top 3 Topics with Most Replies

Attachment name save made by @Anelisa_Bolosha1 with 17 replies.

Why I can assign ROW to value? / made by @Happydayyy with 13 replies.

Close Pop-Up Using On Element Appear Activity made by @Anirudh_Tugawe with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 33 posts!

@rlgandu made 30 posts!

@vrdabberu made 27 posts!

Top 3 Most Liked Posts

This post made by @Jeroen_van_Loon received 3 likes!

Does it make sense to use parallel activity?

Parallel: you have two or more parallel flow that are executed at the same time. While it might not be exactly parallel it’s close enough. It’s actually not that useful in RPA, especially if that part of the flow involves UI elements. Yes, you can enter 12 values in 12 fields into a form and gain a second or two in performance, but as soon as any pre submit processing is involved in the UI, which is more common than you think, you’ll run into all kinds of exotic problem. Always consider that a …

This post made by @pikorpa received 2 likes!

Removing rows after specified cell

Hey @E.T.S did you try this: YourDataTable.AsEnumerable().Take(5).Concat(YourDataTable.AsEnumerable().Skip(5).Where(Function(row) Not row.ItemArray.All(Function(field) String.IsNullOrEmpty(field.ToString())))).CopyToDataTable()

This post made by @steve.matthew received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello Hello, I am new to UiPath, my name is Steve and I’m here to explore UiPath hope to see you all in the forums and looking forward to get connected with you all

Top 3 Most Liked Solutions

This solution provided by @rlgandu received 1 likes!

Remove duplicated rows - in selected range

@E.T.S Sequence6.zip (2.0 KB) Please find the attached process hope it works for you

This solution provided by @Yoichi received 1 likes!

ChatGPTアクティビティの使い方について

途中まで試したのですが、入力の時点でうまくいきません。 どのようにうまくいかないのでしょうか？ １００００文字程度を入力する場合は、有料版を利用した方が無難なのでしょうか？？ 上記の最初のPOSTにも記載しましたが、 この手の自動化は可能であればAPI経由で行った方が安定すると思います。 と思います。 画面が変わっているだけかもしれませんので、現状に合わせて作り直せば動くかもしれませんが、また変更が入るかもしれませんので

This solution provided by @vrdabberu received 1 likes!

Table extraction wizard doesn't fit with the Tables Pattern I need to scrap

Hi @Hector1 If Table Extraction wizard is not working, and if you would like to work with screen scraping or Data scraping option check the below thread to get those option in UiPath Studio and try extracting the table once. 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 | 14 February 2024

Top 3 Topics with Most Views

How to calculate file size in mb made by @Smitesh_Aher2 with 54 views.

Select Case, Switch case made by @jmedinacarbonell with 49 views.

Reframework_System exception made by @Pavan_kumar15 with 48 views.

Top 3 Topics with Most Replies

Where is screen scraping in uipath tab made by @anjani_priya with 18 replies.

How to loop made by @nidhi.kowalli1 with 16 replies.

How to calculate file size in mb made by @Smitesh_Aher2 with 15 replies.

Top 3 Users Who Posted The Most

@Happydayyy made 33 posts!

@mkankatala made 23 posts!

@Anil_G made 23 posts!

Top 3 Most Liked Posts

This post made by @mkankatala received 2 likes!

VB Apps documentation and help articles

Hi @savantsa In the New version VB UiPath apps, the value binding is removed instead of that you can use Set value. Follow the below step by step guide to save the value in a variable for dropdown control, → Click on the dropdown control → Go to Events → Click on Edit rule → Click on + icon → Search for Set value → Create a Variable in Item to set field in Set value → Give like this in value field “MainPage.Dropdown.SelectedItem.ToString”. The selected item in dropdown will save in the crea…

This post made by @Jeroen_van_Loon received 2 likes!

How to write on in a PDF with Uipath?

I have a code snippet for it, combining 1-2 free to use pdf libraries and then invoking certain methods using invoke code. I use it to do the same, write some text in an existing pdf. In my use case, a footer text at the bottom of the document but it all comes down to the same thing. (You can use offset coordinates to place the text). I don’t have direct access to this code example, and when I do I need to remove some sensitive elements for it first before I can post it here, but I’ll try and s…

This post made by @mkankatala received 1 likes!

How to solve number issue /

Hi @Happydayyy In the Input data may be there is empty row with item number. That’s why it was not deleted if you want to delete the last row in the excel you can use the Delete rows activity. → Use the Excel Process scope activity and insert the Use excel file inside of it. → Pass the Excel file path in the Use excel file activity. → Inside Use excel file activity insert the Find find/last row activity to get the last row number. Give the source field value as Excel.Sheet(“FA for 4N”) G…

Top 3 Most Liked Solutions

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

Connecting uipath to Google Bigquery

@3175472466 e.g. if your datasource is called BQ-SVC, set connection string = "Dsn=BQ-SVC" provider name = "System.Data.Odbc" [image]

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

Javascript - select tag with specific criteria

@bs113256 try the following document.querySelectorAll("ul li[class^='jsx']:has(a[href^='/search']:not([hidden]))");

This solution provided by @vrdabberu received 1 likes!

Reframework queue state

Hi @pavan_kumar If the maximum retry is set to 2 and the maximum consecutive retry is set to 3, then the maximum consecutive retry will be executed. This means that the system will attempt the operation up to 3 times consecutively before considering the attempt a failure, regardless of the maximum retry limit 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 | 15 February 2024

Top 3 Topics with Most Views

How to send an outlook mail in UiPath made by @naveen5 with 66 views.

Delete values except the particular word from a column in excel made by @yashashwini2322 with 47 views.

Eliminar datos nulos o con "," made by @jorge_morales with 42 views.

Top 3 Topics with Most Replies

Regex- extracting data from text file made by @abivanth.r with 26 replies.

Delete values except the particular word from a column in excel made by @yashashwini2322 with 24 replies.

How to send an outlook mail in UiPath made by @naveen5 with 22 replies.

Top 3 Users Who Posted The Most

@Happydayyy made 22 posts!

@vrdabberu made 22 posts!

@rlgandu made 19 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Replace word in variable

Hi, FYI, another approach: If you use StudioX, ModifyText activity works as the following. [image] Regards,

This post made by @Jon_Smith received 2 likes!

ComputerVision is amazing

In a previous role I had to build a robot, which meant I had to open a Citrix VM and then interact with a Citrix hosted app… I was furious at the sales team for not properly determining the complexity and over promising, I did eventually make a stable solution, but only because CV saved my ass. I did actually even get the UiPath remote Runtime installed all the way down, the application still didnt have full selectors cause it was that bad.

This post made by @Shyam_Pragash received 2 likes!

Downloading File using Chrome giving error

You can also whitelist entire websites via Chrome’s settings: Settings > Security and Privacy > Site Settings > Insecure Content. Under Allowed to show insecure content click “Add” and enter the main website URL and click “Add”. Issue Solved

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to save the excel file as other file

Hi, If you want to the file named AppNum, can you try to add “.xlsx” as the following in MoveFile activity? "D:\User\Desktop\RPA_Tier2\Completed"+"\"+AppNum+".xlsx" Or if you want to move the file in AppNum folder, can you try to create the folder in advance? [image] Regards,

This solution provided by @Yoichi received 1 likes!

Wrong format of decimal numbers when reading csv - possibly bug

Hi, Which WriteRange activity do you use? At least, WriteRangeWorkbook seems to work well. How about using this? Regards,

This solution provided by @ppr received 1 likes!

For each excel row from bottom up

Based on your inputs a regex could look like this: [grafik] with refering to Groups: [grafik] And above suggestion just need a small adaption Assign Activitiy dtResult = dtDataClone Assign Activity dtResult = (From d in dtData.AsEnumerable Let mts = System.Text.RegularExpressions.Regex.Matches(d("Items").toString, "([A-Z]) (\d+)") From m in mts.Cast(Of Match) Let ra = new Object(){d("ID"), m.Groups(1).Value, m.Groups(2).Value } Select r = dtResult.Rows.Add(ra)).CopyToDataTable

---

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 February 2024

Top 3 Topics with Most Views

2個以上全角スペースが存在したらそれ以降を切り捨てて、String変数に残りを代入したい made by @gorby with 60 views.

Problem with CV Screen Scope made by @hanikf with 49 views.

How to find week No for given data format made by @NISHITHA with 47 views.

Top 3 Topics with Most Replies

Regular expression for the text need made by @T_Y_Raju with 19 replies.

How to find week No for given data format made by @NISHITHA with 15 replies.

How can we query whether the item is in the output or not with linq? made by @Bedirhan_Ozkan with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 33 posts!

@Yoichi made 20 posts!

@Parvathy made 19 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 7 likes!

UiPath Community MVP 2024 announcement!

I feel privileged to be included in such an exceptional community! Congratulations to all the other MVPs!

This post made by @afe.araromi received 6 likes!

UiPath Community MVP 2024 announcement!

I’m honoured once again to be part of UiPath’s incredible family of Community MVPs. Congratulations to the other 124 champions of the 2024 tenure.

This post made by @adiijaiin received 5 likes!

UiPath Community MVP 2024 announcement!

I consider it a privilege to be a part of such an extraordinary Community. The sense of unity and shared purpose is truly inspiring. It’s not just about belonging, but also about contributing to something larger than oneself. I am truly honored. Congratulations to all the MVPs! Cheers!

Top 3 Most Liked Solutions

This solution provided by @CosminV received 2 likes!

Filter QueueItems on Specific Content via API - will it be removed soon?

The API call odata/QueueItems?$filter=contains(SpecificData,'"Key1":"value1"') will continue to work as expected, it will filter the results based on the SpecificData field. The announcement refers only to the data returned by the API call.

This solution provided by @Anil_G received 1 likes!

Regex for Date- Uipath activity

@Anjali_Rani Please try this \d{1,2} [a-zA-Z]* \d{4} [IMG_6800] Added screenshot of results Cheers

This solution provided by @ptrobot received 1 likes!

Get content of zip file - Character encoding

Have you tested to provide the encoding in the ZipArchive constructor instead? ... using (FileStream zipFileStream = File.Open(in_ZipFile, FileMode.Open)) { using (ZipArchive zipArchive = new ZipArchive(zipFileStream, ZipArchiveMode.Read, false, System.Text.Encoding.GetEncoding("437"))) { foreach (ZipArchiveEntry entry in zipArchive.Entries) { fileNames.Add(entry.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 | 17 February 2024

Top 3 Topics with Most Views

Hello Everyone, hope you all are doing great, so I need your help regarding mobile made by @steve.matthew with 45 views.

How to convert Text to double? made by @saileela with 45 views.

Linq code to join and update value made by @sathya_giri with 42 views.

Top 3 Topics with Most Replies

Linq code to join and update value made by @sathya_giri with 14 replies.

Suggest a VB.net Code to remove spaces in Column A of the excel made by @Gopi_Krishna1 with 10 replies.

Can't get Code Source Files to work made by @oyvind.restad with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 20 posts!

@vrdabberu made 12 posts!

@Parvathy made 9 posts!

Top 3 Most Liked Posts

This post made by @AndyMenon received 3 likes!

UiPath Community MVP 2024 announcement!

[20240216_063034_HDR] @Corina_Gheonea at DevCon 2024 … Uipath MVPs are individuals with the greatest heart! What can I say other than shamelessly borrow her words! Congratulations to all MVPs!

This post made by @Vishal_Kalra received 2 likes!

UiPath Community MVP 2024 announcement!

Privileged and honored to be part of this group this year as well ( it being my second year as MVP). Looking forward to contribute and grow together!

This post made by @Jobin_Joy received 2 likes!

UiPath Community MVP 2024 announcement!

Congratulations to all MVPs! Very excited and looking forward to collaborate together.

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Sending mutiple email at one go from Array

@shashank_dullu Can you please tell which send email activity is that? if it needs array then use in_Config("strSender").ToString.Split(";"c).ToArray cheers

This solution provided by @postwick received 1 likes!

Get Newest Email (MicrosoftOffice365 Activity)

I have never used this activity, but I have done “get the code from the verification email” just by using the Query property in the Get Mail (Office 365 - Classic) activity inside Microsoft Office 365 Scope. Typically I tell it just to get the “top 1” email with a received date within the last 5 minutes, or 24 hours, or whatever is appropriate for your automation. If it returns no emails, then it didn’t find the verification email that was sent. If it finds one, it returns the latest one. Fo…

This solution provided by @mkankatala received 1 likes!

Continue activity error-'activity can only be place inside a loop'

Hi @Anelisa_Bolosha1 Continue activity has to be use inside the loop only, Are you using any loop for iteration, and you are checking the element exist inside loop, → If yes, then in then block in If condition place the Break activity to break the loop if element exist. → If not just ignore the else block. it will go for next iteration no need to use continue activity. Hope it helps!!

---

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

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

[system]

Daily Forum Report | 18 February 2024

Top 3 Topics with Most Views

Filter the data column "first name" at every sheet made by @Hemant_Deshmukh with 37 views.

How to move files older than today's date to other folder made by @8b6861dc5e0c9f7008548ca66 with 35 views.

Mass automation for an organization or team made by @youssef169886 with 34 views.

Top 3 Topics with Most Replies

Data labelling in AI Center made by @Aditi_Jha with 11 replies.

Leer Archivo de excel made by @jorge_morales with 9 replies.

How to change extension made by @dipon1112000 with 6 replies.

Top 3 Users Who Posted The Most

@Anil_G made 30 posts!

@vrdabberu made 12 posts!

@Aditi_Jha made 8 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

UiPath Community MVP 2024 announcement!

Congratulations Everyone and keep up the good work. Hope to collaborate with as many as possible

This post made by @Nithinkrishna received 1 likes!

UiPath Community Forum product release: Explore your new user experience with our latest developments

This is going to be super useful !

This post made by @rajaneesh received 1 likes!

UiPath Community MVP 2024 announcement!

Congratulations to all deserving MVPs. I wish you all the best and look forward to interacting in the near future.

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 2 likes!

VB Apps documentation and help articles

Hi @savantsa In the New version VB UiPath apps, the value binding is removed instead of that you can use Set value. Follow the below step by step guide to save the value in a variable for dropdown control, → Click on the dropdown control → Go to Events → Click on Edit rule → Click on + icon → Search for Set value → Create a Variable in Item to set field in Set value → Give like this in value field “MainPage.Dropdown.SelectedItem.ToString”. The selected item in dropdown will save in the crea…

This solution provided by @mkankatala received 1 likes!

How to solve number issue /

Hi @Happydayyy In the Input data may be there is empty row with item number. That’s why it was not deleted if you want to delete the last row in the excel you can use the Delete rows activity. → Use the Excel Process scope activity and insert the Use excel file inside of it. → Pass the Excel file path in the Use excel file activity. → Inside Use excel file activity insert the Find find/last row activity to get the last row number. Give the source field value as Excel.Sheet(“FA for 4N”) G…

This solution provided by @ppr received 1 likes!

To assign selective column /

@Happydayyy we support you on your several topics, but also encounter, that these topics are not straightforward handled in flow topic creation - use case description clearing of requirements, if needed solving topic closing We also prefer to scope 1 topic = 1 case. This strict pattern helps other reasearchers faster to find solutions for similiar cases initial this topic was about: shortening a data table on a subset of columns with: a new case is inserted in this topic, where we prefer…

---

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 February 2024

Top 3 Topics with Most Views

I need help as a beginner :) made by @Erdem_Ozbay with 68 views.

ーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーー made by @neco with 52 views.

How to check if specific data is available or not in Excel using Uipath made by @Baby123 with 52 views.

Top 3 Topics with Most Replies

How to highlight the duplicates in excel made by @Deeksha with 19 replies.

ーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーー made by @neco with 14 replies.

How to check if specific data is available or not in Excel using Uipath made by @Baby123 with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 21 posts!

@mkankatala made 14 posts!

@pikorpa made 12 posts!

Top 3 Most Liked Posts

This post made by @Harika_Mudiam received 3 likes!

UiPath Community MVP 2024 announcement!

Congratulations Everyone and looking forward for more collaboration.

This post made by @rikulsilva received 3 likes!

UiPath Community MVP 2024 announcement!

Congratulations to all MVPs Looking forward to collaborate together

This post made by @AutomationX_by_Kiran received 3 likes!

UiPath Community MVP 2024 announcement!

Congratulations to all MVP’s of 2024

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

File Name Doesnot Exist

Use file exist activity before the rename file activity to check the file exist or not. The output of File exist activity is Boolean datatype variable called bool_file. Insert If activity to check the condition - Condition -> bool_file = True In then block insert rename file activity to rename the file. Delete the Rename file activity and insert it again and pass the variables. Note - In the file_Name variable remove the .pdf extension at last. Hope you understand!!

This solution provided by @efelantti received 1 likes!

Datetime.Now bringing back wrong time

Lowercase “hh” means hours from 01 to 12. To get hours from 0 to 23 you need to use “HH”. “ss” means seconds - in your code there’s seconds slot in place of minutes.

This solution provided by @pikorpa received 1 likes!

<REGEX> Extract 2 numbers from a single string

Hey @anjasing you can try use this: System.Text.RegularExpressions.Regex.Match(yourInputStringVariable, "\d*302\b").Value System.Text.RegularExpressions.Regex.Match(yourSecondInputStringVariable, "\d*123F\b").Value

---

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 February 2024

Top 3 Topics with Most Views

How to replace special characters in excel made by @sathish_Kumar6 with 66 views.

Delete Temp files for VM for different user using the main user made by @Kunal_Jain with 56 views.

Adding Index Column in DataTable using LINQ made by @NILESH.BOT369 with 55 views.

Top 3 Topics with Most Replies

How to replace special characters in excel made by @sathish_Kumar6 with 22 replies.

Adding Index Column in DataTable using LINQ made by @NILESH.BOT369 with 17 replies.

Datascraping getting first attribute value from row made by @sdyre with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 32 posts!

@ppr made 30 posts!

@rlgandu made 24 posts!

Top 3 Most Liked Posts

This post made by @Aswin_Bhaskar received 4 likes!

UiPath Community MVP 2024 announcement!

Congratulations to all the MVPs​:sparkles: So proud to be a part of this amazing UiPath community!!

This post made by @balupad14 received 4 likes!

UiPath Community MVP 2024 announcement!

Congratulation to all MVPs and thank you

This post made by @ppr received 2 likes!

Adding Index Column in DataTable using LINQ

we can avoid the LINQ and achieve it by: Build DataTable - Configure an empty DataTable with 1 Col - RowNum, Configure AutoIncrement [grafik] dtMarked Then use a Merge DataTable Activity and merge your DataTable into dtMarked

Top 3 Most Liked Solutions

This solution provided by @Divyaprakash_DP received 2 likes!

Getting Started with Custom HTMLControl

Hi @Shivangi_Patankar You can refer to this following section in the documentation to better understand how to access App variables inside a Custom HTML control: Apps - Custom HTML. If you wish to access all the data in an entity inside an HTML control, you can create an app variable of type ‘ListSource of Entity’. Alternatively, if you want to obtain a specific record in the Entity, you can create an App variable of the respective Entity type. On the page load event, create a ‘Set value’ rule…

This solution provided by @pravallikapaluri received 1 likes!

How can we query whether the item is in the output or not with linq?

Hi @Bedirhan_Ozkan jsonResponse.Select(Function(x) x.Item("gecerlilik Tarihi").ToString).Any(Function(y)y.Contains("20240101"))

This solution provided by @ppr received 1 likes!

Test Text in RegEx Builder show that regex works, but nothing in output

there a some doubts if maybe sample data and real data are diverged (especially the \r\n representation of Line Breaks) But we can see: utbetalare and Summa are not in the same lines the regex dot (.) is exluding \n [grafik] instead of dot you can rewrite to: Utbetalare[\s\S]+?Summa

---

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.