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.
New Collection Handling â cross-platform
We are introducing new and improved activities for collection handling:
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.
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 button below
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.
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.
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âŚ
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.
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.
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