Forum Engagement Daily Reports

[system]

Daily Forum Report | 09 July 2024

Top 3 Topics with Most Views

Filter Get Outlook Mail Message according to dates selected by user made by @lqxchan with 66 views.

editGrid RowCount in Create Form Task Form made by @Vishal_Kalra with 64 views.

Purpose to add annotations made by @Mounika_Radharapu with 50 views.

Top 3 Topics with Most Replies

Filter Get Outlook Mail Message according to dates selected by user made by @lqxchan with 17 replies.

全体フローの中で1箇所だけ繰り返す方法 made by @once10201029 with 16 replies.

Tutorial on Workflow Analyzer has weird errors made by @Terry_Marr with 16 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 38 posts!

@mkankatala made 35 posts!

@postwick made 28 posts!

Top 3 Most Liked Posts

This post made by @rlgandu received 2 likes!

Slow execution of keyboard shortcut activity

@ra.systems Instead of delays use Retry scope or “Do While” loops with a check for element visibility. Try different Input Methods like “SimulateType”, “SendWindowMessages”

This post made by @supermanPunch received 2 likes!

Returning Index of Last Row that Equals a Certain Value

Hi @rmorgan , Could you maybe try with the below Expression : rowIndex = DT.Rows.IndexOf(DT.AsEnumerable.Where(Function(x)x("Value").ToString.ToLower.equals("yes")).Last) Here, rowIndex is of the type Integer and DT is your Datatable variable, assuming Excel sheet is already being read into Datatable Let us know if this does not work.

This post made by @Parvathy received 1 likes!

How to assign decimal value in particular column value

Hi @Raja.G => Read Range Workbook Output → dt => Use the below code kn Invoke code: dt = dt.AsEnumerable().Take(1).Select(Function(row) row.ItemArray = row.ItemArray.Select(Function(cell, index) If Decimal.TryParse(cell.ToString(), Nothing) Then Return Decimal.Parse(cell.ToString()) ElseIf dt.AsEnumerable().Skip(1).All(Function(r) Not Decimal.TryParse(r(index).ToString(), Nothing)) Then Return DBNull.Value Else Return cell …

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

Returning Index of Last Row that Equals a Certain Value

Hi @rmorgan , Could you maybe try with the below Expression : rowIndex = DT.Rows.IndexOf(DT.AsEnumerable.Where(Function(x)x("Value").ToString.ToLower.equals("yes")).Last) Here, rowIndex is of the type Integer and DT is your Datatable variable, assuming Excel sheet is already being read into Datatable Let us know if this does not work.

This solution provided by @mkankatala received 1 likes!

How to get all occurrences using regex pattern

Hi @mohamedalthaf Your regular expressions not working, try the below regular expressions in the Find Matching Patterns activity, [A-Za-z\s]+\d+\.?\d+\s+\d+\.?\d+ Check the below image for better understanding, [image] Check the below workflow, [image] Hope it helps!!

This solution provided by @bavyaravu133 received 1 likes!

Regular Expressions,,,,,,,!

Hi @priyachennuru789 Try this: If 5 digit zip code always follows state, the following will work. System.Text.RegularExpressions.Regex.Match(yourString,"\b[A-Z]{2}(?=\W+\d{5}\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.