Forum Engagement Daily Reports

[system]

Daily Forum Report | 29 January 2024

Top 3 Topics with Most Views

Expanding Horizons: UiPath's New Google Maps and FreshBooks Connectors in Integration Service made by @Samrat_Dutta with 76 views.

「セルを読み込み」で日付を読み取る場合 made by @kiki1 with 53 views.

Filter data on excel data table made by @shanti_18 with 47 views.

Top 3 Topics with Most Replies

How to get inline image in the mail body!Error made by @Kancharla_Mahija with 25 replies.

Select Item 'DIV': Error HRESULT E_FAIL has been returned from a call to a COM component made by @LOHITH_KUMAR_SAKA with 24 replies.

Filter data on excel data table made by @shanti_18 with 19 replies.

Top 3 Users Who Posted The Most

@mkankatala made 67 posts!

@Anil_G made 39 posts!

@vrdabberu made 36 posts!

Top 3 Most Liked Posts

This post made by @Samrat_Dutta received 2 likes!

Expanding Horizons: UiPath's New Google Maps and FreshBooks Connectors in Integration Service

Exciting News from UiPath Integration Service! We’re thrilled to share that our Integration Service connector catalog has just expanded with the addition of two new connectors: Google Maps and FreshBooks are now in Preview! Google Maps: Explore a world of possibilities with the Google Maps connector and activities. Quickly perform customer address verification, standardize address formats, automate the retrieval of geographic coordinates (latitude and longitude) fo…

This post made by @ppr received 2 likes!

How to get inline image in the mail body!Error

give a try at: strFilePath = FullFilePathToTheImage Assign Activity: strB64 = Convert.ToBase64String(File.ReadAllBytes(strFilePath)) Keep in mind: strB64 is only the part: [grafik] the red part you would handle e.g. by prepending or within the html part It can fail, when done this the first time. But just focus on the correct red handle part, then it it will work

This post made by @Anelisa_Bolosha1 received 2 likes!

Please help in http returns nothing

This was all sorted, I opened a new project and did it and it worked there so I saw that I did a mistake by putting a wrong variable on the body of http activity, I have also updated my dependencies to the latest

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Working with excel and pdf

Hi, Can you try the following sample? This renames files under “files” folder in project folder. [image] dict = dt.AsEnumerable.ToDictionary(Function(r) r(1).ToString+"-"+System.Text.RegularExpressions.Regex.Match(r(2).ToString,"\d+$").Value,Function(r) r(2).ToString) Sample Sample20240125-2.zip (305.6 KB) Regards,

This solution provided by @vrdabberu received 1 likes!

Hi all i need a logic for below task without using Dictionary packages

Hi @Abhilash_S Assign: Dictionary = New Dictionary(Of String, String) From { {"Book 1", "Author A"}, {"Book 2", "Author B"}, {"Book 3", "Author C"}, {"Book 4", "Author A"}, {"Book 5", "Author C"} } Note: Dictionary is of DataType System.Collections.Generic.Dictionary(System.String,System.String) Use the be…

This solution provided by @mkankatala received 1 likes!

How to read every row in a Data Table and have it as String?

Hi @Baltanaktis May be in for each row in datatable it was giving CurrentRow. In your assign you have given Row change it to CurrentRow and try. str_row = String.join(",",CurrentRow.itemArray) [image] Hope it helps!!

---

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.