Forum Engagement Daily Reports

[system]

Daily Forum Report | 19 June 2021

Top 3 Topics with Most Views

Searching string with case insensitive made by @kavya_mamidishetti with 43 views.

How to get all values from datatable except the mentioned value made by @Prince1 with 35 views.

Powershell usage? made by @Felipe_Kotinda with 28 views.

Top 3 Topics with Most Replies

How to convert IEnumerable<FtpObjectInfo> into a datatable made by @kduvvuri with 7 replies.

How to get all values from datatable except the mentioned value made by @Prince1 with 5 replies.

Assign file date with wildcard? made by @erik1 with 5 replies.

Top 3 Users Who Posted The Most

@Subhas_Malik made 5 posts!

@NIVED_NAMBIAR made 4 posts!

@kumar.varun2 made 4 posts!

Top 3 Most Liked Posts

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

Concat multiple column data into another column through linq

assuming your datatable variable is called dt a. use add data column activity to add data column called Col6 (if it doesnt exist) b. use invoke code click edit arguments and add in/out argument dt [image] then click edit code and paste this dt.AsEnumerable().ToList().ForEach(Sub(row) row("Col6")= row("Col1").ToString+row("Col2").ToString+row("Col4").ToString+row("Col5").ToString) this will set Col6 = col1+col2+col4+col5

This post made by @RGudi received 1 likes!

Lesson 9 - Filter Wizard not filtering data table as expected

Late reply but I have just joined the RPA community. This may help for any future user encountering the issue. This problem has been resolved in Modern Design Experience. You can change the data format using Extract Data Table wizard available in Modern design Experience. So filtering on integers is direct and no more workarounds needed. Hope this helps.

This post made by @aparna3010 received 1 likes!

I want to add amt col and do the calculation as amount=mrp-SchemeDiscAmt-LotDisc and also remove total row at the end

Thank you sooo Much!! It Means a lott to me!!Thanks a ton!!

Top 3 Most Liked Solutions

This solution provided by @asgRPA received 1 likes!

When filling in excel only write (overwrite) in the first line

Hi, In your while loop you are restarting the TablaDatosCreada for every iteration. This implies nothing remains stored in your data table. The solution is to move that Build Data Table activity outside the while loop.

---

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 June 2021

Top 3 Topics with Most Views

Take a specific piece of text and the page it is on, from a PDF file made by @Araceli91 with 30 views.

Need Help:Yearly Generate report for vendor made by @Priyanka_Jadhav with 25 views.

PDF Invoice data Extraction Problem made by @ranaprathap928 with 25 views.

Top 3 Topics with Most Replies

PDF Invoice data Extraction Problem made by @ranaprathap928 with 18 replies.

Take a specific piece of text and the page it is on, from a PDF file made by @Araceli91 with 8 replies.

How to Add dynamique number of rows to Auto fill Range activity made by @Soudios with 7 replies.

Top 3 Users Who Posted The Most

@ranaprathap928 made 9 posts!

@prasath17 made 8 posts!

@Krishna_547 made 7 posts!

Top 3 Most Liked Posts

This post made by @Srini84 received 1 likes!

Extract each text between parentheses

@malak_s You can use Regex for this scenario Check below for your reference [image] sampleString = YourString use Assign sampleString = System.Text.RegularExpressions.Regex.Replace(sampleString,"[(]|[)]","") This will trim down the () brackets use Assign sampleString = System.Text.RegularExpressions.Regex.Replace(sampleString,"[-]|[+)]"," ") This will search for - and + and replace with space Hope this may help you Thanks

This post made by @malak_s received 1 likes!

Extract each text between parentheses

Thank you, I think I will do that

This post made by @MrKezay received 1 likes!

I don't want to add some columns in Excel to the table

This is how I did the solution but forgot to write it here. Thank you @Krishna_547

Top 3 Most Liked Solutions

This solution provided by @Srini84 received 1 likes!

Extract each text between parentheses

@malak_s You can use Regex for this scenario Check below for your reference [image] sampleString = YourString use Assign sampleString = System.Text.RegularExpressions.Regex.Replace(sampleString,"[(]|[)]","") This will trim down the () brackets use Assign sampleString = System.Text.RegularExpressions.Regex.Replace(sampleString,"[-]|[+)]"," ") This will search for - and + and replace with space Hope this may help you Thanks

This solution provided by @Krishna_547 received 1 likes!

I don't want to add some columns in Excel to the table

Hi , clone the original dt to another and remove the columns in the duplicate dt to send email and after that use the original dt for further operations.

---

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 June 2021

Top 3 Topics with Most Views

「呼び出しのターゲットが例外をスローしました。」 made by @miwa_yamamoto with 32 views.

How to detect a select menu is blank made by @BlakeSmith with 32 views.

When will UiPath solve the Type Into % bug? made by @Roman_hruska with 31 views.

Top 3 Topics with Most Replies

Unable to install the UiPath Studio through UiPathStudioSetup file made by @shailendra.jyoti with 17 replies.

Linq query to update End date with next line start date -1 made by @Aravinthan with 10 replies.

「呼び出しのターゲットが例外をスローしました。」 made by @miwa_yamamoto with 9 replies.

Top 3 Users Who Posted The Most

@ppr made 16 posts!

@postwick made 15 posts!

@Yoichi made 14 posts!

Top 3 Most Liked Posts

This post made by @LevKushnir received 2 likes!

BAPI Functionality in UI Path

hi @abdel See more in post 46 above. This was done by @gabi_verzea and shows the full journey from Zero to the automation https://forum.uipath.com/t/bapi-functionality-in-ui-path/84739/46?u=levkushnir additionally check this video, where UiPath Accelerators for SAP are used to speed up the implementation https://www.youtube.com/watch?v=YJ8mcy-Ci04 Learn more in the full webinar UiPath Accelerators for SAP : https://start.uipath.com/immersion-lab-jumpstart-sap-automation.html

This post made by @Haenneler received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, my name is Luca. I work with UiPath and RPA almost two years. This forum has already helped me a lot during my journey so thank you a lot.

This post made by @StefanSchnell received 2 likes!

How to Copy Data from SAP Table into SQLite DataBase

At the UiPath DevCon I had a very interesting discussion in the AMER room about the possibility to copy data from an SAP table directly into an SQLite database. The advantage of such an approach is that the data model of the SQLite database prevents inconsistent data. Furthermore, the standard query language SQL can be used. Based on my post about building your own SQLite package, here two Invoke Code Activity routines that can be used to transfer tables directly from SAP into an SQLite database…

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

How to implement dynamic IDX using the loops index?

https://forum.uipath.com/t/how-to-use-variables-in-selectors-in-studio-dynamic-selectors-without-string-manipulation/154110

This solution provided by @ppr received 2 likes!

Problem with datetime.ParseExact() - Portugal

it was asked as your used format string was not matching the input format. Have a look below: [grafik]

This solution provided by @Yoichi received 1 likes!

「呼び出しのターゲットが例外をスローしました。」

こんにちは データを直接確認するのではなく、 RowsプロパティのCountを確認してみてください [img20210621-1]

---

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

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

[system]

Daily Forum Report | 22 June 2021

Top 3 Topics with Most Views

IEのサポート終了 made by @komasuda with 42 views.

Checking data types of columns of datatable made by @WASEEM_KHAN with 30 views.

Max length problem with column made by @sayali_rokade with 28 views.

Top 3 Topics with Most Replies

Convert datatable to collection by validating values made by @JavXult with 14 replies.

Max length problem with column made by @sayali_rokade with 10 replies.

Checking data types of columns of datatable made by @WASEEM_KHAN with 9 replies.

Top 3 Users Who Posted The Most

@Cristian_Negulescu made 20 posts!

@ppr made 17 posts!

@NIVED_NAMBIAR made 15 posts!

Top 3 Most Liked Posts

This post made by @ermanoj3101 received 3 likes!

Where can I find UiPath AI fabric courses in UiPath academy?

You will find it in academy.uipath.com. Inside courses you will find it as AI Center (Previously known for AI Fabric)

This post made by @prasath_S received 3 likes!

Checking data types of columns of datatable

Hi @WASEEM_KHAN Please try this to find the column type of 2nd column dtTable.Columns(1).DataType.ToString [image] finding datatype of 2 columns [image] [image] Thanks

This post made by @ppr received 3 likes!

Checking data types of columns of datatable

As an variation for report retrieval: [grafik]

Top 3 Most Liked Solutions

This solution provided by @ermanoj3101 received 3 likes!

Where can I find UiPath AI fabric courses in UiPath academy?

You will find it in academy.uipath.com. Inside courses you will find it as AI Center (Previously known for AI Fabric)

This solution provided by @rfu received 2 likes!

ポップアップのボタンがクリックできない

こんにちは。 ひょっとするとアプリの作り的に、親ウインドウの「登録」ボタンクリック時に 処理されるイベントの中に 子ウインドウが表示されて「OK」ボタンをクリックされて消える・・という処理が 含まれているのかもしれませんね。 「並列」アクティビティを使って、その中の左側に親ウインドウの登録ボタンクリック、右側に子ウインドウのOKボタンクリックイベントを配置してみたらうまくいったりしないでしょうか。

This solution provided by @Hiba_B received 1 likes!

Getting error - Move File: Could not find file 'E:\Folders_To_Move_Source'

Hi @Chinmay_Bhalerao ! To move the file by using Move file activity, you need to indicate file paths not folder paths. For instance, let’s say you have an excel file named “A.xlsx”, you need in the from section to write: “E:\Name of the source folder\A.xlsx” in the to section to write: “E:\Name of the output folder\A.xlsx” So in your situation, you have to write: in the from: item in the to: "E:\Folders_To_Move_Source\" + Path.Getfilename(item)

---

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

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

[system]

Daily Forum Report | 23 June 2021

Top 3 Topics with Most Views

グラフ作成について made by @miwa_yamamoto with 30 views.

IEnumerable<string>にキャストしたい made by @196006 with 29 views.

Get Outlook message Filter email made by @mosa_sleeman with 28 views.

Top 3 Topics with Most Replies

Failed to convert parameter value from a Double to a DateTime - Insert DB made by @AaronMark with 14 replies.

Extract only specific data from notepad made by @Christin_John with 10 replies.

Dynamic fuzzy selectors made by @pari_patel with 9 replies.

Top 3 Users Who Posted The Most

@ppr made 14 posts!

@Yoichi made 13 posts!

@Christin_John made 10 posts!

Top 3 Most Liked Posts

This post made by @Sophia_Zhylych received 2 likes!

What's new on UiPath Marketplace in 21.4

Hi Nithin, Thanks for the feedback, glad you like the updates Marketplace monetization is targeted for 21.10 release.

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

Click activity questions

lets say base height = 100 and the width between each checkbox is 20, and you want to click the 3rd checkbox then y= 100+(20x2), if you want to click the 2nd checkbox then y=100+(20x1) i attached a workflow here image.zip (32.7 KB), you need open https://aws1.discourse-cdn.com/uipath/original/3X/4/3/4381d132f8f50a51059271a2890891d4dac84fdd.jpeg before you run it and set the checkboxIndex, e.g. if you want to click 3rd checkbox, set checkboxIndex = 2, if you want to click 1st checkbox, set che…

This post made by @HANACCHI received 2 likes!

Excelファイル名に日付を追加しフォルダ保存方法

“交通費検索" & Now.ToString(“yyyyMMdd”) & ”.xlsx" でどうでしょう？

Top 3 Most Liked Solutions

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

Click activity questions

lets say base height = 100 and the width between each checkbox is 20, and you want to click the 3rd checkbox then y= 100+(20x2), if you want to click the 2nd checkbox then y=100+(20x1) i attached a workflow here image.zip (32.7 KB), you need open https://aws1.discourse-cdn.com/uipath/original/3X/4/3/4381d132f8f50a51059271a2890891d4dac84fdd.jpeg before you run it and set the checkboxIndex, e.g. if you want to click 3rd checkbox, set checkboxIndex = 2, if you want to click 1st checkbox, set che…

This solution provided by @HANACCHI received 2 likes!

Excelファイル名に日付を追加しフォルダ保存方法

“交通費検索" & Now.ToString(“yyyyMMdd”) & ”.xlsx" でどうでしょう？

This solution provided by @prasath17 received 1 likes!

Convert special DateFormat into dd/MM/yyyy

@Mr.H - Please try this… [image] DateTime.Parse("Apr 5 2021 12:00AM").tostring("dd/MM/yyyy")

---

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

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

[system]

Daily Forum Report | 24 June 2021

Top 3 Topics with Most Views

Regex to extract data ahead of text made by @AhmedKutraphali with 59 views.

Linq Query with Dt made by @Spark_robot with 55 views.

Can we create multiple empty data table dynamically? made by @Slavia_Monteiro with 52 views.

Top 3 Topics with Most Replies

Extract excel info, search this on web page and click in the right button made by @Prayste with 16 replies.

Regex to extract data ahead of text made by @AhmedKutraphali with 12 replies.

Linq Query with Dt made by @Spark_robot with 10 replies.

Top 3 Users Who Posted The Most

@ppr made 15 posts!

@NIVED_NAMBIAR made 14 posts!

@Yoichi made 13 posts!

Top 3 Most Liked Posts

This post made by @sandeep.tech2009 received 3 likes!

Announcing UiPath HyperHack - #AutomationForGood Winners!

Can we have videos uploaded to show a glimpse of workflows the winning teams created?

This post made by @Yoichi received 3 likes!

Can we create multiple empty data table dynamically?

Hi, How about the following? listDt = Enumerable.Range(0,10).Select(Function(x) New DataTable()).ToList() or listDt = Enumerable.Range(0,10).Select(Function(x) templateDt.Clone).ToList() Regards,

This post made by @Catalina_Rs received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi! I am Catalina and I have been working with UiPath tools for 2 years. I hope I can offer at least a part of the help I’ve received from this forum in my automation projects.

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

How to get the particular value from excel

lets assume the excel is readin into a datatable with read range we can use e.g. Regex to ectract the Fax No Simple Approach: [grafik] Anchored on FAX Token [grafik] For regex also have a look here:

This solution provided by @NIVED_NAMBIAR received 1 likes!

Linq Query with Dt

Hi @Spark_robot you can try this way Read your excel and store in dt1 variable Now use invoke code activitu with argumnet as dt1 as In/Out direction. Code to be used dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“Source”)= If(row(“Mail Subject”).ToString.Contains(“QBO”),“QBO”,“Email”)) Then use write range to write the dt1 into the excel Regards, Nived N Happy Automation

This solution provided by @prasath17 received 1 likes!

Regex to extract data ahead of text

@AhmedKutraphali - Please check this… https://regex101.com/r/v0y6X8/1/ [image] Covered all the 3 variations here. Regex returns 2 matches.

---

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

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

[system]

Daily Forum Report | 25 June 2021

Top 3 Topics with Most Views

Extract two values using Regex made by @Dev2 with 46 views.

UiPathって重いのですか？ made by @Tory with 38 views.

Excel内でサーチしてセルを黄色にしたい made by @196006 with 33 views.

Top 3 Topics with Most Replies

Combined data tables with no reference column made by @wth1993 with 14 replies.

Compare two tables and add column made by @markosc with 12 replies.

Extract two values using Regex made by @Dev2 with 9 replies.

Top 3 Users Who Posted The Most

@ppr made 19 posts!

@prasath_S made 8 posts!

@markosc made 7 posts!

Top 3 Most Liked Posts

This post made by @196006 received 2 likes!

Excel内でサーチしてセルを黄色にしたい

N2027様 ご指導ありがとうございます。 早速使わせていただきました。

This post made by @NIVED_NAMBIAR received 2 likes!

PDF data formatting

Hi @sayali_rokade To learn regex, there is good post in forum made by regex champion @Steven_McKeering Sharing the link here You will find this useful for learning regex Regards, Nived N Happy Automation

This post made by @CristianDan received 1 likes!

Conversion to Base64 format

Hey @dubeychanan, i was looking earlier to do the same thing and based on what i saw in @Cristian_Negulescu video i did it like this. I used only Assign activities in order to keep it simple and i managed to convert images, pdf’s and docx to Base64. I attached the sequence in case you or someone else will need it in the future. [image] ConvertImagePathToBase64String.zip (1.4 KB) Cheers! Cristi

Top 3 Most Liked Solutions

This solution provided by @Surya_Narayana_Korivipadu received 1 likes!

Extract two values using Regex

ok. Assume that you have saved outputs of your matches activities in variables called “Names” and “Numbers” respectively. For each name in Names, if name.tostring().equals(“Olive”), then you can get respective number with Numbers(Index). See below screenshot: [image] As you want number for Olive, you need to do this. Or else, for loop is not needed. Hope this helps you. Let me know if you still have any doubts.

This solution provided by @Catalina_Rs received 1 likes!

How to separate value of same cell but different row into respective cell?

Hi! In sheet1 was the processed data table after the run. I have modified the flow and I left sheet1 with your dt as shown in the example so you can test it. In the case of ALT+Enter separator it is used vbLF to identify it. vbLF is a constant. The new flow contains vbLF as identifier for the multiple value row. I have explained the steps in the attached workflow. SplitRow.zip (29.1 KB)

This solution provided by @N2027 received 1 likes!

Excel内でサーチしてセルを黄色にしたい

以下のアクティビティで簡単にできそうです。 ・範囲内で検索 （セル範囲が取得できます。） ・範囲の色を設定 [image]

---

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

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

[system]

Daily Forum Report | 26 June 2021

Top 3 Topics with Most Views

Writing HTML text to Word document made by @Faraz_Subhani with 37 views.

Why my UIpath Studio icon looks different made by @30f3f2f862699c8f0019492ed with 22 views.

GSuiteアプリケーションスコープ内でのエラー made by @poke with 21 views.

Top 3 Topics with Most Replies

https://forum.uipath.com/t/325578 made by @Ashwin_Swain with 10 replies.

I am getting error when using .key and .value in message box to output the dictionary made by @VIKAS_PANDEY282 with 7 replies.

Dynamic selector not working - test file/Oracle form made by @Thunder with 7 replies.

Top 3 Users Who Posted The Most

@Raghavendraprasad made 9 posts!

@kunalhore2891 made 7 posts!

@Haytam_Mostaine made 6 posts!

Top 3 Most Liked Posts

This post made by @NIVED_NAMBIAR received 1 likes!

I am getting error when using .key and .value in message box to output the dictionary

Hi @VIKAS_PANDEY282 I hope you are using for each to loop through the dictionary and winner is the current item through which u are iterating If yes , can u let me know what is the argument type of for each u had provided

This post made by @VIKAS_PANDEY282 received 1 likes!

I am getting error when using .key and .value in message box to output the dictionary

[dictionary] dictionary name is winnerlist of type(string,int32)

This post made by @VIKAS_PANDEY282 received 1 likes!

I am getting error when using .key and .value in message box to output the dictionary

Yes you are correct , Argument for each loop is dictionary <string ,int32>

Top 3 Most Liked Solutions

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

---

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

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

[system]

Daily Forum Report | 27 June 2021

Top 3 Topics with Most Views

How to check if an item exist in a saved list in excel? made by @aoladipupo with 32 views.

Getting this error, Can anyone help me? made by @Chinmay_Bhalerao with 31 views.

Email Approve| Reject validation made by @Vincent_Nuestro with 24 views.

Top 3 Topics with Most Replies

Reframework 資格情報を取得: You are not authenticated! Error code: 0 のエラーで止まってしまいます。 made by @1111060 with 9 replies.

Email Approve| Reject validation made by @Vincent_Nuestro with 4 replies.

Recognizing special format of dates and compare the difference of dates made by @wth1993 with 4 replies.

Top 3 Users Who Posted The Most

@Ashwin_Swain made 9 posts!

@Nithinkrishna made 6 posts!

@Divyanshu_Divyanshu made 5 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Special Topics Topic LINK Data Grouping and Group member Processing [HowTo] Overview on different options for grouping data and processing the groups Duplication Retrieval with SequenceEqua…

This post made by @ppr received 2 likes!

[HowTo] - Exploring the LINQ Universe (VB.Net)

LINQ (Language-Integrated Query) is part of the .NET framework and offers capabilities for interacting with data, objects or other sources within a particular syntax. This HowTo elaborates on the availabilty of LINQ and exploring the offered functionalities Current Version of this topic is DRAFT and will be finalized / enhanced soon Introduction Lets recap the Example of LINQ from [HowTo] - First Start with LINQ (VB.Net). Sample data: myNumbers | List (Of Int32) = {12,34,5,8,10,2,15,7}.toL…

This post made by @Nithinkrishna received 1 likes!

Outputting Values from Orchestrator for the customer

Hi @jordrowley That’s quite interesting scenario. Thanks for posting it over forum. Yes it’s possible to scrape, But there is a bit better way of doing it via background. We have something called orchestrator API which enables a programmatic interaction with orchestrator resources. Access it through your <orchestrator link>/swagger Coming to the licensing part, [image] This may help you. Thanks #nK

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Outputting Values from Orchestrator for the customer

Hi @jordrowley That’s quite interesting scenario. Thanks for posting it over forum. Yes it’s possible to scrape, But there is a bit better way of doing it via background. We have something called orchestrator API which enables a programmatic interaction with orchestrator resources. Access it through your <orchestrator link>/swagger Coming to the licensing part, [image] This may help you. Thanks #nK

---

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

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

[system]

Daily Forum Report | 28 June 2021

Top 3 Topics with Most Views

If anybody could help in selecting the Time Range in a dropdown as mentioned below according to system time (7-8pm if 7.30pm is time of system)? made by @anjasing with 43 views.

Email Approve and Reject Validation made by @Vincent_Nuestro with 34 views.

HAA - Multi Node with Azure VMs (Minimal Setup) made by @JithinKP with 30 views.

Top 3 Topics with Most Replies

Error: Object reference not set to instance of an Object while Getting Value from Web made by @skg_161125 with 21 replies.

🎉 ppr 1000th Solution Flag Celebration made by @Yoichi with 12 replies.

If anybody could help in selecting the Time Range in a dropdown as mentioned below according to system time (7-8pm if 7.30pm is time of system)? made by @anjasing with 11 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 39 posts!

@Yoichi made 20 posts!

@prasath17 made 18 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 10 likes!

ppr 1000th Solution Flag Celebration

@ppr Congratulations on your 1000th Solution Flag! [1ksolutions] Many members of the forum were helped! Thank you for a lot of great contributions to the community!!!

This post made by @JithinKP received 6 likes!

HAA - Multi Node with Azure VMs (Minimal Setup)

Hi, I was trying to create this multi-node setup in Azure for sometime now. Thought I will consolidate and share it with you guys the working version I could deploy. This is a test setup and you can try it out in Azure to get an idea about multi-node setup. Let me know your thoughts and feedback’s. Primary Requirement An active Pay-As-You-Go Azure subscription Architecture [Drawing-6] System Requirements [Screenshot 2021-06-23 at 12.45.27 PM] License Requirements [Screenshot 2021-06…

This post made by @ppr received 3 likes!

ppr 1000th Solution Flag Celebration

Thank you for the congratulations. It is an honor for me to be mentioned by you @Yoichi . I would like to thank all the forum members for the joint work and the opportunity to collaborate on the various tasks. It makes me happy to see how we help each other and move forward. I am already looking forward to the next time together. Let’s keep rocking UiPath RPA. A special thanks to the UiPath team and their hard work that makes this all possible. @loginerror @pablito @Vibhor.Shrivastava Many gr…

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

How to give a time range of 8-9pm to a time like 8.30 pm (for 10.57 pm time range should be 10-11pm)?

@anjasing - How about this… "Today, " +now.tostring("h:00 tt") + " - " + now.AddHours(1).tostring("h:00 tt") [image] Above logic will automatically add hours from the current time and identifies the PM and AM…Because if the time is 11 am then we have to add 11 am - 12 PM…similarly if its 11 PM then 11PM - 12 AM… Please try and let me know…

This solution provided by @Catalina_Rs received 2 likes!

Find last column in excel?

Hi @fairymemay I found a similar topic. You can check if the info helps you. I have used Convert.ToChar(Convert.ToUInt16("A"c)+3) from that link for a similar situation. You can replace 3 with the code written above for last column.

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

Having trouble in adding a photo in the middle of the mail body in Send Outlook Activity

Drag and Drop the activity in workflow. [image] Click on Open Editor [image] Type in the mail or copy paste the mail text. To insert the image click on add image icon [image] There will be three options. Select the insert now option and click on OK. Your image will be added [image]

---

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

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

[system]

Daily Forum Report | 29 June 2021

Top 3 Topics with Most Views

引数の受け渡しについて made by @Y_M_12 with 50 views.

重複する値を条件分岐で削除したいです。 made by @ATSUKO_TANAKA with 45 views.

I need to extract all the details from invoices pdf and line item describtion quantity and all the fields and i need to do this for all pdf files in the folder made by @aparna3010 with 36 views.

Top 3 Topics with Most Replies

Having problems when receiving the photo in the middle of the mail body from Outlook activity made by @Gokul001 with 22 replies.

I need to extract all the details from invoices pdf and line item describtion quantity and all the fields and i need to do this for all pdf files in the folder made by @aparna3010 with 20 replies.

Filter the Excel Data, and then paste the same on Outlook email body made by @shrayud with 15 replies.

Top 3 Users Who Posted The Most

@Surya_Narayana_Korivipadu made 20 posts!

@Yoichi made 16 posts!

@ppr made 13 posts!

Top 3 Most Liked Posts

This post made by @prasath_S received 3 likes!

How to delete a row in a data table if row has any empty cells in it

Hi @Abhi15 Please Try this dtTable - datatable dtTable = dtTable.AsEnumerable.where(Function(row) row.ItemArray.All(function(col) not string.IsNullOrEmpty(col.ToString))).CopyToDataTable Thanks

This post made by @Yoichi received 2 likes!

In Uipath Studio, Input a number and check positive negative or zero using switch case

Hi, Hope the following helps you. [img20210629-3] Note: in this case, result is string type. Regards,

This post made by @Srini84 received 2 likes!

Move file?

@fairymemay Set the path as C:\other usecase\output2 and destination path as “c:\data old” + Now.ToString(“dd.MM.yyyy”) Now use Invoke method and select Target type as System.IO.Directory Method Name as Move Parameters give the source path and Destination Path [image] Hope this may help you Thanks

Top 3 Most Liked Solutions

This solution provided by @prasath_S received 3 likes!

How to delete a row in a data table if row has any empty cells in it

Hi @Abhi15 Please Try this dtTable - datatable dtTable = dtTable.AsEnumerable.where(Function(row) row.ItemArray.All(function(col) not string.IsNullOrEmpty(col.ToString))).CopyToDataTable Thanks

This solution provided by @Yoichi received 2 likes!

In Uipath Studio, Input a number and check positive negative or zero using switch case

Hi, Hope the following helps you. [img20210629-3] Note: in this case, result is string type. Regards,

This solution provided by @sonaliaggarwal47 received 1 likes!

How to pass secure string to a sharepoint activity

Hi guys, There is another version 1.7.0 available for UiPathTeam.SharePoint.Activities which provides a way to connect using secure password and is working fine for upload and other activities. So this can be utilized. Thanks to @radu_bucur and team for enhanced version of this package Also, “UiPath.MicrosoftOffice365.activities” can be utilized to connect to sharepoint or any other office 365 apps in a secure way. However, for this one, you might have to dig a little more on h…

---

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

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

[system]

Daily Forum Report | 30 June 2021

Top 3 Topics with Most Views

How to get file type from fileinfo datatype made by @cody.barber with 32 views.

Chromeが複数立ち上がっていた時の閉じ方 made by @Y_M_12 with 32 views.

Excel used by another process cannot access error made by @supu123 with 31 views.

Top 3 Topics with Most Replies

Passing Json body in HTTP request not working made by @thima with 23 replies.

Cannot Trigger UiPath Robot after Update to UiPath Assistant in VDI made by @Weicheng with 15 replies.

Delete txt file row character starting with ! and use "Text to column" with delimiter! made by @li.yu with 12 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 23 posts!

@NIVED_NAMBIAR made 19 posts!

@kumar.varun2 made 14 posts!

Top 3 Most Liked Posts

This post made by @Dana_Mustatea received 6 likes!

Rate UiPath on ITCS and get rewarded with a 50 USD Visa Gift Card

I would kindly ask for your support, we’re currently running a campaign with [ITCS], each approved review will be rewarded with a 50 USD Visa Gift Card. If you have the availability for a short call, with the guys from ITCS, it would be much appreciated. The process will be like that: • Interviews/ reviews - This will take place via a phone call. (Calendly link here All you need to do is schedule a time that works, next one. ITCS will take care from there, assuming 20 minutes for all the proc…

This post made by @Taeko_UiPath received 3 likes!

【UiPathアカデミー】（6月分新規）UiPath Test Suite 基礎コース

平素より、UiPathアカデミーをご愛顧いただき誠にありがとうございます このたび、UiPath Test Suite 基礎コースをリリースしましたのでお知らせいたします このコースでは、テストの必要性、迅速なデリバリーを実現するための組織体制、 テスト自動化における必須知識から UiPath Test Suite の基礎知識と主要機能について学習できます ※リンクが遷移しない場合は、ブラウザを一度閉じクッキーとキャッシュをクリアしてください UiPath 製品に関する知識の拡充にお役に立てればと思います ぜひ、UiPath アカデミーをご活用くださいませ 引き続きよろしくお願いいたします

This post made by @cgtruck69 received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello My name is Boule and i did my first robot today very exciting experience

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

How to get file type from fileinfo datatype

@cody.barber - please check this activity… Here is the output I got(See the highlighted text) [image] Hope this helps…

This solution provided by @Srini84 received 2 likes!

If conditon SAP

@Markus3003 if there is sth to download then the button you highlighted is enabled, Is it this your case? If so you can use Element Exist and check whether the button is enable Hope this may help you Thanks

This solution provided by @amalmarella received 1 likes!

-1 day from string?

testtt.xaml (14.5 KB) can you check

---

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

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

[system]

Daily Forum Report | 01 July 2021

Top 3 Topics with Most Views

How to compare 2 columns, if the 2 columns have same data then entire row has to removed made by @Manisree_Parasa with 55 views.

Grouping and eliminating excel columns made by @Meyammai with 45 views.

Extracting JSON string from dynamic text made by @Sonalk with 44 views.

Top 3 Topics with Most Replies

This is the datatable from which I want to retrieve Sales Order number with FAIL status? if anyone can help? made by @anjasing with 16 replies.

How to compare 2 columns, if the 2 columns have same data then entire row has to removed made by @Manisree_Parasa with 10 replies.

Adding values with loop to a data table - data table is not getting updated made by @Lior_Ben_Naim with 10 replies.

Top 3 Users Who Posted The Most

@Srini84 made 24 posts!

@ppr made 13 posts!

@anjasing made 11 posts!

Top 3 Most Liked Posts

This post made by @prasath17 received 2 likes!

Use regex in notepad?

@fairymemay - Read the data.txt using “Read text file” activity and save the output Say StrInput Then using the Matches activity as shown below… [image] Regex Pattern: (?<=Save\s+:\s+)\d+(?=\s+Total Record) [image] Hope this helps…

This post made by @ppr received 2 likes!

Grouping and eliminating excel columns

Variables: [grafik] Flow: [grafik] [grafik] Statements taken from above Find starter help here: GroupBy_2Col_GRPCustomSort_TakeFirst.xaml (8.5 KB)

This post made by @lakshman received 1 likes!

Options strict on disallows implicit conversions from string to double

@Mehak Data scraping will give you output as DataTable. So you need to create one variable of type System.DataTable and pass it to Data scraping activity.

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Use regex in notepad?

@fairymemay - Read the data.txt using “Read text file” activity and save the output Say StrInput Then using the Matches activity as shown below… [image] Regex Pattern: (?<=Save\s+:\s+)\d+(?=\s+Total Record) [image] Hope this helps…

This solution provided by @ppr received 2 likes!

Grouping and eliminating excel columns

Variables: [grafik] Flow: [grafik] [grafik] Statements taken from above Find starter help here: GroupBy_2Col_GRPCustomSort_TakeFirst.xaml (8.5 KB)

This solution provided by @WangJidong received 1 likes!

Read filename (number only)?

@fairymemay Please check this Xaml file, hope it can help you Regards. [image] Main.xaml (11.6 KB)

---

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

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

[system]

Daily Forum Report | 02 July 2021

Top 3 Topics with Most Views

I am taking sales order numbers from a variable(array) and I want to put these order numbers into new line in outlook mail body(HTML format)? if anybody can help? made by @anjasing with 38 views.

Power Shell made by @a.ef with 34 views.

Data scraping does not capture the data from the next page made by @R_R with 33 views.

Top 3 Topics with Most Replies

Any regex for alphanumeric extraction in matches activity of uipath? for e.g. to extract this? made by @anjasing with 16 replies.

Power Shell made by @a.ef with 16 replies.

I am taking sales order numbers from a variable(array) and I want to put these order numbers into new line in outlook mail body(HTML format)? if anybody can help? made by @anjasing with 12 replies.

Top 3 Users Who Posted The Most

@ppr made 16 posts!

@anjasing made 14 posts!

@kumar.varun2 made 12 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Any regex for alphanumeric extraction in matches activity of uipath? for e.g. to extract this?

give a try on [A-Z]?\d+ [grafik] [grafik]

This post made by @Yoichi received 1 likes!

How to insert space between each characters given by user

Hi, Can you try the following expression? String.Join("",yourString.Select(Function(c) c+" ")).Trim Regards,

This post made by @ptrobot received 1 likes!

How to insert space between each characters given by user

Another way to do it is to use ToList(). It splits the string to a list of chars that you then can join to a string with a space in between them. String.Join(" ", str.ToList) [image]

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Any regex for alphanumeric extraction in matches activity of uipath? for e.g. to extract this?

give a try on [A-Z]?\d+ [grafik] [grafik]

This solution provided by @prasath_S received 1 likes!

Autofill Excel Function

Hi @Isyraf_Salahudin Please try this, You can read the excel data and store in a data table (dtTable) 2 And in autofill give range as “A2:A” + dtTable.rows.count.tostring Thanks

This solution provided by @LevKushnir received 1 likes!

Bug in UiPath.Core.Activities.SAP.CallTransaction

@Senseo929 Good news! We have no BUGs in our SAP Activities @raduc thanks for investigation @StefanSchnell thanks for confirmation Best regards, Lev

---

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 July 2021

Top 3 Topics with Most Views

How to get the files from a folder in the same order it is saved? made by @Vignesh_Sahoo with 35 views.

How to Sum Negative and postive values in a single column in Excel made by @surya_teja.k with 30 views.

Internet explorer : “Open Browser: Cannot communicate with Internet Explorer browser” made by @annaa801252 with 29 views.

Top 3 Topics with Most Replies

How to Sum Negative and postive values in a single column in Excel made by @surya_teja.k with 11 replies.

ERROR: 1420, Message - 'Cannot acquire a license.' made by @atoi with 8 replies.

Timeout reached and Unlicensed License status made by @Aleksey_M with 8 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 10 posts!

@surya_teja.k made 6 posts!

@NIVED_NAMBIAR made 5 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

Issue in data filtering

Give a try on: Assign activity leftside: dtFiltered | DataType:DataTable Right side: (From d in YuurDataTableVar.AsEnumerable let acmn = d(yourColNameOrIndex).toString.Trim Where acmn.length = 8 Or acmn.length = 10 Select r=d).CopyToDataTable handling empty filter result can be done with following patterns: [grafik]

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

Combining while and for each

Hi @ayub_z How about this [image] before for each data row loop initialize the counter as 0

This post made by @ppr received 1 likes!

Issue in data filtering

Currently we are working on rolling out a tutorial series on learning LINQ. Have a look on the first tutorials here: https://forum.uipath.com/t/howto-linq-vb-net-learning-catalogue/325671 we suggest to start with learning the basics on List/Array base. With some more practice doing LINQ on datatables will be easier and more sucessfully.

Top 3 Most Liked Solutions

This solution provided by @ppr received 3 likes!

Issue in data filtering

Give a try on: Assign activity leftside: dtFiltered | DataType:DataTable Right side: (From d in YuurDataTableVar.AsEnumerable let acmn = d(yourColNameOrIndex).toString.Trim Where acmn.length = 8 Or acmn.length = 10 Select r=d).CopyToDataTable handling empty filter result can be done with following patterns: [grafik]

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

Combining while and for each

Hi @ayub_z How about this [image] before for each data row loop initialize the counter as 0

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

How to Sum Negative and postive values in a single column in Excel

@surya_teja.k try this dt.AsEnumerable.Sum(Function (x) If(x(1).ToString.Replace(" ","").IsNumeric, CDbl(x(1).ToString.Replace(" ", "")), 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 | 04 July 2021

Top 3 Topics with Most Views

Dealing with the last row of DataTable when using a loop made by @Lior_Ben_Naim with 33 views.

SAP Selector Issues made by @unknownay with 26 views.

Can we create a executable file of UI PATH automation process? made by @Deepak_Gautam with 25 views.

Top 3 Topics with Most Replies

Dealing with the last row of DataTable when using a loop made by @Lior_Ben_Naim with 7 replies.

Academy site doesn't work made by @Isabo with 6 replies.

Add a New Column to the Existing Excel Sheet which is created already made by @Jayavignesh_G with 5 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 9 posts!

@ermanoj3101 made 7 posts!

@RAKESH_KUMAR_BEHERA made 6 posts!

Top 3 Most Liked Posts

This post made by @wasea received 2 likes!

Can we create a executable file of UI PATH automation process?

Hello @Deepak_Gautam , I don’t think this is possible. If you create an automation in UiPath studio, your client should have installed the UiPath robot on his machine. That robot will execute the steps that you configured. You can send your automated process as a package, but not as an executable. I hope that helps. Vasile.

This post made by @ermanoj3101 received 2 likes!

Query - Automation

I don’t think their will be any challenges to automate fb or insta. I have done Automation on FB once to post one image everyday from respective folder. Go ahead and do it😀

This post made by @Bill_Pratt received 1 likes!

Reboot Your Skills Program - Introduce Yourself!

Hi, my name is Bill and I am managing the team that is investigating RPA for use at the Department of Homeland Security. We have a few bots built in a pilot implementation and are gathering use cases from many offices. I will not be doing the work but I want to know enough to be able to speak about it intelligently. My coding skills are about 30-35 years old at this point.

Top 3 Most Liked Solutions

This solution provided by @N2027 received 1 likes!

条件分岐で複数条件がある場合

配列で複数の文字列を条件にすることはできないので、 冗長的ですが、以下のように条件を指定してみてください。 ファイルパス.Contains(“文字列A”) and ファイルパス.Contains(“文字列B”) and ファイルパス.Contains(“文字列C”)

This solution provided by @NIVED_NAMBIAR received 1 likes!

Add a New Column to the Existing Excel Sheet which is created already

Hi @Jayavignesh_G for getting a clear idea, refer this workflow process1.zip (3.4 MB) Mark it as solution if it helps Regards, Nived N Happy Automation

---

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 July 2021

Top 3 Topics with Most Views

Linking Regx With Excel value made by @Mpumi_Setshedi with 37 views.

Write Cell: Index was outside the bounds of the array made by @BoomBot with 31 views.

How to copy from Collection of DataRows to DataTable if Collection is empty? made by @Pedro_Pais with 30 views.

Top 3 Topics with Most Replies

Linking Regx With Excel value made by @Mpumi_Setshedi with 17 replies.

Get XML Nodes questions? made by @Matthew2 with 9 replies.

"Add Verification" made by @Riphath with 9 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 20 posts!

@ayush_purohit made 10 posts!

@Surya_Narayana_Korivipadu made 9 posts!

Top 3 Most Liked Posts

This post made by @TheTanmay1 received 3 likes!
https://forum.uipath.com/t/173729/772

This post made by @manjula_rajendran received 2 likes!

Extracting product description from Website to excel

@jeevana.nagothu-ext , when you extract the Food name get the URL also. [food] Then run each loop and navigate to the URL. Use Get Text activity to scrap the description. Here i attached the workflow. Check it Note: i used for only 10 records. ForForum.xaml (14.8 KB) Hope it will help you. Thanks, Manjula

This post made by @TheTanmay1 received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, I am Tanmay Agarwal, I am an Android developer and Founder & CEO of TheVirtualBots, Actually from childhood I have a passion for automation, robotics process, etc, but i was not able to find a way to fulfill it, but then recently my friend @Deepak_Gautam , introduced me with the power of UI Path as he showed me how he was able to automate his web scrapping of LinkedIn data using UI Path, I was literally amazed to see the working, so I got curious to check out this wonderful platform and …

Top 3 Most Liked Solutions

This solution provided by @ayush_purohit received 1 likes!

How can i ignore reply and forward mail message and take only the first mail message and its attachment

Whenever you get any reply, normally, you get RE: < Mail Subject > format. One of the simpler solution can be to check the subject line which does not start with RE: and has the required subject line. The other stuff wherein you download the attachment from an email can be done via regular steps. To make the solution more robust, the attachment name can be checked, this re-verifies if the file which bot has downloaded needs to be considered or not.

This solution provided by @ayush_purohit received 1 likes!

Hotkey for excel

Question is not very clear, but if you want to auto width - using Invoke VBA could be an option. Firstly, use write the following code in a txt file: Sub ColumnWidth() Columns("<Col_Name>:<Col_Name>").EntireColumn.AutoFit End Sub e.g, Col_Name = “A” to auto-width A column. Then use Invoke VBA activity in excel application scope. Mention Txt path and methodName = ColumnWidth

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

Linq replacement for select query

Hi @Amrutha.mg Try this DT.AsEnumerable.Where(Function (x) x(str_CurrentVC).ToString.Contains(str_CurrentSCValue)).ToArray Query version (From r in DT Where r(str_CurrentVC).ToString.Contains(str_CurrentSCValue) Select r).ToArray

---

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 July 2021

Top 3 Topics with Most Views

How to Filter Date Column with #N/A Value made by @surya_teja.k with 49 views.

Index was outside the bounds of array-URGENT made by @mitul_choudhary with 43 views.

How to write data in Excel file without overwriting? made by @1000_Yukino with 42 views.

Top 3 Topics with Most Replies

How to write data in Excel file without overwriting? made by @1000_Yukino with 27 replies.

Index was outside the bounds of array-URGENT made by @mitul_choudhary with 19 replies.

Input string was not in a correct format-Urgent made by @mitul_choudhary with 18 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 23 posts!

@kumar.varun2 made 17 posts!

@prasath17 made 16 posts!

Top 3 Most Liked Posts

This post made by @Max_Herrera received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi everyone, I’m Maximiliano, I have more than two years of developing automation with different tools, recently I started learning UI Path and I think is a great application for automation. Best regards!!!

This post made by @prasath17 received 2 likes!

Check for empty cell in a datatable

@TyraS - Please try this… (From d in dtData.AsEnumerable Let check = d.ItemArray.Any(Function (x) isNothing(x) OrElse String.IsNullOrEmpty(x.toString.trim)) Select check).Any(Function (e) e) Assign the above statement to Boolean variable…

This post made by @ryoko received 2 likes!

Excelにウェブサイトの情報を入力する方法

いらせられませ、ようこそForumへ Webから読み込む情報の項目が決まっているのであれば、 情報.xlsxで読み込んだデータテーブルに追加で入れるのではなく、 Web情報は新規データテーブルに格納し、Excelに追記の方が良いかも？ 以下は情報.xlsxがA1から始まるデータで、ヘッダーが1行の例です。 情報.xlsxから読み込んだデータテーブルを読み込む…データテーブルA ⇒行数取得用。 『データ テーブルを構築』Activityで情報.xlsxと同ヘッダーの新規データテーブルを作成…データテーブルB Webから取得した情報をデータテーブルBに格納 『範囲に書き込み』の開始セルに、列アルファベット+データテーブルAの行数+2を設定。『ヘッダーを追加』はチェックしない。 ⇒例：“A”+(データテーブルA.rows.count+2).tostring ※+2は、ヘッダー1行と最終行オフセット1行の合計 多分これで行けるかと思うのですが、どうでしょ？

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Check for empty cell in a datatable

@TyraS - Please try this… (From d in dtData.AsEnumerable Let check = d.ItemArray.Any(Function (x) isNothing(x) OrElse String.IsNullOrEmpty(x.toString.trim)) Select check).Any(Function (e) e) Assign the above statement to Boolean variable…

This solution provided by @manjula_rajendran received 1 likes!

Issue with Vm with unattended Bot

Hi @Tharusha.fernando , if it is a browser stuff, don’t need to worry. Complete your workflow. Set the Bot and set the scheduler for running. It will work on your VM. Note: If you are using Active Accessibility to scrape the data then it may not work if your screen is not enabled. Handle the situation in Try Catch. Thanks, Manjula

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

Input string was not in a correct format-Urgent

CInt(((CDbl(If(drInvoiceMain.Item("IGST Amount").ToString.Equals(""), "0", drInvoiceMain.Item("IGST Amount").ToString))+CDbl(If(drInvoiceMain.Item("SGST / UT GST Amount").ToString.Equals(""), "0", drInvoiceMain.Item("SGST / UT GST Amount").ToString))+CDbl(If(drInvoiceMain.Item("CGST Amount").ToString.Equals(""), "0", drInvoiceMain.Item("CGST Amount").ToString)))/CDbl(drInvoiceMain.Item("Taxable Value").ToString))*100)=CInt(If(drInvoiceMain.Item("GST Rate").ToString.Equals(""), "0", drInvoiceMain…

---

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 July 2021

Top 3 Topics with Most Views

String Manipulation- Remove made by @jenkim with 40 views.

Urgent help needed on Updating Values made by @surya_teja.k with 40 views.

Excel Activities for Processing and Filtering made by @jack.chan with 38 views.

Top 3 Topics with Most Replies

How to extract Words from Text that Contains a Given String? made by @hsendel with 12 replies.

String Manipulation- Remove made by @jenkim with 11 replies.

Urgent help needed on Updating Values made by @surya_teja.k with 11 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 28 posts!

@kumar.varun2 made 20 posts!

@Surya_Narayana_Korivipadu made 20 posts!

Top 3 Most Liked Posts

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

Excel Activities for Processing and Filtering

Hi everyone, i’d like to share my new custom activity. Feel free to use it and ask any questions [image] Main Functions include: 1. Batch Delete Rows In Excel - delete specified rows Inputs a. In_rowNumbersToDelete (string) - the row numbers to delete (separated by comma) a. .e.g. “1,3,5,7,9” b. In_excelPath (string) – excel path c. In_sheetName (string) – sheet name 2. Batch Highlight Rows In Excel - highlight specified rows a. In_rowNumbersToHighlight (string) - the row numbers to …

This post made by @petter received 3 likes!

I am struggling with finding a solution to delete all rows in an excel sheet

Hi I am completely new to UiPath, and I have started my first automation project in StudioX. I am struggling with finding a solution to delete all rows in an excel sheet that containing a specific word in a column.

This post made by @Surya_Narayana_Korivipadu received 3 likes!

Generate Yearly Report - transaction item doesnt recognize

Hi. You missed to map value to transaction item. See below screenshot: [image]

Top 3 Most Liked Solutions

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

Click activity in SAP logon automation

use “Select Menu Item” activity from UIAutomation package, after you specify the selector it should give you the option to select any of the items/sub-items in the menu

This solution provided by @Jeroen received 1 likes!

I am struggling with finding a solution to delete all rows in an excel sheet

Hi Petter, Welcome to the forum! I think this is the solution to your problem. Please let me know if it helps or if you need further assistance or explanation. Have you checked out the Academy.uipath.com courses on StudioX? They can teach you all the basics you need to get started with your automations. My workflow: [image] My Excel before: [image] My Excel after (all “Food” entries are gone): [image]

This solution provided by @jishnu.pnair received 1 likes!

How to setup HTTP request where body is form-data (Uploading Files)

Issue Fixed. Dim client As RestClient = New RestClient(“http://xxxxxxxx”) client.Timeout = -1 Dim request As RestRequest = New RestRequest(Method.POST) request.AddParameter(“file”, “abc_1.jpeg”) //request.AddParameter("body param name”, “param value”) request.AddParameter(“userId”, “Jishnu.PNair”) \second param and its values request.AddFile(“file”, “XXXXXXXX\abc_1.jpeg”) \ file that need to be uploaded - param and its value Dim response As IRestResponse = client.Execute(request) Console…

---

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 July 2021

Top 3 Topics with Most Views

Most efficient way to web data extraction? made by @Rems with 95 views.

When Comparing two Excel getting wrong Output made by @Jayavignesh_G with 79 views.

How to get the weekday out from a string variable that holds a date? made by @Lior_Ben_Naim with 79 views.

Top 3 Topics with Most Replies

Postpone transaction item problem made by @liran.levin with 15 replies.

When Comparing two Excel getting wrong Output made by @Jayavignesh_G with 14 replies.

Most efficient way to web data extraction? made by @Rems with 13 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 41 posts!

@Srini84 made 21 posts!

@kumar.varun2 made 13 posts!

Top 3 Most Liked Posts

This post made by @Foxtrek_64 received 3 likes!

How to extract Words from Text that Contains a Given String?

I’m a bit late here but I feel like regex may be a bit too much here. I would instead suggest using a LINQ query. If you have your text as text, then you can easily do text.Split(' ').Where(x => x.Contains("fo") || x.Contains("in")) to grab all of the words.

This post made by @Yoichi received 2 likes!

Compile Error due to Data Type Int32

Hi, Can you try the following expression? "新規値"+Number.ToString() Regards,

This post made by @Thin_Thitsar received 2 likes!

Compile Error due to Data Type Int32

@Yoichi Thank for your reply. I got it. Kindly Regards, Thinn

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Compile Error due to Data Type Int32

Hi, Can you try the following expression? "新規値"+Number.ToString() Regards,

This solution provided by @Yoichi received 2 likes!

Ending a Do While loop if condition doesn't meet

Hi, Can you try to use Stopwatch class as the following? [img20210708-1] Regards,

This solution provided by @prasath_S received 2 likes!

Sum Column in DataTable based on Regions

@Dimple_Mandal Attached the workflow tested it please use this, Main.xaml (11.4 KB) Thanks

---

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

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