Forum Engagement Daily Reports

[system]

Daily Forum Report | 03 October 2023

Top 3 Topics with Most Views

Issue with Update Row Activity for Data Table made by @D_Okthree with 53 views.

Check string contains other string made by @simone.trenta with 53 views.

Date/Time Difference between to String Variables made by @KrishnaKishore with 52 views.

Top 3 Topics with Most Replies

Issue with Update Row Activity for Data Table made by @D_Okthree with 23 replies.

Not able to Find Else if condition inside Else if activity made by @Nikhil_Jain with 20 replies.

Bot should be click 'Argument 1, Argument 2, Argument 3, Argument 4,........, Argument n ' links upto last 'Argument n' present link made by @Smitesh_Aher1 with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 66 posts!

@efelantti made 20 posts!

@Yoichi made 19 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Get duplicates from a list of String

list_str_RouteName.GroupBy(Function (x) x).Where(Function (x) x.Count > 1).Select(Function (x) x.First()).toList

This post made by @Sanober_Mandokhail received 2 likes!

No error encounter on modern activities

If you intentionally make a selector error in your UiPath automation workflow and you are not seeing an error being thrown, there could be a few reasons for this behavior: Try-Catch Configuration: First, ensure that the Try-Catch activity is correctly configured. The sequence inside the “Try” block should contain the activity with the incorrect selector, and the “Catch” block should contain the actions you want to perform when an exception occurs. Exception Type: Check the type of exception y…

This post made by @Yoichi received 2 likes!

Pad left on Uppercase

Hi, How about the following expression? System.Text.RegularExpressions.Regex.Replace(yourString,"(?=[A-Z])"," ") [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Get duplicates from a list of String

list_str_RouteName.GroupBy(Function (x) x).Where(Function (x) x.Count > 1).Select(Function (x) x.First()).toList

This solution provided by @Palaniyappan received 1 likes!

How to get the comments added by the user from a External task in Action Center

Hi Well there is no direct way to get the comments added to an external task in UiPath. Instead of comments you ask the user to mention them under Notes field so that you can get that from get task data activity which gives an task object as output and it will haves notes to be fetched https://docs.uipath.com/activities/other/latest/workflow/get-task-data that is even possible with api also Check this out [IMG_8575] Hope this helps Cheers @krishnakanth.k

This solution provided by @Anil_G received 1 likes!

Apps VB - Slider's "Value binding" absent in VB version

@bruno40 in the default value add the value of your output variable 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 | 04 October 2023

Top 3 Topics with Most Views

Which activity should we use to fetch text from cheque image? made by @Samraat_Maharjan1 with 51 views.

How to verify if a date falls in a specified range? made by @Vaishnav_Tej with 47 views.

Extract data from a drop down list made by @Mkary with 44 views.

Top 3 Topics with Most Replies

Datatable without using column & row reference made by @Smitesh_Aher1 with 28 replies.

How to verify if a date falls in a specified range? made by @Vaishnav_Tej with 28 replies.

Which activity should we use to fetch text from cheque image? made by @Samraat_Maharjan1 with 17 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 49 posts!

@Gokul001 made 26 posts!

@Shiva_Nikhil made 25 posts!

Top 3 Most Liked Posts

This post made by @argin.lerit received 3 likes!

Conditions abracadabra...

Hello @Leon_Romans_van_Schaik - Yeah, these are .NET objects and properties. See an example here: MailMessage Class (System.Net.Mail) | Microsoft Learn [image] The mail object has a property From as seen in the table and in your first example. Each object/property/method has a dedicated page you can use for reference as long as you can search for them. When you start thinking in terms of .NET or C# objects/property/method, it’s easier to recognize them when you see them. You can also use th…

This post made by @lrtetala received 2 likes!

How to handle exception in Invoke VBA Excel Activity

Hi Community folks, I am using the Macro with VB code to automate the excel process by using Invoke VBA Excel activity. If any error occurred in the VB code, the bot stuck at Invoke VBA activity and displayed popup. Is there any solution to handle the exception, If the exception occur in VB Code it will throw back to UiPath. Let me know is there any chance to modify in VB Code or other approach. Note : I encapsulated the whole process in UiPath with Try Catch. Check the below image while ge…

This post made by @miwa_yamamoto received 2 likes!

データテーブルより指定の列を抜き出したい

Yoichi様 いつもありがとうございます。 お陰様で無事に完成しました。 大変勉強になりました。 ありがとうございました。

Top 3 Most Liked Solutions

This solution provided by @argin.lerit received 3 likes!

Conditions abracadabra...

Hello @Leon_Romans_van_Schaik - Yeah, these are .NET objects and properties. See an example here: MailMessage Class (System.Net.Mail) | Microsoft Learn [image] The mail object has a property From as seen in the table and in your first example. Each object/property/method has a dedicated page you can use for reference as long as you can search for them. When you start thinking in terms of .NET or C# objects/property/method, it’s easier to recognize them when you see them. You can also use th…

This solution provided by @Palaniyappan received 1 likes!

Extract Date from Excel Document and Insert it on a Website

Try to mention like this in type into activity Datetime.ParseExact(CurrentRow(1).ToString.Trim.SubString(0,10), “yyyy/MM/dd”, System.Globalization.CultureInfo.InvariantCulture).ToString(“yyyy/MM/dd hh:mm”) Cheers @Ivan_Potgieter

This solution provided by @Palaniyappan received 1 likes!

Integrating Test Manager and TaskTop

Hi TaskTop works with on-premise Test Manager as well To use TaskTop with on-premise Test Manager, you will need to install the Test Manager Connect connector on the server where Test Manager is installed. Installation step check this out for more insights [UiPath Test Manager and TestRail - Planview Tasktop Hub Demo Video] But I would recommend reaching out to TaskTop’s official support or consulting their documentation or website. They will be able to provide you with the l…

---

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

Top 3 Topics with Most Views

Use Application/Browser single/application made by @hm00776818 with 44 views.

Split House Numbers and street address made by @Jeeru_venkat_Rao with 38 views.

How to check where the point is placed made by @lakshmi.mp with 38 views.

Top 3 Topics with Most Replies

How to get specific multiplecolumns name with data made by @suraj_gaikwad with 23 replies.

Use Application/Browser single/application made by @hm00776818 with 14 replies.

Mail-Automation made by @Prakash_Patnala with 14 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 28 posts!

@Anil_G made 26 posts!

@ppr made 25 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

Issue with For Each Loop - Same Data Filling in All UI Elements

@Aditya_Nalawade As per your screenshot It is evident that same data is filled for each ui element loop That is because you have an outer loop which loops through rows…and inner loop will loop through elements…so for each row of outer loop inner ui element loop will tun for all elements… So if you want each row to be populated in each element… Then the loop shpuld change a little Use for each ui element only…currentindex will give you the index which will be 0 ,1, etc for each iteration N…

This post made by @hm00776818 received 1 likes!

Best practice to check element modern activities

element exist will belongs to classic so i want to implement only modern activities

This post made by @Palaniyappan received 1 likes!

Need to force business exception in a flow - Best practice?

Well in order to force a business exception in the case where the HTTP request status is not 200, you can use the following steps: Surround the https activity within try block of a try catch activity Then add a new Throw activity in catch block Set the Exception property of the Throw activity to a New BusinessRuleException(“Failed to download file from web service”.) This will ensure that the process fails with a business exception if the HTTP request status is not 200. Whether the process…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Issue with For Each Loop - Same Data Filling in All UI Elements

@Aditya_Nalawade As per your screenshot It is evident that same data is filled for each ui element loop That is because you have an outer loop which loops through rows…and inner loop will loop through elements…so for each row of outer loop inner ui element loop will tun for all elements… So if you want each row to be populated in each element… Then the loop shpuld change a little Use for each ui element only…currentindex will give you the index which will be 0 ,1, etc for each iteration N…

This solution provided by @supriya117 received 1 likes!

Convert data column to string with ";" as seporator

Hi @Povilas_Jonikas Try this: Assign activity: ResultString = String.Join(";", YourDataTable.AsEnumerable().Select(Function(row) row.Field(Of String)("ColumnName")).ToArray()) or ResultString = String.Join(";", yourDataTable.AsEnumerable().Select(Function(row) row(0).ToString()).ToArray())

This solution provided by @Yoichi received 1 likes!

トランザクション アイテムを取得activity QueueItem変数の使い方

こんにちは SpecificContentを使用してみてください data.SpecificContent.Item("MailSubject").ToString() data.SpecificContent.Item("MailBody").ToString() data.SpecificContent.Item("MailFrom").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 | 06 October 2023

Top 3 Topics with Most Views

How to get extract the unstructure data from the web UI and get specific data in format of string made by @Smitesh_Aher1 with 46 views.

Array of item with double quotes made by @yashashwini2322 with 45 views.

Query in Linq Query made by @Mohammad.Fuad with 42 views.

Top 3 Topics with Most Replies

How to get extract the unstructure data from the web UI and get specific data in format of string made by @Smitesh_Aher1 with 35 replies.

How to convert the date format in csv file to (dd/MM/yyyy) made by @Abhi4 with 20 replies.

Convert System.string to System.datetime variable type made by @lakshmi.mp with 20 replies.

Top 3 Users Who Posted The Most

@lrtetala made 36 posts!

@Praveen_Mudhiraj made 31 posts!

@supermanPunch made 22 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

Convert workflow from one browser to another

One of more options You can have a look at the Browser Migration Tool provided by UiPath it will help to do a conversion. Surely, testing and manual postediting is recommended

This post made by @supriya117 received 2 likes!

Convert workflow from one browser to another

Hi @Muhammad_Anas_Baloch Change the selectors of all ui element activities to SyntaxEditor Code Snippet app='firefox.exe' And check other properties in the selector

This post made by @william.coulson received 2 likes!

Convert workflow from one browser to another

Hi @Muhammad_Anas_Baloch, You could potentially mass replace any instance of app='chrome.exe' with app='firefox.exe' inside a notepad file. Right click on your xaml file, and then open with Notepad/Notepad++. [image] Open the Find and Replace function, enter the appropriate terms in the Find/Replace fields and then click Replace All. [image] Unfortunately this won’t guarantee that all your selectors will work, but this is less time consuming than opening every selector and changing the ap…

Top 3 Most Liked Solutions

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

Changes in Uipath version 2023.4.0

Compare the major release notes: https://docs.uipath.com/studio/standalone/2023.4/user-guide/release-notes-2023-4-0 https://docs.uipath.com/robot/standalone/2023.4/user-guide/2023-4-0 with https://docs.uipath.com/studio/standalone/2022.10/user-guide/release-notes-2022-10-3 https://docs.uipath.com/robot/standalone/2022.10/user-guide/release-notes-2022-10-3 But we recommend to check also the latest patches release to see which improvements or fixes have been made.

This solution provided by @supermanPunch received 1 likes!

Cannot Open any files from Config.xlsx in Reframework! Help needed

@Jai_Pande , I believe this is the issue, We can see that the Double Quotes are also included in the String, which should not be the case. You would have to delete the Double Quotes in the Path if you have also provided it in the Asset.

This solution provided by @Shiva_Nikhil received 1 likes!

Query in Linq Query

@Mohammad.Fuad type the expression manually don’t copy and paste it ( From row In dt Where Not String.IsNullOrEmpty(row(“country”).tostring) Select row ).copytodatatable 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 | 07 October 2023

Top 3 Topics with Most Views

Add Queue Item, Get Queue item, set status made by @avinash.wankhede with 38 views.

Questions about excel ReadRange made by @shenyu with 37 views.

More then 2 pages document understanding made by @Bhargavi_Lokapur1 with 32 views.

Top 3 Topics with Most Replies

How can I click on a list of URLs in a web browser and have a specific behaviour for each page? made by @doglikecat41 with 14 replies.

Required expertise on Regex made by @Sahil_Garg1 with 12 replies.

How to copy data row from 2 excel file and paste it on new excel file simultaneously and what to add in arrayrow in add data row made by @madhavraichur25 with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 24 posts!

@Palaniyappan made 17 posts!

@Shiva_Nikhil made 12 posts!

Top 3 Most Liked Posts

This post made by @Bhargavi_Lokapur1 received 1 likes!

More then 2 pages document understanding

I am doing Document uderstanding In that? I am not able to extract the pdf data is more then 2 pages how can do next anyone has idea please share

This post made by @supermanPunch received 1 likes!

Required expertise on Regex

Hi @Sahil_Garg1 , For Starters, could you check with the below Regex Expression : (?<=amount of overpayment:).*?(\d+\s\d+)\s[\d.,]+\s(\d+\s\d+)\s[\d.,]+\s(\d+\s\d+)\s[\d.,]+\s(\d+\s\d+)\s[\d.,]+\s(\d+\s\d+) We would need to access the required values using Groups. [image] Debug Panel : Regex.Match(strText,"(?<=amount of overpayment:).*?(\d+\s\d+)\s[\d.,]+\s(\d+\s\d+)\s[\d.,]+\s(\d+\s\d+)\s[\d.,]+\s(\d+\s\d+)\s[\d.,]+\s(\d+\s\d+)").Groups(1) [image] Do note that we only received a Single…

This post made by @Palaniyappan received 1 likes!

UiPatjh chrome web driver mode

Hi Let’s go one by one Headless mode means that the browser is launched without a graphical user interface (GUI). This means that the browser window is not displayed on the screen. Headless mode is often used for automated testing and web scraping, as it can be faster and more efficient than using a GUI browser. Use GUI mode means that the browser is launched with a GUI. This is the default mode for UiPath web browser activities. Use GUI mode is useful for debugging and monitoring automation…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

メールメッセージを取得 本文のみ取得できない

こんにちは もし改行記号を削除したいのであれば vMailBody.Replace(vbcr,"").Replace(vblf,"") となりますので、こちら一度試してもらえますでしょうか？

---

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

Top 3 Topics with Most Views

UiPath Assistant - System.Threading.Tasks.TaskCanceledException: “The request was canceled due to the configured HttpClient.Timeout of 30 seconds elapsing.” made by @mukarramahsen with 48 views.

Find and replace 0 with 1 in an excel file, the activity replaces all the occurrences of 0 made by @sharad.bodke with 35 views.

Excel automation query( need linq code as the data is huge ) made by @Suthari_RohithReddy with 34 views.

Top 3 Topics with Most Replies

Use Case __01 made by @Gokul_Murali with 20 replies.

UiPath Assistant - System.Threading.Tasks.TaskCanceledException: “The request was canceled due to the configured HttpClient.Timeout of 30 seconds elapsing.” made by @mukarramahsen with 15 replies.

Get data against row value in excel using Linq made by @c3f1e68294fdcf4a1f0a817ca with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 15 posts!

@supriya117 made 14 posts!

@c3f1e68294fdcf4a1f0a817ca made 13 posts!

Top 3 Most Liked Posts

This post made by @rishiathawale received 1 likes!

Get details from text

Hi All, I want to convert the below text to table or wanted to extract data thru regex. MAA Distri Cal Distribution DST # Account # Ticker CUT # Fund Paid Outstanding Rate/Share 9307 745336 MJAWE 83681P531 Callcal Term Miti Prop 2,485,126.08 74,193,631.799 0.03349514 1st row is heading 2nd is header 3rd is values This text is extrated from pdf.

This post made by @Gokul_Murali received 1 likes!

Use Case __01

Hello guys i have a use case. [MicrosoftTeams-image (18)] step 1: I want to check first row in section column if its 910216 it should take corresponding “SI Lc” amount in the same row. Step 2 : it should check the 2 nd row whether same 910216 repeating and the Risk ID is “2” if the Risk ID is 2 and the value 910216 Repeats It should take the Corresponding "SI Lc " Amount. Note : Here there will be around 50 Rows, Some time the value “910216” will in the 50th Row of Section column. Que…

This post made by @lrtetala received 1 likes!

Find and replace 0 with 1 in an excel file, the activity replaces all the occurrences of 0

Hi @sharad.bodke You can try like this [image] Note: Check the Match entire cell contents property I/P: [image] O/P: [image] Hope this helps!!

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Find and replace 0 with 1 in an excel file, the activity replaces all the occurrences of 0

Hi @sharad.bodke You can try like this [image] Note: Check the Match entire cell contents property I/P: [image] O/P: [image] 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 October 2023

Top 3 Topics with Most Views

How to select multiple item from drop down made by @suraj_gaikwad with 47 views.

How to set properties inside Write Cell (Workbook activity) made by @D_Okthree with 43 views.

Get the exact large number from the excel file made by @Temuulen_Buyangerel with 42 views.

Top 3 Topics with Most Replies

How to compare the current date with the excel file column made by @lakshmi.mp with 34 replies.

Facing problem in extracting aadhar card using Document understanding made by @Jai_Pande with 24 replies.

How to select multiple item from drop down made by @suraj_gaikwad with 22 replies.

Top 3 Users Who Posted The Most

@lrtetala made 54 posts!

@Palaniyappan made 50 posts!

@Gokul001 made 39 posts!

Top 3 Most Liked Posts

This post made by @Melanie_Dunbeck received 2 likes!

Kelly - Automation Technical Resource Lead - Remote - United States - Full Time

Job title: Automation Technical Resource Lead Job role: RPA Lead Country: United States City: Remote Company name: Kelly Employment Type: Full Time Seniority level: Senior more than 5 years Job Description: We are seeking an experienced Automation Technical Resource Lead to join our team. As a member of Kelly’s Automation Enablement Center (AEC) team, the Automation Technical Resource Lead will be responsible for Technical Solution Design and managing a team of onshore and offshore autom…

This post made by @Palaniyappan received 2 likes!

Get the exact large number from the excel file

Hi There are two ways Either change the type of that column to Text in excel file itself and then try to update the data to it so that it doesn’t convert to this format Or if the file is getting generated dynamically and can’t be set as a template then you have again two options you can use single quote before to the value like this “ ‘ “+ yourvalue.ToString something like this for your reference [image] or you can use Balareva activity - a custom component from UiPath marketpla…

This post made by @supermanPunch received 2 likes!

Filter Excel on multiple criteria blank rows and keep rows containing specific values

@1a2bc346dgjk7544ebjkkbvf , Maybe we could generalise with a Regex Expression for all the conditions mentioned : OutputDT = DT.AsEnumerable.Where(Function(x)System.Text.RegularExpressions.Regex.IsMatch(x(0).ToString,"\b[A-Za-z]{1}\b|[A-Za-z]+[0-9]+|\d{2,}")).CopyToDatatable Here, DT is the Input datatable and OutputDT is the Output datatable. Could you try the above expression and let us know if it is working or not. Do try with different data and test it.

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

Filter Excel on multiple criteria blank rows and keep rows containing specific values

@1a2bc346dgjk7544ebjkkbvf , Maybe we could generalise with a Regex Expression for all the conditions mentioned : OutputDT = DT.AsEnumerable.Where(Function(x)System.Text.RegularExpressions.Regex.IsMatch(x(0).ToString,"\b[A-Za-z]{1}\b|[A-Za-z]+[0-9]+|\d{2,}")).CopyToDatatable Here, DT is the Input datatable and OutputDT is the Output datatable. Could you try the above expression and let us know if it is working or not. Do try with different data and test it.

This solution provided by @Gokul001 received 2 likes!

How to to kill remote desktop connection after completion of workflow

Hi @Suraj_Gaikwad_Nuvama_Grou Check out this thread Regards Gokul

This solution provided by @Yoichi received 1 likes!

Get the exact large number from the excel file

Hi, The following topic helps you. 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 October 2023

Top 3 Topics with Most Views

Date Parse time made by @Anelisa_Bolosha1 with 46 views.

Kelly Launches Recruitment Platform for AI and Automation Talent made by @Arya_Morales_Badiola with 44 views.

Extarct string made by @Demo_User with 44 views.

Top 3 Topics with Most Replies

How to move excel sheet at the end using VBA script/code made by @Nishant_mantri with 21 replies.

Need SharePoint query to find folder made by @Learner007 with 17 replies.

UiPath Macro Help needed made by @Ritaman_Baral with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 57 posts!

@Palaniyappan made 39 posts!

@lrtetala made 31 posts!

Top 3 Most Liked Posts

This post made by @Praveen_Mudhiraj received 5 likes!

Monthly Forum Rewards - September 2023

Congratulations Everyone

This post made by @rodrigo.simao received 4 likes!

Monthly Forum Rewards - September 2023

Congratulations everyone! Just a small mistake on your behalf… I’m Portuguese, not Indian Cheers!

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

Monthly Forum Rewards - September 2023

Congratulations to All the winners , Excellent @Praveen_Mudhiraj

Top 3 Most Liked Solutions

This solution provided by @pravallikapaluri received 1 likes!

I have a String in Appended Way so that I need it in Straight Line

Hi @Gopikrishna_S yourStringVariable=“UiPath Forum” singleLineString = yourStringVariable.Replace(vbCrLf, " ") Hope it helps!!

This solution provided by @Yoichi received 1 likes!

I have to delete "New Cell Data" cell from excel but its Cell dynamically changing in Future

Hi, Can you try to use FindReplace Value activity in MatchAll mode with MatchEntireCellContents option as the following? [image] Regards,

This solution provided by @supermanPunch received 1 likes!

Uipath append activity only take the last row

@farrissya.z , Could try with Filter Datatable activity with reference to the First Column being header name and then perform removal of the rows. [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 | 11 October 2023

Top 3 Topics with Most Views

How to merge multiple columns to single column made by @1a2bc346dgjk7544ebjkkbvf with 49 views.

Pick Branch activity Issue made by @raju_alakuntla with 45 views.

Dev Dives: Explore UiPath Solutions Management for seamless packaging, deployment and maintenance made by @Raisa_Bragarea with 43 views.

Top 3 Topics with Most Replies

Pick Branch activity Issue made by @raju_alakuntla with 26 replies.

How to loop emai ids one by one in a website and paste the request number to excel made by @Priyesh_Shetty1 with 19 replies.

How do I add a new column to my data table made by @marcin.chowaniec with 16 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 48 posts!

@lrtetala made 33 posts!

@Anil_G made 23 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 2 likes!

REGX - How to get the particular text in the String using Regx?

Hi @K_GOWTHAM Welcome to UiPath Community Try with this Regular Expression System.Text.RegularExpressions.Regex.Match(YourString,"(?<=Reference\sno\s\W\s)\S+").Tostring [image] Regards Gokul

This post made by @ajay.malhi received 2 likes!

Authentication methode unattended robot with orchestrator

For our client we need to figure out what kind of authentication methode is used when connecting an unattended robot with orchestrator via Client Secret and Machine Key. How secure is this methode in comparison to for example SSH key authentication. Also where is the Client Secret stored. Are there any other methods we can use to connect except from Client secret and Machine key? Thanks!

This post made by @Ricchch received 2 likes!

OCR - Help

@Palaniyappan @Anil_G , thanks friends. I had to increase timeout and separate CV from Use application

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

REGX - How to get the particular text in the String using Regx?

Hi @K_GOWTHAM Welcome to UiPath Community Try with this Regular Expression System.Text.RegularExpressions.Regex.Match(YourString,"(?<=Reference\sno\s\W\s)\S+").Tostring [image] Regards Gokul

This solution provided by @ppr received 1 likes!

Inject js with 2 parameters

Have a look on essentials for working with directories [FirstAid] Migration to Windows target Framework - Missing Microsoft.Activities.Extensions package - Dictionary Activities - News / Vote on Tutorials - UiPath Community Forum UiPath Academy So from UiPath Side you can add entries as you do need About the lists we do feel that this part (on how the values/arguments) are offered can be adapted / optimized / used for the dictionary construction Also have a look here (one …

This solution provided by @Gokul001 received 1 likes!

How to use Send Calendar Invite activity without using Use Outlook 365/app and gmail?

Hi @farrissya.z Does the Outlook installed in your machine?

---

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

Top 3 Topics with Most Views

Arguments for Workflow Not Visible made by @nikolas.hunt with 55 views.

Comparing rows in data table made by @marcin.chowaniec with 53 views.

Getting Time Stamp in Date made by @marina.dutta with 51 views.

Top 3 Topics with Most Replies

Getting Time Stamp in Date made by @marina.dutta with 25 replies.

Arguments for Workflow Not Visible made by @nikolas.hunt with 23 replies.

I have to get previous created folder made by @shaik.muktharvalli1 with 22 replies.

Top 3 Users Who Posted The Most

@lrtetala made 48 posts!

@Shiva_Nikhil made 34 posts!

@Gokul001 made 23 posts!

Top 3 Most Liked Posts

This post made by @marina.dutta received 2 likes!

Getting Time Stamp in Date

Thanks everyone. @lrtetala @Parvathy @Shiva_Nikhil @supriya117 @supermanPunch @Gokul001 This one works . datetime.parseExact(strdate,“dd/MM/yyyy”,system.globalization.cultureinfo.invariantCulture).tostring(“dd/MM/yyyy”)

This post made by @Parvathy received 2 likes!

SQL_Query Error

Hi @km81 SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'YourSheetName$' AND COLUMN_NAME <> 'ColumnToExclude' In this query: INFORMATION_SCHEMA.COLUMNS is a system table that stores information about columns in your Excel sheet. TABLE_NAME = 'YourSheetName specifies the sheet you’re working with. Replace 'YourSheetName with the name of your Excel sheet. COLUMN_NAME <> 'ColumnToExclude' excludes the specific column you want to exclude. Replace 'ColumnToExclude' with the…

This post made by @lrtetala received 2 likes!

SQL_Query Error

Hi @km81 Try this SELECT Column1, Column2, Column3 FROM [SheetName$] WHERE ColumnName <> 'Customer' Hope this helps!!

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

Remove Duplicate rows based on single column and that too if cell starts with specific values

@S_Nitin , Great work on finding the solution . Often, we move into conclusions and provide suggestions far from the solution, so we try to understand or analyse from beginning the requirement so that we do not have to make any major changes to switch back to a different solution. If you have achieved the required result as per the solution you have mentioned, you could close this Topic and mark your post as solution. However, for clearing the confusions if you do have some time, wo…

This solution provided by @sandhiya.ppp received 1 likes!

Comparing rows in data table

Hi @marcin.chowaniec , First create array of list for column names. ColumnNames={“Column1”,Column2"} Then, NewDT=DT2.AsEnumerable().Where(Function(rowB) Not DT1.AsEnumerable().Any(Function(rowA) ColumnNames.All(Function(columnName) rowA(columnName).Equals(rowB(columnName))))).CopyToDataTable() Thanks, Sandhiya P

This solution provided by @Shiva_Nikhil received 1 likes!

Click activity working and not working suddenly

@farrissya.z have tried by making wait for ready property as complete [image] 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 | 13 October 2023

Top 3 Topics with Most Views

Extract last word of first line made by @yashashwini2322 with 52 views.

How to group a datatable? made by @Salim_Atakan with 46 views.

Data Selector Format Flow made by @NISHITHA with 45 views.

Top 3 Topics with Most Replies

Error while Business Exception or System Exception made by @yash.choursia with 26 replies.

Extract last word of first line made by @yashashwini2322 with 16 replies.

Resize image dynamically made by @gilang_mandiri with 14 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 31 posts!

@sai_gupta made 18 posts!

@Anil_G made 17 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Resize image dynamically

Hi, If you want to use index variable, it’s necessary to modify “Do” to “Main Sequence” at Scope as the following, because the variable is reset every time if its scope is Do. [image] Regards,

This post made by @Palaniyappan received 2 likes!

Resize image dynamically

May be before resizing have a copy of it Hope you must be using a loop to resize for each file Within that loop before using resize activity use a COPY FILE activity and have a copy of that file somewhere and then resize it So that u will be having both the old files copied somewhere and also the resized file in the actual folder path @gilang_mandiri

This post made by @supermanPunch received 2 likes!

Get Input data through Microsoft forms

Hi @Dinesh_Babu_S , We have the below method (Video Tutorial) where it explains how the Microsoft form responses are stored automatically in an Excel Sheet in OneDrive, you could then adopt the UiPath Microsoft 0365 activities to get the Excel sheet File or Read the File directly in OneDrive and process further. [How to Create a Microsoft Form with Live Responses in Excel]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Resize image dynamically

Hi, If you want to use index variable, it’s necessary to modify “Do” to “Main Sequence” at Scope as the following, because the variable is reset every time if its scope is Do. [image] Regards,

This solution provided by @Yoichi received 1 likes!

How to group a datatable?

Hi, How about the following sample? [image] dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("Place of Purchase").ToString,r("Material Number").ToString )).Select(Function(g) g.OrderBy(Function(r) CDate(r("Purchase Date"))).Last()).CopyToDataTable Sample20231013-4L.zip (9.3 KB) Regards,

This solution provided by @Palaniyappan received 1 likes!

How much does a upgrade from SAP 7.70 to 8.00 affect robots?

Fine I have seen two to three upgrades with SAP ECC platform and it’s challenges with bots been built on top of these platforms Let’s go one by one Test your robots thoroughly before deploying them to production. This is important for any upgrade, but it is especially important for a major upgrade like this. Make sure that your robots are using the latest version of the UiPath SAP activities. The UiPath SAP activities have been updated to support SAP 8.00. Check for any changes to the SAP…

---

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

Top 3 Topics with Most Views

Paste only values made by @Mohamed_Ameer1 with 37 views.

Reduce Fetched the Data after API Input made by @sneha41 with 36 views.

Process is not going into suspend state made by @RK_S with 32 views.

Top 3 Topics with Most Replies

Paste only values made by @Mohamed_Ameer1 with 15 replies.

LinQ for 2 For Loops and 1 If loop made by @yash.choursia with 13 replies.

Check Dt1 Column1 all Values Exist In the Dt2 column 1 made by @Prateek_Gulab_Pathak with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 43 posts!

@Palaniyappan made 15 posts!

@Dilli_Reddy made 14 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Update Datatable based on dictionary

Hi, I think it’s better to have the dictionary including datarow in advance. For example, using the following expression. dict = dt.AsEnumerable.GroupBy(Function(r) r("Order").ToString).ToDictionary(Function(g) g.Key,Function(g) Tuple.Create(g.Select(Function(r) r("Shipping").ToString).ToArray(),g.Select(Function(r) r).ToArray)) This way we can easily write to the finalnum to datatable just after calculated, in the loop. Can you try the following sample? [image] Sample Sample20231014-1…

This post made by @Yoichi received 2 likes!

「フォームを作成」の「チェックボックス」にUiPathで動的に生成したJSONファイルを適用したい

BuildDataTableは必須ではありません。上記ではDataTableを生成するために使っているだけです。 ただチェックボックスにするためにはColumnのDataTypeがBooleanである必要があるようなので、その点の工夫が必要と思われます。

This post made by @yash.choursia received 2 likes!

Error while Business Exception or System Exception

Thanks a lot @Shiva_Nikhil and @Anil_G .

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

「フォームを作成」の「チェックボックス」にUiPathで動的に生成したJSONファイルを適用したい

BuildDataTableは必須ではありません。上記ではDataTableを生成するために使っているだけです。 ただチェックボックスにするためにはColumnのDataTypeがBooleanである必要があるようなので、その点の工夫が必要と思われます。

This solution provided by @supermanPunch received 1 likes!

Help / Expert advice needed: PDF Table extraction (Purchase Order to Excel)

@Nilochan , For the sent sample, we are able to get the required Expected Output. You could validate it and test it out with different sample and let us know if it does not work. Regex_Extract_SpecificData2.zip (26.8 KB) However, the other format mentioned in your initial post, will not be handled, it does seem that there are one field added in it and one field removed. So, not an uniform extraction. If the extraction also needs to be adhered to different formats, we would need to know how m…

This solution provided by @Dilli_Reddy received 1 likes!

Reduce Fetched the Data after API Input

Hii @sneha41 Try this JSONOBJECT(“ActiveSystems”)(0)(“PhoneNumber”).ToString.SubString(2) or JSONOBJECT(“ActiveSystems”)(0)(“PhoneNumber”).ToString+“.”+JSONOBJECT(“ActiveSystems”)(0)(“PhoneNumber”).ToString.Split(" ")(1) This is helpful for you If anything error please let me know 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 | 15 October 2023

Top 3 Topics with Most Views

Datatable Compare for Checking Rows Exist and a Condition is true for further process made by @Prateek_Gulab_Pathak with 35 views.

How to get all Sheet names of excel using modern activities made by @aslam_ali1 with 32 views.

Creating aggregate excel made by @Floris_Maat with 31 views.

Top 3 Topics with Most Replies

Datatable Compare for Checking Rows Exist and a Condition is true for further process made by @Prateek_Gulab_Pathak with 20 replies.

How to insert data into a Table inside a desktop Application made by @kaustubh.aras28 with 9 replies.

Extract text from email body to variables? made by @salmantahir31 with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 23 posts!

@Palaniyappan made 17 posts!

@Prateek_Gulab_Pathak made 8 posts!

Top 3 Most Liked Posts

This post made by @anlinalbert received 1 likes!

How do I filter data from a csv file?

Hello, I need some help with filtering a csv file. I have a csv file that contains some data, and I want to filter it based on the following criteria: The value in the “Suspicion” column should be greater than 4. However, when I try to do that, I get only an empty data table as a result. I am not sure what I am doing wrong or how to fix it. Can anyone help me with this problem? Thank you in advance. [1] [2] [2.5] [3] [4] Filter.zip (149.7 KB)

This post made by @aslam_ali1 received 1 likes!

How to get all Sheet names of excel using modern activities

Hello friends, Any one know how to get all sheet names of excel using modern activities. Is there any way to get without excel scope. Thanks in advance

This post made by @Prateek_Gulab_Pathak received 1 likes!

Datatable Compare for Checking Rows Exist and a Condition is true for further process

(From row1 In dt_re11.AsEnumerable() Join row2 In dt_input.AsEnumerable() On row1(“SizeCode”).ToString Equals row2(“SizeCode”).toString Where Cint(row1(“TotalQty”).ToString) < Cint(row2(“TotalQty”).ToString) Select row1).CopyToDataTable [image]

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Missing link to UiPath-RPAv1: UiPath RPA Associate v1.0 Exam at Pearson Vue website

@Harish_Rajanna Welcome to the community The 3rd one in your list UiPath-adav1 is the english version of the new associate exam… Old ones are removed [IMG_6348] Cheers

This solution provided by @Palaniyappan received 1 likes!

Can someone help me with the date algorithm to achieve the following

Yeah that works and it’s a good approach you can use a JSON to store the dynamic date values for the From Date and To Date parameters. This will allow you to handle both previous and future dates in the same process. First, define your JSON structure. You can create a JSON string like this { "status": "previous date", "fromDate": "last dispatcher run date", "toDate": "current date - 1" } Now, if the status is “future date,” you can set it like this { "status": "future date", "fromDate": "c…

This solution provided by @supermanPunch received 1 likes!

Datatable Compare for Checking Rows Exist and a Condition is true for further process

@Prateek_Gulab_Pathak , It seems that there are empty row values in your Datatables, Could you check by first performing the update of the Datatable with the below Expression : OutputDT = OutputDT.AsEnumerable.Where(Function(x)Not x.ItemArray.All(Function(y)String.IsNullOrWhiteSpace(y.ToString.Trim))).CopyToDatatable You could then check the condition provided previously :

---

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

Top 3 Topics with Most Views

Give me best prompt to prepare for uipath job interview using uipath made by @Vajrang with 59 views.

How to Remove duplicate rows in columns and delete it made by @suraj_gaikwad with 56 views.

What is a diffrefrence between Coded Workflow and Code Source File made by @indiedev91 with 51 views.

Top 3 Topics with Most Replies

How to display the employees names starts with S and J made by @Bhagyashree_S with 25 replies.

How to Remove duplicate rows in columns and delete it made by @suraj_gaikwad with 24 replies.

How do i extract the month number out of today's date in the modify date activity made by @josiahgoh276 with 24 replies.

Top 3 Users Who Posted The Most

@Anil_G made 42 posts!

@Dilli_Reddy made 26 posts!

@Shiva_Nikhil made 25 posts!

Top 3 Most Liked Posts

This post made by @RAKESH_KUMAR_BEHERA received 2 likes!

UiPath Certification Latest Updates Oct 2023

On October 13 2023, UiPath has made changes to the Developer – Automation Track certifications. UiPath is introducing two new certifications: UiPath Certified Professional Automation Developer Associate and UiPath Certified Professional Automation Developer Professional. These two certifications will replace the old RPA Associate and Advanced RPA Developer certifications. Starting from October 13, 2023, new candidates won’t be able to get the RPA Associate and Advanced RPA Developer certificati…

This post made by @Bhagyashree_S received 2 likes!

How to display the employees names starts with S and J

Hi team, I have got the number of employees names with get text activity and now I want to get the employees names that starts with letters S and J. Can u please help me with this asap.

This post made by @Learner007 received 2 likes!

Extract multiple pages LinkedIn Jobs

Thanks for your responses. I found another solution to solve this. After performing search in top we get results count and every page have 25 records so I’m dividing results/25 and based on that count I’m changing the page number.

Top 3 Most Liked Solutions

This solution provided by @Learner007 received 2 likes!

Extract multiple pages LinkedIn Jobs

Thanks for your responses. I found another solution to solve this. After performing search in top we get results count and every page have 25 records so I’m dividing results/25 and based on that count I’m changing the page number.

This solution provided by @supriya117 received 1 likes!

Generate Yearly Report TaxID Split

Hi @tolgademir Try this: taxID = StrVendorInformationGetText.Split(":"c)(1).Trim().Split(" "c)(0)

This solution provided by @Yoichi received 1 likes!

How to use a nested For Each loop

HI, I think it should be as the following. if UserGuessArray(i) = RandomNumber(j) AndAlso i<>j Can you also try the following sample? Sample20231016-4L.zip (3.4 KB) 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 | 17 October 2023

Top 3 Topics with Most Views

Error Message "Job stopped with an unexpected exit code: 0x40010004" and "Could not start executor. Creating user session timed out." made by @nisargkadam23 with 68 views.

Difference between action center and AI made by @babita with 46 views.

UiPath Modern Design Selector made by @Ritaman_Baral with 42 views.

Top 3 Topics with Most Replies

How to read Only file name and not full path in Uipath dynamic dropdown button made by @tarangmehta1195 with 26 replies.

Can anyone tell me what is this doing? Out_ClientID = ClientInformation.Substring(ClientInformation.IndexOf("ClientID: ") + "Client ID: ".Length).Split(Environment.NewLine.ToCharArray)(0) made by @Jai_Pande with 19 replies.

UiPath Modern Design Selector made by @Ritaman_Baral with 14 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 37 posts!

@Dilli_Reddy made 36 posts!

@supermanPunch made 30 posts!

Top 3 Most Liked Posts

This post made by @postwick received 2 likes!

Seletors in modern activities

I’m surprised this is what the documentation says. The way it was explained to me on a deep dive conference call with a member of the UiPath product team, it actually tries to use strict first and if it doesn’t find it then it bounces down to fuzzy, if that doesn’t find it then it bounces down to image, then computer vision. There are supposed to be some changes coming (I think in 2023.10) to make it more efficient as far as managing the timeout etc. @loginerror I wonder if we could get som…

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

How do I Remove the Line Break in String?

@Parvathy @Dilli_Reddy Thank You all for the Solutions. Working Fine

This post made by @supermanPunch received 2 likes!

Assign Column value without using for each dt

Hi @AbarnaKalaiselvam , The Error is due to the Incorrect Double Quotes used, Re-Type the Double Quotes in the Expression (Not Copy Paste) and check : dt.rows(0)("PIN") = IssueKey.CustomFields("PIN").Values(0)

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

Assign Column value without using for each dt

Hi @AbarnaKalaiselvam , The Error is due to the Incorrect Double Quotes used, Re-Type the Double Quotes in the Expression (Not Copy Paste) and check : dt.rows(0)("PIN") = IssueKey.CustomFields("PIN").Values(0)

This solution provided by @supermanPunch received 1 likes!

Last line of letter using REGEX

Hi @m.soto , Using regex with groups, we should be able to pick the last line value : (?s:.*\r?\n)*(.+)$ [image] System.Text.RegularExpressions.Regex.Match(InputText,"(?s:.*\r?\n)*(.+)$",System.Text.RegularExpressions.RegexOptions.Multiline).Groups(1).value.ToString Debug Panel : [image]

This solution provided by @ppr received 1 likes!

Getting Unique Values from a List of Strings

We split, Trim and distinct like: [grafik]

---

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

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

[system]

Daily Forum Report | 18 October 2023

Top 3 Topics with Most Views

AI at Work | In-Person (24 hours) Hackathon is in Bengaluru this 25th - 26th November | Registrations extended till November 7 made by @Rohit_Radhakrishnan with 104 views.

I want to get the Xaml File Name automatically using activity made by @hashimotosyunsaku with 43 views.

How do I change Datatable to Dictionary, made by @superpunchypp with 41 views.

Top 3 Topics with Most Replies

Cannot extract all rows made by @ahmmed.kathem with 21 replies.

Windows legacy and URL and Xpath activities made by @steved with 21 replies.

Need to use click activity after disapearing a pop op message made by @Soudios with 19 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 47 posts!

@Palaniyappan made 44 posts!

@ppr made 41 posts!

Top 3 Most Liked Posts

This post made by @Rohit_Radhakrishnan received 9 likes!

AI at Work | In-Person (24 hours) Hackathon is in Bengaluru this 25th - 26th November | Registrations extended till November 7

[AIatWork Hackathon] AI at Work Hackathon 2023, Bengaluru is now open for registration as the first UiPath Community in-person hackathon in 3 years! This year, we invite you to bring on your innovative ideas around how you see AI Powered Automation enhancing the overall work processes experience. Some themes for you to explore for Ideation: Improving productivity and efficiency using AI at Work AI at Work, improving the customer/end user experience. Chatbots and Virtual Assis…

This post made by @Dilli_Reddy received 3 likes!

Can not publish to any feed because of version error

UiPath.Nuget.Package likely pertains to a version compatibility issue with the packages used in your UiPath project. This can occur when there’s a mismatch between the version of a package referenced in your project and the version that the project is trying to use during execution Check Package Versions,open the package manager Update or downgrade packages to ensure compatibility.

This post made by @Gokul001 received 2 likes!

How to get the Week number, First, and last day for the given date

Hi @K_GOWTHAM This expression will get the Week Number in Integer CInt(System.Globalization.CultureInfo.InvariantCulture.Calendar.GetWeekOfYear(New Datetime(2023,10,18),System.Globalization.CalendarWeekRule.FirstDay,DayOfWeek.Sunday).ToString) First Date of the week New dateTime(Now.Year,1,1).AddDays(7*(CInt(System.Globalization.CultureInfo.InvariantCulture.Calendar.GetWeekOfYear(New Datetime(2023,10,18),System.Globalization.CalendarWeekRule.FirstDay,DayOfWeek.Sunday).ToString)-1)-CInt(New d…

Top 3 Most Liked Solutions

This solution provided by @Dilli_Reddy received 3 likes!

Can not publish to any feed because of version error

UiPath.Nuget.Package likely pertains to a version compatibility issue with the packages used in your UiPath project. This can occur when there’s a mismatch between the version of a package referenced in your project and the version that the project is trying to use during execution Check Package Versions,open the package manager Update or downgrade packages to ensure compatibility.

This solution provided by @Gokul001 received 2 likes!

How to get the Week number, First, and last day for the given date

Hi @K_GOWTHAM This expression will get the Week Number in Integer CInt(System.Globalization.CultureInfo.InvariantCulture.Calendar.GetWeekOfYear(New Datetime(2023,10,18),System.Globalization.CalendarWeekRule.FirstDay,DayOfWeek.Sunday).ToString) First Date of the week New dateTime(Now.Year,1,1).AddDays(7*(CInt(System.Globalization.CultureInfo.InvariantCulture.Calendar.GetWeekOfYear(New Datetime(2023,10,18),System.Globalization.CalendarWeekRule.FirstDay,DayOfWeek.Sunday).ToString)-1)-CInt(New d…

This solution provided by @ppr received 2 likes!

Disabling specific triggers in a folder using Orchestrator HTTP Request

@fredslund7889 We cross - checked within Swagger and it was working when using the ID as highlighted above

---

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

Top 3 Topics with Most Views

Can anyone solve this please..? made by @Jai_Pande with 64 views.

Extract data from Multiple tables on a single web page made by @minesh.kumar with 41 views.

Eventos de preparación para certificación Automation Developer - Lima - Cono Sur made by @dokumentor with 36 views.

Top 3 Topics with Most Replies

Can anyone solve this please..? made by @Jai_Pande with 34 replies.

Csv Output Issue - Don’t want to round off value in CSV file made by @Naveen_Chaganti with 15 replies.

Extract all file names in a folder and need to write in an excel made by @JOBIN_JOSE with 12 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 37 posts!

@Jai_Pande made 27 posts!

@Shiva_Nikhil made 23 posts!

Top 3 Most Liked Posts

This post made by @dokumentor received 4 likes!

Eventos de preparación para certificación Automation Developer - Lima - Cono Sur

Generamos este espacio para comentarios y consultas correspondientes a la serie de eventos de preparación para certificar UiPath-ADP que hostean los chapters de Lima y Cono Sur

This post made by @OsoPolar received 3 likes!

Exciting News: Revamped and New Certifications Unveiled!

Hi Community, I’m concerned about the high cost of the UiPath Certified Professional Automation Developer Professional exam, which is currently priced at $300 plus tax per attempt for the certificate Automation Developer Professional. UiPath’s success has largely depended on its vibrant developer community. It’s vital that we maintain an inclusive environment. These price increases may discourage both newcomers and dedicated community members from pursuing certification. Cheers,

This post made by @shaik.muktharvalli1 received 1 likes!

I have to get Highlighted word

I have to get Highlighted [image] Thank Shaik Muktharvalli

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

I have a several data tables, and a I want to save them in one data set, how can i do that?

Hi @Jamerson_Gabriel_Renosto1 , Could you maybe try using the Invoke Method activity in the below way : [image] TargetObject : DS.Tables MethodName : AddRange Parameters : Type - Array of Datatables - {DT1,DT2} Here, DS is a variable of type DataSet and it is initialised before using Invoke Method activity. The DT1 and DT2 are the datatable variables to be added to the dataset.

This solution provided by @Steven_McKeering received 1 likes!

Can anyone solve this please..?

Hey @Jai_Pande The error is happening because the datatable has not been created. As you said: Try this, change the condition to: io_dt_TransactionData is nothing [image] [image] You can only reference the row count of a datatable after it has been created. Cheers Steve

This solution provided by @Yoichi received 1 likes!

GET Text On uipath

Hi, How about the following expression? System.Text.RegularExpressions.Regex.Match(yourString,"(?<=END OF PAGES\s+)[\s\S]*").Value [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 October 2023

Top 3 Topics with Most Views

Adding rows to the data table after LINQ made by @marcin.chowaniec with 45 views.

How to Use the 'Break' Activity in an 'If' Clause to Exit a 'Do While' or 'While' Loop made by @indiedev91 with 43 views.

Need to extract the row count from an excel made by @JOBIN_JOSE with 40 views.

Top 3 Topics with Most Replies

How to Use the 'Break' Activity in an 'If' Clause to Exit a 'Do While' or 'While' Loop made by @indiedev91 with 17 replies.

How to write or append bulk data in existing workbook? made by @suraj_gaikwad with 14 replies.

Not able to display the age of employees made by @Bhagyashree_S with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 31 posts!

@Gokul001 made 24 posts!

@ppr made 21 posts!

Top 3 Most Liked Posts

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

Automation Business Analyst Series 2023

Got any plans for autumn?:maple_leaf: UiPath Community is launching a one month long intensive training series dedicated entirely to aspiring and practicing Automation Business Analysts. This is a unique opportunity to embark a like-minded learning cohort, guided by UiPath experts, product managers and MVPs, and gain an incredible skill asset before the year is done. UiPath Business Analyst Webinar Series​:boom: Nov 13 - Dec 13, Mon & Wed/each week/live or self-paced …

This post made by @Yoichi received 2 likes!

Convert different(multiple) types of date into the one fix date format

Hi, Can you try the following expression? CDate(System.Text.RegularExpressions.Regex.Replace(currentItem,"(\d+)\W+(\w+)\W+(\d+)","$2/$1/$3").Trim).ToString("dd MMMM yyyy") [image] Sequence.xaml (6.5 KB) Regards,

This post made by @supermanPunch received 2 likes!

Replace Activity Help

Hi @Emmanuel_Mutua , I believe it is called as Extract Text activity ? [image]

Top 3 Most Liked Solutions

This solution provided by @Dilli_Reddy received 1 likes!

How to insert multiple columns in sql database

@jaranrikki_17 use this query INSERT INTO TableName (Column1, Column2, Column3…) VALUES (‘Value1’, ‘Value2’, ‘Value3’…); use quotes in values Cheers…!

This solution provided by @Palaniyappan received 1 likes!

Bringing Excel Documents Into Studio

Re download the zip and see whether u could see there r not If not create ur own and try it out @smcphillip

This solution provided by @lrtetala received 1 likes!

Need to extract the row count from an excel

Hi @JOBIN_JOSE In Read Range Workbook activity uncheck AddHeaders option [image] 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 | 21 October 2023

Top 3 Topics with Most Views

Getting data first time in Array but not next time made by @c3f1e68294fdcf4a1f0a817ca with 37 views.

ERROR - ' ' is an unexpected token made by @111976 with 33 views.

How to filter the data and add them made by @anjani_priya with 30 views.

Top 3 Topics with Most Replies

How to filter the data and add them made by @anjani_priya with 28 replies.

Filter the Dates in Excel made by @lomarnash643 with 12 replies.

How to delete entire row in excel if the specific column is empty made by @Nur.ain with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 46 posts!

@Palaniyappan made 26 posts!

@anjani_priya made 11 posts!

Top 3 Most Liked Posts

This post made by @lomarnash643 received 3 likes!

Filter the Dates in Excel

@Shiva_Nikhil @Parvathy @lrtetala thank you for the reply Its working

This post made by @anjani_priya received 2 likes!

How to filter the data and add them

Book1.xlsx (8.5 KB) Here is the sample file,How to add the data only the dept IT and age should be 21.How to add that data.

This post made by @Kaviya_V received 2 likes!

How To Convert HTML to Text

Thanks @Palaniyappan and @Anil. I will check and update You

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

First automation Problem

Hi, Can you try to add the following expression just after GeText activty? CurrentRow("UnicornName") = uniName Then Write the datatable to the file using WriteRange outside the loop. [image] MainV2.xaml (28.1 KB) Regards,

This solution provided by @ppr received 1 likes!

For each File in Folder Get Name

give a try at Path.GetFileName(currentItem)

This solution provided by @Dilli_Reddy received 1 likes!

Activity Package not installed

@jaranrikki_17 click on manage packages and go to all packages type UiPath.OCR.activities [image] click and install n save the packages

---

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

Top 3 Topics with Most Views

Getting different confidence for the same field and same document in Document understanding extraction result made by @aslam_ali1 with 31 views.

Issue with reading dictionary value made by @anlinalbert with 31 views.

Excel Read Range not working made by @Sathish_Ashokan with 31 views.

Top 3 Topics with Most Replies

Writing Extracted info to Excel made by @J_Crosby with 16 replies.

Excel Read Range not working made by @Sathish_Ashokan with 9 replies.

Issue with reading dictionary value made by @anlinalbert with 7 replies.

Top 3 Users Who Posted The Most

@Yoichi made 13 posts!

@supermanPunch made 12 posts!

@J_Crosby made 8 posts!

Top 3 Most Liked Posts

This post made by @J_Crosby received 2 likes!

Writing Extracted info to Excel

ooh my bad! I didn’t know I am supposed to click the ELSE then drop the activity in there @supermanPunch you were so right my write range was outside. I just did that and it worked. Thank you guys for being patient with me.

This post made by @Yoichi received 1 likes!

Hello, I need to convert this format date 12/04/1996 to letter format i.e. april twelve, nineteen hundred and ninety six

Hi, How about using the following custom activity? [image] Sample Sample20231023-1.zip (2.7 KB) Regards,

This post made by @J_Crosby received 1 likes!

Writing Extracted info to Excel

@Palaniyappan see above,I think this is the structure you are suggesting or coz that’s what I have

Top 3 Most Liked Solutions

This solution provided by @hale_kaimana received 1 likes!

ワークフローがコンパイルされていることを確認してください

ありがとうございます。 やはりダブルクォーテーションでした。 もう一度新しいプロセスで丁寧に手入力すると解消されました。 しかし、その設定値をレガシーのプロセスにコピペしても解消されません。 （依存関係はどちらも最新で合わせました。） レガシーのプロセス上でアクティビティを作り直しても同じでした。 検証に使える時間がもう無いので、新環境で作り直そうと思います。 ありがとうございましたm(__)m lrtetalaさんも、ありがとうございました！

---

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.