Forum Engagement Daily Reports

[system]

Daily Forum Report | 08 April 2022

Top 3 Topics with Most Views

I need your help made by @momo10 with 49 views.

How to split string value with space made by @yash_p with 45 views.

Vulgarisation – Méthodologie - AGILE - Episode 11 made by @oumayma_lajili2 with 44 views.

Top 3 Topics with Most Replies

There is no option to add a robot in the Orchestrator page made by @mail4bobbysam with 18 replies.

Covert String to Date time made by @Sairam_RPA with 16 replies.

How to split string value with space made by @yash_p with 15 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 49 posts!

@ushu made 25 posts!

@supermanPunch made 23 posts!

Top 3 Most Liked Posts

This post made by @oumayma_lajili2 received 5 likes!

Vulgarisation – Méthodologie - AGILE - Episode 11

Bonjour chère Communauté Aujourd’hui on va aborder un sujet qui me tient à coeur : La Méthodologie des projets RPA. Cet article est un début d’une série d’articles sur les centres d’excellence. 1. Méthodologie de travail fonctionnelle Comme tu le sais, grâce à la RPA les entreprises peuvent avoir des optimisations en terme de délais, coûts importants et économies ROI. En plus, on obtient une précision améliorée des processus et des employés…

This post made by @ppr received 3 likes!

LINQ Update Data Issue

your result comes from the nature of the cartesian product. Your case looks similar to a side by side merge we can do it by writing out excel2 with an offset or LINQ (From x in Enumerable.Range(0, dt1.Rows.Count) Let r1 = dt1.Rows(x) Let r2 = dt2.Rows(x) Let ra = new Object(){r1(0), r1(1), r2(0)} Select row=dtResult.Rows.Add(ra)).CopyToDatable

This post made by @supermanPunch received 2 likes!

Covert String to Date time

@Sairam_RPA , Could you try the Below Approach : Assuming that there are hidden Characters in the String. We will first remove them : dateString = System.Text.RegularExpressions.Regex.Replace(dateString, "[^\x20-\x7F]", "") Next, Check with your original Expression : DateTime.ParseExact(dateString,arr_strFormats,System.Globalization.CultureInfo.InvariantCulture,DateTimeStyles.None) Let us know if it doesn’t work

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

Covert String to Date time

@Sairam_RPA , Could you try the Below Approach : Assuming that there are hidden Characters in the String. We will first remove them : dateString = System.Text.RegularExpressions.Regex.Replace(dateString, "[^\x20-\x7F]", "") Next, Check with your original Expression : DateTime.ParseExact(dateString,arr_strFormats,System.Globalization.CultureInfo.InvariantCulture,DateTimeStyles.None) Let us know if it doesn’t work

This solution provided by @athira.somasekharan received 2 likes!

Click activity denied

Yes there is. In the project settings you can just disable the modern activities and that’s it. [image] Thanks, Athira

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

How Can I Add Color in Outlook Mail Body

something like this "<p style='color:blue'>"+ row(“Mail Body1”).ToString+" “+ row(“İsim Soyisim”).ToString+”,"+" "+" "+row(“Mail Body2”).ToString+" "+" "+row(“Mail Body3”).ToString+" "+" "+row(“Mail Body4”).ToString+" "+" "+row(“Mail Body5”).ToString + "</p>" then in send email activity tick “isBodyHTML” [image]

---

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.