Forum Engagement Daily Reports

[system]

Daily Forum Report | 03 August 2023

Top 3 Topics with Most Views

Announcing the General Availability of Snowflake Connector and Activity Package in Integration Service made by @Samrat_Dutta with 85 views.

Public Preview: Automation Cloud™ Robots – Automated Domain Join made by @Chetak_Shankar with 50 views.

Problem in installing packages made by @Mariam_Saeed with 49 views.

Top 3 Topics with Most Replies

How to Resolve Duplicate elements Found Issue made by @Muhammad_Anas_Baloch with 19 replies.

Faster UiPath Automation made by @Naman_Arora with 19 replies.

I have csv data Want to update value in Name column from Id column made by @Garyy with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 54 posts!

@ppr made 37 posts!

@Nguyen_Van_Luong1 made 37 posts!

Top 3 Most Liked Posts

This post made by @Jon_Smith received 3 likes!

Make automatic detection of TypeArgument in ForEach optional

Can I make a suggestion that with alot of these new stuff you try out, that you typically make it something that can be ‘overidden’ or reverted? I realise that can mean dragging along some legacy stuff (like having classic activities still be a thing even though Modern Design in the intended way to use Ui Automation now) but I think its better at least at the beginning to allow bugs and issues to not be chronic. Certain things I think just make sense to be optional. Like the If layout being ver…

This post made by @Vikas_M received 3 likes!

Monthly Forum Rewards - July 2023

Kudos to everyone!

This post made by @famastyle received 3 likes!

How to scrap multiple pages with many buttons page

I solved thanks to @supriya117 who made for me a while cycle to scrap all 52 pages! thank so much to everyone whom answered with patience to me! @rlgandu @B_H_Akshatha_Pai @mkankatala @raja.arslankhan @Veera_Raj

Top 3 Most Liked Solutions

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

How to check if a value is already present as the reference of any of the existing queue item in orchestrator?

Hi @Harsha_Vemula try to pass a date stamp in the queue as a reference with employee Id (append) Once your are passing Datestamp as well with emp I’d as reference, enforce unique reference property…that would solve ur issue

This solution provided by @rlgandu received 1 likes!

Getting error while using "Type into" activity : Could not find the user-interface (UI) element for this action

@sid04 Use Set text activity instead of Type into

This solution provided by @vrdabberu received 1 likes!

Uipath Regex not taking data if it is 1 decimal point

@Irfan_Musa use the below regex expression in Find Matching Pattern activity and then use the for each (?<=\):\s+)\d+.\d+ or use the below syntax in assign activity and use the for each System.Text.RegularExpressions.Regex.Matches(input,"((?<=\):\s+)\d+.\d+)") [image] 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 | 04 August 2023

Top 3 Topics with Most Views

Getting the sheet names in an Excel File dynamically using Modern Excel made by @RobertRussell_Monsalud with 43 views.

How to update last row in first row made by @Garyy with 42 views.

[Q] how can i get the sheet name in Excel (env StudioX not Studio) made by @yuppiensimpson with 40 views.

Top 3 Topics with Most Replies

Regex pattern for pyhton made by @Jhun_III_Daganzo with 14 replies.

Uipath Assistant quiz made by @Latifa with 13 replies.

GetIMAPMailMessagesで添付ファイルが認識できない made by @111790 with 13 replies.

Top 3 Users Who Posted The Most

@mkankatala made 43 posts!

@rlgandu made 42 posts!

@vrdabberu made 30 posts!

Top 3 Most Liked Posts

This post made by @RobertRussell_Monsalud received 4 likes!

Getting the sheet names in an Excel File dynamically using Modern Excel

Hi All @pravallikapaluri @rlgandu @Veera_Raj @vrdabberu @lrtetala @mkankatala @Akshay_B Thank you so much for all of your help and inputs. I really appreciate it. Best regards, Robert

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

Split the string data

[image]

This post made by @Mohammed_Ismail_Rahid received 2 likes!

Linq to filter and add

you can add it to other datatable (From row In in_FailedConversations.AsEnumerable Let conversationID = row(0).ToString Let reminderCount = CInt(row(1).ToString) Let updatedReminderCount = If((conversationID).Equals(ConversationID.toString), (reminderCount + 1).ToString,“”) Select dt.rows.add(reminderCount,updatedRemindercount)).copytodatatable Hope it helps…

Top 3 Most Liked Solutions

This solution provided by @pravallikapaluri received 1 likes!

Getting the sheet names in an Excel File dynamically using Modern Excel

Hi @RobertRussell_Monsalud [image]

This solution provided by @Vikas_M received 1 likes!

How to take screenshot of the whole window without selector?

Hey @yu.li , Try changing the UI framework in selectors panel while indicating, Shortcut to change it is clicking on F4 while indicating [Screenshot 2023-08-04 143731] Hope it helps you!

This solution provided by @Yoichi received 1 likes!

Where is docs about StudioX free for enterprise users?

Hi, How about the following document? Enterprise plan provides with 100 AutomationExpress liceses. https://docs.uipath.com/automation-cloud/automation-cloud/latest/admin-guide/about-licensing#plans-comparison 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 | 05 August 2023

Top 3 Topics with Most Views

Select year using regular expression made by @helpplease with 52 views.

How can I extract the complete phone number from the website when it's displayed as '0096279552xxx' initially and only revealed after clicking on it? Any ideas? made by @M.Abd with 35 views.

LINQ query! made by @Rohan_Dhole with 34 views.

Top 3 Topics with Most Replies

Multiple extractions using regex made by @helpplease with 12 replies.

VBA code excel made by @shama93 with 11 replies.

Switch Activity Expression Field made by @Joel_Metheny with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 53 posts!

@mkankatala made 26 posts!

@Parvathy made 9 posts!

Top 3 Most Liked Posts

This post made by @mkankatala received 2 likes!

How can I extract the complete phone number from the website when it's displayed as '0096279552xxx' initially and only revealed after clicking on it? Any ideas?

Hi @M.Abd Use get text activity to get the mobile number and indicate on the element. After indicates open the UI explorer and select the attribute which has the proper mobile number data. After this use get attribute activity and select the attribute in the output of get attribute create a variable which stores the exact data. Hope it helps!!

This post made by @Anil_G received 1 likes!

Select year using regular expression

@helpplease Try this one (?<[A-Za-z]{3} ?)\d{4} [image] cheers

This post made by @bhavana_kolli received 1 likes!

Validation error BC30512:

solved.i used generic value

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Select year using regular expression

@helpplease Try this one (?<[A-Za-z]{3} ?)\d{4} [image] cheers

This solution provided by @shama93 received 1 likes!

While activity

Ok thanq so much… will try

This solution provided by @Anil_G received 1 likes!

Excel COUNT IF Formula

@Omkar_Shete2 Add two columns for each to write the data in excel And then use write cell activity and give the formula as "=If(COUNTIF(A:A,A2)>1,""Duplicate Found"","""")" Then use auto fill range to fill the formula to the bottom Repeat same for the second columns as well 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 | 06 August 2023

Top 3 Topics with Most Views

Taking from a different line made by @helpplease with 39 views.

Convert PDF File into Excel from studio made by @Agantuk_Avi with 33 views.

Type into 'INPUT' execution error made by @helpplease with 32 views.

Top 3 Topics with Most Replies

Comapare the File path in a directory with the input value from the Excel row made by @srinusoft37 with 12 replies.

Detection of clicking on an object that is revealed only after standing on it made by @mironb with 12 replies.

Join two JObjects into one JObject made by @Axel_Albert with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 17 posts!

@mkankatala made 12 posts!

@Parvathy made 10 posts!

Top 3 Most Liked Posts

This post made by @NISHITHA received 2 likes!

How to consider both Captital and Small Case

Thanks @mkankatala , @supermanPunch and @Anil_G for your prompt responses

This post made by @Axel_Albert received 1 likes!

Join two JObjects into one JObject

I already have 2 working JObjects. [image] [image] I just want to merge them. jObject1.Merge(jObject2) This was already mentioned in another thread and it doesn’t work, it shows this error. [image]

This post made by @Axel_Albert received 1 likes!

Join two JObjects into one JObject

Hi, I have red a few topics about this and none of them worked for me, so I’m asking it myself. I’m trying to merge/join two JObjects into one. 2 jsons into one json. Anyone knows how to do that?. Thank you.

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

Comapare the File path in a directory with the input value from the Excel row

Hi @srinusoft37 => Take an assign activity and store the File path in a array of string variable called FilePath. Assign -> FilePath = Directory.Getfiles("Folder Path") => Take the Use Excel file activity and give the path of the file. => Inside use Excel file insert the for each Excel row activity. Output - CurrentRow => Inside for each Excel row activity insert the for each to iterate the FilePath (Array of String variable) Output - CurrentItem - Condition -> CurrentItem.Contains(Curre…

---

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

Top 3 Topics with Most Views

Generative Extraction & Classification using Document Understanding in cross-platform projects - Public Preview made by @Monica_Secelean with 46 views.

Please let me know the code that can be +1 in the Excel file name! made by @22222222asas with 46 views.

How to use downloaded excel file, copy paste to existing template made by @Muhamad_Izwan_Bin_Hamran with 46 views.

Top 3 Topics with Most Replies

Please let me know the code that can be +1 in the Excel file name! made by @22222222asas with 25 replies.

Unable to read CSV file having > 2 GB Data made by @Nissy_Ruth_Prabhu with 21 replies.

Send calender invite made by @Yogita_Gaikwad1 with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 70 posts!

@vrdabberu made 51 posts!

@rlgandu made 38 posts!

Top 3 Most Liked Posts

This post made by @Monica_Secelean received 8 likes!

Generative Extraction & Classification using Document Understanding in cross-platform projects - Public Preview

Overview Note: As with all preview features in Studio Web, this functionality is only available for Community accounts and not accessible for Enterprise - to try it out without a community account, feel free to download the DocumentUnderstanding.Activities 2.3.1-preview package in Studio. We understand that classifying and extracting information from diverse document types can be challenging and time-consuming, especially when dealing with custom or unstructured use cases. Therefore, we are e…

This post made by @Gokul001 received 3 likes!

Announcing the UiPath Community HyperHack 2023 Winners!

Congratulations to all the winners Regards

This post made by @Quenton_Wayne_Rebello received 3 likes!

I want to keep the time of received mail in Outlook and keep the data in Excel, what should I do?

You can use mailMessage.Date to get date of the mail recieived E.g:- mailMessages.Select(Function(recieved) recieved.DateAsDateTime.ToString("dd/MM/yyyy")).ToArray mailMessages.Select(Function(recieved) recieved.Date.ToString).ToArray These to give an array of dates of the mail recieved, then loop through the array and add to datatable using add data row Activity

Top 3 Most Liked Solutions

This solution provided by @Nguyen_Van_Luong1 received 3 likes!

I want to keep the time of received mail in Outlook and keep the data in Excel, what should I do?

Hi @Famui_Yanisa , You can extract the date from the email as a DateTime variable type with EmailReceiveTime = CDate(mail.Headers(“Date”)), and then simply covert that received date into the time format you need, like this: EmailTime = TimeEmailReceived.ToString(“HH:mm”) … Then add 1 columns "Time received "in Excel to write my output [image] my step: -create file to save mail and time -get list mail -for each mail to get body and time -write cell to write value of body and time to ex…

This solution provided by @vrdabberu received 2 likes!

I want to know how to use "Each For" activity using array variable

@yuppiensimpson [image] Hope it helps!!

This solution provided by @Anil_G received 1 likes!

Join two JObjects into one JObject

@Axel_Albert The merge needs to be used in the invoke code and not in assign activity Pass both the jobjects as in/out arguments to invoke code and then use it inside invoke code…it would work 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 | 08 August 2023

Top 3 Topics with Most Views

Having Error in Data Extraction Scope made by @Mariam_Saeed with 69 views.

How to run a python script in UiPath StudioX made by @Afsal_Baaqir_A with 62 views.

Help me to create regex to only get numbers made by @StevenIsRobotOnline with 61 views.

Top 3 Topics with Most Replies

Help me to create regex to only get numbers made by @StevenIsRobotOnline with 35 replies.

Having Error in Data Extraction Scope made by @Mariam_Saeed with 33 replies.

Excel query- if value have more than 100 then pass or fail made by @Jeeru_venkat_Rao with 29 replies.

Top 3 Users Who Posted The Most

@Anil_G made 75 posts!

@mkankatala made 47 posts!

@rlgandu made 45 posts!

Top 3 Most Liked Posts

This post made by @Shiva_Nikhil received 3 likes!

How to load Excel data into a DataTable and calculate row and column sums?

Hi @ram_pv dt.AsEnumerable.Sum(Function(r) r.ItemArray.Sum(Function(a) cint(a.ToString))) gives Total Sum of rows the datatable dt.Columns.Cast(of DataColumn).Select(Function(c) dt.AsEnumerable.Sum(Function(r) Cint(r(c.ToString)))).Toarray Gives the columns count of datatable cheers.

This post made by @anthonyjr received 3 likes!

Regex Alphanumeric and Certain Special Characters

All the solutions presented were working but this kind of solution is what I’m looking for, more dynamic and flexible. Thanks miss @sasi_poosarla and also to sir @tazunnisa.badavide , @rlgandu , @mkankatala and @lrtetala

This post made by @vinjam_likitha received 3 likes!

I need to filter multiple excel columns data

Thank you all for the solutions

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

【質問】ActionCenter タスクの割り当て方法について

Hi @jin.ota You can assign to other If you have admin access - All users, that have the required permissions for the specific folder, can be assigned an action. To assign an Action to another user: Make sure you are in the Manage Actions view. On the Unassigned tab, select the More options [image] menu for the desired action. Select Assign to user. The Assign Action window opens. Select a user from the drop-down list. Hope it helps!!

This solution provided by @rlgandu received 1 likes!

Extract the date

@NA_AN Assign firstDayOfPrevMonth = Now.AddMonths(-1).AddDays(-Now.Day + 1) Assign lastDayOfPrevMonth = Now.AddDays(-Now.Day).AddTicks(-1)

This solution provided by @Yoichi received 1 likes!

DataRow[]変数に値が入っているか判定

地名_1はデータテーブルを結合した際に自動生成される列名です。 （同一データテーブル内に同じ列名が存在できないので） 以下Windowsプロジェクト版ですので一度お試しください。 Sample20230808-5CS.zip (3.8 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 | 09 August 2023

Top 3 Topics with Most Views

https://forum.uipath.com/t/571347 made by @Bruskie143 with 52 views.

https://forum.uipath.com/t/571276 made by @gorby with 52 views.

https://forum.uipath.com/t/571318 made by @Udiar with 43 views.

Top 3 Topics with Most Replies

https://forum.uipath.com/t/571528 made by @helpplease with 21 replies.

https://forum.uipath.com/t/571347 made by @Bruskie143 with 19 replies.

https://forum.uipath.com/t/571318 made by @Udiar with 19 replies.

Top 3 Users Who Posted The Most

@Nguyen_Van_Luong1 made 49 posts!

@ppr made 41 posts!

@mkankatala made 36 posts!

Top 3 Most Liked Posts

This post made by @tazunnisa.badavide received 2 likes!
https://forum.uipath.com/t/571494/11

This post made by @Mohamed_Rateb received 1 likes!
https://forum.uipath.com/t/571435/1

This post made by @Kartheek_Battu received 1 likes!
https://forum.uipath.com/t/571319/3

Top 3 Most Liked Solutions

This solution provided by @Vikas_M received 1 likes!
https://forum.uipath.com/t/571322/7

This solution provided by @Mariam_Saeed received 1 likes!
https://forum.uipath.com/t/571337/7

This solution provided by @nikhil.girish received 1 likes!
https://forum.uipath.com/t/571298/2

---

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

Top 3 Topics with Most Views

How to Extract XML File with Parsing made by @marina.dutta with 58 views.

How to rename excel/files? made by @Muhamad_Izwan_Bin_Hamran with 51 views.

I want to add symbols in between a string variable made by @Gines_Cirera with 48 views.

Top 3 Topics with Most Replies

How to Extract XML File with Parsing made by @marina.dutta with 27 replies.

Compare 2 columns and Log message made by @Bhushan_Nagaonkar with 24 replies.

Read PDF With OCR (Tesseract OCR) made by @Temuulen_Buyangerel with 19 replies.

Top 3 Users Who Posted The Most

@mkankatala made 41 posts!

@Nguyen_Van_Luong1 made 38 posts!

@ppr made 33 posts!

Top 3 Most Liked Posts

This post made by @Bhushan_Nagaonkar received 2 likes!

Compare 2 columns and Log message

It is working. Thankyou so much. @mkankatala @Shiva_Nikhil @Nguyen_Van_Luong1

This post made by @Bhushan_Nagaonkar received 2 likes!

Compare 2 columns and Log message

Thankyou I wil try it

This post made by @Yazan_Otaibi received 1 likes!

Send attachment by mail

hi all , i want to send one file as attachment by mail using Outlook send mail the attachment option cant let me put the path its required var as ienumerable and this var contains all files in folder and i want a specific file to sent by giving the path

Top 3 Most Liked Solutions

This solution provided by @B_H_Akshatha_Pai received 1 likes!

I want to get any of those value and write only on single cell

After selecting the element Use if condition , if condition satisfies use a gettext activity and then write that text in excel sheet using write cell Regards,

This solution provided by @rlgandu received 1 likes!

Send attachment by mail

@Yazan_Otaibi Add Attachments to IEnumerable of String: Assign: attachments = {“C:\Path\To\file1.txt”, “C:\Path\To\file2.pdf”} In this example, the attachments variable holds a collection of file paths (strings), which are then passed to the “Send Outlook Mail Message” activity as attachments. This allows you to attach specific files to the email without needing to attach all files from a folder.

This solution provided by @mkankatala received 1 likes!

Benifit of using orchestrator queues

Hi @gr82testing Option B is the correct one. => Queues are created in Orchestrator when we are creating we can give the max retry count but we cannot change after the creation of queues. So Option A is incorrect. => we can monitor the status of the queue items in queue tab in Orchestrator. When upload to queue it is in new state. When run by bot it is in process state. If it is success it is in success state, if any exception is occured it will be in retry state. So Option B is Correct one. …

---

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

Top 3 Topics with Most Views

How to compare excel row by row comparison and view same excel sheet column output made by @nkaushalya with 46 views.

Filter datatable based on dates made by @Kunal_Jain with 43 views.

How to use try catch in singgle line vb? made by @Iwan_Kurniawan2 with 41 views.

Top 3 Topics with Most Replies

How to get Items in List made by @marina.dutta with 19 replies.

Reading headers- excel made by @Anjali_Rani with 17 replies.

How to add header name to excel sheet made by @mironb with 15 replies.

Top 3 Users Who Posted The Most

@Nguyen_Van_Luong1 made 35 posts!

@ppr made 29 posts!

@Shiva_Nikhil made 28 posts!

Top 3 Most Liked Posts

This post made by @Kuldeep_Pandey received 2 likes!

Last Second string 1

Thankyou all its working fine

This post made by @H_khot received 2 likes!

Getting "Key,Value ""Value"",""""" as Invoice Number

ok, Next Time i will Try to Provide a Proper Idea Thanku @supermanPunch and @Shiva_Nikhil for Helping.

This post made by @Gowthaman_Gajakutti received 1 likes!

How to store date value in Datatable in Ui path?

I am having assign variable with date value: experienceDate = 01/12/2023 - 22/08/2023. I want to store experienceDate in a datatable. What type should i choose to store the experienceDate? Please give me solution with an example. Thanks.

Top 3 Most Liked Solutions

This solution provided by @Quenton_Wayne_Rebello received 1 likes!

How to compare excel row by row comparison and view same excel sheet column output

Hey @nkaushalya , You can try the xaml attached below Main.xaml (12.0 KB) Output:- [image]

This solution provided by @esongi_park received 1 likes!

Data Scrape기능에서 필요 없는 컬럼은 어떻게 자를 수 있나요?

[image] 해당 액티비티 사용하시면 됩니다. 0번째가 첫번째입니다 구글링 참고하시면 도움이 될거에요

This solution provided by @ppr received 1 likes!

How to get Items in List

we should not try to put the variety of all possible XML scenarios, which can occur in the world, into one solution. Your XML is bound to an office:document xml. You also have implemented to work with text:p elements We can bring some flexibility into by: [grafik] Or [grafik]

---

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

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

[system]

Daily Forum Report | 12 August 2023

Top 3 Topics with Most Views

I want to print Excel Sheets in PDF made by @venkateshwara_rao with 35 views.

Table Extraction- Write DataTable to Excel Error made by @Heydi_Reyes with 35 views.

How to solve this type of error? made by @Neeraj_Gupta1 with 34 views.

Top 3 Topics with Most Replies

Extract table data not working correctly made by @emir_ozsimsir with 14 replies.

I want to print Excel Sheets in PDF made by @venkateshwara_rao with 10 replies.

Regex for scanned pdf made by @satyarohith2020 with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 29 posts!

@Shiva_Nikhil made 17 posts!

@postwick made 11 posts!

Top 3 Most Liked Posts

This post made by @Shiva_Nikhil received 1 likes!

Extract table data not working correctly

Datatablevaraible.AsEnumerable().GroupBy(Function(i) i(“columnName”)).Select(Function(g) g.First).CopyToDataTable First try with above query if not works use below Datatablevariable.defaultview.totable(true) Can you use this

This post made by @Federico_L received 1 likes!

Unexpected result while debugging project

@Yoichi @Athira I found the solution: [image] This was the mistake^ I was leaving the first Else unpopulated, while leaving the second Else populated. I switched it to this: [image] This solved the issue. Thank you very much.

This post made by @Athira received 1 likes!

Unexpected result while debugging project

Hi @Federico_L Question is a bit unclear, but as per my understanding, instead of checking NextAction.equals(“Request my change”) you are doing NextAction.equals(“Get change”)

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Installing UiPath Studio on Linux Operating System

@Tapan_Behera1 As of now you have option to run bot not to create using linux machines… You can create a cross platform or create a project from Studio web which can work on linux https://docs.uipath.com/robot/standalone/2023.4/user-guide/linux-robots Cheers

This solution provided by @Athira received 1 likes!

Unexpected result while debugging project

@Federico_L I didn’t quiet understand the solution you have given because the condition is checking for “Get change” whereas the options are entirely different. I might have missed something. But the code i am uploading is working for me, though i am not seeing all the exception scenarios handled, but i believe you are doing this for learning purpose so it should be fine. Only thing i have done is changing that condition. Vending Machine.xaml (23.1 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 | 13 August 2023

Top 3 Topics with Most Views

Extracting information from large PDF file with Document Understanding made by @harsha_prakash with 36 views.

How to add multiple variables to a list using invoke method made by @QUY_T_TAM_8.0_IELTS with 35 views.

Hyperlink in uipath made by @satyarohith2020 with 34 views.

Top 3 Topics with Most Replies

Unable to scrape more than 10 tweets on twitter using the table extraction wizard made by @Harith_Sai_Saraf with 12 replies.

Calculation of values after extraction made by @Somanath_Somu with 11 replies.

How to remove time stamp from date made by @satish.rathi59 with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 25 posts!

@supermanPunch made 19 posts!

@postwick made 10 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

Unable to scrape more than 10 tweets on twitter using the table extraction wizard

@Harith_Sai_Saraf Try scrolling till bottom and then extra the tweets There shpuld be some break to scroll ypu cant expect whole intimite scroll to be extracted Cheers

This post made by @Anil_G received 1 likes!

Extract table data not working correctly

@emir_ozsimsir Can you preview the data in extract datatable and check if they are actually repeated or that is the exact data… Ideally there wont be any repeatition Cheers

This post made by @lrtetala received 1 likes!

Extract table data not working correctly

Hi @emir_ozsimsir After extracting the data table use Remove Duplicate Rows activity [image] O/P Excel: ford (1).xlsx (19.2 KB) I hope you understand!!

Top 3 Most Liked Solutions

This solution provided by @Shiva_Nikhil received 1 likes!

Calculation of values after extraction

Hi @Somanath_Somu System.Text.RegularExpressions.Regex.Matches(inputstring,“[^a-zA-Z-\s]”) Gives you the output as collection You can call the required values based on index Hope this helps

This solution provided by @Anil_G received 1 likes!

How to select an exact date in a website's datepicker

@QUY_T_TAM_8.0_IELTS Please check this cheers 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 | 14 August 2023

Top 3 Topics with Most Views

How to spilt the dynamic string? made by @Gowthaman_Gajakutti with 55 views.

Extract Data Table not change values made by @yorman2330 with 51 views.

Help me to spilt Company name, Job title and Experience date and Store them in different variable in Uipath made by @Gowthaman_Gajakutti with 46 views.

Top 3 Topics with Most Replies

Help me to spilt Company name, Job title and Experience date and Store them in different variable in Uipath made by @Gowthaman_Gajakutti with 21 replies.

Able to read range workbook without error? made by @winnie_toh with 16 replies.

What is the method for moving cell values one by one from a sheet to cells on another sheet in Excel? made by @22222222asas with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 69 posts!

@Nguyen_Van_Luong1 made 37 posts!

@rlgandu made 32 posts!

Top 3 Most Liked Posts

This post made by @s.bruce received 2 likes!

Reusable components with libraries is much more difficult than Invoke Workflow

Hi Jason, Quick example - a developer builds a XAML which logs into a web portal, that login XAML is included in a ‘reusable components’ library which is then published to Orchestrator. You have 10 processes which all need to log into that web portal, but one day the third-party changes the login page and all ten processes break. If you had to copy and paste XAMLs between projects, that’s ten change requests, ten code branches, ten tests, ten approvals/pull requests, ten merges, ten new packag…

This post made by @Praveen_Mudhiraj received 2 likes!

How to remove time stamp from date

H! @satish.rathi59 instead of doing all ,simply use this expression Convert.ToDateTime(“05/21/2023 00:00:00”).ToString(“MM/dd/yyyy”) for the reference check below screenshot! [image]

This post made by @manojj.yadav received 2 likes!

Clicking a specific button when there's 5 same buttons

Couldn’t solve this issue with anchor either. The anchor is highlighted correctly but the target is clicked at a different window. Finally, I figured our that I can also close window by right clicking the bottom tabs (which are unique). So, I’m just gonna use it. [image] Thanks for responding!

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Error: "Value for property is not a valid XML syntax."

@Carla_Munoz replace & with &amp; str.Replace("&","&amp;") or you can even use this System.Net.WebUtility.HtmlEncode("str") cheers

This solution provided by @Yoichi received 1 likes!

Cannot assign multiple string-type variables to a value from Excel using String.Format

Hi, Can you try to modify the following red arrow bracket to curly bracket? [image] Regards,

This solution provided by @Yoichi received 1 likes!

Able to read range workbook without error?

Hi, For now, can you try it to put Shortcut activity to send ESC before ReadRange? OR, in many case, it’s unnecessary to use shortcut. I guess you tried to get Sheet name before ReadRange. However we might be able to get each sheet name using ForEachExcelsheet or Classic Get Workbook Sheets activity. So, first, can you try to remove shortcut and set sheet name statically, then check if solve this issue. If it’s solved, try to get sheet name dynamically. 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 | 15 August 2023

Top 3 Topics with Most Views

How to solve this, can u give some hints made by @Anjana_R with 59 views.

Help! Lost 4 days work made by @sid04 with 50 views.

How can I pass few variable in same path? made by @Muhamad_Izwan_Bin_Hamran with 47 views.

Top 3 Topics with Most Replies

Help with Get Text and variables made by @weskorecki with 19 replies.

How can I pass few variable in same path? made by @Muhamad_Izwan_Bin_Hamran with 18 replies.

How to solve this, can u give some hints made by @Anjana_R with 16 replies.

Top 3 Users Who Posted The Most

@Nguyen_Van_Luong1 made 42 posts!

@Anil_G made 33 posts!

@rlgandu made 26 posts!

Top 3 Most Liked Posts

This post made by @jjes received 3 likes!

New video on Action Center: External Tasks and Task Assignment

Link to my latest video on my YouTube channel, “UiPath with Jeppe” (and don’t forget to subscribe) : [Mastering UiPath Action Center: Boost Productivity with External Tasks]

This post made by @Anil_G received 2 likes!

Try catch inside assign activity

@Etienne8125 You can also use jsn.ContainsKey("KeytoSearch") which returns true if present else false so inassignc an sue like this If(jsn.ContainsKey("KeytoSearch"),jsn("KeyToSearch").ToString,"") cheers

This post made by @Latifa received 2 likes!

Email activities

You guys have really elaborated well,thanks a lot for your constant help @lrtetala @Parvathy @rlgandu

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Try catch inside assign activity

@Etienne8125 You can also use jsn.ContainsKey("KeytoSearch") which returns true if present else false so inassignc an sue like this If(jsn.ContainsKey("KeytoSearch"),jsn("KeyToSearch").ToString,"") cheers

This solution provided by @Anil_G received 1 likes!

How to do a correct validation to ensure my retry scope works as intended

@MadsV If you check in properties of click you will have verify execution option where you can give retry as wel [IMG_6118] Hope this helps Cheers

This solution provided by @Yoichi received 1 likes!

【質問】ActionCenter:ファイルコンポーネント

実際に試していませんが、以下のようにFilePathプロパティはいかがでしょうか？ （アップロード元が格納されていますでしょうか？） [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 | 16 August 2023

Top 3 Topics with Most Views

Spliting the data within excel with regards policy number made by @ISBS_ROBOT with 56 views.

I want a method to achieve this made by @P-A-J with 55 views.

Scrape the data in a website made by @QUY_T_TAM_8.0_IELTS with 45 views.

Top 3 Topics with Most Replies

I want a method to achieve this made by @P-A-J with 24 replies.

For some reason, Read Range is not fetching the made by @sid04 with 18 replies.

Write cell excel activity made by @bhavana_kolli with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 37 posts!

@Nguyen_Van_Luong1 made 26 posts!

@Yoichi made 22 posts!

Top 3 Most Liked Posts

This post made by @naveenkumarr received 2 likes!

Null values getting added to queue - Bulk add queue items

thanks @mkankatala and @lrtetala

This post made by @efelantti received 2 likes!

Table Extraction: Extract URLs

Seems like this is available in UiPath.UIAutomation.Activities = 22.4.10, but not in newer versions.

This post made by @Latifa received 2 likes!

Uploading queue items

Thanks a lot @Parvathy @lrtetala and @postwick

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Sub data table

we can group the data / split it to a list of datatables Assign Activity: TableList | DataType: List(Of DataTable) = (From d in Your DataTable.AsEnumerable Group d by k=d("num_chrono").toString.Trim into grp=Group Select t = grp.CopyToDataTable).toList

This solution provided by @tazunnisa.badavide received 1 likes!

Spliting the data within excel with regards policy number

Hey ! I have attached the workflow here ,Hope it might help You. Create Excel.xaml (10.8 KB)

This solution provided by @Yoichi received 1 likes!

I want a method to achieve this

I understand your points. How about the following? dt.AsEnumerable.GroupBy(Function(r) r("ID").ToString).OrderBy(Function(g) Cint(g.Key)).Select(Function(g) dt.Clone.LoadDataRow(new object(){g.Key}.Concat(Enumerable.Range(1,dt.Columns.Count-1).Select(Function(i) String.Concat(g.Select(Function(r) r(i).ToString)))).ToArray,False)).CopyToDataTable Sample20230816-3L (5).zip (15.3 KB) Regards,

---

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

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

[system]

Daily Forum Report | 17 August 2023

Top 3 Topics with Most Views

Linq For 2 datatables. Inserting datat from one datatable to another using one common column made by @yash.choursia with 57 views.

Last day of the month a Sunday? made by @anh.nguyen with 50 views.

Do not have "Open Application" made by @Hood_Blah with 49 views.

Top 3 Topics with Most Replies

Find no in for each row made by @Kuldeep_Pandey with 43 replies.

Linq For 2 datatables. Inserting datat from one datatable to another using one common column made by @yash.choursia with 39 replies.

Last day of the month a Sunday? made by @anh.nguyen with 19 replies.

Top 3 Users Who Posted The Most

@postwick made 55 posts!

@Shiva_Nikhil made 30 posts!

@Anil_G made 26 posts!

Top 3 Most Liked Posts

This post made by @Vikas_M received 3 likes!

How we can compare two sheets based on one reference column and get output in new sheet

Hey @Ajinya_jorwekar , Can you please mark the right post as solution such that it would help the community to access the answer easily Also it will motivate the users to answer and help others just like @Brian_Mathew_Maben did to you Thank you in advance

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

Get row value based on column value

new.xaml (11.8 KB) Hey I have attached the workflow here! hope it might help you!

This post made by @Vikas_M received 2 likes!

How to set an Array to empty/null

Hey @SRoyi , I assume u want to create an empty array u have to initialize [image]

Top 3 Most Liked Solutions

This solution provided by @Vikas_M received 2 likes!

How to set an Array to empty/null

Hey @SRoyi , I assume u want to create an empty array u have to initialize [image]

This solution provided by @ppr received 2 likes!

Parameter has already been declared for this method

can be done directly within an assign activity: myFileNameList = New DirectoryInfo("FolderPathOrVariable").GetFiles().Select(Function (x) x.Name).toList()

This solution provided by @Quenton_Wayne_Rebello received 1 likes!

Linq For 2 datatables. Inserting datat from one datatable to another using one common column

Hey @yash.choursia, Try the below xaml for the sheets you have sent. AddAbrievation.xaml (7.3 KB) Sheets: - Book123.xlsx (281.3 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 | 18 August 2023

Top 3 Topics with Most Views

Write range workbook activity sheet error made by @ISBS_ROBOT with 50 views.

Do not support SELECT ITEM Activity made by @dkngit55 with 48 views.

Please help me with Excel hyperlinks made by @22222222asas with 46 views.

Top 3 Topics with Most Replies

Do not support SELECT ITEM Activity made by @dkngit55 with 25 replies.

How to remove  character in multiple lines from data extracted made by @Harshita_Ramesh with 15 replies.

Please help me with Excel hyperlinks made by @22222222asas with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 28 posts!

@ppr made 22 posts!

@Shiva_Nikhil made 21 posts!

Top 3 Most Liked Posts

This post made by @vkalra received 2 likes!

Please help me with Excel hyperlinks

did you check this?

This post made by @Vikas_M received 2 likes!

Read Range Error in Excel

Hey @ajnaraya , If the excel file is empty then The read range workbook activity throws an nullReference Exception So to handle this exception , please surround your read range activity using Try Catch activity Wrap the Read Range workbook activity like below screenshot [image] Hope it helps you out

This post made by @Mark007 received 2 likes!

Unattended Automation Works When I am Logged In but not when on Screen Lock

Hi @postwick @Anil_G I wanted to write back to you to confirm that after your guidance, I managed to get this working on my spare laptop as an unattended service with the robot logging in and logging out when it is finished. I’m really please I got over this hurdle and couldn’t have done it without your help. Thanks again for your support on this! Mark

Top 3 Most Liked Solutions

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

Double To String in specific format

Hi, Assign Activity: Start by storing your double value in a variable. Let’s say the variable name is doubleValue and it contains the value 1238.2. Assign Activity: Convert the doubleValue to the desired format using the ToString method with a specific format string. formattedString = doubleValue.ToString(“N2”, new CultureInfo(“fr-FR”)) + " (€)" N2: This specifies that the number should be formatted with a thousands separator and two decimal places. CultureInfo(“fr-FR”): This uses the Frenc…

This solution provided by @Anil_G received 1 likes!

Help me to only et the words after spesific numbers

@StevenIsRobotOnline First use this regex to get the value…the first matched value is what you need so use as below and then you can replace all special characters and spaces [A-Z]*[ \-,]*(?=\d{4}) System.Text.regularExpressions.Regex.Replace(System.Text.regularExpressions.Regex.Match(str,"[A-Z]*[ \-,]*(?=\d{4})").Value,"[^A-Z]","") [^A-Z] - this takes care of removing extra characters [image] Hope this helps cheers

This solution provided by @rlgandu received 1 likes!

I have a collection variable and i want to remove from the datatable

@sathish_Kumar6 Assign activity: dataTable = (From row In dataTable.AsEnumerable() Where Not listVariable.Contains(row(“Column_Name”).ToString()) Select row).CopyToDataTable()

---

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

Top 3 Topics with Most Views

Cant able to read Asset Value in Read range activity made by @Aswini_mano with 40 views.

Why is showing like that? made by @Neeraj_Gupta1 with 40 views.

Object refence not set to an instance of an object while Debugging itself made by @Sree_Krishnan_vellinezhi with 40 views.

Top 3 Topics with Most Replies

Error and Warnings found in REFramework_with_queues project made by @Federico_L with 28 replies.

Why is showing like that? made by @Neeraj_Gupta1 with 13 replies.

Object refence not set to an instance of an object while Debugging itself made by @Sree_Krishnan_vellinezhi with 13 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 25 posts!

@Anil_G made 22 posts!

@Praveen_Mudhiraj made 13 posts!

Top 3 Most Liked Posts

This post made by @Jeroen_van_Loon received 2 likes!

How do I get the id of a queue?

Read it in the URL of the orchestrator when you open a queue: https://cloud.uipath.com/ … /DefaultTenant/orchestrator_/monitoring/queues/833639?tid=xxxxxxx&fid=xxxxxxx If you use an on premise Orchestrator the URL is different of course, but the location of the queue ID the same. (Although most likely a lower number)

This post made by @PPIM_RPA received 1 likes!

Replace the last letter of each string in a datatable column

Hello, In dt, there is a column “Animals” How to replace the last letter of each item as such: cows, horses, skunks, pigs > cow(s), horse(s), skunk(s), pig(s)? Thank you

This post made by @Shiva_Nikhil received 1 likes!

Get Text in a Proper Format

hi @QUY_T_TAM_8.0_IELTS I am getting this output "Da Nang (DAD) → Ho C. M. City (SGN)Wed, 13 Sep 2023 " if you want any output from the above string we can extract

Top 3 Most Liked Solutions

This solution provided by @Shiva_Nikhil received 1 likes!

Get Text in a Proper Format

hi @QUY_T_TAM_8.0_IELTS I am getting this output "Da Nang (DAD) → Ho C. M. City (SGN)Wed, 13 Sep 2023 " if you want any output from the above string we can extract

This solution provided by @Parvathy received 1 likes!

Cant able to read Asset Value in Read range activity

Hi @Aswini_mano While giving the path in tha asset make sure you don’t give it in double quotes and just give only the path. Regards

This solution provided by @Anil_G received 1 likes!

How do I get the id of a queue?

@muehlbauer157 You can use orchestrator api…and use get queue definitions api…which will get you the id and the name as well Cheerd

---

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

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

[system]

Daily Forum Report | 20 August 2023

Top 3 Topics with Most Views

How to check only if first row contains required values in DT made by @Sathish_Kumar_S with 42 views.

I am facing a problem after joining tables made by @P-A-J with 39 views.

Error in Connecting unattended bot made by @sathya_auto with 38 views.

Top 3 Topics with Most Replies

I am facing a problem after joining tables made by @P-A-J with 28 replies.

Remove particular rows using LINQ made by @Kira with 16 replies.

Replace Blank\Null values on datatable made by @Adi_Lupashko with 16 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 28 posts!

@postwick made 16 posts!

@Anil_G made 14 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Remove particular rows using LINQ

On first it depends on the mutually agreed skill sets of the development team, and how / if LINQ is allowed when there is no need to touch the left side (e.g. toupper, trim) then Filter DataTable can be used When there is a need to touch the left side (eg toupper, trim) then a data cleansing is needed or can be done directly within the LINQ (we have seen abover, toupper, trim). So it depends on other factors, when to use LINQ or not

This post made by @Shiva_Nikhil received 2 likes!

Hello, all I am new to linq

@Chirag12 Use it in assign activity Leftside Datatabke variable =datatablevar.asenumerable.orderby(Function(x) x(“columnName”)).CopyToDataTable

This post made by @Kira received 1 likes!

Remove particular rows using LINQ

@postwick , @ppr , @Vikas_M , @Shiva_Nikhil , @Dinesh_Guptil , @Praveen_Mudhiraj , Which one is better , Linq or Activities I know that these kind of tasks can be done using activities, But i wanted to know why LInq then? According to me, i feel like Linq is Better than activities Please enlighten me with your knowledge

Top 3 Most Liked Solutions

This solution provided by @Shiva_Nikhil received 1 likes!

Build an automation to display first 10 gmail inbox unread messages in message box

@Sai_Kumar_111 no need no mention any folder. you need to click on + button, it will display all the folders which you have in the mail [forum screenshot] [forum screenshot]

This solution provided by @Shiva_Nikhil received 1 likes!

How to check only if first row contains required values in DT

@Sathish_Kumar_S no you can directly use it in the if Condition [image]

This solution provided by @Vikas_M received 1 likes!

Making of questions

Hey @Conning , Keep the condition as below image, such that the cases (Capital or small) letters do not matter [image] Apart from these it would be great if you also trim the answer The Trim function is used to remove leading and trailing whitespace (spaces, tabs, newlines) from a string. This is particularly useful to clean up user inputs, as extra spaces can inadvertently affect comparisons and operation The ToLower (or ToLowercase ) function is used to convert all characters in a string …

---

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

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

[system]

Daily Forum Report | 21 August 2023

Top 3 Topics with Most Views

How to append two data tables with out merge activity made by @vineelag with 54 views.

Want to split the pdf file basis on text name made by @Smitesh_Aher1 with 54 views.

Regular Expression help-Regex made by @rlgandu with 52 views.

Top 3 Topics with Most Replies

Png 형식 파일 OCR 추출 질문 made by @dongbinr56 with 28 replies.

Code to extract a specific text from a Get Attribute Variable made by @yeshwanth with 22 replies.

In RE Framework, I want to add row data in a Column of Data table in each Transaction made by @Ajinya_jorwekar with 16 replies.

Top 3 Users Who Posted The Most

@Nguyen_Van_Luong1 made 45 posts!

@Shiva_Nikhil made 42 posts!

@Parvathy made 26 posts!

Top 3 Most Liked Posts

This post made by @ramcharan863 received 3 likes!

PDF TABLE EXTRACTION date

Hello @Nikhil_Katta Please follow these steps for your output System.Text.RegularExpressions.Regex.Match(str_Pdftext,“(?<=Approved From).(?=Number of Visits)“).Value.Trim System.Text.RegularExpressions.Regex.Match(str_Pdftext,”(?<=Number of Visits).”).Value.Trim.Split(" “c)(1) System.Text.RegularExpressions.Regex.Match(str_Pdftext,”(?<=Approved Thru).*(?=DME)").Value.Trim Happy Automation [image]

This post made by @Parvathy received 2 likes!

Png 형식 파일 OCR 추출 질문

Hi @dongbinr56 => Use Load image acitvity to load the image and store the output in a variable. => Use Tesseract OCR Engine and pass the variable. Stroe the output in text. => Use Write line or Message box to print the content. Hope it helps!!

This post made by @Nguyen_Van_Luong1 received 2 likes!

Png 형식 파일 OCR 추출 질문

Hi @dongbinr56 , To get text in image PNG, you can use OCR - Japanese, Chinese, Korean with korean character, I think it will correct, I tried it with japan text is ok [image] regards, LNV

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Find the second, third day (Monday) of every month, and of second day of 3,6,9,12 Month

Hi, How about the following condition? Today.Day=2 OrElse (Today.Day=3 AndAlso Today.DayOfWeek=DayOfWeek.Monday) [image] Another action I need to check current date is the second day of March, June, Sept, Dec(3,6,9,12) {3,6,9,12}.Contains(Today.Month) AndAlso Today.Day=2 [image] Regards,

This solution provided by @sasi_poosarla received 2 likes!

Send queue details from one folder to another folder

hai @Kathiravan The Specific Queue can be move or to add to another folder by selecting MANAGE LINKS of that specific Queue… [image] After that [image] need to select the folder to which you need to move that specific Queue Hope it would Helps!!!

This solution provided by @Usha_Jyothi received 2 likes!

I am facing a problem after joining tables

Hi @P-A-J Please check the code MergeDatetebles using linq.zip (10.4 KB) let me know if that works 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 | 22 August 2023

Top 3 Topics with Most Views

How can i Extract the entire folder hierarchy made by @Soudios with 60 views.

How to search index of a string/value from data table but without knowing the column made by @StevenIsRobotOnline with 55 views.

BC30574: Option strict on - Binding error (for each) made by @PeCour with 50 views.

Top 3 Topics with Most Replies

How can i Extract the entire folder hierarchy made by @Soudios with 53 replies.

How can i compare 2 excel file and if there is a difference write it on an other excel file made by @Soudios with 42 replies.

How to extract the empty rows in an excel sheet made by @raju_alakuntla with 16 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 82 posts!

@Nguyen_Van_Luong1 made 55 posts!

@Soudios made 41 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Split datatable variable by Nth occurance of character

A LINQ Approach could look like this: Assign Activity: dtSplit =dtOrigVar.Clone Assign Activity: dtSplit = (From d in dtOrigVar.AsEnumerable() From sp in d(0).toString.Trim.Split(","c).Chunk(2).Select(Function (x) String.Join(",",x)) Let ra = new Object(){sp, d(1), d(2)} Select r = dtSplit.Rows.Add(ra)).CopyToDataTable

This post made by @Yoichi received 2 likes!

デスクトップ版 Outlook アプリを使用 で表を埋め込む際、表を小さくしたい

こんにちは CreateHTMLContentでhtmlのメール本文を文字列として作成しておいて table width=“100%” の部分を例えばtable width="50%"に書き換える等でしょうか。 ひな形のCSSで書き換えれれば良いのですが、表の部分は直接数字が埋め込まれているみたいなので strHtmlBody.Replace("table width=""100%""","table width=""50%""") のようにしてみかでしょうか。

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

Not able to publish package to orchstrator

Hi @pratyush3410 welcome to community then you might be using the wrong [robot] type, you should be using [Studio] or StudioPro and not unnatended

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

REFrame work question

@A_Learner You would not comment out anything rather you would convert ref to linear format For that you need to modify get transaction data by commenting out the activity to interqct with queue inside it and use if condition and set the transactionitem to a value only if the transactionnumber is 1 else set it to nothing For detailed flow check this [2023 | How to use UiPath RE Framework for linear process | Step by Step | Mukesh Kala UiPath] Cheers

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

Not able to publish package to orchstrator

Hi @pratyush3410 welcome to community then you might be using the wrong [robot] type, you should be using [Studio] or StudioPro and not unnatended

This solution provided by @Yoichi received 2 likes!

デスクトップ版 Outlook アプリを使用 で表を埋め込む際、表を小さくしたい

こんにちは あらかじめ別でメール本文を作っておくという意図です。 [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.