Forum Engagement Daily Reports

[system]

Daily Forum Report | 26 May 2022

Top 3 Topics with Most Views

Is there a way to convert datatable's row datatype? made by @wija with 60 views.

Filter data table in excel made by @Riya1 with 48 views.

[Tutorial] How to build filter query in: Get Exchange Mail Messages to get emails with attachment flag category size etc made by @Adrian_Star with 43 views.

Top 3 Topics with Most Replies

Filter data table in excel made by @Riya1 with 21 replies.

I want to send status message when a process is running in the background of uipath apps made by @Petchi_Paramasivam with 14 replies.

Checking Project for validation errors gets stuck made by @MikeStrike with 14 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 49 posts!

@Veera_Raj made 25 posts!

@postwick made 19 posts!

Top 3 Most Liked Posts

This post made by @Adrian_Star received 5 likes!

[Tutorial] How to build filter query in: Get Exchange Mail Messages to get emails with attachment flag category size etc

Hi, I have prepared a comprehensive compendium of knowledge on how to filter e-mails using KQL queries used in filtering e-mail messages in Get Exchange Mail Messages activity. From the following set of information you will learn how to correctly construct a query syntax. I have tested all the query properties below for correct operation on MS Office 2016 for corporate use. I have marked the ones that didn’t work in my company. The KQL language was used in the queries used, which means: Keyw…

This post made by @Himanshu_Yadav received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

This is Himanshu Yadav, I work as a Global RPA Engineer and always try to find new interesting topic and UiPath Forum is the best place to find new topics as UiPath Developers keep posting new issues/solutions they faces during their development. which is the best way to learn new things. So that’s the reason I am here to learn and share my knowledge with you all Thanks and Happy Automation

This post made by @yigit.aybey received 2 likes!

Get Date in Input Dialog And Control of Date

Thanks for your help guys (@Lak_Ui, @lakshman and @ushu), i appreciate your effort and guidance.

Top 3 Most Liked Solutions

This solution provided by @lakshman received 1 likes!

Get Date in Input Dialog And Control of Date

@yigit.aybey You can mention the required date format to be entered by the user in Label field of Input Dialog activity. Assign the Input Dialog activity output to one string variable named strDate. And then check below conditions to validate whether entered date is correct or not. CInt(strDate.Trim.Split("."c)(0)) > 0 AND CInt(strDate.Trim.Split("."c)(0)) <= 31 CInt(strDate.Trim.Split("."c)(1)) > 0 AND CInt(strDate.Trim.Split("."c)(1)) <=12

This solution provided by @jack.chan received 1 likes!

How to itterate alphabet?

do this instead UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(number) where number is integer variable e.g. number=1 will return A number = 26 returns Z number = 100 returns CV number = 1000 returns ALL and so on…

This solution provided by @StefanSchnell received 1 likes!

Two different selectors for the same SAP element when captured in different PCs

@jack.chan Hello Jack, it seems that the network settings of your Environment 1 is low speed LAN connection. Square brackets in the IDs are a typical sign of this. Let us know your result. Best regards Stefan

---

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.