Forum Engagement Daily Reports

[system]

Daily Forum Report | 19 May 2022

Top 3 Topics with Most Views

Type conversion exception problem made by @Priyanka_Jharia with 41 views.

Getting error while trying to get distinct values from database table and covnert to Array made by @MitheshBolla with 38 views.

While Working on Excel Sheet I am getting time also along with Date , How to remove it? made by @Kunal_Jain with 37 views.

Top 3 Topics with Most Replies

While Working on Excel Sheet I am getting time also along with Date , How to remove it? made by @Kunal_Jain with 26 replies.

Retrieve information from an email made by @DimitriLYR with 20 replies.

Getting error while trying to get distinct values from database table and covnert to Array made by @MitheshBolla with 19 replies.

Top 3 Users Who Posted The Most

@postwick made 49 posts!

@Rahul_Unnikrishnan made 31 posts!

@muhammedyuzuak made 31 posts!

Top 3 Most Liked Posts

This post made by @ydash999 received 2 likes!

Split string and keep each character in a datatable

in column separator i only saw the given characters, i didnt try inputing the “-”, so was confused. now solved. thanks bro!

This post made by @ppr received 2 likes!

Getting error while trying to get distinct values from database table and covnert to Array

@MitheshBolla Perfect, it is working May I ask you to flag @supermanPunch for the solution. He supported you and gave you the required hint at first. Thanks

This post made by @supermanPunch received 2 likes!

Error running from orchestrator: Failed to install package. Unable to find package

Hi @jack.chan , Have you Checked the Below Post :

Top 3 Most Liked Solutions

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

Need to copy a particular excel to destination

assign filesArray (Array of string variable) = Directory.GetFiles(folderPath) assign oldestFile (string variable) = filesArray.AsEnumerable().Where(function(file) Datetime.TryParseExact(path.GetFileNameWithoutExtension(file), "dd-MMM-yyyy",nothing, nothing, nothing)).ToArray.AsEnumerable().OrderBy(function(x) cdate(Path.GetFileNameWithoutExtension(x))).first [image]

This solution provided by @supermanPunch received 1 likes!

Split string and keep each character in a datatable

Hi @ydash999 , Maybe you could also Check with Generate Datatable Activity. [image]

This solution provided by @supermanPunch received 1 likes!

Getting error while trying to get distinct values from database table and covnert to Array

Hi @MitheshBolla , Have you tried following the Steps in the Below Post : Also, Do Check if System.Linq is imported in your xaml first by checking in the imports section.

---

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.