Forum Engagement Daily Reports

[system]

Daily Forum Report | 24 August 2023

Top 3 Topics with Most Views

Download documents made by @Nikhil_Katta with 46 views.

I need help to resolve below issue made by @Shru_6 with 45 views.

Stay on page popup while downloading the file made by @Priyesh_Shetty1 with 45 views.

Top 3 Topics with Most Replies

엑셀 공백 셀에 원하는 문자 넣는 방법 문의 made by @geuncho with 31 replies.

I need help to resolve below issue made by @Shru_6 with 24 replies.

Collect specific date of latest update on Spotify playlist (what activities to use?) made by @Chris_Balance with 20 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 48 posts!

@Nguyen_Van_Luong1 made 38 posts!

@Anil_G made 27 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

How to add Key Value Pair in a Dictionary variable?

HI, Can you try either of Assign activity or InvokeMethod activity as the following? [image] Regards,

This post made by @jojo11050702 received 2 likes!

How to connecting to MSSql by using DataBase activity?

Thanks @Anil_G @Parvathy for replying me. By following the thread and the article you mentioned, I connected to the server successfully.

This post made by @Anil_G received 2 likes!

How to connecting to MSSql by using DataBase activity?

@jojo11050702 First install the drivers and as per the drivers select the connection provider using connection wizard and procide db name and othe details…it would build the connection string Or verify connection strings here Cheers

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to add Key Value Pair in a Dictionary variable?

HI, Can you try either of Assign activity or InvokeMethod activity as the following? [image] Regards,

This solution provided by @nikhil.girish received 1 likes!

How do we get machine name while running a process

Hi @sakshi562023 check this out hope this helps

This solution provided by @Yoichi received 1 likes!

Did you listen for file name change activity?

Hi, If you need to process next task when the file name is changed, TriggerScope+FileChange trigger will work. [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 | 25 August 2023

Top 3 Topics with Most Views

I need to extract all the details from invoices made by @pravin_bindage with 52 views.

Value binding option missing made by @mkankatala with 46 views.

Regex code to pull text from pdf's made by @Priyesh_Shetty with 43 views.

Top 3 Topics with Most Replies

I need to extract all the details from invoices made by @pravin_bindage with 20 replies.

Regex code to pull text from pdf's made by @Priyesh_Shetty with 18 replies.

Reading a text file and extract and store the values in variables made by @kaustubh.aras28 with 14 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 26 posts!

@Nguyen_Van_Luong1 made 25 posts!

@postwick made 22 posts!

Top 3 Most Liked Posts

This post made by @Shiva_Nikhil received 1 likes!

【質問】Webのプルダウンリストの値を取得する方法

@Mint_Anzu 範囲書き込みアクティビティを使用する または、以下のものを試してください [image]

This post made by @tazunnisa.badavide received 1 likes!

Reading a text file and extract and store the values in variables

Hey You can also refer the below xaml Main.xaml (10.3 KB)

This post made by @supermanPunch received 1 likes!

Value binding option missing

Hi @mkankatala , A Quick check on this, when selected the Legacy version or Expression, we do get the same properties as mentioned by @Anil_G and when selected the VB version we do not have the Value binding option or is a different property (not so clear or did not find the same). Expression Language - Legacy : [image] Expression Language - VB : [image]

Top 3 Most Liked Solutions

This solution provided by @Shiva_Nikhil received 1 likes!

【質問】Webのプルダウンリストの値を取得する方法

@Mint_Anzu 範囲書き込みアクティビティを使用する または、以下のものを試してください [image]

This solution provided by @ppr received 1 likes!

CurrentRow not able to compare to string

Use following within the conditon FINALWAREHOUSE.trim.eqals(“yorcheckstring”)

This solution provided by @lrtetala received 1 likes!

The Invoke Method activity is throwing this error when passing the arguments

Hi @shenyu Please check on this thread I hope it helps!!

---

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

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

[system]

Daily Forum Report | 26 August 2023

Top 3 Topics with Most Views

Activity for questioning made by @ydhanabalan with 33 views.

PDF split with specific file name made by @Krishnakumar_Vasudevan with 28 views.

How to round 0.565 to 0.57? made by @donghai with 27 views.

Top 3 Topics with Most Replies

Activity for questioning made by @ydhanabalan with 17 replies.

Handling multiple popup while downloading made by @Priyesh_Shetty with 17 replies.

Automating reading a range from Excel and do a search with this batch until the sheet is over made by @mahmoud_sedek with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 52 posts!

@Usha_Jyothi made 22 posts!

@postwick made 15 posts!

Top 3 Most Liked Posts

This post made by @girishankar09 received 1 likes!

Error while capturing image "Object Reference Not Set To An Instance Of An Object"

Thanks @mkankatala So I am running this on Remote Desktop/Workspace. So when I close this, it should ideally run on backend (which works on my other projects/workflows related to my bowse). Only this screenshot activity gives issues. Any suggestion or option to solve this?

This post made by @Anirudh_Tugawe received 1 likes!

Uipath Got Stuck

really?? everyone at this point facing the same issue?

This post made by @Anil_G received 1 likes!

Activity for questioning

@ydhanabalan It wont automatically as anything…you need to write your own logic…for asking questions you can use input dialog box or forms activities and create a form as well cheers

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

Uipath Got Stuck

@Anirudh_Tugawe , Could you check the below post if it is the same case that you are referring to ? Also check if the Package versions are also the same as mentioned in the post. Also, Could you check your opened Application tabs (Maybe using Alt+Tab), to check if the Log Message Expression Window is still open ?

This solution provided by @mkankatala received 1 likes!

Can we export the workflows to PDF, something similar to exporting them to excel?

Hi @Shreya_Gandhi We can save the workflow as a image, after that you can make it to pdf by using online converters. If you want to save it as Image. Right click on the Main sequence and select the save as image option. It will save all the workflow as image. Hope it helps!!

This solution provided by @neha.upase received 1 likes!

How to round 0.565 to 0.57?

Yes, the approach will work for rounding any number to a specified number of decimal places, including numbers like 5.896556. Let’s go through the process step by step using the same approach: Original number: 5.896556 Adding 0.005 to the original number: 5.896556 + 0.005 = 5.901556 Rounding the adjusted number to two decimal places: Math.Round(5.901556, 2) = 5.90 So, for the input 5.896556, the code would output the rounded value 5.90, which is rounded to two decimal places as per your origi…

---

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 2023

Top 3 Topics with Most Views

Read Range Workbook does not exist made by @Anirudh_Tugawe with 34 views.

Inserting a Table in email body made by @Nikhil_Katta with 32 views.

DT Activities made by @J_Crosby with 31 views.

Top 3 Topics with Most Replies

Read Range Workbook does not exist made by @Anirudh_Tugawe with 18 replies.

Inserting a Table in email body made by @Nikhil_Katta with 11 replies.

Multiply the columns with a value made by @Kira with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 49 posts!

@mkankatala made 11 posts!

@Vikas_M made 9 posts!

Top 3 Most Liked Posts

This post made by @Shreya_Gandhi received 2 likes!

Can we export the workflows to PDF, something similar to exporting them to excel?

Thank you so much Mahesh and Parvathy

This post made by @Nikhil_Katta received 1 likes!

Inserting a Table in email body

thanks for replying … but here iam not using outlook activites … im using only smtp

This post made by @Anil_G received 1 likes!

Win 11 Context Menu Not Selectable

@private_matter Did you try using a power shell script to extract the files? that way we can pass the filepath and everything actually happens in background cheers

Top 3 Most Liked Solutions

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

Desper: API Start Job Error 404

@seyjo1 - You probably have checked already but since not mentioned in the post and want to make sure, can you share if you are using POST as the method instead of GET or anything else? [image]

This solution provided by @private_matter received 1 likes!

Win 11 Context Menu Not Selectable

Look forget it. I used a start process activity as such: Executable Path: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe Arguments: Expand-Archive -LiteralPath C:\Users\Administrator\Desktop\archive.zip -DestinationPath C:\Users\Administrator\Desktop\archive That works as well.

---

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 2023

Top 3 Topics with Most Views

How to extract the Name and DoB from PAN Card made by @raju_alakuntla with 54 views.

Orchestratorへパブリッシュができない made by @tomoya.nakagawa with 46 views.

Compare 2 sheets and get the value made by @Kunal_Jain with 44 views.

Top 3 Topics with Most Replies

How to extract the Name and DoB from PAN Card made by @raju_alakuntla with 26 replies.

Compare 2 sheets and get the value made by @Kunal_Jain with 26 replies.

Can anyone Help with RegEx Expression? made by @rodrigo.simao with 25 replies.

Top 3 Users Who Posted The Most

@Anil_G made 46 posts!

@Shiva_Nikhil made 43 posts!

@Nguyen_Van_Luong1 made 35 posts!

Top 3 Most Liked Posts

This post made by @Shiva_Nikhil received 2 likes!

Compare 2 sheets and get the value

@Kunal_Jain Dt1.AsEnumerable().Where(Function(row) Dt2.AsEnumerable().Any(Function(x) x(“RegionSate”).ToString.contains(row(“Region”).ToString))).CopyToDataTable Try this once

This post made by @Clintonnn received 2 likes!

Problem with parsing a Json with invalid characters

Thank worked @Yoichi! Thank you so much, you are a king

This post made by @Anil_G received 2 likes!

Need help on sending an image with variable name appended

@mb29 Can you please use a formatted text or a screenshot to show how youa re giving ideally this would work "<img src=""" + var + "_results.png"" />" cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Need help on sending an image with variable name appended

@mb29 Can you please use a formatted text or a screenshot to show how youa re giving ideally this would work "<img src=""" + var + "_results.png"" />" cheers

This solution provided by @ppr received 1 likes!

How to check IEnumerable(Match) variable through IF statement

We assume that the matches Activtiy is involved (You mentioned IEnumerable(Of Match) And not MatchCollection (output from Regex.Matches) A pattern could look like this: [grafik]

This solution provided by @Yoichi received 1 likes!

Problem with parsing a Json with invalid characters

Hi, Can you try the following expression? strJson = strJson.Trim({"@"c,""""c,Chr(10),Chr(13)}).Replace("""""","""") [image] Sample20230828-1L.zip (3.2 KB) Regards,

---

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

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

[system]

Daily Forum Report | 29 August 2023

Top 3 Topics with Most Views

Help to write Regex Pattern to find job title comes together with experience date? made by @Gowthaman_Gajakutti with 40 views.

Linq Query to Update a column depending on the value of another column made by @Amrutha.mg with 37 views.

Replace picture made by @Yogita_Gaikwad1 with 37 views.

Top 3 Topics with Most Replies

How can I rename the file and move in new excel sheet with rename with saheer name made by @suraj_gaikwad with 22 replies.

Help to write Regex Pattern to find job title comes together with experience date? made by @Gowthaman_Gajakutti with 21 replies.

How to copy mutiple rows into different excel sheets made by @anjani_priya with 19 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 70 posts!

@mkankatala made 54 posts!

@ppr made 38 posts!

Top 3 Most Liked Posts

This post made by @Lucas.Pimenta received 6 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

Awesome! I would love to participate as a Brazilian Portuguese speaker Count me in!

This post made by @Yoichi received 5 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

Hi @loredana_ifrim Thanks for sharing the interesting initiative. I’d like to join (Japaneses language). Regards,

This post made by @brunabruno received 5 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

Yesss!!! Of course @carlosevp! I’m so excited with that…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Linq Query to Update a column depending on the value of another column

Hi, How about the following sample? dt.AsEnumerable.ToList.ForEach(Sub(r) If arrTarget.Contains(r("vendor").ToString) Then r("status")="Exact" Else r("status")="Not Exact" End If End Sub) [image] Sample20230829-1L.zip (8.4 KB) Regards,

This solution provided by @Steven_McKeering received 1 likes!

Help to write Regex Pattern to find job title comes together with experience date?

Hi Well try this pattern: (?<=\))(.+?)(?=\d|Invalid) [image] I thought you needed the date also.

This solution provided by @Riyas.Muhammed received 1 likes!

Excel lookup cell

@Karan_Chauhan , If you what to know the Cell address of the word you are looking for, you can use “LookUp Range” activity inside “Excel Application Scope”. Output result will give you the cell address. [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 | 30 August 2023

Top 3 Topics with Most Views

UiPath UIAutomation 23.8 Community Release made by @Bogdan_Sultana with 73 views.

【募集期間が延長されました】コミュニティ フォーラム: 新しい翻訳機能のテスト参加者を募集しています! made by @Susa with 58 views.

String manipulation and comparison made by @duaine.b with 47 views.

Top 3 Topics with Most Replies

Remove comas from data table or txt made by @E.T.S with 43 replies.

String manipulation and comparison made by @duaine.b with 19 replies.

REGEX quiz made by @Latifa with 16 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 70 posts!

@postwick made 44 posts!

@mkankatala made 43 posts!

Top 3 Most Liked Posts

This post made by @rikulsilva received 4 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

I’d love to join - Brazilian Portuguese

This post made by @Bogdan_Sultana received 4 likes!

UiPath UIAutomation 23.8 Community Release

The UIAutomation 23.8 Preview package was just published with a slight delay vs. the other UiPath Preview packages. Here’s what’s new: With our latest enterprise version 23.4 we released the Trigger-based framework, a new way to build Attended Automations, with event-driven architecture. We provided support for native events monitoring through the Application Event Trigger activity for certain technologies: Web, Java, Active Accessibility. Also, we continue our story of integrating Computer Vis…

This post made by @Susa received 3 likes!

【募集期間が延長されました】コミュニティ フォーラム: 新しい翻訳機能のテスト参加者を募集しています!

以下は Fresh New Opportunity: Pilot A New Forum Feature and Get Rewarded! の抄訳です。詳しくは、元の記事をご覧ください。 UiPath コミュニティ ユーザーの皆様へ、 9 月 1 日から 9 月 24 日までの間、UiPath コミュニティ フォーラム内で、新しい翻訳プラグインのパイロット プロジェクトを実施します。つきましては、このプロジェクトにご参加いただける日本語話者のボランティア メンバーを先着 5 名で募集いたします。 ご参加いただける方は、8 月 31 日 9 月 7 日までに Fresh New Opportunity: Pilot A New Forum Feature and Get Rewarded! に対してリプライしてお申し込みください。翻訳プラグインの使用感についてご感想を提供いただける場合、40 ドル相当の UiPath グッズ バウチャーをご用意しております。 皆様のご参加を心よりお待ちしております。 UiPa…

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 2 likes!

For Each Element Properties

Hi @mango3392 To get the properties of type argument for the for each activity. Downgrade the version of UiPath.System.activities package. Then you can see the type argument properties in for each activity. But the new for each also works good, When you pass the collection variable in the condition field it will automatically changes its type argument automatically. If the condition is array variable it will automatically changes it type argument to array in the background and it works fine. H…

This solution provided by @arjunshenoy received 1 likes!

Else Ifアクティビティの条件文の計算結果をBoolean型に変換したい

Hi @gorby Could you please try the following condition: CInt(row(“number of oranges”).ToString) > 0 AND CInt(row(“number of oranges”).ToString) < 6 Hope this helps, Best Regards.

This solution provided by @Yoichi received 1 likes!

Tricky Question

Hi, How about the following expression? yourString="900323" Then listStr = Enumerable.Range(0,4).Select(Function(i) yourString+i.toString+"00000").ToList [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 | 31 August 2023

Top 3 Topics with Most Views

Reading config from Asset instead of Config.Json or Excel file made by @sonaliaggarwal47 with 47 views.

How to change month to number made by @Mathkar_kunal with 47 views.

Looping over data rows, but starting with the 5th row directly made by @maria-iulia.zdrenghea with 41 views.

Top 3 Topics with Most Replies

How to change month to number made by @Mathkar_kunal with 39 replies.

Excel Formulas when assigned not working made by @P-A-J with 24 replies.

Update values DT in single row made by @Sathish_Kumar_S with 24 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 65 posts!

@Anil_G made 60 posts!

@mkankatala made 51 posts!

Top 3 Most Liked Posts

This post made by @l.wang received 3 likes!

To Make Workflow analyzer rules automatically apply to all projects universally across the UiPath Studio environment

Thanks! That was what I thought. The rules are on the project level. The only way to make it shared through projects is to make a template I guess.

This post made by @HANACCHI received 2 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

Thanks for sharing the interesting initiative. I’d like to join (Japaneses language). 73 & 88

This post made by @robot.gestus received 2 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

Great, I would like to participate and help as a Brazilian Portuguese speaker.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

My studio publish is grayed out (Attended License)

Hi, Can you check the following document? Is there Robot default option? [image] https://docs.uipath.com/studio/standalone/2023.4/user-guide/about-publishing-automation-projects If we have only Attended license, we cannot publish the project. (We need Automation Developer license etc.) Regards,

This solution provided by @nikhil.girish received 1 likes!

Uipath getting freezed while

Hi @sakshi562023 Check this post Hope this might help

This solution provided by @Vikas_M received 1 likes!

Rgex other than is pattern matching

[image] Please refer above screenshot so basically it is near variables panel Hope it helps u out1

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

@Anil_G received 49 likes for their solutions!

@Yoichi received 45 likes for their solutions!

@ppr received 31 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 2023

Top 3 Topics with Most Views

Thoughts after the UiPath Hyperhack 2023 made by @George_Roth with 51 views.

Can't get the correct datetime format made by @cacafundi with 46 views.

Counter with split - help made by @Ellen with 44 views.

Top 3 Topics with Most Replies

I want to convert pdf file to excel made by @office_work with 22 replies.

Counter with split - help made by @Ellen with 20 replies.

Get last value with regex made by @murat.karasoy with 15 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 50 posts!

@Anil_G made 36 posts!

@postwick made 31 posts!

Top 3 Most Liked Posts

This post made by @George_Roth received 6 likes!

Thoughts after the UiPath Hyperhack 2023

I had the honor to participate as a Jury member at the 2023 HyperHack AI Category Section. I didn’t see all the projects, but I saw the finalist 9. I was impressed by all these, below is the list of the finalists with what their automations do. First prize: DrSimplifAI – developed by SimplifyNext team from Singapore This is an automation app for a healthcare use case that aims to enhance the patient experience and improve doctor-patient interactions by leveraging Specialised AI and Generative…

This post made by @koreta received 5 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

Hi @loredana_ifrim. I would like to participate. I speak Japanese. Thank you in advance.

This post made by @Yamasakia received 4 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

I want to participate I am Japanese. Best regards.

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Questions About StudioX found in Dumps of RPA Exam Questions

@Shreyas_Khorgade There would not be any studiox related question for detailed syllabus check this…this will have all info [image] and also questions would be almost at same level as the exam cheers

This solution provided by @nikhil.girish received 1 likes!

Remove vowels from string

Hi @Rishab2 Welcome to community Check this expression Have this in value stored to a variable System.Text.RegularExpressions.Regex.Replace(“yes”,“[AEIOUaeiou]”,“”)

This solution provided by @mkankatala received 1 likes!

Read Range stays pending & Date conversión issue

Hi @Luis_Fernando Instead of using read range workbook activity use the read range activity which is the modern excel activity. => Take use excel file activity and pass the excel file path. => Inside use excel file activity insert the read range activity. In the properties of read range activity, Read formatting option is there select the raw value option which holds the same format of the cells and store in a datatable. => After that use the write csv file to write the datatable to csv file…

---

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 2023

Top 3 Topics with Most Views

Read CSV Activity made by @KuruvaJayaPrakash with 33 views.

How can I delete rows in an excel file if for example column A is empty made by @goncalo.rocha with 32 views.

Extract the filenames from a folder and save them in Excel or Notepad made by @jharmel.carmona with 29 views.

Top 3 Topics with Most Replies

Match DT data with other DT and get the email address made by @Sathish_Kumar_S with 18 replies.

Extract the filenames from a folder and save them in Excel or Notepad made by @jharmel.carmona with 10 replies.

How to convert a string to a mail message made by @P-A-J with 9 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 14 posts!

@Anil_G made 12 posts!

@postwick made 11 posts!

Top 3 Most Liked Posts

This post made by @takashi_hashimoto received 2 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

I am a Japanese living and working in Japan. I would love to participate.

This post made by @takashi_hashimoto received 2 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

Native language is Japanese

This post made by @Yoichi received 1 likes!

Need help on arg value

Hi, Unfortunately, out type argument will be blank when exit the xaml due to exception. How about using exception.Data as the following sample? Set content of yourname variable to exception.Data(“Yourname”) , then rethrow [image] we can get it using exception.Data(“yourname”) in catch state of main.xaml [image] The following is a sample of the above. BlankProcessv2.zip (6.4 KB) Regards,

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 | 03 September 2023

Top 3 Topics with Most Views

Code working in studio run but not through orchestrator made by @JOBIN_JOSE with 38 views.

Re framework automation made by @J_Crosby with 33 views.

Problem extracting Data URL made by @hiring.antiquescollectors with 32 views.

Top 3 Topics with Most Replies

How to get string after some character made by @aslam_ali1 with 13 replies.

Excel freeze Panes made by @Luffy with 13 replies.

Re framework automation made by @J_Crosby with 9 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 15 posts!

@postwick made 12 posts!

@Shiva_Nikhil made 11 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 2 likes!

Re framework automation

Oh wow I m right It’s already discussed in forum @J_Crosby

This post made by @J_Crosby received 1 likes!

Re framework automation

@Palaniyappan @Shiva_Nikhil I saw those two questions and doubted the correct options after reading deeply on re-framework, that’s why I asked. Option B is also what I think is right from my research. I just needed a confirmation. Thanks a lot guys for your time Cheers J Crosby

This post made by @Vikas_M received 1 likes!

Good evening, how to use regex in assign please

Hey @Girid , Please refer to already available questions in the forum in order to avoid recurring threads Also, to answer your question U can use System.Text.RegularExpressions.Regex.match(YourString,"\d+\d+.\d+").value Hope it helps you out!

Top 3 Most Liked Solutions

This solution provided by @Vikas_M received 1 likes!

Good evening, how to use regex in assign please

Hey @Girid , Please refer to already available questions in the forum in order to avoid recurring threads Also, to answer your question U can use System.Text.RegularExpressions.Regex.match(YourString,"\d+\d+.\d+").value Hope it helps you out!

This solution provided by @postwick received 1 likes!

Need a linq query to solve this issue

Why bother with an extra variable? Just do it all with an If expression… If(CurrentRow.ItemArray.All(Function(x) x.ToString().Equals(“NoChange”)),"OK","Error")

This solution provided by @Palaniyappan received 1 likes!

Transaction Status

It’s option B @J_Crosby

---

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 2023

Top 3 Topics with Most Views

Errror Compare Two File made by @Muhammad_Taufik_Akbar with 52 views.

How to replace blank cell with 0 using Excel activities made by @lrtetala with 42 views.

UiPath Can't indicate SAP element made by @alvin.c.apostol26 with 40 views.

Top 3 Topics with Most Replies

Conditional formatting made by @E.T.S with 18 replies.

Unable to run app on mobile made by @Mathkar_kunal with 16 replies.

Get queue items -set transaction progress! made by @Hazem_Saleh with 15 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 50 posts!

@supermanPunch made 30 posts!

@ppr made 28 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 5 likes!

How to replace blank cell with 0 using Excel activities

Hi @lrtetala , Could you try using the below value in ValueToFind property and check : Type.Missing Maybe also Match Entire Cell Contents property is needed to be updated : [image]

This post made by @Anuj_Tiwari received 3 likes!

Migrating Legacy Listings to Windows

Hi everyone, You may already be aware that the default compatibility for new projects in latest versions of UiPath Studio is “Windows”. It’s important to know that the number of users using the Windows projects in Studio is increasing rapidly. The Legacy listings won’t support Windows so those users of latest Studio version(s) won’t be able to find and use Legacy listings under default compatibility. Therefore, we strongly ask all of you to complete the transition of your legacy listings to W…

This post made by @Pothanakar_Prabhakar received 2 likes!

How we can install uipath studio on linux server

Thanks for the resolution @Palaniyappan @arjunshenoy

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 5 likes!

How to replace blank cell with 0 using Excel activities

Hi @lrtetala , Could you try using the below value in ValueToFind property and check : Type.Missing Maybe also Match Entire Cell Contents property is needed to be updated : [image]

This solution provided by @Arvind_Kumar1 received 2 likes!

Passing values from one page to another

@Aditi_Jha , as you shown you are not using VB Apps. so please do below steps on legacy app. Set Value on click rule Create app variable In Set value pass the App variable and set value from your custom list. you can use app variable across other page now. Thanks, Arvind

This solution provided by @supermanPunch received 2 likes!

Write the values based on the column name in write cell activity

Hi @tharani.natarajan , Assuming that you have read the Data as a Datatable in Excel sheet, we can check with the below to convert Column Index to Column Letter : columnLetter = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(DT.Columns.IndexOf("MailId")+1) Here, DT is the Datatable variable and columnLetter is a String variable.

---

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 2023

Top 3 Topics with Most Views

How to hide password in the UiPath Apps made by @karthickrkumaran with 49 views.

UiPathTeam.SharePoint.Activities Authentication exception: The sign-in name or password does not match one in the Microsoft account system made by @Yap_Derek with 42 views.

Need Regex Expression made by @Konda_Sai_Charan_Goud with 40 views.

Top 3 Topics with Most Replies

Delete existing file in download activity made by @E.T.S with 18 replies.

I want to create excel sheet on monthly basis made by @Bhushan_Nagaonkar with 15 replies.

SQL update passing variable made by @Povilas_Jonikas with 14 replies.

Top 3 Users Who Posted The Most

@ppr made 44 posts!

@Palaniyappan made 43 posts!

@postwick made 38 posts!

Top 3 Most Liked Posts

This post made by @Yap_Derek received 2 likes!

UiPathTeam.SharePoint.Activities Authentication exception: The sign-in name or password does not match one in the Microsoft account system

Hi All, I am using the UiPathTeam.SharePoint.Activities on a windows legacy project to connect to SharePoint and I experiencing this authentication error. The bot has been running fine using this method for a long time until it failed yesterday. [image] Here are some additional details: Studio Version 2022.10.5 Robot is running on Window Server 2019 Account used does not have MFA enabled. I am using the latest version of the package which is version 1.7.0 I have doubled check and the login…

This post made by @Palaniyappan received 2 likes!

Duration process

Hi once the job run is over for a process, you can open Automation - > JOBS tab and click on " i " symbol to that run it shows the start time and end time like this [image] @Khoa_Automation-Factory

This post made by @Anil_G received 2 likes!

UiPathTeam.SharePoint.Activities Authentication exception: The sign-in name or password does not match one in the Microsoft account system

@Yap_Derek This has been an open issue…workaround or better solution would be to move to office 365 activities Cheers

Top 3 Most Liked Solutions

This solution provided by @arjunshenoy received 2 likes!

Is it necessary to pass UiRPA before taking UiARD?

Hi @postwick If you have sufficient functional experience & knowledge of the UiPath tools, you can just skip the UiRPA & directly take up the UiARD examination, as I did. Hope this helps, Best Regards.

This solution provided by @postwick received 2 likes!

Object reference error plz solve

Check the arguments and variables. If this happens right when you try to run a process, it can mean you have something defined that doesn’t exist yet. For example, you cannot reference one variable in another variable’s default.

This solution provided by @Nitya1 received 2 likes!

Setting smart queue/time triggers

Hi @olgu Managing job triggers and ensuring that they don’t interfere with scheduled machine maintenance can be a challenging task in UiPath Orchestrator. Here are some suggestions to handle this scenario: Check Time Inside Workflow: As you mentioned, you can add logic within your workflow to check the current day and time. If it’s close to the scheduled maintenance window, you can gracefully end the job, making sure to complete any necessary cleanup tasks. Queue Trigger Time Window: 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 | 06 September 2023

Top 3 Topics with Most Views

For each activity property missing made by @Jeeru_venkat_Rao with 45 views.

For Each Row in Data Table fail. Why? made by @Norbi_V with 42 views.

Multiple attribute in selector using OR operator made by @Akshat_Sharma1 with 40 views.

Top 3 Topics with Most Replies

Guide me how can i download the several file from the website made by @Akash5 with 23 replies.

Using browser in a loop error made by @Povilas_Jonikas with 15 replies.

For each activity property missing made by @Jeeru_venkat_Rao with 13 replies.

Top 3 Users Who Posted The Most

@postwick made 31 posts!

@Palaniyappan made 29 posts!

@ppr made 26 posts!

Top 3 Most Liked Posts

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

Help me with coding uipath best practices

Hi @Rishab2 Check this out Hope this helps

This post made by @Yap_Derek received 2 likes!

UiPathTeam.SharePoint.Activities Authentication exception: The sign-in name or password does not match one in the Microsoft account system

Thanks for your answer @sonaliaggarwal47. I have not upgraded to v2020.10.x recently. When I started working on UiPath projects, the studio version I work with is already version 2022.10.5 and we have been running this version for the past 7-8 months. I will look into the o356 activities as suggested. Thanks

This post made by @Akshat_Sharma1 received 1 likes!

Multiple attribute in selector using OR operator

Hi Community, Recently I came across an automation problem. I am using element exist activity using aaname to detect a text. Now in some cases with aaname its not able detect element but with visible innertext its able to detect. Is there any way we can use put both and if value matches with either aaname or visible innertext then element exist returns true value. Thanks

Top 3 Most Liked Solutions

This solution provided by @nikhil.girish received 2 likes!

Help me with coding uipath best practices

Hi @Rishab2 Check this out Hope this helps

This solution provided by @Karthik_Reddy_A received 1 likes!

For each row in Excel file

@E.T.S hi use for each row in datatable inside use two assign activities variable1=currentrow(“ColumnName”).tostring variable2=currentrow(“ColumnName”).tostring columnname you can mention your column Names cheers

This solution provided by @Vikas_M received 1 likes!

I have 2 excel with same headers

Hey @Girid Please refer below website https://docs.uipath.com/activities/other/latest/workflow/merge-data-table Also please refer below video [UiPath Tutorial | Merge Data table & Join Data tables activity | Comparison and property explanation] Hope it helps you!

---

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 2023

Top 3 Topics with Most Views

Unable to resolve Object reference error at startup made by @theEmailRobot with 52 views.

[Solved] UiPath to show timestamp in message box made by @Sathish_Ashokan with 45 views.

UiPath Action Center help needed made by @Ritaman_Baral with 43 views.

Top 3 Topics with Most Replies

Unable to resolve Object reference error at startup made by @theEmailRobot with 26 replies.

Renaming file with current date and time made by @E.T.S with 18 replies.

Can i paste value in variable? made by @Samraat_Maharjan1 with 16 replies.

Top 3 Users Who Posted The Most

@postwick made 40 posts!

@Palaniyappan made 37 posts!

@ppr made 27 posts!

Top 3 Most Liked Posts

This post made by @ppr received 1 likes!

Convert HTTP Response with nested JSON to DataTable

For some dynamics we can have a look at this longer oneliner: [grafik] And can break the idea down to smaller parts and/or decompose it to essential activities myRowJOs | List(Of JObjects) = myJObject("d")("results").Cast(of JObject).Select(Function (x) new JObject(x.Properties.Where(Function (p) Not p.Name.Equals("__metadata")))) we constructed new JObjcets where we removed the __metadata property (could be extended by a block list approach as well) then we convert it to a DataTable: d…

This post made by @Yoichi received 1 likes!

[Solved] UiPath to show timestamp in message box

HI, What format do you need? The simplest is just Now as the following. [image] Regards,

This post made by @vinitha_yachamaneni received 1 likes!

Unattended Robot doesn't work in a different location

Hi @Carla_Munoz If your Unattended Robot is not running when your laptop is outside your home location, it’s likely because the Orchestrator is unable to connect to your laptop due to network or firewall restrictions Also Ensure that your laptop has a consistent way to be reached from Orchestrator, even when it’s outside your home network. This can be done by setting up a static IP address or configuring dynamic DNS (DDNS) if your laptop’s IP address changes when you move

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Convert HTTP Response with nested JSON to DataTable

For some dynamics we can have a look at this longer oneliner: [grafik] And can break the idea down to smaller parts and/or decompose it to essential activities myRowJOs | List(Of JObjects) = myJObject("d")("results").Cast(of JObject).Select(Function (x) new JObject(x.Properties.Where(Function (p) Not p.Name.Equals("__metadata")))) we constructed new JObjcets where we removed the __metadata property (could be extended by a block list approach as well) then we convert it to a DataTable: d…

This solution provided by @Yoichi received 1 likes!

変数に1000を掛けたい

こんにちは 変数の型をそろえる必要があるかと思います。基本的には以下の様になります。 [image] 変数A(Int型)で取得した値12.000 整数型は小数点以下を扱えませんので、代入は12になるかと思います。 エラー内容：Option Strict On で ‘String’ から ‘Double’ への暗黙の型変換はできません 型があっていないと思います。変数BがString型ではないでしょうか？ その場合、(変数A*1000).ToString の様にする必要があります。

This solution provided by @Yoichi received 1 likes!

Need to extract data from textfile

HI, How about the following expression? This extract numeric characters which exists at the end of the next line of “PO NUMBER” (Because I guess it’s PO NUMBER) [image] System.Text.RegularExpressions.Regex.Match(strData,"(?<=PO NUMBER[\s\S]+?)\d+(?=\r?\n|$)").Value Sample20230907-3L.zip (14.4 KB) Regards,

---

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

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

[system]

Daily Forum Report | 08 September 2023

Top 3 Topics with Most Views

Manipulate string in datatable column made by @wwls with 42 views.

Remove "=" from a row made by @Kunal_Jain with 41 views.

[REFramework] Initialization sequence workflow made by @Tri_Vu with 41 views.

Top 3 Topics with Most Replies

Pulling array item from queue made by @E.T.S with 20 replies.

Replace specific values(Nà) of all columns of datatable - Reopen made by @rishiathawale with 16 replies.

Reading from data table issue made by @E.T.S with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 54 posts!

@Palaniyappan made 25 posts!

@postwick made 24 posts!

Top 3 Most Liked Posts

This post made by @Kartheek_Battu received 3 likes!

Need to modify the string

Hello @shruthi_arali Take “Assign” activity. In the “To” field of the “Assign” activity, create a variable to store the converted value. Let’s call it “convertedValue” and set its data type to Integer. In the “Value” field of the “Assign” activity, OriginalValue As String = “17,039.66” ConvertedValue As Integer = Integer.Parse(originalValue.Replace(“,”, “”).Replace(“.”, “”)) Thanks & Cheers!!!

This post made by @Shiva_Nikhil received 2 likes!

Lesson content different from installed Studio content

@Jon_Smith I know that if you update the studio the default dependecies will also upgraded If you want you can downgrade the dependecies as per your requirement you can downgrade Cheers

This post made by @mpraveen1902 received 2 likes!

Need to modify the string

HI @shruthi_arali str_Variable=System.Text.RegularExpressions.Regex.Replace(“(17,039.66)”,“[(),.]”,“”) You can try with regex also [image]

Top 3 Most Liked Solutions

This solution provided by @mpraveen1902 received 2 likes!

Need to modify the string

HI @shruthi_arali str_Variable=System.Text.RegularExpressions.Regex.Replace(“(17,039.66)”,“[(),.]”,“”) You can try with regex also [image]

This solution provided by @Parvathy received 1 likes!

Read Range: Exception has been thrown by the target of an invocation

Hi @arthurang So, you are reading the data written from Write Range activity using Read Range activity right. You need to use another Use Excel File and from that you can read the data using Read Range. Regards

This solution provided by @Shiva_Nikhil received 1 likes!

Lesson content different from installed Studio content

@Gordon_Freeman hi welcome to the community the lesson which we are created based on the older version of UiPath you are using the update version of studio like 2023.6.0 or 2023.8.0,check below image you can view your version of studio [image] so in that there will no option of selecting the type of argument 2.in the new feature the type of argument will be automatically created based on your value like example below i have created the output for get outlook mail messages activity out…

---

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

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

[system]

Daily Forum Report | 09 September 2023

Top 3 Topics with Most Views

DataRow Item Array Convert into Datatable made by @Shyam_Pragash with 38 views.

Error Downloading Monthly Report from Microsoft Edge - REF Assignment made by @Vishnu_Vardhan_Addagada with 31 views.

Error in variable when placed as integer in scope made by @Smit_Jain with 31 views.

Top 3 Topics with Most Replies

Error in variable when placed as integer in scope made by @Smit_Jain with 18 replies.

Unable to Copy the color of filter cells made by @Cuberoot with 13 replies.

How to Delete the folder which has yesterday's date in lt made by @Girid with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 17 posts!

@Nitya1 made 17 posts!

@Smit_Jain made 11 posts!

Top 3 Most Liked Posts

This post made by @Cuberoot received 2 likes!

Unable to Copy the color of filter cells

input file is in Sheet1 and output file is in Sheet2. Thanks

This post made by @Shiva_Nikhil received 2 likes!

Have created an automation to add data row to data table but showing some error,thanks for any help

@Sai_Kumar_111 Hi [image] [image] [image] cheers

This post made by @Anil_G received 1 likes!

Error Downloading Monthly Report from Microsoft Edge - REF Assignment

@Vishnu_Vardhan_Addagada Are you not able to indicate? If so did you happen to try changing the mode to active accessibility and try? Ideally you should get some selector like below <wnd app=‘msedge.exe’ cls=‘Chrome_WidgetWin_1’ title=‘* Microsoft​ Edge’ /> <ctrl name='Save As' role=‘push button’ /> Cheers

Top 3 Most Liked Solutions

This solution provided by @Shiva_Nikhil received 2 likes!

Have created an automation to add data row to data table but showing some error,thanks for any help

@Sai_Kumar_111 Hi [image] [image] [image] cheers

This solution provided by @Anil_G received 1 likes!

Error Downloading Monthly Report from Microsoft Edge - REF Assignment

@Vishnu_Vardhan_Addagada Are you not able to indicate? If so did you happen to try changing the mode to active accessibility and try? Ideally you should get some selector like below <wnd app=‘msedge.exe’ cls=‘Chrome_WidgetWin_1’ title=‘* Microsoft​ Edge’ /> <ctrl name='Save As' role=‘push button’ /> Cheers

This solution provided by @Vikas_M received 1 likes!

How to Delete the folder which has yesterday's date in lt

@Girid , Please refer below file BlankProcess.zip (8.5 KB) Hope it helps you!

---

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

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

[system]

Daily Forum Report | 10 September 2023

Top 3 Topics with Most Views

Regex and Delay not working made by @Ritaman_Baral with 38 views.

I get this error “Excel Application Scope” after I clicked “Run”? made by @Sara_Piana with 36 views.

Build your first automation studio made by @Vincent_Shoshin with 31 views.

Top 3 Topics with Most Replies

I get this error “Excel Application Scope” after I clicked “Run”? made by @Sara_Piana with 15 replies.

Regex and Delay not working made by @Ritaman_Baral with 12 replies.

About extraction of invoice details using document understanding made by @Nithin_Thatikonda with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 23 posts!

@Sara_Piana made 13 posts!

@Palaniyappan made 12 posts!

Top 3 Most Liked Posts

This post made by @Shubham_Varshney received 1 likes!

Wipro - UiPath Test Suite - Across Country - India - Full Time

Job title: UiPath Test Suite Job role: RPA Developer Country: India City: Across Country Company name: Wipro Employment Type: Full Time Seniority level: Associate 3 to 5 years Job Description: Looking for 2-8 years of person with Experience in UiPath Test Suite. Preference to short notice period Candidates Apply here: shubham2712@gmail.com

This post made by @lrtetala received 1 likes!

I get this error “Excel Application Scope” after I clicked “Run”?

Hi @Sara_Piana Please check on this thread it might be helps you

This post made by @Yoichi received 1 likes!

How to debug error using wildcard?

Hi, Can you try to replace unfixed string with asterisk in SendHotKey activity as same as AttachWindow? name='*File_*.txt - Notepad' [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to debug error using wildcard?

Hi, Can you try to replace unfixed string with asterisk in SendHotKey activity as same as AttachWindow? name='*File_*.txt - Notepad' [image] Regards,

This solution provided by @Palaniyappan received 1 likes!

Hi, I have some big values to save and process like -10,00,00,00,30,29,601 (+ve as well as -Ve) and -118.1966670 (with high decimal precision) which data type I should use to process such data?

Hi For large values, you should use the Int64 data type. The Int64 data type can store values up to 9,223,372,036,854,775,807. This is more than enough to store the values you mentioned. For values with high decimal precision, you should use the Double data type. The Double data type can store values up to 15 decimal places. This is enough to store the value -118.1966670. If you are not sure which data type to use, you can always use the String data type. The String data type can store any ty…

This solution provided by @Anil_G received 1 likes!

Creating an automation for some process and getting error while assigning to variables

@Sai_Kumar_111 Ideally it would work…i hope this is inside for each row in datatable activity…sometimes the columns are casted as objects…and at that time we need to add .ToString Hope this helps 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 | 11 September 2023

Top 3 Topics with Most Views

Apps - Attended Real time Communication made by @Venkata_Rajendran with 176 views.

How to combine 2 rows(with header) into a single row header? made by @angush.st with 66 views.

How to Split the Rows in a Data Table into multiple Data Tables? made by @Vishnu_Vardhan_Addagada with 51 views.

Top 3 Topics with Most Replies

Write Cell Workbook not allowing me to update Excel without closing it first made by @Ampra with 25 replies.

I want to take first row data column 3 to column 12 other all below data will be delete which has duplicate ID and Duplicate Address value made by @Garyy with 14 replies.

How to Run SAP scripting made by @Learner007 with 13 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 43 posts!

@Nguyen_Van_Luong1 made 23 posts!

@postwick made 22 posts!

Top 3 Most Liked Posts

This post made by @Venkata_Rajendran received 11 likes!

Apps - Attended Real time Communication

We are very excited to release our latest feature of Apps- Attended Robot real-time communication. This capability allows you to communicate between Apps and attended robots in real time. With this feature, we will be solving the performance issue of starting a new process every time, there is a need to communicate between Apps and Attended robots. Using this capability, an App can start a process and communicate with the process any number of times by invoking various XAMLs in the process. Th…

This post made by @Ampra received 2 likes!

Write Cell Workbook not allowing me to update Excel without closing it first

I was able to apply the fix!! I can now write to the file I wanted I just want to say- I am terribly sorry for how drawn-out this became. I am trying to follow along in the UiPath course but the version in the videos are outdated and different from mine. It is making this process of learning very difficult, but your support has been the only thing keeping me going. Thank you so very much for your patience and advice with help. You are truly rockstars <3 @Parvathy @Palaniyappan -Ampr…

This post made by @neha.upase received 2 likes!

How to get count of empty columns in the excel

Hi, Try this emptyRowCount = YourDataTable.AsEnumerable().Where(Function(row) Not String.IsNullOrEmpty(row.Field(Of String)(“ColumnA”)) AndAlso String.IsNullOrEmpty(row.Field(Of String)(“ColumnC”))).Count()

Top 3 Most Liked Solutions

This solution provided by @Jeroen_van_Loon received 1 likes!

Outlook shared mailbox synchronization takes too long

Common problem indeed. A few tips I’ve used in the past in different environments: you can leave outlook open if your VDI’s are persisten validate the status bar, and look for something like ‘all folders up to date’ and wait for that dynamically when opening outlook. When you use your get mail messages activities, be sure that it is set up to get enough messages. Know that if you use filters in this activity, the filters are applied ‘after’ getting the messages. Example: your mailbox contain…

This solution provided by @Nguyen_Van_Luong1 received 1 likes!

How to Split the Rows in a Data Table into multiple Data Tables?

Hi, @Vishnu_Vardhan_Addagada my code Main.xaml (21.9 KB) my input Test.xlsx (9.9 KB) my output in csv output.zip (1.3 KB) full path Split Data.zip (24.5 KB) regards,

This solution provided by @Palaniyappan received 1 likes!

How to copy a text from a textbox and paste it to another textbox using UiPath StudioX?

Hi Welcome to UiPath forum hope the below steps would help you resolve this use GET ATTRIBUTE activity to get the text VALUE of an attribute https://docs.uipath.com/activities/other/latest/ui-automation/get-attribute#:~:text=Retrieves%20the%20value%20of%20a,the%20aastate%20attribute%2C%20for%20example. then use TYPE INTO ACTIVITY and indicate the field where you want to paste it along with the value obtained from above activity mention the variable and then press PLUS button to include…

---

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

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

[system]

Daily Forum Report | 12 September 2023

Top 3 Topics with Most Views

Creating a Workday connection in Integration Service made by @Samrat_Dutta with 69 views.

How to update the status made by @anjani_priya with 46 views.

How to Install Teams Packages made by @wsinten with 43 views.

Top 3 Topics with Most Replies

How to update the status made by @anjani_priya with 12 replies.

How to Install Teams Packages made by @wsinten with 11 replies.

Forms made by @Rohit_Nandwani with 10 replies.

Top 3 Users Who Posted The Most

@Nguyen_Van_Luong1 made 56 posts!

@Palaniyappan made 33 posts!

@postwick made 30 posts!

Top 3 Most Liked Posts

This post made by @Samrat_Dutta received 2 likes!

Creating a Workday connection in Integration Service

Step One: Create an Integration System User (ISU) In your Workday portal, log into the Workday tenant. In the Search field, type Create Integration System User. Select the Create Integration System User task. [image] On the Create Integration System User page, in the Account Information section, enter a user name, and enter and confirm a password. Click OK. [image] Note: due to xml encoding, “&”, “<”, and “>” cannot be included in the password. Note: Make sure Require New P…

This post made by @Palaniyappan received 2 likes!

UiPath Spotlight Directory: Amplify Your Presence

This is fantastic

This post made by @ppr received 1 likes!

Extract the specific value from the JSON object

in Addition to above: [grafik] output - myJObject | DataType: JObject [grafik] Kindly note: the property keys are case sensitive when using it

Top 3 Most Liked Solutions

This solution provided by @Nguyen_Van_Luong1 received 1 likes!

Update Datatable column name when it contain certain word?

Hi @winnie_toh , You can use if check contains then assign yourDT.Columns(index).ColumnName = “New Column Name” can you share your file and conditions regards,

This solution provided by @Yoichi received 1 likes!

Data table filter wizard unable to filter column name that contain line breaks

Hi, How about the following? [image] "Sep TTL"+vblf+"Allo" OR "Sep TTL"+vbcrlf+"Allo" Sample workflow Sample20230912-1L.zip (8.3 KB) Regards,

This solution provided by @Nguyen_Van_Luong1 received 1 likes!

Tooltip in Argument Panel

Hi @irahmat , You can right click to argument then select design properties [image] [image] [image] [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.