Forum Engagement Daily Reports

[system]

Daily Forum Report | 02 March 2024

Top 3 Topics with Most Views

In my project , they are asking for a presentation on the new advanced features of uipath made by @Ragavi_Rajasekar with 31 views.

Can someone suggest for practicing API's in Uiapth made by @devasaiprasad_K with 29 views.

Unable to get enterprise license trial key to activate offline made by @ng.zijian with 29 views.

Top 3 Topics with Most Replies

Append Column made by @amitha.aenugula with 6 replies.

Check if the web form contains a specific text made by @starterui with 5 replies.

Gsuite Application Scope - How to over come the token refresh made by @BharathKamalapur with 4 replies.

Top 3 Users Who Posted The Most

@Anil_G made 14 posts!

@Parvathy made 12 posts!

@Gopi_Krishna1 made 8 posts!

Top 3 Most Liked Posts

This post made by @Ellie.Smith received 1 likes!

Selector taking a really long time to load for popup window, and always failed to find the element in debug runs

Hi, I am learning UiPath with the provided training, in one exercise, I am trying to add a “click” activity to close the pop up windows which appears after clicking “Add Account”. [image] However, the UI selector always took a very long time to load when the popup window is present. When I finally add the target element with 100% validation score, it still failed with a timeout when debugging the process. Any ideas for why it happens? - I compared the given solution and my own target/anchor…

This post made by @amitha.aenugula received 1 likes!

Append Column

Hi all, I got a question, I have two excels Excel1 and Excel2. I want to append the data of ColumnA of Excel1 with ColumnC of Excel2 Same way ColumnB of Excel1 with ColumnD of Excel2 and ColumnC of Excel1 with ColumnE of Excel2. Note :Both the excels has different Column Names. Can anyone help me on this? Appreciate your help.

This post made by @amitha.aenugula received 1 likes!

Append Column

Excel 1 |Column 1 | Column 2 | Column 3 | Column 4| |786 | abc | 12345 | cc| |456 | cfg | 7865 | cc| |678 | uyr | 9865 | cc| |675 | adf | 56787 | cc| Excel 2| |Date | CUCC | Name | ACC| |10-12-2024 | 673 | rty | 86| |28-02-2024 | 332 | uyt | 85| |28-02-2024 | 4576 | hgf | 34| |28-02-2024 | 567 | kjh | 56| Output |Date | CUCC | Name | ACC| |10-12-2024 | 673 | rty | 86| |28-02-2024 | 332 | uyt | 85| |28-02-2024 | 4576 | hgf | 34| |28-02-2024 | 567 | kjh | 56| |Empty | 7…

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 2 likes!

How to bold header in file excel by processed from Uipath?

Hi @bayu.herlambang Use the below Macros code to make A1:F1 bold. Place the Invoke VBA acitvity after the first Set Range Color activity: Sub BoldHeaders() Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to your sheet's name With ws.Range("A1:F1").Font .Bold = True End With End Sub [image] Properties of Invoke VBA [image] Text file path: Macos Code.txt (211 Bytes) Hope it helps!!

This solution provided by @postwick received 2 likes!

Package is removed, yet its activities are still being shown in the available list

It’s how it’s designed. You see the activities so you can use them, and if you use them the dependency is automatically installed. If you don’t need the activity, why would you search for it? If you go to Settings/Design there is a setting named “Show activities available for install” and you can turn it off. This setting is described in the documentation. https://docs.uipath.com/studio/standalone/2023.4/user-guide/configuring-studio-settings

This solution provided by @Prateek_Gulab_Pathak received 1 likes!

How to Compare Column 1 quantity to column 2 quantity i.e column 1 values is less than or equal to column 2

thanks for the solution It worked!!!

---

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.