Forum Engagement Daily Reports

[system]

Daily Forum Report | 18 October 2024

Top 3 Topics with Most Views

The method to use Replace in a DataTable help made by @22222222asas with 24 views.

Clear browser history made by @Lakshya_Garg2 with 23 views.

Delete folder made by @A_Learner with 23 views.

Top 3 Topics with Most Replies

How to get selected check box value using form extractor in DU made by @Akshaya89 with 22 replies.

Paste unique value made by @Darkfighter with 11 replies.

Delete folder made by @A_Learner with 10 replies.

Top 3 Users Who Posted The Most

@Akash_Javalekar1 made 12 posts!

@Akshaya89 made 11 posts!

@Yoichi made 11 posts!

Top 3 Most Liked Posts

This post made by @SangramGhadge received 2 likes!

Celebrating Our Outstanding Community Contributors: Meet our 11 Forum Moderators 2024

Congratulations Everyone. Keep Automating

This post made by @dokumentor received 2 likes!

Join AI Associate Developer Series 2024!

Hi @ijanszen1 Attending all sessions is not mandatory. You will need to register for at least one of the sessions to be included in the invitation to take the verification exam. Then depending on the results you can be eligible for a free voucher or a discount. Anyway we recommend reviewing the videos, If you are new to UiPath RPA development we recommend you start from the first session if not maybe starting from Session 3 will be fine

This post made by @Shahazeer_Ummer_D received 2 likes!

The method to use Replace in a DataTable help

Hi @22222222asas, Based on the regex you provided refer the xaml attached below for the solution. Test.xaml (8.4 KB) The LINQ query iterates over each row in the DataTable and applies the Replace function to every item (cell) in the row, removing whitespaces and parentheses. It then adds the modified rows to a cloned DataTable, preserving the original structure but with the cleaned-up data. Hope this helps , Thank you

Top 3 Most Liked Solutions

This solution provided by @Shahazeer_Ummer_D received 2 likes!

The method to use Replace in a DataTable help

Hi @22222222asas, Based on the regex you provided refer the xaml attached below for the solution. Test.xaml (8.4 KB) The LINQ query iterates over each row in the DataTable and applies the Replace function to every item (cell) in the row, removing whitespaces and parentheses. It then adds the modified rows to a cloned DataTable, preserving the original structure but with the cleaned-up data. Hope this helps , Thank you

This solution provided by @Melroy_Dsa received 1 likes!

RPA 作业

Hi @YI_LI_WU, Based on the information provided, let’s assume you’ll input the number of players who will be participating in the game. You can then dynamically create either a Dictionary or an Integer Array, where the size corresponds to the number of players. Initialize all the values (or indexes) to 0. Each player will take turns sequentially. Every time it’s a player’s turn, you’ll increment their value in the array or dictionary by 1. The process continues like this, looping through each …

This solution provided by @Yoichi received 1 likes!

How to find the same value from the web in Excel help

Hi, If you want to use ReadRange, the following will help you. [image] dr = dt.AsEnumerable.Where(Function(r) r.ItemArray.Skip(1).Any(Function(o) o.ToString="d7002")).FirstOrDefault() note: dr is DataRow type 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 | 19 October 2024

Top 3 Topics with Most Views

Hi team run time I need add "," in my string made by @Kutchu_Umakanth with 18 views.

Need to shrink image size below 240 kb made by @Ush_Dhar with 16 views.

Not sure how to resolve this made by @mint with 16 views.

Top 3 Topics with Most Replies

How to retry email for 10 mins? made by @Shruthika_r with 8 replies.

Not sure how to resolve this made by @mint with 5 replies.

Need to shrink image size below 240 kb made by @Ush_Dhar with 4 replies.

Top 3 Users Who Posted The Most

@Anil_G made 26 posts!

@Darkfighter made 5 posts!

@sudster made 5 posts!

Top 3 Most Liked Posts

This post made by @Terry_Marr received 1 likes!

How to get values from Uipath.Form?

OK that worked. Are you saying that the ONLY way to get values out of the Forms activity is to first make a bunch of global variables to set the returning values to? Is there a way to assign the whole dictionary object at once and pass that?

This post made by @AJ_Ask received 1 likes!

Need to shrink image size below 240 kb

Hi @Ush_Dhar You can use from UiPath.PDF.Activities Package activity called ExportPDFPageAsImage Loop through all the pages in the pdf for images. You can use the Get File Info Activity and check the Size of the image in loop. Ref- How do i get exact image size? - #4 by rikulsilva If above 240 kb you can resize the image by using following way Ref- Resize images - #10 by ppr Hope this helps

This post made by @Akash_Javalekar1 received 1 likes!

Extract table from PDF - Document Understanding

Hi @Ralph_Sena26 please find workflow solution I have used form extractor which can extract table from the given pdf Document_Understanding.zip (559.1 KB) Let me know if its work for you [This image shows an invoice from Xerox, detailing charges for equipment and software, along with tax details by jurisdiction, and displayed within a data extraction interface. (Captioned by AI)]

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

UiPath notifcation summary

@Suastrian_Dika tenant → Settings → mail → Turn off enable email alerts 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 | 20 October 2024

Top 3 Topics with Most Views

How to filter state wise based on column value made by @Raja.G with 16 views.

How to resolve this error in Http request? made by @naveen.s with 16 views.

When should you choose the Orchestrator API? made by @Rahul_Rajendran with 11 views.

Top 3 Topics with Most Replies

ネストされたDataTableから抽出 made by @sanpo.daikou24 with 10 replies.

When should you choose the Orchestrator API? made by @Rahul_Rajendran with 9 replies.

How to resolve this error in Http request? made by @naveen.s with 6 replies.

Top 3 Users Who Posted The Most

@Ehab_Sawars made 9 posts!

@ashokkarale made 7 posts!

@Erimateia made 6 posts!

Top 3 Most Liked Posts

This post made by @rashmisingh2695 received 2 likes!

How to filter state wise based on column value

Hi @Raja.G Can you please try with this workflow Filter_DT.xaml (10.2 KB) [The image illustrates a workflow for reading data from a spreadsheet, filtering the data based on certain conditions and state mappings, and then writing the filtered data back into separate sheets for US and CA states using an automation script. (Captioned by AI)]

This post made by @ashokkarale received 1 likes!

When should you choose the Orchestrator API?

@Rahul_Rajendran, Any action over Orchestrator you would like to perform automatically on the basis of some condition or requirement can be the good use case for using Orchestrator API’s. The UiPath Orchestrator API offers a wide range of capabilities that can be leveraged for various use cases1. Here are some key examples: Managing Queues and Queue Items: Programmatically add, retrieve, and update work items in queues1. Starting and Stopping Jobs: Kickoff automation jobs on-demand or on a s…

This post made by @rashmisingh2695 received 1 likes!

How to add veriable in query of get message activity in office 365

Hi @Hemant_Deshmukh You can try to write the query like this assuming srt.number is the variable "contains(subject, 'project report no" + srt.number.toString + "')"

Top 3 Most Liked Solutions

This solution provided by @rashmisingh2695 received 2 likes!

How to filter state wise based on column value

Hi @Raja.G Can you please try with this workflow Filter_DT.xaml (10.2 KB) [The image illustrates a workflow for reading data from a spreadsheet, filtering the data based on certain conditions and state mappings, and then writing the filtered data back into separate sheets for US and CA states using an automation script. (Captioned by AI)]

This solution provided by @ashokkarale received 1 likes!

Api vs odata

@A_Learner, It’s nothing but just how the resources are organized. It delineates how to access specific resources or data points within the API. For example, in the path “/api/Stats/GetJobsStats”: /api represents the base endpoint. /Stats is a specific resource within the API. /GetJobsStats is the action or specific operation you want to perform on that resource. Similarly we have few others also like /forms/ /odata/ It’s a way to organize and direct the flow of data requests and responses…

This solution provided by @Erimateia received 1 likes!

Variables not fully copying when transferring sequences between workflows in UiPath

Hi @Fauzia_Ajaz In UiPath, when you copy a sequence from one workflow to another, some variables are copied automatically and others need to be added manually due to the way variables are defined in the workflow scope. Variables in UiPath have a specific scope, which defines where they can be accessed. When you copy a sequence, only variables that are in the same scope as the copied sequence are automatically transferred. If a variable is defined in a broader scope (for example, at the parent …

---

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 2024

Top 3 Topics with Most Views

UiPath Community Veterans Training Program made by @DeaTo with 34 views.

How to resolve this issue? made by @naveen.s with 28 views.

Unable to send email using SMTP activity made by @Deeksha with 27 views.

Top 3 Topics with Most Replies

How to resolve this issue? made by @naveen.s with 18 replies.

How to split "20/10/24 Domestic" to generate only the date made by @shilpashree.mohanty with 18 replies.

Error in Python Scope Activity made by @Sanket_Tidke with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 28 posts!

@ashokkarale made 26 posts!

@Yoichi made 17 posts!

Top 3 Most Liked Posts

This post made by @DeaTo received 4 likes!

UiPath Community Veterans Training Program

We are proud to present to you the UiPath Community Veterans Training Program See UiPath Community Veterans Training Program at UiPath UiPath Community Veterans Program This is your opportunity to discover what UiPath AI-powered automation is all about. Through this program you can start equipping yourself with the skills and knowledge necessary to excel in this rapidly evolving automation developer landscape. We will guide you through the program w…

This post made by @ashokkarale received 2 likes!

Error in Python Scope Activity

@Sanket_Tidke, Have you installed .Net Runtime 6.0? Also follow these How to guides:

This post made by @sallavudeen_ashwin received 1 likes!

Become a 2025 UiPath Community MVP – Apply Now

Thanks @Vibhor.Shrivastava for sharing this . Will use this Oppurtunity effectively…

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

Error in Python Scope Activity

Python v3.12 - Invoking a script.zip (97.9 KB) This solution worked

This solution provided by @Yoichi received 1 likes!

Windowsレガシプロジェクトの実行端末について

こんにちは 基本的には問題なく動作します。 （日本語訳は「対応OS」となっていますが、英語ですとCompatibility となっており、OSそのものは同じWindowsであればそれほど問題になりません）

This solution provided by @ashokkarale received 1 likes!

Give input from Assistant

@Shravan_Pintu, Create arguments in your Main.xaml like this and publish the code. In Assistant it should show you these arguments where you can pass your desired inputs to the bot. [The image shows a UiPath workflow sequence with assignments to retrieve and process directory files, including arguments for input parameters. (Captioned by AI)]

---

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 2024

Top 3 Topics with Most Views

Selector dynamic issue made by @sruthesanju with 24 views.

How to filter? made by @naveen.s with 23 views.

Task Mining client doesn't support Windows 11 - really? made by @karpatan with 19 views.

Top 3 Topics with Most Replies

Error in saving information in excel made by @Liliana_Novais with 12 replies.

System Exception Not working as Expected made by @marina.dutta with 11 replies.

Excel filter for multiple selection made by @Omkar_Shete2 with 9 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 24 posts!

@Anil_G made 18 posts!

@sudster made 11 posts!

Top 3 Most Liked Posts

This post made by @Sanket_Tidke received 2 likes!

Error in Python Scope Activity

Thank You @ashokkarale for providing proper solution by connecting over the call. Here is the resolution for everyone: -Install Python V3.12 64bit -Install Python application in accessible “c” folder i.e. C:\Program files\Python -Install .net windows desktop runtime V6.0.32 64bit .NET Core 6.0.32 - Versions of .NET -Python Activity Package 1.8.1 or above

This post made by @ashokkarale received 2 likes!

Parallel activity is executing Left to Right. Shouldn't it be parallel?

@FayazMohammed, If we use other activities than invoke workflow inside the parallel activity, it works left to right not simultaneously but if you put your logic in separate workflows and use Invoke Workflow File activity inside Parallel activity, it works parallelly. Refer these threads for more discussions on this. [Parallel Activity in UiPath Example]

This post made by @Yoichi received 2 likes!

パブリッシュのエラーを解消したい

こんにちは 説明が「空のテンプレート」になっていますので、おそらくテンプレートプロジェクトですね。 右上の「プロセス」で作成しなおしてみてください。

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 2 likes!

Parallel activity is executing Left to Right. Shouldn't it be parallel?

@FayazMohammed, If we use other activities than invoke workflow inside the parallel activity, it works left to right not simultaneously but if you put your logic in separate workflows and use Invoke Workflow File activity inside Parallel activity, it works parallelly. Refer these threads for more discussions on this. [Parallel Activity in UiPath Example]

This solution provided by @sven.wullum1 received 1 likes!

Such a hassle finding downloads today

Hi, You could just use the customer portal? Product Downloads

This solution provided by @Yoichi received 1 likes!

並列アクティビティの条件が空白の場合

こんにちは 試した方が早いかと．．． [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 | 23 October 2024

Top 3 Topics with Most Views

Get Queue Items fetches 100 queue items made by @thima with 19 views.

Catch Block on Orchestrator made by @Jyothi31 with 19 views.

Automation problem in an excel file and looping queries on chrome made by @Julie2 with 17 views.

Top 3 Topics with Most Replies

複数ファイルのDataRowを積みあげてDataTableを作成したい made by @gorby with 15 replies.

Unseeing Browser made by @michelle.soto with 13 replies.

Update status if column has duplicate value made by @Lakshya_Garg2 with 12 replies.

Top 3 Users Who Posted The Most

@Yoichi made 28 posts!

@ashokkarale made 26 posts!

@Anil_G made 12 posts!

Top 3 Most Liked Posts

This post made by @sven.wullum1 received 2 likes!

Terminal Emulator approach

Hi! As pointed out by @mateuszmacheta CV is quite taxing, and furthermore is not as reliable as the more traditional approaches (Computer Vision relies on visually extracting the text). Here’s a screenshot of the “Configure Connection” you will have to do with the Terminal Session activity: [image] Just install the Terminal Activities package in your Studio and take a look. Using the Direct Connection you could “bypass” the emulater and connect directly to the “source”. Read up on it here…

This post made by @golla.sandeep received 2 likes!

Unable to install uipath.form.activities package

have you checked if this custom package repository(C:\Users.nuget\packages directory) is added to studio Package repo sources? Regards SG.

This post made by @savantsa received 1 likes!

How to combine multiple assign statements into a single multi-assign

I wish there was a way to combine multiple assign activities into a single multi-assign with a single click. Perhaps, we could select the individual activities and right click to see an option to combine. Needless to say, only if we selected assign statements. I feel this can go a long way in reducing the time it takes to do this manually and improve productivity as well as accuracy.

Top 3 Most Liked Solutions

This solution provided by @sven.wullum1 received 2 likes!

Terminal Emulator approach

Hi! As pointed out by @mateuszmacheta CV is quite taxing, and furthermore is not as reliable as the more traditional approaches (Computer Vision relies on visually extracting the text). Here’s a screenshot of the “Configure Connection” you will have to do with the Terminal Session activity: [image] Just install the Terminal Activities package in your Studio and take a look. Using the Direct Connection you could “bypass” the emulater and connect directly to the “source”. Read up on it here…

This solution provided by @ashokkarale received 1 likes!

Custom activity into orchestrator

@Shravan_Pintu, I assume it’s how to import the activity into Orchestrator. You can publish the package directly to tenent feed or navigate to tenent -->packages -->upload package. The main difference between a custom activity and a reusable activity lies in their design and usage. A custom activity refers to a user-defined operation specifically tailored for a particular workflow or application. It is designed to perform a unique function that maybe isn’t available in standard library acti…

This solution provided by @ashokkarale received 1 likes!

Can't find the way to integrate Data Service into Apps dropdown list

@hongjoo.choi, Follow these steps: Click on Config icon of List source and Select Query Builder [This image shows a dropdown component configuration interface, with the "Query builder" option circled on the right-hand "General" settings panel. (Captioned by AI)] Select the entity you desired and click save. Here mine is Test [A query builder interface shows a dropdown menu with options and the "Save" button circled in red. (Captioned by AI)] Your List Soruce should be look like thi…

---

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

Top 3 Topics with Most Views

How to read the Excel based on scenario made by @balanirmalkumar.s with 21 views.

Error while deleting specific folder made by @Akshaya89 with 20 views.

How do you manage to do some code reviews in studio projects made by @Matt67 with 19 views.

Top 3 Topics with Most Replies

System Exception occuring made by @AsadPathan2665 with 13 replies.

How to read the Excel based on scenario made by @balanirmalkumar.s with 12 replies.

Get List info Activity Error (Office 365 Actvities) in Orchestrator made by @Chetan_Wagh with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 34 posts!

@ashokkarale made 22 posts!

@jast1631 made 9 posts!

Top 3 Most Liked Posts

This post made by @evan.cohen received 3 likes!

Web Apps: Public Preview - Build Apps in Studio Web

Hello UiPath Forum! Along with many other capabilities launching in 2024.10, we’re excited to kick off the Public Preview of Web Apps, which the community can now build directly within Studio Web. What makes Web Apps different? Web Apps are over 40x faster invoking workflows at runtime (yes, you read that right) Web Apps are easier to build (stick around and find out how) Web Apps use inline workflows as event handlers instead of rules Web Apps support easy debugging via breakpoints and watch…

This post made by @Roman-Routinuum received 1 likes!

Celebrating Our Outstanding Community Contributors: Meet our 11 Forum Moderators 2024

Congratulations! Thanks so much for your unrelenting effort on here!

This post made by @Anil_G received 1 likes!

Clarification on UIPath licenses and Orchestrator Requirements

@varenyeolad Orchetsrator is part of it Ideally it is needed. Yes it is Cloud gets more pactches, new features faster, No platform maintainance, infra cost is reducd… On prem, your own cloud, upgrades can wait till you need, whole control on you current - https://licensing.uipath.com/ on prem vs cloud - Advantages/Disadvantages of On-Prem and Cloud Orchestrator - #3 by Anil_G cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Clarification on UIPath licenses and Orchestrator Requirements

@varenyeolad Orchetsrator is part of it Ideally it is needed. Yes it is Cloud gets more pactches, new features faster, No platform maintainance, infra cost is reducd… On prem, your own cloud, upgrades can wait till you need, whole control on you current - https://licensing.uipath.com/ on prem vs cloud - Advantages/Disadvantages of On-Prem and Cloud Orchestrator - #3 by Anil_G cheers

This solution provided by @ashokkarale received 1 likes!

Cant capture the save print output as

@Jyothi31, That’s great! Kindly close the thread by marking my answer as solution. This will be helpful to other community members as well.

This solution provided by @ashokkarale received 1 likes!

How to pass file path dynamically in Invoke VbScript Activity?

@Sanket_Shinde1, Click on Input Arguments and pass a string argument with your dynamic file path [The image shows a software interface for setting and invoking VBScript with input arguments, highlighting the string variable "strFilePath" as an input argument in the arguments dialog. (Captioned by AI)] Inside you script, replace your hard coded file with this code: Set objWorkbook = objExcel.Workbooks.Open(WScript.Arguments(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 | 25 October 2024

Top 3 Topics with Most Views

Adding a row to a data table problem made by @goropopovic with 20 views.

Count the banana from excel made by @Shravan_Pintu with 19 views.

https://forum.uipath.com/t/775646 made by @Kruthi_BS with 18 views.

Top 3 Topics with Most Replies

https://forum.uipath.com/t/775646 made by @Kruthi_BS with 13 replies.

Count the banana from excel made by @Shravan_Pintu with 9 replies.

Adding a row to a data table problem made by @goropopovic with 8 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 33 posts!

@Anil_G made 29 posts!

@jast1631 made 19 posts!

Top 3 Most Liked Posts

This post made by @ijanszen1 received 2 likes!

Adding a row to a data table problem

@SorenB that’s a cool idea, haven’t seen that yet. @goropopovic when you hover over the red dot with your mouse, what does the error say? No need to ‘suppose’, UiPath should give some information there

This post made by @Anil_G received 2 likes!

Best practices for UiPath Studio -> Git/GitLab integration: Branches vs Separate Projects?

@yosemitesam Ideally maintaining them separate would be a good option to have automatic pipelines when code is check in etc… If all of those is not needed then grouping them as @jast1631 mentioned also makes sense Another way is to group them based on function …HR,Supply chain etc Cheers

This post made by @Anil_G received 2 likes!

I am studying for the Associate Certification. Can someone help me with this question?

@nevesisabela963 Option 2 would be correct Because as the library is published to local folder we first need to add that folder as a package feed for the library to be visible Hope this helps Cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

I am studying for the Associate Certification. Can someone help me with this question?

@nevesisabela963 Option 2 would be correct Because as the library is published to local folder we first need to add that folder as a package feed for the library to be visible Hope this helps Cheers

This solution provided by @Ones received 1 likes!

Adding a row to a data table problem

Hi @goropopovic the charter " scapes the string. So, if you want to have a " in the middle of the string try to write it with double ", like this: || vv { "=HYPERLINK(""C:\Users\g... Best Regards

This solution provided by @ashokkarale received 1 likes!

What is the file extension of a published package downloaded from UiPath Orchestrator? Pls, help

@nevesisabela963 .nupkg is the right answer. It’s Nuget package in which the project is gets packaged.

---

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

Top 3 Topics with Most Views

Replace one row name(thaar) with row name(Audi) in excel in uipath made by @Shravan_Pintu with 16 views.

Write Cell not able to pass correct value and save it made by @keevcodata with 12 views.

Remove double quotes (") from a string made by @Deepti_Hirave with 10 views.

Top 3 Topics with Most Replies

Replace one row name(thaar) with row name(Audi) in excel in uipath made by @Shravan_Pintu with 12 replies.

旧バージョンUiPathStudioライセンスについて made by @orengelike with 5 replies.

Get Queue item from different folder than job running folder made by @Koushalya_Khot with 3 replies.

Top 3 Users Who Posted The Most

@Anil_G made 10 posts!

@ashokkarale made 9 posts!

@Shravan_Pintu made 6 posts!

Top 3 Most Liked Posts

This post made by @ashokkarale received 2 likes!

Get Queue item from different folder than job running folder

@Koushalya_Khot, In your queue transaction handling activity like Get Transaction Item, Get Queue item pass the folder name as well. This will ensure that the activity will get the queue items from that particular folder.

This post made by @Anil_G received 1 likes!

Replace one row name(thaar) with row name(Audi) in excel in uipath

@Shravan_Pintu Use find/replace activity and you can replace all or the cirst occurance with required value Cheers

This post made by @Anil_G received 1 likes!

Replace one row name(thaar) with row name(Audi) in excel in uipath

@Shravan_Pintu you have given row count so youa re searching for 3 just give “Banana” and “Mango” in valut to find and replace with fields respectively cheers

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

Replace one row name(thaar) with row name(Audi) in excel in uipath

@Shravan_Pintu, Use this logic. LINQ to print the counts String.Join(", ", (From row In dtInput.AsEnumerable From col In dtInput.Columns.Cast(Of DataColumn) Group row(col.ColumnName).ToString.Trim.ToLower By fruit = row(col.ColumnName).ToString.Trim.ToLower Into Group Select $"{fruit} {Group.Count}").ToArray) [The image depicts an automation workflow in UiPath that uses an Excel file to find and replace the value "Banana" with "Mango,…

---

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

Top 3 Topics with Most Views

Unable to use UiPath Studio made by @Muhammad_Taeyyab with 16 views.

Connecting to Microsoft OneDrive SharePoint 365 Failed made by @sufimazlan with 11 views.

Selector issue in server made by @Pooja_Kanwar with 11 views.

Top 3 Topics with Most Replies

特定の条件からメールを取得する方法について made by @once10201029 with 13 replies.

Selector issue in server made by @Pooja_Kanwar with 8 replies.

Click the title to jump (js jump), unable to obtain the web page content made by @bccuiop with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 16 posts!

@Eric_Alvarado made 6 posts!

@Pooja_Kanwar made 5 posts!

Top 3 Most Liked Posts

This post made by @Muhammad_Taeyyab received 1 likes!

Unable to use UiPath Studio

Thanks @Anil_G , it worked. Cheers!

This post made by @Kruthi_BS received 1 likes!

How To automate the process of extracting barcode data from the TEC-IT barcode generator website

Thank you Soren, Yes please, that would be helpful if you explain with an example.

This post made by @Anil_G received 1 likes!

Connecting to Microsoft OneDrive SharePoint 365 Failed

@sufimazlan Are you trying from a company laptop or account? If so you might be needed to reach your it to give your username the required permissions or add you to right azure app or user group Cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Connecting to Microsoft OneDrive SharePoint 365 Failed

@sufimazlan Are you trying from a company laptop or account? If so you might be needed to reach your it to give your username the required permissions or add you to right azure app or user group 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 | 28 October 2024

Top 3 Topics with Most Views

For Each UI Element" frequently can lead to errors made by @22222222asas with 22 views.

Log MessageアクティビティとWrite Lineアクティビティの使い分け方法 made by @gorby with 18 views.

Concatenate column values where duplicates using linq made by @qwerty1 with 18 views.

Top 3 Topics with Most Replies

Geeting error at Build Stage CI/CD made by @chandresh_agarwal with 12 replies.

【Assistant】指定されたファイルが見つかりません。とエラーが出てしまいます made by @ta-fujiwara with 10 replies.

MS 365 Scope - for SharePoint File/Folder Upload made by @hacky with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 39 posts!

@ashokkarale made 26 posts!

@Yoichi made 18 posts!

Top 3 Most Liked Posts

This post made by @Akash_Javalekar1 received 2 likes!

Join AI Associate Developer Series 2024!

Thanks for the Update @shailendra236

This post made by @ljvandyk received 2 likes!

Join AI Associate Developer Series 2024!

I am wondering the same.

This post made by @Anonymous_iL received 2 likes!

Missing item in DataTable

Thanks @AkshaySandhu @Anil_G I solved it by removing Add header checkbox of Read Range activity.

Top 3 Most Liked Solutions

This solution provided by @Anonymous_iL received 2 likes!

Missing item in DataTable

Thanks @AkshaySandhu @Anil_G I solved it by removing Add header checkbox of Read Range activity.

This solution provided by @ashokkarale received 1 likes!

Concatenate column values where duplicates using linq

@qwerty1, Follow this approach: Full Solution: [This image is a flowchart of an automation process in UiPath that reads an Excel workbook, groups data, iterates over the groups to concatenate values and add rows to an output table, writes the output to a new worksheet, and logs a message once done. (Captioned by AI)] Variables: [The image depicts a variable management window showing three variables named dtInput, groupedData, and dtOutput, all scoped to DT_Test, with their types being Dat…

This solution provided by @Yoichi received 1 likes!

【Assistant】指定されたファイルが見つかりません。とエラーが出てしまいます

以下の事例ですと、プロジェクト自体が自動化プロセスではなく、テンプレートになっていたのですが、こちらの可能性ございませんでしょうか？ これに該当しない場合は、なんらかのファイルが読み込めていないので、それの特定が必要になります。ログファイル等になにか痕跡がないか確認可能でしょうか？

---

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

Top 3 Topics with Most Views

UiPath Orchestrator jobs by external Application using API made by @dutta.marina with 28 views.

Filter date without hour in Excel made by @sullivanne with 20 views.

Read and write date from excel to web using uipath made by @Mehdi_KAMALI_FR with 19 views.

Top 3 Topics with Most Replies

UiPath Orchestrator jobs by external Application using API made by @dutta.marina with 38 replies.

How to select items from the second column associated with column1? made by @Geeta with 12 replies.

UiPath Studio Community Editionインストール時のサインインエラーについて made by @Takaya_7750 with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 81 posts!

@dutta.marina made 21 posts!

@ashokkarale made 19 posts!

Top 3 Most Liked Posts

This post made by @evan.cohen received 3 likes!

Web Apps: Public Preview - Build Apps in Studio Web

@PeCour @ashokkarale The last thing we want is another migration, so from that perspective this bullet might be misleading. In an ideal world we make it possible to add inline workflows to your existing Apps and there’s no “migration” like there was for Legacy → VB. While this isn’t a commitment at the moment, we’d love to get your input on what you’d need from the product going forward in this regard. We’re looking at rolling out Web Apps to customers in the coming weeks, with general availabi…

This post made by @ashokkarale received 3 likes!

Add empty row and columns to Datatable

@hansen_Lobo, Here is possible approach. Full Solution: [This image depicts a sequence of activities in an automation workflow, starting with reading an Excel file, manipulating data, and writing the results to a specified worksheet. (Captioned by AI)] [The image shows a workflow in UiPath where a data column is added to a DataTable, an "Invoke Method" activity is used to set the ordinal position of the column, and the parameters and properties are configured for this method. (Captioned by…

This post made by @Antonio_Perez received 2 likes!

Which data type is best suited to store the values of month names? Multiple Choice

I was looking for an answer to this question in the questionnaire because I chose string and it gave me the wrong answer. This makes me think that the questionnaire is wrong, because I maintain that string is the correct one. There are 12 months in a year, and that is unalterable, it never changes, it is the perfect example of an array; you don’t have to add or remove months, because there will always be 12. Therefore, the only explanation I can find for why it is answered as wrong is that th…

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 3 likes!

Add empty row and columns to Datatable

@hansen_Lobo, Here is possible approach. Full Solution: [This image depicts a sequence of activities in an automation workflow, starting with reading an Excel file, manipulating data, and writing the results to a specified worksheet. (Captioned by AI)] [The image shows a workflow in UiPath where a data column is added to a DataTable, an "Invoke Method" activity is used to set the ordinal position of the column, and the parameters and properties are configured for this method. (Captioned by…

This solution provided by @Anil_G received 2 likes!

Error loop for DataExtract where the table is null

@Rodrigo_Habitat in the context of for loop please change the name of current item to soemthign else other than the table name [The image shows a data table field named "ItensNF_Table" highlighted in a form with a red marker. (Captioned by AI)] cheers

This solution provided by @Anil_G received 1 likes!

Google Sheet activities works in Studio but not in Unattended

@gpla Go to processes under automation tab…edit the process on second page of it it will ask to choose the connection 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 | 30 October 2024

Top 3 Topics with Most Views

When opening my brand new project I get several Nuget related errors made by @ShadowDom with 25 views.

Identify a number in different formats made by @Michaeljep with 21 views.

Extract date of format 'February 10, 2024' usingn regex made by @Harsha_Vemula with 17 views.

Top 3 Topics with Most Replies

When opening my brand new project I get several Nuget related errors made by @ShadowDom with 16 replies.

Copy Range not finishing made by @A_Learner with 15 replies.

How to compare the content in a datatable with today's date made by @22222222asas with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 29 posts!

@A_Learner made 17 posts!

@ashokkarale made 17 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

How to compare the content in a datatable with today's date

@22222222asas terminate workflwo will stop process or if you want to end some loop then use break cheers

This post made by @Anil_G received 1 likes!

How to compare the content in a datatable with today's date

@22222222asas hope they are in same format dt.AsEnuemrable.Any(function(x) x("DaetColumn").ToString.Equals(TodayVariable)) this give true if atleast one match is found else false cheers

This post made by @Eric_Alvarado received 1 likes!

How to compare the content in a datatable with today's date

@22222222asas It depends on the process, but you can consider throwing a Business Rule Exception There’s an activity call ‘Terminate Workflow’ but I’ll recommend you test this many times

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

How to compare the content in a datatable with today's date

@22222222asas hope they are in same format dt.AsEnuemrable.Any(function(x) x("DaetColumn").ToString.Equals(TodayVariable)) this give true if atleast one match is found else false cheers

This solution provided by @Woon_El received 1 likes!

DataTable filling up with random data after using Remove Data Row?

@sudster @Anil_G sorry for the question, turns out I forgot to clear the excel sheet, so it was actually my previous data in there.

---

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 | 31 October 2024

Top 3 Topics with Most Views

UIPath questions! made by @naveen.s with 21 views.

Issues with 'Click Image' Activity on Edge for 'Save As' Button made by @Jose_Corbalan with 17 views.

Create an excel pivot table from multiple sheet made by @Ahmad_Rais with 17 views.

Top 3 Topics with Most Replies

How to get text starting from a word to end of the line made by @Krithi1 with 14 replies.

Windowsレガシ移行に伴うSharePoint上フォルダのコピー失敗 made by @dev.K with 11 replies.

How to pass specific Queue Item to a workflow made by @Terry_Marr with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 20 posts!

@Krithi1 made 13 posts!

@Yoichi made 11 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Is there a reliable ocr activity to scan pdfs?

@Anthony2 If you have the license you can try with different ocrs …epending on resolution …type of file like scanned,digital etc different ocrs would give different results…generally teseract and UiPath ocr gives better results Cheers

This post made by @Yoichi received 2 likes!

Windowsレガシ移行に伴うSharePoint上フォルダのコピー失敗

あとは、UNC表現の問題か否かの切り分けのため以下の式の結果を確認した方が良いかと思います。 System.IO.Path.GetInvalidPathChars().Any(Function(c) filepath.Contains(c)) [image] もしTrueが返るなら、何か不正な文字が含まれていると思います。

This post made by @Yoichi received 2 likes!

Windowsレガシ移行に伴うSharePoint上フォルダのコピー失敗

どうも以下で報告されている事象と一致してそうです。（対象もSharepointのようなので） 残念ながら、解決には至っていなさそうですが．．．。

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

FindMeetingTimesで、Outlookのカレンダーに自動で作成をしたいです

すみません、式が不足していました。これで開始日時のリストが出力されると思います。 String.Join(vbcrlf,slots.Select(Function(x) x.MeetingTimeSlot.Start.DateTime)) いずれにしても中身は入ってそうですので、繰り返し（コレクションの各要素）アクティビティでイテレートして、中身を確認していってもらえればと思います。

This solution provided by @Anil_G received 2 likes!

Reading all "date"´s

@VanjaV Its a json array Use deserialize json array Then loop theough array and inside loop currentitem("Date").ToString will give the dates Else rry deserialize json and select target argument as datatable you would get a column with date Cheers

This solution provided by @naveen.s received 1 likes!

Issues with 'Click Image' Activity on Edge for 'Save As' Button

@Jose_Corbalan , You can try below: When using the “Click Image” activity in UiPath to interact with elements like the “Save As” button in Microsoft Edge, there can be issues due to variations in image recognition, screen resolution, DPI settings, or UI changes in the browser. Here are several alternative methods and workarounds to improve the reliability of your workflow when saving downloaded files in Edge: 1. Use Keyboard Shortcuts Instead of relying on the “Click Image” activity, consid…

[Previous Month] Top 3 Users with the most likes on their solutions

@Anil_G received 41 likes for their solutions!

@ashokkarale received 30 likes for their solutions!

@Yoichi received 24 likes for their solutions!

---

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 November 2024

Top 3 Topics with Most Views

Kill Process excel question made by @A_Learner with 18 views.

Can't use relative path in 'Append Range Workbook' activity made by @Nafissa_Al_Abida with 15 views.

Orientación Hack-a-bot UES made by @dokumentor with 12 views.

Top 3 Topics with Most Replies

Different elements made by @rodrigosre with 8 replies.

Uipath Edge Automation download made by @Ritaman_Baral with 7 replies.

Error when executing REF made by @amanda.gondim with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 11 posts!

@Yoichi made 9 posts!

@Ehab_Sawars made 8 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Can't use relative path in 'Append Range Workbook' activity

Hi It seems double quote matter. For now, can you try to replace (re-type) all the double quote wilth " (0x22 character)? (Please copy and pate this character " if necessary) FYI Regards,

This post made by @jessbrian received 1 likes!

Join AI Associate Developer Series 2024!

@cristina.vidu it is jessbrian.maglalang@gmail.com

This post made by @Anil_G received 1 likes!

DU - Document Validation Missing Value Issue

@PWilliams but once you save it would show up in output variable cheers

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 | 02 November 2024

Top 3 Topics with Most Views

Adding a 2 columns between columns made by @Priyesh_Shetty with 16 views.

Unable to install studio which is connected to orchestrator by default using command line made by @sharazkm32 with 10 views.

How To split the string to get last name made by @Bot_Learner1 with 8 views.

Top 3 Topics with Most Replies

How To split the string to get last name made by @Bot_Learner1 with 9 replies.

Adding a 2 columns between columns made by @Priyesh_Shetty with 6 replies.

Read PDF in background? made by @Terry_Marr with 3 replies.

Top 3 Users Who Posted The Most

@Anil_G made 7 posts!

@Bot_Learner1 made 6 posts!

@lrtetala made 4 posts!

Top 3 Most Liked Posts

This post made by @lrtetala received 1 likes!

How To split the string to get last name

@Bot_Learner1 It work’s for sure. Can you please show the screenshot of your workflow [The process flow assigns a full name to a variable, extracts the last name by splitting the string, and displays the last name in a message box. (Captioned by AI)] Regards,

This post made by @lrtetala received 1 likes!

How To split the string to get last name

@Bot_Learner1 Try below name.Trim.Split(" "c).Last() [The image depicts a sequence in a robotic process automation workflow where a name string is split and trimmed to extract and display the last name "HEROLD" in a message box. (Captioned by AI)] Regards,

This post made by @Erimateia received 1 likes!

How To split the string to get last name

Hi @Bot_Learner1 To extract the last name from a string in UiPath, follow these steps using native UiPath activities like Assign and Log Message or Write Line to check the results. Steps Use the Assign activity to define a variable named lastName. In the expression field for lastName, use the Split function to split the string by spaces and select the last element of the resulting array. For example: lastName = Split(fullName, " ")(Split(fullName, " ").Length - 1) Here, fullName is the var…

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

How To split the string to get last name

@Bot_Learner1 Try below name.Trim.Split(" "c).Last() [The image depicts a sequence in a robotic process automation workflow where a name string is split and trimmed to extract and display the last name "HEROLD" in a message box. (Captioned by AI)] Regards,

---

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

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

[system]

Daily Forum Report | 03 November 2024

Top 3 Topics with Most Views

How to use Queue Upload item made by @bbbb with 15 views.

Http Client Parameters - Accept header & User-Agent made by @Vladyslav_Tkachov with 14 views.

Final Report- Even exceptions in middle of execution made by @Ajith3 with 14 views.

Top 3 Topics with Most Replies

Error Dropdown made by @tobias_va with 6 replies.

Http Client Parameters - Accept header & User-Agent made by @Vladyslav_Tkachov with 4 replies.

Final Report- Even exceptions in middle of execution made by @Ajith3 with 4 replies.

Top 3 Users Who Posted The Most

@mohammed.hugail made 7 posts!

@Erimateia made 4 posts!

@tobias_va made 3 posts!

Top 3 Most Liked Posts

This post made by @Vikas_M received 2 likes!

Adding a 2 columns between columns

Hey @Priyesh_Shetty , You can add new columns in your Excel sheet using various approaches. Here are five methods you might consider: Approach 1: Default View Add the 2 columns - “Today” and “Pending qty” using “Add Data Column” Activity Set your Assign block as following image dt_input.DefaultView.ToTable(False,"PO NO","Today","INVOICE QTY","CAPEX/OPEX","Pending qty") [image] Approach 2: Set Ordinal - Invoke Method Use the “Invoke Method” activity and configure it . Refer below images…

This post made by @Dennis_Orina1 received 1 likes!

Error Dropdown

First use a click to expand the drop down before using the select item activity

This post made by @Erimateia received 1 likes!

Erro login studio

Hi @robot.gestus Siga os passos abaixo para tentar solucionar o problema. Configurar o Orchestrator no UiPath Studio: Abra o UiPath Studio e vá até o menu de configurações. Em “Orchestrator Settings,” verifique se o endereço do ServiceURL está correto. Em seguida, clique em “Connect” ou “Conectar” para estabelecer a conexão. Checar a URL do Orchestrator: No campo ServiceURL, confirme se o link é o correto (exemplo: https://cloud.uipath.com/nome_da_conta/nome_do_tenant). O endereço deve…

Top 3 Most Liked Solutions

This solution provided by @Vikas_M received 2 likes!

Adding a 2 columns between columns

Hey @Priyesh_Shetty , You can add new columns in your Excel sheet using various approaches. Here are five methods you might consider: Approach 1: Default View Add the 2 columns - “Today” and “Pending qty” using “Add Data Column” Activity Set your Assign block as following image dt_input.DefaultView.ToTable(False,"PO NO","Today","INVOICE QTY","CAPEX/OPEX","Pending qty") [image] Approach 2: Set Ordinal - Invoke Method Use the “Invoke Method” activity and configure it . Refer below images…

---

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 November 2024

Top 3 Topics with Most Views

Validation Control in Apps: Private Preview - Build holistic validation experiences made by @udit.chandna with 44 views.

Why does Read Range of Modern Excel Activity not throw exception if target sheet not exist? made by @irahmat with 30 views.

Compare 2 excel data made by @Jeeru_venkat_Rao with 23 views.

Top 3 Topics with Most Replies

How to compare the data table with "Date" column and pick first 3 unique date value rows made by @Manaswini_UI with 11 replies.

To find the percentage of repeated values in a list of strings? made by @sfdc_sfdc with 10 replies.

Doubt in preparation exam made by @Antonio_Perez with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 31 posts!

@ashokkarale made 14 posts!

@Pooja_Kanwar made 10 posts!

Top 3 Most Liked Posts

This post made by @udit.chandna received 4 likes!

Validation Control in Apps: Private Preview - Build holistic validation experiences

Big News! UiPath Validation Control in Apps is in Private Preview! Dear all, Continuing on our Forward promise, we’re beyond excited to unveil the registration of the much-anticipated private preview of UiPath Validation Control in Apps! This is the first time we have brought the most loved Validation Station to UiPath Apps, allowing customers to build customized validation experiences leveraging Apps and Action Center. What’s New? [image] -Validation Station as an …

This post made by @Matt67 received 2 likes!

Doubt in preparation exam

Hello, was reading this thread and I agree with this. It’s honestly a hard question which looks quite easy on appearance, very easy to missunderstand, because, AddHeaders needs to be checked because there are headers in Excel file that we want to retrieve as well. I don’t really understand what UiPath is testing with this question

This post made by @hansen_Lobo received 1 likes!

HTTP request Transfer file HTTP header getting attached

Hello All, I am trying to move a text file from local machine to S3 bucket. Attaching the flow and values assigned. [image] All other properties are default [image] So here’s the problem, The HTTP header gets attached to the body. Content-Disposition: form-data; name=“file”; filename=“bintxt.txt” Content-Type: application/octet-stream What can i change in the properties panel to solve the issue. I don’t want the headers in the file. Thank you

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

To find the percentage of repeated values in a list of strings?

Hi @sfdc_sfdc Can you try the below listOfValues = New List(Of String) From{"A", "B", "A", "C", "A"} percentage = ((listOfValues.Where(Function(x) x = listOfValues.GroupBy(Function(y) y).OrderByDescending(Function(g) g.Count()).First().Key).Count() / listOfValues.Count()) * 100).ToString [The image depicts a workflow using assignment and message box activities to calculate and display a percentage in a Windows application. (Captioned by AI)] Regards,

This solution provided by @ppr received 1 likes!

Need Regex Help to Get Words Before DOT Symbol

When input is about filenames and the filename without extension is needed also have a look here: [grafik]

---

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

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

[system]

Daily Forum Report | 05 November 2024

Top 3 Topics with Most Views

How can we compare made by @mint with 25 views.

Filter Blank rows in Excel using Linq made by @Manii_K with 24 views.

The specified folder doesn't exist - worked fine yesterday made by @Short with 21 views.

Top 3 Topics with Most Replies

Invoke method to remove a key-value pair in json gives error made by @Nick101 with 12 replies.

Filter Blank rows in Excel using Linq made by @Manii_K with 10 replies.

Creating Dynamic JSON on basis of excel data made by @Pogboom with 9 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 21 posts!

@Nick101 made 7 posts!

@Yoichi made 7 posts!

Top 3 Most Liked Posts

This post made by @ashokkarale received 3 likes!

3 Million Members and Counting: Advancing the Future of Automation Together

Cheers to the vibrant, unstoppable and unique community! I believe community makes you humble and same I feel with the UiPath community. Here I mate many humble and expert members who are always there to help. Everyday is learning opportunity here on UiPath forum. Kudos everyone

This post made by @jjes received 2 likes!

Profile Execution video on YouTube

Hi everyone, just posted a video about an overlooked feature in Studio - Profile Exection. Watch it here: [Boost Your UiPath automation efficiency using Profile Execution!] Cheers, Jeppe

This post made by @ashokkarale received 2 likes!

Studio stuck in debug layout

Tried restarting the machine?

Top 3 Most Liked Solutions

This solution provided by @Manisha_Ravindra received 1 likes!

How to get specific value from given string/input

Hi @Nisha_K21 You can use below approach strYourInput = “My email ID is abc@gmail.com” strOutput = System.Text.RegularExpressions.Regex.Match(strYourInput, “[a-zA-Z0-9._%±]+@[a-zA-Z0-9.-]+.[a-zA-Z]{2,}”).Value This will give you the output as abc@gmail.com

This solution provided by @Gowtham_K115 received 1 likes!

Import the formula in the cell into the following rows

Hi @ozgur.yukcan Welcome to the community !!! You only need to enter the formula in the first row, then use Excel’s Autofill range activity to automatically extend the formula down to the last row. Regards, Gowtham K

This solution provided by @Manisha_Ravindra received 1 likes!

How to publish test cases in uipath studio

Hi @Akshaya89 First Create a test case and your desired test case Link to your Test Manager Set as publishable Click on Publish Test Cases [Screenshot 2024-11-05 200451] 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 | 06 November 2024

Top 3 Topics with Most Views

Need to create a trigger in Uipath made by @vishal_nachankar with 29 views.

Compare 2 data and find the differences made by @Ryan_Lee with 26 views.

Copy Values from One column of DT1 to another column of Dt2 made by @Manii_K with 21 views.

Top 3 Topics with Most Replies

Need to create a trigger in Uipath made by @vishal_nachankar with 16 replies.

Copy Values from One column of DT1 to another column of Dt2 made by @Manii_K with 14 replies.

I have to update in excel after completion of my transaction item in required row made by @shaik.muktharvalli1 with 13 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 21 posts!

@Akash_Javalekar1 made 14 posts!

@Yoichi made 14 posts!

Top 3 Most Liked Posts

This post made by @ton_roelandse received 1 likes!

Cannot send /track/transaction/start request to Automation Tracker server. Exception: Unauthorized:

I have not seen it appear again.

This post made by @ashokkarale received 1 likes!

Orchestrator output argument has value, but when called on API, it returns null. How to solve

@Royyy, You can refer this for more understanding on this.

This post made by @Sudeen_Raj_Shetty received 1 likes!

Copy Values from One column of DT1 to another column of Dt2

Hi @Manii_K You can use this Linq DT2 = (From row in DT1 Let x = New Object(){row(“Item”),row(“ID”),row(“Department”)} Select DT2.Clone.Rows.Add(x)).CopyToDataTable

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Orchestrator output argument has value, but when called on API, it returns null. How to solve

have a look here for further explanation

This solution provided by @Manisha_Ravindra received 1 likes!

CRON Expression for Time based Trigger

Hi @Akshaya89 0 0 9-18/3 ? * MON-FRI * Here’s a breakdown of the expression: 0 0: At the start of the hour. 9-18/3: Every 3 hours between 9 AM and 6 PM. ?: No specific day of the month. *: Every month. MON-FRI: Only on weekdays (Monday to Friday). This will ensure your bot runs at 9 AM, 12 PM, 3 PM, and 6 PM from Monday to Friday.

This solution provided by @Manisha_Ravindra received 1 likes!

LINQ query to sum Price values stored in datatable

Hi @Nisha_K21 , Assuming column Price is of the type double totalPrice = yourDataTable.AsEnumerable().Sum(Function(row) row.Field(Of Double)("Price")) Explanation yourDataTable: Replace this with the name of your DataTable variable. row.Field(Of Double)("Price"): Accesses each value in the "Price" column as a Double. totalPrice: This should be a variable of type Double to store the sum.

---

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.