Forum Engagement Daily Reports

[system]

Daily Forum Report | 24 February 2024

Top 3 Topics with Most Views

Write cell issue on output sheet made by @Happydayyy with 47 views.

Excel and Microsoft form automation made by @Sandhana_Murali with 42 views.

Fixing the datatable issue made by @Happydayyy with 42 views.

Top 3 Topics with Most Replies

Want to apply filter in my existing excel made by @Gopi_Krishna1 with 13 replies.

Table Extraction-Activate activities not working after being published to Orchestrator made by @DamilolaAdeogun with 11 replies.

Writtng in excel made by @Satyam_Shrivastava with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 10 posts!

@Happydayyy made 10 posts!

@vrdabberu made 8 posts!

Top 3 Most Liked Posts

This post made by @Satyam_Shrivastava received 2 likes!

Writtng in excel

I am having a Doubt i am reading excel file… With for each activity i am looping through each cell of column “Name” and “Salary” i want a Flow that if name repeating>1… then sum of the same name salary.

This post made by @pravallikapaluri received 2 likes!

Writtng in excel

Hi @Satyam_Shrivastava Follow the below approch. Assign activity: nameSalaries = New Dictionary(Of String, Double) For Each Row activity (ForEachRow in dt): If activity: Condition: nameSalaries.ContainsKey(row("Name").ToString()) Then: Assign activity: nameSalaries(row("Name").ToString()) += CDbl(row("Salary").ToString()) Else: Assign activity: nameSalaries(row("Name").ToString()) = CDbl(row("Salary").ToSt…

This post made by @supermanPunch received 1 likes!

Write cell issue on output sheet

Hi @Happydayyy , Could you check with the below modified workflow : WriteCell_Output.zip (34.3 KB) To make it clear, I believe the problem was with the Input data that you were using. Empty spaces were found in the 2.1 Summary sheet at the end. I deleted the empty rows found in that sheet and that particular issue was resolved (assumed it was a typo error in the sheet). In addition to the above, I made a correction in the workflow by removing a For Each Row loop as I thought it was not neces…

Top 3 Most Liked Solutions

This solution provided by @ptrobot received 2 likes!

WHILE inside FOR EACH activity

There’s no need for a while loop. You just need a variable that keeps track of the previous invoice number and then compare it with the current invoice number in the For Each Row loop. If-condition: CurrentRow("Num_Invoice").ToString.Equals(previousInvoice) [image]

This solution provided by @suraj.setty received 2 likes!

I can't find Close book activity for Excel

Hi @IPIX , Close Workbook activity belongs to Classic Activities, you can use it by enabling “Show Classic” from the Filter. [image] If you are using modern activities , the excel will be Closed Automatically when you use the Scope.

This solution provided by @rikulsilva received 1 likes!

Would need solution for the same topic

Hi @anjasing UiPath Integrarion for Azure DevOps was updated and you need update the tasks version in your pipelines to windows project build properly. To do this, In your pipeline, before UiPath Pack task, add UiPath Install Platform task and choose a windows cli. Update all UiPath task to 4.* version You don’t need update the extension itself

---

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.