Forum Engagement Daily Reports

[system]

Daily Forum Report | 11 March 2022

Top 3 Topics with Most Views

Measuring Bot Execution Time made by @anmita with 56 views.

Else condition pass to CATCH? made by @fairymemay with 55 views.

Moving collumns made by @Atharv_Madne with 52 views.

Top 3 Topics with Most Replies

Else condition pass to CATCH? made by @fairymemay with 18 replies.

Smtp errror made by @poojaskyrathore with 17 replies.

Moving collumns made by @Atharv_Madne with 15 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 35 posts!

@ashwin.ashok made 33 posts!

@nikhil.girish made 24 posts!

Top 3 Most Liked Posts

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

Post GET API Request

Hi @karina_mota try downgrading the package and see if issue still persist ? Thanks

This post made by @Yoichi received 2 likes!

Is it possible to create a code where it behaves like a scientific calculator?

Hi, Unfortunately, Vb or C# doesn’t have a function like eval(), we need to approach by other ways. ● DataTable.Compute method strExpression = "((10-5)*(2+2))*5" dt = New DataTable() Then dt.Compute(strExpression, "").ToString ● Inject JS script activity strExpression = "((10-5)*(2+2))*5" Inject JS Script activity Indicate an element in any browser. Input Parameter : strExpression ScriptCode "function(e,v) { return eval(v); }" ScriptOutput : strResult ●Use 3rd party library. Per…

This post made by @karina_mota received 1 likes!

Post GET API Request

Hi Thank you very much, I created a new project and re-installs activity in an older version. The error is gone. Now I will try the procedure that the @dokumentor suggested. very grateful [Capturar]

Top 3 Most Liked Solutions

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

Post GET API Request

Hi @karina_mota try downgrading the package and see if issue still persist ? Thanks

This solution provided by @Yoichi received 2 likes!

Is it possible to create a code where it behaves like a scientific calculator?

Hi, Unfortunately, Vb or C# doesn’t have a function like eval(), we need to approach by other ways. ● DataTable.Compute method strExpression = "((10-5)*(2+2))*5" dt = New DataTable() Then dt.Compute(strExpression, "").ToString ● Inject JS script activity strExpression = "((10-5)*(2+2))*5" Inject JS Script activity Indicate an element in any browser. Input Parameter : strExpression ScriptCode "function(e,v) { return eval(v); }" ScriptOutput : strResult ●Use 3rd party library. Per…

This solution provided by @suraj.setty received 1 likes!

Adding Values of column

Hi @mohamedalthaf Please have a look. [Uipath Sum of Column in Excel] Hope this helps to solve. Thanks.

---

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

Top 3 Topics with Most Views

How to count Special 3 character in one String made by @Sweety_Nagar with 73 views.

Convert System.Collections.Generic.List`1[System.SystemException] to string? made by @fairymemay with 56 views.

Regex help capturing total amount made by @MaxDS1 with 42 views.

Top 3 Topics with Most Replies

How to count Special 3 character in one String made by @Sweety_Nagar with 14 replies.

Convert System.Collections.Generic.List`1[System.SystemException] to string? made by @fairymemay with 13 replies.

Excel to Sap Business one made by @badal_patel with 10 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 34 posts!

@Gokul001 made 19 posts!

@fairymemay made 14 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 1 likes!

Regex help capturing total amount

HI @MaxDS1 If you need the whole text try this expression System.Text.RegularExpression.Regex.match("InputString","(I\salt\s)(\d.+)|(Saldo\s)(\d.+)|(Saldo\svor\sfavør\n)(\d.+)|(Ultimosaldo\sI\salt DKK\s)(\d.+)|(I\salt\sDKK\s)(\d.+)|(Beløb\sSkyldig\nkr\s)(\d.+)").Tosting.Trim [image] Regards Gokul

This post made by @Gokul001 received 1 likes!

Regex help capturing total amount

HI @MaxDS1 Try this Regex Expression System.Text.RegularExpression.Regex.match("InputString","(?<=I\salt\s)(\d.+)|(?<=Saldo\s)(\d.+)|(?<=Saldo\svor\sfavør\n)(\d.+)|(?<=Ultimosaldo\sI\salt DKK\s)(\d.+)|(?<=I\salt\sDKK\s)(\d.+)|(?<=Beløb\sSkyldig\nkr\s)(\d.+)").Tosting Regards Gokul

This post made by @jeevith received 1 likes!

Regex help capturing total amount

Hei @MaxDS1, In short the last one has kroner “Kr” one the newline before it starts with digits. So your pattern was not capturing the last one. Similar to your anchor search with pipes, you can use the | to look for two different types of patterns. Basically an OR logic. \s(saldo|i alt|ultimo|Beløb\sskyldig).{0,19}?\n?(kr [\d*.\d*]+.,\d*|[\d*.\d*]+.,\d*) [image] From Regex101 (I like using this website since it provides group matches and explanation of the pattern) [image] One more thi…

Top 3 Most Liked Solutions

This solution provided by @jeevith received 1 likes!

Regex help capturing total amount

Hei @MaxDS1, In short the last one has kroner “Kr” one the newline before it starts with digits. So your pattern was not capturing the last one. Similar to your anchor search with pipes, you can use the | to look for two different types of patterns. Basically an OR logic. \s(saldo|i alt|ultimo|Beløb\sskyldig).{0,19}?\n?(kr [\d*.\d*]+.,\d*|[\d*.\d*]+.,\d*) [image] From Regex101 (I like using this website since it provides group matches and explanation of the pattern) [image] One more thi…

This solution provided by @Palaniyappan received 1 likes!

Throw, Rethrow and Global Exception handler

Hi I appreciate your interest and passion to know the activity and it’s properties But by next Pls be clear with the query you want to get clarified On a note that these are EXCEPTION handling methods / activities used in UiPath There are five activities for handling exception Try catch Throw Rethrow Global exception handler Retry scope Rethrow is used when you want activities to occur before the exception is thrown. Throw activity is used when you want to throw error before the execut…

This solution provided by @ashwin.ashok received 1 likes!

For Loop append string

Hi @fairymemay , If you are using a For Each Loop, then here is a sample sequence to get you started: [image] [image] [image] I’m using a Substring Method to get rid of the comma that gets appended towards the start when we first start assigning the items to our string variable. CombineStrings.xaml (6.4 KB) Kind Regards, Ashwin A.K

---

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

Top 3 Topics with Most Views

Activities if made by @pl.rusinov with 47 views.

How to store multiple extracted PDF data through DU into excel made by @sai_krishna6 with 43 views.

Copy values from one excel to another made by @Sathish_Kumar_S with 41 views.

Top 3 Topics with Most Replies

Compare values from different excel made by @aqiff with 10 replies.

How to store multiple extracted PDF data through DU into excel made by @sai_krishna6 with 10 replies.

Copy values from one excel to another made by @Sathish_Kumar_S with 8 replies.

Top 3 Users Who Posted The Most

@ashwin.ashok made 16 posts!

@Palaniyappan made 15 posts!

@Nithinkrishna made 9 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Does Deserialize Contain XML Value?

we would recommend to do a first check on only local name. So we do not have handle unknown namespaces. [grafik] xdoc.Descendants().Any(Function (x) x.Name.LocalName.tolower.equals(strElementNameVar.toLower))

This post made by @anmita received 1 likes!

Execution Time in Insight Dashboard

If we have the transaction duration in Seconds for bot then how can I find the Bot Processing Time in hour format using formula in widget ? (Example in 1 hr how much time does it execute needs to be found)

This post made by @Sathish_Kumar_S received 1 likes!

Copy values from one excel to another

How to copy the Value of the each header in file 1 to file 2 ? File 1: [image] File 2: [image]

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Does Deserialize Contain XML Value?

we would recommend to do a first check on only local name. So we do not have handle unknown namespaces. [grafik] xdoc.Descendants().Any(Function (x) x.Name.LocalName.tolower.equals(strElementNameVar.toLower))

---

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

Top 3 Topics with Most Views

Data scrapping On multiple pages made by @vijay_allena with 74 views.

How to use Inject .NET Code? made by @donghai with 55 views.

Chrome Download made by @cury with 53 views.

Top 3 Topics with Most Replies

Could not extract proper text made by @Sirisha_Siri with 24 replies.

Data scrapping On multiple pages made by @vijay_allena with 23 replies.

What type of input method should we use for Keyboard shotcuts in modern design? made by @divya.paul with 18 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 54 posts!

@Palaniyappan made 41 posts!

@ashwin.ashok made 30 posts!

Top 3 Most Liked Posts

This post made by @ordo received 3 likes!

Error while executing SAP BAPI_REQUISITION_CHANGE From Uipath Activities

Hi @pmexilinx, the problem is the data structure of the BAPIs you are using. The BAPI_REQUISITION_GETDETAIL uses a table of type BAPIEBAN where BAPI_REQUISITION_CHANGE uses data type BAPIEBANV for the requisition items. First columns of BAPIEBAN [image] First columns of BAPIEBANV [image] Therefore just copying the data table will not work. You need to map the individual columns. You can either use transaction SE37 in the SAP GUI to check the structure of the parameters or use “Export P…

This post made by @Sudharsan_Ka received 2 likes!

Write excel data in word template

HI @Katrina Can You tell exactly how you created your workflow if possible share the screenshot of the flow? You can try this if you not done before Fill alphabets in the each column in the word document like A1,B1,C1 like this here is the document updated [image] Q2 Revenue.docx (35.7 KB) Now read range and store in a var Assign a counter =1 where counter is integer datatype. Loop through all the rows Kill Process “Word” and check the continue on error Delay for 2 secs Word Scope Use…

This post made by @Palaniyappan received 2 likes!

Extract only dates from a string using Matches activity

Hi Try with this expression (\d){1,2}\W(\d){1,2}\W(\d){1,4} [image] Hope this would help you resolve this Cheers @Harsha_Vemula

Top 3 Most Liked Solutions

This solution provided by @Sudharsan_Ka received 2 likes!

Write excel data in word template

HI @Katrina Can You tell exactly how you created your workflow if possible share the screenshot of the flow? You can try this if you not done before Fill alphabets in the each column in the word document like A1,B1,C1 like this here is the document updated [image] Q2 Revenue.docx (35.7 KB) Now read range and store in a var Assign a counter =1 where counter is integer datatype. Loop through all the rows Kill Process “Word” and check the continue on error Delay for 2 secs Word Scope Use…

This solution provided by @Palaniyappan received 2 likes!

Extract only dates from a string using Matches activity

Hi Try with this expression (\d){1,2}\W(\d){1,2}\W(\d){1,4} [image] Hope this would help you resolve this Cheers @Harsha_Vemula

This solution provided by @Nithinkrishna received 2 likes!

How to use Inject .NET Code?

Hey @donghai Kindly check the below once, Thanks #nK

---

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

Top 3 Topics with Most Views

Assign: The source contains no DataRows? made by @fairymemay with 45 views.

Rowcount after filtering made by @Sirisha_Siri with 43 views.

How to Fetch files from a folder based on the timestamp in filename? made by @Sirimalla_Karthik_Chandra with 42 views.

Top 3 Topics with Most Replies

How to Fetch files from a folder based on the timestamp in filename? made by @Sirimalla_Karthik_Chandra with 15 replies.

How to make filters with regex from array or from variables with conditionals? made by @Lynx with 13 replies.

Extract Firstname and Last name from the string after specific text format made by @benjamin.9052 with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 51 posts!

@Palaniyappan made 29 posts!

@ushu made 22 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Group String in Array and Json

after deserialization will look like this: [grafik] you will lose some values. We can achieve it by grouping the values, but need the detail input string. Maybe you can share it as txt file with us? Thanks

This post made by @supermanPunch received 2 likes!

Group String in Array and Json

Hi @Pablo_Sanchez , Try Replacing the Regular expression Pattern in Matches Activity with the below : \[(\d+)\](.*?)\/\/ Let us know if it doesn’t work

This post made by @ppr received 2 likes!

Group String in Array and Json

@Pablo_Sanchez With the help of Regex we can split the string [grafik] refering to the groups (we will trim later) [grafik] For regex learning have a look here: With following flow we can achieve the result: [grafik] [grafik] [grafik] The main idea is about: use regex to as mentioned above Regex.Matches(strText, strPattern, RegexOptions.IgnoreCase) group the matches and create JProperties, return all as an array (From m In myMatches.Cast(Of Match).toList Group m By k=m.Gro…

Top 3 Most Liked Solutions

This solution provided by @MirceaGolban received 2 likes!

Pre-defined ML Packages

Hi @Vicky_Fegan1 We know about the download issue and a fix is in the works. In the meantime, please use the attached schemas. schemas.zip (16.2 KB) Thank you

This solution provided by @Soudios received 1 likes!

I would like the bot to write to the last empty line in Excel

i tried an other solution that’s you count the number of row on the excel and you add +1

This solution provided by @supermanPunch received 1 likes!

Group String in Array and Json

Hi @Pablo_Sanchez , I was able to Get the Data into the Json as Needed. Although there might be a better method than this. First we have to identify the group of values in the input String. We could use the below Regex for that : \[(\d+)\](\w+) [image] We can then use the Matches Activity with the above pattern to get the resultant matched values. Here onwards, the data I have converted to a Datatable for ease in grouping the values. [image] Next, Group the data based on Number and iter…

---

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

Top 3 Topics with Most Views

How to count the number of blank items in a datatable? made by @Pruthvi.G with 62 views.

Split text ,? made by @fairymemay with 60 views.

Invoke workflow & Terminate workflow? made by @vivek_sinha with 56 views.

Top 3 Topics with Most Replies

Date question made by @cury with 29 replies.

https://forum.uipath.com/t/407522 made by @Futurised with 20 replies.

How to use right click or crtl +s in new browser tabs? made by @Rodrigo_Buch with 17 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 50 posts!

@ashwin.ashok made 38 posts!

@Palaniyappan made 34 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

How to handle periodically missing item from the dropdown menu when using Select Item activity?

Depending on the type of dropdown an element exists with dynamic selector to the option element from the dropdown select element could be an alternate to find children. A benefit of find children is that we do have more control when evaluating the found children. Keep in mind that find children will return uielements. So an evaluation on the value could look like this (check on innertext attribute) FindChildrenOutPut.Any(Function (x) x.Get("innertext").toString.Trim.Equals(YourSearchValue)) …

This post made by @Palaniyappan received 2 likes!

How to count the number of blank items in a datatable?

Hi If you want to delete the empty rows considering the whole DATATABLE then DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Or If you want to delete empty rows based on one column DatatableName = DataTableName.Select("Convert(column3, System.String)< >''").CopyToDataTable() or Datatablename = DataTableName.Select("column3< >''").CopyToDataTable() Cheers @Pruthvi.G

This post made by @komal.v.konduru received 2 likes!

Cannot select the pop up

@Palaniyappan Thanks, Sir. Those really helped me. @nikhil.girish @Gokul001 Thanks mates your valuable messages helped me a lot.

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

How to handle periodically missing item from the dropdown menu when using Select Item activity?

Depending on the type of dropdown an element exists with dynamic selector to the option element from the dropdown select element could be an alternate to find children. A benefit of find children is that we do have more control when evaluating the found children. Keep in mind that find children will return uielements. So an evaluation on the value could look like this (check on innertext attribute) FindChildrenOutPut.Any(Function (x) x.Get("innertext").toString.Trim.Equals(YourSearchValue)) …

This solution provided by @Palaniyappan received 1 likes!

Pass variable to array?

Mention like this if the variable name is Strinput Enumerable.Range(0,dt_configRate.RowCount).Select(Function(s) dt_configRate.Rows(s)(Convert.ToInt32(Strinput.ToString)).ToString).ToArray() Cheers @fairymemay

This solution provided by @ppr received 1 likes!

How to count the number of blank items in a datatable?

find starter help here: Check_dtHasBlanksInAnyCol.xaml (6.9 KB)

---

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

Top 3 Topics with Most Views

How to loop Through Multi made by @Ishan_Shelke1 with 45 views.

Which regex expression pattern to use if I want to select the number after 2 words? made by @mce with 44 views.

What is the difference between Boolean ? and Boolean made by @kkpatel with 41 views.

Top 3 Topics with Most Replies

Close outlook window made by @A_Learner with 14 replies.

Compare dates and identify date formats made by @kavya.s16 with 13 replies.

Questions about dynamic selectors made by @Uddynitjh with 11 replies.

Top 3 Users Who Posted The Most

@fernando_zuluaga made 27 posts!

@ushu made 24 posts!

@Gokul001 made 23 posts!

Top 3 Most Liked Posts

This post made by @diana.gray received 3 likes!

The Reboot Work Festival registration is live!

The Reboot Work Festival Participate in a festival of ideas and a celebration of automation! Register for this one day event on 2022-04-12T00:00:00Z (UTC) below:

This post made by @diana.gray received 2 likes!

Join Us - "Become an RPA Citizen Developer" - March 29th

Join Us on March 29 at 1:00 EDT, for this exclusive UiPath sponsored session with Glenn Hoorman, Executive Vice President of eAlliance. Glenn will cover the following topics: The new workforce, new work model and automation New tools and technologies to empower and engage the workforce A proven way for non-IT users to build their own automations using robotic process automation (RPA) Examples and demonstrations of RPA automations built by RPA Citizen Developers Register Here: See Become an R…

This post made by @Palaniyappan received 2 likes!

Excel Activity -- COM

Hi When you are using excel file for multiple times in short span of time within the process then there are two ways to handle this Use workbook activities instead of excel application scope and other excel activities Search as workbook and you can see same set of excel activities which actually doesn’t rely on excel application which is why you get this error on being used frequently along the process Or use multiple delay Activity and KILL PROCESS activity with ProcessName property as”Ex…

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 2 likes!

Excel Activity -- COM

Hi When you are using excel file for multiple times in short span of time within the process then there are two ways to handle this Use workbook activities instead of excel application scope and other excel activities Search as workbook and you can see same set of excel activities which actually doesn’t rely on excel application which is why you get this error on being used frequently along the process Or use multiple delay Activity and KILL PROCESS activity with ProcessName property as”Ex…

This solution provided by @Palaniyappan received 1 likes!

Can i train my own ML models in AI Center

Hi Have a view on this document for more guidance If you are looking for out of box models Check this up for model training guidance Cheers @jack.chan

This solution provided by @ashwin.ashok received 1 likes!

Need to convert scraped string into double, the number is in German format

Hi @manjesh_kumar , Here is a sequence I have developed based on a similar thread which discusses this problem: [image] Basically, you have to play around with the CultureInfo to get what you want. In this scenario, you are dealing with Portugal Numbers, so you have to implicitly specify what the formats are before referencing the Culture Info. For that, first create a variable of type System.Globalization.CultureInfo and initialize it using this → New CultureInfo("pt-PT") Next, use two …

---

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 | 18 March 2022

Top 3 Topics with Most Views

Datarow throwing error made by @kavya.s16 with 43 views.

エンコード"shift_jis"はサポートされていませんというエラーの解消方法について made by @UedaKorai with 42 views.

LINQ "not in" datatable made by @ajh with 41 views.

Top 3 Topics with Most Replies

Error Job stopped with an unexpected exit code made by @fairymemay with 25 replies.

Merge column 2 column to one column? made by @fairymemay with 19 replies.

How to click on each name of web page made by @siteltower with 17 replies.

Top 3 Users Who Posted The Most

@fernando_zuluaga made 31 posts!

@Gokul001 made 24 posts!

@fairymemay made 21 posts!

Top 3 Most Liked Posts

This post made by @ashwin.ashok received 2 likes!

Match and remove first linebreak from string

Seems like I was a little too late. Fantastic solutions by @Mr_JDavey though! I’ll just leave what I’ve found here in case you are interested: [image] System.Text.RegularExpressions.Regex.Replace(str_txtData,"(?<=^.*)\r?\n"," ") Kind Regards, Ashwin A.K

This post made by @Mr_JDavey received 2 likes!

Match and remove first linebreak from string

Hi there @Ninjabullen, I trust you are having a fantastic day! You should be able to achieve this via Strings.Replace: Strings.Replace(String, String, String, Int32, Int32, CompareMethod) Method (Microsoft.VisualBasic) | Microsoft Docs You can configure it as: YourString= Strings.Replace(YourString, VBCRLF, String.Empty, 1, 1) This will ultimately say, replace the first instance of VBCRLF in the String value. Example below: [image] Please let me know if you have any questions. Thanks …

This post made by @ppr received 2 likes!

How to write cell in a column exceeding the range A to Z

[grafik]

Top 3 Most Liked Solutions

This solution provided by @Mr_JDavey received 2 likes!

Match and remove first linebreak from string

Hi there @Ninjabullen, I trust you are having a fantastic day! You should be able to achieve this via Strings.Replace: Strings.Replace(String, String, String, Int32, Int32, CompareMethod) Method (Microsoft.VisualBasic) | Microsoft Docs You can configure it as: YourString= Strings.Replace(YourString, VBCRLF, String.Empty, 1, 1) This will ultimately say, replace the first instance of VBCRLF in the String value. Example below: [image] Please let me know if you have any questions. Thanks …

This solution provided by @ppr received 2 likes!

How to write cell in a column exceeding the range A to Z

[grafik]

This solution provided by @Steven_McKeering received 2 likes!

Which regex expression pattern to use if I want to select the number after 2 words?

Hi @mce Thank you for the Sample, the expected Output. But I think we need more information on the Pattern and any extra requirements you have. There are many talented people on the UiPath Community forums who can help with a pattern and have contributed a reply (@ppr and @Gokul001) but they need as much information as possible to make a strong pattern This information should be in the first post. 1 Minute invested in Original Post = 2+ Minutes saved later …

---

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 | 19 March 2022

Top 3 Topics with Most Views

How To Prnt Key values pairs from an dictionary made by @Sidney_Vogel with 48 views.

Read range error? made by @fairymemay with 40 views.

Combine several excel files and create pivot made by @vkrivenko with 39 views.

Top 3 Topics with Most Replies

How can I make the Instagram like button dynamic? made by @ridvanucok with 9 replies.

How To Prnt Key values pairs from an dictionary made by @Sidney_Vogel with 9 replies.

Read range error? made by @fairymemay with 9 replies.

Top 3 Users Who Posted The Most

@fernando_zuluaga made 14 posts!

@Shikhar_Tandon made 5 posts!

@fairymemay made 5 posts!

Top 3 Most Liked Posts

This post made by @Thanu_Matheesha1 received 1 likes!

Combine several excel files and create pivot

There are pre-build activities to combine excel files such as merge and to create a pivot table there is an activity called to create a pivot table. Use those pre-built activities to build your work flow

This post made by @vkrivenko received 1 likes!

Combine several excel files and create pivot

Hello, I have given several Excel files with reports. I’ve need to combine them all and create a pivot table. Please, help

This post made by @Lynx received 1 likes!

How to negate a regex?

itis works great!! thank very much @Steven_McKeering

Top 3 Most Liked Solutions

This solution provided by @ashwin.ashok received 1 likes!

How To Prnt Key values pairs from an dictionary

Hi @Sidney_Vogel , You could also try looping through the Keys and reference the Values using the dictionary itself For Each-> Key In in_exceldata.Keys So could you give this a try instead? [image] key+ " " + in_exceldata(key).ToString Also, I’ve changed the ArgumentType to String → [image] BlankProcess1_v1.zip (5.6 KB) Kind Regards, Ashwin A.K

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

Need to stop excel and chrome

Hi @Bhjanga_Prabhu I would recommend you to use kill process activity for both EXCEL and Chrome in start of your process Drag 2 kill process activities and in properties just mention process name as excel and Chrome Also make continue on error property as TRUE Thanks

This solution provided by @fernando_zuluaga received 1 likes!

Read range error?

Can you try converting or saving your excel to an CSV file then using the read csv file, it should work and in less time 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 | 20 March 2022

Top 3 Topics with Most Views

Problems with the dynamic selector made by @appleikmek with 41 views.

AI Center not opening in Community Version of Cloud Orchestrator made by @Sainath_S1 with 30 views.

Linq Filter DataTable and rename Columns made by @NHoe with 30 views.

Top 3 Topics with Most Replies

Problems with the dynamic selector made by @appleikmek with 8 replies.

Write cell beyond a to z range in Gsuite - Google Sheets? made by @Pruthvi.G with 7 replies.

How to extract and update account number if account code from code column foun made by @Mansi_Mhatre with 7 replies.

Top 3 Users Who Posted The Most

@fernando_zuluaga made 10 posts!

@ashwin.ashok made 6 posts!

@appleikmek made 5 posts!

Top 3 Most Liked Posts

This post made by @Steven_McKeering received 1 likes!

How to do conditional "or" in regex?

Hi @Lynx The pipe symbol “|” represents Or in Regex. Take a look at this Regex Pattern I have created for you. [image] I have used an achor on the text “OP. GRAVADA” and then inserted some brackets which will find either “S/” or “$” (note that “$” must be escaped “\$” like this to mean it literally instead of the end of a line). Just be aware that Regex101.com is great for learning and for ‘basic’ Regex Patterns but I strongly recommend using RegexStorm as it is 100% compatible with UiPath …

This post made by @Lynx received 1 likes!

How to do conditional "or" in regex?

Thanks a lot @Steven_McKeering

This post made by @ridvanucok received 1 likes!

How to Scan QR code in scanned pdf's

@adarsh_kotagiri I can’t share it because it’s a workflow I made for a company. However, if I am available during the day, I can create an external workflow and share it with you.

Top 3 Most Liked Solutions

This solution provided by @Steven_McKeering received 1 likes!

How to do conditional "or" in regex?

Hi @Lynx The pipe symbol “|” represents Or in Regex. Take a look at this Regex Pattern I have created for you. [image] I have used an achor on the text “OP. GRAVADA” and then inserted some brackets which will find either “S/” or “$” (note that “$” must be escaped “\$” like this to mean it literally instead of the end of a line). Just be aware that Regex101.com is great for learning and for ‘basic’ Regex Patterns but I strongly recommend using RegexStorm as it is 100% compatible with UiPath …

This solution provided by @nice-guy received 1 likes!

データスクレイピング時の型変換エラー

Yoichi さん、回答ありがとうございました。別スレットを立てて質問しますので、よろしくお願いします。

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

Filter column by condition?

Use my sequence for reference TestA.xaml (13.0 KB) read config and input to configDt and inputDt datatables [image] loop configDt, in each iteration, filter input Dt so that APAPDT >=APAPDT1 and <= APAPDT2 and output filtered table to filterdDt write filteredDt to FileName.xlsx [image] Result Report1.xlsx [image] Report2.xlsx [image]

---

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 | 21 March 2022

Top 3 Topics with Most Views

Copy specific column from one excel to another excel last row with specific column made by @mashy2 with 44 views.

How to get Particular file From directory made by @Anand_Designer with 44 views.

"SMTP Mail" fails on one computer and works on another made by @Aguirre with 44 views.

Top 3 Topics with Most Replies

How to get Particular file From directory made by @Anand_Designer with 17 replies.

Assign: An item with the same key has already been added made by @Sirisha_Siri with 16 replies.

Unable to Scrap the text using Matches Activity made by @Omkar_Deshmukh with 14 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 39 posts!

@ppr made 28 posts!

@ashwin.ashok made 23 posts!

Top 3 Most Liked Posts

This post made by @Debakanta_Mahanta received 2 likes!

Combo-Dropdown - Web Automation

Hi Swapnil, You can directly navigate to the url assigned to Ruling by MahaRERA href=“Login Page : Maharashtra Real Estate Regulatory Authority” [image] Thank you Debakanta

This post made by @ashwin.ashok received 2 likes!

Change picture/icon in Assistant

Hi @Timsener , It looks like its still a work in progress as detailed in this thread by UiPath → Kind Regards, Ashwin A.K

This post made by @ashwin.ashok received 2 likes!

Write cell beyond a to z range in Gsuite - Google Sheets?

Hi @Pruthvi.G , I understand that, but you wanted the range, correct? This snippet of code with allow you to compute the range, which you can them pass into the range like so → [image] UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(32) + int_index.ToString Kind Regards, Ashwin A.K

Top 3 Most Liked Solutions

This solution provided by @ashwin.ashok received 2 likes!

Change picture/icon in Assistant

Hi @Timsener , It looks like its still a work in progress as detailed in this thread by UiPath → Kind Regards, Ashwin A.K

This solution provided by @ppr received 2 likes!

Regex or String manipulation needed in order to insert a new line before a value

[grafik] (\d+ [\d\/]{10})

This solution provided by @Yoichi received 1 likes!

Remove Odd items from Array

Hi, Hope the following helps you. Remove even: arrVar = arrVar.Where(Function(x,i) i mod 2 =1).ToArray() Remove odd: arrVar = arrVar.Where(Function(x,i) i mod 2 =0).ToArray() 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 | 22 March 2022

Top 3 Topics with Most Views

How to train same custom DU model multiple times? made by @shrey.shah with 50 views.

How to copy sheet from Excel to another with a new sheet name made by @Archie with 50 views.

Problems with selectors made by @Pavel_Shlykevich with 46 views.

Top 3 Topics with Most Replies

How to copy sheet from Excel to another with a new sheet name made by @Archie with 21 replies.

How to add date in google forms throgh excel sheet? made by @guptasweb with 20 replies.

Get date value as a string made by @Pradumn_Chavan with 18 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 43 posts!

@fernando_zuluaga made 27 posts!

@ppr made 25 posts!

Top 3 Most Liked Posts

This post made by @Tuan_Nguyen1 received 2 likes!

Performance Desktop Triggers

Thanks, this is very helpful. I’ll take a look and discuss what we can do with the team.

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

Type into letters skipping

Hi @Rahul_54 We have a property called delay between keys So kindly use this property where set it 200 ms Note :Adjust as per your website behaviour Thanks

This post made by @ashwin.ashok received 2 likes!

Add amounts Found using Regex

Hi @spemur01 , There are two way to sum up the values, and I have detailed both in this workflow. Please have a look and let me know if it is as expected. Single Step → [image] matches.Cast(Of Match).Sum(Function(s) Convert.ToDouble(s.ToString.Replace(",",""))) Using For Each ->(TypeArgument: System.Text.RegularExpressions.Match) [image] doub_sumLoop= doub_sumLoop+Convert.ToDouble(match.ToString.Replace(",","")) MatchandSum.xaml (7.1 KB) Kind Regards, Ashwin A.K

Top 3 Most Liked Solutions

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

Type into letters skipping

Hi @Rahul_54 We have a property called delay between keys So kindly use this property where set it 200 ms Note :Adjust as per your website behaviour Thanks

This solution provided by @ashwin.ashok received 2 likes!

Add amounts Found using Regex

Hi @spemur01 , There are two way to sum up the values, and I have detailed both in this workflow. Please have a look and let me know if it is as expected. Single Step → [image] matches.Cast(Of Match).Sum(Function(s) Convert.ToDouble(s.ToString.Replace(",",""))) Using For Each ->(TypeArgument: System.Text.RegularExpressions.Match) [image] doub_sumLoop= doub_sumLoop+Convert.ToDouble(match.ToString.Replace(",","")) MatchandSum.xaml (7.1 KB) Kind Regards, Ashwin A.K

This solution provided by @supermanPunch received 1 likes!

Combo-Dropdown - Web Automation

Hi @Swapnil_Pawar , We should be able to Hover over the Dropdowns and Click the "Rulings By MahaRERA" option. Hover over Downloads, then Hover Over Maharashtra and Perform a Click on Rulings By MahaRERA Check the Below Workflow and Let us know if it doesn’t work : Dropdown_Click.xaml (14.3 KB)

---

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 | 23 March 2022

Top 3 Topics with Most Views

LINQ query for filtering made by @A_Learner with 57 views.

Needed Uipath Activities for Text document(Notepad) made by @arunprasanth_m with 51 views.

Using Refresh Browser in a Loop until Element appears made by @djkmod83 with 47 views.

Top 3 Topics with Most Replies

Send hotkey is not supporting, while trying to scroll down in excel made by @shuklarchana001 with 24 replies.

Not able to use Type Into and Set Text activity to fill out a web form made by @harmeet_kaur with 20 replies.

Specific Text Extraction from SAP Page made by @Tarif_Mohammad with 18 replies.

Top 3 Users Who Posted The Most

@ppr made 28 posts!

@fernando_zuluaga made 27 posts!

@postwick made 26 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 2 likes!

How to automate in a survey a number of answers for option 1 and another number of answers for option 2? (it also contains multiple answers to be checked)

Hi @robertcostache , Could You Explain what do you mean by these Percentages? Is it the Percentage of times the Option is Selected out of 900 times ?

This post made by @THIRU_NANI received 2 likes!

Assistant is not working

Hi! delete the json file and run the studio again! Regards, Nani

This post made by @suraj.setty received 2 likes!

How to train same custom DU model multiple times?

Hi @shrey.shah I would suggest to follow the document as per the best practice , I think my method may not work every time. You can select the Minor version as 0 as suggested in the article. Thanks .

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to make a replace in a string irrespective of string length?

Hi, Can you try the following expression? System.Text.RegularExpressions.Regex.Replace(yourString,"(?<=^.{6}).*(?=.{4}$)",Function(m) New String("X"c, m.Value.Length)) Regards,

This solution provided by @Jeroen_van_Loon received 1 likes!

How to write a if statement based on percentage

Your if then else reults are swithced around. You state if resultstwo > 0,8 then writeline less than 80. > means greater then… so switch the then and else sub-sequences around and you have it correct.

This solution provided by @Gokul001 received 1 likes!

Needed Uipath Activities for Text document(Notepad)

I n this workflow, Just update the date in the Type Into Activity DateTime.Now.ToString("yyyyMMdd") DateTime.Now.AddDays(-1).ToString("yyyyMMdd") [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 | 24 March 2022

Top 3 Topics with Most Views

Yang Miss,请赐教 made by @bigpeng with 54 views.

Unable to browser attach in ForEachRow made by @SJJ with 47 views.

How to append the data into excel using Add Data row activity made by @mayankjha986 with 46 views.

Top 3 Topics with Most Replies

Find exact Match and replace the tex file made by @Shagoul_Hameed with 17 replies.

Yang Miss,请赐教 made by @bigpeng with 16 replies.

How to append the data into excel using Add Data row activity made by @mayankjha986 with 15 replies.

Top 3 Users Who Posted The Most

@ushu made 33 posts!

@fernando_zuluaga made 31 posts!

@Gokul001 made 25 posts!

Top 3 Most Liked Posts

This post made by @ashwin.ashok received 2 likes!

Copying from one list to another

Hi @Igor_Wolny , Here is another way to approach the problem. I hope it gets you thinking in creative ways → lst_masterSet = New List(Of String) From {"Ai123", "Ai243", "Bi344", "Bi3443", "Ci24244", "Ci48484"} lst_searchCriterias = lst_masterSet.Select(Function(s) s.Substring(0,2)).Distinct().ToList() dict_items = lst_searchCriterias.ToDictionary(Function(k) k, Function(v) lst_masterSet.Where(Function(w) w.StartsWith(v)).ToList()) ListExercise.xaml (5.9 KB) Kind Regards, Ashwin A.K

This post made by @JFletch100 received 1 likes!

How to set execution target for 'Queue' trigger type?

Is there a fix for this issue or are they hoping that by ignoring it, the issue will go away?

This post made by @andrewjames received 1 likes!

Bug Report - System.Activities.statements.Assign activity throws Cannot implicitly convert type 'object' to 'string'. An explicit conversion exists (are you missing a cast?)

I had the same issue today with a multiple assign in 2021.10.5 To fix it I opened the XAML into notepad, and changed the “object” references to “string” and this fixed the issue. Unfortunately I can’t remember the steps I used when creating the multiple assign.

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 1 likes!

How to convert Json to data table

Hi @red_yan Welcome to community Look into the documentation Regards Gokul

This solution provided by @ppr received 1 likes!

V2.11.4 excel process scope

[grafik] And with index [grafik]

This solution provided by @postwick received 1 likes!

Copying from one list to another

Use Debug instead of Run. Then right-click your activities and set breakpoints. It’ll pause at each breakpoint and then you can look at the debug panels on the left to see the realtime values of each variable/list.

---

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 | 25 March 2022

Top 3 Topics with Most Views

Merge column in Datable & calculate value (LINQ) made by @fairymemay with 62 views.

How to do sum on dynamic columns in Excel made by @vinjam_likitha with 52 views.

The "Open Browser" Activity is missing made by @cui.z.1 with 46 views.

Top 3 Topics with Most Replies

Merge column in Datable & calculate value (LINQ) made by @fairymemay with 17 replies.

Unable to fetch data from excel when having value is 0 made by @shuklarchana001 with 12 replies.

How to do sum on dynamic columns in Excel made by @vinjam_likitha with 12 replies.

Top 3 Users Who Posted The Most

@ashwin.ashok made 27 posts!

@ushu made 22 posts!

@ppr made 21 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Remove part of string after last occurrence of delimiter "/"

we can do it with regex: [grafik] or using string method Split and join it again

This post made by @ushu received 1 likes!

How to terminate the UIPath process with a messagebox cancel button

@bencemarci You can terminate the process using terminate workflow activity. Please find the related work flow for this process MessageBox.zip (2.3 KB) Please use below video for more info on terminate workflow activity [UiPath Terminate Workflow Example]

This post made by @RAKESH_KUMAR_BEHERA received 1 likes!

UiPath Orchestrator New Version (2022) | By Rakesh

Learn how to use the new orchestrator UiPath user interface quickly. This video will show you how to navigate the new interface and upload a project to Orchestrator. This video will walk you through the process of successfully adding machines, robots as well as developing processes and deploying the UiPath studio built project. This video will serve as an excellent introduction to the new version of UiPath orchestrator 2022. [UiPath Orchestrator New Version (2022) | By Rakesh]

Top 3 Most Liked Solutions

This solution provided by @ushu received 1 likes!

How to terminate the UIPath process with a messagebox cancel button

@bencemarci You can terminate the process using terminate workflow activity. Please find the related work flow for this process MessageBox.zip (2.3 KB) Please use below video for more info on terminate workflow activity [UiPath Terminate Workflow Example]

This solution provided by @Yoichi received 1 likes!

I want to compare two datatable and put them in a new datatable

Hi, There are some ways to achieve this. One of them, we can use LeftJoin. The following will help you. Regards,

This solution provided by @Yoichi received 1 likes!

Looking Assistant with excel

Hi, If there is possibility it returns no row, first get datarow array using the following expression, then use CopyToDataTable when its length is larger than 0. arrDataRow = (From a In dt1.AsEnumerable Group Join b In dt2.AsEnumerable On a("bill number").ToString Equals b("bill number").ToString Into grp = Group From row In grp.DefaultIfEmpty() Select If(row Is Nothing, dtResult.LoadDataRow({a("Name"),a("amount"),a("bill number"),a("account"),a("Others"),"",""},…

---

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

Top 3 Topics with Most Views

Could not find the user interface(UI) element for this action made by @Liya_Sunny with 38 views.

Document understanding Algorithm? made by @vivek_sinha with 33 views.

Count PDF Pages made by @momo10 with 29 views.

Top 3 Topics with Most Replies

Could not find the user interface(UI) element for this action made by @Liya_Sunny with 10 replies.

System.String item cannot display all related methods made by @vrbkrpa1982 with 6 replies.

Read range (Settings and Constants sheets): Could not load file or assembly ‘ClosedXML, Version=0.87.0.0 made by @SandeepPanchal with 5 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 31 posts!

@Sudharsan_Ka made 6 posts!

@Liya_Sunny made 5 posts!

Top 3 Most Liked Posts

This post made by @Apple received 2 likes!

Argument Value

Thanks it works

This post made by @Gokul001 received 1 likes!

Read range (Settings and Constants sheets): Could not load file or assembly ‘ClosedXML, Version=0.87.0.0

Hi @SandeepPanchal Can you update the dependencies mentioned below, UiPath.Excel.Activities UiPath.MicrosoftOffice365.Activities Update the package and try running the process. Regards Gokul

This post made by @Gokul001 received 1 likes!

Insert Name from excel column into Outlook email body

Hi @jibroni Use → Save For Later activity it will act like assign activity in Studio Have a look on the user interface of Studiox Regards Gokul

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

Top 3 Topics with Most Views

Queue status in orchestrator made by @T_Y_Raju with 39 views.

How to Configure Get IMAP Mail Message Activity in Ui path made by @varun_shinde1 with 37 views.

Create multiple sheets in excel file based on records made by @avinashy with 36 views.

Top 3 Topics with Most Replies

For each row in Table and If condition (build data table OK / Add data row OK) made by @Felipe_Sternberg with 19 replies.

Can Someone help me with filtering excel column which has a date made by @shilpa_p with 11 replies.

Error in Inner Join Data Tables using custom LINQ made by @kit2815 with 8 replies.

Top 3 Users Who Posted The Most

@ashwin.ashok made 15 posts!

@lakshman made 6 posts!

@Felipe_Sternberg made 5 posts!

Top 3 Most Liked Posts

This post made by @ashwin.ashok received 2 likes!

Create multiple sheets in excel file based on records

Hi @avinashy , That can be achieved by converting the DataTable into a List of DataTables each containing 10 records. But how you want to go about naming each sheet is still unclear, so I’ve given generic names followed by indexes (Sheet2, Sheet3…Sheetn) The logic for that is detailed below → [image] Enumerable.Range(0,CInt(Math.Ceiling(dt_sampleData.Rows.Count()/10))).Select(Function(s) dt_sampleData.AsEnumerable.Skip(s*10).Take(10).CopyToDataTable()).ToList() Could you give this a try a…

This post made by @ashwin.ashok received 1 likes!

How to Configure Get IMAP Mail Message Activity in Ui path

Hi @varun_shinde1 , You might have to enable few settings in your account for this to happen. Maybe this link could be of help? Kind Regards, Ashwin A.K

This post made by @NIVED_NAMBIAR received 1 likes!

Edit code LINQ?

@fairymemay For updating the different columns, you had to use the code like this as below DT_TextFile.AsEnumerable().ToList().ForEach(Sub(row) row("FPP")= CDbl(row("FPP").ToString)/Cdbl(row("Case").ToString)) DT_TextFile.AsEnumerable().ToList().ForEach(Sub(row) row("APSUM")= CDbl(row("APSUM").ToString)/Cdbl(row("Case").ToString)) Try this approach Thanks & Regards, Nived N

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

Top 3 Topics with Most Views

string.Contains() not working made by @ainaasyhda with 53 views.

How to get TransactionItem Number? made by @MasterSinge with 48 views.

I need to check if the second variable contains 70% of the first variable made by @ridvanucok with 47 views.

Top 3 Topics with Most Replies

Get Asset - You are not authenticated! Error Code: 0 made by @Craig_Bannerman1 with 20 replies.

Cannot Trigger UiPath Robot after Update to latest UiPath studio version made by @Ashok_kumar7 with 14 replies.

Delete column (error Copytodatable is not a member) made by @fairymemay with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 30 posts!

@ashwin.ashok made 28 posts!

@ushu made 28 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…

This post made by @shalini.singh received 2 likes!

Care Health Insurance - RPA Developer - Gurgaon - India - Full Time

Job title: RPA Developer Job role: RPA Developer Country: India City: Gurgaon Company name: Care Health Insurance Employment Type: Full Time Seniority level: Junior 1 to 2 years Job Description: Role Description • Design the automation workflows, write the code using UiPath • Make changes to the robot code during implementation as needed • Responsible for the overall testing cycles Requirements • Graduate in Computer Science/IT or equivalent Degree • Analytical and proven problem-s…

This post made by @Yoichi received 2 likes!

BC20198 ')' expected at Line 1

Hi, FYI, VB expression for it will be the following. in_dt_dsrDtRaw.AsEnumerable().ToList().ForEach(Sub (row) If(row("INVOICE_NUMBER").tostring.substring(0,3)="950") Then row("BILLED_QTY")=0 row("LOCAL_CURR_AMOUNT") = Double.Parse(row("LOCAL_CURR_AMOUNT").ToString) * -1 row("NET_AMOUNT")=Double.Parse(row("NET_AMOUNT").ToString) * -1 End If End Sub )

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

BC20198 ')' expected at Line 1

Hi, FYI, VB expression for it will be the following. in_dt_dsrDtRaw.AsEnumerable().ToList().ForEach(Sub (row) If(row("INVOICE_NUMBER").tostring.substring(0,3)="950") Then row("BILLED_QTY")=0 row("LOCAL_CURR_AMOUNT") = Double.Parse(row("LOCAL_CURR_AMOUNT").ToString) * -1 row("NET_AMOUNT")=Double.Parse(row("NET_AMOUNT").ToString) * -1 End If End Sub )

This solution provided by @ppr received 2 likes!

Get Asset - You are not authenticated! Error Code: 0

[image] [/quote] not sure if an explicit reference to UiPath.Activities.Api is needed. Check its removal also

This solution provided by @Gokul001 received 2 likes!

Edit code LINQ?

Hi @fairymemay Why you need to delete the column? Have a look on the thread 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 | 29 March 2022

Top 3 Topics with Most Views

Excel「yy-mm-dd（文字列）」を「yyyy/mm/dd（数値）」にしたい made by @peanuts with 48 views.

What is the licensing fee for 1 developer? made by @Rodrigo_Buch with 47 views.

About screen scraping made by @swapnilpatil8200 with 42 views.

Top 3 Topics with Most Replies

How To Get Data From Filter Array Of Strings made by @burakavuncu with 18 replies.

How to ignore attachments(images) embed in mail body made by @VISHNU07 with 15 replies.

How to extract data from handwritten text pdf? made by @raju_alakuntla with 14 replies.

Top 3 Users Who Posted The Most

@Sudharsan_Ka made 32 posts!

@fernando_zuluaga made 23 posts!

@ppr made 22 posts!

Top 3 Most Liked Posts

This post made by @Lucas.Pimenta received 2 likes!

Winners: UiPath Apps Product Feedback

Congratulations!!

This post made by @StefanSchnell received 2 likes!

SAP.Middleware.Connector.RfcCommunicationException

@LevKushnir Hello Lev, nope. RC = Return Code RFC_RC 18 = RFC_NOT_SUPPORTED, the operation is not supported on that handle. This is a rather rare error that I have never encountered. CPIC 00024 = CM_PROGRAM_PARAMETER_CHECK (SAP Note 63347) Maybe a parameter is invalid or passed in the wrong format? Best regards Stefan

This post made by @LevKushnir received 2 likes!

SAP.Middleware.Connector.RfcCommunicationException

@DanaKz see the post above, it sounds like something wrong with parameteres. thanks, @StefanSchnell

Top 3 Most Liked Solutions

This solution provided by @ridvanucok received 1 likes!

Excel Formula Write

Burak, Evet, Türkçe kullandığın Excel’de sıkıntı yaşaman çok normal. Eğer kurumsal bir proje yapıyor isen, Excel’in dilini ingilizceye çevirmen daha sağlıklı olacaktır. Bende de şuan Türkçe excel yok o yüzden deneyemiyorum. Excel’i Türkçe olarak değiştiremiyorum diyorsan ona göre bir çözüm arayalım. Not: Forum’da bizden birilerini görmek güzel

This solution provided by @ridvanucok received 1 likes!

PDD Word Template

Hi @Kakooza-Allan-Klaus, Does this empty template satisfy the request? Blank PDD Template.docx (266.0 KB)

This solution provided by @Yoichi received 1 likes!

Save Image from variable ICollection<object> to local folder

Hi, I think it’s better to use List<UiPath.Core.Image> as @lakshman mentioned. However if you need to use ICollection<Object> for some reason, the following will work. [img20220329-a1] TypeArgument of ForEach is object. And Image property of SaveImage is as the following. CType(item,UiPath.Core.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 | 30 March 2022

Top 3 Topics with Most Views

Regex / split without delimitter made by @Aldhyt_Wirangga1 with 64 views.

Delete or Remove an entire Row in excel on the basis of some Condition made by @Mayank_Soni with 45 views.

Unable to run script after rdp disconnects made by @Mathkar_kunal with 42 views.

Top 3 Topics with Most Replies

Create Project Failed? made by @eric.chen with 23 replies.

Regex / split without delimitter made by @Aldhyt_Wirangga1 with 15 replies.

Active Directory- Get Object Properties For Each Data in Excel made by @burakavuncu with 15 replies.

Top 3 Users Who Posted The Most

@ushu made 28 posts!

@lakshman made 26 posts!

@suraj.setty made 20 posts!

Top 3 Most Liked Posts

This post made by @Sam_Abraham received 3 likes!

What is the difference between the open browser and attached browser

Hi @meeraa Open browser is used to open a browser at a specified URL and execute multiple activities within it Attach browser is used to attach to an already opened browser and perform multiple actions within it.

This post made by @DanaKz received 2 likes!

SAP.Middleware.Connector.RfcCommunicationException

@StefanSchnell thank you very much, issue was resolved by using your advice on how to code password string. @LevKushnir thank you for your help!

This post made by @ordo received 2 likes!

BAPI_REQUISITION_CREATE - Need additional fields

HI Pratik, you can not simply add fields to an existing accelerator. The accellerator does rely on the fields being available in the BAPI itself. If you send fields to the BAPI which this BAPI doesn’t understand, you will get an error. However you can easily add support for additional BAPIs, in your case BAPI_PR_CREATE. The easiest way would be to: Copy the directory of an existing BAPI in the accellerator. Rename the files to follow the schema with the BAPI name in the artifacts. Modify t…

Top 3 Most Liked Solutions

This solution provided by @Sam_Abraham received 3 likes!

What is the difference between the open browser and attached browser

Hi @meeraa Open browser is used to open a browser at a specified URL and execute multiple activities within it Attach browser is used to attach to an already opened browser and perform multiple actions within it.

This solution provided by @ppr received 2 likes!

Regex

give a try at: [grafik]

This solution provided by @Gokul001 received 2 likes!

Save Email Attachments Saves Images

HI @hurmet.noka Actually, the Filter property from Save Mail Attachment will filter on which attachments should be saved. The filter should be in RegEx format. Try to use “.csv” in the filter Or Try to use “.*(.CSV|.Csv|.CSv|.csv)” in the filter [image] Have a look on the thread 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.