Forum Engagement Daily Reports

[system]

Daily Forum Report | 02 May 2023

Top 3 Topics with Most Views

Split the text made by @Demo_User with 54 views.

How to get latest download files made by @Suraj_Gaikwad_Nuvama_Grou with 44 views.

How to get over all count of a queue items? made by @Vrishchik with 44 views.

Top 3 Topics with Most Replies

Split the text made by @Demo_User with 22 replies.

How to read ExtractedData in inverse made by @Muhammad_Anas_Baloch with 15 replies.

Two level subfolders help made by @Ricchch with 13 replies.

Top 3 Users Who Posted The Most

@Yoichi made 33 posts!

@Anil_G made 33 posts!

@Srini84 made 27 posts!

Top 3 Most Liked Posts

This post made by @dla0313 received 2 likes!

[ODBC Teradata Driver] Query Timeout Expired

Thanks, yes I increased the timeout to 60 seconds and its working now.

This post made by @Srini84 received 2 likes!

[ODBC Teradata Driver] Query Timeout Expired

@dla0313 You better increase the timeout of the Execute Query activity and see As the default activity timeout is 30 seconds and if the Query is taking more time then you can see this type of errors You can place some delays as well if this is still not working Hope this may help you Thanks, Srini

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

Compare a list of mails, using subjects with list of subjects stored in list of string

Hi @Karan_Zaveri , Try this: listMailMessage.AsEnumerable().Where(Function(mail) listSubjects.Any(Function(x) mail.Subject.ToString.ToLower.Trim.Contains(x.ToString.ToLower))).ToList Regards,

Top 3 Most Liked Solutions

This solution provided by @Srini84 received 2 likes!

[ODBC Teradata Driver] Query Timeout Expired

@dla0313 You better increase the timeout of the Execute Query activity and see As the default activity timeout is 30 seconds and if the Query is taking more time then you can see this type of errors You can place some delays as well if this is still not working Hope this may help you Thanks, Srini

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

Compare a list of mails, using subjects with list of subjects stored in list of string

Hi @Karan_Zaveri , Try this: listMailMessage.AsEnumerable().Where(Function(mail) listSubjects.Any(Function(x) mail.Subject.ToString.ToLower.Trim.Contains(x.ToString.ToLower))).ToList Regards,

This solution provided by @Srini84 received 1 likes!

How to remove empty row in excel for some specific columns

@sathish_Kumar6 You can use Filter Datatable activity and mention your column for example F->“campaign” and put is not empty Then you will get all the values wth the campaign which is not empty Now use Read Range activity to write it back to a new excel Hope this may help you Thanks, Srini

---

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 May 2023

Top 3 Topics with Most Views

How can I add two numbers and add those two numbers before enter into captcha? made by @Samraat_Maharjan1 with 56 views.

Not getting the desired values made by @ajindal with 54 views.

Need to check if a IEnumerable argument has any value stored and return is as a bool made by @goncalo.rocha with 50 views.

Top 3 Topics with Most Replies

How can I add two numbers and add those two numbers before enter into captcha? made by @Samraat_Maharjan1 with 29 replies.

UiPath studio is not installing made by @Learner007 with 24 replies.

Error in GetIMAP Activity made by @ashwini.mali with 22 replies.

Top 3 Users Who Posted The Most

@Anil_G made 48 posts!

@supermanPunch made 22 posts!

@arjunshenoy made 16 posts!

Top 3 Most Liked Posts

This post made by @Jithesh_R received 4 likes!

How to get data from web without using scrapping

Hey @Suraj_Gaikwad_Nuvama_Grou , Please check this wokflow .Iam able to get the output using find children and Get attribute. Main.zip (4.6 KB) Output: [image]

This post made by @arjunshenoy received 2 likes!

How to get data from web without using scrapping

@Suraj_Gaikwad_Nuvama_Grou As I already mentioned, it is possible to extract the data from the visible page using Find Children & Get Attribute. You can refer to the workflow @Jithesh_R just shared using the same concept. But, your data is spanning across 50 pages & you might have to implement a click activity or something similar to change the page every time before the find children get executed. Best Regards.

This post made by @V_Vasanth_Kumar received 2 likes!

How to copy data to text file by checking if column having specific value after data scraping?

hi @vnsatyasunil Please refer the below flow, [image] [image] Regards, V Vasanth Kumar

Top 3 Most Liked Solutions

This solution provided by @Jithesh_R received 4 likes!

How to get data from web without using scrapping

Hey @Suraj_Gaikwad_Nuvama_Grou , Please check this wokflow .Iam able to get the output using find children and Get attribute. Main.zip (4.6 KB) Output: [image]

This solution provided by @Srini84 received 1 likes!

Can we deploy multiple bots from different accounts on the same server machine having different users?

@piyush.g Welcome to forums To my knoweldge it’s possible to setup in 5 different users in one windows Server Now, for installation, you can logging to Admin account and install for every User, this will install the setup file But you need to login manually to each user and you have configure the assistant to connect to Orchestrator Also, you need to have different licenses for each user Hope this may help you Thanks, Srini

This solution provided by @supermanPunch received 1 likes!

How to update the blank and Zero row in DT

@chandans , Could you try changing the Direction of in_CELL_Value_AF to In and check if you are able to resolve the issue. Also change the type to string as I believe it is a String type value.

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 04 May 2023

Top 3 Topics with Most Views

CLI for interacting with UiPath services made by @thschmitt with 64 views.

What are the reasons for choosing UiPath for RPA instead of using JavaScript or Python? made by @sagar.raval with 56 views.

Extract the multi row value in excel file made by @Le_Vo_Tien_Phat_KHCM with 53 views.

Top 3 Topics with Most Replies

Extract the multi row value in excel file made by @Le_Vo_Tien_Phat_KHCM with 12 replies.

Regex activity issue made by @BlueBird1 with 11 replies.

How to copy column data from excel and paste in a web browser in single line format made by @Naman_Arora with 11 replies.

Top 3 Users Who Posted The Most

@Yoichi made 20 posts!

@Anil_G made 17 posts!

@vishal.kp made 13 posts!

Top 3 Most Liked Posts

This post made by @thschmitt received 6 likes!

CLI for interacting with UiPath services

Command Line Interface (CLI) for interacting with UiPath Services uipathcli provides a unified command line interface for accessing UiPath resources. You can use the CLI to execute commands from a terminal, either interactively or automated through scripts. The CLI makes it easy to get started using UiPath Service APIs and allows you to set up resources and automate small tasks. uipathcli works on all major platforms (Windows, Linux, MacOS) and architectures (x86/x64 and ARM). Getting Starte…

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

How enter yesterday date example today is 04/05/2023 I have to enter 04/04/2023. What is the expression can we use?

Hi @Zuber_Shaikh , Datetime.Now.adddays(-1).tostring("dd/MM/yyyy") Regards,

This post made by @Umadevi_Sanjeevi received 2 likes!

How enter yesterday date example today is 04/05/2023 I have to enter 04/04/2023. What is the expression can we use?

Hi @Zuber_Shaikh , Can you confirm which value you have to enter. 04/04/2023 or 03/05/2023. Input = 04/05/2023 Get yesterday date Now.AddDays(-1).ToString("dd/MM/yyyy") Output is 03/05/2023 Get Last month yesterday date from the current date Now.AddMonths(-1).AddDays(-1).ToString("dd/MM/yyyy") Output: 03/04/2023 Thanks!

Top 3 Most Liked Solutions

This solution provided by @fernando_zuluaga received 1 likes!

Linq query to remove a particular string from a particular column

Hi @taruna.mehra Give a try with the following [image] In the invoke code use this dtInput.AsEnumerable().ToList().ForEach(Sub(r) r("Column name -session Id")= r("Column name -session Id").ToString().Trim().Replace("#ADA#", String.Empty)) Make sure to replace the exact column name within the double quotes Regards!

This solution provided by @AmlanKiranPatel received 1 likes!

Published Automation Not Showing in Uipath Assistant

Hi @vishal.kp , It’s Solved. Actually, I was Publishing it to “Orchestrator Tenant Process Feed” Instead of “Orchestrator Personal WorkSpace Feed”.(Just a silly mistake that takes me 3Hr to Solve. Ha Ha )

This solution provided by @arjunshenoy received 1 likes!

Get value from a List of Dictionary based on a Key value

Hi @Himanshu_Punj You can use the following query: dictList.Where(Function(dict) dict("Age").ToString() = "25").Select(Function(dict) dict("Name").ToString()).FirstOrDefault() Hope this helps, Best 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 | 05 May 2023

Top 3 Topics with Most Views

How do i update different Excel Sheet tab base on the file name? made by @monicaong0609 with 57 views.

While extracting data through data scraping,column names are getting as data instead of column names made by @vnsatyasunil with 56 views.

DataTables activities made by @BlueBird1 with 46 views.

Top 3 Topics with Most Replies

While extracting data through data scraping,column names are getting as data instead of column names made by @vnsatyasunil with 13 replies.

Split com regras made by @devrpa746 with 11 replies.

Problem with SAP version migrating from version 750 to 760 made by @Juanjo_Fernandez with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 48 posts!

@vnsatyasunil made 12 posts!

@mkankatala made 11 posts!

Top 3 Most Liked Posts

This post made by @RAKESH_KUMAR_BEHERA received 2 likes!

How do I Install UiPath Robot in Service Mode or User Mode | UiPath Service Mode | UiPath User Mode

[How do I Install UiPath Robot in Service Mode or User Mode | UiPath Service Mode | UiPath User Mode]

This post made by @AlexGabriel97 received 2 likes!

SPLIT STRING DOUBT

You could use “.replace”. string.Replace(“:”,“”)

This post made by @PALKUMARI_PATEL received 1 likes!

How to get the file from sharepoint and drop the file on sharepoint?

Thanks @Anil_G For helping on the issue. Working absolutely fine.

Top 3 Most Liked Solutions

This solution provided by @AlexGabriel97 received 2 likes!

SPLIT STRING DOUBT

You could use “.replace”. string.Replace(“:”,“”)

This solution provided by @Anil_G received 1 likes!

Extract Year from a date

@renjutom Please try this Datetime.ParseExact("Jan 25","MMM yy",System.Globalization.CultureInfo.InvariantCulture).Year cheers

This solution provided by @Anil_G received 1 likes!

Insert/Delete row issue

@kawtar.ettayarssouti I guess the position start from 1…if you want to remove first teo then position is 1 and number of rows is 2 Cheers

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 06 May 2023

Top 3 Topics with Most Views

Error for UiPath Apps: The UiPath Assistant is Required to Complete this action made by @RAKESH_KUMAR_BEHERA with 40 views.

HTTP Error 400. The size of the request headers is too long made by @everluo with 37 views.

Supports Persistence Missed made by @xiaotingyan98 with 35 views.

Top 3 Topics with Most Replies

How to read range with colors and do write range with colors made by @Gomathi_Ganesan with 12 replies.

Runtime Execution Error_application arguments Change made by @jackie.yue with 11 replies.

Schedule bot in 2 machine made by @logesh_kumar1 with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 28 posts!

@jackie.yue made 8 posts!

@Gomathi_Ganesan made 7 posts!

Top 3 Most Liked Posts

This post made by @_pjflo received 1 likes!

How to do versioning of package

Thanks for explaining, @Anil_G! Greatly helped

This post made by @LAKSHMI_NARAYANA_PEMMASAN received 1 likes!

Buscar imagen y click en boton o continuar

if you are using Modern activities use Check App State [image] if image found then actions on target appears other wise on does not appear side Classic Use element exists activity which will give you boolen value (true or false ) [image] now use if activity with the result from above [image] Hope this helps Regards

This post made by @pruebaxx454 received 1 likes!

Buscar imagen y click en boton o continuar

Thank you very much

Top 3 Most Liked Solutions

This solution provided by @LAKSHMI_NARAYANA_PEMMASAN received 1 likes!

Buscar imagen y click en boton o continuar

if you are using Modern activities use Check App State [image] if image found then actions on target appears other wise on does not appear side Classic Use element exists activity which will give you boolen value (true or false ) [image] now use if activity with the result from above [image] Hope this helps 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 | 07 May 2023

Top 3 Topics with Most Views

How to install Abbyy OCR in UiPath the latest community version made by @Kakooza-Allan-Klaus with 41 views.

Resolution problems in unattended Mode made by @JoSom with 41 views.

Zipping the file will save the contents in the project folder itself and not getting saved in the given folder location. Why? made by @vignesh_S.M with 39 views.

Top 3 Topics with Most Replies

Zipping the file will save the contents in the project folder itself and not getting saved in the given folder location. Why? made by @vignesh_S.M with 15 replies.

Excelシート名の取得方法 made by @sayaka.y with 9 replies.

How to install Abbyy OCR in UiPath the latest community version made by @Kakooza-Allan-Klaus with 8 replies.

Top 3 Users Who Posted The Most

@Nitya1 made 20 posts!

@Anil_G made 18 posts!

@LAKSHMI_NARAYANA_PEMMASAN made 12 posts!

Top 3 Most Liked Posts

This post made by @Jon_Smith received 1 likes!

After updates cannot open any projects (..23.4.0.nupkg denied)

This is a poor fix. Don’t do it. The issue is due to some bug related to the new release, for some reason the packages in the install folder do not have the correct permissions. Go to that packages folder and set it and all the files into it to Full Control for all users. Your projects will open correctly again after that. There are other topics on this discussing this including one that has replies from a UiPath staff member who also shows how to do it via command line.

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

Convert String datetime type

Hi @Radhika_Lohar1 , Cdate("05/15/2023") Regards,

This post made by @Radhika_Lohar1 received 1 likes!

Convert String datetime type

It worked! Thanks.

Top 3 Most Liked Solutions

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

Convert String datetime type

Hi @Radhika_Lohar1 , Cdate("05/15/2023") Regards,

This solution provided by @Anil_G received 1 likes!

How to install Abbyy OCR in UiPath the latest community version

@Kakooza-Allan-Klaus This is just a warning not an error…windows legacy is being removed and also support for it is removed from april… And to use abby as of now UiPath does not support it [image] https://docs.uipath.com/activities/other/latest/user-guide/release-notes-uipath-abbyy-activities Cheers

This solution provided by @Jon_Smith received 1 likes!

Error While Debugging

Your problem is clear. Its your Get Temperature activity. You are trying to set the value (assign it) to an expression. In this case Temperature.ToString(). Temperature.ToString() is an expression. You need to change it to simply be Temperature.

---

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 May 2023

Top 3 Topics with Most Views

LINQ to update columns in data table made by @besakkiappan46 with 66 views.

How to split any string with text as keyword made by @Swarit_Goyal1 with 58 views.

Data Base query to excel File made by @Jay_Chaudhary with 58 views.

Top 3 Topics with Most Replies

How to split any string with text as keyword made by @Swarit_Goyal1 with 23 replies.

Regular expression not working made by @neha.verma with 23 replies.

Data Base query to excel File made by @Jay_Chaudhary with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 34 posts!

@supermanPunch made 30 posts!

@Shubham_Kinge made 23 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 5 likes!

Monthly Forum rewards - April 2023

Congratulations to all the winners

This post made by @Anil_G received 3 likes!

Monthly Forum rewards - April 2023

Congratulations … Keep up the good work

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

Monthly Forum rewards - April 2023

Congrats team

Top 3 Most Liked Solutions

This solution provided by @Nitya1 received 2 likes!

If activity with OR expression

Hi @rathi.sham Try this LINQ function to filter the array and return only the items that do not match those two values. Use an Assign activity to create a new filtered array:- filteredArray = myarray.Where(Function(fruit) Not fruit.Equals(“Kiwi”) AndAlso Not fruit.Equals(“Plum”)).ToArray() Use an If activity to check if the original array contains “Kiwi” or “Plum”: myarray.Intersect({“Kiwi”, “Plum”}).Any() This expression returns True if the original array contains any of the values …

This solution provided by @arjunshenoy received 2 likes!

LINQ to update columns in data table

Hi @besakkiappan46, welcome to the Community. Please use the following query in the Invoke Code activity: C#: { yourDt.AsEnumerable.ToList.ForEach(row => { row("TIN") = System.Text.RegularExpressions.Regex.Match(row("TIN").ToString().Trim(), @"(\d{3})(\d{2})(\d{3})").Groups[1].ToString() + "-" + System.Text.RegularExpressions.Regex.Match(row("TIN").ToString().Trim(), @"(\d{3})(\d{2})(\d{3})").Groups[2].ToString() + "-" + System.Text.RegularExpressions.Regex.Match(row("TIN").To…

This solution provided by @Shubham_Kinge received 1 likes!

Help with activity Save as Excel fil

Hello @Ricchch Here you can do, dont provide hardcoded path. provide folder to store the file. then use for each file in folder which contains *.csv,*xls different condition. and then provide that file path to use file activity using currentfile. Hope this helps.

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 09 May 2023

Top 3 Topics with Most Views

I want to use right cell activity using counter mechanism made by @Bhushan_Nagaonkar with 59 views.

Unable extract the all the rows from web data table made by @rchin with 53 views.

Missing Excel Pross Scope made by @TOOKT with 47 views.

Top 3 Topics with Most Replies

I want to use right cell activity using counter mechanism made by @Bhushan_Nagaonkar with 23 replies.

Regex Doubt1 made by @RpaUi02 with 23 replies.

How to grouping excel data to send to API made by @Raja.G with 20 replies.

Top 3 Users Who Posted The Most

@Anil_G made 77 posts!

@Srini84 made 35 posts!

@supermanPunch made 20 posts!

Top 3 Most Liked Posts

This post made by @Raluca_Ilie received 3 likes!

Rate UiPath on G2 and Get Rewarded

Until May 15th, you can review UiPath on G2 and get rewarded with a 25$ Visa Gift Card. IMPORTANT: If your review will be approved, you will receive the gift card directly from the G2 team as a Thank You for contributing with a detailed, balanced, complete review The UiPath team is not involved in the G2 approval process for your reviews or issuing the gift cards. Please be sure to use your LinkedIn or your business email for validation. This is required by G2 to help verify your experience …

This post made by @Yoichi received 3 likes!

How can i remove this anoying message?

Hi, FYI, if you can upgrade UiPath to 23.4, the following message will be shown and we can choose “Don’t show again” [image] Regards,

This post made by @Jithesh_R received 2 likes!

Monthly Forum rewards - April 2023

Congratulations All

Top 3 Most Liked Solutions

This solution provided by @Mohammad_Irfan received 1 likes!

End of expression expected while using linq in assign

@Karthik23 write the condition in the same line

This solution provided by @supermanPunch received 1 likes!

How to select a sheet of an excel based on regex pattern

Hi @Karthik23 , From the given statements, we can understand that the word mapping appears in both sheetnames and it is in the beginning. But do we need to have a Regex ? We could also go with StartsWith. YourWbSheets.Where(Function(x)x.ToLower.StartsWith("mapping")).FirstOrDefault Do you maybe have some other sheetnames or examples where you believe regex would be more benficial ?

This solution provided by @arjunshenoy received 1 likes!

I want to save the file dynamically

Hi @Shubham_Kinge By the usage of relative path & datetime properties, you can make the file be saved dynamically by the combination of these methods: → currentDirectory = Environment.CurrentDirectory → relativePath = "Data\Output" → fileName = "yourFileName_"+Now.ToString("dd_MM_yyyy")+".yourFileExtension" → savingLocation = Path.Combine(currentDirectory, relativePath, fileName) Hope this helps, Best 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 | 10 May 2023

Top 3 Topics with Most Views

製品ドキュメントの人間翻訳版公開のお知らせ (2023 年 5 月 4 日更新確認分) made by @Naoko_Sato with 70 views.

How to convert date format from dd-mm-yyyy to MM-dd-yyyy in excel made by @sathish_Kumar6 with 48 views.

You can now use the UiPath CI/CD Pipelines made by @alexandru.iordan with 47 views.

Top 3 Topics with Most Replies

Published package not visible on UiPath assistant made by @neha.verma with 32 replies.

Write in excel sheet made by @ajindal with 21 replies.

Date format problem made by @BlueBird1 with 17 replies.

Top 3 Users Who Posted The Most

@Srini84 made 49 posts!

@neha.verma made 33 posts!

@Anil_G made 32 posts!

Top 3 Most Liked Posts

This post made by @Naoko_Sato received 4 likes!

製品ドキュメントの人間翻訳版公開のお知らせ (2023 年 5 月 4 日更新確認分)

以下のユーザー ガイドの人間翻訳版が公開されました。(2023 年 5 月 4 日更新確認分) UiPath 概要ガイド

This post made by @pavithra_pavi received 3 likes!

UiPath - Download Attachments From .Msg File | VbScript

I’m back with one more interesting topic. the topic covers handshake between #UiPath and #vbscript . Have you ever wondered how to download attachments from .Msg files.? . Check out my latest video on “How to download attachments from .MSG files” [UiPath - Download Attachments From .Msg File | VbScript]

This post made by @alexandru.iordan received 3 likes!

You can now use the UiPath CI/CD Pipelines

Automation Ops - Pipelines is now in Public Preview You can now use the UiPath CI/CD engine to automate your automations. Given you have the automation source code under source control (currently GitHub), you can set up CI/CD pipelines (as simple as building an UiPath project) to streamline your development process. Imagine the following scenario: Automation is developed in a Development environment and needs to meet certain quality checks before reaching the Production environment. The q…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

トリガースコープを複数同時に使用したい

こんにちは 例えばクリックトリガーを２つ並べて、Actionのセクションで、args.TriggerName の内容に応じて処理を振り分ければ良いかと思います。 [image]

This solution provided by @Harshith_Adyanthaya received 1 likes!

How to get values from Get Transaction Item

@mohamedalthaf Try this. Test1_Que.SpecificContent.GetValueOrDefault(“Name”).ToString Hope it helps.

This solution provided by @ppr received 1 likes!

How to get numbers before % in string using Reg Ex

regex simple: [grafik] Anchored [grafik] Assign Activity: myDouble = CDbl(System.Text.RegularExprressions.Regex.Match(strText, strPattern).Value.Trim)

---

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 May 2023

Top 3 Topics with Most Views

Filter Date column from data table made by @sneha_arbole with 48 views.

IF Object Reference not set to an instance of an object made by @jokakeekian with 46 views.

Machine unavailable made by @SA64 with 46 views.

Top 3 Topics with Most Replies

Uipath file is unable to open.. Whats the reason for this made by @Bhushan_Nagaonkar with 19 replies.

Index was outside the bounds of the array using string variables made by @guilherme_melato with 17 replies.

IF Object Reference not set to an instance of an object made by @jokakeekian with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 80 posts!

@mkankatala made 30 posts!

@arjunshenoy made 24 posts!

Top 3 Most Liked Posts

This post made by @postwick received 2 likes!

Modern click activity is not supporting in out of open browser why?

No you don’t. You should leave the application open (don’t set Use App/Browser to close it), output the app object to a variable, and use that variable as the input for another Use App/Browser in the process state. By the way, it sounds like you’re using REFramework. I recommend you don’t. It’s not for beginners. Have you taken the free training on the UiPath Academy web site?

This post made by @Anil_G received 2 likes!

Read file .msg

@andreus91 Please check this for detailed step by step guide Cheers

This post made by @Yoichi received 1 likes!

Unable to use Exchange mail activity in Windows compatability

Hi, Can you try UseOutlook365 which is included in Mail activities package? Its activities name is exchange-application-card and is designed for exchange online. https://docs.uipath.com/activities/other/latest/user-guide/exchange-application-card Regards,

Top 3 Most Liked Solutions

This solution provided by @pavithra_pavi received 1 likes!

Unable to use Exchange mail activity in Windows compatability

Here you go with screenshot [image] [image]

This solution provided by @Yoichi received 1 likes!

How to generate 25 rand numbers between 50 5000

HI, Hope the following helps you. rnd = New Random() arrRndNumber = Enumerable.Range(0,25).Select(Function(i) rnd.Next(50,5001)).ToArray() Then Sum of even numbers arrRndNumber.Where(Function(i) i mod 2 =0).Sum() Sum of odd numbers arrRndNumber.Where(Function(i) i mod 2 <>0).Sum() [image] Regards,

This solution provided by @natanael.mendes received 1 likes!

Write Cell in Google Spreadsheet for each row

This is happening because you are referencing only the column, currentrow.tostring will not bring a number. You need to put a counter to be able to increment the data insertion for each line. Counter=Counter+1 and put “B”+Counter.tostring

---

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 May 2023

Top 3 Topics with Most Views

Multiple AND Conditions made by @dutta.marina with 71 views.

Cannot modify the data type in Foreach activity made by @vishnugopal with 55 views.

Can you please help me with a project? made by @Suthari_RohithReddy with 53 views.

Top 3 Topics with Most Replies

Multiple AND Conditions made by @dutta.marina with 18 replies.

How to scrape zip code from address made by @Bot_Learner with 15 replies.

Cannot modify the data type in Foreach activity made by @vishnugopal with 13 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 29 posts!

@adiijaiin made 24 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @pavithra_pavi received 3 likes!

Read-Subject-And-Body-FromMsgFile

Im back with another video (extended session of fetching details from MSG files). In this video, i have explained how to Read Email Subject, address, body from MSG file. Check out the link below [Read-Subject-And-Body-FromMsgFile]

This post made by @Kirti_Lohokare received 2 likes!

Is it possible to create form task in foreach loop and then let user approve or reject in action center

Hi the issue has been resolved. I have converted data table into the array . Now looping through array. Meanwhile i have downgraded my packages versions. It is working fine

This post made by @Charlie_Greenberg received 2 likes!

Dev Dives: Rapidly automate APIs and build custom connectors

The Integration Service product team is happy to invite all to our May 31st, Dev Dives presentation and demos. Most Integration Service demos begin with an amazing collection of accelerators, or the contents of the Connector Catalog. Here you’ll find approximately 60 prebuilt cross-industry connectors. All API-based connectors are immediately available to help automate workflows across applications such as Salesforce, SAP, Microsoft Office 365, ServiceNow and Adobe Document Services, to name j…

Top 3 Most Liked Solutions

This solution provided by @natanael.mendes received 1 likes!

Orchestrator Queue Page Error (#199 - No Language Found.)

You can try clearing your browser’s cache, it might work.

This solution provided by @pravupada received 1 likes!

Filter Date column from data table

Hello @sneha_arbole Try this, It may help. dt.AsEnumerable.Where(Function(r) CInt(CDate(r(“Date”).ToString).DayOfWeek)>2 AndAlso CDate(r(“Date”).ToString)>DateTime.Now.AddDays(-5) AndAlso CDate(r(“Date”).ToString)<= DateTime.Now ).ToArray.copytodatatable Thanks.

This solution provided by @pcman21 received 1 likes!

Invalid HTTP request to Wedos WAPI (request is empty)

Problem solved: I had to add “request=” before and then put the JSON. I also had to add header Content-Type: application/x-www-form-urlencoded header “request={”“request”“: {”“user”“: ““pcman21@seznam.cz””, ““auth””: ““202b62bc4646281f97d225db1249840c8452dd8f””, ““command””: ““domain-create””, ““clTRID””: ““a44B””, ““data””: {”“name”“: ““example.cz””, ““period””: 1, ““dns””: “””“, ““owner_c””: ““CONTACT””, ““admin_c””: ““CONTACT””}, ““test””: 1}}” Thank you for your help.

---

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 May 2023

Top 3 Topics with Most Views

Try Catch Stucks Indefinitely made by @Axel_Albert with 74 views.

Need help with "how to click multiple checkboxes based on values in an array " made by @rathi.sham with 45 views.

How to add string data in data table made by @Aditya10989 with 42 views.

Top 3 Topics with Most Replies

Try Catch Stucks Indefinitely made by @Axel_Albert with 19 replies.

Need help with "how to click multiple checkboxes based on values in an array " made by @rathi.sham with 14 replies.

How to add string data in data table made by @Aditya10989 with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 36 posts!

@Nitya1 made 27 posts!

@Axel_Albert made 10 posts!

Top 3 Most Liked Posts

This post made by @Camila_Caldas received 2 likes!

Restrict data service entity access per folder

Thanks @Nitya1 I found a solution for what I need! Basically I want to segregate access based on entities and I realize that is possible to create a role and specify for which entity this role applies. Then you just need to assign this role to a specific user or group. I think this is a new possibility UiPath make available because last time I search for this was not there. [image]

This post made by @AndyMenon received 1 likes!

Dataservice units explanation

Hi @Camila_Caldas , It should be visible to you already. Login to Automation Cloud and: Click the Admin Icon on the left navigation bar Click the Licenses Tile on the right Click Robots & Services Tab And you should be able to see the DSU and the DSU limits. Here is a screen grab from the Automation Cloud CE. [image] I hope this helps. thanks

This post made by @AndyMenon received 1 likes!

Dataservice units explanation

I hope I have understood your question correctly. The DSU is a Service license. It can be used not just with automations but with Apps and APIs as well. If you want to know more, you can go to this page (I posted in my earlier response) and check the Services section on that page. You will see Units for all different types of Service Licenses. [image] thanks

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Dropdown Search and Select Asset Values In Orchrestrator

@private_matter You can create a UiPath app and give them instead of updating in assets that way…you can give a drop down as well In string type to give a value…there can be any value that we might want to type…restriction can be done in apps as needed for any asset you need Hope this helps Cheers

This solution provided by @Anil_G received 1 likes!

Try Catch Stucks Indefinitely

@Axel_Albert Yes mostly looks like…thats what I wanted to confirm if its stuck on sequence of throw… Glad that your issue is resolved Cheers

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 14 May 2023

Top 3 Topics with Most Views

Send attached files by mail problem made by @kawtar.ettayarssouti with 52 views.

Pasting X rows of data into SAP transaction made by @UI_SF with 38 views.

What is the fastest and stable solution for writing datatable to excel made by @mlellison with 38 views.

Top 3 Topics with Most Replies

Send attached files by mail problem made by @kawtar.ettayarssouti with 14 replies.

What is the fastest and stable solution for writing datatable to excel made by @mlellison with 10 replies.

Во вложении xlsx файл. Написать робота, который найдет в нем дублирующие строки, удалит одну из них, добавит строку «Итого» и запишет в ней сумму по оставшимся строкам made by @nikolajageev538 with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 14 posts!

@Nitya1 made 13 posts!

@kawtar.ettayarssouti made 9 posts!

Top 3 Most Liked Posts

This post made by @Ritaman_Baral received 1 likes!

Library

Who can upgrade a previously published library? When and where to use Global exception handler ? Please explain the concept also Can I use fuzzy selector on title name ? What are usage of different attributes of a selector such as idx,wbctrl etc. Please share any available link Thanks, Ritaman.

This post made by @rathi.sham received 1 likes!

Need help with "how to click multiple checkboxes based on values in an array "

Thanks to everybody for helping me out. I was going insane… Thanks again.

This post made by @rathi.sham received 1 likes!

Need help with "how to click multiple checkboxes based on values in an array "

Yes…you saved the day, I was about to lose it… Thank you so much.

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 | 15 May 2023

Top 3 Topics with Most Views

String manipulation using split function made by @RAKESH_KUMAR_Tiwari with 57 views.

Want to Compare two excel file and fill the data into this excel file but the Problem is Headings are Dynamic from one row to another how to overcome this made by @Gopikrishna_S with 55 views.

How to use LINQ different data table made by @miftah with 51 views.

Top 3 Topics with Most Replies

String manipulation using split function made by @RAKESH_KUMAR_Tiwari with 25 replies.

How do you Assign Multiple Variables from a Data Table? made by @jdavis7 with 16 replies.

Dynamic String Manipulation - Required help made by @Swetha_V with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 63 posts!

@Yoichi made 24 posts!

@LAKSHMI_NARAYANA_PEMMASAN made 23 posts!

Top 3 Most Liked Posts

This post made by @pavithra_pavi received 4 likes!

How to initialize queueitemm and assign value

Hi @gopal_ram , please try below logic TransactionItem = new QueueItem() TransactionItem.SpecificContent = New Dictionary(Of String, Object)() From {{"<your queueitem field","its value"}} NOTE : TransactionItem is of type queueitem **example : ** [image]

This post made by @pavithra_pavi received 2 likes!

Remove rows from DT which have date later than a provide date

Hello @TyraS , Try below logic. Hope it helps (From p In dt.Select() Where (From q In dt.Select() Where DateTime.ParseExact(q("Column1").tostring,"ddMMyyyy",System.Globalization.CultureInfo.InvariantCulture)<(DateTime.ParseExact(p("Column1").tostring,"ddMMyyyy",System.Globalization.CultureInfo.InvariantCulture)) Select q).toArray.count>1 Select p).ToArray.copyTodatatable() **NOTE : ** dt : is variable of type datatable “Column1” : is your date column

This post made by @arisarnado received 1 likes!

How to Use ComputerVision and OCR in an offline environment

Background: We are currently trying to use ComputerVision and OCR in an offline environment (not connected to Orchestrator). We tried to use the following guide but we were not able to make it work: UiPath version: 2022.10.07 (Enterprise License) Questions: Are there missing steps in the guide above? Is there a separate guide for setting up offline OCR?

Top 3 Most Liked Solutions

This solution provided by @pavithra_pavi received 4 likes!

How to initialize queueitemm and assign value

Hi @gopal_ram , please try below logic TransactionItem = new QueueItem() TransactionItem.SpecificContent = New Dictionary(Of String, Object)() From {{"<your queueitem field","its value"}} NOTE : TransactionItem is of type queueitem **example : ** [image]

This solution provided by @arjunshenoy received 1 likes!

Input string was not in a correct format -Get text activity

Hi @Paddi The error occurs in Activity 4 because the grant variable might not always contain a valid integer value. This issue can arise if the regular expression pattern doesn’t match any digits or if there are leading or trailing whitespaces in the extracted value. Try this to tackle the issue: For Activity 3 → Assign grant = System.Text.RegularExpressions.Regex.Match(page, "\d+(?=page)").Value.Trim() Before proceeding with the Activity 4, use an If condition to check the RegEx outcome: …

This solution provided by @ppr received 1 likes!

Error converting Int to String with LINQ

with the Field method and to String it is double converted, give a try at: DT.AsEnumerable().GroupBy(Function(r) r("Column A value").toString.ToUpper.Trim).Select(Function(s) s.First()).CopyToDataTable

---

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 May 2023

Top 3 Topics with Most Views

Json array with in Json object made by @Hazem_Saleh with 66 views.

For each loop condition made by @raju_alakuntla with 63 views.

How to add data row in same row? made by @prabin_chand1 with 62 views.

Top 3 Topics with Most Replies

I want count of total no. of transaction written in separate excel made by @Bhushan_Nagaonkar with 21 replies.

For each loop condition made by @raju_alakuntla with 20 replies.

Json array with in Json object made by @Hazem_Saleh with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 75 posts!

@adiijaiin made 35 posts!

@Yoichi made 22 posts!

Top 3 Most Liked Posts

This post made by @pavithra_pavi received 4 likes!

How to initialize a queuing element without using the orchestrator component and create fields and assign a value

Hello Everyone, Im back with a more interesting topic and problem walkthrough on UiPath is “How to initialize a queuing element without using the orchestrator component and create fields and assign a value” topic covers : 00:00 - Introduction 00:56 - develop the code 00:57 - Explain on Assign activity 01:40 - create variable 02:23 - Explain on UiPath Best coding Practices 04:38 - Initialize Transaction Item or queue item 05:45 - Create element or field and assign value check out the vi…

This post made by @Yoichi received 2 likes!

Get Text and Screen Scraping not working on Powershell screen

FYI, we can also get the text using Modern GetText with manual settings. Can you try the following steps? First, put UseApplication activity and indicate window of PowerShell. Then, get content of Selector property. [image] Next. put GetText activity and set the following items manually. Strict selector is from the above selector. [image] Finally, we can get the content. [image] Regards,

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

Throw and Rethrow

rethrow can only be put into the catch block. sometimes you may need to do some actions in the catch block before propagating the error further e.g. Try // processing steps Catch // perform certain actions e.g. update log / click on error popup etc… // rethrow to REFramework to handle exception (send email / take screenshot / update queue item ) etc…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Compare rows from two separate data tables

@Josh_James The new line characters might be different in both… Try removing from both and check …you can use replace function System.Text.RegularExpressions.Regex.Replace(str,"\s","") This will replace any space or neeline characters from string Cheers

This solution provided by @Anil_G received 1 likes!

One or more erros occured

@sathish_Kumar6 Thank you…basically int he logs it says failed in uplod files activity and as per explanation the only place upload is there in ftp… [IMG_5744] Now coming to oner or more errors…generally when this error is show inner exception would contain the exact exception details as in your case path is empty…please check why that is empty… Hope this helps Cheers

This solution provided by @mkankatala received 1 likes!

Next to each row in datatable, write number (1 , 2 , 3 and etc.)

Hi @Povilas_Jonikas Read the Excel file and store it in a datatable variable. Use Build datatable activity to create a new datatable. Map the columns in the new datatable in build datatable activity. Use for each row in datatable activity to iterate the extracted datatable. Use the add data row activity to add the data in to the new datatable. For slno column take a counter variable and give that counter variable in the add data row activity. After add data row activity increment the counter va…

---

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 May 2023

Top 3 Topics with Most Views

Extract background colour of each cell of every row made by @dutta.marina with 51 views.

Pdf automation for separating the usable page made by @Iswarya_P1 with 51 views.

For each loop error made by @suraj_gaikwad with 45 views.

Top 3 Topics with Most Replies

Extract background colour of each cell of every row made by @dutta.marina with 22 replies.

For each loop error made by @suraj_gaikwad with 19 replies.

繰り返しフロー内でLIST分スクショをとりまとめてメール本文に貼付したい made by @manchester1120 with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 118 posts!

@Nitya1 made 28 posts!

@mkankatala made 23 posts!

Top 3 Most Liked Posts

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

How to add list of string type and array of string type in uipath

Hi @tharaninatarajan1901 , You can use the .concat function [image] Regards,

This post made by @Harshith_Adyanthaya received 2 likes!

Change date and time format

Hi @redanime94 , Try this: CDate(inputDateString).ToString(“dd/MM/yyyy HH:mm”) Ex: CDate(“Wed, 17 May 2023 22:46:45 +1200”).ToString(“dd/MM/yyyy HH:mm”) [image] Hope it helps.

This post made by @vnsatyasunil received 2 likes!

Add config key/value pair:Column "value" does not belong to table datatable error in init all settings in reframework

solved. In assets sheet space is there

Top 3 Most Liked Solutions

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

How to add list of string type and array of string type in uipath

Hi @tharaninatarajan1901 , You can use the .concat function [image] Regards,

This solution provided by @Anas-p-v received 1 likes!

How would you bite this issue? (merging excel files)

Read the excel files using excel activities, and use append range activity to append content of each file to a new file

This solution provided by @Anil_G received 1 likes!

Is there anything in Uipath Marketplace that helps in Copying files from one network folder to another network folder?

@Bhagyaraj_Digumarthi For the same functionality I dont think there would be any…because it wpuld be redundant right… Or are you looking for something else? Cheers

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 18 May 2023

Top 3 Topics with Most Views

For Each Loop in 2023.4.1 made by @abhay-b with 48 views.

I have two different questions made by @Pujari_Manjunatha with 48 views.

Read pdf activites made by @RACHEL_PAUL with 46 views.

Top 3 Topics with Most Replies

Facing issue while using For Each Loop to retrieve email attachments made by @saleem_sheik1 with 24 replies.

How to compare data in a column if it matches with ADMN word should write same word in another column.Can anyone help me please it's Urgent made by @sandhyareddy with 20 replies.

How to get the row item which is associated with other column made by @geetanjali.nerlekar with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 91 posts!

@adiijaiin made 42 posts!

@Yoichi made 16 posts!

Top 3 Most Liked Posts

This post made by @pavithra_pavi received 4 likes!

How to filter datatable based on Date using LINQ

Im back with one more solution to our day to day issue in RPA programming. i.e., How to filter datatable based on Date using [#LINQ] [Filter - DataTable - Based On Date | How to convert string to Date]

This post made by @mkankatala received 2 likes!

I need to know if Cv Activities need an active screen to do automation?

Hi @YashBiswakarma When will you use the UI activities in development of the program. When the bot runs the UI element has to be appear on the screen. Weather you use in citrix applications (CV activities) or any desktop applications. Hope it helps!!

This post made by @Yoichi received 2 likes!

How to use PadLeft with Replace(",","").Replace(".","") correctly

Hi, If comma is thousand separator and dot is decimal point, the following expression might be better. Math.Floor(Double.Parse(limit,System.Globalization.NumberStyles.Any)).ToString().PadLeft(9,"0"c) [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 2 likes!

I need to know if Cv Activities need an active screen to do automation?

Hi @YashBiswakarma When will you use the UI activities in development of the program. When the bot runs the UI element has to be appear on the screen. Weather you use in citrix applications (CV activities) or any desktop applications. Hope it helps!!

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

Try-catch activity, loop breaks when don't find a match

@rathi.sham problem is you are not catching any exception hence it will break click add new catch [image] click system.exception [image] then it should work

This solution provided by @mkankatala received 1 likes!

CV Screen Scope Error while performing CV activities

Hi @YashBiswakarma The CV Screen Scope activity is used to perform computer vision operations within a specific application or window. It requires the target application or window to be in the foreground so that it can accurately capture and interact with the elements on the screen. Hope it helps!!

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 19 May 2023

Top 3 Topics with Most Views

Is there anybody who can help me in that error? made by @170290064 with 65 views.

Need 516250 from the text made by @Pujari_Manjunatha with 61 views.

How I can write combine data of three columns in new column like this made by @Swarit_Goyal1 with 49 views.

Top 3 Topics with Most Replies

Is there anybody who can help me in that error? made by @170290064 with 16 replies.

I want to extract only @gmail.com and want to remove entire data. Can anyone help me please. It's Urgent made by @sandhyareddy with 15 replies.

I'm not being able to export variable values in to data table after navigating trough each url from a csv file made by @Subhani with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 37 posts!

@arjunshenoy made 18 posts!

@Yoichi made 17 posts!

Top 3 Most Liked Posts

This post made by @Yashin_Sayed received 3 likes!

Cannot encrypt UiPath.Orchestrator.dll.config section

Hi @Lucca, We were facing a similar issue while encrypting the orchestrator.dll.config for 22.10 version. After encrypting the SecureAppSettings successfully, we were not able to encrypt ConnectionStrings. Our issue was, after initial encryption or decryption is successful, the “configsection” closing parameter position is getting misplaced in the dll.config file. So the next encryption/decryption fails saying “Object reference not set to an instance of an object” as below. [MicrosoftTeams-i…

This post made by @170290064 received 2 likes!

Is there anybody who can help me in that error?

Thanks a lot for everybody. Problem is solved Like i said i am the beginning of that journey. I appreciate all answers and huge respect for @Yoichi and thanks @Parvathy @fernando_zuluaga . I know i am new in this area but i believe that i am a quick learner. All the best with you all

This post made by @Swarit_Goyal1 received 1 likes!

How I can write combine data of three columns in new column like this

Can you guide how I can use this approach, If possible please upload xaml

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Add columns in data table

Hi, Can you try the following? [image] io_dtModifiedExtractedFile.Columns("NewRowNo").SetOrdinal(3) io_dtModifiedExtractedFile = io_dtModifiedExtractedFile.AsEnumerable.Select(Function(r) io_dtModifiedExtractedFile.Clone.LoadDataRow({r(0),r(1),r(2),Cint(r(2))+2,r(4),r(5),r(6)},False)).CopyToDataTable() Sample20230512-3.zip (15.3 KB) Regards,

This solution provided by @natanael.mendes received 1 likes!

Orchestrator doesnt load

maybe your local time is wrong and this is conflicting with your orchestrator

This solution provided by @fernando_zuluaga received 1 likes!

How to remove or no fill an excell cell color?

Hi @Suastrian_Dika Give a try using the Format Cells Activity [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 | 20 May 2023

Top 3 Topics with Most Views

Add Column in data table with modified value made by @ashwini.mali with 40 views.

Capture the element in the children window made by @jackie.yue with 37 views.

Read range(Settings and Constants sheets) made by @170290064 with 34 views.

Top 3 Topics with Most Replies

Add Column in data table with modified value made by @ashwini.mali with 20 replies.

Read range(Settings and Constants sheets) made by @170290064 with 17 replies.

Orchestration Process (Foreground and Background issue) made by @anusha2 with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 22 posts!

@ushu made 19 posts!

@Yoichi made 16 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 1 likes!

How to Merge cells and sum values if rows are same

Hi, Hope the following sample helps you. [image] dt = dt.AsEnumerable.GroupBy(Function(r) r("Name").ToString).Select(Function(g) dt.Clone.LoadDataRow({g.Key,g.First()(1),g.First()(2),g.Sum(Function(r) CInt(r("Amount")))},False)).CopyToDataTable Sample20230520-4L.zip (7.0 KB) Regards,

This post made by @Anil_G received 1 likes!

How to Merge cells and sum values if rows are same

@sathish_Kumar6 Read the data in to a datatable dt…now use below in the assign activity Use Build datatable activity with outdt and 4 columns as strings outdt = (From d In Dt.AsEnumerable() Group d By k=d("Name").toString.Trim Into grp = Group Let gSum =grp.Sum(function(x) CDBL(x("Amount").ToString).ToString Let ra = New Object(){k,grp.FirstOrDefault(1).ToString, grp.FirstOrDefault(2).ToString,gSum} Select r = outDt.Rows.Add(ra)).CopyToDataTable() Cheers

This post made by @Yoichi received 1 likes!

Read range(Settings and Constants sheets)

Hi, This error shows Config.xlsx is already opened. So, can you try either of the following? Use UseExcelFile and RearRangeX instead of ReadRangeWorkbook. or Close Config.xlsx before the ReadRangeWorkbook. Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to Merge cells and sum values if rows are same

Hi, Hope the following sample helps you. [image] dt = dt.AsEnumerable.GroupBy(Function(r) r("Name").ToString).Select(Function(g) dt.Clone.LoadDataRow({g.Key,g.First()(1),g.First()(2),g.Sum(Function(r) CInt(r("Amount")))},False)).CopyToDataTable Sample20230520-4L.zip (7.0 KB) Regards,

This solution provided by @Anil_G received 1 likes!

Could not Download Attachments from Gmail

@TienGiang Please check the retrieve attachments property in the for each email activity [IMG_5776] Hope this helps Cheers

This solution provided by @Yoichi received 1 likes!

Read range(Settings and Constants sheets)

Hi, First set empty at Range property of ReadRange [image] Next, the following OrchestratorQueueFolder data causes error. For now can you try to set empty? [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 | 21 May 2023

Top 3 Topics with Most Views

Uipath sort file names based on alpha numberic names made by @mihir.s.bandodkar with 38 views.

Move file functionality failing in latest version 2023.4.1 made by @alok.verma with 37 views.

Get Current ticket sysid in uipath made by @Kalki with 32 views.

Top 3 Topics with Most Replies

Having trouble downloading zip files to my windows machine from UiPath Learning plans made by @katieward02 with 8 replies.

リスト型変数の重複削除について made by @AAAbbb with 7 replies.

Get Current ticket sysid in uipath made by @Kalki with 6 replies.

Top 3 Users Who Posted The Most

@katieward02 made 6 posts!

@Nitya1 made 5 posts!

@Kalki made 4 posts!

Top 3 Most Liked Posts

This post made by @HANACCHI received 1 likes!

リスト型変数の重複削除について

代入アクティビティ 左辺 結果を格納するlist型変数 右辺 重複削除したい変数.Distinct() でどうでしょう？

This post made by @Yoichi received 1 likes!

リスト型変数の重複削除について

こんにちは 以下お試しください listVar = listVar.Distinct().ToList()

This post made by @Nitya1 received 1 likes!

リスト型変数の重複削除について

Hi @AAAbbb Can you try this- List myList = new List { “A”, “B”, “C”, “A”, “A” }; List distinctList = myList.Distinct().ToList(); Thanks!!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

リスト型変数の重複削除について

こんにちは 以下お試しください listVar = listVar.Distinct().ToList()

---

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.