Forum Engagement Daily Reports

[system]

Daily Forum Report | 30 January 2023

Top 3 Topics with Most Views

Compare column is equal or not made by @Rahul_PK with 51 views.

How it break the loop if count is not fixed made by @Neha_Aggarwal1 with 49 views.

Selector not choosing correct variable made by @april.simon with 48 views.

Top 3 Topics with Most Replies

S112_DocumentUnderstanding Exception Scenario made by @Harsha_S1 with 33 replies.

Check if cv get text value is same as another value then the loop should break made by @Neha_Aggarwal1 with 14 replies.

Trigger is not working made by @neha.kumarief868 with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 28 posts!

@Yoichi made 18 posts!

@Sudharsan_Ka made 16 posts!

Top 3 Most Liked Posts

This post made by @jdomanski received 11 likes!

What is the role of a Solution Architect Session follow-up discussion

In my approach, the way of how we document depend on the size of the process, its ownership, clarity of happy path, goals, products and automation workload - which often turns out crucially as we want to deliver results fast. So we shouldn’t limit ourselves to the current definition in a given organization, but rather make a division according to chances for quick wins. Because, after all, according to Porter Value Chain, a process is both a macro-process and its minor component at the sub-proc…

This post made by @GT_Ropa received 3 likes!

How do you guys scale and duplicate the bot into multiple machines easily?

Hi @celie.mccook Hopefully this will help: Usually UR robots are what you want to go for. Please check the community agreement if you want to run multiple robots at the same time. https://www.uipath.com/hubfs/legalspot/Legal%20Terms/UiPath_Community_Agreement.pdf Community edition subject to the conditions herein and the Documentation. If the Customer is either an individual, oran organization that, together with its Affiliates, collectively have (a) less than 250 physical or virtual mach…

This post made by @Jon_Smith received 2 likes!

Status update - Transaction Item / Queue Item

When you don’t know these, I’d suggest looking at the reframework itself to figure it out. You can search for all the set transaction item actions and then figure it out. This will prepare you much better for the exam compared to trying to memorize answers.

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

URL orchestrator request with more than one fitler

DefaultTenant/orchestrator_/odata/QueueItems?$filter=QueueDefinitionId eq 715671 And Status eq 'Failed'

This solution provided by @jack.chan received 1 likes!

Status update - Transaction Item / Queue Item

queueitem is a transaction item transaction item means the unit that you are processing . such as: queue item datarow item (of a list) and so on… all of them follow the same rules since its all using the same reframework so the answer is SetTransactionData.xaml which is in Process Transaction only

This solution provided by @vignesh_S.M received 1 likes!

How to clear the error of implicit conversion from Integer to string?

Thanks @Priyanka_Ramesh … But, the issue is due to the reason that, I have defined the assign activities not within a sequence. After enclosing all the activities within a sequence, the error has gone…

---

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.

[system]

Daily Forum Report | 31 January 2023

Top 3 Topics with Most Views

Outlook Issue- Is there any robust solution for using the Outlook on bot machine? made by @shreyash_shirbhate with 57 views.

What language is best to use if you start your automation journey now? C# vs VB.Net? made by @christel.andersson with 40 views.

Running problem due to resolution made by @mironb with 40 views.

Top 3 Topics with Most Replies

Replace blank value in datable with NA made by @Neha_Aggarwal1 with 23 replies.

Send Email with Multiple attachment made by @pravin_bindage with 15 replies.

Running problem due to resolution made by @mironb with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 50 posts!

@ppr made 26 posts!

@Sudharsan_Ka made 23 posts!

Top 3 Most Liked Posts

This post made by @fernando321 received 2 likes!

Cannot Retrieve latest UiPath.UiAutomation.Activities - error

Trying to retrieve UiPath.UiAutomations.Activities 22.10.5 was causing error. Confirmed no blockers in networking side. Came across updated URL for the Packages (in the 2022.10 documentation). Once added to Studio, the activity downloaded. https://pkgs.dev.azure.com/uipath/public.feeds/_packaging/UiPath-Official/nuget/v3/index.json Hopefully this saves others much research and troubleshooting time!

This post made by @ppr received 2 likes!

How to get the last row value from a datatable

YourDataTable.AsEnumerable.Last() - will return last Datarow lets assume a particular column value from the last row YourDataTable.AsEnumerable.Last()(ColNameOrIndex)

This post made by @supermanPunch received 2 likes!

Second-highest date

Hi @sayed.tabrez , Assuming you have already read the Data from the Excel as a Datatable, you can Check with the below Expression : SecondHighestDate = DT.AsEnumerable.OrderByDescending(Function(x)CDate(x("YourBirthDateColumnName").ToString))(1).ToString Here, SecondHighestDate is of the Type String, and DT is the Datatable variable. Let us know if the above expression does not work.

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

Second-highest date

Hi @sayed.tabrez , Assuming you have already read the Data from the Excel as a Datatable, you can Check with the below Expression : SecondHighestDate = DT.AsEnumerable.OrderByDescending(Function(x)CDate(x("YourBirthDateColumnName").ToString))(1).ToString Here, SecondHighestDate is of the Type String, and DT is the Datatable variable. Let us know if the above expression does not work.

This solution provided by @Aakash_Singh_Rawat received 2 likes!

How i can get alternative values from excel like row 1 and row 3 odd row except even row

Hi @sayed.tabrez, Use assign: odd_dt = dt.AsEnumerable.Where(Function(x) Not dt.Rows.IndexOf(x) Mod 2=0).CopyToDataTable where dt is your output datatable used in Read Range. Please mark this as solution if it solves your problem.

This solution provided by @fernando_zuluaga received 1 likes!

Filtrar un email outlook

Hola puedes probar con el siguiente codigo [image] (From m In mailMessages Where m.Subject.Trim.Contains("yournumber") Select m).ToArray Saludos

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

@Yoichi received 57 likes for their solutions!

@Anil_G received 56 likes for their solutions!

@Kaviyarasu_N received 27 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.

[system]

Daily Forum Report | 01 February 2023

Top 3 Topics with Most Views

What type of automations can be done using uipath made by @Vajrang with 66 views.

When invoking one workflow, the below error showing made by @Yashobanta_Dash with 48 views.

Excel Files Automation made by @DimiG with 47 views.

Top 3 Topics with Most Replies

Excel Files Automation made by @DimiG with 24 replies.

Table Extraction Next Page Problem made by @Arzu_Kaya with 21 replies.

Unable to select from dropdown list made by @Mathkar_kunal with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 65 posts!

@Sudharsan_Ka made 32 posts!

@supermanPunch made 26 posts!

Top 3 Most Liked Posts

This post made by @Vajrang received 8 likes!

What type of automations can be done using uipath

List down all platforms that UiPath can interact with

This post made by @Gokul001 received 6 likes!

Monthly Forum rewards - January 2023

Congratulations to all the winner

This post made by @Anil_G received 5 likes!

Monthly Forum rewards - January 2023

Congratulations Everyone.

Top 3 Most Liked Solutions

This solution provided by @arjunshenoy received 3 likes!

Close chrome gracefully

Hi @pravin_bindage Kill activity will force stop the browser and sets the browser’s ‘exit_type’ flag as Crashed. This might affect the execution & browser performance over a period of time. You can use the ‘Close Application’ or ‘Close Tab’ activity if you want to close the browser gracefully.

This solution provided by @Manish540 received 3 likes!

Linq Query for extracting excel from row containing specific string till row containing specific string

@yash.choursia Check this below workflow attached, Uipath_Extract_GetRangeOfRows.xaml (12.3 KB) Hope this may help you

This solution provided by @Sharwaree_Nimbalkar received 1 likes!

Studio Web | Easy Automation Use case | UiPath

Very helpful and Well explained !!

---

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.

[system]

Daily Forum Report | 02 February 2023

Top 3 Topics with Most Views

Write Range Object reference not set Error made by @DimiG with 39 views.

Read File With Sequence File Name Order made by @Hendaryie_Tjoeng with 38 views.

How to remove set of words with a keyword made by @sunilkanth with 38 views.

Top 3 Topics with Most Replies

Write Range Object reference not set Error made by @DimiG with 43 replies.

Read File With Sequence File Name Order made by @Hendaryie_Tjoeng with 19 replies.

Build Data Table error with Google.Apis.Drive.v3.Data.File type made by @Jes_Hunsballe with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 87 posts!

@DimiG made 21 posts!

@fernando_zuluaga made 19 posts!

Top 3 Most Liked Posts

This post made by @arivu96 received 3 likes!

Monthly Forum rewards - January 2023

Congratulations to all the winners

This post made by @Bilal_Anwar received 2 likes!

Monthly Forum rewards - January 2023

Congratulations everyone

This post made by @Anil_G received 2 likes!

Setting ENV variables in Orchestrator

@marcus.coates12 Yes it sets the value in orchetsrator not in the system env variables…but if you want to set environment variable you have an activity for that…and the value for it can be controlled from assets Similarly you have a get env variable as well Cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Setting ENV variables in Orchestrator

@marcus.coates12 Yes it sets the value in orchetsrator not in the system env variables…but if you want to set environment variable you have an activity for that…and the value for it can be controlled from assets Similarly you have a get env variable as well Cheers

This solution provided by @Anil_G received 1 likes!

How to send emails from Outlook 365 with Two-factor authentication?

@Lynx No it is not like that…we use secret…did you give application scope? …app secret does not work with delegated permissions it needs application permissions in your azure app Can you try adding this package feed to manage packages and check https://pkgs.dev.azure.com/uipath/public.feeds/_packaging/UiPath-Official/nuget/v3/index.json Cheers

This solution provided by @Yoichi received 1 likes!

Regex to extract text before keyword and include the keyword

Hi, Can you try the following pattern? \S*\.ca [image] Regards,

---

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.

[system]

Daily Forum Report | 03 February 2023

Top 3 Topics with Most Views

実行するにはコンパイルする必要があります とエラーが表示される made by @spaceforce with 45 views.

How to split excel data using a specific column using Studio made by @raisonne with 43 views.

[Data Service] How to add value to variable in uipath studio made by @Anh_Tuan with 40 views.

Top 3 Topics with Most Replies

How to split excel data using a specific column using Studio made by @raisonne with 27 replies.

実行するにはコンパイルする必要があります とエラーが表示される made by @spaceforce with 13 replies.

Get IMAP Mail Messages: Input string was not in a correct format made by @Manju_Reddy_Kanughula with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 38 posts!

@supermanPunch made 21 posts!

@fernando_zuluaga made 19 posts!

Top 3 Most Liked Posts

This post made by @km81 received 2 likes!

Unable to sign in cloud.uipath.com

@loginerror Thanks for your message I will get help from Colud Technical support on this.

This post made by @Yoichi received 2 likes!

実行するにはコンパイルする必要があります とエラーが表示される

以下の事例ですと、ライブラリ側で（内部で）参照しているUiPath.System.Activites packageを22.10.3から22.4.5にダウングレードすると解消したそうです。

This post made by @ppr received 2 likes!

How to convert ienumerable<queueItem> to datatable

We assume that get Queue Item->s is used here we would recommend to specify what is needed. QueueItems Properties e.g. Reference, Status,… SpecificContent infos Example: All SpecificContent Dictionaries to DataTable Assign Activity: dtData = JArray.FromObject(YourGetQueueItemsOut.Select(Function (x) x.SpecificContent).toArray).toObject(Of DataTable)

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

How to convert ienumerable<queueItem> to datatable

We assume that get Queue Item->s is used here we would recommend to specify what is needed. QueueItems Properties e.g. Reference, Status,… SpecificContent infos Example: All SpecificContent Dictionaries to DataTable Assign Activity: dtData = JArray.FromObject(YourGetQueueItemsOut.Select(Function (x) x.SpecificContent).toArray).toObject(Of DataTable)

This solution provided by @supermanPunch received 2 likes!

How to split excel data using a specific column using Studio

Hi @raisonne , Could you Check with the below Steps : Create and Initialise a Dictionary variable in the below way using an Assign Activity : TeamDict = new Dictionary(Of String,Datatable) Get the Team Set as Groups, convert to Datatable and add to Dictionary using an Assign Activity like below TeamDict = DT.AsEnumerable.GroupBy(Function(x)x("TEAM").ToString).ToDictionary(Function(x)x.First.Item("TEAM").ToString,Function(y)y.CopyToDataTable) Now, We can loop through the Dictionary TeamD…

This solution provided by @Gokul001 received 1 likes!

Working with Date (dd.MM.yyyy) format

Hi @M_L Print the Date in the log message and get the date format from it. in_TransactionItem.SpecificContent("Start").Tostring And update the date format in the expression and check it [image] Regards Gokul

---

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.

[system]

Daily Forum Report | 04 February 2023

Top 3 Topics with Most Views

Create HTML Content. Add Image at runtime made by @altp123 with 70 views.

Invoke PowerShell/Start Process: Backslashes get Added to String at Runtime made by @Jack_Moran with 45 views.

Windows-Legacy made by @447_J_U_S_SANDEEP with 37 views.

Top 3 Topics with Most Replies

Select unknown element made by @alexis.mendoza with 10 replies.

How press ctrl+D in excel application made by @vineelag with 7 replies.

Rearrange made by @Devendra_Bhardwaj with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 31 posts!

@rikulsilva made 10 posts!

@fernando_zuluaga made 9 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

How can I delete the same records in excel file?

@Arzu_Kaya Please remove the Write range and use Merge datatable and Write it at the ends Filter - Dt.AsEnumerable.Where(function(x) x.ItemArray.Any(function(y) IsNothing(y) OrElse String.IsNullOrEmpty(y.ToString.Trim))).CopyToDataTable cheers

This post made by @FIROZ_RANGREZ received 1 likes!

How press ctrl+D in excel application

Hi @vineelag , You can use send hotkey like this [image] in indicate on screen, try to select your excel application Regards, Firoz

This post made by @FIROZ_RANGREZ received 1 likes!

How press ctrl+D in excel application

Hi @vineelag , Try to use Active Accessibility (Marked in red in the below snap)as a framework when indicating element and select whole excel. like this [Untitled] Here you can see I have selected the whole excel and validate the properties as @RajKumar_DC has mentioned. Regards, Firoz

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

How can I delete the same records in excel file?

@Arzu_Kaya Please remove the Write range and use Merge datatable and Write it at the ends Filter - Dt.AsEnumerable.Where(function(x) x.ItemArray.Any(function(y) IsNothing(y) OrElse String.IsNullOrEmpty(y.ToString.Trim))).CopyToDataTable cheers

---

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.

[system]

Daily Forum Report | 05 February 2023

Top 3 Topics with Most Views

How do i add flow decision activity on studio web? and loop it as in studiopath normal made by @Arvind_Karthigayan with 71 views.

How to find count of today date in excel based on input value made by @Raja.G with 35 views.

Number Filter UiPath made by @Real.Downey with 34 views.

Top 3 Topics with Most Replies

Issue with the selector made by @govindreddy_nagireddy with 18 replies.

Write Range Workbook: Object Reference Not set to an instance of an Object_Error while getting Queue Items from Orchestrator made by @Alekhya_Gandhi with 13 replies.

An activity that breaks the loop in the flowchart after a certain amount of repetitions made by @eduardo34 with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 34 posts!

@rikulsilva made 14 posts!

@govindreddy_nagireddy made 12 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

How can you pass different DataTables in .rows.Items

Hi, FYI, another approach without if: dict = New Dictionary(Of Boolean, DataTable)From{{true,dtA},{false,dtB}} dict is Dictionary<Boolean, DataTable> type Then, the following will work. dict(condition).Rows(0).Item(0).ToString [image] Sample20230206-1L.zip (2.7 KB) Regards,

This post made by @NiesonF received 1 likes!

How can you pass different DataTables in .rows.Items

This worked perfectly!

This post made by @Boopathi.M received 1 likes!

How to click on a Ui Element only if it contain a specific text ( out of many similar Ui element )

Hi @celie.mccook Use click activity and indicate it on your name and analyze the selector if any element is unique for that particular name like aaname or text and you can pass variable dynamically in the selector to click on your name or any other name you wish to click You can see Data Extract example in UiPath site Thanks

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How can you pass different DataTables in .rows.Items

Hi, FYI, another approach without if: dict = New Dictionary(Of Boolean, DataTable)From{{true,dtA},{false,dtB}} dict is Dictionary<Boolean, DataTable> type Then, the following will work. dict(condition).Rows(0).Item(0).ToString [image] Sample20230206-1L.zip (2.7 KB) Regards,

This solution provided by @rikulsilva received 1 likes!

How could I separate one column into multiple colums with their values?

@pprin001 Hi Use Read CSV activity and pass the column separator (,) The output is a DataTable that you can save

This solution provided by @Anil_G received 1 likes!

Which country has most points?

@Comet Did you create a datatable using build Datatable as stated above? Also try this, I have added check to rating if it is a number Newdt = (From d In ExtractedTable.AsEnumerable() Group d By k=d("Country").toString.Trim Into grp = Group Let sum = grp.sum(function(x) If(IsNumeric(x("Rating").ToString.Trim),CDBL(x("Rating").ToString.Trim),0)) Let ra = New Object(){k,sum} Select r = Newdt.Rows.Add(ra)).CopyToDataTable() cheers

---

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.

[system]

Daily Forum Report | 06 February 2023

Top 3 Topics with Most Views

Where we can use ChatGPT with UiPath? made by @BNK with 55 views.

Filter requester for specific people made by @goncalo.rocha with 41 views.

Delete row studiox not working made by @Mark_Rajkumar with 41 views.

Top 3 Topics with Most Replies

Delete row studiox not working made by @Mark_Rajkumar with 24 replies.

Filter requester for specific people made by @goncalo.rocha with 21 replies.

Duplicate row Uipath made by @Krishan_Rapswal with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 50 posts!

@Gokul001 made 25 posts!

@ppr made 15 posts!

Top 3 Most Liked Posts

This post made by @PGCC received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, my name is Phil and I work mostly supporting the infrastructure that constructs the environments in which we run our automations.

This post made by @Ashutosh.Gupta received 2 likes!

Get latest file based on creation time

Hi Dinesh, Please try ‘For each file in folder’ activity. In this activity update “ORDER BY” => “Create date oldest first”. [Screenshot (29)]

This post made by @Sisay_Dinku received 2 likes!

I want to try RPA challenge using Reframework while Dispatcher Intergrated in Performer

Hi @Anil_G and @fernando_zuluaga Yes, I was able to integrate the dispatcher into the main process using switch activity and it’s worked fine. Thanks, guys, for your perspective. That was very helpful.

Top 3 Most Liked Solutions

This solution provided by @Ashutosh.Gupta received 2 likes!

Get latest file based on creation time

Hi Dinesh, Please try ‘For each file in folder’ activity. In this activity update “ORDER BY” => “Create date oldest first”. [Screenshot (29)]

This solution provided by @FIROZ_RANGREZ received 1 likes!

How to get 1st 3 letters of a 8 letter word to type into from a json string key data?

Hi @Arvind_Karthigayan, Try like this Jobj("orderId").ToString().SubString(0,3) Regards, Firoz

This solution provided by @Tuannna1 received 1 likes!

Oauth2.0

OAuth 2.0 is a protocol used to secure authorization to access resources. To integrate OAuth 2.0 with UiPath, you need to perform the following steps: Obtain OAuth 2.0 credentials: Depending on the OAuth 2.0 provider, you may need to register your application and obtain client ID, client secret, and a redirect URL. Use the UiPath Web API activities to build a workflow that performs the OAuth 2.0 authorization flow. This usually involves sending a request to the authorization endpoint to get a…

---

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.

[system]

Daily Forum Report | 07 February 2023

Top 3 Topics with Most Views

How to install UiPath studio for latest version 2022.10 (I am using Flex plan) made by @BNK with 42 views.

ReFrameworkでインプットファイルがない場合の処理 made by @111860 with 38 views.

How to get dynamic cell range made by @Sai.Srinivas with 36 views.

Top 3 Topics with Most Replies

Why retry is not working in system Exception in Reframework in uipath? made by @Prabin_Chand with 19 replies.

How to run java based web application in locked screen? made by @Prabin_Chand with 19 replies.

Add prefix to whole row made by @neha.kumarief868 with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 74 posts!

@Sudharsan_Ka made 30 posts!

@rikulsilva made 28 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

How to filter value using query instead of filter data table

dtResult = From d in YourDataTabeVar.AsEnumerable Let si = d.Item("Index").ToString.Trim Where {"0","1.0"}.Any(Function (x) si.StartsWith(x)) Select r = d).CopyToDataTable Handling empty results: [FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum

This post made by @rikulsilva received 2 likes!

How to filter value using query instead of filter data table

Hi, you can use linq for this yourDt = yourDt.AsEnumerable.Where(Function(x) x.Item("Index").ToString.StartsWith("0")).CopyToDataTable But, before make assignment, make sure that the DT has least one row with your condition or it will be throw a exception in CopyDataTable method. put in if condition yourDt.AsEnumerable.Where(Function(x) x.Item("Index").ToString.StartsWith("0")).Any Or you can directly put in assign using if your dt = if(yourDt.AsEnumerable.Where(Function(x) x.Item("Index")…

This post made by @rikulsilva received 2 likes!

How to create an action for x amount of times a task is performed

You can use loop activities to processes your tasks. Inside your loop, put some validation before start the next one. For example, check if login time out occurs, if so, you call other workflow just for login. Then your process continues without break. If you need more robust solution with retry mechanism, processes task individually and so on the better choice is ReFramework If you perform simple task, you can create additional step for check login. Specially create a workflow only for lo…

Top 3 Most Liked Solutions

This solution provided by @rikulsilva received 1 likes!

How to filter value using query instead of filter data table

Yes, it is. Just add “or” condition yourDt = yourDt.AsEnumerable.Where(Function(x) x.Item("Index").ToString.StartsWith("0") or x.Item("Index").ToString.StartsWith("1.0")).CopyToDataTable

This solution provided by @Anil_G received 1 likes!

For each excel Row How do I message box counting out the numbers?

@oscar.o Then use fa filter datatable and filter the required row with 0 and then use filtereddt.rowcount and in message box write "0 is repeated " + filtereddt.rowcount.tostring Or create a integer variable and initialize it with 0 …then in the then condition use counter = counter+1 in assign and get the count and outside the loop use Msg box with "0 is repeated " + counter.tostring Hope this helps Cheers

This solution provided by @supermanPunch received 1 likes!

Error "End of expression expected" on Type Into activity

Hi @Dea_Pahumi , Could you try changing the Expression to the below : if(String.IsNullOrWhiteSpace(in_Address1),"",in_Address1) This part should be handled when you enabled the Property EmptyField [image] Let us know if this does not work as Expected and describe what happens.

---

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.

[system]

Daily Forum Report | 08 February 2023

Top 3 Topics with Most Views

Automatically adding values inside of array input of library activity made by @GT_Ropa with 76 views.

I have one problem made by @Shubham_Bidwai with 51 views.

Need to calculate the days for different year and month made by @sruthesanju with 49 views.

Top 3 Topics with Most Replies

I have one problem made by @Shubham_Bidwai with 32 replies.

How can I set web element attribute "hasFocus" to True? made by @Prabin_Chand with 22 replies.

Selecting a range of items in an array made by @olmccb with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 70 posts!

@Sudharsan_Ka made 36 posts!

@rikulsilva made 22 posts!

Top 3 Most Liked Posts

This post made by @Omkar_Shete1 received 2 likes!

Monthly Forum rewards - January 2023

Congratulations Anil_G

This post made by @vishal.kp received 2 likes!

Linq query to filter line items not starts with particular value

Hi @mohamedalthaf , You can negate the condition by just putting Not infront of it like shown below. DT.AsEnumerable().Where(Function(w) not w(“Amount”).ToString.Trim.StartsWith(“-”)).CopyToDataTable

This post made by @supermanPunch received 2 likes!

Assign error in chatgbt (Non-invocable member can not be used like a method)

Hi @hb61 , Could you try changing to the below Expression and Check if it works : ChatGBTInput["prompt"]

Top 3 Most Liked Solutions

This solution provided by @vishal.kp received 2 likes!

Linq query to filter line items not starts with particular value

Hi @mohamedalthaf , You can negate the condition by just putting Not infront of it like shown below. DT.AsEnumerable().Where(Function(w) not w(“Amount”).ToString.Trim.StartsWith(“-”)).CopyToDataTable

This solution provided by @supermanPunch received 2 likes!

Assign error in chatgbt (Non-invocable member can not be used like a method)

Hi @hb61 , Could you try changing to the below Expression and Check if it works : ChatGBTInput["prompt"]

This solution provided by @Anil_G received 1 likes!

Filtering in /odata/jobs?

@Mads_Commerou Please try using filters on time …they look something liek this $filter=TimeStamp ge 2023-01-22T02:00:20.043Z. For more details on api please check the swagger files Get swagger by appending swagger/index.html to your orchestrator url Cheers

---

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.

[system]

Daily Forum Report | 09 February 2023

Top 3 Topics with Most Views

🆕 Reviews Campaign: Rate UiPath on G2 and get rewarded! made by @Dana_Mustatea with 69 views.

Unique Email Creation made by @Sai.Srinivas with 46 views.

How to format an extracted text made by @alexis.mendoza with 43 views.

Top 3 Topics with Most Replies

Type into not removing previous text and not entering new text made by @Riya_Bansal with 20 replies.

Mail can not sent made by @Shubham_Bidwai with 19 replies.

Unique Email Creation made by @Sai.Srinivas with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 29 posts!

@Shubham_Bidwai made 22 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @Krollythegoalie received 3 likes!

Dev Dives: Slingshot your next Low Code App!

Hello UiPath Community, Do you like seeing examples of UiPath Apps in action? Are you ready to learn how to approach building more complicated Apps? If so, I have some exciting news for you… I’m David Kroll, Director of Product Marketing at Ashling Partners - and I’m thrilled to be on the next Dev Dives episode on Thursday, February 23rd! During my development career, I helped deliver over 20 real-world apps. In this session, I’ll walk through how I approach wireframing and design, the too…

This post made by @jack.chan received 3 likes!

Error: "Log Message : Object reference not set to an instance of an object."

the error is happening because you didnt type CourseEmails here, meaning the extracted mails are not assigned to CourseEmails variable type in CourseEmails here, and try again @Islam_ISmail [image]

This post made by @sharon.palawandram received 2 likes!

Submit your AI Use Cases for the UiPath AI Summit 2023, Challenge

Please vote on this use case - Extract structured documents using Forms AI.

Top 3 Most Liked Solutions

This solution provided by @jack.chan received 3 likes!

Error: "Log Message : Object reference not set to an instance of an object."

the error is happening because you didnt type CourseEmails here, meaning the extracted mails are not assigned to CourseEmails variable type in CourseEmails here, and try again @Islam_ISmail [image]

This solution provided by @Yoichi received 2 likes!

Regex to extract nth item from CSV string and save it to a string variable

Hi, If we use regex101 for UiPath, it’s better to set C# at flavor as the following image. And the following pattern will work for your requirement. (?<=^([^,]+,){5})[^,]* [image] [image] Regards,

This solution provided by @kennbalobalo received 1 likes!

Selecting a range of items in an array

Glad to know that the file opened up now. happy to help and contribute to the community!

---

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.

[system]

Daily Forum Report | 10 February 2023

Top 3 Topics with Most Views

If condition always comes as false made by @DimiG with 51 views.

Two Excel compare made by @pravin_bindage with 48 views.

Regex to get number made by @Deepa_Madkar with 46 views.

Top 3 Topics with Most Replies

Two Excel compare made by @pravin_bindage with 23 replies.

Regex to get number made by @Deepa_Madkar with 20 replies.

If condition always comes as false made by @DimiG with 18 replies.

Top 3 Users Who Posted The Most

@Yoichi made 29 posts!

@Sudharsan_Ka made 27 posts!

@Anil_G made 22 posts!

Top 3 Most Liked Posts

This post made by @Acovuk received 1 likes!

Issue with "IBM iAccess Client Solutions" - Microsoft C++ Runtime Library Error Popup

Hello guys, I have an issue with the application “IBM iAccess Client Solutions - AS400” when starting a workflow. I get the error message shown below: [Forum1] Expression: !“A HotSpot VM Attach API is attempting to connect to an OpenJ9 VM. This is not supported.” Problem: Microsoft C++ Visual Runtime Library Error A new pop-up appears after every click in the application. It’s not possible to run a workflow within this application… This worked fine for years but now it doesn’t… Can anybod…

This post made by @Yoichi received 1 likes!

How to obtain a new column with those values

HI, Because in the original file write it without header. For now, can you try to add the following expression just after AddDataColumn activity? dtConsolidadoOoutput.Rows(0)("newColumn")="name" [image] Regards,

This post made by @RZVP received 1 likes!

Automation Suite courses - Feedback space

Hi @Hiba_B , The UiPath Automation Suite Installation course has been released as planned, In November 2021. It’s available here: https://academy.uipath.com/courses/uipath-automation-suite-installation. As for the diagrams, some of them are available on the UiPath Documentation portal, for example here: Deployment architecture And if you have specific questions about Automation Suite, I’d suggest to check the threads under the Automation Suite category and ask the questions there. The product…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to convert json String to dictionary

Hi, Can you try the following sample? This outputs datatable. [image] Sample20230210-1L.zip (2.8 KB) Regards,

This solution provided by @nikhil.girish received 1 likes!

Data scrapping wizard not showing in the panel

Hi @Dileep_D You might have updated the studio Check if there is something called table extraction

This solution provided by @Yoichi received 1 likes!

Merge multiple rows into one based on common column values

HI, The following is grouping by column “Booking No”,“Booking Component ID”, “Item No” and “Booking Status” and concatenate string in “note” column. In remaining column, the first row is kept. Does this work for you? Or do you need grouping by all the columns except “note” column? [image] Sample20230210-4Lv2.zip (21.2 KB) Regards,

---

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.

[system]

Daily Forum Report | 11 February 2023

Top 3 Topics with Most Views

I don't quite understand trim made by @CK_CHECK with 34 views.

IF problems with dynamic pages..! made by @CK_CHECK with 33 views.

Dynamic read range made by @Sabbir_Anwar with 28 views.

Top 3 Topics with Most Replies

IF problems with dynamic pages..! made by @CK_CHECK with 6 replies.

How to replace multiple words while working with 3 documents? made by @Alearns with 4 replies.

How to Convert the Parallel Activity to Parallel For Each Activity? made by @ppqrstvwxyz with 4 replies.

Top 3 Users Who Posted The Most

@Anil_G made 28 posts!

@Sudharsan_Ka made 7 posts!

@Yoichi made 6 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

Document Understanding - handle document error

@Camila_Caldas To start with when something fails because of system it is always good to retry before marking exception… So ideally adding it back to queue is good to re processes it… Again …as AI center involves sku’s/AI units which get consumed…if we are extracting information from multiple documents in same transaction and bot failed after extracting one or two and if the exception is unknown we can retry…but to maintain it…it would be good…if the process can be continued or reuse the docu…

This post made by @postwick received 1 likes!

Linq Query - datatable

Use the Join Datatable activity. What you’re trying to do is called a join. It’s a standard database operation.

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

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.

[system]

Daily Forum Report | 12 February 2023

Top 3 Topics with Most Views

Help about regex - UIPath made by @Shoji with 37 views.

UiPath REST API Call made by @Umer_Shahid with 34 views.

How can I change the size of chrome browser? made by @Judy with 32 views.

Top 3 Topics with Most Replies

How to download files and find path from multiple subfolders in SharePoint using 0365 Activities made by @Akshay_Suryawanshi with 12 replies.

Reply to a sent mail of particular date based on Subject made by @IT2_08_Saket_Maurya with 9 replies.

How to calculate percentage in Uipath excel file made by @Sanket_RPA with 7 replies.

Top 3 Users Who Posted The Most

@Yoichi made 10 posts!

@fernando_zuluaga made 8 posts!

@IT2_08_Saket_Maurya made 6 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Help about regex - UIPath

Hi, How about the following? dtPlace.AsEnumerable.Where(function(x) System.Text.RegularExpressions.Regex.IsMatch(CurrentRow("Address").ToString.ToLower, "\b"+x("State").ToString.ToLower + "\b")) Regards,

This post made by @nikhil.girish received 2 likes!

Activity read text file throwing an error

Hi @Prasidh_Krishna Check out this similar topic Hope this might help

This post made by @RPAForEveryone received 1 likes!

How can I change the size of chrome browser?

Hi @Judy As seen in the image I shared, the last row has a shortcut to “reset” zoom level. In your situation, you could use Reset Zoom and then zoom out 10% at a time, as needed. The standard behaviour is each Ctrl + - command zooms out by 10%. So the following three keystrokes with, say, 0.5 or 1-second delay will get you to the right zoom. Send Keystrokes → Ctrl+ 0 (100%) Send Keystrokes → Ctrl + - (90%) Send Keystrokes → Ctrl + - (80%) Adjust as needed

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Help about regex - UIPath

Hi, How about the following? dtPlace.AsEnumerable.Where(function(x) System.Text.RegularExpressions.Regex.IsMatch(CurrentRow("Address").ToString.ToLower, "\b"+x("State").ToString.ToLower + "\b")) Regards,

This solution provided by @nikhil.girish received 2 likes!

Activity read text file throwing an error

Hi @Prasidh_Krishna Check out this similar topic Hope this might help

This solution provided by @kali received 1 likes!

Reply to a sent mail of particular date based on Subject

I see what u mean now. you can try the following my example here… [image] yourDate is datetime variable. For your case that would be the date your trying to filter. This should be a filter condition for your get email activity: “[SentOn] >= '” + yourDate.ToLongDateString+“’ AND [SentOn] < '” + yourDate.AddDays(1).ToLongDateString+“'” Hope this helps

---

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.

[system]

Daily Forum Report | 13 February 2023

Top 3 Topics with Most Views

Add comment to cell made by @arina with 54 views.

Older date made by @GDMM with 46 views.

Can i use wildcard(*) in assign activity made by @pravin_bindage with 44 views.

Top 3 Topics with Most Replies

「OneDriveとSharePointを使用」の利用について made by @_kurosawa_daisuke with 15 replies.

Can i use wildcard(*) in assign activity made by @pravin_bindage with 15 replies.

Regexproblem made by @Kuldeep_Pandey with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 75 posts!

@Sudharsan_Ka made 45 posts!

@Mark_Rajkumar made 16 posts!

Top 3 Most Liked Posts

This post made by @g.ward received 3 likes!

UiPath Apps 'Stop Process' Function

Hi, I had a request from a customer to build in a simple pause/stop function for a long running bot, as sometimes they need to kick it off the software it runs on to allow them to complete a task. I was hoping this would be a quick job, a simple pause button I could build into the existing UiPath App they have to send a stop process command, but it looks like that is not an option - you can only start a process. I considered building a second bot to send the stop command via an API, but that …

This post made by @RobertRussell_Monsalud received 2 likes!

Conversion from type 'DBNull' to type 'Integer' is not valid in Excel

Hi @fernando_zuluaga and @Anil_G! Thank you so much for your help. If there is only a way to mark as a solution both of your responses, I would have done it. Best regards, Robert Monsalud

This post made by @iamNairda received 2 likes!

I need help plz ..ideas of busniess process in uipath

Maybe you find something good in the Use Case repository:

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Conversion from type 'DBNull' to type 'Integer' is not valid in Excel

@RobertRussell_Monsalud You have two options here… Use excel formula using write cell …first read the datatable which will give you the rowcount = dt.Rowcount Now use write cell with values as "= Sum(B2:B" + rowcount.ToString + ")" and cell as “B” + (RowCount+1).ToString Or Read the datatable then use assign activity as below Sum = dt.AsEnumerable.Sum(function(x) if(IsNothing(x("Games Played")) OrElse String.IsNullOrEmpty(x("GamesPlayed").ToString.Trim,0,cdbl(x("Games Played").ToString))) …

This solution provided by @supermanPunch received 1 likes!

How count present date count based on find least count date present cell value

Hi @Raja.G , Could you Check with the below Expression : DT.AsEnumerable.OrderBy(Function(x)x.ItemArray.Skip(2).Where(Function(y)y.ToString.Contains(Now.ToString("MM.dd.yy"))).Count).First.Item("Name").ToString Here, DT is your Datatable variable. Let us know if it doesn’t work and what was the error received.

This solution provided by @Anil_G received 1 likes!

How to activate Flex License? Which orchestrator to use for Flex License? As there is no orchestrator license

@nisargkadam23 I believe that should be same… But as you have a chance of messing up…Would suggest contact the support …They would confirm as well if there are any issues Because as per docs that I shared as well I don’t see any separate way to do but use the same as one thing for sure is that there isn’t any separate license for orchestrator at all… license is basically for orchestrator to understand what you purchased cheers

---

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.

[system]

Daily Forum Report | 13 February 2023

Top 3 Topics with Most Views

Add comment to cell made by @arina with 54 views.

Older date made by @GDMM with 46 views.

Can i use wildcard(*) in assign activity made by @pravin_bindage with 44 views.

Top 3 Topics with Most Replies

「OneDriveとSharePointを使用」の利用について made by @_kurosawa_daisuke with 15 replies.

Can i use wildcard(*) in assign activity made by @pravin_bindage with 15 replies.

Regexproblem made by @Kuldeep_Pandey with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 75 posts!

@Sudharsan_Ka made 45 posts!

@Mark_Rajkumar made 16 posts!

Top 3 Most Liked Posts

This post made by @g.ward received 3 likes!

UiPath Apps 'Stop Process' Function

Hi, I had a request from a customer to build in a simple pause/stop function for a long running bot, as sometimes they need to kick it off the software it runs on to allow them to complete a task. I was hoping this would be a quick job, a simple pause button I could build into the existing UiPath App they have to send a stop process command, but it looks like that is not an option - you can only start a process. I considered building a second bot to send the stop command via an API, but that …

This post made by @RobertRussell_Monsalud received 2 likes!

Conversion from type 'DBNull' to type 'Integer' is not valid in Excel

Hi @fernando_zuluaga and @Anil_G! Thank you so much for your help. If there is only a way to mark as a solution both of your responses, I would have done it. Best regards, Robert Monsalud

This post made by @iamNairda received 2 likes!

I need help plz ..ideas of busniess process in uipath

Maybe you find something good in the Use Case repository:

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Conversion from type 'DBNull' to type 'Integer' is not valid in Excel

@RobertRussell_Monsalud You have two options here… Use excel formula using write cell …first read the datatable which will give you the rowcount = dt.Rowcount Now use write cell with values as "= Sum(B2:B" + rowcount.ToString + ")" and cell as “B” + (RowCount+1).ToString Or Read the datatable then use assign activity as below Sum = dt.AsEnumerable.Sum(function(x) if(IsNothing(x("Games Played")) OrElse String.IsNullOrEmpty(x("GamesPlayed").ToString.Trim,0,cdbl(x("Games Played").ToString))) …

This solution provided by @supermanPunch received 1 likes!

How count present date count based on find least count date present cell value

Hi @Raja.G , Could you Check with the below Expression : DT.AsEnumerable.OrderBy(Function(x)x.ItemArray.Skip(2).Where(Function(y)y.ToString.Contains(Now.ToString("MM.dd.yy"))).Count).First.Item("Name").ToString Here, DT is your Datatable variable. Let us know if it doesn’t work and what was the error received.

This solution provided by @Anil_G received 1 likes!

How to activate Flex License? Which orchestrator to use for Flex License? As there is no orchestrator license

@nisargkadam23 I believe that should be same… But as you have a chance of messing up…Would suggest contact the support …They would confirm as well if there are any issues Because as per docs that I shared as well I don’t see any separate way to do but use the same as one thing for sure is that there isn’t any separate license for orchestrator at all… license is basically for orchestrator to understand what you purchased cheers

---

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.

[system]

Daily Forum Report | 14 February 2023

Top 3 Topics with Most Views

How to check a string starts with numeric value and ends with alphabets made by @chandolusathi.kumar with 52 views.

Remove/Add/Replace image/text into the word header and footer made by @Manjunath_Ramappa with 46 views.

Need to remove last characters made by @govindreddy_nagireddy with 41 views.

Top 3 Topics with Most Replies

How to check a string starts with numeric value and ends with alphabets made by @chandolusathi.kumar with 25 replies.

Copy file, rename it with T-1 date and paste it on same folder made by @Nicholas_Yu with 20 replies.

ExtractedText.Trim.Replace is not visible to use made by @niranjan.kummara with 18 replies.

Top 3 Users Who Posted The Most

@Sudharsan_Ka made 49 posts!

@Anil_G made 33 posts!

@Yoichi made 30 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Extract Html

get attribute Activity on the attribute with name lang along with a manually postedited selector

This post made by @Anil_G received 2 likes!

Extract Html

@kanmz You can try using ger attribute with whole window selector on lang Cheers

This post made by @ppr received 2 likes!

Extract Html

with the solution mark we would assume that the suggestion was working if not have a look here: [grafik] we manually edited and used under the parent selector <webctrl tag='HTML' />

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Extract Html

with the solution mark we would assume that the suggestion was working if not have a look here: [grafik] we manually edited and used under the parent selector <webctrl tag='HTML' />

This solution provided by @nikhil.girish received 2 likes!

How to ignore case to check string match

Hi @Prakash_P3 Convert both string either upper or lower for comparison STR1.ToUpper=STR2.ToUpper

This solution provided by @ABHIMANYU_THITE1 received 1 likes!

Getting Error : Assign: Cannot create an L-value from the given expression with property 'ColumnName' because the target object is null

Hi @srinivas_pradeep, you are trying to assign a value to an object property, but the object itself is null, meaning it hasn’t been instantiated or assigned a value. In other words, you are trying to access a property of an object that doesn’t exist. Kindly check the target object is instantiated or not. Happy Automation, Cheers!

---

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.

[system]

Daily Forum Report | 15 February 2023

Top 3 Topics with Most Views

Credential Expiry Field in Orchestrator made by @Jayavignesh_G with 60 views.

UiPath API - how to add $filter to sub level property? made by @david.jonsson with 58 views.

Orchestrator in Automation Cloud™ - Data Retention and Archiving for Jobs made by @Alexandru_Szoke with 58 views.

Top 3 Topics with Most Replies

Document understanding - Digitize document error made by @srinivas_pradeep with 13 replies.

Regex Match problem ( Assign: Object reference not set to an instance of an object) made by @TakeshiC with 12 replies.

Simulate click stopped working after update on 2022.10.5 version made by @Petar_Soce with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 31 posts!

@fernando_zuluaga made 24 posts!

@Yoichi made 16 posts!

Top 3 Most Liked Posts

This post made by @prasadsatish received 10 likes!

UiPath Community MVP 2023 announcement!

Many Congratulations to all MVP 2023! I loved the way various UiPath Community members interact with each other; Solid technical expertise shown by community members always help and design your automation supporting best practices. I also look forward to networking with fellow UiPath MVPs to support & contribute a common goal to RPA Democratization. Thanks @Vibhor.Shrivastava @Rohit_Radhakrishnan @cristina.vidu for building such amazing community. With the UiPath MVP program, I want to con…

This post made by @Gokul001 received 10 likes!

UiPath Community MVP 2023 announcement!

Great news !! Thanks UiPath for recognize me as an UiPath MVP 2023, and I’m very happy to be a part of it thanks @Vibhor.Shrivastava and @Rohit_Radhakrishnan for the amazing support Congratulations to all other MVPs . I’m really excited to work together and make great things with the UiPath community.

This post made by @Sudharsan_Ka received 9 likes!

UiPath Community MVP 2023 announcement!

Congrats !! to all MVP’s

Top 3 Most Liked Solutions

This solution provided by @nikhil.girish received 2 likes!

How to change column data type of a datatable

Hi @Karthik_1256 Check this activity

This solution provided by @Sathish_Kumar_S received 1 likes!

Getting strange exception while running Get Google Token activity

Please install Bouncy Castle portable Version 1.9.0. package that will solve the issue

This solution provided by @fernando_zuluaga received 1 likes!

How calculate each item in excel

Hey here is your solution BlankProcess1.zip (11.6 KB) Regards

---

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.

[system]

Daily Forum Report | 16 February 2023

Top 3 Topics with Most Views

Linq query to update datatable column made by @Sasikanth with 49 views.

"Add to dictionary" Activity is not available in uipath studio made by @Yazharasan with 47 views.

How to get value by Regex match made by @TakeshiC with 47 views.

Top 3 Topics with Most Replies

How to get value by Regex match made by @TakeshiC with 28 replies.

Linq query to update datatable column made by @Sasikanth with 16 replies.

How to get the Required values form the string using regex expressions made by @chandolusathi.kumar with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 52 posts!

@Sudharsan_Ka made 38 posts!

@fernando_zuluaga made 23 posts!

Top 3 Most Liked Posts

This post made by @Venkatesh_R1 received 5 likes!

UiPath Community MVP 2023 announcement!

Hearty Congratulations to all the MVPs of 2023

This post made by @kennbalobalo received 5 likes!

UiPath Community MVP 2023 announcement!

I am honored and humbled to be an MVP 2023. Congratulations to my amazing fellow MVPs! I am looking forward to collaborating with you and supporting the community! Thank you so much, UiPath and UiPath Community, for all the support.

This post made by @jamesjacobsydney received 4 likes!

UiPath Community MVP 2023 announcement!

Congratulations to all MVPs!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Split関数の使い方について

こんにちは 変数名.Split({" "c,"_"c}) で空白と _ の両方の文字でSplitできますので 変数名.Split({" "c,"_"c})(2) で取得できると思います。

This solution provided by @Jack_Moran received 1 likes!

Invoke PowerShell/Start Process: Backslashes get Added to String at Runtime

With the help of @Anil_G I have found the answer: As he mentions below, the backslashes don’t actually do anything; they are just UiPath’s way of processing my String. The actual issue was the command itself: I had failed to account for time zones! This is why my extracted logs, and the logs I was seeing in Event Viewer for the same time period, did not match up. The above command is still correct, but you must specify to your end user that their input should be in UTC time, NOT your timezone.

This solution provided by @Sudharsan_Ka received 1 likes!

Unable to install Bala Reva easy excel packages

Checkout this expression @Manju_Reddy_Kanughula Read the data and save it in the datatable dt.AsEnumerable().Where(Function(s) Not String.IsNullOrEmpty(s("Amount").ToString) or Not String.IsNullOrWhiteSpace(s("Amount").ToString)).Sum(Function(a) CInt(a("Amount").ToString)).ToString Regards Sudharsan

---

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.

[system]

Daily Forum Report | 17 February 2023

Top 3 Topics with Most Views

Replace exact text in string made by @Ram_Gurav1 with 68 views.

Check if text in an element exists - do X if exists, do Y if it doesn't made by @mhoreen with 46 views.

I want to create a gettext from multiple pds in a folder made by @PriyaRPA with 40 views.

Top 3 Topics with Most Replies

How can I detect diferent types of objects that are located in the same place made by @goncalo.rocha with 9 replies.

How to get different time zone - current date and time made by @AJITH_SK with 9 replies.

Assign Column as type date from datatable (source excel) made by @laura.groeger with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 49 posts!

@postwick made 14 posts!

@Sudharsan_Ka made 11 posts!

Top 3 Most Liked Posts

This post made by @RPAForEveryone received 3 likes!

Read and write last row

Hi @Sabbir_Anwar You can achieve this in two steps: Get Total Rows in table → dt.Rows.Count dr = dt.Rows(RowCount - 1) dt is a DataTable object, dr is DataRow. The dr object can then be used to retrieve column values as needed. Please use the search feature on Forums to look up answers for simple questions such as this one. It’s always likely that someone has already had this problem and it’s resolved. This will save you a lot of time (and community members too ) https:…

This post made by @ddpadil received 2 likes!

UiPath Community MVP 2023 announcement!

[image]

This post made by @ppr received 2 likes!

Issue with Selectors maybe from the resolution

@FlorinOvi welcome to the forum can you check:

Top 3 Most Liked Solutions

This solution provided by @Shakti_Singh received 1 likes!

How update Project Settings UI Automation Classic

Hi Check this Package Version, How sap is coming [image] [image]

This solution provided by @Yoichi received 1 likes!

Check if text in an element exists - do X if exists, do Y if it doesn't

Hi, I think it might be better to use either of the following. Use GetText (or GetFullText, Get VisibleText), then check its contents. [image] Use ElementExists with aaname or innertext attibute like '*NET ONLY*' in the selector. [image] Regards,

This solution provided by @Anil_G received 1 likes!

Assign Column as type date from datatable (source excel)

@laura.groeger You need to convert them to date.Try as below var. Lieferdatum = cdate(CurrentRow("Lieferdatum").ToString) var. Umterminierungsdatum = Cdate(CurrentRow("Umterminierungsdatum").ToString) And change the datatupe of your liefrdatum and umte… to datetime Hope this helps Cheers

---

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.