Forum Engagement Daily Reports

[system]

Daily Forum Report | 04 June 2021

Top 3 Topics with Most Views

I want to retrieve data from a table present in mail Body in outlook? it would be better if we can retrieve that table from mail in DataTable format made by @anjasing with 28 views.

How To Terminate Process in Middle of Whole Process? made by @hsendel with 25 views.

Format date in excel made by @fairymemay with 25 views.

Top 3 Topics with Most Replies

vbCrLf, Environment.NewLine doesn't work on Outlook made by @Wing_Ben_Wong with 16 replies.

How To Terminate Process in Middle of Whole Process? made by @hsendel with 12 replies.

I want to retrieve data from a table present in mail Body in outlook? it would be better if we can retrieve that table from mail in DataTable format made by @anjasing with 12 replies.

Top 3 Users Who Posted The Most

@ppr made 19 posts!

@postwick made 12 posts!

@Pankaj.Patil made 11 posts!

Top 3 Most Liked Posts

This post made by @mz3bel received 3 likes!

RPA France - Vulgarisation – Episode 3 : Comment faire ses premiers pas sur UiPath?

L’épisode 3 tant attendu est là !!! Comment faire ses premiers pas sur UiPath ? Comme pour tout langage informatique, crée ton premier “Hello, World” Si tu as raté l’épisode 2, tu peux retrouver le lien au bas de cet article Qu’est-ce que UiPath et pourquoi est-il utilisé ! L’un des outils d’automatisation les plus populaires, UiPath, est un outil d’automatisation de processus robotique utilisé pour l’automati…

This post made by @Pankaj.Patil received 2 likes!

I need to append date and time to the file name dynamically while using the move activity

@manjesh_kumar, Can you try with below? DestinationFolder+Path.GetFileNameWithoutExtension(SourceFolder)+“_”+Now.ToString(“dd.MM.yyyy”)+“.txt”

This post made by @vasile.bujac received 2 likes!

API => GET Jobs not working

The order in which jobs are returned from odata/Jobs endpoint without any OData parameters isn’t technically defined. If you’d like to find out the status of the last job that was run, try ordering by StartTime desc or EndTime desc, for example /odata/Jobs?$top=1&$orderby=StartTime desc should return the last job that has started. Use StartTime if you’d like to include running jobs which do not have an EndTime property set. If you’re interested in completed jobs only, successful or failed, use E…

Top 3 Most Liked Solutions

This solution provided by @Pankaj.Patil received 2 likes!

I need to append date and time to the file name dynamically while using the move activity

@manjesh_kumar, Can you try with below? DestinationFolder+Path.GetFileNameWithoutExtension(SourceFolder)+“_”+Now.ToString(“dd.MM.yyyy”)+“.txt”

This solution provided by @ppr received 2 likes!

How to duplicate rows with ignorecase

@fightblue give a try on: Assign activity Left side: dtCleansed | Datatype: Datatable Right side: (From d in YourDataTableVar.AsEnumerable Group d by k1=d(“city”)toString.Trim.ToUpper, k2=d(“ammount”).toString into grp=Group Select grp.First()).CopyToDataTable Kindly note: Cross check the column names on spellings and ensure that the LINQ statement is using the names as in your real data

This solution provided by @J0ska received 1 likes!

How To Terminate Process in Middle of Whole Process?

There is enough resources about T/C. Search and test. It is the best learning. Cheers

---

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.