Forum Engagement Daily Reports

[system]

Daily Forum Report | 31 January 2023

Top 3 Topics with Most Views

Outlook Issue- Is there any robust solution for using the Outlook on bot machine? made by @shreyash_shirbhate with 57 views.

What language is best to use if you start your automation journey now? C# vs VB.Net? made by @christel.andersson with 40 views.

Running problem due to resolution made by @mironb with 40 views.

Top 3 Topics with Most Replies

Replace blank value in datable with NA made by @Neha_Aggarwal1 with 23 replies.

Send Email with Multiple attachment made by @pravin_bindage with 15 replies.

Running problem due to resolution made by @mironb with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 50 posts!

@ppr made 26 posts!

@Sudharsan_Ka made 23 posts!

Top 3 Most Liked Posts

This post made by @fernando321 received 2 likes!

Cannot Retrieve latest UiPath.UiAutomation.Activities - error

Trying to retrieve UiPath.UiAutomations.Activities 22.10.5 was causing error. Confirmed no blockers in networking side. Came across updated URL for the Packages (in the 2022.10 documentation). Once added to Studio, the activity downloaded. https://pkgs.dev.azure.com/uipath/public.feeds/_packaging/UiPath-Official/nuget/v3/index.json Hopefully this saves others much research and troubleshooting time!

This post made by @ppr received 2 likes!

How to get the last row value from a datatable

YourDataTable.AsEnumerable.Last() - will return last Datarow lets assume a particular column value from the last row YourDataTable.AsEnumerable.Last()(ColNameOrIndex)

This post made by @supermanPunch received 2 likes!

Second-highest date

Hi @sayed.tabrez , Assuming you have already read the Data from the Excel as a Datatable, you can Check with the below Expression : SecondHighestDate = DT.AsEnumerable.OrderByDescending(Function(x)CDate(x("YourBirthDateColumnName").ToString))(1).ToString Here, SecondHighestDate is of the Type String, and DT is the Datatable variable. Let us know if the above expression does not work.

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

Second-highest date

Hi @sayed.tabrez , Assuming you have already read the Data from the Excel as a Datatable, you can Check with the below Expression : SecondHighestDate = DT.AsEnumerable.OrderByDescending(Function(x)CDate(x("YourBirthDateColumnName").ToString))(1).ToString Here, SecondHighestDate is of the Type String, and DT is the Datatable variable. Let us know if the above expression does not work.

This solution provided by @Aakash_Singh_Rawat received 2 likes!

How i can get alternative values from excel like row 1 and row 3 odd row except even row

Hi @sayed.tabrez, Use assign: odd_dt = dt.AsEnumerable.Where(Function(x) Not dt.Rows.IndexOf(x) Mod 2=0).CopyToDataTable where dt is your output datatable used in Read Range. Please mark this as solution if it solves your problem.

This solution provided by @fernando_zuluaga received 1 likes!

Filtrar un email outlook

Hola puedes probar con el siguiente codigo [image] (From m In mailMessages Where m.Subject.Trim.Contains("yournumber") Select m).ToArray Saludos

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

@Yoichi received 57 likes for their solutions!

@Anil_G received 56 likes for their solutions!

@Kaviyarasu_N received 27 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.