Forum Engagement Daily Reports

[system]

Daily Forum Report | 17 June 2024

Top 3 Topics with Most Views

Creating several Global variables made by @ymshin0421 with 48 views.

Net Weaver Portal - Server not connected issue made by @anjali123 with 48 views.

How to get the specific Row Number in excel? made by @z1185399190 with 47 views.

Top 3 Topics with Most Replies

Extract specific text from HTML code with Regex made by @Maxime_LAUGIER with 15 replies.

How to get the specific Row Number in excel? made by @z1185399190 with 11 replies.

Problem with CV Scope/Click/attach Window not recognizing elements in Desktop application! made by @rohan.dhole with 11 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 41 posts!

@Anil_G made 37 posts!

@ppr made 22 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Variable selector

@A_Learner [image] hope this clarifies cheers

This post made by @ppr received 2 likes!

How to reorder the column

A formal reminder on the method signature: [grafik] So we are using an array

This post made by @ppr received 2 likes!

How to compare two lists(String)?

@Guru_Koli21 LINQ learning resources:

Top 3 Most Liked Solutions

This solution provided by @lchirathapudi received 1 likes!

How to get the specific Row Number in excel?

Hi @z1185399190 Try this String.IsNullOrEmpty(CurrentRow.ByField("ColumnName").ToString) Or String.IsNullOrWhiteSpace(CurrentRow.ByField("ColumnName").ToString) [image] Thanks, Pallavi

This solution provided by @vrdabberu received 1 likes!

Issue in finding the date difference

Hi @mint Try the below syntax systemDate = DateTime.ParseExact("06-17-2024", "MM-dd-yyyy", System.Globalization.CultureInfo.InvariantCulture) sharepointDate = DateTime.ParseExact("14-06-2024", "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture) differenceInDays = (systemDate - sharepointDate).Days systemDate: System.DateTime sharepointDate: System.DateTime differenceInDays: System.Int32 Regards

This solution provided by @ashokkarale received 1 likes!

How to compare two lists(String)?

@Guru_Koli21, Use this LINQ allContained = L1.All(Function(item) L2.Contains(item)) Here, allContained is a Boolean variable that will be True if all elements in L1 are present in L2 and False otherwise. Input: L1 = New List(Of String) From {"A", "B", "C", "D"} L2 = New List(Of String) From {"A", "B", "C", "D", "E", "F"} Logic: [image] Output: [image] Sample Workflow: Workflow1.xaml (7.5 KB) Thanks, Ashok

---

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.