Forum Engagement Daily Reports

[system]

Daily Forum Report | 26 November 2022

Top 3 Topics with Most Views

Removing validation error made by @lq_c with 40 views.

Github UIPath App not working made by @EchoS with 31 views.

How to open logs from execution_log_data made by @RPA_Canada with 30 views.

Top 3 Topics with Most Replies

Can't access for each json children after deserializing made by @pink_unicorn_waifu with 17 replies.

DataTable Group By and Sum made by @huang.kaijin with 10 replies.

Unable to upload sheets in uipath made by @Cuberoot with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 33 posts!

@pink_unicorn_waifu made 7 posts!

@Justine made 6 posts!

Top 3 Most Liked Posts

This post made by @neil.obrien received 1 likes!

Extract Table Data fails and causes Studio to freeze

Hello Maciej , Packages look like this [image] I have worked around the error by copying an Extract Table activity and then using a click to get the selector and then updating the Extract Table activity with the selector from the click.

This post made by @neil.obrien received 1 likes!

Extract Table Data fails and causes Studio to freeze

Maciej, You are right! Updated to current versions and the problem disappeared. Thank you!! [image]

This post made by @RajKumar_DC received 1 likes!

How to open logs from execution_log_data

Hi @RPA_Canada, Use Ctrl+L

Top 3 Most Liked Solutions

This solution provided by @RajKumar_DC received 1 likes!

How to open logs from execution_log_data

Hi @RPA_Canada, Use Ctrl+L

This solution provided by @Anil_G received 1 likes!

Is there a way to extract the account no values(excluding special characters that are not numeric or alphabets)?

Hi @Justine “1.12345678/2.35548674” this is the string that is being passed in the assign if you want to split what is there in excel then read the excel into datatable…run a for each loop and pass currentrow(“Youraccountnumbercolumnname”).Tostring then it will get the account numbers eg: System.Text.RegularExpressions.Regex.Matches(currentrow(“Youraccountnumbercolumnname”).Tostring,“\d+.\d+”) Note: Do this inside for each row in datatable loop. Keep assign and the for each(already created)…

---

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

Top 3 Topics with Most Views

Read range cell value made by @rajyavardhansr with 37 views.

Cant add sharepoint list item made by @Nathan_Betters1 with 31 views.

Acme-test login is not working made by @balasubramaniam.r.k with 28 views.

Top 3 Topics with Most Replies

JIRA Cloud> HTTP Request with proxy made by @pushkar.singh with 12 replies.

Edgeの右クリック→メニュー上の「画像をコピー」操作できない made by @11159 with 8 replies.

Read range cell value made by @rajyavardhansr with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 26 posts!

@Yoichi made 10 posts!

@bakrious12 made 6 posts!

Top 3 Most Liked Posts

This post made by @house.of.nf.ssk received 1 likes!

無料期間の失効

それらしき情報は落ちていませんでしたので、一か八かでアンインストール、インストールしました。 インストール後はどのアカウントにサインインしますか？と聞かれ恐らく今まで使用していたアカウントを選択するとエラーが出ました。おそらく間違って作成したアカウントを選択すると無事サインインが完了し、使用できるようになりました。取り急ぎ勉強は可能になりましたが、今後も更新で苦労するのかもしれません。更新が来るたびにアカウントを作成していけばよいのかもしれませんが、正式な更新方法を知らないと不安ですね。 急ぎの案件ではなくなりましたが、どなたか今後もアドバイス頂けると助かります。

This post made by @lynnsong986 received 1 likes!

Regex help 11.26.22

thanks both, this works perfectly! Lynn

This post made by @RajKumar_DC received 1 likes!

Acme-test login is not working

@balasubramaniam.r.k, try with deferent browser thanks,

Top 3 Most Liked Solutions

This solution provided by @house.of.nf.ssk 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 | 28 November 2022

Top 3 Topics with Most Views

How to solve this issue can anyone suggest me? made by @Soundarya_Guduri with 44 views.

"Could not find the UI element corresponding to this selector" made by @Ram_Gurav1 with 40 views.

Need LINQ expression for multiple Group by made by @Marian_B with 38 views.

Top 3 Topics with Most Replies

Need LINQ expression for multiple Group by made by @Marian_B with 22 replies.

DateTime data insert to sql server made by @Shyam_Pragash with 18 replies.

How to extract table in PDF file made by @minal.patil with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 119 posts!

@Yoichi made 48 posts!

@Gokul001 made 39 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

ブラウザのタブをアクティブ化

こんにちは Activateアクティビティ 検証しましたがうまくいきませんでした。 どのように設定していますでしょうか？ 最も単純には、ブラウザをアタッチで、当該タブ(タイトル)を指定して、その中に何も設定しないアクティベートアクティビティを設置するだけで動作すると思います。 [image] 動作原理的に、入力方式をSimulateType/ClickやChromimuAPIを使えばアクティブかどうかは無関係で動作します。(SelectItemも同様です）Default(HardwareEvent)を使う場合はアクティブ化は必須になります。

This post made by @ppr received 2 likes!

How to convert this ISO time format PT1M16.87S to seconds in studio

[grafik]

This post made by @Yoichi received 2 likes!

Is it illegal to use the community version at work?

HI, First, perhaps you should check license term of Community Agreement In the latest, it says as the following. So if your purpose is profit purpose, you cannot use it. [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

How to convert this ISO time format PT1M16.87S to seconds in studio

[grafik]

This solution provided by @Yoichi received 2 likes!

Is it illegal to use the community version at work?

HI, First, perhaps you should check license term of Community Agreement In the latest, it says as the following. So if your purpose is profit purpose, you cannot use it. [image] Regards,

This solution provided by @Anil_G received 1 likes!

How Can I Filter a Long TXT File

Hi @Burak_Baris_Gologlu My bad . This is the regex to use System.Text.RegularExpressions.Regex.Matches("YourString","T\.C\. SAKARYA.*T\.C\.") And your matchcol variable should be of type Matchcollection [image] Adding .ToString will not work . Change the variable type as shown above 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 | 29 November 2022

Top 3 Topics with Most Views

How to solve: 0 (zero) gets truncated with the number beginning with 0 in my output excel file made by @Sisay_Dinku with 63 views.

代入アクティビティでキャスト例外 made by @shunsuke.ogata with 51 views.

How to extract the table using Regex or String Manipulation made by @sunilkanth with 43 views.

Top 3 Topics with Most Replies

Can I Use Read Cell Activity To Output String Type Only? made by @Hendaryie_Tjoeng with 23 replies.

How to solve: 0 (zero) gets truncated with the number beginning with 0 in my output excel file made by @Sisay_Dinku with 21 replies.

InvokeWorkflowFile activity Issue UiPath.System.Activities 22.10.1 version or higher made by @satchauhan with 21 replies.

Top 3 Users Who Posted The Most

@Anil_G made 121 posts!

@Gokul001 made 60 posts!

@Yoichi made 36 posts!

Top 3 Most Liked Posts

This post made by @ppr received 4 likes!

String Manipulation from heLLo WOrLd to HEllO woRlD

on of a few options: [grafik] String.Join("",YourStringVar.Select(Function (x) If(Char.IsLower(x), x.tostring.toupper, x.toString.tolower)))

This post made by @yrobert received 2 likes!

The "modern" activities don't make sense

Hi Since we work most of the time on a test environment when we create the automation, the window selectors won’t work on the production environment. SImple reason, the window selector has a different title in test environment or even app name. So we need to change every window selector. With modern, it implies a lot of additionnal work. Even anchors and verifiy part of click/type activities have their own window selector that we need to adapt → this means 3 Window selector to adapt. It is ju…

This post made by @sangeethaneelavannan1 received 2 likes!

How to show a message box, stating the total invoice value?

@how2awpp Welcome to uipath community. Yes ,you can use message box [image] here totalinvoicevalue is the variable

Top 3 Most Liked Solutions

This solution provided by @ppr received 4 likes!

String Manipulation from heLLo WOrLd to HEllO woRlD

on of a few options: [grafik] String.Join("",YourStringVar.Select(Function (x) If(Char.IsLower(x), x.tostring.toupper, x.toString.tolower)))

This solution provided by @ppr received 2 likes!

How to handle "The source contains no datarows" exception?

@Sami_Rajput With the DataTableVar.Select Method we can do it similar in_DT_to_filter.Select("[Date] > '"+in_Date+"'").ToList

This solution provided by @Gokul001 received 1 likes!

Read Specific Tet from Text File

HI @prerna.gupta Check out this XAML file TextFileRegex.xaml (9.0 KB) [image] [image] Regards Gokul

---

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

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

[system]

Daily Forum Report | 30 November 2022

Top 3 Topics with Most Views

Uipath practice Test Question made by @Aima_Arif with 49 views.

GetCurrentJobInfo-->WorkflowFullPath as a property made by @jeevith with 37 views.

Error not solving made by @taruna.mehra with 37 views.

Top 3 Topics with Most Replies

When trying to Invoke a Ref process from a flowchart workflow, "Could not find part of the path '....../GetTransactiondata.xaml' error made by @Rajeena_M with 25 replies.

範囲に書き込みをしようとするとエラーになる made by @miwa_yamamoto with 24 replies.

I have upgraded some packakes and now my WF does not recognizes some actyvities made by @tomaz with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 84 posts!

@Gokul001 made 60 posts!

@Yoichi made 42 posts!

Top 3 Most Liked Posts

This post made by @Emerald received 2 likes!

GetCurrentJobInfo-->WorkflowFullPath as a property

Thanks, @Konrad_Mierzwa. For all others, below is the code for the custom activity. using System.Activities; using System.ComponentModel; using UiPath.Robot.Activities.Api; namespace UiPath.Workflow.Information { [Category("Custom Activities.Workflow")] [DisplayName("Get Workflow Path")] public class GetWorkflowPath : CodeActivity { [Category("Output")] public OutArgument<string> Output { get; set; } protected override void Execute(CodeActivityContext …

This post made by @sangeethaneelavannan1 received 2 likes!

Selecting combobox by using value inside excel row

Hi @Miracle_Vernawan Welcome to the UiPath community If you do not want to use a select element, you can use one-click activity to click on the dropdown field and another click activity to select the item.

This post made by @Gokul001 received 2 likes!

Selecting combobox by using value inside excel row

Hi @Miracle_Vernawan Can you share the error message here? Try to use in_TransactionItem.Specificcontent("Plant Code").Tostring Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Studioxにて各行の繰り返し処理を各シートで実行する方法

こんにちは StudioXの場合、デバッグ機能が弱いので、必要な情報を適当なタイミングで出力することにより 原因を探ることになると思います。 シートの指定は Index_From_For_Each で行ているように思えますので、 まずはその数値がインクリメントされているかを確認するためにループ中で 1行書き込みで書き出してみる それが問題なければ、シート名が正しいかを確認するために SheetsOfExcelA(Index_From_For_Each) の内容を書き出してみる 等のアプローチになると思います。

This solution provided by @Anil_G received 1 likes!

Error in creating a custom input dialog box

Hi @Prathyai_K Try changing the system activities package version Please check this Cheers

This solution provided by @Shyam_Pragash received 1 likes!

DateTime data insert to sql server

Hi @Anil_G @RajKumar_DC Thanks All Finally we found the soluation to import Null data with specificed variable types in sql server. If ( String.IsNullOrEmpty(Exl_Created_At), New Nullable(Of Date), System.Convert.ToDateTime(Exl_Created_At)) Variable Type : Nullable.System.Datetime Thanks Shyam

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

@Gokul001 received 90 likes for their solutions!

@Yoichi received 71 likes for their solutions!

@ppr received 36 likes for their solutions!

---

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

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

[system]

Daily Forum Report | 01 December 2022

Top 3 Topics with Most Views

To change date format in dd/mm/yyyy made by @pankajmohan.dhane with 40 views.

Error Related to Write in Excel made by @YUDISTIRO_Evan with 38 views.

Solution for excel Columns made by @supu123 with 38 views.

Top 3 Topics with Most Replies

Background Process - Access Denied To Path made by @omer.ozturk with 16 replies.

Robot doesn't exist made by @Imene_ZARAI with 16 replies.

Encode "65001: Unicode (UTF-8)" to "932: Japanese (Shift-JIS)" made by @Chendoran_M with 15 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 48 posts!

@Anil_G made 41 posts!

@Yoichi made 27 posts!

Top 3 Most Liked Posts

This post made by @GuyVW received 1 likes!

UiPath Integration Service Launches Connector Builder in Public Preview!

@Roman_hruska sincere apologies for the late response. We actually had taken in your entire example and discussed this in lots of detail internally. Building similar examples out to see what the behavior was and if there’s anything we could do to address this in its current version. Unfortunately… the short answer is: currently not supported in Preview by the Connector Builder Activity Pack. Technical reasoning behind this is that we are flattening some of this detail behind the scenes that then…

This post made by @bobzbobz received 1 likes!

Activity 'Execute Macro' has no timeout?

I agree, but also think that UiPath should be able to handle timeout in case of badly made macros. In my own particular case I have nothing to do with the macros, I only handle results based on activation of those.

This post made by @arivu96 received 1 likes!

Activity 'Execute Macro' has no timeout?

Hi @bobzbobz , Currently this options is not available. @uipath Need to implement this logic in this activity. Regards, Arivu

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

PowerShell を呼び出し: 引数 '-' を受け入れる位置指定パラメーターが見つかりません。

こんにちは 最初のc:\の手前にダブルクオーテーションを２つ "cd ""C:\ 最後のダブルクォーテーションと）の間にダブルクオーテーションを２つ )""" それぞれ挿入してみてください

This solution provided by @sangeethaneelavannan1 received 1 likes!

Selector of ">" the caractére greather than

@nora_ziani Wildcard ? ( If it is single character)Or * (more character)Will make it dynamic

This solution provided by @Gokul001 received 1 likes!

SQL Run query showing error while run the process

HI @SURESH_P The given value is empty. Or Your variable or argument is not passed correctly. Can you check all the values that are passed in the Run query activity. Regards Gokul

---

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

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

[system]

Daily Forum Report | 02 December 2022

Top 3 Topics with Most Views

Building intelligent automations - adding AI to RPA workflows made by @shivaraman_shankar with 48 views.

Assign Integer Value to XML made by @ram_dhas with 43 views.

How add text in variables made by @beginnerui with 41 views.

Top 3 Topics with Most Replies

I want to read the yesterday data from master file which is in .xaml format can anyone help me on it made by @Tea_coffie_235 with 20 replies.

Question of excel made by @purnima_mandan with 15 replies.

Assign Integer Value to XML made by @ram_dhas with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 48 posts!

@Anil_G made 23 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @GT_Ropa received 1 likes!

New Dictionary(Of Srting,Srting) コンフィグファイルを読み込ませる際のエラー

@H_U お疲れ様です。 Assignのところで [image] ちょびっとデータタイプの名前を間違えました。 「Srting」ではなくて、「String」です。 それを試してみてください。 New Dictionary(Of String, String) どうぞよろしくお願いいたします。

This post made by @H_U received 1 likes!

New Dictionary(Of Srting,Srting) コンフィグファイルを読み込ませる際のエラー

ありがとうございました！ 気づくことができなかったので、とても助かりました！

This post made by @Gokul001 received 1 likes!

转换为Windows版本后input Dialog报错

Hi @cindy.zhou Welcome to uipath community Can you try to Re enter the value in the Text box. It is because if the Double Quotation issue "" Check out this thread Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @GT_Ropa received 1 likes!

New Dictionary(Of Srting,Srting) コンフィグファイルを読み込ませる際のエラー

@H_U お疲れ様です。 Assignのところで [image] ちょびっとデータタイプの名前を間違えました。 「Srting」ではなくて、「String」です。 それを試してみてください。 New Dictionary(Of String, String) どうぞよろしくお願いいたします。

This solution provided by @Gokul001 received 1 likes!

转换为Windows版本后input Dialog报错

Hi @cindy.zhou Welcome to uipath community Can you try to Re enter the value in the Text box. It is because if the Double Quotation issue "" Check out this thread Regards Gokul

This solution provided by @Yoichi received 1 likes!

Help what data type should I use when I have numbers or currency?

Hi, Can you try the following? [image] Double.Parse(yourString).ToString("N2") Regards,

---

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

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

[system]

Daily Forum Report | 03 December 2022

Top 3 Topics with Most Views

Condition to check if array is empty or null made by @Ray_Sha1 with 37 views.

How can you "kill" a certain window on an application? made by @tomato25 with 37 views.

How could I get the value of each row in this workflow? made by @pprin001 with 35 views.

Top 3 Topics with Most Replies

How to use select item activity made by @harshikakhatri269 with 10 replies.

Does Re-Framework template in C# exist? made by @wilbardmtei with 7 replies.

Count At_Kt as 1 if subject Mark is less than 40 and calculate total nos of At_Kts. Eg: If any student has less then 40 marks in 2 Subject then ATKT count is 2 ,If any student has less then 40 marks in 3 subject then ATKT count is 3 .......not get result made by @sohil_bagwan with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 13 posts!

@Gokul001 made 10 posts!

@Rahul_Unnikrishnan made 9 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

Click activity is not working to toggle button ON & OFF in chrome (Uipath's Orchestrator turning license ON and OFF buttons)

Hi @Hariram_Narayanan Welcome to the community You can try using orchestrator API’s for this [image] API Reference - API References cheers

This post made by @Hariram_Narayanan received 1 likes!

Click activity is not working to toggle button ON & OFF in chrome (Uipath's Orchestrator turning license ON and OFF buttons)

Thank you Anil, that is so cool! I’m really excited to try it out.

This post made by @SrenivasanKanna received 1 likes!

AI Center Pipeline Version Accuracy Issues

Thank you so much, i got it.

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 | 04 December 2022

Top 3 Topics with Most Views

Splitting Error made by @MHarakeh with 41 views.

How to use "Build collection activity"? made by @Rawan_Ghurab with 37 views.

How to extract details from PDF to Excel made by @SURESH_P with 33 views.

Top 3 Topics with Most Replies

Empty path name is not legal in global variable made by @Riya_Bansal with 20 replies.

Problem with my automation made by @Nur_Amin with 11 replies.

For each row & Add data row : Collection was modified; enumeration operation might not execute made by @Lakshya_Garg2 with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 19 posts!

@Yoichi made 16 posts!

@Swaroop_Singh_R made 7 posts!

Top 3 Most Liked Posts

This post made by @Jair_Warrior received 1 likes!

La comunidad HispanoHablante diga Hola aca!

Saludos a todos.

This post made by @Swaroop_Singh_R received 1 likes!

Condition to check if array is empty or null

Hiiii @Ray_Sha1 you can use arr1.count=0 in condition sooo that you can able to get empty array [image]

This post made by @Anil_G received 1 likes!

Click activity is not working to toggle button ON & OFF in chrome (Uipath's Orchestrator turning license ON and OFF buttons)

@Hariram_Narayanan From the api reference you can see the swagger file which will have full details about the api input format and all…if that is what you are looking for Orchurl + swaager/index.html would give you the way it has to be used This is the activity where you will pass those api requests in process https://docs.uipath.com/activities/docs/orchestrator-http-request [UiPath Orchestrator API Using Orchestrator HTTP Request Activity | Part 1 | Overview & Demo] Cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Click activity is not working to toggle button ON & OFF in chrome (Uipath's Orchestrator turning license ON and OFF buttons)

@Hariram_Narayanan From the api reference you can see the swagger file which will have full details about the api input format and all…if that is what you are looking for Orchurl + swaager/index.html would give you the way it has to be used This is the activity where you will pass those api requests in process https://docs.uipath.com/activities/docs/orchestrator-http-request [UiPath Orchestrator API Using Orchestrator HTTP Request Activity | Part 1 | Overview & Demo] Cheers

This solution provided by @Anil_G received 1 likes!

Reframework error#

Hi @bakrious12 Where you are reading guid from that xaml the guid should be out and where you are trying to set the guid value to queue in that xaml guid should be in In your xaml change the argument guid direction for random name make it as IN And not sure why you are trying to fill infodt twice once in both xaml. because the second one will over right the first one Is that clear? cheers

This solution provided by @Yoichi received 1 likes!

Get outlook mail messages activity not found

Hi, All right. For now can you try to turn on “ShowDeveloper” at Filter in Activities panel? Then we can use GetOutllokMailMessages activity as the following. [image] Regards,

---

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

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

[system]

Daily Forum Report | 05 December 2022

Top 3 Topics with Most Views

What do we need to get a job in UiPath made by @Vajrang with 76 views.

How can I copy name, email, and phone number from excel into outlook contact WITHOUT ForEach? made by @Lior_Shamir with 51 views.

Finding the similar columns between two different sheets made by @Rawan_Ghurab with 46 views.

Top 3 Topics with Most Replies

Finding the similar columns between two different sheets made by @Rawan_Ghurab with 21 replies.

What do we need to get a job in UiPath made by @Vajrang with 19 replies.

How can I copy name, email, and phone number from excel into outlook contact WITHOUT ForEach? made by @Lior_Shamir with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 78 posts!

@Gokul001 made 53 posts!

@Yoichi made 23 posts!

Top 3 Most Liked Posts

This post made by @Vajrang received 19 likes!

What do we need to get a job in UiPath

you can post questions that you are asked in the interview. post any challenges that you are asked to solve in the program

This post made by @Gokul001 received 6 likes!

Monthly Forum rewards - November 2022

Congrats to all the winner

This post made by @Sudharsan_Ka received 3 likes!

Monthly Forum rewards - November 2022

Congrats to all

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Can we declare global variables for invoke code in Uipath

Hi @Riya_Bansal Assigning a global variable to arguments in invoke code is not working? If so you can try assigning to local Variable and use assign activity next to assign that to global variable Cheers

This solution provided by @Yoichi received 1 likes!

エクセルのドロップダウンリストを選択する方法について

こんにちは データの入力規則の機能によるドロップダウンでしょうか？ セル書き込みアクティビティを使えば、任意の値を書き込めますので、 選択する予定の値を直接書き込んでみてください。 [image]

This solution provided by @Gokul001 received 1 likes!

How to Contains Help

Hi @punnipah Try with this expression if(System.Text.RegularExpressions.Regex.Replace(Currentitem.Subject.Tostring,"\W","").Contains("SubjectLCMS"),"S") Regards Gokul

---

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 December 2022

Top 3 Topics with Most Views

Please provide me code that accepts user input and displays input along with welcome message made by @Vajrang with 83 views.

Definition & Execution of Business Rules for Fields (mandatory, possible values & fixed format rules) made by @Monica_Secelean with 61 views.

row.item().ToString に関して made by @wataru.K with 43 views.

Top 3 Topics with Most Replies

How do I isolate these values as within a PDF? made by @dr1992 with 26 replies.

Excel Application Scope Error but It Doesn't Have This Error Before made by @BBCC_0000 with 21 replies.

How to divaded one number to digits and save every digit in variable made by @mironb with 20 replies.

Top 3 Users Who Posted The Most

@Anil_G made 116 posts!

@Rahul_Unnikrishnan made 59 posts!

@Yoichi made 38 posts!

Top 3 Most Liked Posts

This post made by @Vajrang received 12 likes!

Please provide me code that accepts user input and displays input along with welcome message

Task 1, Sequence Task: Based on the input we should get the welcome message Step: 1 Add Input Dialog Box and give the input Step 2: Add Message box to display a message Projects Deploy it in orchestrator Execute from orchestrator

This post made by @Monica_Secelean received 8 likes!

Definition & Execution of Business Rules for Fields (mandatory, possible values & fixed format rules)

In order to paint the full picture of a Document Type, together with information which is not necessarily available in the document itself, we have added the ability to provide additional information about it. In this effort, I’m happy to report, we started enriching the Document Type with Business Rules, on a Field Level, staring with the Intelligent OCR package version 6.6.0-preview. These rules need to be respected by the extracted field values, in order for the extraction to be consi…

This post made by @StefanSchnell received 4 likes!

Monthly Forum rewards - November 2022

Congratulations to all the winners and thank you for your effort.

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

Database activity 2022.10.3

Hi @Sandhya_Gajare Executes a SQL statement on a database, For Update, Insert delete statement we can use Run command activity Run Query will returns the query result in a DataTable

This solution provided by @raja.raviraj received 1 likes!

Is there any way i can identify the name of the current test case during run time

yep this works. Thanks much !!!

This solution provided by @Anil_G received 1 likes!

Combine two Google Sheets into one?

Hi @Josh_James create a second datatable and after retreiving the data using read range do a merge datatable on to the second datatable in the loop. So that the second time the first dt gets over written and the merge will merge it with the previous data which is already present in it This is how it looks [image] I added dt1.clone when the loop starts or for the first iteration because we need to give a structure to the second dt2 before performing merge Hope this is clear 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 | 07 December 2022

Top 3 Topics with Most Views

How to Add data column with values made by @Abdul_Khaliq1 with 39 views.

Extract Data from Browser made by @Pravin_S with 35 views.

Community版をインストールしているはずなのにEnterprise版になってしまう made by @emi.h8gj.nakajima with 34 views.

Top 3 Topics with Most Replies

Community版をインストールしているはずなのにEnterprise版になってしまう made by @emi.h8gj.nakajima with 17 replies.

How to Add data column with values made by @Abdul_Khaliq1 with 13 replies.

VBAのエラークリック made by @chiikawausagi with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 86 posts!

@Yoichi made 25 posts!

@sangeethaneelavannan1 made 15 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Community版をインストールしているはずなのにEnterprise版になってしまう

こんにちは Enterprise のFreeプランですので、利用可能なライセンスはAutoamtion Expressだけになります。 StduioXは使用できますが、Studioは使えないので、Studioを使いたいならCommunityプランが 必要になると思います。（あるいはProを購入するかですが．．．．） 基本的に、StudioがCEかEnterpriseになるかはご推察の通り、AutomationCloud上のプランに依存しますので、今の組織を削除→再作成か、あるいは別のメールアドレスがあるなら、新たに作り直した方が早いかもしれません。

This post made by @Lior_Shamir received 1 likes!

How can I copy name, email, and phone number from excel into outlook contact WITHOUT ForEach&ReadRange - when the excel file is closed?

@gustavo.cervelin Gustavo, you are the best! Thank you for all the help and the good vibes. You did a lot for me Waiting for you in Israel and hope Brazil win the world cup!!

This post made by @Koushik_tatikondawar received 1 likes!

How to execute just 1 time the for each row based on comparing the first "for each" value with the second "For each"

Hello @pprin001, " (CurrentRow(“Nombres”).ToString).Contains((CurrentRow1(“Nombres”).toString).substring(5))" CurrentRow(“Nombres”).ToString = “Planillas_BcoBci20" CurrentRow1(“Nombres”).toString = "Banco BCI” Reference - Str1.Contains(Str2) The expected output for the above code snippet is False, because the .Contains method checks if the entire string “Str2” occurs within “Str2”. I guess you are assuming it would also be checking if all the possible substrings of “Str2” will also be check…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Community版をインストールしているはずなのにEnterprise版になってしまう

こんにちは Enterprise のFreeプランですので、利用可能なライセンスはAutoamtion Expressだけになります。 StduioXは使用できますが、Studioは使えないので、Studioを使いたいならCommunityプランが 必要になると思います。（あるいはProを購入するかですが．．．．） 基本的に、StudioがCEかEnterpriseになるかはご推察の通り、AutomationCloud上のプランに依存しますので、今の組織を削除→再作成か、あるいは別のメールアドレスがあるなら、新たに作り直した方が早いかもしれません。

This solution provided by @Koushik_tatikondawar received 1 likes!

How to execute just 1 time the for each row based on comparing the first "for each" value with the second "For each"

Hello @pprin001, " (CurrentRow(“Nombres”).ToString).Contains((CurrentRow1(“Nombres”).toString).substring(5))" CurrentRow(“Nombres”).ToString = “Planillas_BcoBci20" CurrentRow1(“Nombres”).toString = "Banco BCI” Reference - Str1.Contains(Str2) The expected output for the above code snippet is False, because the .Contains method checks if the entire string “Str2” occurs within “Str2”. I guess you are assuming it would also be checking if all the possible substrings of “Str2” will also be check…

This solution provided by @Lior_Shamir received 1 likes!

Invoke VBA - Write to cell

Hi @Anil_G @gustavo.cervelin The problem was the date.Now.ToString So, the correct way is: Function DateAndTime(RowToRead as string) Sheet1.Range(“F”+RowToRead).Value = Now End Function 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 | 08 December 2022

Top 3 Topics with Most Views

Send Exchange Mail Message: No server address provided error made by @julian_ho with 63 views.

Get marks count with percentage made by @Vajrang with 58 views.

Studio 22.10 Microsoft.Activities.Extensions Add To Dictionary defaulting to Dictionary(of Object, Object) at compile made by @GT_Ropa with 47 views.

Top 3 Topics with Most Replies

Send Exchange Mail Message: No server address provided error made by @julian_ho with 28 replies.

How to get row index based on location? made by @JustZaffan with 24 replies.

Excel write range :current date and time made by @Kuldeep_Pandey with 21 replies.

Top 3 Users Who Posted The Most

@Anil_G made 119 posts!

@Yoichi made 37 posts!

@sangeethaneelavannan1 made 32 posts!

Top 3 Most Liked Posts

This post made by @Vajrang received 7 likes!

Get marks count with percentage

please give me code to get total for each person Names RollNo English Maths Hindi Science Social Total Percentage Kiran 1 20 21 23 20 21 Akhil 2 21 22 24 21 22 Ani 3 19 20 22 19 20 Sri 4 14 15 17 14 15 Jaya 5 13 14 16 13 14 Kavya 6 22 23 25 22 23

This post made by @Emira received 3 likes!

UiPath is launching a new initiative: UiPath Digital Credentials

Great News!

This post made by @nikhilesh578 received 3 likes!

UiPath is launching a new initiative: UiPath Digital Credentials

Great News

Top 3 Most Liked Solutions

This solution provided by @Naveen_Mohandas received 2 likes!

Get marks count with percentage

inputDt.Columns(“Total”).Expression=“English+Maths+Hindi+Science+Social”

This solution provided by @Anil_G received 1 likes!

Im getting total 12 matches numbers from the regex but i only want the even number

Hi @sathish_Kumar6 Loop through the 12 matches in a for loop in the for loop properties there is property index create a int32 type variable(var1) and assign to it Then use a if condition inside (Var1 mod 2) = 0 On then side You will have all odd set On else side You will have all even set Cheers

This solution provided by @Anil_G received 1 likes!

User defined package sources is not showing in Manage Packages

Hi @anil_shaw Is the package developed in Windows Legacy ? and current is your project on Windows? then you won’t see the package Open a New project and select Windows Legacy and then check the packages [image] 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 | 09 December 2022

Top 3 Topics with Most Views

How to convert a string to date made by @Chendoran_M with 49 views.

Comparacion de tablas con mas de 100.000 registros made by @RPA_Trgasa with 44 views.

Wanted to Add to Queue Items in orchestrator from Data table made by @Sisay_Dinku with 38 views.

Top 3 Topics with Most Replies

How to convert a string to date made by @Chendoran_M with 11 replies.

Matching id with ignoring 1 character made by @ldiaz with 11 replies.

How to get only date from the complete date? made by @harshikakhatri269 with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 83 posts!

@Gokul001 made 35 posts!

@Yoichi made 23 posts!

Top 3 Most Liked Posts

This post made by @Kaviyarasu_N received 2 likes!

UiPath is launching a new initiative: UiPath Digital Credentials

It looks Awesome

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

UiPath is launching a new initiative: UiPath Digital Credentials

That’s a great news!!!

This post made by @BReddy_m received 2 likes!

How to retrieve all successful transaction items from orchestrator Queue?

I have queue and completed all transactions some or failed and other items are succeeded, I need the report only for successful transaction items and send in the excel sheet to business people, Can please anyone help on this.?

Top 3 Most Liked Solutions

This solution provided by @raja_ias received 2 likes!

Send hotkey for Space?

Use " "=> in the key field

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

How to retrieve all successful transaction items from orchestrator Queue?

Hi @BReddy_m Use an activity called Get queue item And there in properties kindly pass your queue name and select your desired state ( successful) U can select the queue item status from the properties and select the successful item only which gives you the list of queue items which are processed successfuly

This solution provided by @Anil_G received 1 likes!

How to extract two zip file and determine the difference of each text inside on a config file?

Hi @wally.cariaga Use unzip activity to unzip it extracts everything out…Now use for each file folder which has an option to include files in sub folders as well and you will be able to get all the sub folder related files as well Then use Directory.Getfiles for second zip file contents and give the filter as the file name required if found then read the file and split the extracted string using new lien character and compare both the arrays …if there are difference print them [image] [ima…

---

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 December 2022

Top 3 Topics with Most Views

How to add semicolon after each value in email address column made by @vielesh with 56 views.

Add 0 in the beginning of a mobile number if the mobile number only has 9 digits and starts with 4 made by @ammohan with 54 views.

Need to remove duplicates on single column made by @manojmanu.rpa with 51 views.

Top 3 Topics with Most Replies

How to remove special characters in excel data table like for one sheet made by @sathish_Kumar6 with 6 replies.

Need to remove duplicates on single column made by @manojmanu.rpa with 6 replies.

I have a excel in which after opening the sheet user will find the grade which is “F19,010” and under this grade it will find the location as “Mumbai” and fetch the value for the same grade under Mumbai City made by @Prathamesh_Chavan with 5 replies.

Top 3 Users Who Posted The Most

@Anil_G made 21 posts!

@Yoichi made 12 posts!

@Rahul_Unnikrishnan made 11 posts!

Top 3 Most Liked Posts

This post made by @shesherao.patil received 1 likes!

How to use casesensitive attribute in selectors for Select Item Activity?

Its working thanks a lot for your fine solution

This post made by @Yoichi received 1 likes!

How to use casesensitive attribute in selectors for Select Item Activity?

Hi, Can you try to add .Replace(" “,”") as the following? strSelect = options.Split(vbCrLf.ToCharArray,StringSplitoptions.RemoveEmptyEntries).Where(Function(s) s.ToLower.Replace(" ","")=strTarget.ToLower.Replace(" ","")).FirstOrDefault Regards,

This post made by @Anil_G received 1 likes!

How to remove special characters in excel data table like for one sheet

Hi @sathish_Kumar6 Perform a for each row in excel and then use currentRow("Columnname") = System.Text.RegularExpressions.Regex.Replace(currentRow("Columnname").ToString,"[^a-zA-Z0-9\s]","") This will replace all values except the specified which are alphabets numbers and spaces Cheers

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to use casesensitive attribute in selectors for Select Item Activity?

Hi, Can you try to add .Replace(" “,”") as the following? strSelect = options.Split(vbCrLf.ToCharArray,StringSplitoptions.RemoveEmptyEntries).Where(Function(s) s.ToLower.Replace(" ","")=strTarget.ToLower.Replace(" ","")).FirstOrDefault Regards,

This solution provided by @Anil_G received 1 likes!

How to remove special characters in excel data table like for one sheet

Hi @sathish_Kumar6 So in the regex cap is for ignore the next characters and what characters i gave are alphabets(a-z and A-Z) , numbers (0-9) , any space characters(\s) .so ignoring these characters all other characters will be replaced [image] If you wnat to do for all columns then i would suggest read the data into a datatable and then use for loop on row and another loop on column inside the row loop and replace it Then write back the data Other way is to do with linq queries but aga…

This solution provided by @Yoichi received 1 likes!

画像の合成処理を代入で処理

こんにちは 返り値がないメソッドを呼ぶときはInvoke Method(メソッド呼び出し）アクティビティを使用する必要があります。 例えば以下になります。 [image] なおGraphics.DrawImageには上記の組み合わせの引数はないと思いますので、 コールする内容は見直したほうが良いように思えます。 詳しくは以下を参照ください。

---

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 December 2022

Top 3 Topics with Most Views

Type into element can't execute made by @mironb with 48 views.

How to delete rows excel that contain unwanted data made by @Nur_Amin with 36 views.

Do I need to have an Unattended bot to use start job and get reference? made by @testbb with 31 views.

Top 3 Topics with Most Replies

How to do Nested For Each Excel Row made by @YUDISTIRO_Evan with 9 replies.

Type into element can't execute made by @mironb with 8 replies.

How to delete rows excel that contain unwanted data made by @Nur_Amin with 6 replies.

Top 3 Users Who Posted The Most

@Yoichi made 11 posts!

@Anil_G made 11 posts!

@purnima_mandan made 6 posts!

Top 3 Most Liked Posts

This post made by @Shubham_Varshney received 1 likes!

Your Automation Community Journey 2022 in Review

Submitted

This post made by @Pravin_S received 1 likes!

Auto iterate through each column

Thanks @Anil_G & @Yoichi

This post made by @testbb received 1 likes!

How To filter Not Null vaulue in dt.select

thank you!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

画像のトリミング

こんにちは このエラーの意味はRectangleが System.Drawing.Rectangle DocumentFormat.OpenXml.Vml.Rectangle のどちらか特定できない旨の内容になります。 解消方法としては New System.Drawing.Rectangle(139, 90, 1024, 1599) と名前空間付きで表記し、どちらのクラスかを明確化すると 良いかと思います。

---

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 December 2022

Top 3 Topics with Most Views

How can i get this? made by @aparna30 with 63 views.

Is there any way to check if there are same file name existing in different zip file? made by @fniedez with 40 views.

Cannot find Add To Dictionary activity made by @Rakshith_VM with 40 views.

Top 3 Topics with Most Replies

Error for Filter DataTable made by @I_am_Praj with 24 replies.

Is there any way to check if there are same file name existing in different zip file? made by @fniedez with 18 replies.

Sort highest IEnumerable RegexMatch made by @uiStijn with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 73 posts!

@Yoichi made 36 posts!

@ppr made 18 posts!

Top 3 Most Liked Posts

This post made by @Kaviyarasu_N received 4 likes!

How can i get this?

Hi @aparna30 I will gave simple solution for this. The first one make as list. The list contains list= new List(of string)(new string(){“Apple_Fruit”,“Grapes”,"Banana”}) The second value make it as string datatype. it contains str = “Apple”. You need use this function list.contains(str) The result is false Please refer the below image [image] Hope you got the answer

This post made by @fniedez received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, I am new to UiPath, I am trying to do create a basic exercise and I am having some difficulty, so I decided to check out the forum. Thanks, France

This post made by @Kaviyarasu_N received 2 likes!

Your Automation Community Journey 2022 in Review

Submitted

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

How to add array to datatable

Hi @pravin_bindage I hope both array are of same length then directly us the below Use for each with in argument as enumerable.range(0,array1.count()-1).toarray and chnage type argument to int32 Use add datarow with array as {array1(currentitem),array2(currentitem)} Cheers

This solution provided by @Yoichi received 1 likes!

Regex match in one group

Hi, What is your expected output? Is it Mr? If so the following works [image] System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Driver\s+)\w+").Value If Mr TEST TESTING, the following will work. [image] System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Driver\s+).+").Value Regards,

This solution provided by @AkshaySandhu received 1 likes!

Get text activity in a parallel

@Povilas_Jonikas in array row use {stringTable,stringTable1}

---

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 December 2022

Top 3 Topics with Most Views

How to convert data variable get from "for each ui element" into datatable for database insertion? made by @hjie30 with 43 views.

Need help in sending API request made by @Learner007 with 41 views.

Compare string with excel column values made by @pravin_bindage with 39 views.

Top 3 Topics with Most Replies

Need help in sending API request made by @Learner007 with 24 replies.

How to convert data variable get from "for each ui element" into datatable for database insertion? made by @hjie30 with 18 replies.

Adding data into data table made by @Abdul_Khaliq1 with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 104 posts!

@Yoichi made 37 posts!

@sangeethaneelavannan1 made 30 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

Selectors are not editable

Hi, It’s because you use this inside OpenBrowser or AttachBrowser activity and top level selector is inherited from the activity. if you need to edit this, can you try to put the activity outside OpenBrowser or AttachBrowser, and indicate the target element, then edit. Regards,

This post made by @jack.chan received 1 likes!

Document understanding error while copying to a stream

i tried using machine learning extractor on a 27-page pdf and it threw this exception after a minute of waiting [image] but it works fine for smaller pdfs e.g. 1-10 pages

This post made by @Anil_G received 1 likes!

Document understanding error while copying to a stream

Hi @jack.chan It has some limitations. Please check this [image] cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Document understanding error while copying to a stream

@jack.chan Please check this…This can be thrown when the size is huge as well And also there is a per page pixel limit which might be exceeded as well. if you are getting the same exception multiple times …then try checking with lesser pages .That would give you an idea on the limit… If it occurred only once there might be some connection issues cheers

This solution provided by @Anil_G received 1 likes!

How to get numbers in correct format

Hi @mohamedalthaf Please check this cheers

This solution provided by @Anil_G received 1 likes!

Repeated files when using ForEachFileX activity

@camilacalderon I guess Include sub folders is checked both in foreachFolderX and in foreachfileX which makes each folder traverse twice…Please uncheck Include subfolders in FOreachFolderx loop and if you need check it only in the FOrEachFileX that way each folder is traversed only once [image] This the case where multiple files are coming 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 December 2022

Top 3 Topics with Most Views

Get all against unique value in row made by @sshitol with 41 views.

How to get Specific value using Matches activity? made by @Vaishnav_Tej with 38 views.

How to automate Captcha made by @Sankaraveni_M with 38 views.

Top 3 Topics with Most Replies

Each excel row activity made by @Nur_Amin with 18 replies.

OmniPage package error: made by @krishna_priya with 17 replies.

Get all against unique value in row made by @sshitol with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 81 posts!

@Yoichi made 41 posts!

@Gokul001 made 29 posts!

Top 3 Most Liked Posts

This post made by @Gokul_Jayakumar received 2 likes!

How to get Specific value using Matches activity?

Dowload the packages from manage packages UiPath.pdf.activities [image]

This post made by @Anil_G received 2 likes!

Is this available to automate this kind of workflow?

Hi @pprin001 Yes it is possible You can use table extraction to extract all the data as is from the website into a datatable Read the excel data into another datatble Run a loop on website datatable(dtweb)(in arguments assign index variable) Check if the index < dtexcel.rowcount-1 On then side check if data is present in excel daatatable by using if condition to check currentrow(0).tostring.trim.equals(dtexcel.rows(index).tostring this condition is for checking first column similarly you can…

This post made by @Anshdeep_Tyagi received 1 likes!

Activity Creator with .NET 6 Support is now released

Hi @mdiv Thankyou it is working fine now.

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Is this available to automate this kind of workflow?

Hi @pprin001 Yes it is possible You can use table extraction to extract all the data as is from the website into a datatable Read the excel data into another datatble Run a loop on website datatable(dtweb)(in arguments assign index variable) Check if the index < dtexcel.rowcount-1 On then side check if data is present in excel daatatable by using if condition to check currentrow(0).tostring.trim.equals(dtexcel.rows(index).tostring this condition is for checking first column similarly you can…

This solution provided by @Gokul_Jayakumar received 1 likes!

How to get Specific value using Matches activity?

Hello @Vaishnav_Tej Based on your input, we need to frame the regex condition. The document also should be in the desired format. For Regex need, share your input and expected output, it help us to provide you a better solution Kindly refer to this link, it may help you

This solution provided by @Anil_G received 1 likes!

Convert Word Files into PDFs without using Word Application Scope

Hi @DarDarSara Try using this [image] Dim MyApp As New Microsoft.Office.Interop.Word.Application MyApp.Visible = False Dim MyDoc As Microsoft.Office.Interop.Word.Document = MyApp.Documents.Open(InputFile.ToString) Mydoc.SaveAs(OutputFile.ToString, Microsoft.Office.Interop.Word.WdSaveFormat.wdFormatPDF) Mydoc.Close(Microsoft.Office.Interop.Word.WdSaveOptions.wdDoNotSaveChanges) MyApp.Quit() If you have all the word docs in Same folder and the destination filename is same as source filena…

---

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 December 2022

Top 3 Topics with Most Views

How to file type made by @manoj_verma1 with 48 views.

Scarping data from table made by @Shubham_Bidwai with 43 views.

No xaml files available when extracting from the nupkg package made by @Karthikeyan_CS with 41 views.

Top 3 Topics with Most Replies

Scarping data from table made by @Shubham_Bidwai with 24 replies.

ERROR HRESULT: 0x800700c1. open java application made by @Aguirre with 22 replies.

How to file type made by @manoj_verma1 with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 55 posts!

@sangeethaneelavannan1 made 36 posts!

@Gokul001 made 33 posts!

Top 3 Most Liked Posts

This post made by @sharon.palawandram received 3 likes!

UiPath is launching a new initiative: UiPath Digital Credentials

Saw many badges on LinkedIn and it looks awesome, another great initiative done!

This post made by @Anca_Bolca received 1 likes!

Definition & Execution of Business Rules for Fields (mandatory, possible values & fixed format rules)

Hello @sharon.palawandram Next to the search box you have a filter icon and from what I notice the “Include Prerelease” is not selected for you. Once you tick that filter you should be able to see and use our preview packages

This post made by @KavinduPerera received 1 likes!

UiPath Dev Dives - 2023 webinar series for developers

Cheers Very Excited to Join

Top 3 Most Liked Solutions

This solution provided by @arivu96 received 1 likes!

Converting Word File To PDF without using Word Application Scope

Hi @chilled_lad , Only those two option is there to convert word to pdf. you can create custom activity also but again the same code you are going to use to convert the word to pdf file. Regards, Arivu

This solution provided by @arivu96 received 1 likes!

How to find/match specific values in notepad?

Hi @Muralikrishna_Surve , Please use below xaml to extract the value. MultiplefilesRegex.xaml (7.6 KB) [image] Regards, Arivu

This solution provided by @Yoichi received 1 likes!

DTの集約について（任意の列の文字列が一致する行の合計）

こんにちは 空欄を0扱いにしてよいなら dt.AsEnumerable.GroupBy(Function(r) r("果物").ToString()).Select(Function(g) dt.Clone.LoadDataRow({cobj(g.Key)}.Concat(dt.Columns.Cast(Of DataColumn).Skip(1).Select(Function(dc) cobj(g.Sum(Function(r) if(Int32.TryParse(r(dc.ColumnName).ToString, new int32),CInt(r(dc.ColumnName).ToString),0))))).ToArray,False)).CopyToDataTable() になります。ただし上記はシート上０と表示されます。0の部分を空欄にする必要ありますでしょうか？

---

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

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