Forum Engagement Daily Reports

[system]

Daily Forum Report | 25 August 2022

Top 3 Topics with Most Views

Hi I new here, so I need to iterate through mail and check their subject if the subject is "Invoice I need to proceed further or else I need to throw an error after loop is completed I already created workflow but its not working when email subject is dif made by @Simran2 with 66 views.

Shorten Regex Pattern made by @6027ae06be5a67a04d29acc18 with 42 views.

Send mail Activity made by @Sandhya_Gajare with 42 views.

Top 3 Topics with Most Replies

Hi I new here, so I need to iterate through mail and check their subject if the subject is "Invoice I need to proceed further or else I need to throw an error after loop is completed I already created workflow but its not working when email subject is dif made by @Simran2 with 30 replies.

How to get row index if Excel has duplicate row made by @PALKUMARI_PATEL with 18 replies.

Shorten Regex Pattern made by @6027ae06be5a67a04d29acc18 with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 28 posts!

@raja.arslankhan made 25 posts!

@ppr made 22 posts!

Top 3 Most Liked Posts

This post made by @postwick received 2 likes!

Cannot bring the target application to the front because the Windows session is locked

No, there is no setting to avoid this. It’s how RDP sessions work. Users shouldn’t be logging into your bot servers at all. It interferes with Orchestrator. But yes, if anyone logs in with one of your robot accounts, they MUST SIGN OUT. Closing the RDP window leaves the session running which is explained in the popup you get when you close the RDP window. [image]

This post made by @shun received 2 likes!

ジョブ実行の際、引数を複数渡すことはできますか？

引数を複数設定するということは、 以下のように、Studio上で2個以上の引数を設定した上で、APIのパラメータを設定します。 [画像1] 一方、akaさんが設定しているものは、 「ID=1000」、「ID=2000」のように同一の引数「ID」に対して、2つの値を設定しています。 UiPathのワークフローでは、同一名称の引数は作成できないので、上記設定は間違ったやり方となります。 「ID=1000」、「ID=2000」のように引数を設定したいのであれば、1000の時と2000の時、それぞれ別々のジョブを開始する必要があります。

This post made by @marian.platonov received 2 likes!

Download attachment file of POST API response from a custom API endpoint

Check the solution from this thread Saving file using HTTP request - #7 by Jun_Wei

Top 3 Most Liked Solutions

This solution provided by @postwick received 2 likes!

Cannot bring the target application to the front because the Windows session is locked

No, there is no setting to avoid this. It’s how RDP sessions work. Users shouldn’t be logging into your bot servers at all. It interferes with Orchestrator. But yes, if anyone logs in with one of your robot accounts, they MUST SIGN OUT. Closing the RDP window leaves the session running which is explained in the popup you get when you close the RDP window. [image]

This solution provided by @shun received 2 likes!

ジョブ実行の際、引数を複数渡すことはできますか？

引数を複数設定するということは、 以下のように、Studio上で2個以上の引数を設定した上で、APIのパラメータを設定します。 [画像1] 一方、akaさんが設定しているものは、 「ID=1000」、「ID=2000」のように同一の引数「ID」に対して、2つの値を設定しています。 UiPathのワークフローでは、同一名称の引数は作成できないので、上記設定は間違ったやり方となります。 「ID=1000」、「ID=2000」のように引数を設定したいのであれば、1000の時と2000の時、それぞれ別々のジョブを開始する必要があります。

This solution provided by @ppr received 2 likes!

Shorten Regex Pattern

Can you check: [grafik] \bF(([aire]+[\s\S]*?)*?)s\b

---

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 | 26 August 2022

Top 3 Topics with Most Views

Problem using Application/Browser made by @Fabrizio_Ortotti with 48 views.

How to remove empty spaces from the numbers made by @Chippy_Kolot with 47 views.

What's the difference between cloud.uipath.com and uipath.cloud.com? made by @Surya_Narayana_Korivipadu with 43 views.

Top 3 Topics with Most Replies

Problem using Application/Browser made by @Fabrizio_Ortotti with 18 replies.

Not able to select the dropdown value while doing automation in uipath made by @Chauhan_Nagesh with 15 replies.

How to add the date and time in my end of day report file? made by @dylanTana with 12 replies.

Top 3 Users Who Posted The Most

@postwick made 29 posts!

@ppr made 22 posts!

@Yoichi made 21 posts!

Top 3 Most Liked Posts

This post made by @Nitya1 received 2 likes!

How To Get The Sheet Name From Excel – In UiPath

Excel is the most used application in the business process automation. To work with it, we might sometimes want to know the sheets available in it, let us see how to find all the sheet names available in a workbook. wb as WorkbookApplication wb.GetSheets Example Implementation using UiPath : Let us implement a workflow which takes a sample excel file and displays all the sheets available in it. Step 1: Drag “Excel Application Scope” activity into the designer panel and supply the foll…

This post made by @kumar.varun2 received 2 likes!

How to add the date and time in my end of day report file?

Hi @dylanTana This what you are doing [image] Instead concatenate the different Strings [image] Or use Path.Combine [image]

This post made by @raja.arslankhan received 2 likes!

How to add the date and time in my end of day report file?

@dylanTana get full folder path in veriable. then right Folderpath+“back slash symbol”+DateTime.Now.ToString(“yyyyMMddHHmmss”)+In_Config(“OrchestratorQueueName”).ToString string.format is used when we are trying to add string specific place and you are not mentioning that place

Top 3 Most Liked Solutions

This solution provided by @marian.platonov received 2 likes!

How to get top 10 queue items using Orchestrator Http request activity?

So in your case it will be https://cloud.uipath.com/odata/QueueItems?$top=10&$skip=0 (it will retrieve only the first 10 QueueItems)

This solution provided by @postwick received 1 likes!

How to add the date and time in my end of day report file?

That will result in… EODReport.xlsx\20220826 You don’t use Path.Combine to build the filename. You use it to combine the final filename with the rest of the path. So you need an assign to set the filename: myfile = “EODReport” + Now.ToString(“MMddyyyy”) + “.xlsx” Then… Path.Combine(somePathVar,myfile) to get something like… C:\temp\EODReport08262022.xlsx The point to Path.Combine is to make sure the \ are added correctly. Consider you have the following variables: myPath = “C:\temp” …

This solution provided by @THIRU_NANI received 1 likes!

How to click arrow in sap, can any one help me

Hey! Have you tried SAP expand tree activity? Reference: Regards, NaNi

---

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 | 27 August 2022

Top 3 Topics with Most Views

How to continue when there is exception in sequecne made by @T_Y_Raju with 37 views.

Send Hotkey Not Actioning made by @Kalaisri_K with 32 views.

Handling API response when object may or may not be available in response made by @Teekay with 29 views.

Top 3 Topics with Most Replies

How to iterate pdf file one after another file made by @NS7799 with 17 replies.

Received date for Outlook message made by @Topias_Stromberg1 with 17 replies.

Multiple Assign Error made by @Sukanya_Dutta with 8 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 21 posts!

@Gokul001 made 8 posts!

@marian.platonov made 8 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Handling API response when object may or may not be available in response

a null check can be done as shown below: [grafik] for a more defensive handling the existence of a JSON Property we can do: [grafik] we use this often for techniques when setting up generic extraction flows and and calculate existing properties against a list of interested properties

This post made by @Omkar_Sonawane received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello Everyone! I am Omkar from India, I work in a mobile gaming company as a Webmaster and my work is mostly in Firebase, AWS S3, FTP, and a little bit of Javascript. I got introduced to UiPath recently and wish to get certified as a Developer and explore the limits of Automation. Currently, I am preparing for certification and I want to connect with the UiPath community to a greater extent. Cheers!

This post made by @Gines_Cirera_Dona received 1 likes!

Uipath and dynamic paths

This worked, thank you so much.

Top 3 Most Liked Solutions

This solution provided by @Nishant_Banka1 received 1 likes!

Handling API response when object may or may not be available in response

Hi, I think it’s the ToString method that is throwing the error. Since we are doing a ToString on an object that doesn’t exist Can you try removing the ToString, and then try? Thanks, Nishant

---

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 | 28 August 2022

Top 3 Topics with Most Views

Json to data-table made by @indrajit.shah with 40 views.

Read Text File: One or more errors occurred made by @Rawan.md with 30 views.

How do I change the Date Format From (2022-08-28) to 28 Aug 2022? made by @kishan.savaliya with 27 views.

Top 3 Topics with Most Replies

Json to data-table made by @indrajit.shah with 14 replies.

Read Text File: One or more errors occurred made by @Rawan.md with 6 replies.

CSVをExcelに貼り付ける際、先頭行を除く方法と文字化け解決法 made by @Chitose_Takematsu with 5 replies.

Top 3 Users Who Posted The Most

@indrajit.shah made 8 posts!

@raja.arslankhan made 7 posts!

@kmaddikatla made 7 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

How do I change the Date Format From (2022-08-28) to 28 Aug 2022?

Hi, Hope the following helps you. [image] CDate(yourString).ToString("d MMM yyyy") Regards,

This post made by @StefanSchnell received 1 likes!

Migrating Activities to .NET 6

@Andreea_Stroe Hello Andreea, thank you very much for this very interesting and important news. Best regards Stefan

This post made by @kishan.savaliya received 1 likes!

How do I change the Date Format From (2022-08-28) to 28 Aug 2022?

Thank You Very Much @Yoichi For the Solution Its working Properly

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How do I change the Date Format From (2022-08-28) to 28 Aug 2022?

Hi, Hope the following helps you. [image] CDate(yourString).ToString("d MMM yyyy") Regards,

This solution provided by @Yoichi received 1 likes!

CSVをExcelに貼り付ける際、先頭行を除く方法と文字化け解決法

こんにちは 日本語のエンコーディングは基本的には、"shift_jisかUTF-8 かと思うので、これらを試してみてはと思います。 あと可能であれば現在組まれているワークフローのスクリーンショットを共有いただくと、良いかと思います。

---

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 | 29 August 2022

Top 3 Topics with Most Views

How to extract email id from a string without using regex made by @sagar.raval with 46 views.

LINQ - Multiple CONDITIONAL Unique Identifier Matching Two Data Tables made by @anthonyjr with 45 views.

Data Scraping - Value does not fall within the expected range made by @weelip with 40 views.

Top 3 Topics with Most Replies

How to extract email id from a string without using regex made by @sagar.raval with 16 replies.

Css-Selector pass in Uipath made by @Shyam_Pragash with 15 replies.

ファイルサイズを取得 made by @autopc01 with 13 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 30 posts!

@Yoichi made 12 posts!

@Gokul001 made 12 posts!

Top 3 Most Liked Posts

This post made by @Kashi_Vishwanath received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Greetings to All !!! hope you all are doing fine. I just joined this forum and see there are giants in RPA and I look forward in learning from your rich experience. I am the VP customer success & Business Acquisition from Collective Minds Digital Solutions from India. This is my first post in this forum. I am into RPA for last 3 months. I am a plastics technologist, heading manufacturing process for various organizations for last 24 years. I was with a leading MNC for 10 years. I am currently lo…

This post made by @Bogdan_Zavera received 2 likes!

I have a component and I can not to edit

Hello Siyang, we are looking into it and will get back to you with updates in a few hours. Thank you for reaching out

This post made by @Andreea_Stroe received 2 likes!

I have a component and I can not to edit

Hi @wusiyangjia, Your listing is now in status Needs Update, so you can edit it accordingly. Thank you, Andreea

Top 3 Most Liked Solutions

This solution provided by @Andreea_Stroe received 2 likes!

I have a component and I can not to edit

Hi @wusiyangjia, Your listing is now in status Needs Update, so you can edit it accordingly. Thank you, Andreea

This solution provided by @Gokul_Jayakumar received 1 likes!

How to extract email id from a string without using regex

Hello @sagar.raval , Try this method it may help for you Split(YourString," ") You ca use the split string and loop it using for each loop , you can split each string. Within loop , use if condition for isolate the string contains “@” “.” item.ToString.Contains("@") And item.ToString.Contains(".") KIndly refer this flow of XAML file. EmailString_Manipulation.xaml (9.3 KB) [image]

This solution provided by @Yoichi received 1 likes!

ファイル名から月を取得したいが、数字のファイルがあると取得できない

こんにちは \Dを使用しているから全角数字も対象に含まれるからです。このパターンを尊重するなら “1?\d(?=[^0-9])” だと通りますが、いずれにしても半角数字が含まれると正常に動作しないと思うので あまりよくないと思います。 そのため例えば System.Text.RegularExpressions.Regex.Match(System.IO.path.GetFileNameWithoutExtension(yourFilePath),"1?\d$").Value+"月" 等の方が良いかと思います。

---

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 | 30 August 2022

Top 3 Topics with Most Views

Combine Duplicate row value into Single row made by @agathiyanv with 52 views.

Scheduling calendar and License utilization made by @Natalino_Mantoan with 47 views.

Select Current Month from a Drop Down Menu made by @Farah_halawani with 45 views.

Top 3 Topics with Most Replies

Select Current Month from a Drop Down Menu made by @Farah_halawani with 24 replies.

For each row - read only last 5 numeric characters made by @andrew.haworth with 19 replies.

Maintenance mode via Swagger authentication made by @Snowman with 18 replies.

Top 3 Users Who Posted The Most

@marian.platonov made 31 posts!

@ppr made 30 posts!

@Sanjit_Pal made 20 posts!

Top 3 Most Liked Posts

This post made by @Natalino_Mantoan received 6 likes!

Scheduling calendar and License utilization

Hello everyone, I would like to ask if there is a way to view all the schedules present on the tenant and the status of license occupations via monitoring, insights, or any other way. The main goal is to understand if a machine is overloaded or, on the other hand, is often free so as to better manage schedules or consider buying new licenses. I have already tried to look in Insights if information on schedules could be retrieved, but it does not seem to be possible. Also, in the Monitoring se…

This post made by @Sanjit_Pal received 4 likes!

Import Datatable From Word Document To Excel File

UiPath provides us the flexibility to export the data from the word document to excel file, here one more exciting way to achieve the result. You can create a .bat file using the below code Sub ImportWordTable(wdFileName) Dim wdDoc As Object Dim tableNo As Integer 'table number in Word Dim iRow As Long 'row index in Excel Dim iCol As Integer 'column index in Excel Dim resultRow As Long 'from which row result should be written Dim tableStart As Integer Dim tableTot As Integer On Error Resume…

This post made by @ppr received 3 likes!

[HowTo] LINQ - First Start # Min | Max | Sum | Average Operator

This HowTo gives an introductory overview of the aggregation Operators: Min, Max, Sum, Average Introduction The aggregation operators are used to retrieve from a collection a particular result by setting the contained items into a relationship. Overview I – Input P – Processing O – Output {2,12,-8,6,14,5} get the lowest value -8 {2,12,-8,6,14,5} get the highest value 14 {2,12,-8,6,14,5} sum up all values 31 {2,12,-8,6,14,5} get the average of all values 5.17 Constraints P…

Top 3 Most Liked Solutions

This solution provided by @ankit.saraf received 2 likes!

Data Service: Query Entity Records Best Practice

It really depends on what you are trying to achieve with your process and how you are using the entities. The typical suggestion will be to use Query activity in the process to fetch the latest data from entities when you run a process. Once the data is fetched, it remains in your process memory as variables until either the process ends or the variable is removed from scope. That’s why, any changes you do to the entity data has to be written back to Data Service using the Update, Create or Del…

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

How to run in incognito

Hi @Trisen_Jr Welcome to community There is an option in open browser activity As properties called private Kindly check that field

This solution provided by @Yoichi received 1 likes!

How to extract data of particular row using Linq?

Hi, Perhaps you should use uppercase like Contains(“TOTAL ADD ON”) becuase of ToUpper. 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 | 31 August 2022

Top 3 Topics with Most Views

Extr number from string made by @Yashas_H with 37 views.

How to extract specific data from a JSON payload using SelectToken? made by @KMota with 32 views.

Remove duplicate rows from two datatables based on a specific columns made by @hckwon5 with 29 views.

Top 3 Topics with Most Replies

Separate text and number made by @Sabbir_Anwar with 17 replies.

Argument value not provided made by @Halil_Gezer with 16 replies.

How to download all attachments apart from pdf made by @gokul1904 with 15 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 26 posts!

@postwick made 26 posts!

@ppr made 22 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

How to check string present in dictionay or not

we do have the ContainsKey(yourKey) / ContainsValue(YourValue) we can use LINQ we can check the keys / the values lists to get a new dictionary similiar to your output we could use LINQ Assign Activity: dictUpdated = (From x in YourOriginDict Let chk = x.Key.toUpper.Contains(YourCheckStringVar.toUpper) Let v = If(chk, "found", "Notfound") Select t = Tuple.Create(x.Key, v)).ToDictionary(Function (t) t.Item1,Function (t) t.Item2) Or (From x in YourOriginDict.Keys Let chk = x.toUpper.Contai…

This post made by @Nitya1 received 1 likes!

How to Convert an Array to List in UiPath

Converting one datatype to another is one of the most common things we do in programming. Let’s see how to convert an Array to List in UiPath. our_List = our_Array.ToList Example: Implementation using UiPath : Let us implement a workflow which converts an “Array” to “List” Step 1: Create variables as shown below [image] Step 2: Drag “Assign” activity into the design panel and initialize the Array of string type. [image] Step 3: Drag another “Assign” activity into the design panel …

This post made by @Lori received 1 likes!

I use LINQ expression should filter one column value which >-1 and <1, However, I cannot get the right data, who can help?

@kumar.varun2 Thanks for you help, seem that I made a mistake, I got the value which I want, thanks you very much!

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

How to check string present in dictionay or not

we do have the ContainsKey(yourKey) / ContainsValue(YourValue) we can use LINQ we can check the keys / the values lists to get a new dictionary similiar to your output we could use LINQ Assign Activity: dictUpdated = (From x in YourOriginDict Let chk = x.Key.toUpper.Contains(YourCheckStringVar.toUpper) Let v = If(chk, "found", "Notfound") Select t = Tuple.Create(x.Key, v)).ToDictionary(Function (t) t.Item1,Function (t) t.Item2) Or (From x in YourOriginDict.Keys Let chk = x.toUpper.Contai…

This solution provided by @kumar.varun2 received 1 likes!

I use LINQ expression should filter one column value which >-1 and <1, However, I cannot get the right data, who can help?

Hi @Lori Could you give this a try Filter datatable where “AP Invoice Number” = Blank and “AR Invoice Number” not Blank and “Issue Type”=“Price Diff” or Blank and “Diff” column value "-1 < and < 1 ", ( From d In CSVDT.AsEnumerable _ Let APInvoiceNum = d("AP Invoice Number").ToString.Trim().ToUpper() Let ex = d("Issue Type").ToString.Trim().ToUpper() Let diff = Convert.ToDouble(d("Diff").ToString) _ Let c1 = String.IsNullOrEmpty(APInvoiceNum) Let c2 = Not d("AR Invoice Number")…

This solution provided by @Gokul001 received 1 likes!

What is execution trail and what is its use?

Hi @Rohit_More Check the below image execution trail is used to see which are in-progress, Executed, Faulted in the workflow. You must run the process in Debug Mode [image] Check out the docs for more info Debugging Actions. Regards Gokul

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

@Yoichi received 54 likes for their solutions!

@ppr received 45 likes for their solutions!

@Gokul001 received 33 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 September 2022

Top 3 Topics with Most Views

Revamped Alerts in Orchestrator made by @sebastian.ungureanu with 57 views.

How to get the 1st and last days of the Last week made by @anit.michael1 with 42 views.

Click is failing despite 100% match made by @mayowa.mike-adeogun with 39 views.

Top 3 Topics with Most Replies

Not able to understand which activity to be used made by @Sam_H with 19 replies.

When using email account as a variable in the Outlook app, it can't find the folder made by @Jayant_Kumar_Singh with 13 replies.

How to get the 1st and last days of the Last week made by @anit.michael1 with 9 replies.

Top 3 Users Who Posted The Most

@marian.platonov made 26 posts!

@postwick made 19 posts!

@Gokul001 made 19 posts!

Top 3 Most Liked Posts

This post made by @sebastian.ungureanu received 2 likes!

Revamped Alerts in Orchestrator

Hello, UiPath community! We’re excited to announce that we’ve re-worked some of the functionality in Orchestrator alerts to bring you more value, faster. Let’s look at what’s new and improved: More actionable alerts - we’re adding deep-linking to alert notifications, so you can get more details on a specific alert directly from the email alerts in your inbox or from in-Orchestrator alerts with just one click New email template – we’ve updated our Alerts email design for you to be able to …

This post made by @Gangadhar_Athili received 2 likes!

Regex string extraction

[image]

This post made by @Gokul001 received 2 likes!

Regex string extraction

Hi @Lydia_Gathoni How about this expression? System.Text.RegularExpressions.Regex.Match(YourString,"\S\S\d{4}").Tostring Or System.Text.RegularExpressions.Regex.Match(YourString,"\S{2}\d{4}").Tostring [image] Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Neil_Ryan received 1 likes!

Change postpone date of multiple queue items

Hi @Sparrow If you use the Orchestrator REST API’s to achieve this. Get All the Queue Items https://ORCHESTRATOR_HOSTNAME/swagger/index.html#/QueueItems/QueueItems_Get 2)Look through each Queue Item returned in the results from Step1 For each queue item use the following Rest API call https://ORCHESTRATOR_HOSTNAME/swagger/index.html#/QueueItems/QueueItems_PutById Set the DeferDate field to the new value The below ticket provides some more context around the approach.

This solution provided by @Gokul001 received 1 likes!

How to assign a boolean value for a string if it contains specific texts

Hi @Ben_siu Use If condition "YourString".Contains("Yes") [image] If the String is Yes it will Go to Then part If the String is No it will Go to Else part Regards Gokul

This solution provided by @Yoichi received 1 likes!

DateTime - Option strict on disallows implicit conversions from ‘object’ to ‘string’ uipath

Hi, Can you try as the following? DateTime.Parse(BirthDates(item.ToString())) OR Set String at TypeArgument in ForEach activity. 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 | 02 September 2022

Top 3 Topics with Most Views

Unable to fetch table data from web application made by @sagarjb with 41 views.

Dynamic file name of excel file made by @Agnes_Castro_Salvador with 40 views.

Remove row from a particular string from data Table made by @taruna.mehra with 34 views.

Top 3 Topics with Most Replies

Remove row from a particular string from data Table made by @taruna.mehra with 25 replies.

Read huge excel range into a data table made by @A_Learner with 22 replies.

Could not find the user-interface (UI) element for this action - Unattended robot made by @ankur.agarawal with 20 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 37 posts!

@Yoichi made 25 posts!

@raja.arslankhan made 23 posts!

Top 3 Most Liked Posts

This post made by @raja.arslankhan received 4 likes!

Monthly Forum rewards - August 2022

@loginerror Thank you so much an Congratulations Everyone. I will try to give community my best.

This post made by @Veera_Raj received 3 likes!

Monthly Forum rewards - August 2022

congratulations to everyone

This post made by @StefanSchnell received 3 likes!

Monthly Forum rewards - August 2022

Congratulations to all the winners and thank you for your effort.

Top 3 Most Liked Solutions

This solution provided by @grkiran2 received 1 likes!

Need Help to understand the Code

The state is in this format: If(<condition> , <Value when condition is True> , <Value when condition is False>) In you case IF evaluates the condition CBool(in_Config("SomeImput1").ToString). if True, returns value for in_Config(“Input2”).Tostring if False, returns value for in_config(in_config(“Input3”).Tostring+“_”+in_config(“input4”).tostring+“_AppName”).ToString

This solution provided by @Gokul001 received 1 likes!

Extracting substring from a string

Hi @gokul1904 How about this expression? System.Text.RegularExpressions.Regex.Match(YourString,"(WEF\S\d+)(?=\s)|(WEF\S\d+)(?=[a-z])").Tostring [image] Regards Gokul

This solution provided by @Yoichi received 1 likes!

Issue on ascending order on table

HI, Thanks, the following will work. Can you try this? dt.AsEnumerable.Where(Function(r) Double.Parse(r("Discount").ToString)>10).OrderBy(Function(r) Double.Parse(r("Discount").ToString)).CopyToDataTable() 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 September 2022

Top 3 Topics with Most Views

How can I get the UiPath.Cryptography.Activities package in UiPath Studio? made by @Jcircuit13 with 41 views.

Get sheet name which is in any digit made by @sayali_rokade with 30 views.

Idx made by @447_J_U_S_SANDEEP with 28 views.

Top 3 Topics with Most Replies

Have taken 2 workflows and trying to invoke the same in main workflow but not showing the arguments of the other workflows in main(invoke activity),but selected the right workflow made by @Sai_Kumar_111 with 18 replies.

Why I always get the last row data when using "For Each" with web scaping? made by @Cheatken with 17 replies.

How to compare Datatables with values made by @smritijoshi with 14 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 29 posts!

@marian.platonov made 15 posts!

@Sai_Kumar_111 made 13 posts!

Top 3 Most Liked Posts

This post made by @marian.platonov received 1 likes!

Monthly Forum rewards - August 2022

Congratulations to all the winners!!!

This post made by @Yoichi received 1 likes!

Can you please let me know why i am repeatedly getting this error,but i have passed the arguments right and data table is also good.Thanks for any help

Hi, For now, can you check if variable DT is null in Locals panel when exception occurs? Regards,

This post made by @sandeep13 received 1 likes!

Can you please let me know why i am repeatedly getting this error,but i have passed the arguments right and data table is also good.Thanks for any help

@Sai_Kumar_Pothuganti could you please check DT is initialise or not.? This type of error occurred when we access the variable without Initialisation. Thanks

Top 3 Most Liked Solutions

This solution provided by @sandeep13 received 1 likes!

Can you please let me know why i am repeatedly getting this error,but i have passed the arguments right and data table is also good.Thanks for any help

@Sai_Kumar_Pothuganti could you please check DT is initialise or not.? This type of error occurred when we access the variable without Initialisation. Thanks

This solution provided by @lakshman received 1 likes!

How to Use UIBrowser with Use Application/browser activity

@Sidney_Vogel Use Application/Browser activity will give output of type UiElement whether it is application or browser. Create one variable of type UiElement and set to Output Element field. Later if you want to use it then pass above output UiElement variable to Input Element of Use Application/Browser activity.

This solution provided by @raja.arslankhan received 1 likes!

Have taken 2 workflows and trying to invoke the same in main workflow but not showing the arguments of the other workflows in main(invoke activity),but selected the right workflow

@Sai_Kumar_111 ok great but I think we should not wait for tomorrow. Before running all the files should be close which you are using in process. Two process can’t open a same file at a time So please close the file and then run the process

---

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 September 2022

Top 3 Topics with Most Views

How to Change Color of Specific Cells Dynamically made by @Ken_Ward with 36 views.

Data Table String removal made by @taruna.mehra with 33 views.

How to add serial numbers in particular column made by @mohamedalthaf with 32 views.

Top 3 Topics with Most Replies

Data Table String removal made by @taruna.mehra with 11 replies.

How to add serial numbers in particular column made by @mohamedalthaf with 7 replies.

To extract substring with Regex made by @gokul1904 with 6 replies.

Top 3 Users Who Posted The Most

@gokul1904 made 9 posts!

@sandeep13 made 8 posts!

@Cheatken made 8 posts!

Top 3 Most Liked Posts

This post made by @arivu96 received 1 likes!

Monthly Forum rewards - August 2022

Congratulations to all the winners🏆

This post made by @Sairam_RPA received 1 likes!

Get SAP Folder, Sub Folder Information and Use that for Automation

Hi Good afternoon, I am working with an SAP application. In this application I need to get all the folders, sub folders information and all files information. I have developed a bot that scrapes all the data from the SAP application. It uses hot keys to click down and does a CTRL+C to get the file name’s and sends a right key to open the folders. My question is I am unable to indentify which one is a folder which one is a file from the data I get. Is there a way UiPath Can Identify this infor…

This post made by @FAIZANKHAN_PATHAN received 1 likes!

Automation Awareness - The Automation Journey - We want to hear your thoughts!

I was impressed with the banking example where he has to copy every value and paste in different place,it was he best example to explain rpa.

Top 3 Most Liked Solutions

This solution provided by @Areej_fatima received 1 likes!

For each와 selector 변수 활용 질문

Hi You can use wild cards in your selector for make selectors dynamic Thanks

This solution provided by @Nishant_Banka1 received 1 likes!

How to add serial numbers in particular column

Hi, Initialize an int32 variable counter with value 1, then loop through your datatable and for each row, set the value with column name ‘#’ to the counter. Increment the counter on each loop. [image] Finally write the datatable back to the Excel Thanks, Nishant

This solution provided by @ppr received 1 likes!

To extract substring with Regex

[grafik] (?<=\().*?(?=\))

---

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 September 2022

Top 3 Topics with Most Views

Schedule a process to run continuously 24/7 forever made by @NotFranmax with 47 views.

Find match for rows in excel made by @gokul1904 with 45 views.

How to extract the specified data from the text file? made by @jamunatj with 44 views.

Top 3 Topics with Most Replies

Find match for rows in excel made by @gokul1904 with 17 replies.

Schedule a process to run continuously 24/7 forever made by @NotFranmax with 14 replies.

How to extract the specified data from the text file? made by @jamunatj with 14 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 26 posts!

@Yoichi made 21 posts!

@Sanjit_Pal made 20 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 3 likes!

Basic concept of Macros

Hello Everyone, Hope you are doing good I would like to present this post who are looking for the expressions related to Macro How to Run the Macro Here are the steps to run the macros Go to the Developer tab Click on Macros In the Macro dialog box, select the macro you want to run. Click on Run button. [image] [image] Unhide All Worksheets Except the Active Sheet User needs to unhide all the workbook at one go, try to execute macros. Sub UnhideAllWoksheets() Dim ws As Worksheet For E…

This post made by @ppr received 3 likes!

Schedule a process to run continuously 24/7 forever

vs. [grafik]

This post made by @Sanjit_Pal received 2 likes!

How Do I Remove the Spcae From the Datatable Cloumn header?

Hey @kishan.savaliya, You can do it using the below method. [image] Thanks, Sanjit

Top 3 Most Liked Solutions

This solution provided by @Gangadhar_Athili received 1 likes!

How Do I Remove the Spcae From the Datatable Cloumn header?

Read Sheet Without Headers (DT) DT.Asenumerable.First().itemarray.Select(function(v) v.Trim).Toarray Now Take For Each inside that Assign DT.Columns(idx).ColumnName=item put idx variable in For each output at the end write the data into excel without add headers.

This solution provided by @Yoichi received 1 likes!

Copy Paste Range with variable

Hi, How about the following? range1+":"+range2 Regards,

This solution provided by @ppr received 1 likes!

Find match for rows in excel

have a check at: [grafik] (From d In dtData.AsEnumerable Let sc = strCUR.Trim.Substring(0,2).toUpper Let sa = strACC.Trim.Substring(strACC.Trim.Length - 4).toUpper Let rm = d("Remit_ID").toString.Trim.toUpper Where rm.StartsWith(sc) Or rm.EndsWith(sa) Let cm2 = Convert.ToInt32(rm.StartsWith(sc)).toString Let cm1 = Convert.ToInt32( rm.EndsWith(sa)).toString Let msk = CInt(cm1 & cm2) Where msk > 0 Order By msk Descending Select v = d("Supplier_ID").toString).DefaultIfEmpty("No record found").Fi…

---

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 September 2022

Top 3 Topics with Most Views

Add header row to top of existing data datatable made by @Jcircuit13 with 46 views.

Advanced RPA Certification Question made by @sainandini.mannava with 45 views.

Cannot publish library with flowchart activity used made by @kaydine.santuyo with 43 views.

Top 3 Topics with Most Replies

Merge multiple rows in one made by @ravindar.singh with 17 replies.

Assign - the source contains no data row - problem with extracting data from empty datatable made by @Olivera_Kalinic with 17 replies.

How to add key & value to the dictionary from the text file? made by @jamunatj with 16 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 38 posts!

@Sanjit_Pal made 21 posts!

@Shubham_Dutta made 21 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

How to add key & value to the dictionary from the text file?

@jamunatj [grafik] Feel free to decompose the oneliner to part steps File.ReadAllLines(strFilePath) .Skip(1) .Where(Function (x) Not String.IsNullorEmpty(x.Trim)) .Select(Function (x) Regex.Split(x.Trim,"\s{2,}")) .toDictionary(Function (x) x.First(),Function (x) x.Last())

This post made by @qbrandon received 2 likes!

UiPathのアクティビティではどのようなVB.NET Codeが実行されるか確認できないでしょうか？

恐れ入りますがUiPathのオフィシャルなActivityのソースコードは基本非公開です。 マーケットプレースのパッケージは物によってgithubで公開されているコードがたまにあります。 ちなみに、ほとんどのアクティビティがC#で実装されています。

This post made by @Yoichi received 2 likes!

Regex Help Is not Match

Hi, How about using Regex.Replace as the following? System.Text.RegularExpressions.Regex.Replace(yourString,"(?<=\r\n)(.+?)(?= \d{4,5} (?:[\w]+: |Documents))(?:[^a-zA-Z]+)([^\s]+)\s(.+)(?= [A-Z0-9]+ /) (.+)(?=/ \d{2}/\d{2}/\d{4})(?:.*)(?<=\d{2}:\d{2}:\d{2}\s)([\d]+)","") Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Regex Help Is not Match

Hi, How about using Regex.Replace as the following? System.Text.RegularExpressions.Regex.Replace(yourString,"(?<=\r\n)(.+?)(?= \d{4,5} (?:[\w]+: |Documents))(?:[^a-zA-Z]+)([^\s]+)\s(.+)(?= [A-Z0-9]+ /) (.+)(?=/ \d{2}/\d{2}/\d{4})(?:.*)(?<=\d{2}:\d{2}:\d{2}\s)([\d]+)","") Regards,

This solution provided by @ppr received 2 likes!

Regex to filter on first occurrence of 3 or 4 digits in a sting

ok bold did mislead us [grafik]

This solution provided by @Gokul001 received 2 likes!

Merge multiple rows in one

HI @ravindar.singh How about this expression? (From d In BuildDT.AsEnumerable Group d By k=d("Booking No").toString.Trim Into grp = Group Let nj = String.Join(" ",grp.Select(Function (n) n("Leading passenger 1").toString.Trim)) Let ra = New Object(){k,grp.First()(1),grp.First()(2),nj,grp.First()(4)} Select r = DtOutput.Rows.Add(ra)).CopyToDataTable 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 | 07 September 2022

Top 3 Topics with Most Views

Python Activity : Invoke Python Method made by @Sukanya_Dutta with 55 views.

Is there a way to get all the variable names and store it in String array? made by @_waysi with 49 views.

How to copy entire row in one excel and paste in to excel made by @Baby123 with 42 views.

Top 3 Topics with Most Replies

Python Activity : Invoke Python Method made by @Sukanya_Dutta with 22 replies.

REGEX look ahaed to another word made by @adrian_sullivan with 18 replies.

Is there a way to get all the variable names and store it in String array? made by @_waysi with 12 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 41 posts!

@Sanjit_Pal made 21 posts!

@Gokul_Jayakumar made 20 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 3 likes!

How To Generate an Pivot using Macros

Hello Everyone, Hope you are doing well I would like to present this post who are looking for the expressions related to Create an Pivot using VBA script Creating the Pivot using VBA Option Explicit Sub CreateNewSheet() ' ' CreateNewSheet Macro ' ' Dim wb As Workbook Dim ws As Worksheet Dim Name As String Dim SourceR As Range Dim TableName As String Set wb = ThisWorkbook Set SourceR = Range("A1").CurrentRegion TableName = "NewTable" Set ws = ActiveSheet With wb …

This post made by @marian.platonov received 3 likes!

Debug incomign API requests

If you don’t have a Network engineer internally that may help you, you may install Fiddler in the Orchestrator machine and in the machine that is performing the requests. How to Collect Fiddler logs? Download the version for your system Download Fiddler Web Debugging Tool for Free by Telerik Extract the files Double Click on Fiddler to open and install. Configure Fiddler to decrypt HTTPS traffic Within Fiddler, click Tools → Fiddler Options Select the HTTPS tab Check the checkbox to Decrypt …

This post made by @yuko.tanaka received 2 likes!

【UiPathアカデミーよりお知らせ】

平素よりUiPathアカデミーをご利用いただきありがとうございます。 この度「RPAスタータープログラム」が、v2021.10対応の新学習プランとして「RPAスターター」にリニューアルいたしました。 「RPAスターター」は、2つの新しいコース「RPAと自動化入門」と「StudioX による初めてのオートメーション開発」で構成されており、RPAやUiPathに関する疑問に対してお答えすると共に、UiPath StudioXを使用した初めてのオートメーション開発を行います。 現在「RPAスタータープログラム」をご受講中の方は、恐れ入りますが2022年9月14日までに修了いただきますようお願い申し上げます。 なお「RPAスタータープログラム」修了済みの方は、9月14日以降も修了証明書の発行*は可能です。 また、2022年7月19日より「RPAデベロッパー基礎プログラム」も、v2020.10対応の「RPAデベロッパー基礎」としてリニューアルいたしております。 旧プログラムを既に修了されている方は今後も修了証明書の発行*は可能ですが、ぜひ「RPAデベロッパー基礎」もご受講ください。 …

Top 3 Most Liked Solutions

This solution provided by @Sanjit_Pal received 1 likes!

My Final statement runs every time in my flow and i want this to be run if bots fails

Keep you final statement workflow in the catch block inside the exception object in this way it wont execute for each iteration, it will be executed for the iteration if the iteration will throw the error

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

How do I pass the column values to another column in Excel in the same sheet in this scenario?

[image] for columnFecha you need to specify the range e.g. I333 to i350 if you only specify I333 it will only copy the value of I333

This solution provided by @ppr received 1 likes!

How to check if a element/node exist in the xml to perform the next actions

One of a few options Xdoc.Root.Descendants(Xns + “Supplier_Invoice_Reference”).Count > 0

---

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 September 2022

Top 3 Topics with Most Views

Data table extraction made by @Prasanth_98 with 39 views.

How to Split Date from Text made by @kaveri_satpute with 36 views.

Change QueueItem Status made by @sacad with 35 views.

Top 3 Topics with Most Replies

Reading all the files inside for each files in folder activity made by @Vidhi_Patel with 23 replies.

Data table extraction made by @Prasanth_98 with 22 replies.

How do I check for adjacent characters and if they match, delete one? made by @Vlad_Svitelskyi with 15 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 31 posts!

@raja.arslankhan made 29 posts!

@muthuraman.g made 21 posts!

Top 3 Most Liked Posts

This post made by @Domo_Arigato received 2 likes!

Revamped Alerts in Orchestrator

Wish we could adjust time daily alert is sent. Living in UTC +10 the email arrives at 17:00 (17:03 to be exact) Information is too old to be useful when reading email following morning for events which happened >24 hours prior. The only documentation to change this indicates on-premises only.

This post made by @Bogdan_Doaga1 received 2 likes!

Revamped Alerts in Orchestrator

Hi, Eeva! Yes. These improvements will be included in Orchestrator 22.10 on-prem release

This post made by @muthuraman.g received 2 likes!

Error UIPath Opened In anoter studio

Hi @MUHAMED_HUSSAIN_BIN_HITHA , There is multiple reasons associated with this error. I have provided all the troubleshooting steps below. Which is worked for me. Try restarting UiPath Studio Try rebooting the workstation/ server/ computer Ensure no other User does not maintain any access to the files specific to the current project Temporarily disable the anti-virus and firewall and try publishing the project Open task manager – check for presence of any project specific Process/Task and clo…

Top 3 Most Liked Solutions

This solution provided by @muthuraman.g received 2 likes!

Error UIPath Opened In anoter studio

Hi @MUHAMED_HUSSAIN_BIN_HITHA , There is multiple reasons associated with this error. I have provided all the troubleshooting steps below. Which is worked for me. Try restarting UiPath Studio Try rebooting the workstation/ server/ computer Ensure no other User does not maintain any access to the files specific to the current project Temporarily disable the anti-virus and firewall and try publishing the project Open task manager – check for presence of any project specific Process/Task and clo…

This solution provided by @Gokul001 received 1 likes!

How remove duplicates character in string variable?

Hi @Vlad_Svitelskyi Welcome to UiPath community String.Join("",StringInput.Distinct) Check out the XAML file Remove DuplicateCharacter.xaml (4.8 KB) [image] Regards Gokul

This solution provided by @ppr received 1 likes!

Comparing Excel columns

A multi code handling could look like this [grafik]

---

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 September 2022

Top 3 Topics with Most Views

How can I concatenate the rows in excel made by @HeartCatcher with 45 views.

Deleting multi-column filtering results made by @nilesay with 35 views.

Date Compare Issue made by @Robotics with 35 views.

Top 3 Topics with Most Replies

Regex pattern to remove any html code from a data made by @Fahad_Sheji with 26 replies.

How can I concatenate the rows in excel made by @HeartCatcher with 24 replies.

Date Compare Issue made by @Robotics with 22 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 35 posts!

@Gokul001 made 30 posts!

@Gokul_Jayakumar made 26 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 3 likes!

How To use Arithmetic operator using LINQ

Hello Everyone I would like to present this post who are looking for the expressions related to Arithmetic operator Min | Max | Sum | Average Introduction Aggregate expressions are used to make calculations over a specific set of records. For example, to calculate the total Quantity of all records, or the total number of records in the dataset. Sum operator SUM function can be extremely useful to calculate the sum of the items in a list/Collection LINQ Expression (From d in BuildDt.AsEnum…

This post made by @muthuraman.g received 2 likes!

Error UIPath Opened In anoter studio

Hi @MUHAMED_HUSSAIN_BIN_HITHA Its not orchestrator or studio issues. No need to compare with other bots/process. Give a try to follow the above steps, it actually fixed my issues. Also as @Gokul001 suggested check your Project.json location. There will be a chance you have copied your projects in multiple locations.

This post made by @Zishan_Sk received 1 likes!

How to change date format?

thanks this is the shortest and prettiest way to define date and conversion

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Cannot split the word set between 2 word sets

Hi, The above expression works in my environment as the following. Can you check the following sample? [image] Sample20220909-3.zip (3.3 KB) Regards,

This solution provided by @Gokul001 received 1 likes!

Cannot count the outlook mails using the count although there are emails in outlook inbox

Have you logged into the Outlook App [image] I think you are using it in the Online Outlook, So switch to configure the Outlook App in you PC and try it 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 | 10 September 2022

Top 3 Topics with Most Views

Create time folder based on the mail receiving time and date made by @Venusha_Sree with 31 views.

How to send email with file name and file path? made by @Venusha_Sree with 29 views.

Dear Masters, Can u give Linq query to merge this three data tables.Tq made by @lakshmi_narayana_ch with 28 views.

Top 3 Topics with Most Replies

I need to filter one year and one month before date in excel sheet from current date. I tried so many ways, but it can,t work. If anyone knows how to do that, please share with me made by @lokeshkumar.k with 21 replies.

Why this error showing!option strict on disallows late binding error made by @Siddharth_Kumar1 with 13 replies.

Upload A file made by @Sheen_Ildephonse with 10 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 15 posts!

@Sanjit_Pal made 11 posts!

@lokeshkumar.k made 11 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 2 likes!

How to Use Node.js with JavaScript in Combination with UiPath

Node.js is a JavaScript runtime environment on Chrome V8 engine. JavaScript is a very common and used programming language from many programmers around the world. A variety of packages are offered for Node.js that provide different aspects of problem solving. The consideration of an integration scenario into an UiPath RPA workflow can only be profitable from these points of view. [NodeJS] It is possible to execute JavaScript code with Node.js or to use it in REPL (read-eval-print-loop) mode. …

This post made by @Sanjit_Pal received 2 likes!

Get specified columns from a data table

Assume, we have a requirement to get specified columns from a data table then we generally delete unnecessary columns to get the actual ones. Instead of this, you can use the below expression with simple assign activity avoiding deletion logic Variable of type data table outputDT = DT.DefaultView.ToTable(False,“Items”,“ID”) Replace DT with your input data table outputDt is output data table Replace Items,ID with your actual column names that you want to retrieve You can also add additional co…

This post made by @ushu received 1 likes!

How to send email with file name and file path?

Hi @Venusha_Sree - Have a look on the below workflow Example.zip (10.5 KB)

Top 3 Most Liked Solutions

This solution provided by @raja.arslankhan received 1 likes!

Upload A file

@Sheen_Ildephonse Please follow these steps. 1- use open browser OR Attach browser activity. 2- use click activity and select selecor of Attachment button. 3- Now file selection window popup will open and put full path of file. Use again click activity to click on “OK”

This solution provided by @Yoichi received 1 likes!

How to use LINQ to compare two DataTable values and return a boolean

Hi, How about the following? dt1.AsEnumerable.Any(Function(r) r("Shipment").ToString="G05468") Regards,

This solution provided by @Siddharth_Kumar1 received 1 likes!

Why this error showing!option strict on disallows late binding error

i gave the type object instead of string. now it resolved after changing into string and changing the code from line.Split(":“c,StringSplitOptions.RemoveEmptyEntries) to line.Split({”:"c},StringSplitOptions.RemoveEmptyEntries)…

---

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 September 2022

Top 3 Topics with Most Views

How to assign a empty value to a list of string made by @gokul1904 with 35 views.

How to extract a line value with reference of first line in Regex made by @jai_kumar2 with 32 views.

How to remove a special character from a string var made by @mohamedalthaf with 28 views.

Top 3 Topics with Most Replies

How to assign a empty value to a list of string made by @gokul1904 with 8 replies.

Drag & drop template containers across different pages made by @Irina_Butu with 5 replies.

Hot to set If Activity condition to go else if then is empty made by @jai_kumar2 with 5 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 10 posts!

@Sanjit_Pal made 6 posts!

@marian.platonov made 4 posts!

Top 3 Most Liked Posts

This post made by @SKSONI03 received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, I am Satish, ME Student of Manufacturing Systems and Automation and Robotics is a big part of both my academics and my intrests. What UiPath is offering to the industry and the end users is just phenomenal and I am just awe-struck to get to know its capabilities and its applications. I can’t wait enough to get to learn more of its tools and deploy them in to my projects and later into the organisaton i am placed in. UiPath is synonyous to Excellence and Optimisation. Thank you UiPath Team. …

This post made by @Babedi_Paai received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello World! My name is Babedi, and I am from South Africa. I am currently doing my final year in IT at the North West University. The reason why I have joined UiPath community forum is because I have RPA as a content in my module. Since well there are people with more experience from around the world in this community, I am hoping to learn more from them, since I am beginner.

This post made by @Sidney_Vogel received 1 likes!

How to use LINQ to compare two DataTable values and return a boolean

Yes, this worked perfectly as well, thank you so much @Yoichi

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 September 2022

Top 3 Topics with Most Views

Compare 2 excel sheets using uipath made by @alamelu.b with 46 views.

Displaying wrong Next Run Time made by @Thong_Mai_Tr_ng_Hoang with 45 views.

Handling Multiple Check App State/Element Exist Scenario made by @Liu_Nado with 39 views.

Top 3 Topics with Most Replies

Scroll to particular UI element made by @agathiyanv with 13 replies.

Unable to send email using Send SMTP mail Activity made by @Shahu_Rahul with 13 replies.

How to split my value from two types of string? made by @ozgecatak with 12 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 34 posts!

@Gokul001 made 31 posts!

@raja.arslankhan made 25 posts!

Top 3 Most Liked Posts

This post made by @Syed_Muhammad_Salman received 4 likes!

Enabling insights

Navigate to your respective Automation Cloud URL and log in with your UiPath account. From the left navigation pane, select the Admin option. Under the Tenants context menu, find the tenant you want to enable Insights for, and click the 3-dot menu. [1902|autoxauto][1902|autoxauto] From the menu, select the Edit Services option. Check the box next to Insights, and then click the Save button. A confirmation message is displayed. [426|autoxauto]

This post made by @Syed_Muhammad_Salman received 4 likes!

RowCount is not a member of System.Data.DataTable

Hi @Ramiz Open the workflow in a in notepad and add this line: System.Data.DataSetExtensions in the AssemblyReference list. Look at this for more clarification.

This post made by @Syed_Muhammad_Salman received 3 likes!

Buissness Roi Template greyed out

You need to configure Roi Dataset before. Look at the three dots at the top right corner. and then click configure roi dataset. Once you enter values in the dataset, you’re good to go.

Top 3 Most Liked Solutions

This solution provided by @Syed_Muhammad_Salman received 4 likes!

Enabling insights

Navigate to your respective Automation Cloud URL and log in with your UiPath account. From the left navigation pane, select the Admin option. Under the Tenants context menu, find the tenant you want to enable Insights for, and click the 3-dot menu. [1902|autoxauto][1902|autoxauto] From the menu, select the Edit Services option. Check the box next to Insights, and then click the Save button. A confirmation message is displayed. [426|autoxauto]

This solution provided by @Syed_Muhammad_Salman received 4 likes!

RowCount is not a member of System.Data.DataTable

Hi @Ramiz Open the workflow in a in notepad and add this line: System.Data.DataSetExtensions in the AssemblyReference list. Look at this for more clarification.

This solution provided by @Syed_Muhammad_Salman received 3 likes!

Buissness Roi Template greyed out

You need to configure Roi Dataset before. Look at the three dots at the top right corner. and then click configure roi dataset. Once you enter values in the dataset, you’re good to go.

---

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 September 2022

Top 3 Topics with Most Views

How to remove empty spaces in datatable made by @Chippy_Kolot with 57 views.

How to extract price value from this text made by @vinjam_likitha with 52 views.

For Each Datarow made by @nilesay with 44 views.

Top 3 Topics with Most Replies

Help with nested For Each Loop made by @diya_poovamma with 16 replies.

Fetch value from JsonArray made by @tharani.natarajan with 14 replies.

How to pass the body in PUT Method in HTTP activity made by @tharani.natarajan with 14 replies.

Top 3 Users Who Posted The Most

@hafiz.ahsan made 25 posts!

@ppr made 24 posts!

@tharani.natarajan made 18 posts!

Top 3 Most Liked Posts

This post made by @Andreea_Stroe received 3 likes!

Migrating Activities to .NET 6

Hi all, One update on this topic: as you know, the custom activities published on the Marketplace can be discovered and used from the dedicated Studio feed. Going forward, please note that in Studio 22.4 Windows target framework version, only the packages that are migrated to .Net 5 or higher will be displayed in the Marketplace feed. The packages that are not compatible with .Net 5 or higher will be present in Studio 22.4 Windows - Legacy version only. Please feel free to reach out in case y…

This post made by @Syed_Muhammad_Salman received 3 likes!

Difference between Form and Intelligent Form Extractor

Hi @RebeccaMike Form Extractor (FE) is capable of processing fixed forms at this moment, and so is Intelligent Form Extractor (IFE). The difference between the two is that the IFE allows you to mark certain fields as being handwritten, and it uses a handwriting OCR service to try to retrieve the handwritten content of those fields or cells, while FE can only retrieve the text that is found during digitization within the same area for a field. The second difference is that IFE allows you to ma…

This post made by @Areej_fatima received 2 likes!

Open Outlook in PiP

You might wanna use start process activity to start outlook in pip mode. Refer below link for more details:

Top 3 Most Liked Solutions

This solution provided by @Syed_Muhammad_Salman received 3 likes!

Difference between Form and Intelligent Form Extractor

Hi @RebeccaMike Form Extractor (FE) is capable of processing fixed forms at this moment, and so is Intelligent Form Extractor (IFE). The difference between the two is that the IFE allows you to mark certain fields as being handwritten, and it uses a handwriting OCR service to try to retrieve the handwritten content of those fields or cells, while FE can only retrieve the text that is found during digitization within the same area for a field. The second difference is that IFE allows you to ma…

This solution provided by @supermanPunch received 1 likes!

How to get value from Dictionary string string

Hi @l.sambinelli , Firstly, You could access the value of Set-Cookie : setCookieValue = yourDict("Set-Cookie").ToString Next, you could perform String /Regex Operations to get the value required : [image] Expression : System.Text.RegularExpressions.Regex.Match(setCookieValue,"(?<=MYSAPSSO2=).*?(?=;)").Value.ToString

This solution provided by @Gangadhar_Athili received 1 likes!

How to check if the string contains two or three characters

if my_first_str.split(" “c).count()=2 Then…excel elseif my_other_str.split(” "c).count()=3 Then…Mail

---

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.