Forum Engagement Daily Reports

[system]

Daily Forum Report | 31 October 2023

Top 3 Topics with Most Views

How to get LocalPath from Zip Extracted Files Variable? made by @aeklikit with 54 views.

Excel value replace help made by @Learner007 with 51 views.

How to change docx to pdf for current file in a for each file loop made by @Helpmepls with 50 views.

Top 3 Topics with Most Replies

Sharepoint create folder made by @Ritaman_Baral with 24 replies.

ORchestrator SIgn-in issue made by @Gayathri_Mk with 22 replies.

I need to create sequence for finding similar image of input image from other sub-folder images made by @Rohit_Tarle1 with 20 replies.

Top 3 Users Who Posted The Most

@Anil_G made 100 posts!

@Palaniyappan made 32 posts!

@Gayathri_Mk made 25 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Excel value replace help

Hi, How about the following sample? [image] Condition not Int32.TryParse(CurrentRow("age").ToString,New Int32) OrElse CInt(CurrentRow("age"))<=0 Sample Sample20231031-5L.zip (15.0 KB) Regards,

This post made by @pere received 1 likes!

Invoke Powershell is not working

There you go. I wonder if this was really necessary. A project with merely three activities (one Assign, that could be avoided, an Invoke Power Shell connecting to Microsoft Teams and another one calling a script using Get-Team. Exactly what I described in my previous comments. You could have tried by yourself and you would have seen that it doesn’t work. Oh well. blankProjectTeams.zip (30.1 KB)

This post made by @pere received 1 likes!

Invoke Powershell is not working

There you go again. This is what started it all. A project with only one activity, with only one Invoke Power Shell call to “Install-Module”, which triggers the infamous System.Management.Automation.CmdletInvocationException: Cannot process argument transformation on parameter ‘CallerPSCmdlet’. Cannot convert the “System.Management.Automation.PSScriptCmdlet” value of type “System.Management.Automation.PSScriptCmdlet” to type “System.Management.Automation.PSCmdlet”. —> System.Management.Automa…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Excel value replace help

Hi, How about the following sample? [image] Condition not Int32.TryParse(CurrentRow("age").ToString,New Int32) OrElse CInt(CurrentRow("age"))<=0 Sample Sample20231031-5L.zip (15.0 KB) Regards,

This solution provided by @Dilli_Reddy received 1 likes!

Orchestrator qeury

@Pushpendra_kowthavarapu -If your automation process involves connecting to a SQL Server database and manipulating data directly on the runner machine, you would typically need SQL Server or a SQL Server client installed on the runner machine. -If your automation process connects to a remote SQL Server database, you do not necessarily need SQL Server on the runner machine. -Database in Orchestrator: In this case, the runner machines do not need SQL Server installed because the database operat…

This solution provided by @efelantti received 1 likes!

Tap Control Key while clicking

Can you check if you perhaps have a typo in some elements’ name? If you want to select all the items, you can try the following: [image] SelectMultiple_Sample.xaml (7.7 KB)

[Previous Month] Top 3 Users with the most likes on their solutions

@Yoichi received 49 likes for their solutions!

@Palaniyappan received 42 likes for their solutions!

@ppr received 29 likes for their solutions!

---

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.