Forum Engagement Daily Reports

[system]

Daily Forum Report | 10 September 2022

Top 3 Topics with Most Views

Create time folder based on the mail receiving time and date made by @Venusha_Sree with 31 views.

How to send email with file name and file path? made by @Venusha_Sree with 29 views.

Dear Masters, Can u give Linq query to merge this three data tables.Tq made by @lakshmi_narayana_ch with 28 views.

Top 3 Topics with Most Replies

I need to filter one year and one month before date in excel sheet from current date. I tried so many ways, but it can,t work. If anyone knows how to do that, please share with me made by @lokeshkumar.k with 21 replies.

Why this error showing!option strict on disallows late binding error made by @Siddharth_Kumar1 with 13 replies.

Upload A file made by @Sheen_Ildephonse with 10 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 15 posts!

@Sanjit_Pal made 11 posts!

@lokeshkumar.k made 11 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 2 likes!

How to Use Node.js with JavaScript in Combination with UiPath

Node.js is a JavaScript runtime environment on Chrome V8 engine. JavaScript is a very common and used programming language from many programmers around the world. A variety of packages are offered for Node.js that provide different aspects of problem solving. The consideration of an integration scenario into an UiPath RPA workflow can only be profitable from these points of view. [NodeJS] It is possible to execute JavaScript code with Node.js or to use it in REPL (read-eval-print-loop) mode. …

This post made by @Sanjit_Pal received 2 likes!

Get specified columns from a data table

Assume, we have a requirement to get specified columns from a data table then we generally delete unnecessary columns to get the actual ones. Instead of this, you can use the below expression with simple assign activity avoiding deletion logic Variable of type data table outputDT = DT.DefaultView.ToTable(False,“Items”,“ID”) Replace DT with your input data table outputDt is output data table Replace Items,ID with your actual column names that you want to retrieve You can also add additional co…

This post made by @ushu received 1 likes!

How to send email with file name and file path?

Hi @Venusha_Sree - Have a look on the below workflow Example.zip (10.5 KB)

Top 3 Most Liked Solutions

This solution provided by @raja.arslankhan received 1 likes!

Upload A file

@Sheen_Ildephonse Please follow these steps. 1- use open browser OR Attach browser activity. 2- use click activity and select selecor of Attachment button. 3- Now file selection window popup will open and put full path of file. Use again click activity to click on “OK”

This solution provided by @Yoichi received 1 likes!

How to use LINQ to compare two DataTable values and return a boolean

Hi, How about the following? dt1.AsEnumerable.Any(Function(r) r("Shipment").ToString="G05468") Regards,

This solution provided by @Siddharth_Kumar1 received 1 likes!

Why this error showing!option strict on disallows late binding error

i gave the type object instead of string. now it resolved after changing into string and changing the code from line.Split(":“c,StringSplitOptions.RemoveEmptyEntries) to line.Split({”:"c},StringSplitOptions.RemoveEmptyEntries)…

---

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.