UiPath Community 2022.10 Stable Release - various Activities

UiPath Community 2022.10 Stable Release - Various Activities

This topic goes in-depth about the improvements in various activities. To read about other products, please navigate to the main topic here.

System Activities

Get Asset and Get Credential have the option of configuring a caching method.

This will improve the execution time as a request to the orchestrator will be sent if configured cache has expired. Keep in mind that the default configuration has not changed and by default there will be no caching.

image013

New Collection Handling – cross-platform

We are introducing new and improved activities for collection handling:

  • Filter Collection
  • Merge Collections
  • Remove From Collection
  • Append Item to Collection
  • Collection to DataTable

Excel

In order to use these, you’ll need to update your Excel package to the latest version

Filter Pivot Table

The activity allows you to configure the filter of a pivot table, as well as clearing any existing filters.

image017

Performance improvements for Read Range

We’ve made some performance improvements to the Read Range activity, allowing it to read the data faster.

New activities

The activities below have been added to the Modern Excel package. They were part of the Classic activities but now can be used within the Use Excel File scope without having to use the Show Developer flag to list them:

  • Invoke VBA
  • Get Cell Color

Please tell us what you think

Which features excite you the most and you are going to try right away? We want to hear what you think! Please use the image button below :slight_smile:

7 Likes

It would be super helpful if you could provide a use case example for the caching method feature.

For example if I get a credential asset and I have the CacheStrategy set to Execution, I assume it retrieves the credential at execution. But if I have it set for 24Hours, how does that impact the behavior?

It only retrieves it if it hasn’t been retrieved in the last 24 hours? If it has been retreived in the last 24 hours, how does my current workflow know what the value of the asset was when it was last retrieved?

I thought maybe it would be more clear if I pulled in the activity and looked at it myself, but sadly in the Windows (versus Legacy) version of a workflow, this property is not visible or editable.

1 Like

Hi,

A lot of activities no longer work since they are converted to Windows version due to the dependencies are not compatible anymore. There seems no updated version of those.

2 Likes

they don’t work for me as well. But it seems to be a problem with backend activities

1 Like

Hi. After updating to the last version I get the following errors:
image
What can I do about it? it’s a backend error, doesn’t depend on my code

1 Like

image
image
Unable to understand how to use IResource, and its frustrating.

Alteast try to explain what is this IResource.

Not able to add multiple files in the collection.

1 Like

WOW, that’s new wave of features. What I liked most since I’m so into Excel is that “Pivot Table” & “Invoke VBA” and for sure I’m going to use them… Keep it up… :heart_eyes_cat:

1 Like

For me, the two libraries that seem to have no corresponding version for “Windows” are Microsoft.Activities (was using 1.0.1) and UiPathTeam.Sharepoint.Activities (was using 1.7.0). I get errors that say “cannot create unknown type…”

11/07/2022 11:34:38 => [Error] BackupConfigs.xaml: Cannot create unknown type ‘{clr-namespace:UiPathTeam.SharePoint.Activities;assembly=UiPathTeam.SharePoint.Activities}SharepointApplicationScope’.
11/07/2022 11:34:38 => [Error] ArchiveInputFiles.xaml: Cannot create unknown type ‘{clr-namespace:UiPathTeam.SharePoint.Activities;assembly=UiPathTeam.SharePoint.Activities}SharepointApplicationScope’.
11/07/2022 11:34:38 => [Error] GetParams.xaml: Cannot create unknown type ‘{clr-namespace:UiPathTeam.SharePoint.Activities;assembly=UiPathTeam.SharePoint.Activities}SharepointApplicationScope’.
11/07/2022 11:34:38 => [Error] GetInputFiles.xaml: Cannot create unknown type ‘{clr-namespace:UiPathTeam.SharePoint.Activities;assembly=UiPathTeam.SharePoint.Activities}SharepointApplicationScope’.
11/07/2022 11:34:38 => [Error] UploadOutputFilesToSharepoint.xaml: Cannot create unknown type ‘{clr-namespace:UiPathTeam.SharePoint.Activities;assembly=UiPathTeam.SharePoint.Activities}SharepointApplicationScope’.
11/07/2022 11:34:38 => [Error] Main.xaml: Cannot create unknown type ‘{http://schemas.uipath.com/workflow/activities}SendExchangeMail’.
11/07/2022 11:35:03 => [Error] Could not find type ‘SendExchangeMail’ in namespace ‘http://schemas.uipath.com/workflow/activities’. Row: 1291, Column: 20

I hope UiPath comes out with some guidance around missing Activities that are usable in “Windows” mode.

1 Like

I to am having issues with activities after upgrading. I switched to “Windows” and my database connection started throwing errors. Investigation suggests some error or another related to the Microsoft.Data.SqlClient. Every attempt to remedy this runs into some form or another of that package being unavailable or System.Data.SqlClient not having what it needs to replace it.

This bot was working before I tried to update it. So now I have a nag to update my bot to a broken state if I roll back.

I have same kind of issue. I have process which uses UipathTeam.sharepoint when i migrated to latest version I am getting error like this.

RemoteException wrapping System.Exception: Failed to install package ‘libtest.1.0.1’ —> RemoteException wrapping System.Exception: NU1101: Unable to find package WSS_ObjectRepository. No packages exist with this id in source(s): Gallery, https://cloud.uipath.com/wilhegotzeoq/Global_Business_Services/orchestrator_/nuget/v3/30989acf-9c08-4eb1-8794-382847c75ca5/index.json, https://cloud.uipath.com/wilhegotzeoq/Global_Business_Services/orchestrator_/nuget/v3/b1b25d4f-cb19-481f-8028-0c0e2d704a00/index.json, https://www.myget.org/F/workflow/, Local, nuget.org
NU1101: Unable to find package UiPathTeam.SharePoint.Activities. No packages exist with this id in source(s): Gallery, https://cloud.uipath.com/wilhegotzeoq/Global_Business_Services/orchestrator_/nuget/v3/30989acf-9c08-4eb1-8794-382847c75ca5/index.json, https://cloud.uipath.com/wilhegotzeoq/Global_Business_Services/orchestrator_/nuget/v3/b1b25d4f-cb19-481f-8028-0c0e2d704a00/index.json, https://www.myget.org/F/workflow/, Local, nuget.org

Hi there ! I have problem same as you, did you fixed it, please guide me

This is the thread where I resolved it with @loginerror

It looks like this was a misconfig on the UiPath side and that retrying the steps suggested by Maciej I was able to complete the task after it was remedied

1 Like