Forum Engagement Daily Reports

[system]

Daily Forum Report | 07 October 2021

Top 3 Topics with Most Views

For Each loop jump to next activity of entire sequence made by @private_matter with 53 views.

Extra Column being Render in the excel file made by @SH_94 with 47 views.

Transform datatable string column into data time format (DD-MM-YYYY) made by @joao_adelio1 with 46 views.

Top 3 Topics with Most Replies

For Each loop jump to next activity of entire sequence made by @private_matter with 17 replies.

Excel Remove rows not numeric made by @d_liberati with 16 replies.

Transform datatable string column into data time format (DD-MM-YYYY) made by @joao_adelio1 with 15 replies.

Top 3 Users Who Posted The Most

@rahulsharma made 38 posts!

@postwick made 37 posts!

@ppr made 32 posts!

Top 3 Most Liked Posts

This post made by @raduc received 3 likes!

Click Tabs in SAP /cockpit/1

Hi @StefanSchnell, Yes, I already talked to @LevKushnir and we will document this. Regarding the extra '?'s you added, they are not needed as that is another container/control. To be more clear, the replacement of '/'s to '?'s is only needed in the leaf id of the container control that requires wildcards. subSUB_HDR:/COCKPIT/SAPLDISPLAY46:04051 would need this replacement only if you needed to use wildcards within it (for example: subSUB_HDR:?COCKPIT?SAPLDISPLAY??:*) This is a picture (hopef…

This post made by @raduc received 3 likes!

Click Tabs in SAP /cockpit/1

Hi @Gwen, Seems that you hit a known problem with SAP id scheme. The problem here is that the control in the id that you are trying to use wildcards has slashes in its name and we cannot identify the hierarchy properly. You have 2 solutions: You can use regex matching (RegEx Search), but I don’t recommend this since it’s slower Replace all slashes(‘/’) in the control name with ‘?’ (simplest and recommended solution) In your case you should use: <sap id='usr/subSUB_MAIN:?COCKPIT?SAPLDISPLAY…

This post made by @postwick received 3 likes!

Transform datatable string column into data time format (DD-MM-YYYY)

Linq loops through the rows anyway. That’s what I think people don’t understand. ANY method of updating rows in a datatable MUST loop through all the rows.

Top 3 Most Liked Solutions

This solution provided by @raduc received 3 likes!

Click Tabs in SAP /cockpit/1

Hi @Gwen, Seems that you hit a known problem with SAP id scheme. The problem here is that the control in the id that you are trying to use wildcards has slashes in its name and we cannot identify the hierarchy properly. You have 2 solutions: You can use regex matching (RegEx Search), but I don’t recommend this since it’s slower Replace all slashes(‘/’) in the control name with ‘?’ (simplest and recommended solution) In your case you should use: <sap id='usr/subSUB_MAIN:?COCKPIT?SAPLDISPLAY…

This solution provided by @Palaniyappan received 1 likes!

How to Check and Catch No internet Connection Error

Hi You can use TRY catch block and place the sequence of activities to check whether internet is connected or not Please refer the below threads for the sample code Cheers @Shinjid

This solution provided by @lakshman received 1 likes!

Get received date Mail outlook?

@Maria99 Try below expression. CDate(item.Headers(“Date”)).ToString("dd/MM/yyyy")

---

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.