Forum Engagement Daily Reports

[system]

Daily Forum Report | 19 August 2024

Top 3 Topics with Most Views

２つのDataTableの重複していない行をDataTableとして取得したい made by @FSP with 21 views.

RE Framework System Exception - Multiple Application made by @Karthi_M with 21 views.

How store the email body into excel using email received trigger? made by @Naveen_Kanike with 18 views.

Top 3 Topics with Most Replies

Encoding/decoding an encrypted file made by @KING1 with 10 replies.

How store the email body into excel using email received trigger? made by @Naveen_Kanike with 10 replies.

UiPath with Amazon SES made by @Nisha_K21 with 7 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 24 posts!

@Yoichi made 10 posts!

@sven.wullum1 made 7 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

How to do addition of Double value in particular column

Assign Activity: mySumAsFormatedString = dtData.AsEnumerable.Sum(Function (x) CDbl(x("Amount").toString.Trim)).toString("F2")

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

UiPath with Amazon SES

Hi! Take a look at this article: Activities - Send email (uipath.com) It’s not mentioned in the article, but I believe you also need to install the “Integration Service Activities” package from UiPath as well. [image]

This post made by @Nisha_K21 received 1 likes!

UiPath with Amazon SES

Hi @sven.wullum1 , I can see it now. Thanks!

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

How to do addition of Double value in particular column

Assign Activity: mySumAsFormatedString = dtData.AsEnumerable.Sum(Function (x) CDbl(x("Amount").toString.Trim)).toString("F2")

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

UiPath with Amazon SES

Hi! Take a look at this article: Activities - Send email (uipath.com) It’s not mentioned in the article, but I believe you also need to install the “Integration Service Activities” package from UiPath as well. [image]

This solution provided by @Yoichi received 1 likes!

２つのDataTableの重複していない行をDataTableとして取得したい

こんにちは 最終的にdt1に加えるならマージして重複を削除しても同じかと思いますが．．．． dt2の中でdt1にない行を抽出するには以下で可能です。 arrDr = dt2.AsEnumerable.Except(dt1.AsEnumerable,DataRowComparer.Default).ToArray() [image] Sample Sample20240819-2.zip (3.4 KB)

---

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

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

[system]

Daily Forum Report | 20 August 2024

Top 3 Topics with Most Views

How to copy data from mutiple txt files into a excel file? made by @yangyq10 with 27 views.

🎉 ppr 3000th Solution Flag Celebration made by @Yoichi with 26 views.

Argument value showing Null made by @dutta.marina with 22 views.

Top 3 Topics with Most Replies

How to copy data from mutiple txt files into a excel file? made by @yangyq10 with 16 replies.

My email received trigger activity throwing error faulted in orchestrator? made by @Naveen_Kanike with 16 replies.

Googleスプレッドシートのシートを取得について made by @ml.system with 16 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 27 posts!

@lrtetala made 23 posts!

@singh_sumit made 17 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 8 likes!

ppr 3000th Solution Flag Celebration

@ppr Congratulations on your 3000th Solution Flag! Thank you for all the great things you’ve contributed to the Community!!! Let’s celebrate this milestone together.

This post made by @ppr received 7 likes!

ppr 3000th Solution Flag Celebration

@lrtetala, @ashokkarale, @mkankatala, @pravallikapaluri, @Parvathy, @Venkat4, @singh_sumit Thank you for the congratulations. Let the robots dance and teach them these moves that are smart and distinctive.

This post made by @ppr received 2 likes!

ppr 3000th Solution Flag Celebration

@jeevith I am already looking forward to our joint collaboration when we delve deeper into special topics @Steven_McKeering Many thanks for the friendship that has connected us for several years @Anil_G Thank you for the congratulations. Keep up the good work

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Creating a .jpl file with various attributes

As we have not unique keys [grafik] we cannot model it as a dictionary but e.g. with datatable we can premodel, fill and generate the jpl file content e.g. [The image displays a debugging session showing the contents of a data table "dtData" and its formatted output using a String.Join and LINQ query in the Immediate window. (Captioned by AI)] (keep in mind that the immediate panel escapes the inner ") Screenshot file: [grafik] String.Join(Environment.NewLine, dtData.AsEnumerable.Select…

This solution provided by @ignasi.peiris received 1 likes!

How to copy data from mutiple txt files into a excel file?

Find below the 2nd approach, using the excel activities (Did redesign it a bit to avoid opening excel 3 times): Test Sample_IP.zip (159.4 KB) Manage sheet: [The image is a screenshot of an Excel spreadsheet displaying multiple rows of purchase order information including issue dates, order numbers, supplier details, item descriptions, quantities, unit prices, and delivery dates. (Captioned by AI)] Edit: The solution does not contemplate a rerun, therefore make sure to delete the rows in the…

This solution provided by @lrtetala received 1 likes!

Multiple Assign Issue

Hi @yangyq10 Can you try this [The image displays a sequence in a process automation tool where data is being copied from one Excel file and transposed into a temporary sheet, with an added step to assign the value "YBOR" to each row's "Order" field. (Captioned by AI)] Output: [This image shows a spreadsheet with multiple columns for order-related data, including fields for order type, sales office, customer PO header, delivery date, and customer number, among others. (Captioned by AI)] W…

---

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

Top 3 Topics with Most Views

How to make the selector' selecting more accurate? made by @Dingkun_Yang with 27 views.

How to extract the mail body unstuctured mail body?And extracted and stored in varaible but i required only specfic data how to get required data from mail body? made by @Naveen_Kanike with 27 views.

Copy row item and paste into 3 different sheets made by @Jeeru_venkat_Rao with 21 views.

Top 3 Topics with Most Replies

How to make the selector' selecting more accurate? made by @Dingkun_Yang with 30 replies.

How to extract the mail body unstuctured mail body?And extracted and stored in varaible but i required only specfic data how to get required data from mail body? made by @Naveen_Kanike with 27 replies.

Export the data next next page? made by @domsmgtmeet22 with 15 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 35 posts!

@lrtetala made 30 posts!

@mkankatala made 23 posts!

Top 3 Most Liked Posts

This post made by @ashokkarale received 4 likes!

Monthly Forum Rewards - July 2024

Congratulations everyone Thanks, Ashok

This post made by @mkankatala received 3 likes!

Monthly Forum Rewards - July 2024

Kudos to Everyone…

This post made by @pravallikapaluri received 3 likes!

Monthly Forum Rewards - July 2024

Congratulations to everyone

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Transaction ID

Hi @Nisha_K21 If you want Transaction ID use TransactionItem.Itemkey.ToString Regards,

This solution provided by @SorenB received 1 likes!

Comparing data between two Excel file

Hello Please take a look at the attached example below. [image] Compare data.xaml (16.6 KB) Best regards, Soren

This solution provided by @Kanak_Lata_Singh received 1 likes!

How to make the selector' selecting more accurate?

Hi @Dingkun_Yang Try to use Modern activities and make sure to add an anchor to the element. For reference please look into this Thanks

---

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

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

[system]

Daily Forum Report | 22 August 2024

Top 3 Topics with Most Views

Filter data table not working for two things? made by @Kalle77 with 25 views.

過去に作成したプログラムが起動できません。 made by @miwa_yamamoto with 22 views.

UiPath Assistantのみを使う場合のライセンスについて made by @gorby with 19 views.

Top 3 Topics with Most Replies

Filter data table not working for two things? made by @Kalle77 with 38 replies.

過去に作成したプログラムが起動できません。 made by @miwa_yamamoto with 15 replies.

GenAI activities model name made by @Lynn_Song with 13 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 33 posts!

@Yoichi made 22 posts!

@Raj_esh made 20 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 3 likes!

ppr 3000th Solution Flag Celebration

Congratulations @ppr! Your dedication, knowledge, and wealth of experience have been invaluable to all of us in the forum. The insightful information you share has undoubtedly helped me, and many others, achieve our goals. Here’s to even more solutions and achievements that you’ll continue to bring to the community. Cheers to your contributions!

This post made by @Krishna_Raj received 2 likes!

Monthly Forum Rewards - July 2024

congratulations to everyone

This post made by @ppr received 2 likes!

ppr 3000th Solution Flag Celebration

@supermanPunch Many thanks for the kind words and also for your help with my various tutorials. It’s about time for a virtual coffee chat again

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

GenAI activities model name

@Lynn_Song, Use Integration Service Activities package version 1.5.0 which have the all available models to be used. In latest version they removed that dropdown but I don’t know why. If you want to use latest version, take all model names from 1.5.0 and then upgrade to latest and pass the extracted model names. Cheers! Thanks, Ashok

This solution provided by @Yoichi received 1 likes!

An error occurs on combining two filter conditions for get outlook message

HI, Unfortunately we cannot use JET style query and DASL style query at same time. So How about using only DASL query, for example? "@SQL= urn:schemas:httpmail:subject LIKE '%target word%' AND urn:schemas:httpmail:datereceived >= '2024/8/22 0:00'" Regards,

This solution provided by @ashokkarale received 1 likes!

Extracting and pasting the Communication Status from a Website to Excel

This means the UI element is overlapped by some popup or another Ui Element. Check if it is the case. Regarding get text, you will have to make the selector dynamic to adopt other codes from the excel. So replace the T0000xxx from selector with a variable which will contain these codes. Thanks, Ashok

---

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

Top 3 Topics with Most Views

🆕 ⭐ Reviews Campaign: Rate UiPath on G2 and get rewarded! made by @Dana_Mustatea with 30 views.

Unable to Install Packages: "No compatible version with Windows projects" Error made by @ImPratham45 with 21 views.

Lost permission to the Manage Access panel made by @LeonJia with 20 views.

Top 3 Topics with Most Replies

Kill Process and Stop Process in Orchestrator made by @shahidh.aqeel.shahul with 13 replies.

How to write datatable data into my one drive excel file which is having same made by @Naveen_Kanike with 10 replies.

How to get sub-string from a string made by @Krithi1 with 10 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 21 posts!

@lrtetala made 12 posts!

@ranjith_udayakumar made 11 posts!

Top 3 Most Liked Posts

This post made by @arivu96 received 2 likes!

Monthly Forum Rewards - July 2024

Congratulations to all the winners Regards, Arivu

This post made by @Dana_Mustatea received 1 likes!

Reviews Campaign: Rate UiPath on G2 and get rewarded!

Until August 27th, the first 100 reviewers of UiPath on G2, will receive a 25$ Amazon Gift Card. If your review will be approved within the first 100 ones, you will receive the gift card directly from the G2 team as a Thank You for contributing with a detailed, balanced, complete review. Please be sure to use your LinkedIn or your business email for validation. This is required by the G2 to help verify your experience with our products. Y…

This post made by @ppr received 1 likes!

Remove rows with no data from datatable

We can do: Assign Activity dtCleansed = (From d in YourDataTableVar.AsEnumerable Let chk = d.ItemArray.Skip(1).All(Function (x) isNothing(x) OrElse String.IsNullorEmpty(x.toString.Trim)) Where not chk Select r = d).CopyToDataTable Handling emtpy results we do:

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Remove rows with no data from datatable

We can do: Assign Activity dtCleansed = (From d in YourDataTableVar.AsEnumerable Let chk = d.ItemArray.Skip(1).All(Function (x) isNothing(x) OrElse String.IsNullorEmpty(x.toString.Trim)) Where not chk Select r = d).CopyToDataTable Handling emtpy results we do:

This solution provided by @lrtetala received 1 likes!

Pdf is read line by line from top to bottom

Hi @Murat Set PreserveFormatting to True [The image shows a UiPath activity sequence for reading text from a PDF file and writing it to a text file, with the "PreserveFormatting" option set to true in the "Read PDF Text" activity. (Captioned by AI)] Regards,

This solution provided by @Manisha_Ravindra received 1 likes!

How to validate username and password field when creating login page

Hi @Nisha_K21 In order to validate fields first click on the username field and go to create rule there you can use set value option Item to set : Username variable value : (pagename).username.value Do the same thing for password as well. Finally in the login button create a rule to check username and password contains null or not If : Username is vbNullString or Password is vbNullString Then: Show Error Message Else : Show Success message Hope this will solve your question Regards, M…

---

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

Top 3 Topics with Most Views

How to convert month to text? made by @domsmgtmeet22 with 16 views.

Already Login to ACME - Automation Skips Login Page After First Successful Run made by @mohammed.fuseini with 13 views.

I am getting error in community edition made by @devasaiprasad_K with 13 views.

Top 3 Topics with Most Replies

Already Login to ACME - Automation Skips Login Page After First Successful Run made by @mohammed.fuseini with 9 replies.

How to convert month to text? made by @domsmgtmeet22 with 9 replies.

How to add specific column in different excel sheet made by @Riya1 with 6 replies.

Top 3 Users Who Posted The Most

@Anil_G made 13 posts!

@ashokkarale made 6 posts!

@mkankatala made 6 posts!

Top 3 Most Liked Posts

This post made by @vrdabberu received 1 likes!

Already Login to ACME - Automation Skips Login Page After First Successful Run

Hi @mohammed.fuseini Use Check App State Activity and indicate thhe Home Page screen of ACME website. In Target Appears do nothing and in Target Does not Appears keep the activities like type into to type the Username, Password and click the Login button. Regards

This post made by @ashokkarale received 1 likes!

Already Login to ACME - Automation Skips Login Page After First Successful Run

@mohammed.fuseini, Refer this Sample Project. CalculateClientSecurityHash.zip (3.1 MB) In this project refer this workflow. [The image displays a file directory with a list of .xaml files under the "System1" folder, with "System1_Login.xaml" circled in red. (Captioned by AI)] Logic is available in it. Thanks, Ashok

This post made by @singh_sumit received 1 likes!

Already Login to ACME - Automation Skips Login Page After First Successful Run

Hie @mohammed.fuseini if you are working with modern activity use check app state activity and if you are still working with classic activity use element exist activity to check if the page is logged in or loged out … this help you to handle this error problem cheers Happy Automation

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

Already Login to ACME - Automation Skips Login Page After First Successful Run

@mohammed.fuseini, Refer this Sample Project. CalculateClientSecurityHash.zip (3.1 MB) In this project refer this workflow. [The image displays a file directory with a list of .xaml files under the "System1" folder, with "System1_Login.xaml" circled in red. (Captioned by AI)] Logic is available in it. Thanks, Ashok

This solution provided by @ashokkarale received 1 likes!

Are permissions permissive or restrictive?

@Terry_Marr, You are right. For example if any user got admin role along with any other, admin permissions will take the priority. Thanks, Ashok

---

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

Top 3 Topics with Most Views

i_dt_Datatable3からDataRowの配列arr_DataRowを作成したい。 made by @gorby with 12 views.

Googleスプレッドシートを使用について made by @ml.system with 11 views.

Move File Error when using Load Image made by @ADITYA_T with 10 views.

Top 3 Topics with Most Replies

Move File Error when using Load Image made by @ADITYA_T with 6 replies.

SAP UI element is not indicating made by @Pavan_kumar15 with 5 replies.

i_dt_Datatable3からDataRowの配列arr_DataRowを作成したい。 made by @gorby with 5 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 5 posts!

@Anil_G made 5 posts!

@gorby made 4 posts!

Top 3 Most Liked Posts

This post made by @Pavan_kumar15 received 2 likes!

SAP UI element is not indicating

Hi @mkankatala/@ashokkarale, I used Click activity to indicate UI element. Issue has been solved now after UiPath.UIAutomation.activities package updated to latest version -2024.10.3. Now i am able to indicate each and every element in SAP.

This post made by @naveen.s received 1 likes!

Already Login to ACME - Automation Skips Login Page After First Successful Run

@mohammed.fuseini If you are using the Classic activity then use element exist like → if the acme home page exist skip the login if not then login to the acme again. If you are using the modern activity then use check app state(which is similar to the element exists in classic activity) → if the acme home page exist skip the login if not then login to the acme again.

This post made by @lrtetala received 1 likes!

How to send out email base on excel column data

Hi @yangyq10 Use below query to find any Mismatch is there hasMismatch = dt.AsEnumerable().Any(Function(row) row("Result1").ToString.Equals("Mismatch") OrElse row("Result2").ToString.Equals("Mismatch") OrElse row("Result3").ToString.Equals("Mismatch") OrElse row("Result4").ToString.Equals("Mismatch") OrElse …

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

How to send out email base on excel column data

Hi @yangyq10 Use below query to find any Mismatch is there hasMismatch = dt.AsEnumerable().Any(Function(row) row("Result1").ToString.Equals("Mismatch") OrElse row("Result2").ToString.Equals("Mismatch") OrElse row("Result3").ToString.Equals("Mismatch") OrElse row("Result4").ToString.Equals("Mismatch") OrElse …

---

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

Top 3 Topics with Most Views

Why did this exception occur? The item is getting stuck in the queue made by @Praveen_Soni with 33 views.

How to filter emails by subject made by @Mohammad_Allan with 19 views.

「VBAを呼び出し」の設定が解りません made by @Shigehiko_Tane with 17 views.

Top 3 Topics with Most Replies

I have a existing excel file and i want to write my build data table data into my existing excel file but which has some data present into my existing excel?how? made by @Naveen_Kanike with 14 replies.

How to edit the table properties in Create HTML Content Activity made by @shahidh.aqeel.shahul with 12 replies.

Add DataRowアクティビティの列配列の記述の最後の.ToStringについて made by @gorby with 12 replies.

Top 3 Users Who Posted The Most

@Yoichi made 24 posts!

@ashokkarale made 15 posts!

@lrtetala made 14 posts!

Top 3 Most Liked Posts

This post made by @Monica_Secelean received 2 likes!

-How can i create validation task in orchestrator in Action Centre For Validation?

Document Understanding has 2 activity packs: IntelligentOCR with Load Taxonomy, Digitize, Data Extraction Scope, etc. DocumentUnderstanding.Activities with the Classify Document, Extract Document Data and Create Validation Task the 2 packs cannot be combined - for the Create Validation Task activity, you need the input of an Extract Document Data activity - in this sense, either replace your extractor with Extract Document Data and use it together with the Create Validation Task activity or r…

This post made by @Shalom_Oguntolu received 2 likes!

Kickstart for Automation Student Developers

Hello @cristina.vidu , I have completed the Teaining and also completed the form all before Aug 20th but I am yet to get the verification test email/link [The image shows an email notification from UiPath congratulating the recipient for earning the UiPath Academy Automation Developer Associate Training credential. (Captioned by AI)]

This post made by @ashokkarale received 1 likes!

Converting decimal present in excel to digits and then doing sum of a column values

@anjasing Use Format Cells activity to format the column as Decimal and then apply your formula for sum. Thanks, Ashok

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

Converting decimal present in excel to digits and then doing sum of a column values

@anjasing Use Format Cells activity to format the column as Decimal and then apply your formula for sum. Thanks, Ashok

This solution provided by @lrtetala received 1 likes!

How to auto fill the values upto specific range

@anjani_priya Use like below [The image shows an Excel Fill Range action configured to write the formula "=A2+B2" in the range C2:C25 on Sheet2. (Captioned by AI)] Regards,

This solution provided by @Yoichi received 1 likes!

更换计算机升级win11后get不到email floder

Hi, For now, can you try Repair tool for Microsoft Office in UiPath Studio? [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 | 27 August 2024

Top 3 Topics with Most Views

Questions about OpenBrowser made by @ChenSiXing with 26 views.

Right enter in terminal session not work made by @porush669 with 22 views.

Issue with Uipath Regex made by @besakkiappan46 with 20 views.

Top 3 Topics with Most Replies

Right enter in terminal session not work made by @porush669 with 15 replies.

Questions about OpenBrowser made by @ChenSiXing with 14 replies.

How to capture lastrow of a super long excel table and type into WEB page? made by @yangyq10 with 13 replies.

Top 3 Users Who Posted The Most

@Yoichi made 25 posts!

@Anil_G made 22 posts!

@ashokkarale made 20 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

GenAI activities not showing up in Enterprise version

@Lynn_Song In enterprise do you have ai units? Also are gen ai activities enable din ai trust layer from automation ops? Cheers

This post made by @Lynn_Song received 2 likes!

GenAI activities not showing up in Enterprise version

Thank you so much, I set up the policy and applied to the user and now it works.

This post made by @wahyumrizqi received 1 likes!

Tutorial How To Solve Image Text Captcha On UiPath

Hi Everyone, I hope you are doing well today. i just wanna share, this is my first time video to record full tutorial on UiPath. This video will help you to Solve Image Text Captcha on UiPath with help from 2Captcha API. Feel free if you have any feedback. I Really appreciate that. . Demo: [Demo How To Solve Image Text Captcha Challenge using UiPath] Full Tutorial: [Tutorial How To Solve Image Text Captcha On UiPath]

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

GenAI activities not showing up in Enterprise version

@Lynn_Song In enterprise do you have ai units? Also are gen ai activities enable din ai trust layer from automation ops? Cheers

This solution provided by @vrdabberu received 1 likes!

For Each email: Unable to cast object of type 'System.Char' to type 'System.Text.RegularExpressions.Match'.For Each email: Unable to cast object of type 'System.Char' to type 'System.Text.RegularExpressions.Match

Hi @shubham.jadhav You need to pass result variable in For Each loop because the result variable will store the collection of data that is extracted. ex_email will just store the First Match extracted from the regular Expression. And the variable datatype will be System.String. But the variable datatype of result would be IEnumberable<Match> Hope you understand!! Regards

This solution provided by @mahmoud.zaky received 1 likes!

How to put data from a column of Excel sheet to list of string in

Hi @Vivek_Pandey2 you can try below sequence: For Each file in folder Activity → to get all excel files in your folder and start to iterate on it one by one. Excel scope Activity. Use excel Application activity → you will use the CurrentFile in the location. read range activity → to select the needed column to be used later. create for each data table activity → add the output datatable of above activity in this one. inside it you will use if activity and make the needed logic on it like curr…

---

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

Top 3 Topics with Most Views

Edge browser shows blank page and tab is showing "Loading..." made by @jacchr with 93 views.

Invoke code activity and Remove collection errors made by @gurumurthyv1999 with 25 views.

How to match and mapping values in an excel made by @Kavya_S with 23 views.

Top 3 Topics with Most Replies

I need to Audit list of URL to identify different item they sell in there menu. Through uipath made by @sfdc_sfdc with 15 replies.

How to Automatically Type a Username into a Field Using Automation Tools made by @Aakash_Sharma4 with 13 replies.

I've got this error while running bot in production: Object reference not set to an instance of an object made by @Ngoc_Nguyen with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 48 posts!

@ashokkarale made 20 posts!

@lrtetala made 19 posts!

Top 3 Most Liked Posts

This post made by @Luiza_Surdu-Bob received 4 likes!

Edge browser shows blank page and tab is showing "Loading..."

Hi @jacchr , You are right, this issue is related to the Edge browser update to version 128.0.2739.42. Several users of the Edge browser have already reported this problem: Homepage tab not loading 128.0.2739.42 → https://techcommunity.microsoft.com/t5/enterprise/homepage-tab-not-loading-128-0-2739-42/m-p/4227415 Microsoft Edge 128.0.2739.42 Broken → Reddit - Dive into anything Microsoft is working on this issue and is planning to release a fix later this week, with the next Stable 128 upda…

This post made by @SorenB received 2 likes!

SELECT Studio and Acess

Hello Use breakpoints and Locals panel to check if your variables have the desired (correct) value. Regards Soren

This post made by @jacchr received 1 likes!

Edge browser shows blank page and tab is showing "Loading..."

Hi Experts I have an automation that has been running for quite a long time now. The job is scheduled to run unattended in Orchestrator but since last Friday the jobs all have state Faulted. The same happens when I start the job manually. Looking into the logs of the jobs I can see that the jobs fails when launching the Edge browser and opening the webpage the automation is using. The automation is build using the REFramework template. It was build more than a year ago using 2022.x core compon…

Top 3 Most Liked Solutions

This solution provided by @Luiza_Surdu-Bob received 4 likes!

Edge browser shows blank page and tab is showing "Loading..."

Hi @jacchr , You are right, this issue is related to the Edge browser update to version 128.0.2739.42. Several users of the Edge browser have already reported this problem: Homepage tab not loading 128.0.2739.42 → https://techcommunity.microsoft.com/t5/enterprise/homepage-tab-not-loading-128-0-2739-42/m-p/4227415 Microsoft Edge 128.0.2739.42 Broken → Reddit - Dive into anything Microsoft is working on this issue and is planning to release a fix later this week, with the next Stable 128 upda…

This solution provided by @ppr received 1 likes!

How to match and mapping values in an excel

it is all about requirment definition and sample data When contains ACCESS_ADMIN and is the input then it looks like we want to search for roles from input in the mapping. So we split the input roles on , (From d in dtMapping.asEnumerable Where d("App").toString.Trim.Equals(yourAppKeyVar) Let rls = InputRoleVar.Trim("[]".ToCharArray).Split(","c).Select(Function (x) x.Trim).ToArray Let wrl = d("Role in website").toString.Trim Where rls.Any(Function (v) wrl.Contains(v) ) Select s = d("Role…

This solution provided by @ashokkarale received 1 likes!

How to Automatically Type a Username into a Field Using Automation Tools

@Aakash_Sharma4, Automation is all about teaching or instructing the bot where to click/type and what. Type into activity is built for the purpose of typing something on the application. Instead of searching for other options than Typeinto, I would suggest to find the issue with selector of the field you are trying to type. Thanks, Ashok

---

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

Top 3 Topics with Most Views

How to get the particular table values and store it into another datatable made by @jamuna_T with 19 views.

How can i optimize the if condition as post 15 or more condition sometime it works and somitime not made by @mint with 18 views.

Object reference error in in_Config made by @Jeeru_venkat_Rao with 15 views.

Top 3 Topics with Most Replies

How can i optimize the if condition as post 15 or more condition sometime it works and somitime not made by @mint with 21 replies.

How to get the particular table values and store it into another datatable made by @jamuna_T with 11 replies.

Object reference error in in_Config made by @Jeeru_venkat_Rao with 11 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 26 posts!

@Anil_G made 18 posts!

@lrtetala made 17 posts!

Top 3 Most Liked Posts

This post made by @ashokkarale received 1 likes!

Unable to install package / run automation

@JavXult, Normally the dependency packages gets download automatically to user Nuget folder but check it once if it’s there. You can manually try to copy this package to Nuget folders from your development machine. Thanks, Ashok

This post made by @ppr received 1 likes!

Use skip() and Take() method in linq

we suggest to open a new topic on your case and get individually help Preview: Assign Activity: TableList | DataType: List(of DataTable) = dtDataVar.AsEnumerable.Chunk(SegmentSizeAsIntVar).Select(Function (x) x.CopyToDataTable).ToList UPD1 - added preview on calculation of Fixed, Remaining rest Skip Take calculations: [The image shows a debugging session in Visual Studio Immediate Window, displaying the values and computations for , , , , and . (Captioned by AI)]

This post made by @lrtetala received 1 likes!

Get latest and earliest date from column

Hi @SorenB earliestDate = dt.AsEnumerable() _ .Select(Function(row) DateTime.ParseExact(row("Dates").ToString(), "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture)) _ .Min().ToString("dd-MM-yyyy") latestDate = dt.AsEnumerable() _ .Select(Function(row) DateTime.ParseExact(row("Dates").ToString(), "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture)) _ .Max().ToString("dd-MM-yyyy") Regards,

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Get latest and earliest date from column

Hi @SorenB earliestDate = dt.AsEnumerable() _ .Select(Function(row) DateTime.ParseExact(row("Dates").ToString(), "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture)) _ .Min().ToString("dd-MM-yyyy") latestDate = dt.AsEnumerable() _ .Select(Function(row) DateTime.ParseExact(row("Dates").ToString(), "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture)) _ .Max().ToString("dd-MM-yyyy") Regards,

This solution provided by @SorenB received 1 likes!

Unable to install package / run automation

Hello @JavXult Can you please try and compare this file from your development machine, with the one on your production machine? C:\Program Files\UiPath\Studio\NuGet.config If the 2 files differ, then please try this: Take a backup of the file on your production machine Replace the file on your production machine with the file from your development machine Please let me know if it helps. I have created a case at UiPath Customer Support about this NuGet.config file that doesn’t get update…

This solution provided by @lrtetala received 1 likes!

Regex in if statement

Hi @nmjvk Try this For Each item In textArr If System.Text.RegularExpressions.Regex.IsMatch(item, "CVR") Then ' If "CVR" exists in the current item Else ' If "CVR" does not exist in the current item End If Next 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 | 30 August 2024

Top 3 Topics with Most Views

How can i perform a click and hold a Key for 10 seconds in UI path? made by @Akarshan_Sonkar with 16 views.

Activity Invoke Method is gone made by @sumouse with 14 views.

How to check if multiple folders exists or not? made by @shilpashree.mohanty with 14 views.

Top 3 Topics with Most Replies

How to check if multiple folders exists or not? made by @shilpashree.mohanty with 14 replies.

Want to add header on exported excel made by @Jeeru_venkat_Rao with 11 replies.

Hi, I want to read and write all email Id with ";" separated in one Cell in excel sheet, where I have email id's row by row in excel made by @dinesh.pazhaniyandi with 9 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 22 posts!

@Yoichi made 15 posts!

@lrtetala made 11 posts!

Top 3 Most Liked Posts

This post made by @SorenB received 2 likes!

.screenshots folder missing from .nupkg

Hello @sonaliaggarwal47 I have recently had a support case at UiPath Customer Portal regarding the .screenshots folder. Not the same subject as you are writing about in this post, but during my conversation with the support team, they confirmed that the .screenshots folder does not get included when you publish the project. I think this is mainly to comply with GDPR. Regards Soren

This post made by @111561 received 1 likes!

変数の既定の値が消えます

Studioがアップデートされてから 変数の既定欄がおかしいです。 （バージョンは2024.10.4です。） （1） 過去に作っていたファイル（xamlファイル）を開くと、入力されていた既定欄の値が消えています。 （2） 既定欄に値が入力されているのに、デバッグすると、ローカルパネルでは値がnullになります。 一度まったく他の値を入力し、もう一度正しい値を入力すると、しばらくは定着します。 何度もデバッグしていると、またnullになります。 すべてのxamlファイルではなく、上記現象が起きたり無事だったり、過去に作成したファイルだけでなく、新規で作成したファイルでも起きます。 なかなか再現できないのですが、過去のファイルから値が消えているのは非常に困ります。 解決方法はありますでしょうか？

This post made by @mukeshkala received 1 likes!

2024 Product Updates in UiPath Studio

I just uploaded a new video on my YouTube channel, where I dive into the latest 𝟮𝟬𝟮𝟰 𝗽𝗿𝗼𝗱𝘂𝗰𝘁 𝘂𝗽𝗱𝗮𝘁𝗲𝘀 𝗳𝗼𝗿 𝗨𝗶𝗣𝗮𝘁𝗵 𝗦𝘁𝘂𝗱𝗶𝗼. Keeping up with these #updates is crucial for staying ahead in the automation game, and this video covers everything you need to know! Check out the video here. [UiPath 2024 Product Updates | UiPath Studio New Features | Cumulative Updates 2024] 𝗪𝗵𝗮𝘁’𝘀 𝗜𝗻𝘀𝗶𝗱𝗲? ◉ Enhancements to flowchart capabilities, making process desig…

Top 3 Most Liked Solutions

This solution provided by @adriano.dias received 1 likes!

Integration Services - SharePoint Shared List Not Accessible in Studio

Found out that it was something related to the machine/studio I was using. Moved to another machine, the list was accessible.

---

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

Top 3 Topics with Most Views

Integration of Linkedin in a UiPath automation error made by @Iancecil_W with 10 views.

For each Row: How to get the value of next row value (Current Row +1 ) made by @Yugal_Raju with 7 views.

"message": "Digitize Document: Could not load file or assembly 'Emgu.CV.Platform.NetStandard, Version=4.5.3.4721, Culture=neutral, PublicKeyToken=7281126722ab4438'.\", made by @Polina_Glebovich with 6 views.

Top 3 Topics with Most Replies

How to Authenticate an HTTP Request Using a Cookie made by @Mohamed_Ahmed_Mofreh with 7 replies.

Can't move outlook mail to a specific folder made by @yangyq10 with 5 replies.

Error in saplogon made by @anjani_priya with 5 replies.

Top 3 Users Who Posted The Most

@Anil_G made 43 posts!

@lrtetala made 6 posts!

@Mohamed_Ahmed_Mofreh made 4 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

Why right-side [First Name] get empty when the [For Each Row] is in the second turn?

@Dingkun_Yang looks like it is still loading and the type into started …try to use a delay or wait for load complete cheers

This post made by @Anil_G received 1 likes!

Input method- Simulate & Click type=Double click

@Pavan_kumar15 I hope this clarifies [This image is a note explaining that "SimulateClick" can only be used with the input types "CLICK_SINGLE" and "BTN_LEFT," otherwise an error will occur during workflow execution. (Captioned by AI)] Cheers

This post made by @Anil_G received 1 likes!

For Each UI Element does not work with infinite scroll

@Mubeen_Hassan Without opwning are you not able to fetch the details? If so then first use table extraction /for each ui element just to get the url to each profile Then use loop to navigate to each profile and get the details insteqd of clicking eqch Cheers

Top 3 Most Liked Solutions

This solution provided by @Dingkun_Yang received 1 likes!

Why right-side [First Name] get empty when the [For Each Row] is in the second turn?

Thanks @Anil_G After [Click] was added, it worked. [The image demonstrates the process in a form automation tool, assigning and clicking on a "First Name" field to input "Patricia" as part of an Employee Information form. (Captioned by AI)]

This solution provided by @yangyq10 received 1 likes!

Can't move outlook mail to a specific folder

@lrtetala I get it now, we need to use the 2nd activity but not the 1st one [image]

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

@lrtetala received 36 likes for their solutions!

@ashokkarale received 30 likes for their solutions!

@Yoichi received 21 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 September 2024

Top 3 Topics with Most Views

Excel automation find the count made by @Sai17 with 14 views.

How to use click activity on popup message while opening excel in studio made by @siddharudh.kinagi with 11 views.

Unable to run python script made by @Sandeep_Mishra1 with 8 views.

Top 3 Topics with Most Replies

How to use click activity on popup message while opening excel in studio made by @siddharudh.kinagi with 13 replies.

Unable to run python script made by @Sandeep_Mishra1 with 11 replies.

Run time execution error First studio process made by @brixt.macharia with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 19 posts!

@lrtetala made 9 posts!

@siddharudh.kinagi made 7 posts!

Top 3 Most Liked Posts

This post made by @lrtetala received 2 likes!

Excel automation find the count

@Sai17 If you want to check all columns, then try below Method1: By using For Each loop currentDataRow(currentDataColumn) = If(currentDataRow(currentDataColumn).ToString.Length > 100, currentDataRow(currentDataColumn).ToString.Substring(0, 100), currentDataRow(currentDataColumn).ToString) [This image shows a UiPath sequence workflow that reads data from an Excel file, processes each cell to handle nulls, and writes the updated data back to the same Excel file. (Captioned by AI)] Method2: B…

This post made by @SUDHANSHU_VADUKA received 1 likes!

AI center not being added

Hi, for AI center particularly i have taken the pro trial, but Ai center is not being added at all. For a long time its just showing that its updating, but fails again and agian. Plz help

This post made by @SUDHANSHU_VADUKA received 1 likes!

Excel not being added

[image] Excel Add in is giving an error,even after multiple refreshes, and multple uninstalls and installs

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Insert Excel table data into email body

Hi @wason_ha Can you try below [The image shows a UiPath workflow sequence that reads data from an Excel file and sends an email using the Outlook desktop app, with specified recipient, subject, and body format. (Captioned by AI)] [This image shows an email composition interface with fields for the account, recipient, subject, body (in HTML format), and attachments, with highlighted options for HTML body and opening the editor. (Captioned by AI)] [The image shows an HTML content editor wi…

This solution provided by @lrtetala received 1 likes!

Uipath 에서 웹 브라우저 타겟을 인식하지 못합니다

Hi @diddbwjd1931463 When indicating the element try to change the UI Framework(F4) [The image shows a pop-up menu in a software application, highlighting the selection option to change the UI framework with a tooltip that suggests using F4 to change the technology for determining UI elements and their selectors. (Captioned by AI)] Regards,

This solution provided by @Anil_G received 1 likes!

Question UiPath Academy course

@A_Learner yes till you upgrade you can have only those two 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 | 02 September 2024

Top 3 Topics with Most Views

How to pass excel sheet name in Excel read range made by @shilpashree.mohanty with 21 views.

Chrome v130 will stop running MV2 extensions made by @Luiza_Surdu-Bob with 18 views.

UiPathのOCにサインインできなくなりました。 made by @mayumi-abe with 17 views.

Top 3 Topics with Most Replies

Sorting One of Column from Pivot Table made by @aranadya with 14 replies.

UI PATH APPS - DropDown list on Column made by @sayali.p with 14 replies.

AI center issue with ML skill Activity made by @sagnik.sarkar with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 38 posts!

@lrtetala made 12 posts!

@sayali.p made 10 posts!

Top 3 Most Liked Posts

This post made by @Luiza_Surdu-Bob received 1 likes!

Chrome v130 will stop running MV2 extensions

Background As mentioned in the Chrome MV2 deprecation timeline, Chrome will soon stop running MV2 extensions: Chrome MV2 deprecation timeline Resuming the transition to MV3 Our testing indicates that this will happen in Chrome v130, which is currently in the Dev channel. Chrome v130 is scheduled to reach the Stable channel on October 9th, 2024. See the Chromium release schedule. Initially, the MV2 deprecation will be controllable by this Chrome flag: chrome://flags/#extension-manifest-v2-…

This post made by @Anil_G received 1 likes!

How to mark Sharepoint List the status as Completed/In Progress/ Failed etc

@Chetan_Wagh First use for each list item and use a filter to update only the iem you need…odata filter will help now inside the loop update the column you need and then use update item check this thread to see how to update a sepcific column filter to be used "fields/ColumnName eq '" + in_Transactionitem.SpecificContent("Name").ToString + "'" Hope this helps cheers

This post made by @htanaka1 received 1 likes!

変数の既定の値が消えます

UiPath Studioを再インストール後ですが、SVNでプロジェクトのバージョン管理をしているので、Studio端末に既定値が消えてしまったプロジェクトをチェックアウトしてからは今のところ、事象は発生しておりません。

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

How to mark Sharepoint List the status as Completed/In Progress/ Failed etc

@Chetan_Wagh First use for each list item and use a filter to update only the iem you need…odata filter will help now inside the loop update the column you need and then use update item check this thread to see how to update a sepcific column filter to be used "fields/ColumnName eq '" + in_Transactionitem.SpecificContent("Name").ToString + "'" Hope this helps cheers

This solution provided by @lrtetala received 1 likes!

Consolidated_LineItems_LINQ

Hi @Balachander_Pandian Can you try the below [This image depicts a sequence diagram of an automated process for handling and manipulating data within an Excel file using a series of defined actions such as finding, replacing, copying, appending, filtering, and writing data ranges. (Captioned by AI)] Sequence17.xaml (17.0 KB) Output: Consolidated.xlsx (13.2 KB) Regards,

This solution provided by @vrdabberu received 1 likes!

Why UIDemo Logon cannot be opened when [debug] was clicked?

Hi @Dingkun_Yang You need not give the entire path in Invoke Workflow name there. Just drag and drop the xaml file from Projects Panel which you want to Invoke and map the arguments and variables and try running the flow once. Regards

---

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

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

[system]

Daily Forum Report | 03 September 2024

Top 3 Topics with Most Views

Remove spaces from file name made by @sullivanne with 25 views.

Comparing column name between 2 excel made by @zaffan.isa with 19 views.

Suggest a way to extract the Table made by @Rudhresh_tamil with 19 views.

Top 3 Topics with Most Replies

Need help in scheduling the test case made by @mint with 15 replies.

Remove spaces from file name made by @sullivanne with 14 replies.

Date conversion from numbers to date format made by @maciek with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 53 posts!

@lrtetala made 34 posts!

@ashokkarale made 21 posts!

Top 3 Most Liked Posts

This post made by @sayali.p received 1 likes!

How to add any Credentials in UI PATH APPS?

Actually I wanted to do is , I wanted to store Credentials in Entity i.e. Username and Password So that Username I wanted to check with TextField Control If they Bothe get match then messagebox [A simple login form with fields for User ID and User Password. (Captioned by AI)] this is my Textboxes then in that First textbox [A conditional logic interface shows an if/else statement evaluating user credentials and displaying a message with specified title and content if the condition is met.…

This post made by @lrtetala received 1 likes!

Remove spaces from file name

Hi @sullivanne Path.GetFileNameWithoutExtension(CurrentFile.ToString).Replace(" ", "") Regards,

This post made by @ppr received 1 likes!

Microsoft Office 365 Issue

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Error when filtering outlook messages in the 'Get outlook mail messages activity' C#

@anan.deneke for c# try this "@SQL=\"urn:schemas:httpmail:subject\" like '%New Policy%'" cheers

This solution provided by @lrtetala received 1 likes!

How to rename for a outlook attachment?

Hi @yangyq10 If you have only one attachment try below [The image shows a UiPath workflow sequence for saving email attachments to a specified directory and then renaming the first attachment while keeping its extension. (Captioned by AI)] Regards,

This solution provided by @lrtetala received 1 likes!

How to replace text in word document with random series number

@chaitanyaKumar If you want numbers between 0001 to 9999 then change like below New Random().Next(0001, 9999).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 | 04 September 2024

Top 3 Topics with Most Views

Not able to get the data from the Queue made by @pradyumn.agrawal1 with 28 views.

Publishing project getting timeout error made by @Mozammil with 22 views.

Create Or Condition for Excel Column made by @NISHITHA with 17 views.

Top 3 Topics with Most Replies

Not able to get the data from the Queue made by @pradyumn.agrawal1 with 20 replies.

HOW to downloads multiple pdfs? made by @domsmgtmeet22 with 16 replies.

Extract the text from SAP which is table format made by @Naveen_Kanike with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 50 posts!

@ashokkarale made 37 posts!

@batthula.p949 made 15 posts!

Top 3 Most Liked Posts

This post made by @zell12 received 3 likes!

Dive into the innovative world of agentic AI with UiPath – We need your insights!

Thanks @loredana_ifrim ! Great initiative!! Here’s my 2 cents: Software automation has come a long way from being just a glorified screen scraping solution, to a full-fledged Business Applied AI, that is core in automating end to end critical business processes. Recent advancements mean we can now automate tasks that are far more complex, with more efficiency, than we could just two years ago—or even six months ago. Take UiPath DocPath for example - a fine-tuned large language model for info…

This post made by @chaitanya.kulkarni received 1 likes!

Dive into the innovative world of agentic AI with UiPath – We need your insights!

Integrating UiPath with Agentic AI has truly transformed how we approach automation. As an Automation Architect deeply involved in AI, I’ve seen the power of combining these technologies to create more intelligent, adaptive systems that go beyond traditional automation. With Agentic AI, we’re not just automating tasks; we’re creating bots that can learn, adapt, and make decisions on their own. One of the most exciting projects I worked on involved implementing Agentic AI in a customer support p…

This post made by @Kismet_Tosun received 1 likes!

Interview Question, Can anyone share the code please

Hi, @Shravan_Pintu I made for you. Data.xlsx (8.5 KB) Main.xaml (22.0 KB) project.json (1.7 KB)

Top 3 Most Liked Solutions

This solution provided by @Kismet_Tosun received 1 likes!

Interview Question, Can anyone share the code please

Hi, @Shravan_Pintu I made for you. Data.xlsx (8.5 KB) Main.xaml (22.0 KB) project.json (1.7 KB)

This solution provided by @ashokkarale received 1 likes!

Table Scroll Sideways on the Browser

@SenzoD, Use Mouse Scroll activity here. Thanks, Ashok

This solution provided by @Anuja_Ravikant_Khamitkar received 1 likes!

繰り返しが終了しても現在のインデックスがリセットされない件

問題: ループの intIndex (現在のインデックス) はループ終了後もリセットされないため、テーブル データをスクレイピングして Excel データと照合するときに問題が発生します。 解決策: intIndex をリセット: 各ループまたは繰り返しの後に、intIndex 変数を手動で 0 または目的の開始値にリセットします。 変数の再初期化: 新しい反復を開始する前に、ループで使用されるすべての変数 (intIndex など) が再初期化されていることを確認します。 実装: ループの最後に割り当てアクティビティを追加します: 割り当て: intIndex = 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 | 05 September 2024

Top 3 Topics with Most Views

Why Studio desktop is crashing? made by @RobotUi with 24 views.

Unable to run python code through UIPath made by @Smitesh_Aher2 with 19 views.

Move files one folder another folder? made by @domsmgtmeet22 with 19 views.

Top 3 Topics with Most Replies

Rename filename made by @wason_ha with 12 replies.

Regex grab value for identifier made by @SorenB with 10 replies.

Unable to run python code through UIPath made by @Smitesh_Aher2 with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 21 posts!

@ashokkarale made 18 posts!

@chethan.dinnupati made 15 posts!

Top 3 Most Liked Posts

This post made by @Monica_Secelean received 2 likes!

Dev Dives session on measuring the success of Document Processing automations

Hello UiPath Community! Eager to learn how to measure the success of your document processing automations? Join us on September 26th and let’s have a conversation about key metrics and data points to improve your automations. I am Monica Luca, Senior Product Manager @UiPath, and together with Daniel Lerner, Principal Product Manager @UiPath, we will help you understand the success of your Document Processing automations. Join the next Dev Dives session on September 26th, to: Define t…

This post made by @Jon_Smith received 2 likes!

Extracting Tables From Email Body

Without confidential data please, I am guessing this is a typo

This post made by @moritz.seiler received 2 likes!

Can not bring the target application in foreground because the Windows session is locked

Hi @Kanak_Lata_Singh Many thanks for your answer! I deleted the studio and reinstalled it with in unattended Robot mode instead of Automation Developer. And since then i don’t get the error message. [image] Thanks all!

Top 3 Most Liked Solutions

This solution provided by @moritz.seiler received 2 likes!

Can not bring the target application in foreground because the Windows session is locked

Hi @Kanak_Lata_Singh Many thanks for your answer! I deleted the studio and reinstalled it with in unattended Robot mode instead of Automation Developer. And since then i don’t get the error message. [image] Thanks all!

This solution provided by @Raja2 received 2 likes!
https://forum.uipath.com/t/765019/4

This solution provided by @singh_sumit received 1 likes!

Rename filename

@wason_ha here its working before file name [image] pass this in input parameter [The image shows the UI of the Expression Editor in UiPath, with a code snippet to rename a file by appending the current date in 'yyyy-MM-dd' format to its name. (Captioned by AI)] (upload://bZVuVuhKoKBS94ENeOyZPy3BZx5.png) [image] and finally output (update name) [The image shows a software interface for renaming a file, with an active output indicating the execution of the "CompareTwoSheets" process a…

---

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

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

[system]

Daily Forum Report | 06 September 2024

Top 3 Topics with Most Views

Issue with "Object reference is not set" Error in Read Range Activity made by @Melroy_Dsa with 25 views.

Merge DateTime type column made by @Manisha24 with 21 views.

I wanted to convert column value from date time to string made by @Nisha_K21 with 18 views.

Top 3 Topics with Most Replies

Merge DateTime type column made by @Manisha24 with 15 replies.

Unable to add item using bulk add queue items activity made by @Nisha_K21 with 13 replies.

Custom timeout made by @olgu with 13 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 21 posts!

@Anil_G made 18 posts!

@Yoichi made 16 posts!

Top 3 Most Liked Posts

This post made by @mateuszmacheta received 3 likes!

Custom timeout

Have you tried Timeout Scope? Activities - Timeout Scope

This post made by @Melroy_Dsa received 2 likes!

Issue with "Object reference is not set" Error in Read Range Activity

I was recently using the read range activity to read from an excel file. Despite providing the correct file location and sheet name, I kept receiving the error message: “Object reference is not set to an instance of an object". When I added a new Read Range activity with the same properties, it resolved the issue and worked as expected. Has anyone experienced a similar issue? Any insights on why the original Read Range activity failed while the new one worked would be greatly appreciated. [Th…

This post made by @Binit_Sarkar received 1 likes!

Issue with "Object reference is not set" Error in Read Range Activity

Same bro, Even i have faced similar issue

Top 3 Most Liked Solutions

This solution provided by @Kismet_Tosun received 1 likes!

Issue with "Object reference is not set" Error in Read Range Activity

Don’t use the Workbook. Try excel application scope and read range.

This solution provided by @Yoichi received 1 likes!

Merge DateTime type column

It’s my bad. I had modified at wrong place. The following expression will work. dt.AsEnumerable.GroupBy(Function(r) r("BookID").ToString).Select(Function(g) dt.Clone.LoadDataRow({g.Key,String.Join(",",g.Where(Function(r) not String.IsNullOrEmpty(r("BookName").ToString)).Select(Function(r) r("BookName").ToString)),String.Join(",",g.Where(Function(r) r("PublishesDate") isnot Nothing AndAlso DateTime.TryParse(r("PublishesDate").ToString,Nothing)).Select(Function(r) CDate(r("PublishesDate").ToStrin…

This solution provided by @Yoichi received 1 likes!

Excel Read Range of strings into datatable adds quotation marks to some strings

Hi, I directly checked the string data inside the xlsx file. However, there is no special character including double quote. [image] i guess it’s caused by comma in each data. If you need to remove the double quotes, Trim(Chr(34)) may help you as workaround. Regards,

---

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

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

[system]

Daily Forum Report | 07 September 2024

Top 3 Topics with Most Views

Hiii all I am getting this error during creating a new project.Ialso tried Uninstall and reinstall but again this error came plz help me out made by @bharti_Ranjan with 12 views.

We are now using modern folders but my start job activity wont start the job, in classic folder setup it was working fine made by @Farai_Alvin with 12 views.

Here inspect, what does it mean exactly? made by @Ayatulla_Middya with 11 views.

Top 3 Topics with Most Replies

Help with filtering out data rows with certain values in columns made by @jwetherin with 5 replies.

Which is actually correct? made by @Ayatulla_Middya with 4 replies.

Access new dinammicaly created chrome tab made by @Tudor_Gavriliuc with 3 replies.

Top 3 Users Who Posted The Most

@Anil_G made 16 posts!

@Ayatulla_Middya made 3 posts!

@mkankatala made 3 posts!

Top 3 Most Liked Posts

This post made by @mkankatala received 1 likes!

Which is actually correct?

Hi @Ayatulla_Middya In UiPath, Workbook activities are generally faster than Excel activities. This is because Workbook activities interact directly with the file system, without needing Excel to be installed or opened in the background. On the other hand, Excel activities rely on the Excel application, which can add some overhead due to the application’s loading time and resource usage. However, the difference in speed may not always be significant, depending on the size of the data and the c…

This post made by @Yoichi received 1 likes!

Which is actually correct?

Hi, I don’t think the second option is correct, because of the following. Workbook activity is not always fast. Especially, in case of a lot of manipulation. Excel activity is reliable. Rather, workbook activities may cause compatibility issues because they do not use Excel applications. Regards,

This post made by @Ayatulla_Middya received 1 likes!

Which is actually correct?

@mkankatala thank you

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

Which is actually correct?

Hi @Ayatulla_Middya In UiPath, Workbook activities are generally faster than Excel activities. This is because Workbook activities interact directly with the file system, without needing Excel to be installed or opened in the background. On the other hand, Excel activities rely on the Excel application, which can add some overhead due to the application’s loading time and resource usage. However, the difference in speed may not always be significant, depending on the size of the data and the c…

This solution provided by @Anil_G received 1 likes!

Unable to define default value of dropdown when using Forms and dynamic list

@dokumentor My bad i checked and yes its the last item it is picking always…we had a similar situation in one of the processes…and default galue property in backend is not getting reflected even if we set it manually so we had to go this route 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.