Forum Engagement Daily Reports

[system]

Daily Forum Report | 14 April 2023

Top 3 Topics with Most Views

Send email dynamically with attachments made by @RAKESH_KUMAR_Tiwari with 58 views.

Concatenate the string made by @Vrishchik with 44 views.

Can I trigger automations from my phone with UiPath Apps? made by @Luis_Fernando with 43 views.

Top 3 Topics with Most Replies

Send email dynamically with attachments made by @RAKESH_KUMAR_Tiwari with 27 replies.

Date format Change1 made by @Kuldeep_Pandey with 14 replies.

Opposite sing Excel made by @Kuldeep_Pandey with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 57 posts!

@Yoichi made 30 posts!

@Kuldeep_Pandey made 17 posts!

Top 3 Most Liked Posts

This post made by @monika.singh received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi My name is Monika, Just started my journey as a RPA Developer. Glad to be a part of community.

This post made by @Anil_G received 2 likes!

How to replace row values of specific column in excel?

@Vaishnav_Tej Your replace function is correct…what you need to do is to perform this action in a for each row in datatable or for each excel row activities Inside ethat use curretrow("Column") = currentrow("Column").ToString.Replace("abc","") If abc is not constant then use regex as suggested by @arjunshenoy Cheers

This post made by @jack.chan received 2 likes!

Using VBA and file name excel variables

delete second assign in UiPath [image] then replace vba with this Sub Del_Rws(out_Str_input As String) Dim d As Object Dim a As Variant, b As Variant, itm As Variant Dim nc As Long, i As Long, k As Long Dim inputWb as Workbook Set inputWb = Workbooks.Open(out_Str_input) Dim fso As Object Set fso = VBA.CreateObject("Scripting.FileSystemObject") Dim fileName As String fileName = fso.GetFileName(out_Str_input) Sheet2.Range("A1:A1000").Formula = "='[" & fileName & "]PLHQ'!D20" Sheet2.Ran…

Top 3 Most Liked Solutions

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

Using VBA and file name excel variables

delete second assign in UiPath [image] then replace vba with this Sub Del_Rws(out_Str_input As String) Dim d As Object Dim a As Variant, b As Variant, itm As Variant Dim nc As Long, i As Long, k As Long Dim inputWb as Workbook Set inputWb = Workbooks.Open(out_Str_input) Dim fso As Object Set fso = VBA.CreateObject("Scripting.FileSystemObject") Dim fileName As String fileName = fso.GetFileName(out_Str_input) Sheet2.Range("A1:A1000").Formula = "='[" & fileName & "]PLHQ'!D20" Sheet2.Ran…

This solution provided by @Yoichi received 1 likes!

Add elements from array to list

HI, Can you try to create instance of the list as the following. for example? [image] And it might be better to set scope Main. AppentCollection.zip (55.4 KB) Regards,

This solution provided by @Anil_G received 1 likes!

Help with activites and sequence

@Ricchch Use get outlook mail message in the folder give the foler path like "Inbox\Business\Projects\Ananke" It has a filte rproperty where jet or dasl queries can be used Hope this helps 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.