Forum Engagement Daily Reports

[system]

Daily Forum Report | 09 April 2021

Top 3 Topics with Most Views

Fill missing data in excel - Replace "?" made by @Yudhisteer_Chintaram with 28 views.

How to Convert time to text string in excel? made by @Welcoming with 27 views.

Connection with UiPath Excel-Add-In keeps failing made by @anotherulrich with 27 views.

Top 3 Topics with Most Replies

How to split the equation(string type),if A1-A2 then var1=A1, var2=- , var3=A2 made by @eimon with 20 replies.

Question on Number type made by @Prinal_C with 12 replies.

https://forum.uipath.com/t/305355 made by @SIM_JUN_HUI_BERTRAM_CSOD with 12 replies.

Top 3 Users Who Posted The Most

@prasath_S made 37 posts!

@Hiba_B made 24 posts!

@prasath17 made 16 posts!

Top 3 Most Liked Posts

This post made by @Hiba_B received 2 likes!

Data extraction from text to excel

Hi @sayali_rokade ! A way is to use regex, @prasath17 masters it: would you mind helping us ?

This post made by @sangL received 2 likes!

How pass datatable as checkbox or selectboxes in Form.Activities

Hi @lojyehuang - thanks for the inquiry. We will check this internally to see if we can resolve and follow up with you. Thanks.

This post made by @Eric_Wong_Test received 2 likes!

How to split the equation(string type),if A1-A2 then var1=A1, var2=- , var3=A2

You can use this [image]

Top 3 Most Liked Solutions

This solution provided by @wood.raymond79 received 2 likes!

Activities Pane Remains above Main Window

Problem solved. I was able to resize the pane by dragging it out from the side. It popped out of the centre and I was able to move it back to its home.

This solution provided by @prasath_S received 1 likes!

Delete text in SAP

Hi @Markus3003 Use type into activity and set empty field propery ticked, it will clear the text field and type whatever text you given in the input field of the activity. In properties panel of type into activity, [image]

This solution provided by @Eric_Wong_Test received 1 likes!

How to split the equation(string type),if A1-A2 then var1=A1, var2=- , var3=A2

match.xaml (6.0 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 | 10 April 2021

Top 3 Topics with Most Views

Take screenshot and Send mail made by @mtalha.shafiq with 26 views.

Sign-in error in UiPath Studio made by @daniel.popescu1985 with 25 views.

Structure of Loops - 2.0 with Queues made by @Yudhisteer_Chintaram1 with 22 views.

Top 3 Topics with Most Replies

Sign-in error in UiPath Studio made by @daniel.popescu1985 with 9 replies.

Take screenshot and Send mail made by @mtalha.shafiq with 9 replies.

Close specific excel without all excel documents closed made by @ting801215 with 7 replies.

Top 3 Users Who Posted The Most

@afe.araromi made 10 posts!

@prasath17 made 7 posts!

@JayakumarSanthanam made 4 posts!

Top 3 Most Liked Posts

This post made by @phee_beng_ying received 2 likes!

Milestone 1 - Build your first Automation

Sending quarterly reminders to colleagues to update their documents. Attaching the correct documents to the correct group of colleagues for their review and amendment. Sending monthly user verification reports.

This post made by @prasath17 received 1 likes!

How to store particular array elements of an array into another array

@rahulsharma - please take a look here…

This post made by @rahulsharma received 1 likes!

How to store particular array elements of an array into another array

Thanks @prasath17 that was helpful.

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 | 11 April 2021

Top 3 Topics with Most Views

Split Text of character made by @Poorani_Ramachandran with 20 views.

Excel: How do you calculate sum dynamica made by @Prinal_C with 19 views.

Linq Query to Filter Datatable column as same date with 2 hrs time.? Pls made by @Aravinthan with 18 views.

Top 3 Topics with Most Replies

データテーブルの項目キー毎の件数を取得後、希望順に並べ替えたい made by @miwa_yamamoto with 11 replies.

Update Status in Excel made by @Yudhisteer_Chintaram1 with 10 replies.

How to create a .zip file made by @Bobae_Lee with 9 replies.

Top 3 Users Who Posted The Most

@prasath_S made 25 posts!

@Tamilselvan made 16 posts!

@prasath17 made 12 posts!

Top 3 Most Liked Posts

This post made by @daniel.popescu1985 received 3 likes!

Sign-in error in UiPath Studio

I marked that post as the solution, but I don’t find the checkbox for Solved.

This post made by @pranam.gangadhar received 3 likes!

Milestone 4 - Tools for Building Automation

I used Write Text File actions. It directly saves the password from clipboard and saves the .txt file in a prescribed folder with a file name of your choice.

This post made by @StefanSchnell received 1 likes!

Code Generator for the Invoke Code Activity to use SAP RFC Function Modules Easily

After the global event about SAP API Automation with the help of UiPath I had a lot of discussions about the most common API use case in relation with SAP. It seems to be reading data from tables. Therefore I decided to extend the RFM Code Generator to support this possibility in a simple way. The current release of the RFM Code Generator contains the possibility to generate code for the RFM RFC_READ_TABLE. In the tab ReadTable it is possible to select an SAP transparent table or an SAP view to…

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 1 likes!

Regex to fetch specific items from string

Hi @DewanjeeS - Please try like this… [image]

This solution provided by @prasath_S received 1 likes!

Close specific excel without all excel documents closed

I have tested the workflow and and its closing only the workbook we needed to close, [image] [image] [image] It you cant find the input for close workbook activty then you dont have to create a variable and assign it.

This solution provided by @Yoichi received 1 likes!

データテーブルの項目キー毎の件数を取得後、希望順に並べ替えたい

こんにちは 以下トピックが参考になると思います。

---

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

Top 3 Topics with Most Views

Add header in DT made by @Jesmine with 35 views.

Is studio have a robot? made by @halis with 32 views.

How to view specific folders in a directory made by @Serik_Tashenov with 30 views.

Top 3 Topics with Most Replies

How to view specific folders in a directory made by @Serik_Tashenov with 22 replies.

Is there any idea to append column in excel? made by @Ganesh_S1 with 19 replies.

Add header in DT made by @Jesmine with 13 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 26 posts!

@prasath_S made 24 posts!

@Hiba_B made 20 posts!

Top 3 Most Liked Posts

This post made by @andres.perez received 3 likes!

Milestone 1 - Working with Decisions, Iterations and Scenarios

Hey! It seems the link to download the zip which contains the material for this practice is wrong. [image] You can copy them from the solution though! Have a nice week!

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

Announcing the 2021 UiPath MVPs!

Congratulations to all.

This post made by @Zoul_BZ received 2 likes!

Milestone 1 - Working with Decisions, Iterations and Scenarios

Hi! Echoing andres, the zip file is the same as Week 1 practice.

Top 3 Most Liked Solutions

This solution provided by @anotherulrich received 2 likes!

Connection with UiPath Excel-Add-In keeps failing

I followed this: Excel Plugin Not Getting Installed - #3 by AndrewHall and this solved the issue. Nothing to do with Admin rights… Regards, Ulrich

This solution provided by @NIVED_NAMBIAR received 1 likes!

Remove particular Data columns by using Wildcards

Hi @he.cao u can try this way Read the excel file and store in dt1 now use below assign activity to get only column name starting with Column- data_array = (From dc In dt.Columns.Cast(Of DataColumn) Where dc.ColumnName.StartsWith(“Column-”) Select dc.ColumnName).ToArray() Now use for each loop to loop through each element in data_array [ datatype of data_array is String ] Iniside the loop use Remove Data Column Activity to remove the column from the datacolumn by specifying the name of c…

This solution provided by @Yoichi received 1 likes!

How to read string regardless of Uppercase, Lowercase or mixed using Regex

Hi, Can you try System.Text.RegularExpressions.RegexOptions.IgnoreCase option as the following? System.Text.RegularExpressions.Regex.Match(strVar,"(?<=(Person Address)).*",System.Text.RegularExpressions.RegexOptions.IgnoreCase).Value 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 | 13 April 2021

Top 3 Topics with Most Views

How to convert String to Integer made by @Z_Z with 27 views.

REplacing Values in a column of datatable made by @Username95 with 25 views.

How to add or concatenate double quotes with String Variables? made by @wdescalsota with 25 views.

Top 3 Topics with Most Replies

How to add or concatenate double quotes with String Variables? made by @wdescalsota with 26 replies.

EXCEL Write Cell / Auto Fill made by @CoolRobot with 14 replies.

Error: Input Dialog: TypeConverter cannot convert from System.String made by @Yu_Winni with 10 replies.

Top 3 Users Who Posted The Most

@prasath_S made 39 posts!

@Pravin_Patil1 made 35 posts!

@prasath17 made 17 posts!

Top 3 Most Liked Posts

This post made by @Alison_Evans received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi all, I am an entrepreneurial accountant in New Zealand, working alongside a large number of business managers to improve business and accounting systems. I believe that RPA is the next tool for me to learn, and I am very much at the beginning, but have a background in database management which helps a lot. I want to first understand it for my own business, but then be able to offer it as a setup service to clients. I love learning it, and wish I had more time to devote to it, but ultimately …

This post made by @SushilSharma received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, my name is Sushil. I am based in Noida, India. I manage IT-Infra team for Cyient Noida (India) location. I am here to see the capability of StudioX and learn to utilize it to increase my and my team’s productivity in day to day routine tasks.

This post made by @veaceslav_costetchi received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello to everyone! I’m new to UiPath, looking to learn new skills here.

Top 3 Most Liked Solutions

This solution provided by @prasath_S received 2 likes!

Another reason why Filter datatable activity in my logic always return zero

Hi @eimon I think it should be a number type in excel please use convert.toint32(variable1.tostring.trim) in filter datatable Or cint(variable1.tostring.trim) Or give variable1 datatype as integer in UiPath and just past the value in the filter datatable

This solution provided by @Hiba_B received 1 likes!

TYPE="DATE" problem!

Ok indeed I just tried it with the activity that you have (from the modern experience bucket), it does not work. I don’t know why and how you could use this activity to make it work, but I suggest you to do the following: go to activities, then filter, then check the Show Classic tool [image] Once you’ve done it, you can drag and drop the type into version that I have: [image] That way you have the following sequence at the end: [image]

This solution provided by @HANACCHI received 1 likes!

データテーブルをマージできない

データテーブルのマージは、ソースに指定したDataTableを、保存先に指定したDataTableにマージします。 例えば、DataTableとして指定した変数が実は引数にも指定されていたとか、EXCELで読み取ったDataTableが実は空であったとか。。。

---

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

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

[system]

Daily Forum Report | 14 April 2021

Top 3 Topics with Most Views

Unzip File from Download Folder made by @Elena_Scha with 109 views.

I need to extract the data from the image made by @copy_writes with 81 views.

データテーブルから条件指定の値を取得したい made by @miwa_yamamoto with 67 views.

Top 3 Topics with Most Replies

In ServiceNow, i need to proceed based on short description made by @Swetha_V with 21 replies.

Split one excel into 2 with a condition and write cell after cell made by @Dragonici_Victor with 20 replies.

データテーブルから条件指定の値を取得したい made by @miwa_yamamoto with 19 replies.

Top 3 Users Who Posted The Most

@Pravin_Patil1 made 38 posts!

@Srini84 made 32 posts!

@prasath_S made 26 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

Last 5 days of current month

it looks like you are interested in a series/Collection of the last 5 days fro current month (so e.g. in Feb: 24,25,26,27,28) Variables: [grafik] Assign: [grafik] Enumerable.Range(-4,5).Select(Function (x) LastMonthDate.AddDays(x)).toList Result: [grafik]

This post made by @CosminV received 2 likes!

UiPathOrchestrator_Log File (.ldf) is getting larger

Maintaining the transaction log file is usually the job of a DBA, so make sure you get the help of one if it’s a production system. If it’s not, here’s an article with what you can do to reduce its size: SQL Server Transaction Log Backup, Truncate and Shrink Operations

This post made by @VB_Tech_pro received 2 likes!

How to give a excel cell value as input range to split pdf as range

Hi @prasath17 Now Iam able split pages adding some sequence of balareva.pdfspliter to FindPDFPageNo.zip . I will provide the size comparison screenshoots

Top 3 Most Liked Solutions

This solution provided by @ppr received 3 likes!

Last 5 days of current month

it looks like you are interested in a series/Collection of the last 5 days fro current month (so e.g. in Feb: 24,25,26,27,28) Variables: [grafik] Assign: [grafik] Enumerable.Range(-4,5).Select(Function (x) LastMonthDate.AddDays(x)).toList Result: [grafik]

This solution provided by @Camille361 received 1 likes!

Improve a process' speed

@ppr @Hiba_B Thank you very much for your help ! I actually found something else to make my process faster. In fact my process was just a sequence of clicks et types on a website so it already was not that long but I wanted to make it even more faster ! And this morning I found an option “SimulateClick” and “SimulateType” that makes it much more faster. Thank you once again ! @Hiba_B Ravie de rejoindre la communauté ! A bientôt peut être pour mes futures questions ! …

This solution provided by @Pravin_Patil1 received 1 likes!

I get error in regex in pattern panel (Error ERROR Validation Error Compiler error(s) encountered processing expression ""(?<=ocr_text":")(\d+\.\d+).*(?="}])"". End of expression expected. Image Extraction.xaml)

@copy_writes Try like below "(?<=ocr_text"+"""+:+"""+")\d+.\d+"

---

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

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

[system]

Daily Forum Report | 15 April 2021

Top 3 Topics with Most Views

How extract only last index data from the excel made by @copy_writes with 30 views.

整数または自然数の取得について made by @pthfs1 with 29 views.

Unknown space in text made by @Username95 with 28 views.

Top 3 Topics with Most Replies

Time out reached for unattended bot made by @Naveed_Hakim1 with 21 replies.

Invoke code returns error made by @ranjani with 13 replies.

Unusal double quote made by @Radap with 12 replies.

Top 3 Users Who Posted The Most

@Pravin_Patil1 made 30 posts!

@Srini84 made 21 posts!

@postwick made 20 posts!

Top 3 Most Liked Posts

This post made by @teresa received 2 likes!

Take the survey: The State of the RPA Developer 2021

Sorry! We had so many questions for you guys!

This post made by @seanrockvz13 received 2 likes!

Studio Type Bot triggered from orchestrator?

Hi @loginerror, looping you in.

This post made by @prasath_S received 2 likes!

How to create new excel file every day uniquely

Hi @chaithanya_kumar_M Use write range activity and in file path give as “Yourpath\Filename_Prefix” + now.tostring(“ddMMyyyy hhmm”) + “.xlsx” it will craete a new file with creent datetime.

Top 3 Most Liked Solutions

This solution provided by @prasath_S received 2 likes!

How to create new excel file every day uniquely

Hi @chaithanya_kumar_M Use write range activity and in file path give as “Yourpath\Filename_Prefix” + now.tostring(“ddMMyyyy hhmm”) + “.xlsx” it will craete a new file with creent datetime.

This solution provided by @Dragos_Bobolea received 1 likes!

Question about Computer Vision

Hi, yes, that’s one of the biggest advantages of CV over find image. As long as the anchor-target pairs don’t change relative positions, it will work just fine

This solution provided by @prasath17 received 1 likes!

A value between

@Gabriel_Wisniewski - As an Alternate… [image] (?<=ICMS\s+\S+\s+)[\d.,]+ Note: I have also included . in my pattern and this can grab any values…you can test it…

---

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

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

[system]

Daily Forum Report | 16 April 2021

Top 3 Topics with Most Views

📢 HyperHack - Automation for Good challenge! made by @Vibhor.Shrivastava with 104 views.

Our new look for Orchestrator is here! made by @Alexandra_Gurita with 41 views.

Schedule is not working from Orchestrator made by @Ziarul_Haque with 35 views.

Top 3 Topics with Most Replies

How to add Saved Value to file name made by @jessica.matthess with 17 replies.

Scheduled Jobs not running on time - delayed for about 45 mins made by @rpa_automation with 11 replies.

File: Conversion from string to double made by @AhmedKutraphali with 10 replies.

Top 3 Users Who Posted The Most

@Pravin_Patil1 made 16 posts!

@prasath17 made 12 posts!

@AhmedKutraphali made 12 posts!

Top 3 Most Liked Posts

This post made by @Vibhor.Shrivastava received 13 likes!

HyperHack - Automation for Good challenge!

[LinkedIn_Twitter_hyperhack21_1200x627_1] Join the #AutomationForGood challenge! Every year we turn our attention, our skills, and resources to the world around us, we listen, and we relentlessly try to explore the societal impact of automation. This year, we invite you, the global UiPath community, to join forces with us for the #automationforgood Hackathon. It’s time for all of us to connect to the world outside our daily tasks. It’s time to dive into our local communities, find and solve t…

This post made by @Alexandra_Gurita received 13 likes!

Our new look for Orchestrator is here!

Introducing Apollo design system Over the past couple of years, we’ve seen the number of products from UiPath grow from 3 to over 20! With this rapid growth, we realized that our customers would benefit from a design system to keep our experiences simple to use and easier to develop. The Apollo design system is a collection of objects (controls in many cases) that allow us to provide UiPath customers with the best possible experience across all of our products. Guided by clear standards, we as…

This post made by @Hiba_B received 3 likes!

HyperHack - Automation for Good challenge!

That’s greaaaaaat !! Are some french people interested ? Don’t mind to do it alone, but the more merrier

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

Click activity - How to read asterisk *?

Hi, Can you try regex selector as the following? <webctrl aaname='Consumer Max-500-2\.5-2\.5\*' matching:aaname='regex' /> Regards,

This solution provided by @Yoichi received 2 likes!

Regex not accepted by UiPath

Hi, Can you try the following pattern? [\d*.\d*,\d*]+(?=\r?\n\r?\nVALOR LIQUIDO DA NOTA) Regards,

This solution provided by @Tamilselvan received 2 likes!

How to Pass a Variable in the Label of UiPath Forms?

@Haroon_Patel Form Dynamic Labels for Textfield.zip (43.1 KB) Please find the sample workflow for dynamic labels in textfield. Regarding your above query, you dont necessarily add “redrawOn” at line #7. you can add it at the end of the json. in your example, you can add it after line #10. Please try the attached workflow and let us know. 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 | 17 April 2021

Top 3 Topics with Most Views

PDF Data extraction for clientid made by @sayali_rokade with 26 views.

How to Split the string after '-' made by @Rahul_Jawahirani with 25 views.

How can I fill these PDF made by @oscar.cuevas.jimenez with 24 views.

Top 3 Topics with Most Replies

User License Management and Unattended robots in 21.4 made by @JithinKP with 7 replies.

How to create mulitipication on 2*1=2 while using do while in UiPath made by @Ashrof_ali with 7 replies.

How to Split the string after '-' made by @Rahul_Jawahirani with 5 replies.

Top 3 Users Who Posted The Most

@airwaveexporter made 8 posts!

@AKM_Robinuzzaman made 8 posts!

@vignesh.ks made 7 posts!

Top 3 Most Liked Posts

This post made by @prasath_S received 3 likes!

Click Input returns multiple results

Hi @mpathan If the output of get text is strText Use if activity and in condition give strText.tostring.trim.toupper = “NO RECORDS FOUND” In else do your logic

This post made by @NIVED_NAMBIAR received 3 likes!

Click Input returns multiple results

In addition to what @prasath_S has said, you can try with element exists to check whether the element No records Found is there or not. based on boolean value you can extend your logic on it. Regards, Nived N Happy Automation

This post made by @jenyshirly received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hai… hello all…Myself Jeny…I am working with RPA automation for the past two years…I am really interested on how this automation works and makes things around us…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Tesseract OCR 日本語対応できない問題

こんにちは CE最新版ではどうやら以下にtessdataフォルダを作成しなければならないような感じです。 一度お試しください。 C:\Users\[ユーザー名]\AppData\Local\UiPath\app-xx.xx.xx\net461

This solution provided by @Zing received 1 likes!

Draft email does not show up in Outlook's Outbox

Hello @ovidiuponoran, thanks for following up! I have uninstalled and re-installed the outlook desktop application, and re-installed the chrome and excel add-ins for uipath, and it is working as intended. Not sure what was wrong before, but so happy that its working!

This solution provided by @vignesh.ks received 1 likes!

Copie, paste data Excel

Hi @E.E You can use “Remove DataRow” activity before “append range” activity. In “Remove DataRow” activity properties provide the DataTable variable and RowIndex as ‘0’. So it will remove the header and append the rest of the data’s. Note: Uncheck ‘Add Headers’ in read range(DataTable which you need to append) activity properties. 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 | 18 April 2021

Top 3 Topics with Most Views

UIPath Enterprise Studio with Cloud Community issue made by @Mohammed_Shehata with 30 views.

Find row value with specific made by @Prinal_C with 26 views.

Preprocess Excel Column made by @Yudhisteer_Chintaram1 with 22 views.

Top 3 Topics with Most Replies

UIPath Enterprise Studio with Cloud Community issue made by @Mohammed_Shehata with 9 replies.

Filter remove lenght made by @sedayngl_sedayngl33 with 8 replies.

Find row value with specific made by @Prinal_C with 6 replies.

Top 3 Users Who Posted The Most

@prasath_S made 9 posts!

@Mohammed_Shehata made 7 posts!

@AhmedKutraphali made 6 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Repeating the same character multiple times in a string

Hi, Another solution: new String("-"C,225) Regards,

This post made by @ppr received 2 likes!

Merging 3 excel files with non continuous records into 1 excel with continuous records

Looks Like an issue with the datatypes. Can you Check if the typeargument for the for each Activity ist Set to datatable

This post made by @cornelius.nowald received 1 likes!

Get Modern Folder FullyQualifiedName as Index in Log Target

Hi @rdgagp , I tried few more things to fetch the folder name (not just folder-ID) and directly apply to the index name, but I think without UiPath including the FQN as event property this will not work. I also created a very cumbersome workaround, but in comparison to this I think managing access to indices by mapping folder-IDs to users is going to be easier. I manually created a sperate target for each folder (paying attention to the ES index-naming-convention) [image] and a separate lo…

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 | 19 April 2021

Top 3 Topics with Most Views

Yoichi 1000th Solution Flag Celebration made by @ppr with 51 views.

Enter password without get credentials made by @Sakshi_Jain with 36 views.

32bit版端末でUiPathの動作確認・運用をしたい made by @I.S with 33 views.

Top 3 Topics with Most Replies

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

Extract data using regex made by @ashishmani with 16 replies.

Assign value from One datatable to another made by @MLT with 13 replies.

Top 3 Users Who Posted The Most

@prasath_S made 27 posts!

@ppr made 24 posts!

@Yoichi made 15 posts!

Top 3 Most Liked Posts

This post made by @ppr received 14 likes!

Yoichi 1000th Solution Flag Celebration

@Yoichi Congrats to your 1000th Solution Flag. Many thanks for your support to the community and the valuable help. Let’s celebrate this event with you and the community.

This post made by @Yoichi received 10 likes!

Yoichi 1000th Solution Flag Celebration

@ppr @prasath17 Thank you for your kind messages. I’m happy to be able to contribute even a little to this great community. Let’s continue to do our best. Best regards, Yoichi

This post made by @prasath17 received 6 likes!

Yoichi 1000th Solution Flag Celebration

Congrats @Yoichi … Let’s Celebrate I have bookmarked lot of your solutions and used in my various projects…thank you so much for your continued support…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

データテーブルのフィルター方法

こんにちは 複雑な条件の場合、フィルターデーターテーブルアクティビティでは実現が難しいと思います。 保持したいのであれば newDt = dt.AsEnumerable.Where(Function(r) r("Column1").ToString.StartsWith("t") AndAlso r("Column2").ToString.StartsWith("h") AndAlso System.Text.RegularExpressions.Regex.IsMatch(r("Column3").ToString,"^00\d99/..\d\d$")).CopyToDataTable 例は削除したいようなので、削除したいのであれば newDt = dt.AsEnumerable.Where(Function(r) not (r("Column1").ToString.StartsWith("t") AndAlso r("Column2").ToString.StartsWith("h") AndAlso System.Text.RegularExpressions.…

This solution provided by @prasath17 received 1 likes!

How to get value in mail body outlook

@LucastoH - If you are having same pattern in all the email, then you can use Regex and write the results in the datatable inside the for each … [image] Regex pattern Link. Hope this helps…

This solution provided by @cheez_RPA received 1 likes!

32bit版端末でUiPathの動作確認・運用をしたい

Windows 7 を利用して開発/実行したい場合、現状、エンタープライズ版のうち 2019.10 シリーズのみ利用可能です。2019.10 シリーズは 32 bit に対応していることが、ドキュメントに記載されております。 なお 2019.10 シリーズのサポート終了は 2022年11月 に予定されています。 ご存知のことと思いますが、Windows 7はサポートが終了しています（エンタープライズ向けに延長サポートを購入することは出来ますが）。UiPath以外のソフトウェアもサポートが終了しているか、または今後サポートを終了していくことが考えられますので、まずはWindows 7での運用環境を見直していただくのが良いかと思います。

---

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

Top 3 Topics with Most Views

I get the error in the App data, The UiPath Assistant is required to complete this action made by @copy_writes with 45 views.

Tip: How to Detect SAP Server Side Scripting Settings made by @StefanSchnell with 44 views.

UiPath Integrations Meetup Series made by @Vibhor.Shrivastava with 43 views.

Top 3 Topics with Most Replies

I get the error in the App data, The UiPath Assistant is required to complete this action made by @copy_writes with 23 replies.

Find digit made by @rsr with 17 replies.

Extraction from UI Element made by @Yudhisteer_Chintaram1 with 14 replies.

Top 3 Users Who Posted The Most

@prasath_S made 23 posts!

@Yoichi made 23 posts!

@copy_writes made 22 posts!

Top 3 Most Liked Posts

This post made by @Vibhor.Shrivastava received 6 likes!

UiPath Integrations Meetup Series

[UiPath-LinkedIn-20Apr21_Meetups_on_Integrations (1)] We are happy to announce the meetup series on UiPath Integrations Join these meetups to simplify process automation for industry-leading enterprise software with officially supported API Integrations from UiPath. Auto-deploy UiPath on AWS and Automate Critical AWS Operations 2021-05-13T12:00:00Z (UTC) → 2021-05-13T13:30:00Z (UTC) This session is for RPA developers and IT DevOps Engineers who want to levera…

This post made by @Yoichi received 4 likes!

Yoichi 1000th Solution Flag Celebration

Thanks @Yuki_Uzuki

This post made by @TonyNudd received 4 likes!

Is it possible to connect Uipath with IOT projects

Hi, Thanks for the plug @NIVED_NAMBIAR Typically IoT solutions need to handle Event-Driven data. The best way to do this is in production for example, is to connect UiPath Orchestrator to Node-RED … See the link below. I have also created some personal IoT projects with Arduino and Raspberry-PI … I used the UiPath Custom Activity Builder to attach robots to a Bluetooth connection… not recommended for mission critical but allows home IoT projects controlled by RPA to be created. The overview …

Top 3 Most Liked Solutions

This solution provided by @TonyNudd received 4 likes!

Is it possible to connect Uipath with IOT projects

Hi, Thanks for the plug @NIVED_NAMBIAR Typically IoT solutions need to handle Event-Driven data. The best way to do this is in production for example, is to connect UiPath Orchestrator to Node-RED … See the link below. I have also created some personal IoT projects with Arduino and Raspberry-PI … I used the UiPath Custom Activity Builder to attach robots to a Bluetooth connection… not recommended for mission critical but allows home IoT projects controlled by RPA to be created. The overview …

This solution provided by @Yoichi received 1 likes!

「image exists」がアクティビティの一覧にない

こんにちは モダンデザインになっているのではないでしょうか？ アクティビティパネルのフィルターを開いてクラシックを表示の欄があれば これをチェックしてみてください。 [img20210420-4] あるいはStudioXプロファイルになっている可能性もあるかもですが… （緑色ベースの画面ならこちらの可能性があります）

This solution provided by @cornelius.nowald received 1 likes!

Get Modern Folder FullyQualifiedName as Index in Log Target

Hi @rdgagp, I think I found a way which might work using some srcipts the query the Orchestrator API for the folder FQNs and sanitizes them using ES index aliases . Based on this folder structure [image] I create index aliases using the ES API (manually sanitizing the names for this test) PUT /default-1-33*/_alias/logtestfolder PUT /default-1-34*/_alias/logtestfolder_logtestfolderson PUT /default-1-35*/_alias/logtestfolder_logtestfolderson_logtestfoldergrandson then queried to check inf t…

---

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

Top 3 Topics with Most Views

How do i solve length cannot be less than zero? made by @SIM_JUN_HUI_BERTRAM_CSOD with 38 views.

Robot Master Badge Request made by @Bala_Ashokan with 36 views.

How to convert variable value into date made by @Reddy_1 with 35 views.

Top 3 Topics with Most Replies

EMERGENCY! I cannot get into any of my Orchestrator Tenants in the cloud. Help! made by @AndyMenon with 15 replies.

Click on Button Selector made by @Sahil_Garg1 with 15 replies.

Click Checkbox in a table based on dynamic values made by @tilarapiyush with 15 replies.

Top 3 Users Who Posted The Most

@prasath_S made 33 posts!

@ppr made 18 posts!

@Yoichi made 18 posts!

Top 3 Most Liked Posts

This post made by @apurba2samanta received 2 likes!

Our new look for Orchestrator is here!

Welcome to the UiPath community @Alexandra_Gurita! It’s great that UiPath modifies its products frequently and this version of Orchestrator looks very nice. Thanks & Regards, Apurba Samanta

This post made by @pthfs1 received 2 likes!

要素が配列の連想配列の初期化について

できました！ 調べても情報がなく途方に暮れてました。 誠にありがとうございます。

This post made by @Yoichi received 2 likes!

要素が配列の連想配列の初期化について

こんにちは 以下お試しください。 New Dictionary(Of String,String())

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

要素が配列の連想配列の初期化について

こんにちは 以下お試しください。 New Dictionary(Of String,String())

This solution provided by @flavius received 2 likes!

Error - Cannot Open Item

Seems a problem with the Nuget cache. Could you please try deleting the Packages folder in the %USERPROFILE%/.nuget folder? And, after this, try to create a new project in StudioX again? [image]

This solution provided by @vignesh.ks received 2 likes!

How to choose folder and file from date as string?

Hi @fairymemay For this scenario, do the below steps: Split the date with “/” and assign the arrayofstring to variable. Check whether the folder was exists. If yes, then just write the excel or else, create the folder with year and write the excel. Attached screen shot for your reference. [image] In WriteRange activity, give path like this: your2020FolderPath+"\"+splitingString(2)+"\Report "+splitingString(1)+"."+splitingString(2)+".xlsx" Feel free to reach us at any time if you have do…

---

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

Top 3 Topics with Most Views

Separate File path from File name made by @Latif with 42 views.

How to get the value for each row made by @Tharusha_Fernando with 36 views.

Datatableで特定の行の特定の値の取得方法 made by @zuka with 29 views.

Top 3 Topics with Most Replies

How to print output as a string made by @Sharma_Sania with 24 replies.

Separate File path from File name made by @Latif with 16 replies.

How to show a message with the total of lines and with a specific column that was extracted made by @Gabriel_Mascarenhas with 15 replies.

Top 3 Users Who Posted The Most

@prasath_S made 26 posts!

@ppr made 19 posts!

@Yoichi made 16 posts!

Top 3 Most Liked Posts

This post made by @ppr received 4 likes!

How to get the value for each row

@Tharusha_Fernando give a try on following prepare a result datatable e.g. dtResult = dtOrigVar.Clone Add a column Total to dtResult with add datacolumn activity use an assign activity: left side: dtResult right side: (From d in dtOrigVar.AsEnumerable Let t = {"car loan","housing loan","food", "transport"}.Sum(Function (x) Convert.ToInt32("0" & d(x).toString.Trim)) Let ra = d.ItemArray.Append(t).toArray Select dtResult.Rows.Add(ra)).CopyToDataTable

This post made by @Rohan_Goswami received 3 likes!

Do you tried the Ui path Forum Progressive Web App

Hey folks, Do you noticed that Ui path forum website has the option to download the website as a PWA. I noticed it today, this is a pretty cool feature try it if you haven’t. [1112]

This post made by @ppr received 2 likes!

How to divide a number and get results with decimals

find some basics: [grafik] [grafik] and give a try on: [grafik]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

配列をDatatableに格納したい

こんにちは おそらくオーソドックスなのは @Eric_Wong_Test さんが提示した方法になります。 ただし、この方法はBuildDataTableやReadRange等で事前にDataTableを構成しておかねばなりません。 一方Generate DataTableを使った方法は上記の制限がありますので、これらご注意ください。

This solution provided by @ppr received 1 likes!

How to get the value for each row

lets assume you want to sum up all columns: Let t = d.ItemArray.Sum(Function (x) Convert.ToInt32(“0” & x.toString.Trim)) Lets assume you want to sum up not all columns but all with the name 1,2,3…30 Let t = Enumerable.Range(1,30).Sum(Function (x) Convert.ToInt32("0" & d(x.toString).toString.Trim))

This solution provided by @raheelferoze received 1 likes!

Data Manager not opening

Hi @Pablito it sounds weird but the Data manager was working on Incognito but not on browser. and yes I cleared the cookies and it worked fine in normal browser

---

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

Top 3 Topics with Most Views

Csvのテーブルから別のテーブルに行追加したい made by @zuka with 73 views.

Get spesific row item made by @Aditya_Nugroho with 62 views.

Data to the last row in excel but not the last row made by @CoolRobot with 51 views.

Top 3 Topics with Most Replies

Get spesific row item made by @Aditya_Nugroho with 14 replies.

Csvのテーブルから別のテーブルに行追加したい made by @zuka with 13 replies.

How to maximize the excel file that i open? made by @SIM_JUN_HUI_BERTRAM_CSOD with 12 replies.

Top 3 Users Who Posted The Most

@prasath_S made 12 posts!

@Yoichi made 11 posts!

@prasath17 made 10 posts!

Top 3 Most Liked Posts

This post made by @Vibhor.Shrivastava received 5 likes!

HyperHack - Automation for Good challenge!

Hello, #uipath community, Hope you are all progressing well with your Hackathon solution, busy building team, or brainstorming ideas. If you are willing to participate and still looking for some ideas. Here are some needs and problem statements you can consider and help NGOs / associations we closely work with. We want to be transparent with all the participants hence sharing details here and help connect interested folks to the contact person for further discussion. Few important points: We…

This post made by @sishiramishra received 2 likes!

HyperHack - Automation for Good challenge!

@Vibhor, Our team name is BOT-Factory, we would be interested in part of: #The Social Incubator (Use case 1) Our Team: @sishiramishra @lovely.sinha , (One more user yet to confirm)!!

This post made by @Anmol_Yadav received 2 likes!

HyperHack - Automation for Good challenge!

Hi Vibhor. We (RPA Kriegers) confirm the topic 1 and 4 of NGO Teach for Romania. One more team member will also be joining us. Thanks, Anmol

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Regex to select word in the next line of a string

@VB_Tech_pro - here you go… [image] (?<=SGD AMOUNT\s+\r?\n?\d+\s+)\S+ Assumption: SGDAmount always present in the previous line… Hope this helps…

This solution provided by @amitbhatt55 received 1 likes!

What is the maximum page limit of OCR Engines embedded with UiPath Studio

Hi @loginerror, This is resolved long back. UiPath Studio embedded OCR Engines are not having any page limit.

This solution provided by @Yoichi received 1 likes!

Csvのテーブルから別のテーブルに行追加したい

こんにちは 現在のインデックスプロパティにInt32型変数としてiを定義しておいてください。 [img20210423-9]

---

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

Top 3 Topics with Most Views

Filter some data in excel file made by @maroua301 with 26 views.

PDF content in to in to excel table made by @srilakshmi_Tippireddy with 24 views.

Loop through application until data table is null? made by @Tristan_Stumpf with 24 views.

Top 3 Topics with Most Replies

Need help with data scraping from sub links made by @tabbyd with 8 replies.

PDF content in to in to excel table made by @srilakshmi_Tippireddy with 7 replies.

How to get latest downloaded file in a workflow or sequence? made by @Vishal_Singh1 with 5 replies.

Top 3 Users Who Posted The Most

@wasea made 9 posts!

@Mikolaj_Zielinski made 7 posts!

@Shraddha_Gore made 6 posts!

Top 3 Most Liked Posts

This post made by @prasath17 received 3 likes!

PDF content in to in to excel table

@srilakshmi_Tippireddy - I will try my best to provide the patterns by looking at the pic… TO: (?<=TO\s?:).*(?=\sINVOICE) For the above use…Regexvar(0).value.trim… INVOICE NUMBER = (?<=ISSUE DATE\r\n\s+)\w+ ISSUE DATE = (?<=ISSUE DATE\r\n\s+\w+\s+)\w+ CUSTOMER CODE = (?<=DUE DATE\r\n.*)\S+(?=\s+\d{2}\w{3}\d{4}) INR = (?<=GRAND TOTAL AMOUNT IN\s?)\w{3} AMOUNT = (?<=GRAND TOTAL AMOUNT IN.*)[\d.]+ Hope this helps…

This post made by @prasath17 received 2 likes!

Move various files with the same extension type

Hi @Cruz_Becerril_Alliso - Please try this… Directory.GetFiles(Environment.ExpandEnvironmentVariables("%USERPROFILE%\Downloads\"),"*.xml") [image] For Each "Type Argument’ is string. Hope this helps…

This post made by @Shriharsha_H_N received 1 likes!

Uipath Marketplace ! BalaReva Word Activities

Thanks @balupad14 its working now i updated the package

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 | 25 April 2021

Top 3 Topics with Most Views

How to access the offcial and connet packages? made by @fightblue with 29 views.

How to delete a last row in excel file when the data is dynamic? made by @Vishal_Singh1 with 28 views.

https://forum.uipath.com/t/310189 made by @fairymemay with 28 views.

Top 3 Topics with Most Replies

How to resolve 'Copy Sheet' error in excel? made by @Dorothy_lee with 15 replies.

Not able to maximize the window from taskbar made by @Vishal_Singh1 with 15 replies.

Condition always true! made by @Mohammed_Bakr with 6 replies.

Top 3 Users Who Posted The Most

@wasea made 13 posts!

@prasath_S made 7 posts!

@Vishal_Singh1 made 6 posts!

Top 3 Most Liked Posts

This post made by @prasath_S received 2 likes!

Invoke Vb.NET Code dictionary error

Hi @Hara_Gopal In UiPath you have to create a new dictionary variable inside invoke code and assign that dictionary to your output dictionary variable. Try this, Dim dict As New Dictionary (Of String, String) Dim item, key, val As String Try For Each item In lst 'lst is a list passed as input key = item.Split(CChar(":"))(0).ToString.Trim val = item.Split(CChar(":"))(1).ToString.Trim dict.Add(key, val) Next emailDict = dict Catch e As Exception console.WriteLine(e) console.WriteLin…

This post made by @NIVED_NAMBIAR received 2 likes!

Invoke Vb.NET Code dictionary error

Hi @Hara_Gopal I think u had forget to declare the dictionary Can u try this code Dim dictionary As New Dictionary (Of String, String) Dim item, key, val As String Try For Each item In lst 'lst is a list passed as input key = item.Split(CChar(":"))(0).ToString.Trim val = item.Split(CChar(":"))(1).ToString.Trim emailDict.Add(key, val) Next Catch e As Exception console.WriteLine(e) console.WriteLine(e.Message) console.WriteLine(e.Source) End Try Regards Nived N …

This post made by @pat_lee received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi Everyone, I am Patrick. I have been a software consultant for more than 25 yrs, My Job is to train people in accounting software and management reporting. With uipath I hope I can intergrade Uipath to the software to make its more easier to generate report.

Top 3 Most Liked Solutions

This solution provided by @wasea received 1 likes!

Download file from web to a specific folder

hello @Brennan_Montoni , You can use the Wait for download activity to do this. try and let us know if works. Vasile.

---

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

Top 3 Topics with Most Views

What's new in Action Center 21.4? made by @Liji with 37 views.

Save Attachment - Length cannot be less than zero made by @Louis_liu with 36 views.

Splitting Excel in various columns made by @Yudhisteer_Chintaram1 with 34 views.

Top 3 Topics with Most Replies

Delete rows in excel if value in a column is "D" made by @Brennan_Montoni with 19 replies.

Splitting Excel in various columns made by @Yudhisteer_Chintaram1 with 17 replies.

How to pull out all files with modified date less than seven days in a folder? made by @Kelsey_Dane with 17 replies.

Top 3 Users Who Posted The Most

@Jayesh_678 made 26 posts!

@Pankaj.Patil made 19 posts!

@Yoichi made 17 posts!

Top 3 Most Liked Posts

This post made by @Liji received 6 likes!

What's new in Action Center 21.4?

Since our last updates in 20.10 where we released a dedicated Action Center portal for business users, we have been focusing on enabling our customers to scale operations using Action Center based automations by on-boarding more business users as well as by broadening the scenarios being automated. What’s new in business user experience and Actions handling ? Multi-user handling of Form Actions by forwarding Actions to other Users [ForwardActions] Action summary panel to keep track of th…

This post made by @alvaro.j.nobre received 2 likes!

UIPath Studio freezes when I right click on project

That solved it. Thank you for your quick and effective response.

This post made by @Yoichi received 2 likes!

携帯電話にSMSを送信したい

こんにちは UiPathからの直接のSMS送信は難しいので、Twilio等のサービスを経由して行う場合が多いかと思います。

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

携帯電話にSMSを送信したい

こんにちは UiPathからの直接のSMS送信は難しいので、Twilio等のサービスを経由して行う場合が多いかと思います。

This solution provided by @Srini84 received 1 likes!

Error: Object invoked has disconnected from its client?

@SIM_JUN_HUI_BERTRAM_CSOD can you share your screenshot of workflow? Also tell us is it causing due to looping into many files? Thanks

This solution provided by @Yoichi received 1 likes!

範囲を読み込みが途中で終わってしまう

こんにちは Localsパネルのビューアーはすべての情報を出力するわけではないので、今回のケースの確認方法と してはあまりよくないと思います。 WriteLineやLogMessageあるいは、ブレイクポイントで実行を停止しているなら Immediateパネルで dt.Rows.Countの様にDataTableの行数を確認してみると 良いように思います。 [img20210426-6]

---

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

Top 3 Topics with Most Views

🚀 Registration for UiPath DevCon is closing soon! Join us for FREE June 15-16 made by @teresa with 60 views.

Object Detection Virtual Event - Discussion made by @Radu_Buciu with 36 views.

How to find month before today 3 days (working day)? made by @fairymemay with 28 views.

Top 3 Topics with Most Replies

データテーブルの値を配列に変換したい made by @zuka with 14 replies.

How to take cc from excel sheet while sending mail in uipath made by @Sudha_Jha with 13 replies.

Excel Update - Help made by @Anjali_Rani with 12 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 26 posts!

@prasath17 made 18 posts!

@Yoichi made 17 posts!

Top 3 Most Liked Posts

This post made by @teresa received 10 likes!

Registration for UiPath DevCon is closing soon! Join us for FREE June 15-16

Registration for UiPath DevCon is closing soon! Join us for FREE June 15-16. We’re excited to share that UiPath DevCon is BACK for 2021! Read more below or register right away! Our annual conference by developers, for developers is coming up this June 15-16, 2021. This virtual event brings together our technical community around the world for two days of learning, building, and connecting. We’re covering topics like Inter-process Communication, Object Repository, an…

This post made by @Radu_Buciu received 6 likes!

Object Detection Virtual Event - Discussion

Hi! I’m Radu from Neurolabs. We have created this topic to discuss about object detection in the UiPath workflows. We encourage you to share your thoughts, challenges, use cases or any ideas related to this topic. Let’s extend the current RPA capabilities beyond the screen by identifying objects in images or videos! What will follow is a webinar 2021-04-28T11:30:00Z (UTC). You can join it here:

This post made by @Geoff received 2 likes!

New enterprise-scale features now live!

With today’s regular update of Automation Cloud, we’re excited to announce that the following new enterprise-scale features have moved out of preview to be fully available (some today, some last week). These features focus on lowering your total cost of ownership for automation and making your automation environment easier to manage with better compliance. Automation Cloud for Enterprise customers can now exclusively take advantage of: Azure AD Integration : Customers with an Azure AD get aut…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Get specific tags from an XML document

Hi, Do you want to extract “ClaveProdServ” attribute and “Importe” attribute? If so, the following helps you. [img20210427-1] Sample20210427-1.zip (5.3 KB) Regards,

This solution provided by @Rome received 1 likes!

Uipath Studio shows blank

Hi All, Issue resolved. From my end we are suspecting some license issue connecting to orchestartor. What we did is we updated via Home>Setting>License and Profile>Change Local License. We select acquire license to orchestrator then auto restart the uipath studio. open again the studio select the workflow and you will encounter the same as per screenshot above. But when you click NEW…in the background the workflow appear. see screenshot below. [uipath]

This solution provided by @NIVED_NAMBIAR received 1 likes!

How to find month before today 3 days (working day)?

Hi @fairymemay I had updated the workflow check this Main.xaml (13.2 KB) the output i got [image] Regards, Nived N Happy Automation

---

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

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

[system]

Daily Forum Report | 28 April 2021

Top 3 Topics with Most Views

UiPath Marketplace - Automation Ideas Board made by @Andreea_Stroe with 53 views.

Dynamic folder creation made by @Nivetha_R with 33 views.

How to tackle with overlapping text in a Document? made by @raheelferoze with 32 views.

Top 3 Topics with Most Replies

Dynamic folder creation made by @Nivetha_R with 10 replies.

Filter Data Table activity deletes cells made by @achalisma with 8 replies.

How to read a different date format and write the output in a different format? made by @lmoham with 8 replies.

Top 3 Users Who Posted The Most

@ppr made 24 posts!

@Hiba_B made 18 posts!

@Techpriest made 11 posts!

Top 3 Most Liked Posts

This post made by @Andreea_Stroe received 9 likes!

UiPath Marketplace - Automation Ideas Board

Hello, We are very excited to share with you the latest news from UiPath Marketplace! We know how enthusiastic the RPA Community is when it comes to automation and we want to help you in your efforts! Today we have released a public Trello board containing automation ideas that we believe are not touched upon yet and would make an impact on everyone’s way of work. This comes as a result of a massive content review - we wanted to spot the gaps and allow everybody who wants to…

This post made by @DeaTo received 3 likes!

Object Detection Virtual Event - Discussion

You’ll be able to find the recording in the event page :See How to Detect Objects in Images & Videos using UiPath Robots at UiPath EMEA&APAC Virtual Events

This post made by @ppr received 2 likes!

Keep string after a certain word

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

データテーブルの値を配列に変換したい

こんにちは DataTable 側がnullなのではないでしょうか？

This solution provided by @HANACCHI received 1 likes!

Datediff関数の戻り値について

[image] こんな感じです。ご参考まで。

This solution provided by @Hiba_B received 1 likes!

Need to have XML activity for Uipath 2019.10.6

No because it’s not in .nupkg format (as would be an activity in UiPath terms). It’s in xaml format, so if you want to call it as a package you will need to open the xaml file of Paramatrix, create as a library from it (basically copy/paste the code + argument): [image] Then you will be able to publish it from library options, then you will be able to call the package from Manage packages at a local level [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.