Forum Engagement Daily Reports

[system]

Daily Forum Report | 16 March 2022

Top 3 Topics with Most Views

How to count the number of blank items in a datatable? made by @Pruthvi.G with 62 views.

Split text ,? made by @fairymemay with 60 views.

Invoke workflow & Terminate workflow? made by @vivek_sinha with 56 views.

Top 3 Topics with Most Replies

Date question made by @cury with 29 replies.

https://forum.uipath.com/t/407522 made by @Futurised with 20 replies.

How to use right click or crtl +s in new browser tabs? made by @Rodrigo_Buch with 17 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 50 posts!

@ashwin.ashok made 38 posts!

@Palaniyappan made 34 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

How to handle periodically missing item from the dropdown menu when using Select Item activity?

Depending on the type of dropdown an element exists with dynamic selector to the option element from the dropdown select element could be an alternate to find children. A benefit of find children is that we do have more control when evaluating the found children. Keep in mind that find children will return uielements. So an evaluation on the value could look like this (check on innertext attribute) FindChildrenOutPut.Any(Function (x) x.Get("innertext").toString.Trim.Equals(YourSearchValue)) …

This post made by @Palaniyappan received 2 likes!

How to count the number of blank items in a datatable?

Hi If you want to delete the empty rows considering the whole DATATABLE then DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Or If you want to delete empty rows based on one column DatatableName = DataTableName.Select("Convert(column3, System.String)< >''").CopyToDataTable() or Datatablename = DataTableName.Select("column3< >''").CopyToDataTable() Cheers @Pruthvi.G

This post made by @komal.v.konduru received 2 likes!

Cannot select the pop up

@Palaniyappan Thanks, Sir. Those really helped me. @nikhil.girish @Gokul001 Thanks mates your valuable messages helped me a lot.

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

How to handle periodically missing item from the dropdown menu when using Select Item activity?

Depending on the type of dropdown an element exists with dynamic selector to the option element from the dropdown select element could be an alternate to find children. A benefit of find children is that we do have more control when evaluating the found children. Keep in mind that find children will return uielements. So an evaluation on the value could look like this (check on innertext attribute) FindChildrenOutPut.Any(Function (x) x.Get("innertext").toString.Trim.Equals(YourSearchValue)) …

This solution provided by @Palaniyappan received 1 likes!

Pass variable to array?

Mention like this if the variable name is Strinput Enumerable.Range(0,dt_configRate.RowCount).Select(Function(s) dt_configRate.Rows(s)(Convert.ToInt32(Strinput.ToString)).ToString).ToArray() Cheers @fairymemay

This solution provided by @ppr received 1 likes!

How to count the number of blank items in a datatable?

find starter help here: Check_dtHasBlanksInAnyCol.xaml (6.9 KB)

---

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.