Forum Engagement Daily Reports

[system]

Daily Forum Report | 23 February 2022

Top 3 Topics with Most Views

How to find specific string using regex made by @BHARAT_NAGAR with 61 views.

How to Date Convert "Date" to "System date" format? made by @Ashok_kumar7 with 57 views.

Excel Delete Columns from a dynamic sheet tab (Source) made by @CMB80 with 53 views.

Top 3 Topics with Most Replies

Excel Delete Columns from a dynamic sheet tab (Source) made by @CMB80 with 31 replies.

How to find specific string using regex made by @BHARAT_NAGAR with 31 replies.

Trim data made by @daryl_pressley with 22 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 39 posts!

@Shikhar_Tandon made 27 posts!

@gustavo.cervelin made 25 posts!

Top 3 Most Liked Posts

This post made by @Krollythegoalie received 6 likes!

Your feedback on UiPath Apps can earn you a certification voucher - ends March 9

Hello Maciej, and thank you for the opportunity to provide some feedback on UiPath Apps! 1. What integration to an automation platform are you looking forward to see in UiPath Apps and why? Action Center Integration Apps allows for the construction of beautiful interfaces, but it could benefit from Action Center. Showing a user a list of tasks assigned to them, or their group, would be very useful within an App portal homepage. Would like to see improvements around connecting to workflow …

This post made by @Vitor_Merola received 4 likes!

Your feedback on UiPath Apps can earn you a certification voucher - ends March 9

What integration to an automation platform are you looking forward to see in UiPath Apps and why? It would be great if we can find a plugin to integrate Uipath Apps getting data from Sharepoint list directly, without Premium connectors. Once the most of the companies have Microsoft Plataform in place, and not are working with Microsoft Power Automate to automate boring tasks. What controls are missing in UiPath Apps and how would you use this new control? As it is found in several development…

This post made by @Gokul001 received 2 likes!

How to Date Convert "Date" to "System date" format?

Or you can use this too Datetime.ParseExact(“1-Feb-2022”,“d-MMM-yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd-MM-yyyy”) [image] Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @gustavo.cervelin received 2 likes!

Why is this written as "=SUM(A1,B1)" in TypeB workflow?

Hi @ydash999, It’s just a different approach usign Excel formula to get the sum of two values. In this case, the formula is written from C1 to C11 because the defined range is "C1:C"+RowsCount Where RowsCount is 11. Then, it will work similar to when you drag a formula. I mean, it will consider the respective row. Are there other ways to do this without formulas? Yes… You could use a for each row activity, get column A value and column B value, covert both of them to Int32, perform the sum …

This solution provided by @THIRU_NANI received 1 likes!

How to Date Convert "Date" to "System date" format?

Hi! Try this: Cdate(DateVariable).ToString("dd-mm-yyyy") Reference: [Date1] Regards, NaNi

This solution provided by @sven.wullum received 1 likes!

Download from storage bucket - Cannot find the requested page

Solution was to install and use Chrome instead of IE11!

---

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.