Forum Engagement Daily Reports

[system]

Daily Forum Report | 23 February 2023

Top 3 Topics with Most Views

The status that it shows "In process" and "Completed" made by @Bhushan_Nagaonkar with 44 views.

Decoding Excel file from HTTP Request made by @Erikas_Martinaitis with 42 views.

How to make unattend robot unlocked the screen made by @Zoeyu with 42 views.

Top 3 Topics with Most Replies

Element changes after hovering made by @dyvo with 21 replies.

How to get the Excel data Values by increasing value of cell value one by one made by @chandolusathi.kumar with 16 replies.

Merge excel files into 1 made by @Juandix with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 56 posts!

@ppr made 26 posts!

@postwick made 23 posts!

Top 3 Most Liked Posts

This post made by @Savan_S_Bangoria received 3 likes!

How to sum up the duplicates values

Hi @T_Y_Raju , First you will have to filter the data based on the fff column to consider only rows containing PA2 and then you can use the following code to get the sum of the duplicate columns. add this in the assign statement and add your datatable instead of dt (From row In dt.AsEnumerable Group row By key = New With { Key.group = row.Item(“aaa”).ToString.Trim } Into grp = Group Select dt.LoadDataRow(New Object() { Key.group, grp.Select(Function(x) x(“bbb”).ToString).First, grp.Selec…

This post made by @Ali_Gunawan_S.Kom_M.M received 2 likes!

It doesn't feel like it's been 3 years of learning RPA

Hi All, At the beginning of 2020 I learned RPA Studio X and Studio, at first I thought RPA was something related to Robots or Robotic Machines like Factory, but after I studied I was quite surprised, it turns out that RPA is something that is easy to learn because it’s low code and it looks like it’s easy. RPA, all digital things on the computer can be automated, after studying I finally took the certification exam and successfully passed it, then from the university it gave me a very extraordi…

This post made by @ignasi.peiris received 2 likes!

String was not recognize valid date time

As @supermanPunch suggested, using DateTime.ParseExact would be the Go-To solution to convert strings to date, and then work with DateTime functions. CDate, Convert.ToDateTime, DateTime.Parse tend to fail with certain type of dates. DateTime.ParseExact lets you write the exact format (in this case it would be “dd/MM/yyyy”, but also an array of possible formats Hope this helps!

Top 3 Most Liked Solutions

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

How can I import linq and other libraries into invoke code activity?

@ext-o can you try use the import pane instead [image]

This solution provided by @supermanPunch received 1 likes!

String was not recognize valid date time

Hi @satish.rathi59 , Could you Check with the below Expression : DateTime.ParseExact(str_ETADate,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture).AddDays(-Cint(str_MapTransitTime)).ToString("dd/MM/yyyy")

This solution provided by @Gokul_Jayakumar received 1 likes!

Date time condition

Hello @Kevin_Maurice Initially Convert the String into Date Time Format using Use read range activity and store data as DT Use For Each loop data table. and try below conditions DateTime.ParseExact(CurrentRow(0).tostring.trim,"yyMMddHHmm",System.Globalization.CultureInfo.InvariantCulture()) If Condition (DateTime.ParseExact(CurrentRow(0).tostring.trim,"yyMMddHHmm",System.Globalization.CultureInfo.InvariantCulture()).TimeOfDay>DateTime.ParseExact("10:15","HH:mm",System.Globalization.Cultur…

---

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.