Forum Engagement Daily Reports

[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.

[system]

Daily Forum Report | 14 September 2022

Top 3 Topics with Most Views

How to convert Image to byte? made by @vanithavs with 54 views.

How can I read all .xlsx files in a folder and read tab names from each excel made by @Pranee_007 with 48 views.

Error : Cannot find this file. Verify the path and filename are correct made by @Vaishnav_Tej with 41 views.

Top 3 Topics with Most Replies

Error : Cannot find this file. Verify the path and filename are correct made by @Vaishnav_Tej with 31 replies.

How can I read all .xlsx files in a folder and read tab names from each excel made by @Pranee_007 with 18 replies.

How to convert Image to byte? made by @vanithavs with 17 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 50 posts!

@raja.arslankhan made 49 posts!

@postwick made 36 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

After calling an API that that returns a JSON, is it possible to grab a PDF within the JSON file?

in short, yes grab the document string from JSON array Decode the Base64 representation Save the result to file system as e.g. abc.pdf file Decoding e.g.

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

How do i Remove the Digits After Decimal Wihout Round?

Hi @kishan.savaliya Try Generic InputStr.Substring(0,InputStr.split("."c)(0).length+2)

This post made by @StefanSchnell received 2 likes!

Migrating Activities to .NET 6

@Andreea_Stroe Thank you very much for this valuable information.

Top 3 Most Liked Solutions

This solution provided by @Gokul_Jayakumar received 2 likes!

How do i Remove the Digits After Decimal Wihout Round?

Hello @kishan.savaliya You can use Regex method System.Text.RegularExpression.Regex.Match(YourString,"\d+.\d").ToString.Trim [image]

This solution provided by @rohith.prabhu received 2 likes!

How to create the new excel file by using the Original file with format

Hello @poomnattawat , You are using for loop to loop through the PDF files and extract the data from it right ? To read PDF File you are passing the PDF File Path right? Perform the following steps inside the for loop. Create a Variable Called PDF_FileName (Type String) Use Assign activity Assign : PDF_FileName = Path.GetFileNameWithoutExtension(PDF File Path) this will store the PDF File name. As you are having the Template file (Application Format.xlsx) hence you need to create copy…

This solution provided by @Gokul001 received 2 likes!

How to use multiple condition to filter in Filter data table activity

HI @Krishnakumar_Vasudevan Can you Check on the XAML file FilterDataTable.xaml (9.2 KB) [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 | 15 September 2022

Top 3 Topics with Most Views

Sum of column data made by @Sabbir_Anwar with 40 views.

How to write Value from specific column made by @Mohammed_sahil with 40 views.

Help with this case using dates made by @Jesus_Fonseca with 36 views.

Top 3 Topics with Most Replies

Add data and data scraping made by @irem_dogan with 29 replies.

Sum of column data made by @Sabbir_Anwar with 25 replies.

How to add multiple invoices in pdf format to a single excel file? made by @Harshita_Ramesh with 16 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 55 posts!

@Gokul001 made 34 posts!

@postwick made 26 posts!

Top 3 Most Liked Posts

This post made by @Ray_Sha1 received 2 likes!

Linq to select column A based of condition in columnB

All the above solutions work fine

This post made by @supermanPunch received 2 likes!

Linq to select column A based of condition in columnB

@Ray_Sha1 , You could Check the Below Expression : DT.AsEnumerable.Where(Function(x)x("ColumnB").ToString.Equals("Yes")).Select(Function(x)x("ColumnA").ToString).ToArray

This post made by @postwick received 2 likes!

How to run an unattended bot entirely on orchastrator

You’re asking others to write your entire process for you. What you should do is complete the free training on the UiPath Academy web site, to understand how UiPath automations are created. You’ll need to use the API to put an item into a queue which triggers a job, and that job checks the price. Then you’d have to design an API into your app to receive the alert back from the UiPath job. “First can i even run a bot just on orchastrator as orchastrator functioning like a server” No. Jobs d…

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

Linq to select column A based of condition in columnB

@Ray_Sha1 , You could Check the Below Expression : DT.AsEnumerable.Where(Function(x)x("ColumnB").ToString.Equals("Yes")).Select(Function(x)x("ColumnA").ToString).ToArray

This solution provided by @postwick received 2 likes!

How to run an unattended bot entirely on orchastrator

You’re asking others to write your entire process for you. What you should do is complete the free training on the UiPath Academy web site, to understand how UiPath automations are created. You’ll need to use the API to put an item into a queue which triggers a job, and that job checks the price. Then you’d have to design an API into your app to receive the alert back from the UiPath job. “First can i even run a bot just on orchastrator as orchastrator functioning like a server” No. Jobs d…

This solution provided by @postwick received 2 likes!

Error On Fetching Column Values from database

That means you are referencing an array element, row element, row, etc that doesn’t exist. In other words, you have an array with 5 elements but reference index 7 which doesn’t exist. Post a screenshot of your assign, and show us the expression.

---

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

Top 3 Topics with Most Views

How to predict max and min the price can go made by @sagar.raval with 41 views.

Dynamically name excel sheet made by @diya_poovamma with 40 views.

How to align the first row in text file? made by @jamunatj with 40 views.

Top 3 Topics with Most Replies

For each and data scraping made by @Yurdanur_Yusuf with 33 replies.

ClientSecurityHash code is working fine still i am not getting score when i am uploding on uipath acadamy made by @Sandhya_Gajare with 25 replies.

Dynamically name excel sheet made by @diya_poovamma with 22 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 50 posts!

@Gokul001 made 36 posts!

@ppr made 35 posts!

Top 3 Most Liked Posts

This post made by @CharanTejChenna received 1 likes!

Data manager: Line items spanning several lines

Yes. Got to know this. Thanks for your info. Will get back to you as soon as I try this.

This post made by @ngango88 received 1 likes!

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

Amazing!!! I can’t wait to build the robots on UiPath.

This post made by @Nitya1 received 1 likes!

How To Reverse A DataTable In UiPath

We may come across situations where we have to process the records available in excel or a data table in reverse. So let’s explore how to do that in UiPath!!! dt_Reverse = dt_Original.AsEnumerable.Reverse.CopyToDataTable Note: Simply replace the “dt_Original” with your required “DataTable” Example Implementation using UiPath : Let us implement a workflow which takes a sample data table as input and outputs the reverse of it. Step 1: Drag “Build Data Table” activity into the desi…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Xlsxファイルをcsvで保存したい

こんにちは 最も簡単な方法はWorkbook-ReadRangeとWriteCSVを使えば、EXCELのアプリケーションが インストールされていなくてもCSV化することができます。（以下の例） もし書式がうまく反映されていないときは、ExcelApplicationScopeまたはUseExcelFileをつかって Excelのアプリケーションを開いて、それでReadRangeすれば良いかと思います。 なお日本語が含んでいる場合はWriteCSVのエンコーディングの設定が必要な場合があるので ご注意ください。 [image]

This solution provided by @ppr received 1 likes!

Fetch the value from json output

feel free to decompose the longer line [grafik] myJObject("ChargeTransactionDetails")("ChargeTransactionDetail").Where(Function (x) x("ChargeType").Value(of String).Equals("TRANSFER_OUT")).Select(Function (x) x("TransferToOhKey").Value(of String)).ToArray

This solution provided by @Gokul001 received 1 likes!

How to extract the infomation

Hi @Sandhya_Gajare Share the expression for generating this EQ75283- Kizzie Kohen- Italy value? Check out the Split expression Client ID ClientID = ClientInformation.Substring(ClientInformation.IndexOf("Client ID: ") + "Client ID: ".Length).Split(Environment.NewLine.ToCharArray)(0) Client Name ClientName = ClientInformation.Substring(ClientInformation.IndexOf("Client Name: ") + "Client Name: ".Length).Split(Environment.NewLine.ToCharArray)(0) Client Country ClientCountry = ClientInforma…

---

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

Top 3 Topics with Most Views

Chrome is update and now getting Error made by @Ram_Gurav1 with 41 views.

Queue Null value made by @Ketan_Wajekar with 33 views.

The AI Fabric Section not avaliable in the Orchestrator made by @Rusira_Liyanage with 30 views.

Top 3 Topics with Most Replies

Not getting grade for Client Security Hash assignment on academy made by @Sandhya_Gajare with 26 replies.

Wait for Button to be Clickable made by @Beere_Plays with 13 replies.

How to convert IEnumerable to Datatable? made by @Muralikrishna_Surve with 8 replies.

Top 3 Users Who Posted The Most

@Sanjit_Pal made 26 posts!

@raja.arslankhan made 20 posts!

@Sandhya_Gajare made 13 posts!

Top 3 Most Liked Posts

This post made by @Shubham_Dutta received 1 likes!

In the 'Lookup Column category' the value for argument 'Column Name' is not set or is invalid."

Hi @Fresher , Are you passing the correct column name for which you want to look up the data. Please check your column name spelling and all because this error occurs due to column mismatch. Thanks & Regards, Shubham Dutta

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

In the 'Lookup Column category' the value for argument 'Column Name' is not set or is invalid."

Hi @Fresher Could you try adding this snippet of code right before the Lookup Column Activity to check if the column is present in the Data Table during runtime? dt1.Columns.Cast(Of DataColumn).Any(Function(a) a.ColumnName.Equals("Material Code")) [image] If it returns false, then that means the Data Table isn’t being parsed properly somewhere. Also, could you please let us know what it is that you are trying to achieve here? We will try to help you out if you could provide some sample da…

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

How to convert IEnumerable to Datatable?

Hi @Muralikrishna_Surve , Could you try declaring a Variable of type DataTable and assign that to the Read Range Activity? Usually when you create a variable using Ctrl+K in the Read Range Output it generates a Datatable. As for converting an IEnumerable to DataTable, if its an IEnumerable of DataRows, then you have to append a .CopyToDataTable() method to it. Kind Regards, Ashwin A.K

Top 3 Most Liked Solutions

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

In the 'Lookup Column category' the value for argument 'Column Name' is not set or is invalid."

Hi @Fresher Could you try adding this snippet of code right before the Lookup Column Activity to check if the column is present in the Data Table during runtime? dt1.Columns.Cast(Of DataColumn).Any(Function(a) a.ColumnName.Equals("Material Code")) [image] If it returns false, then that means the Data Table isn’t being parsed properly somewhere. Also, could you please let us know what it is that you are trying to achieve here? We will try to help you out if you could provide some sample da…

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

How to convert IEnumerable to Datatable?

Hi @Muralikrishna_Surve , That can be easily taken care of. If needed, we can even add the actual headers, but if the headers are not important then you can try this. First we read the Row, then initialize the DataTable before we use a For Each Activity to keep adding DataColumns to fit the schema: [image] Then we add the row to our newly created DataTable. [image] ReadRowConvertToDT.xaml (6.7 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 | 18 September 2022

Top 3 Topics with Most Views

How to go to the else condition with UIElement not found? made by @pprin001 with 33 views.

Specified folder does not exisit made by @Bharath_Kumar3 with 32 views.

dotNET 7 Assemblies Not Visible in Manage Packages made by @StefanSchnell with 31 views.

Top 3 Topics with Most Replies

Specified folder does not exisit made by @Bharath_Kumar3 with 11 replies.

Why we are using JSON file to create config file made by @meeraa with 9 replies.

Problem in splitting the value in column made by @naveenkumarr with 8 replies.

Top 3 Users Who Posted The Most

@ashwin.ashok made 10 posts!

@ppr made 6 posts!

@Bharath_Kumar3 made 5 posts!

Top 3 Most Liked Posts

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

Problem in splitting the value in column

Hi @naveenkumarr , Welcome to the UiPath Forum. I see that you have a list of acronyms that you’d like to replace the invoice numbers with, and we would really appreciate it if you could provide some sample data to work with. Since you haven’t provided anything, I will have to make few assumptions as I devise a solution for you. Assumption #1 The List of acronyms is read into a datatable Assumption #2 All invoice numbers are present in the list of acronyms Keeping these two assumptions i…

This post made by @Udiar received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, I’m new to Uipath, I was looking for a JS programmer to make some scripts to help me with some daily tasks, then he offered me the Uipath instead. I think I like it but I encountered some weird issues, for example I don’t understand why the Switch case value can’t process a VB expression… (while its not an issue in other programming languages). Looking forward to better get to know UiPath. Thanks,Udi

This post made by @Shubham_Dutta received 1 likes!

Problem in splitting the value in column

Hi @naveenkumarr , I have created a sample workflow with only 2 data i.e. “Need to create ticket for 26 8” and “Need to create ticket for 34 8 7”. and got the output in sheet 2 of input.xlsx file, Go through my workflow and add your other data data details in further if conditions and add data row activity. New folder (2).zip (9.1 KB) I hope this will help you. Thanks & Regards, Shubham Dutta

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

Top 3 Topics with Most Views

Assign Activity LINQ Query made by @Ishan_Shelke with 54 views.

Action Center notifications in public preview made by @Liji with 53 views.

How to convert dd-MMM-yy to yyyy.MM.dd format? made by @vanithavs with 52 views.

Top 3 Topics with Most Replies

Error in Core activities configuration in Studio when using company laptop, not happen with personal laptop made by @tueminh290597 with 17 replies.

MY Last folder name made by @rAE_rAS with 15 replies.

[LINQ] - Remove Duplicate Rows with Multiple Unique Identifier Columns from Multiple Data Table made by @anthonyjr with 14 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 42 posts!

@Rahul_Unnikrishnan made 28 posts!

@sharon.palawandram made 23 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 5 likes!

G-Suite Guidelines

Hello Everyone, I would like to present this post who are looking for the G-Suite Automation Google Workspace Steps Open the console and create a new project. [image] Enable all the APIs which are necessary for the project [image] Create a credential based on the project need (API, OAuth, Service Account). [image] [image] If created Service Account, generate the key and store them in the project folder or the folder to which the bot has access. [image] [image] The Key will …

This post made by @Liji received 5 likes!

Action Center notifications in public preview

We are happy to announce the new notifications feature within Automation cloud portal for Action Center events in public preview. Action Center users will now receive built-in notifications through two channels, in-app and email to notify them with the most relevant events like Action assignment (bulk& single), Action forward and Action un-assignments. Users can manage their own preferences for opting-in or opting-out of these notifications from user profile itself. All cloud customers…

This post made by @Liji received 2 likes!

Is is possible to have email notifications when a task is added to the action center

Hi @lukasziebold We have notifications opening up in public preview for all cloud customers very soon Action Center notifications in public preview

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

Linq to Select first few columns using index in datatable

Hi @Ray_Sha1 How about this expression? New DataTable → DtOutput (From d In Dt.AsEnumerable let ra = d.ItemArray.Take(9).toArray Select DtOutput.Rows.Add(ra)).CopyToDataTable Regards Gokul

This solution provided by @Gokul001 received 1 likes!

Googleフォームの回答が入力されるスプレットシートから当日分の回答だけフィルターしたい

Hi @T_Hirao1 How about this expression Use Assign activity DtOut → Variable Type is System.Data.DataTable DtOut = DTInput.Asenumerable.Where(Function(r) CDate(r(“Column Name”).ToString).Date=DateTime.Now.Tostring("dd-MM-yyyy")).Copytodatatable Note - “dd-MM-yyyy” → spreadsheet format that need to give here. Regards Gokul

This solution provided by @Yoichi received 1 likes!

トリガースコープについて

こんにちは トリガースコープはタイムアウトの設定等がなく、設定により回数制限なく繰り返すことが 可能なので、例えば常時特定アクションの監視を行う専用のプロセスに用いられるケースが 考えられます。 もう少し具体的に例を挙げるとOutlookのメールが着信したら何らかのアクションを行う あるいはファイルが更新されたら何らかのアクションを行う専用のプロセス等が考えられます。 通常のプロセスの一部として使うこともできますが、その場合は例えばタイムアウト処理や 通常の処理等を並列アクティビティを用いて疑似並列に走らせる等が必要になるかと思います。

---

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

Top 3 Topics with Most Views

How to get the Robot ID made by @Juan_Esteban_Valencia with 45 views.

I can't send screenshoot in e-mail body made by @Patrycja_Cwikla with 42 views.

Orchestrator API/getting output from the process made by @db64a40e754add3bd2df0ad39 with 41 views.

Top 3 Topics with Most Replies

I can't send screenshoot in e-mail body made by @Patrycja_Cwikla with 23 replies.

Logging onto Orchestrator in Unattended Mode made by @zackattack0517 with 18 replies.

Copy and paste one column in other column in same excel sheet made by @lokeshkumar.k with 17 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 42 posts!

@Gokul001 made 38 posts!

@marian.platonov made 31 posts!

Top 3 Most Liked Posts

This post made by @matti.grove received 1 likes!

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

I’m most intrigued by the discover phase, and I think StudioX will be the best product for me to try out.

This post made by @heyium received 1 likes!

While the file is running, the macro works fine, but when I open the excel file after the process is completed, half of the operations that need to be done in the macro are saved

Thank you @Rahul_Unnikrishnan , it worked!

This post made by @Rahul_Unnikrishnan received 1 likes!

While the file is running, the macro works fine, but when I open the excel file after the process is completed, half of the operations that need to be done in the macro are saved

Hello @heyium Please check the below similar post. https://forum.uipath.com/t/execute-macros-document-was-not-saved/260873/7 Thanks

Top 3 Most Liked Solutions

This solution provided by @Rahul_Unnikrishnan received 1 likes!

While the file is running, the macro works fine, but when I open the excel file after the process is completed, half of the operations that need to be done in the macro are saved

Hello @heyium Please check the below similar post. https://forum.uipath.com/t/execute-macros-document-was-not-saved/260873/7 Thanks

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

How to delete rows with multiple conditions - LINQ

Hi @Gabriel_Wisniewski , Instead of deleting rows, we can look at it this way. Lets focus on the rows that we are interested in retaining. If you are unsure about the number of columns, and/or its names, or if the rows contain alphanumerical characters, then this might be the solution you are looking for: Dt.AsEnumerable().Where(Function(w) w.ItemArray.Any(Function(a) If(Integer.TryParse(a.ToString,New Int32),Convert.ToInt32(a),0)>2)).CopyToDataTable() [image] CheckAllCellsInGivenRow.xaml …

This solution provided by @ppr received 1 likes!

AsEnumerable is not a member of System.data.DataTable issue

First we check following: Then lets clear if the project is set to VB or C#

---

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

Top 3 Topics with Most Views

HyperHack 2022 update! Winners have been announced! made by @Rohit_Radhakrishnan with 73 views.

Plzz help me made by @katta_nikhil with 41 views.

Linq how to exclude OrderID from a other Datatable made by @raiko.m with 35 views.

Top 3 Topics with Most Replies

Convert to Date Time From String made by @nilesay with 19 replies.

Plzz help me made by @katta_nikhil with 19 replies.

Problem With Text File To Data Table To CSV File Conversion made by @worldwynj with 12 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 32 posts!

@raja.arslankhan made 23 posts!

@postwick made 23 posts!

Top 3 Most Liked Posts

This post made by @Rohit_Radhakrishnan received 10 likes!

HyperHack 2022 update! Winners have been announced!

UiPath Community organized this years edition of HyperHack, global community hackathon, with more than 560 participants from 38 countries this year, the competition drew diverse participation with over 30% women participation around the world from over 230 unique organizations. We challenged our community to solve business problems across 3 categories and we have been really excited to see the teams present innovative solutions. Here are our ama…

This post made by @Sudharsan_Ka received 2 likes!

Convert to Date Time From String

@nilesay You need to change the column type to date in excel right? you can achieve it using a modern activity or BalaReva Activity Check out this image and skeleton xaml file for modern [image] Sequence.xaml (8.2 KB) Checkout this thread for Balareva activities Regards Sudharsan

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

Introducing Canary Tenant for Automation Cloud

wao New Addition

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Error IN DATATABLE

Hi, Can you try the following out_dt_table.AsEnumerable() Then set DataRow in TypeArgument property in Parallel For Each. BTW, do you need to use Parallel For Each? I recommend to use ForEach or ForEachRow if you don’t have special reason. Regards,

This solution provided by @Yoichi received 1 likes!

Add column values of each Id in data table (1st row of each id)

Hi, How about the following sample? [image] dt.AsEnumerable().GroupBy(Function(r) r("Id").ToString).ToList.ForEach(Sub(g) g.First().Item("A")=g.Sum(Function(r) CDbl(r("A").ToString)) g.First().Item("B")=g.Sum(Function(r) CDbl(r("B").ToString)) g.First().Item("C")=g.Sum(Function(r) CDbl(r("C").ToString)) g.First().Item("D")=g.Sum(Function(r) CDbl(r("D").ToString)) End Sub) Sample20220921-2.zip (8.8 KB) Regards,

This solution provided by @Yoichi received 1 likes!

Linq how to exclude OrderID from a other Datatable

Hi, How about using DtExclude as the following? DtOutput = (From d In dtInput.AsEnumerable Where Not DtExclude.AsEnumerable.Any(Function(r) r("Order").ToString=d("Order").ToString) Where Convert.ToDateTime(d("Date").ToString) <= DateTime.Today Select d).CopyToDataTable And as @ashwin.ashok mentioned, perhaps you should evaluate value as numeric as the following. dtExcluse = (From d In dtInput.AsEnumerable Where Int32.TryParse(d("Rate").ToString,New Int32) AndAlso Int32.Parse(d("Rate").ToSt…

---

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.