Forum Engagement Daily Reports

[system]

Daily Forum Report | 05 June 2023

Top 3 Topics with Most Views

Edgeブラウザで名前を付けて保存が選べない made by @minami with 91 views.

Not able to click on Save As pop up in edge browser made by @vishal_nachankar with 79 views.

Selectors inside inspect element stopped working after new chrome update made by @manojj.yadav with 54 views.

Top 3 Topics with Most Replies

Quick Question! made by @170290064 with 24 replies.

Hi please help me with extract types of clauses using regex in the given word made by @praveena.nadi with 20 replies.

Filter Data Table: the value for argument 'Column Name' is not set or is invalid, filter table issue made by @lakshmi.mp with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 86 posts!

@raja.arslankhan made 27 posts!

@Yoichi made 24 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Edgeブラウザで名前を付けて保存が選べない

@minami Open ui explorer and change the framework to active accessibility and then try to indicate the element [image] you can as well check the visual tree on the left to see if the element is identified or not…sometimes if if not identified it would be available in visual tree and you can select from there right click and use set as target element… cheers

This post made by @Yoichi received 2 likes!

Edgeブラウザで名前を付けて保存が選べない

もう少し深堀してみたところ、 最初はダウンロードの枠のみしか選択できない →そのまま枠をターゲット要素として選択 →アンカー選択時に内部の各要素を選択できるようになる →一旦アンカー含めて確定する →再度要素を取り直すと、以降は問題ないようです。 一度21.10の環境でも試してみてはと思います。

This post made by @Anil_G received 2 likes!

Ask where to save each file before downloading button isn't working anymore in google chrome

@Ush_Dhar Keep the activity which download the file inside a wait for downlod activity…and wait for download has a output which will give the file which is downloaded… [image] Also I have checked and you can use this selector change framework from ui explorer and it is working [image] <wnd app='chrome.exe' cls='Chrome_WidgetWin_1' title='Settings - Downloads - Google Chrome' /> <ctrl name='Settings - Downloads' role='document' /> <ctrl name='Ask where to save each file before downloading…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Edgeブラウザで名前を付けて保存が選べない

@minami Open ui explorer and change the framework to active accessibility and then try to indicate the element [image] you can as well check the visual tree on the left to see if the element is identified or not…sometimes if if not identified it would be available in visual tree and you can select from there right click and use set as target element… cheers

This solution provided by @arjunshenoy received 1 likes!

Relationship between the number of documents and the training time

Hi @Konrad_Mierzwa The number of data used in training a pipeline seems to be a factor that significantly increases the training time. Since the default epoch value is set to 100, some more factors such as the complexity of the document, its digitization & number of labels also make some impact. Using GPU will reduce this time but is gonna consume a lot of AI units depending upon your use case. Hope this helps, Best Regards.

This solution provided by @arjunshenoy received 1 likes!

How to get the datarow with the lowest value from datatable

Hi @richardvh, welcome to the Community. You can try this expression: DriverRow = dt_F1.AsEnumerable().OrderBy(Function(row) CInt(row("Points"))).First() The First() method to retrieve the first row from the sorted DataTable, which will be the DataRow with the lowest value in the Points column. Finally, we assign the result to the variable DriverRow. Edit: Output will be like- [image] Hope this helps, Best 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 | 06 June 2023

Top 3 Topics with Most Views

Broken selectors after Chrome/Edge update to version 114.0.1823.37 made by @Luiza_Surdu-Bob with 235 views.

UiPath Edge Extension can no longer sense or interact with the Save As Button within Edge PDF Viewer made by @taxguy33 with 88 views.

Active Accessibility(AA) is not available Suddenly made by @Kathiravan with 88 views.

Top 3 Topics with Most Replies

Problem with Browser Automation made by @Julian3 with 13 replies.

配列ないの値を分割したい made by @natsumikan with 12 replies.

Need to click the dynamic data on scroll box made by @sandhya.govindharam with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 60 posts!

@Yoichi made 38 posts!

@argin.lerit made 14 posts!

Top 3 Most Liked Posts

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

Broken selectors after Chrome/Edge update to version 114.0.1823.37

The latest Chrome and Edge updates (114.0.1823.37) introduced a breaking change to the way support for Active Accessibility is enabled. This causes automation processes to fail when trying to interact with the following browser screens: Print popup PDF viewer Observed behavior Following the browser update, it is no longer possible to identify web elements using Active Accessibility (AA) mode with UIAutomation activities. Example of selector that no longer works because of this issue: <wnd…

This post made by @karanpvsr received 3 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello Everyone, Good to be in the community, I am an IT Professional with 6+ years of work experience on various products alongside Solution Architecture of RPA (Robotic Process Automation) specifically in UiPath. I have graduate in my Masters in Management Information Systems at University at Buffalo Recently and I am looking for new opportunities where I can employ my expertise to create and contribute to automations based on UiPath in an organization. I hope I can learn and contribute furt…

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

Selectors inside inspect element stopped working after new chrome update

Hi, Just contacted UiPath support and they mentioned that after recent update for Google Chrome/Microsoft Edge (from old version to114.x.x.x) the selector which contains “< wnd >” and “< ctrl >” tags have stopped working. Then this means Active Accessibility support is broken and issue is from Chrome side. We can use --force-renderer-accessibility along with your URL or provide it as an argument to access those tags again in dev region. But the issue is, there are already running bots in produc…

Top 3 Most Liked Solutions

This solution provided by @postwick received 2 likes!

Get Email Query Categories

I believe you have to use categories/any not just categories. So… categories/any(a:a eq ‘BOT Pending’)

This solution provided by @Yoichi received 2 likes!

Edgeブラウザで名前を付けて保存が選べない

FYI 本件に関するナレッジベース公開された模様です。

This solution provided by @postwick received 1 likes!

How to convert the text file data to datatable or excel file?

Read Text File into a string variable. Split on VbCrLf + VbCrLf (basically split on every blank line) Now you have an array of the records. Then you can For Each through the array and split each one on VbCrLf. Using Add Data Row, your array(0) will be Name and array(1) will be Age. You can just use Replace to get rid of "Name " and "Age " each time.

---

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

Top 3 Topics with Most Views

Uipath stopped working on extensions? made by @Munish_Jain with 61 views.

After converting from windows legacy to windows changes made by @lakshmi.mp with 53 views.

Sum the amount if id is duplicate made by @adishjain with 53 views.

Top 3 Topics with Most Replies

Error in Linq .Need Help made by @dutta.marina with 22 replies.

I want to compare two values using regex made by @Bhushan_Nagaonkar with 19 replies.

Sum the amount if id is duplicate made by @adishjain with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 143 posts!

@Yoichi made 38 posts!

@prateek.mehandiratta9 made 30 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 4 likes!

Monthly Forum Rewards - May 2023

Congratulations everyone…keep up the good work. Cheers

This post made by @Sudharsan_Ka received 4 likes!

Monthly Forum Rewards - May 2023

Congrats All

This post made by @Matti_rajobit received 3 likes!

Broken selectors after Chrome/Edge update to version 114.0.1823.37

If someone needs desperate fix and downgrading chrome is not possible. I accidentally found out really weird fix for this. Fix: install and open Windows Accessibility insights. If you open Windows Accessibility insights on the background UiPath seems to be able to find the selectors. I have no idea how and why this works. Maybe this will help the team solve the problem. Disclaimer, I have only tried this on my local computer and one website. The version of Accessibility Insights I am using i…

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Make array of distinct Strings from a column in a data table that has values of type Integer and String

dt.AsEnumerable.Select(Function(row) row("WE").toString).Distinct.toArray The statement is doing this already

This solution provided by @Anil_G received 1 likes!

Need to click the dynamic data on scroll box

@sandhya.govindharam With mouse scroll may I know what element you used…it should exactly match witht he required element if not it will scroll till down Alternatelt use the mouse scroll with no of scrolls and then use click activity So basically you floe should be as below While loop with condition as true and max iteration as any number may be 40 Then element exists /check app state to check for the click element On the then side use click activity On the else side use mouse scroll The…

This solution provided by @Anil_G received 1 likes!

Issue on using the Active Accessibility UI Framework after Browser Upgrade

@Jerry1 Please check this. If using modern activities a work around is provided for now. If not downgrade the browser. UiPath is working on it and can use the workaround in the mean time 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 June 2023

Top 3 Topics with Most Views

On Element Appear! made by @170290064 with 55 views.

Date column error, Error 1899 made by @Sisay_Dinku with 47 views.

Fetch date from an application, and change it to the beginning of the next month in format( MM/DD/YYYY) made by @ayushi_jain3 with 45 views.

Top 3 Topics with Most Replies

Data from PDF to Excel made by @JwK with 53 replies.

Date column error, Error 1899 made by @Sisay_Dinku with 27 replies.

On Element Appear! made by @170290064 with 22 replies.

Top 3 Users Who Posted The Most

@Anil_G made 83 posts!

@prateek.mehandiratta9 made 57 posts!

@Yoichi made 51 posts!

Top 3 Most Liked Posts

This post made by @_Chuki received 2 likes!

Edge、Chromeをアップグレード(Edge:114.0.1823.37、Chrome:114.0.5735.91)すると、セレクター操作できない

ありがとうございました。 おかげさまで安心してパッチ適用の指示を出せますm(_ _)m

This post made by @kevinpscott received 2 likes!

23.4.2 bug no longer able to select Exceptions in Try/Catch

UPDATE! I have determined I can select an Exception Type by using tab to select the dropdown and using keys to select what I want. But as you can see, selecting it with the mouse no longer works.

This post made by @Bhushan_Nagaonkar received 2 likes!

I want to compare two values using regex

@Anil_G & @argin.lerit I tried using get ocr text and image region selection. It worked. Thanks for your time and effort.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Chromium APIの優先順位について

こんにちは 個人的には シミュレート＞ChromimuAPI＞ウインドウメッセージ＞ハードウェアイベント です。対応さえしていれば、シミュレートが速く正確なので最優先。 ChromiumuAPIは直接ブラウザとのやり取りで済みますので、他よりも精度は高い傾向になると思います。ただしGoogleChromeとEdgeにしか使えない制限はあります。 https://docs.uipath.com/ja/studio/standalone/2023.4/user-guide/input-methods

This solution provided by @Anil_G received 1 likes!

How to split string into array at the end of every line

@SRoyi Welcome to the community Please use this Arrayvar = str.Split({Environment.NewLine},Stringsplitoptions.RemoveEmptyEntries) Str is the string variable where the data is stored Cheers

This solution provided by @arjunshenoy received 1 likes!

Passing the Dynamic values to the body payload in HTTP PUT requests

Hi @srinusoft37 Seems like there are some syntax issues in the dynamic parsing of the data into the payload. Please try the following syntax & let us know if this works: "{""state"":""3"",""comments"":""" + StrValue + " Completed""}" Hope this helps, Best 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 | 09 June 2023

Top 3 Topics with Most Views

TYPE INTO ACTIVITY not typing made by @BHUVAN with 53 views.

Uipath studio objects binding issue made by @Harika_Mudiam with 51 views.

How to Decode base64 string value using uipath? made by @Thumu_Suresh with 46 views.

Top 3 Topics with Most Replies

Selector Issue while downloading the PDF's made by @Priyesh_Shetty1 with 40 replies.

TYPE INTO ACTIVITY not typing made by @BHUVAN with 24 replies.

I have encountered failures in my UiPath process in certain special cases made by @Sreeja_Chilumukuri with 24 replies.

Top 3 Users Who Posted The Most

@prateek.mehandiratta9 made 54 posts!

@Anil_G made 39 posts!

@Yoichi made 38 posts!

Top 3 Most Liked Posts

This post made by @Sneha_S_Ananda received 2 likes!

Broken selectors after Chrome/Edge update to version 114.0.1823.37

Hi, You would have to download the package version 21.10.9 & load it orchestrator or to your project nuget from the official UiPath feed

This post made by @alvin.c.apostol26 received 2 likes!

Regex for extracting string

Hi UiPath, let say I have 2 possibles strings below: 10-77349_PLS LOAD & GIVE ME PO#_APR&RETAILS. THANK YOU or 10-77349_PLEASE LOAD & GIVE ME PO#_APR&RETAILS. THANK YOU How can I manipulate it to have the output format below: 10-77349_APR&RETAILS

This post made by @sidra.zeeshan received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, My name is Sidra Zeeshan. I am here because recently I have started my work as RPA developer, and I am taking courses of UiPath certifications. Hope to have good time here Thanks, Sidra.

Top 3 Most Liked Solutions

This solution provided by @adiijaiin received 1 likes!

What is the purpose of Column* section in Add Data Column Activities?

Hi @lovepong66 This Column section would take a Variable of type DataColumn. Alternate way of creating a column inside a datatable. See this example, initially I had 3 columns in my dataTable. I have used DataColumn type variable ColumnName, assigned a value to it new DataColumn(“Column4”) And then used Add Data Column activity and passed that ColumnData Variable in here. [image] The outputs are as follows: [image] e

This solution provided by @Yoichi received 1 likes!

値を検索/置換のアクティビティについて

こんにちは 例えば以下のような感じでしょうか。 [image] NewBlankTask20230609-1.zip (107.8 KB)

This solution provided by @arjunshenoy received 1 likes!

Filter email body on specific line

Hi @Tengku_Aliff, welcome to the Community. You can simple read the email body & use the following RegEx pattern to extract the desired data: Ticket ref: (\w+\d+) [image] The corresponding UiPath Syntax will be: System.Text.RegularExpressions.Regex.Match(emailBodyString,”Ticket ref: (\w+\d+)”).ToString Hope this helps, Best Regards.emphasized text

---

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

Top 3 Topics with Most Views

UiPath Assistant for Excel add-in made by @Catalina_Ianus with 214 views.

Sort or Getting specific words that be included in specific value made by @hoseongwon with 58 views.

Convert Regex Result to String Variable made by @raychel.hall with 57 views.

Top 3 Topics with Most Replies

Date format issue of excel file made by @Cuberoot with 22 replies.

Type Into Error Field made by @dutta.marina with 15 replies.

웹사이트에서 다운로드 한 엑셀파일을 실행시키고싶습니다 made by @Jeongmin_Park with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 74 posts!

@Yoichi made 37 posts!

@prateek.mehandiratta9 made 35 posts!

Top 3 Most Liked Posts

This post made by @Catalina_Ianus received 6 likes!

UiPath Assistant for Excel add-in

We are glad to announce that we released UiPath Assistant for Excel, the new add-in that enables you to run your attended automations without leaving the Excel spreadsheet. So, whenever you need a robot’s help with structuring, analyzing, or updating data, you can simply open Assistant in the Excel panel and access all your Excel-related automations with no disruptions. The add-in can be accessed and downloaded as follows: Via a direct link from Microsoft AppSource By searching t…

This post made by @supermanPunch received 2 likes!

New Forms Activity Dictionaries Disabled after latest Update!

@AndyMenon , I guess this is an approved bug After updating my Studio to the latest version now, 23.4.2, I do have the same issue. And all the methods you mentioned as a work around does work. You could see that the Arguments Property is Locked in the below image and also the form Path is updated as well : [image] But again this happened only after I updated my Studio.

This post made by @adiijaiin received 2 likes!

ExcelReadRange Activity, custom range

Hi @dbukk Are there some more columns after G, which you don’t wanna read? If that is the case, please do the following, read the whole range starting from A3. Store it in a DataTable variable, retrieve the count of rows from here using ReadRowCount = datatablename.rowCount Then again use a read range activity: pass “A3:G”+ReadRowCount.toString. Thanks Happy Automation!

Top 3 Most Liked Solutions

This solution provided by @adiijaiin received 2 likes!

ExcelReadRange Activity, custom range

Hi @dbukk Are there some more columns after G, which you don’t wanna read? If that is the case, please do the following, read the whole range starting from A3. Store it in a DataTable variable, retrieve the count of rows from here using ReadRowCount = datatablename.rowCount Then again use a read range activity: pass “A3:G”+ReadRowCount.toString. Thanks Happy Automation!

This solution provided by @Harshith_Adyanthaya received 1 likes!

How to bypass captcha in website

Hi @sathish_Kumar6 , Try this chrome extension: Captcha Buster After installing this, you will get a new icon on the captcha screen. Clicking that captcha will be solved automatically using audio. [image] Hope it helps.

This solution provided by @arjunshenoy received 1 likes!

Regular expression not working but it works at Regex101

@Juan_Paz I just observed that the RegEx pattern that you are using to retain the numbers & remove that whitespaces is not actually working when the whitespace is present in the end of the data. [IMG_4320] If your sole purpose is to remove the whitespace, then I’d suggest you to go with the Trim function, like portapapeles2.ToString.Trim Or, if you are determined to achieve this via RegEx, please give the following pattern a try: \s*(\d+)\s* [IMG_4321] Hope this helps, Best 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 | 14 June 2023

Top 3 Topics with Most Views

💥 UiPath Community HyperHack 2023 is LIVE! Register Now! 💥 made by @diana.gray with 77 views.

Columns data to move another Columns in linq made by @Shyam_Pragash with 51 views.

Getting error when using python activities in uipath made by @Vivek_Sharma with 47 views.

Top 3 Topics with Most Replies

How to Assign: Now.toString = "01/05/2023" made by @wija with 22 replies.

UiPath Action Centre-Error made by @marina.dutta with 19 replies.

Bc30561: 'action' is ambiguous, imported from the namespaces or types 'system, microsoft.office.interop.outlook' made by @NewBiew with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 80 posts!

@Yoichi made 41 posts!

@raja.arslankhan made 32 posts!

Top 3 Most Liked Posts

This post made by @diana.gray received 11 likes!

UiPath Community HyperHack 2023 is LIVE! Register Now!

UiPath Community HyperHack 2023 is LIVE! Register Now! HyperHack 2023 is now LIVE! Are you a problem solver within your team or organization? Are you interested in creating effective, ground-breaking solutions with UiPath technology? Do you often think of innovative use cases for any business problem that you come across? The UiPath Community invites you to choose your challenge from one of two categories and contribute to bringing automation ideas to life by identi…

This post made by @ppr received 3 likes!

[InfoSet] - LegacyToWindows Migration # Information Index

About this [InfoSet] - LegacyToWindows Migration series The [InfoSet] series summarise a topic and offer information resources of different kinds. As the topic of Legacy-to-Windows migration is currently in focus, it was selected for the [InfoSet] series to provide further assistance. This information index is the landing page that lists all the different information resources. Blogs Tools & Guides Blueprint Block Topic Registration / Inventorisation / Prototyping Jump Start Guide …

This post made by @ppr received 2 likes!

[InfoSet] - LegacyToWindows Migration # Jump Start Guide

Introduction A migration project blueprint was presented here: [InfoSet] - LegacyToWindows Migration # Project Blueprint Overview and discussed why the Legacy-To-Windows migration is necessary and proposed a project blueprint for it. This blog contains a series of questions and a checklist for preparing a Legacy-To-Windows migration . Following the Legacy-To-Windows migration project blueprint, the building blocks from the beginning to the first prototype migration are addressed. How To use …

Top 3 Most Liked Solutions

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

Not able to view tenant feed while publishing project

Hi @sneha09871 Welcome to community There m8ght be missing permissions Check this link Happy Automation

This solution provided by @Anil_G received 2 likes!

Can't "PadLeft" for some reason

@Josh_James If you need first five then you need to do substring and not pad Str.Trim.SubString(0,5) Cheers

This solution provided by @Yoichi received 1 likes!

データテーブルの加工について

こんにちは 以下いかがでしょうか？ （事前に結果出力用のresultシートを作成しています） [image] dtResult = dt.AsEnumerable.GroupBy(Function(r) r("番号").ToString).Select(Function(g) dtResult.LoadDataRow({g.key}.Concat(g.Select(Function(r) r("英語").ToString)).ToArray,False)).CopyToDataTable NewBlankTask20230614-1.zip (56.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 | 18 June 2023

Top 3 Topics with Most Views

Revision help please made by @Latifa with 47 views.

How to solve this error: Write Range: 0x800A03EC? made by @Samraat_Maharjan1 with 44 views.

File Change Trigger V3 made by @tclukay with 38 views.

Top 3 Topics with Most Replies

How to solve this error: Write Range: 0x800A03EC? made by @Samraat_Maharjan1 with 27 replies.

Revision help please made by @Latifa with 15 replies.

Create percentage using LINQ query made by @coder with 11 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 39 posts!

@Anil_G made 33 posts!

@prateek.mehandiratta9 made 21 posts!

Top 3 Most Liked Posts

This post made by @raja.arslankhan received 1 likes!

Getting Select Item Error

@170290064 Issue resolved. [image] Generate_Yearly_Report_2023_Performer (2).zip (1.0 MB) change Queue name and asset name in process and enjoy Ignore Failed Items in snip…it was due to testing

This post made by @170290064 received 1 likes!

Getting Select Item Error

Yes please, I know there is a simple mistake but i do not know where is it.

This post made by @tclukay received 1 likes!

File Change Trigger V3

What level of folder access is required in order for the File Change Trigger activity to work? I tried attaching a trigger to a folder I have read-only access to, and the trigger completely ignores any activity occurring in the folder. No error messages, just doesn’t detect anything. @UiPath or someone else, any thoughts on this?

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

I don't ́t have the Get IMAP activity in studiox Windows

Hi, Can you try to turn on Developer option at Filter in Activities panel as the following? [image] Regards,

This solution provided by @Yoichi received 1 likes!

Value does not fall within the expected range

Hi, I guess probably in_System1Url is null. Can you check Locals panel when error occurs in Debug run? If it’s null, can you check logic regarding passing argument? Or if you need to Run File or Debug File, please set some url value as defult value as the following? [image] Regards,

This solution provided by @BeiJing0305 received 1 likes!

Write Dataset to Excel with Table mixed with Field

Appreciate all the help. The new “For Each” is a bit counter-intuitive, however. Hope UiPath will “fix” this. I can’t be the only one who’s confused.

---

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

Top 3 Topics with Most Views

Regex patterns made by @Gayathri_Mk with 56 views.

Migrating Legacy Activities to Windows made by @Anuj_Tiwari with 55 views.

Get current job running made by @Yazan_Otaibi with 55 views.

Top 3 Topics with Most Replies

Dt1 made by @Pushpendra_kowthavarapu with 20 replies.

Issue in reading argument made by @RAKESH_KUMAR_Tiwari with 14 replies.

UiPath.Python.Activities Scope problem made by @KevinDS with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 58 posts!

@arjunshenoy made 19 posts!

@raja.arslankhan made 17 posts!

Top 3 Most Liked Posts

This post made by @Anuj_Tiwari received 3 likes!

Migrating Legacy Activities to Windows

Hi everyone, We conduct regular content reviews at UiPath Marketplace to uphold user experience and trust by ensuring the listings meet the necessary standards and provide value to users. As you might already be aware, legacy .NET Framework 4.6.1 is no longer supported by Microsoft, hence, we encourage all of you to finalize migrating your legacy activities to Windows and keep the content updated with latest product releases. This way you can ensure that the automations that you have developed…

This post made by @ppr received 2 likes!

Linq for fetching value from Datatable

Duplicate of:

This post made by @balaraj.pubalan received 2 likes!

Date & Time to C#

Its works [image]

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Check if string only contains grades like A,A+,B,B+

we can use Regex isMatch method or isMatch Activity [grafik]

This solution provided by @Yoichi received 1 likes!

Date & Time to C#

Hi, In C#, as backslash is special character, it’s necessary to escape backslash or use @ as the following "C:\\Users\Documents\\DL_" OR @"C:\Users\Documents\DL_" In addition, / and : cannot be used as file name (or file path if you want to use it as part of directory name ). So as a result,the following will work, for example. @"C:\Users\Documents\DL_" +DateTime.Now.ToString("MMddyyyy-hhmm tt") Regards,

This solution provided by @Anil_G received 1 likes!

How to add node with data in JArray datatype?

@lovepong66 Follow the steps Convert the jarray to datatable using assign activity with dt = varJarray.ToObject(Of DataTable) Use add data column activity and add a new column Column3 Then populate the values …as I see all the 3 values are similar say if you want to add xxx only as value for all roes then use assign with dt.Columns("Column3").Expression = "'xxx'" Now you need to convert the datatable to jarray again using the same serialize and deserialize steps you used above in your code …

---

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

Top 3 Topics with Most Views

Automaation challenge made by @RAKESH_KUMAR_Tiwari with 49 views.

Group by in list made by @rayz1503 with 45 views.

Table extraction pdf made by @devendra_bhardwaj2 with 44 views.

Top 3 Topics with Most Replies

Code for yesterday's date file download made by @Priyesh_Shetty1 with 24 replies.

Send Hotkey or Click activity is not working for save as the excel file on Data Access Studio application made by @sandhya.govindharam with 17 replies.

Create a csv file with UTF-8 Encoding (Without BOM) made by @christian.2a with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 60 posts!

@arjunshenoy made 25 posts!

@raja.arslankhan made 20 posts!

Top 3 Most Liked Posts

This post made by @frederic-f.bonnet received 2 likes!

Problem to copy paste a cell under excel

Hi , it seems that copy/paster runs correct , in fact i probably discovered the cause in my code i open two times the file with pivot tables : to change D-D to D-1 in tables ( 1st open ) open website to recover the database D-D to update the database and update D-D tables ( 2nd open) and to refresh the data i use refresh button on excel . I decided to change , the process excel open excel and change D-D to D-1 open si the new database and update D-D tables open website to recover the da…

This post made by @Luis_Fernando received 2 likes!

UiPath Apps, Filter Function not Working

Thank you very much Dear friends @Anil_G @Arvind_Kumar1. This expression did solve my problem. Glad to count on y`all

This post made by @Anil_G received 2 likes!

Extraction Validation Action center (Document Understanding)

@Christodoulos The method that you are doing or ideating to do is the only way as of now…there is no other way to display only few fielda other than playing around eith your taxonomy Cheers

Top 3 Most Liked Solutions

This solution provided by @frederic-f.bonnet received 2 likes!

Problem to copy paste a cell under excel

Hi , it seems that copy/paster runs correct , in fact i probably discovered the cause in my code i open two times the file with pivot tables : to change D-D to D-1 in tables ( 1st open ) open website to recover the database D-D to update the database and update D-D tables ( 2nd open) and to refresh the data i use refresh button on excel . I decided to change , the process excel open excel and change D-D to D-1 open si the new database and update D-D tables open website to recover the da…

This solution provided by @ppr received 1 likes!

Main.xaml: BC30561: 'Action' is ambiguous, imported from the namespaces or types

it is more about the manual xaml editing, which you can try within an editor e.g. notepad++ Take a Backup before editing XAMLs or other files

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

Use Unique excel file for the same bot

@trentm Yes You can do it. “Your Folder Path”+UserNameVar+Now.ToString(“ddMMyyyy)+”.xlsx" Date is for to make more unique

---

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

Top 3 Topics with Most Views

Filter Rows Based on Color made by @shreyash_shirbhate with 57 views.

How change the format in excel? made by @copy_writes with 55 views.

Regex extract date after specific word made by @Dave_White with 49 views.

Top 3 Topics with Most Replies

Filter Rows Based on Color made by @shreyash_shirbhate with 24 replies.

Downloading zip file and pdf file from website made by @Priyesh_Shetty1 with 24 replies.

Getting error in Queue adding made by @Learner007 with 23 replies.

Top 3 Users Who Posted The Most

@Anil_G made 72 posts!

@Yoichi made 32 posts!

@ppr made 26 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

How to merge bulk multiple pdf into single file

@Sakthi_Gokula_Kannan Please check this [UiPath - Merge multiple PDF files into One| PDF Automation| Practical demo to join pdf files] Cheers

This post made by @supriya117 received 2 likes!

Selector error while clicking a Button

Hi @Sahil_Garg1 Use SendWindowMessages as an input method. Regards,

This post made by @Irene received 2 likes!

For Each move files from folder tho another folder

Ah, you mean something like this? Directory.GetFiles("your_root_folder", "*", SearchOption.AllDirectories).Where(Function (f) f.Contains("\DLV03\") OrElse f.Contains("\E-INV\") OrElse f.Contains("\PL\")).ToList Then you do just one loop with the list you get from this operation.

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

How to merge bulk multiple pdf into single file

@Sakthi_Gokula_Kannan Please check this [UiPath - Merge multiple PDF files into One| PDF Automation| Practical demo to join pdf files] Cheers

This solution provided by @Irene received 2 likes!

For Each move files from folder tho another folder

Ah, you mean something like this? Directory.GetFiles("your_root_folder", "*", SearchOption.AllDirectories).Where(Function (f) f.Contains("\DLV03\") OrElse f.Contains("\E-INV\") OrElse f.Contains("\PL\")).ToList Then you do just one loop with the list you get from this operation.

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

How to add multiple To id's in SMTP mail activity

Hi @Praveen_Vs Please check below solution and update us if you still face issue:

---

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

Top 3 Topics with Most Views

How to process each transaction(datatable )in reframe work? made by @vnsatyasunil with 46 views.

Iterate through hundreds folder made by @Deepak_M with 45 views.

Append logic does not follow through - Write data table error / bug made by @jezaia.vanderwatt with 42 views.

Top 3 Topics with Most Replies

Downloading available name zip from Website made by @Priyesh_Shetty1 with 21 replies.

Iterate through hundreds folder made by @Deepak_M with 17 replies.

How to process each transaction(datatable )in reframe work? made by @vnsatyasunil with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 38 posts!

@postwick made 31 posts!

@raja.arslankhan made 28 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Cut long lines of numbers by 10

when it is not guaranteed that the string length is always a multiple of 10 then we can handle this felxible as done below: [grafik]

This post made by @Irene received 2 likes!

Best Approach for manipulation?

Fully agreed to what @raja.arslankhan posted. In addition, and only based on my personal experience, when working with files on shared drives there’s always a chance that the connection might drop even just for a moment, causing your process to fail. This can happen randomly, and sometimes it can be really tricky to manage. On the other hand, the same thing might happen when copying the files to a local folder. In both cases, error management is key, so make sure that your process is bullet proo…

This post made by @Yoichi received 1 likes!

Ocr text take much time to be executed

Hi, Can you try to set value at Timeout property such as 3000 etc? [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @Irene received 1 likes!

Create HTML Content takes first row as header

It seems to be a known issue. Somebody proposed a workaround here, you can take a look: Post HTML email with datatable but doesn’t contain header - Help / Studio - UiPath Community Forum It basically creates a fake row as a first row, which will be skipped. Your header will be shifted to 2nd row and displayed as a header. Quite annoying, but it should work.

This solution provided by @Parvathy received 1 likes!

Deleting Extra Spaces in a String

Hi @Luis_Fernando Use the following below syntax: System.Text.RegularExpressions.Regex.Replace(cleanString, "\s+", " ") Note: Attached the workflow for reference Sequence11.xaml (7.9 KB) Hope it helps!! Regards,

This solution provided by @AkshaySandhu received 1 likes!

Replacing text, but I need to maintain the case

How about using below logic: dt_Mapping will look like below [image] For each row as DataRow in dt_Mapping.Rows str_Input = Regex.Replace(str_Input,"(?!\>[\w ]*)" & CurrentRow("Column1").ToString & "(?=[\w ]*\<)",CurrentRow("Column2").ToString) Next row Sample Input <li>Hello my favourite color is Red Color</li><li class="color"> Hello my favourite color is Red Color</li> Output <li>Hello my favourite colour is Red Color</li><li class="color"> Hello my favourite colour is Red Color</li>…

---

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

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

[system]

Daily Forum Report | 23 June 2023

Top 3 Topics with Most Views

Date_Format_Issue made by @Gokul_Murali with 55 views.

How to Spilt the output from Regex made by @Pavan_Patil with 49 views.

Published made by @paramjit.tarang with 45 views.

Top 3 Topics with Most Replies

Date_Format_Issue made by @Gokul_Murali with 27 replies.

Filter the Column Values and get it Count in linq made by @Shyam_Pragash with 21 replies.

How to Spilt the output from Regex made by @Pavan_Patil with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 42 posts!

@Yoichi made 30 posts!

@raja.arslankhan made 30 posts!

Top 3 Most Liked Posts

This post made by @arjunshenoy received 1 likes!

How to run the bot Saturday,Sunday and holidays

@suraj_gaikwad Please take a look at this, where you can upload the calender & define the non-working days: https://docs.uipath.com/orchestrator/automation-cloud/latest/user-guide/managing-non-working-days [image] The same defined calendar can be configured while creating a trigger. [image] If you want to run the process on non-working days (holidays & weekends), then you can define all the working days in the CSV file that you are going to upload in the ‘Non-Working Days’ tab. Hope thi…

This post made by @Yoichi received 1 likes!

Get File with the middle name

Hi, If my understanding is right, the following will work. Can you try this? [image] Condition System.Text.RegularExpressions.Regex.Match(CurrentFile.Name,"(?<=_).*?(?=_)").Value=targetNumber Regards,

This post made by @suraj_gaikwad received 1 likes!

How to run the bot Saturday,Sunday and holidays

@arjunshenoy @Anil_G Thanks, Let me try is it working or not

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Get File with the middle name

Hi, If my understanding is right, the following will work. Can you try this? [image] Condition System.Text.RegularExpressions.Regex.Match(CurrentFile.Name,"(?<=_).*?(?=_)").Value=targetNumber Regards,

This solution provided by @ppr received 1 likes!

Import Data Table and header has two lines

for each Activity (not the for each row activity) item in YourDT.Columns | TypeArgument: DataColumn Assign Activity: item.ColumnName = item.ColumnName.Replace(vbLf,"")

This solution provided by @Jithesh_R received 1 likes!

How to run the bot Saturday,Sunday and holidays

@suraj_gaikwad , Put this inside If condition and check DateTime.ParseExact(CurrentRow("Date").ToString, "MM/dd/yyyy hh:mm:ss",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy").Equals(Now.ToString("dd/MM/yyyy")) 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 | 24 June 2023

Top 3 Topics with Most Views

THE selected item is not compatible please a screen or a element made by @krishnapriya_Anu with 27 views.

How do we get 1st day of current month made by @ganesh67921 with 26 views.

Cannot find some activities made by @harrietwang013 with 26 views.

Top 3 Topics with Most Replies

In Excel, count the rows until the row (Column New), and add the data by 18. The value of 18 is obtained from another Excel file made by @krishnapriya_Anu with 11 replies.

How to switch the workflow based on the web page content made by @felix.guan with 7 replies.

Studio uninstallation issue made by @Prasad_Ashish with 7 replies.

Top 3 Users Who Posted The Most

@Yoichi made 11 posts!

@Anil_G made 9 posts!

@argin.lerit made 5 posts!

Top 3 Most Liked Posts

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

How do we get 1st day of current month

Hi @ganesh67921 Check this out New DateTime(Now.Year,Now.Month,1).Tostring(“MM/dd/yyyy”)

This post made by @PrasanthManivannan received 1 likes!

Regex Pattern for Uipath (10 Basic Pattern)

Regex Pattern for UiPath (10 Basic Pattern) ====================================== Matching a date pattern in the format “YYYY-MM-DD” \d{4}-\d{2}-\d{2} Matching an email address: \w+@\w+\.\w+ Matching a URL: https?://\S+ Matching a phone number in the format “(XXX) XXX-XXXX”: \(\d{3}\) \d{3}-\d{4} Matching a social security number (SSN) in the format “XXX-XX-XXXX”: \d{3}-\d{2}-\d{4} Extracting all numbers from a string: \d+ Extracting all capitalized words from a string: \b[A-Z]+\…

This post made by @ganesh67921 received 1 likes!

How do we get 1st day of current month

Hi @nikhil.girish Thanks for your reply Will check this expression

Top 3 Most Liked Solutions

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

How do we get 1st day of current month

Hi @ganesh67921 Check this out New DateTime(Now.Year,Now.Month,1).Tostring(“MM/dd/yyyy”)

This solution provided by @ppr received 1 likes!

Simple question about "Get From Clipboard" option doenst appear

@Felipe_Linhares welcome to the forum You are working with StudioX. The Get From Clipboard Activity is an activity from Studio For getting text we can e.g. use: new UiPath.Core.Activities.ClipboardWrapper().GetText

This solution provided by @wahid_rochman received 1 likes!

How to add new Robot license to existing Orchetrator?

Hey @Anil_G , Thanks for your suggestion to contact UiPath Technical Support. Because the new license is bought for new tenant, so the proposed solution was apply the new license code to Tenant level. With this method the new license wouldn’t interrupt the existing license.

---

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

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

[system]

Daily Forum Report | 25 June 2023

Top 3 Topics with Most Views

Error in Json Data made by @marina.dutta with 34 views.

Check sum of two values is 0 and update the status made by @Shivam_Rana with 30 views.

Check the code made by @katta_nikhil with 28 views.

Top 3 Topics with Most Replies

Error in Json Data made by @marina.dutta with 17 replies.

Check sum of two values is 0 and update the status made by @Shivam_Rana with 15 replies.

Dynamic Drop Down in Data Grid Not Working made by @Nitin_Mishra with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 37 posts!

@Yoichi made 16 posts!

@marina.dutta made 10 posts!

Top 3 Most Liked Posts

This post made by @iamankhandelwal1997 received 2 likes!

Unable to login to UI Path

@raja.arslankhan @Anil_G It started working now after upgrading my system.

This post made by @marina.dutta received 1 likes!

Slide Bar to Right

@argin.lerit Thanks .Will try

This post made by @Anil_G received 1 likes!

Global variable: is not declared. It may be inaccessible due to its protection level

@donghai Please try upgrading your dystem activities and check if it resolves higher to 23.2 atleast Cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Problem with activites , can't find activity "image exists" in list, and i added the package

@gundam-ace In the new activities image exists is combined with check app state activity…in that please select the target method as image and indicate the image you need to search Cheers

This solution provided by @donghai received 1 likes!

Global variable: is not declared. It may be inaccessible due to its protection level

Hi @Anil_G Thanks your reply. I found there are some error tips in xaml file imports tab, after I delete it, every thing is OK. BR, Donghai

---

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

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

[system]

Daily Forum Report | 26 June 2023

Top 3 Topics with Most Views

JSON Data Deserialize JSON: Unexpected character encountered while parsing value: O. Path '', line 0, position 0 made by @marina.dutta with 47 views.

Decimal Value in datatable made by @Kuldeep_Pandey with 46 views.

Write Cell : Failed setting the current sheet to: Sheet1 in workbook: Original error message: 0x800AC472 made by @Samraat_Maharjan1 with 46 views.

Top 3 Topics with Most Replies

Write Cell : Failed setting the current sheet to: Sheet1 in workbook: Original error message: 0x800AC472 made by @Samraat_Maharjan1 with 24 replies.

What is the Package name of Excel Range to Image activity? made by @Gopikrishna_S with 14 replies.

Unziping files and pasting the total number of pan numbers under the columns made by @Priyesh_Shetty1 with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 77 posts!

@Yoichi made 54 posts!

@raja.arslankhan made 23 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 1 likes!

Please help me out

Hi, How about the following? [image] Sample20230626-8L.zip (7.6 KB) Regards,

This post made by @ppr received 1 likes!

Time is in string format with AM and PM i need to convert time in 24 hrs format

We do see, that it is working [grafik] give a try by trimming the value Datetime.ParseExact(YourStringVar.Trim(),"h:mm tt", System.Globalization.CultureInfo.InvariantCulture).toString("HH:mm")

This post made by @Yoichi received 1 likes!

レガシで使えた「StrConv」がwindowsでは利用できません。

こんにちは 取り急ぎ名前空間付きで呼び出してもらえますでしょうか？ Microsoft.VisualBasic.Strings.StrConv(yourString,VbStrConv.Narrow,&H411) あとEncodingの関係で以下も必要になると思います。

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Please help me out

Hi, How about the following? [image] Sample20230626-8L.zip (7.6 KB) Regards,

This solution provided by @ppr received 1 likes!

Time is in string format with AM and PM i need to convert time in 24 hrs format

We do see, that it is working [grafik] give a try by trimming the value Datetime.ParseExact(YourStringVar.Trim(),"h:mm tt", System.Globalization.CultureInfo.InvariantCulture).toString("HH:mm")

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

Not able to delete other package version

Hi @tanuja38 Seems permission of deleting package is missing from your end Check this out Whether you have sufficient permissions

---

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

Top 3 Topics with Most Views

Studio Web is now available for all enterprise customers made by @Magdalena_Neagu with 147 views.

Dev Dives: Unleash the full potential of your automations with Generative AI made by @zell12 with 78 views.

【新規】UiPath Studio Web ガイドの人間翻訳版公開のお知らせ (2023 年 06 月 14 日更新確認分) made by @Akiyo_Yamada with 47 views.

Top 3 Topics with Most Replies

Tristate変数の変数パネルでの定義方法 made by @gorby with 18 replies.

How to total rows present in a excel sheet? made by @ujjwal.bansal with 16 replies.

API Integration With Http Request using Datasetkey made by @Shyam_Pragash with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 48 posts!

@Yoichi made 44 posts!

@Irene made 24 posts!

Top 3 Most Liked Posts

This post made by @Magdalena_Neagu received 4 likes!

Studio Web is now available for all enterprise customers

If you logged in to your UiPath Cloud account today, you probably noticed the latest addition to the family. A new entry available for Studio Web, our latest addition to the Studio Family. [StudioWeb live] What is Studio Web? Studio Web is a browser based automation canvas, designed with cross-platform automation projects in mind. It allows you to build automations directly in your browser, across online business apps and services. We consider it the best way to get started with automation. S…

This post made by @zell12 received 3 likes!

Dev Dives: Unleash the full potential of your automations with Generative AI

Hello UiPath Community, How can you boost your automation with generative AI? I’m Russel Alfeche, Technology Leader for RPA at qBotica, and I’m thrilled to be on the next Dev Dives episode on Wednesday, June 28th! Together with Dhruv Patel, we’ll provide you with several ideas to level up your automations with LLMs, GPT, and other generative AI or foundation models. Because we’ve seen how powerful large language models can be, whether it’s for writing professional looking essays, responding …

This post made by @Anil_G received 2 likes!

Quizzes

@Latifa Arjun is right in his answer already Cheers

Top 3 Most Liked Solutions

This solution provided by @marian.platonov received 1 likes!

Library Usage

Start you playing with these: [image] [image] Item: JSONText.GetValue(“dependencies”) folderPath: CurrentFile.ToString arrayOfText: Split(folderPath.tostring,“\”) processVersion: arrayOfText(arrayOfText.Count-4)

This solution provided by @irahmat received 1 likes!

Some of My UiPath Activities only Show their title on the workflow

please downgrade your project dependencies to version 22.10 UiPath.system.Activities UiPath.UiAutomation.Activities.

This solution provided by @Yoichi received 1 likes!

Merge Excel files without knowing the files name from a folder

HI, How about the following sample? [image] Sample20230627-8L.zip (21.3 KB) Please un-comment delete file activity if you remove src files. 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 | 28 June 2023

Top 3 Topics with Most Views

I have to remove the unnecessary data from variable value made by @vinjam_likitha with 43 views.

Safely Close Excel Workbook made by @elliot.barling with 42 views.

How to extract table contain 15000 record and write in excel sheet made by @Abdalla with 41 views.

Top 3 Topics with Most Replies

How to extract table contain 15000 record and write in excel sheet made by @Abdalla with 18 replies.

How to set the input field empty before typing values made by @raju_alakuntla with 16 replies.

Use Application/Browser Activity Error after Studio Upgrade to 2023.6 Release made by @saurabh.goswami1 with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 37 posts!

@Yoichi made 33 posts!

@postwick made 32 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

"Expression Activity type 'VisualBasicValue`1' requires compilation in order to run" after attempt to add new column in Excel file

please check the following: the variable monthyear has a default value: today.ToString(“MMMyy”) please retype the default value and ensure that the double quotes are of type: " and not inverted

This post made by @mkankatala received 1 likes!

Automate excel web version

Hi @manasdas6224 If Your questions is How can automate the excel automation in UiPath web? In UiPath web there is no option to read the excel by using read range workbook. There is no read range workbook activity in UiPath web. You can read the google sheets in UiPath web. The UiPath web is only integrated with the cloud Google and microsoft only. Check the below attached image. [image] Hope it helps!!

This post made by @sangeethaneelavannan1 received 1 likes!

How to get the date from the below text

It worked .thanks

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

"Expression Activity type 'VisualBasicValue`1' requires compilation in order to run" after attempt to add new column in Excel file

please check the following: the variable monthyear has a default value: today.ToString(“MMMyy”) please retype the default value and ensure that the double quotes are of type: " and not inverted

This solution provided by @pravallikapaluri received 1 likes!

How to copy data from specific cell to another in Excel

Hi @mironb Excel Application Scope WorkbookPath: [Path to Excel file] Read Cell SheetName: “Sheet1” Cell: “A1” Output: cellValue Write Cell SheetName: “Sheet2” Cell: “B2” Value: cellValue End Excel Application Scope Hope it helps!!

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

Inyección JavaScript

@camilo_gonzalez - Puedes tratar este código: "function(e, disponible){ let newVal = document.getElementsByClassName('string-cell editable renderable'); newVal[0]['innerHTML']=disponible; }" Y en el parameter InputParameter de la Actividad, pone la variable que contiene el valor de disponible en el código JS como asi: [image] Espero que esto es útil para ti

---

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

Top 3 Topics with Most Views

Loop through each char of string made by @satyam_verma with 44 views.

Use Excel Fileアクティビティ配下に大規模フローチャートを配置する件 made by @gorby with 44 views.

Split PDF every 2 pages made by @Gemma_Walker with 41 views.

Top 3 Topics with Most Replies

Error when opening studio automation made by @aquinn with 23 replies.

Loop through each char of string made by @satyam_verma with 21 replies.

Convert string to list made by @manasdas6224 with 14 replies.

Top 3 Users Who Posted The Most

@Irene made 40 posts!

@Yoichi made 34 posts!

@Anil_G made 29 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Loop through each char of string

Hi, You should output not newstr but newstring. [image] Regards,

This post made by @Jugger received 1 likes!

The project could not be opened

Hi everyone, thanks for the quick action on this matter. Much appreciated. @alexandru I’ve updated to 23.6.1 and it works fine, all good now.

This post made by @postwick received 1 likes!

2023.4.2 is unwantingly Hiding sequences

I’m curious why you want to see this extra clutter on your screen.

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Convert string to list

@manasdas6224 Test.zip (141.2 KB)

This solution provided by @ptrobot received 1 likes!

Handel known pop up and messages

Have you tested the Pick / Pick Branch activities?

This solution provided by @Pedro_Vieira received 1 likes!

How to read record content - Servicenow - Integration Service - List All Records

Thank you for your attention, after I asked the question here on the forum, I saw that it was an object, and I accessed the item I needed using a for. Inside the for, I put an assing; curretitem.NameItem.ToString

---

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

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

[system]

Daily Forum Report | 30 June 2023

Top 3 Topics with Most Views

Continuous Error in UiPath Studio After Update made by @jay.jmee with 53 views.

Is the Ask GPT activity down? (Update: It is not. The question I was asking was timing out.) made by @JOrdinas with 50 views.

How to iterate through datatables made by @Geeta with 45 views.

Top 3 Topics with Most Replies

Outlook mail folder error made by @katta_nikhil with 17 replies.

How to iterate through datatables made by @Geeta with 14 replies.

Click on empty row made by @Povilas_Jonikas with 12 replies.

Top 3 Users Who Posted The Most

@lrtetala made 32 posts!

@ppr made 26 posts!

@raja.arslankhan made 22 posts!

Top 3 Most Liked Posts

This post made by @argin.lerit received 4 likes!

Reboot work! UiPath robot-inspired trophies

Folks, excited to share this year’s champion trophy for our RPA teams’ internal Hackathon. [image] [image] [image] The theme of our internal Hackathon this year is What was not possible, IS NOW POSSIBLE. The focus is on reusable code in StudioX for our Citizen Devs, and chatbot-development for our seasoned RPA Devs. The champion team will be awarded this trophy. Always loved the cute little UiPath robots that appear at the end of the Academy training videos shouting “Reboot work!!” and s…

This post made by @Yoichi received 2 likes!

Can not regconize Advance button in Chrome browser

HI, It’s probably the following matter. Can you try to upgrade UiAutomation.Activities package to the fixed version? Regards,

This post made by @Parvathy received 2 likes!

Uipath exam question

Hi @ShivaniD Answer would be Option A. Explanation: Based on all the 4 options idx value can be modified for stable automation. Other than idx values. If the selector contains innertext, aaname these selectors are modified at most cases because will not be an stable selector. These attributes give more stable automation. Hope it helps!! Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Can not regconize Advance button in Chrome browser

HI, It’s probably the following matter. Can you try to upgrade UiAutomation.Activities package to the fixed version? Regards,

This solution provided by @Yoichi received 1 likes!

How to get index of row by searching data in JArray?

HI, Do you need to get “station” from “jimmy”? If so, the following will work. JsonArray.Where(Function(x) x("Column0").ToString="jimmy").First()("Column1") This assumes there is a item which you need. If there is possibility target does not exist, it’s necessary to add some logic. Regards,

This solution provided by @ppr received 1 likes!

While scrolling elements become visible

we asked for to have the same scenario as you are testing. When using any other criteria we do have looked at a different set. However, the next button is working. The problem is, that the Extract Data is more slow and grabs not a page complete. Therefore we do have less rows. You can try if the out-of-the-box settings allows you to better sync. Otherwise, you can remodel your approach and take more care about sync and extraction. Paging can be done with url trick as just the page number has…

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

@Yoichi received 82 likes for their solutions!

@Anil_G received 53 likes for their solutions!

@arjunshenoy received 27 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.