Forum Engagement Daily Reports

[system]

Daily Forum Report | 28 June 2022

Top 3 Topics with Most Views

If else not working for empty cells or 0 made by @DTECH with 50 views.

Check element exists message box made by @anh.nguyen with 40 views.

Where is the "Text to Column" equivalent activity inside Studio? made by @Chaaza with 38 views.

Top 3 Topics with Most Replies

Download file from sharepoint with 365 issue made by @Soudios with 17 replies.

If else not working for empty cells or 0 made by @DTECH with 16 replies.

Cannot select New made by @Anived_Mishra with 16 replies.

Top 3 Users Who Posted The Most

@muhammedyuzuak made 48 posts!

@Rahul_Unnikrishnan made 33 posts!

@THIRU_NANI made 29 posts!

Top 3 Most Liked Posts

This post made by @Abhijna_Nayak received 2 likes!

Extract Value from Analytics data of queue item

How to extract the value of analytics data in queue in details tab of queue item? For specific data its .SpecificContent and for output data its .output. What about analytics data?

This post made by @patrick.krukenfellner received 2 likes!

Display Log Fields in Orchestrator as Column

Dear UiPath Team, recently we thought a lot about how to improve our logging setup in UiPath and how we can maximize the use of the already provided logging solution by UiPath Orchestrator in order to enable better monitoring and troubleshooting of our robots, instead of having an additional logging solution in place, such as ElasticSearch (Note that I am referring to the UiPath Automation Cloud Orchestrator, where ElasticSearch is still not integrated). One point we stumbled upon was the disp…

This post made by @NervYerem received 2 likes!

Api Edge / Url Id change every time

Navigate to the base URL Allow user to login, If the site auto logs in there’s nothing to do here After the user is logged in, the URL should change to contain the ID. Read in the url of the browser, use preferred method to parse out the ID (Regex if you need a suggestion) Assign the parsed ID into a variable, then use it in the URL for your next actions.

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

How can I use Window Handle with Find Element Activity?

Hey @grosner Using it inside a parent container activity should help ? Any issues on that case. Thanks #nK

This solution provided by @Edwin_Barahona received 1 likes!

Api Edge / Url Id change every time

Yeah, so I don’t think thats edge’s api considering the site is built on php. Said that, I don’t think that id is a token but a unique identifier generated by the application on redirection that will eventually be tied to a formulary after being sent. Have you tried just sending just the core url https://xxxx/index.php or https://xxxx/

This solution provided by @Sanjit_Pal received 1 likes!

How to Write range without Specifying Cell Numbers

Hey @Ishan_Shelke, Number of rows does not cause any error, if you have a datatable having 10 rows and 3 columns you can write it from cell “A1” on the other hand if you would be having 100 number of rows and 3 columns still you can write it on cell “A1” The end range is not required, you have to give only the initial point. Thanks, Sanjit Pal

---

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 2022

Top 3 Topics with Most Views

Filter DataTable using Linq made by @Satish_Ch with 51 views.

Prepare/Modify Datatable as Datetime column has null values made by @Satish_Ch with 42 views.

How to split particular text from string made by @Rohit_Patil1 with 39 views.

Top 3 Topics with Most Replies

How to split particular text from string made by @Rohit_Patil1 with 16 replies.

Creating Folder name with email received date made by @k.vandana with 16 replies.

How to use the same variable from different sequence made by @Abc_Xyz1 with 15 replies.

Top 3 Users Who Posted The Most

@THIRU_NANI made 33 posts!

@muhammedyuzuak made 28 posts!

@Rahul_Unnikrishnan made 24 posts!

Top 3 Most Liked Posts

This post made by @Jamie_Davies received 2 likes!

Happy Anniversary UiPath Learner, Virtual Party!

Happy Anniversary UiPath Academy! Definitely come a long way since those first few courses and have helped masses of people globally Looking forward to the future !

This post made by @Lucas_Clemente received 2 likes!

Document Understanding - How to create extractors using Forms AI

Hello, in this video we will see the use of Forms AI from Document Understanding, seeing how to create extractors with it and how to apply them within our workflows. Forms AI is an extraction tool present within the Document Understanding service that allows us to process structured documents, in other words, documents that do not have significant variations in their layout. So, Let’s go! [UiPath - Forms AI in Document Understanding]

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

Unique reference revert back

Hi @Umesh98761 please find the screenshot [image] Thanks

Top 3 Most Liked Solutions

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

Unique reference revert back

Hi @Umesh98761 please find the screenshot [image] Thanks

This solution provided by @Yoichi received 1 likes!

String型で取り込んだ日付のフィルター

こんにちは フィルターデータテーブルアクティビティですとうまく評価されませんね。 例えば以下の式でフィルターできると思うので、こちらお試しください。（ただし返り値が空の場合例外になるので、その時はもう少し工夫が必要になります） dt = dt.AsEnumerable.Where(Function(r) r("ColumnName").ToString>="20220625").CopyToDataTable()

This solution provided by @THIRU_NANI received 1 likes!

How to delete empty rows in excel. i found vb code, i need c#

Hey! Use filter datatable… Mention the column and is empty ->Remove Regards, NaNi

---

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 2022

Top 3 Topics with Most Views

2つのExcelブックの同じ名前のシート同士を比較したい made by @T_Hirao1 with 36 views.

How to sort data in excel sheet with month names made by @Zeba with 35 views.

Element exits Selectors made by @tkiran with 35 views.

Top 3 Topics with Most Replies

Element exits Selectors made by @tkiran with 21 replies.

Replace characters with nothing using Regular Expression pattern in Type into activity (Type this) made by @Ruxandra_Zamfir with 20 replies.

How to extract data for last 7 consecutive days from an excel data table made by @faiqaqureshi90 with 15 replies.

Top 3 Users Who Posted The Most

@THIRU_NANI made 36 posts!

@Rahul_Unnikrishnan made 25 posts!

@ppr made 18 posts!

Top 3 Most Liked Posts

This post made by @Daniel_Santos1 received 1 likes!

How to get bigInt number more than 15 characters from the database and put it in a string

Hi guys, thanks a lot for the tips. I managed to get around the problem. Forcing to concatenate a letter with a number in the select in the database. This caused the number to be interpreted by uipath as a string. Look select id,cnpj, num_doc_ajustado = concat ([num_doc],‘a’), data_hora, razao_social, local_arq from [bdp].[dbo].[compr] where cnpj in (6xxx55320143,8xx58002,102xxx0000121,42xxx000167,8xxx49130500009) and dsc_stat = ‘CONCLUIDO’ order by dat_hora_ult_alt desc [image]

This post made by @tarik received 1 likes!

Automation Awareness - The Automation Journey - We want to hear your thoughts!

Learning the processes and figuring out the best possible way to apply automation. Improving the automation would be fun too.

This post made by @Rahul_Unnikrishnan received 1 likes!

I want to add days to the current date, can any one help me on this?

Hello @saritha_panguluri Please check the below doc.

Top 3 Most Liked Solutions

This solution provided by @Daniel_Santos1 received 1 likes!

How to get bigInt number more than 15 characters from the database and put it in a string

Hi guys, thanks a lot for the tips. I managed to get around the problem. Forcing to concatenate a letter with a number in the select in the database. This caused the number to be interpreted by uipath as a string. Look select id,cnpj, num_doc_ajustado = concat ([num_doc],‘a’), data_hora, razao_social, local_arq from [bdp].[dbo].[compr] where cnpj in (6xxx55320143,8xx58002,102xxx0000121,42xxx000167,8xxx49130500009) and dsc_stat = ‘CONCLUIDO’ order by dat_hora_ult_alt desc [image]

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

Ml ai dataserrvice

Hi @Praveen_Sood basically enterprise trial is provided for 60 days No payment options are asked , nothing to worry about that

This solution provided by @ahmad.sultan received 1 likes!

Unable to use 'forward task' activity

Finally understood the reason of this issue, according to UiPath support the minimum version of on-premise Orchestrator and Action center that supports ‘Forward task’ and ‘Complete Task’ activities is 21.4, and in my case it was 20.10

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

@Yoichi received 54 likes for their solutions!

@ppr received 42 likes for their solutions!

@jack.chan received 30 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 July 2022

Top 3 Topics with Most Views

Can you please suggest possible real time projects in Retail, Construction andTelecom industry projects? made by @raju_alakuntla with 41 views.

Rename Duplicate Column in an excel made by @deepaksvg99 with 41 views.

Excuse me, is the anchor point of your click and type into still normal? made by @Uddynitjh with 40 views.

Top 3 Topics with Most Replies

Excuse me, is the anchor point of your click and type into still normal? made by @Uddynitjh with 18 replies.

Log messages for particular data made by @prathik_8679 with 11 replies.

Object reference not set to an instance of an object! made by @Copariu_Victor with 11 replies.

Top 3 Users Who Posted The Most

@THIRU_NANI made 27 posts!

@Nithinkrishna made 23 posts!

@kumar.varun2 made 15 posts!

Top 3 Most Liked Posts

This post made by @sathish_Kumar6 received 2 likes!

How to add a number that contains string and numbers. for example ABCD1234 and i want to add +1 to end like ABCD1235

thank you so much…it means lot to me… really very huge thanks rajeshwari…u saved me

This post made by @AaronTank received 1 likes!

Cumulative Delay to Start Jobs from Orchestrator

Hello, I am having an issue with the timing of my jobs starting. I am using a ServiceNow connector to submit a queue item to a queue in UiPath, which then triggers a job to start. This piece works fine, and the time from ServiceNow submitting the request, to the queue item appearing in New status in the queue is generally less than two seconds. The problem I’m seeing, however, is a long and steadily-increasing delay from the time that item appears in the queue, until the time the job actually…

This post made by @angel_ramirez received 1 likes!

Steps to enable AI Centre in Enterprise version

Hi in my company we have Uipath enterprise but we do not know all the steps for enabling AI Centre. Would you help me with the correct steps for Enterprise version? I have checked youtube videos but they are based in the community edition version. Do we need to go to the cloud?, what url? and what email do we need to use company’s email, uipath admins email? I do not know I am new on this. Thank you!!

Top 3 Most Liked Solutions

This solution provided by @Venkata_Rajendran received 1 likes!

UiPath Data Service have data access restriction option?

@Naveen.Ch : Can you try the following? Mention the entity table as list source nad the column in the column property . In the below example, TP_Department is the entity name and Location is the column [image]

This solution provided by @kumar.varun2 received 1 likes!

Help with Linq

Hi @guilherme.dias What is the requirement? (Input and Output) Please go through this post by @ppr for learning the LINQ

This solution provided by @Yoichi received 1 likes!

Excuse me, is the anchor point of your click and type into still normal?

Hi, Can you try to use Click activity not under Classic but under UiAutomation-Application? [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 | 02 July 2022

Top 3 Topics with Most Views

Transferring of Hours Rendered from one sheet to another made by @Robert_Russell_Monsalud with 31 views.

Break loop by 2000 records, perform other operations and continue loop made by @RPA-botDev with 30 views.

Directiry.GetFiles error made by @Emre_Emek with 30 views.

Top 3 Topics with Most Replies

Transferring of Hours Rendered from one sheet to another made by @Robert_Russell_Monsalud with 7 replies.

System Input Dialog and other activities not found on new Projects, but present in older foreign example projects made by @MALMAL_MAL with 7 replies.

Break loop by 2000 records, perform other operations and continue loop made by @RPA-botDev with 6 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 17 posts!

@Rahul_Unnikrishnan made 17 posts!

@Vidu_Senanayake made 4 posts!

Top 3 Most Liked Posts

This post made by @RAKESH_KUMAR_BEHERA received 2 likes!

API UiPath Automation| API | HTTP Request | HTTP Response | API Call in UIPath

[API UiPath Automation| API | HTTP Request | HTTP Response | API Call in UIPath]

This post made by @Joe_Matuch received 1 likes!

Possible to add a single task to Action Center without UiPath.Persistance.Activities?

Yes, I turned on “Supports Persistence.”

This post made by @Joe_Matuch received 1 likes!

Possible to add a single task to Action Center without UiPath.Persistance.Activities?

Hi again, @Nithinkrishna . I added a Create Form Task, and that went fine. It created a task that I completed in Action Center. However, that was not very useful because the outputs of the completed form task did not get used anywhere. I put a “Wait for Form Task and Resume” after the Create Form Task, but then I started to get the error below. Here you can see my main workflow, the persistence activities in my ProcessTransactions.xaml, and the error I am getting. I turned on “Supports Persiste…

Top 3 Most Liked Solutions

This solution provided by @Vidu_Senanayake received 1 likes!

Break loop by 2000 records, perform other operations and continue loop

Try this workflow. in this work flow you just loop and check if the main data table you have if greater than 0 assign a temporary datatable with first N rows dt_Main.AsEnumerable.Take(NumOfRows).CopyToDataTable() Next you remove N number of rows from your main datatable if(dt_Main.RowCount>NumOfRows,dt_Main.AsEnumerable.Skip(NumOfRows).CopyToDataTable(),dt_Main.Clone) Testing2000RecordLoop.xaml (10.0 KB)

---

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

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

[system]

Daily Forum Report | 03 July 2022

Top 3 Topics with Most Views

Scriptless Test Automation Solution for End-to-End Interfaces Integration (Web ,API, Database) made by @STEP_Amit_Sangale with 54 views.

How to get attachment name only xlsx file made by @Teck_Hwee_Goh with 37 views.

How to manipulate an object extracted by Regex and Match made by @Bennyhana with 35 views.

Top 3 Topics with Most Replies

How to manipulate an object extracted by Regex and Match made by @Bennyhana with 9 replies.

How to replace a column/row value in datatable in Uipath (based on some condition) without using for each row made by @MariaJosephina with 8 replies.

How to get attachment name only xlsx file made by @Teck_Hwee_Goh with 6 replies.

Top 3 Users Who Posted The Most

@PALKUMARI_PATEL made 6 posts!

@THIRU_NANI made 6 posts!

@Steven_McKeering made 4 posts!

Top 3 Most Liked Posts

This post made by @PALKUMARI_PATEL received 1 likes!

For each row loop return row number

I found this very helpful. It’s working.

This post made by @marian.platonov received 1 likes!

RPA governance model sample

To generate a governance file with your current configuration from Studio, go to the Backstage view > Help tab, and select Generate Governance File . The exported file can be shared across your team. [image] Reference: https://docs.uipath.com/studio/docs/governance#generate-the-governance-file UiPath Automation Ops is a centralized, web-based platform that enables a simple and convenient way to manage and implement governance policies based on user profiles, and to manage the feeds available…

This post made by @PALKUMARI_PATEL received 1 likes!

How to get Cell reference or Cell Number along with cell value from datatable

I’ve got this Solution by using Lookup Range activity. Thanks Though

Top 3 Most Liked Solutions

This solution provided by @jack.chan received 1 likes!

Transferring of Hours Rendered from one sheet to another

i add a temporary column “RowNumber”, so that when i filter the datatable, i know which row number in sheet3 to update use this version, i will remove that column before updating the excel TEST.xaml (38.9 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 | 04 July 2022

Top 3 Topics with Most Views

Date time is dd/mm/yyyy 00:00:00 and other time is dd/mm/yyyy made by @Soudios with 44 views.

Spilt Column Value in data table and add to other columns by using LINQ made by @nitesh.s with 37 views.

Dyanamic Selector issue made by @srujana13a5 with 36 views.

Top 3 Topics with Most Replies

Spilt Column Value in data table and add to other columns by using LINQ made by @nitesh.s with 14 replies.

Date time is dd/mm/yyyy 00:00:00 and other time is dd/mm/yyyy made by @Soudios with 13 replies.

How to add two data tables into one one data table, merge column wise made by @ashishmani with 12 replies.

Top 3 Users Who Posted The Most

@THIRU_NANI made 32 posts!

@ushu made 16 posts!

@ppr made 14 posts!

Top 3 Most Liked Posts

This post made by @HeartCatcher received 2 likes!

Outlook error in studio

Hi all, I am getting an error in outlook activity as in the attachment please do needful to resolve the same. @Rahul_Unnikrishnan @ppr @Yoichi @ushu @lakshman @geetishree.rao @Nithinkrishna [Outlook error in studio]

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

Spilt Column Value in data table and add to other columns by using LINQ

Hi @nitesh.s I have implemented the @ppr aaproach Please have a look [image] [image] Output [image] SplitColumns.xaml (7.6 KB)

This post made by @Abhinav_Shukla received 1 likes!

How to get Designation of the recepient from Outlook

@shankm It actually worked very well

Top 3 Most Liked Solutions

This solution provided by @THIRU_NANI received 1 likes!

How Can i Store the Seperate Sheet Data in seperate DataTable?

Hey! Use Excel application scope and pass the PATH Now use get workbook sheets activity in output-> Create a variable the type of this variable is List(String) Use for each and inside the for each use Read range->Output->Dt pass the item in sheet You will get the one by one sheet and the data will be stored in the Dt variable Now use the if Condition Item.Equals("CY") Then Block: Perform the Actions Else block: Perform the PY Actions Regards, NaNi

This solution provided by @muhammedyuzuak received 1 likes!

Copy activity to new project

Hi @MikeC, You can copy events, but variables only come with you in the scope range they are in. For example, you can put a sequence with the variables below it. However, the variables defined globally and included in that sequence will not be moved. Regards, MY

This solution provided by @benjamin.leung received 1 likes!

Why I cannot find my labels in Orchestrator Asset

Thank you. I have found the reason. The labels cannot contain 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 | 05 July 2022

Top 3 Topics with Most Views

📢 Launching 'Automation Hub Best Practices' webinar series! made by @cristina.vidu with 69 views.

How to loop and write made by @Sharanabasava1 with 52 views.

Unable to access ACME System Website made by @Samuel_Lagos with 48 views.

Top 3 Topics with Most Replies

How to loop and write made by @Sharanabasava1 with 28 replies.

Find last row with data in Excel made by @Emmy_O with 17 replies.

How to filter data from excel and store in different datatable made by @sayali_rokade with 12 replies.

Top 3 Users Who Posted The Most

@THIRU_NANI made 25 posts!

@ppr made 20 posts!

@NIVED_NAMBIAR made 15 posts!

Top 3 Most Liked Posts

This post made by @Teodora_Patrascu received 5 likes!

Document Understanding Process - 2022.6-preview Release

Hello everyone! We are very excited to announce the 2022.6-preview release of the Document Understanding Process. Important Changes in 2022.6-preview: Official support for C# Introduction of Asset naming convention, for better visibility of the Document Understanding Assets in Orchestrator New overriding Assets for Orchestrator Configuration Various bug-fixes I am including in this post the updates for 2022.4 release as well. Important Changes in 2022.4…

This post made by @cristina.vidu received 4 likes!

Launching 'Automation Hub Best Practices' webinar series!

We listened to your requests and are happy to announce that we’re launching a brand-new webinar series on ‘Automation Hub Best Practices’. Based on our experience and our customers’ successful journeys, we’re happy to share tips to successfully roll-out Automation Hub and scale your automation program with effective prioritization, faster implementation, and the impact you can measure. See the session list for this month and join our product experts as they walk you through the practical…

This post made by @Diego_Busca received 2 likes!

Unable to access ACME System Website

Hi all, already mentioned on this post System Acme website not working - Help / Studio - UiPath Community Forum and it seems that @loginerror was informed.

Top 3 Most Liked Solutions

This solution provided by @Sudharsan_Ka received 1 likes!

Pass information from one column to another

HI @Hendrix_Santos You can try this Read the excel file(read Range) Filter Datatble(Condition : “Column name” contains “YES”) save in new datatable Write range and write that in new sheet or excel file Can you provide sample input ? Regards Sudharsan

This solution provided by @Vidu_Senanayake received 1 likes!

How to remove certain word from a string

Hi you can use a Assign inside a for each and assign the CurrentRow(“Column”)=System.Text.RegularExpressions.Regex.Replace(CurrentRow(“Name”).ToString, “[,]{0,1}Not Correct[,]{0,1}”, “”).Trim RemoveSpecialCharacters.xaml (9.9 KB)

This solution provided by @Mr.H received 1 likes!

Match Excel cells to get information from another

Hi Bro. Try this one. JoinDatatable.zip (69.1 KB)

---

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

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

[system]

Daily Forum Report | 06 July 2022

Top 3 Topics with Most Views

After acquiring the Unattended license from the Cloud Orchestrator. The Robot still showing connected unlicensed. made by @BalaManikanta_007 with 50 views.

Error to Log on in SAP made by @daniel.canas with 45 views.

- License Cost - made by @narender.bn with 43 views.

Top 3 Topics with Most Replies

Error to Log on in SAP made by @daniel.canas with 19 replies.

How to check current date lies in which quarter? made by @Pogboom with 17 replies.

How to group excel data table? made by @Rhys18 with 17 replies.

Top 3 Users Who Posted The Most

@ppr made 29 posts!

@supermanPunch made 28 posts!

@THIRU_NANI made 27 posts!

Top 3 Most Liked Posts

This post made by @matheus.delimaramos received 5 likes!

Acme-test.uipath.com is online again

is there any forecast? I’m waiting to finish an exercise, thanks in advance

This post made by @Joe_Matuch received 3 likes!

Acme-test.uipath.com is online again

We’re conducting training for a group of new hires, and it all centered on the ACME site. I have an idea for how we can pivot, but I hope the issue gets fixed soon!

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

Close tab

Hi @AsadPathan2665 You can follow this approach Use Attach Browser Activity to attach the tab by indicating it Inside the scope - use Close Tab activity to close the tab [image]

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Get File Extension from a file path

[grafik]

This solution provided by @supermanPunch received 1 likes!

Comparing a String to a list of Strings including wildcards

@Kyleb91 , You would need to correct the wildcards, In Regex it is not * it is .*. [image] Maybe some more explanations : [image] [image]

This solution provided by @Yoichi received 1 likes!

How can I make this inside variable?

Hi, Can you try the following expression? arrInt = yourString.Split(","c).Select(Function(s) Int32.Parse(s.Trim)).ToArray

---

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

Top 3 Topics with Most Views

Queue based trigger in orchestrator- problem made by @akhils with 50 views.

Regex Expression for finding particular number made by @Sahil_Garg1 with 45 views.

Write CSV problem (numbers in general format with +12) made by @Pablo_Sanchez with 39 views.

Top 3 Topics with Most Replies

Regex Expression for finding particular number made by @Sahil_Garg1 with 30 replies.

How to add data in new data column? made by @Mandava_Naresh with 24 replies.

Write CSV problem (numbers in general format with +12) made by @Pablo_Sanchez with 23 replies.

Top 3 Users Who Posted The Most

@AkshaySandhu made 28 posts!

@Felix_Effendi made 21 posts!

@Yoichi made 21 posts!

Top 3 Most Liked Posts

This post made by @seanrockvz13 received 2 likes!

Document Understanding Process - 2022.6-preview Release

Thanks for this update @Sergiu.Wittenberger, @Alexandru-Luca , @Teodora_Patrascu

This post made by @JSR_Techno_Talk_s received 2 likes!

Dictionary issue

Thanks Buddy , For Quick answer and ur suggestion

This post made by @Nithin_P received 1 likes!

Moving Licences from a Orchestrator to another

Hi @rene.ramirez, Yes, all the Non-Prod Licenses can be consolidated into a single Non-Prod Orchestrator. Please raise a support ticket using this form, UiPath License Support team will help you out with this request. Thanks & Regards, Nithin

Top 3 Most Liked Solutions

This solution provided by @grkiran2 received 1 likes!

Using statement in uipath

Came across your post looking how to implement using statement in UiPath. Still haven’t found it. To your other question, you can use Invoke Method activity to execute certain statements. If you are dealing with collections, you can still use Invoke Method, but there are some activates which make it easier to add, clear, remove etc. from a collection. Search for ‘Collection’ in Activities panel to find those activities.

This solution provided by @Srini84 received 1 likes!

Getting the sum of row for thousands of employees

@Robert_Russell_Monsalud Check below workflow for your reference SumusingExcelForumla.zip (202.3 KB) If this helpful for you, please close this thread by clicking on Mark as solution this post so that others can be beneficial Hope this may help you Thanks

This solution provided by @jack.chan received 1 likes!

How do I subtract two Columns?

@kishan.savaliya try this Test (2).xaml (11.4 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 | 08 July 2022

Top 3 Topics with Most Views

How to Check Today's is Third Thursday of month or not made by @Buvaneshwaran_R with 43 views.

How to use typeinto without indicating element on screen? made by @shraddha_joshi with 40 views.

UnAttended Robotのタスク設定について made by @1111202 with 37 views.

Top 3 Topics with Most Replies

Issues with Except/Remove dublicate rows in two datatables made by @Xheni_Xhensila with 15 replies.

Create Dispatcher and Performer Bot without Orchestrator made by @Vincent_Nuestro with 15 replies.

This error means? made by @taruna.mehra with 15 replies.

Top 3 Users Who Posted The Most

@ppr made 26 posts!

@THIRU_NANI made 19 posts!

@NIVED_NAMBIAR made 18 posts!

Top 3 Most Liked Posts

This post made by @HeartCatcher received 4 likes!

How to subtract two numbers

Hi All, I need to subtract two numbers in a process. Please do needful to achieve this. For ex: if I subtract 100 from 200 the answer will be 100 i.e:200-100=100 How to achieve this using UIpath?? @ushu @palanikumar @Palaniyappan @Gokul001 @ppr @Yoichi @gantalaramu @lakshman @geetishree.rao

This post made by @Kane_Baden1 received 3 likes!

Queue status getting updated to successfull even when system/application exception occurs

It will be caused by Process.xaml completing successfully, not throwing an error out to the main.xaml portion of the REFramework. If you’re handling errors in the process.xaml you will need to either throw an error after the exception messages are sent OR pass back that a failure occured during the process.xaml so that the outer xaml can route it appropriately.

This post made by @Yoichi received 2 likes!

How to Check Today's is Third Thursday of month or not

Hi, How about the following? d = DateTime.Today Then, condition will be d.DayOfWeek = DayOfWeek.Thursday AndAlso d.Day>=15 AndAlso d.Day<=21 Regards,

Top 3 Most Liked Solutions

This solution provided by @Kane_Baden1 received 3 likes!

Queue status getting updated to successfull even when system/application exception occurs

It will be caused by Process.xaml completing successfully, not throwing an error out to the main.xaml portion of the REFramework. If you’re handling errors in the process.xaml you will need to either throw an error after the exception messages are sent OR pass back that a failure occured during the process.xaml so that the outer xaml can route it appropriately.

This solution provided by @Yoichi received 2 likes!

How to Check Today's is Third Thursday of month or not

Hi, How about the following? d = DateTime.Today Then, condition will be d.DayOfWeek = DayOfWeek.Thursday AndAlso d.Day>=15 AndAlso d.Day<=21 Regards,

This solution provided by @Melvin_Abraham received 2 likes!

Remove Zeroes At the Start of the Number

I believe you should not use like this as it will remove all the zeros including the ones in between the numbers. To remove zeros only at the starting, you can use the below function. variable.TrimStart("0"c) 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 | 09 July 2022

Top 3 Topics with Most Views

Font size of text within activity made by @patrick_p3 with 31 views.

How to extract text beside a keyword from PDF made by @audrxyx with 30 views.

How to find ui elements in below use case made by @shraddha_joshi with 29 views.

Top 3 Topics with Most Replies

Reading multiple excel file with password protected and save it another excel file made by @SH_94 with 11 replies.

Get monday date from specific week number made by @M1288 with 10 replies.

How to find ui elements in below use case made by @shraddha_joshi with 7 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 16 posts!

@M1288 made 7 posts!

@ushu made 6 posts!

Top 3 Most Liked Posts

This post made by @Aakash_Chaurasiya1 received 1 likes!

Error Send SMTP Mail Message: 534: 5.7.9 Application-specific password required. Learn more at

Its Working

This post made by @Nitya1 received 1 likes!

How to Include HTML table in mail Body with dynamic Values inUiPath

Sometimes we might need to send the emails which will contain the tabular data in it… This small HTML template can help you in inserting tabular structure inside the mail body. Implementation using UiPath Step 1: In the Html Template file provided, Add the required number of “tags” for the required number of rows inside the table. [image] Drag “Read Text File“ activity into the designer panel and provide the html file path to it. Read the Html Content into a String Variable UserData. [i…

This post made by @harmeet.singh1 received 1 likes!

UiPath - Sales Engineer - Austin - United States - Full Time

Job title: Sales Engineer Job role: Other Role Country: United States City: Austin Company name: UiPath Employment Type: Full Time Seniority level: Senior more than 5 years Job Description: Overview We see boundless potential in the way we live. It drives the way we work. Our culture is our most valuable asset. It acts like a compass for us. We are fast, immersed, humble and bold. And that’s not just words on the walls. Eliminating time-consuming tasks means people get to do more of wh…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Studioで繰り返し（各メール）のOutlookアカウントカードを設定するには？

こんにちは 例えば以下になります。 [image] O365OutlookやGmailでも利用できます。詳しくはドキュメントを参照すると良いかと思います

---

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

Top 3 Topics with Most Views

How to use a dynamic selector in a webform drop down list made by @Shaun_21 with 38 views.

Log in check and if exists log out made by @sayali_rokade with 36 views.

Password Proctected Excel File made by @SH_94 with 35 views.

Top 3 Topics with Most Replies

Condition to filter date from excel made by @KKsekar with 21 replies.

Error code 1002 in add queue item made by @vignesh_S.M with 7 replies.

Deleting unnecessary data in excel made by @Hey_hi with 7 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 24 posts!

@Rahul_Unnikrishnan made 18 posts!

@NIVED_NAMBIAR made 9 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 4 likes!

Monthly Forum rewards - June 2022

Congratulations to everyone Keep rocking

This post made by @Rahul_Unnikrishnan received 3 likes!

Perform Data Extraction on web page that delays to navigate to next page

Hello @stanstilo You can modify the DelayBetweenPagesMS property in Data extraction. DelayBetweenPagesMS - The amount of time, in milliseconds, to wait until the next page is loaded. (If the loading time of the page is longer, this value should be higher.)

This post made by @suraj.setty received 2 likes!

Monthly Forum rewards - June 2022

Congratulations to all the winners

Top 3 Most Liked Solutions

This solution provided by @aanandsanraj received 2 likes!

Re-arrange the columns position in Excel

Hi @Hey_hi , Read the excel Use Filter Datatable Activity in output column tab add all the columns in the order you want Get the output and Write the datatable back to the same excel

---

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

Top 3 Topics with Most Views

Changes to Orchestrator roles and permissions made by @sebastian.ungureanu with 43 views.

"Failed to create a .........." while opening file made by @Povilas_Jonikas with 39 views.

ReFramework error made by @guptasweb with 38 views.

Top 3 Topics with Most Replies

Convert to integer error made by @d.ulutas with 22 replies.

Merge two excel sheets from different excel files using sheet name made by @Sukanya_Dutta with 22 replies.

I have to use click activity dynamically for some chapters how can i make it in automation? made by @lokeshmello with 21 replies.

Top 3 Users Who Posted The Most

@THIRU_NANI made 43 posts!

@Nithinkrishna made 25 posts!

@Rahul_Unnikrishnan made 22 posts!

Top 3 Most Liked Posts

This post made by @Rahul_Unnikrishnan received 4 likes!

How to use Create HTML Content activity to add tables and images to email body in UiPath?

Hello All, Those who are looking for a solution to add HTML content to the email body to add images, tables, or to do some formating to the font can watch the below video. You can learn about UiPath.Mail.Activities.Business.SendMailX & UiPath.Mail.Activities.Business.CreateHtmlContent . These activities are very easy to use and you can create your own html template for the emails. [How to use Create HTML Content activity to add tables and images to email body in UiPath? | AutoBot] …

This post made by @StefanSchnell received 3 likes!

Monthly Forum rewards - June 2022

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

This post made by @Nithinkrishna received 2 likes!

Wait For Download Grabs Temp File

Hey @serge.r The activity has been improved in the latest release which overcomes this scenario. You can say to activity which extension files to be ignored. Thanks #nK

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

モダン仕様とクラシック仕様の混在

こんにちは EXCEL関係のクラシックアクティビティはEXCELファイルを使うアクティビティ内で 使用できますので、それを使う必要があるのであれば、Excel Application Scopeと UseExcelFileを混在させるよりは、ExcelProcessScope-Use Excel Fileの構成にしておいて、 その内部でクラシックのReadRangeを使った方が良いかもしれません。 なおEXCELのプロセスを終了させないよう、ExcelProcessScopeは大きめに囲ってもらうと 良いかと思います。 [image]

This solution provided by @Yoichi received 1 likes!

StudioXの範囲指定

こんにちは 上段の処理ですと、取得できない様なのですが… 仕様としては可能と思いますが、どのように取得できないのでしょうか？ [image]

This solution provided by @Yoichi received 1 likes!

Regular Expression unrecognized escape sequence

Hi, Can you try to remove ^ as the following? System.Text.RegularExpressions.Regex.Match( filtereddata,@"(?<=Passport-Number\W)(\w.*)$").Value Regards,

---

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

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

[system]

Daily Forum Report | 12 July 2022

Top 3 Topics with Most Views

📢 Launching UiPath Community Global HyperHack 2022 🔥 made by @cristina.vidu with 73 views.

Transferring of multiple column values from one excel sheet to another excel sheet made by @Robert_Russell_Monsalud with 43 views.

Filtering Huge Data from Excel made by @Mirai with 40 views.

Top 3 Topics with Most Replies

Transferring of multiple column values from one excel sheet to another excel sheet made by @Robert_Russell_Monsalud with 13 replies.

How to find row index of string in excel made by @minal.patil with 11 replies.

Add bulk data from excel to queue made by @M1288 with 11 replies.

Top 3 Users Who Posted The Most

@THIRU_NANI made 27 posts!

@postwick made 26 posts!

@Rahul_Unnikrishnan made 25 posts!

Top 3 Most Liked Posts

This post made by @cristina.vidu received 8 likes!

Launching UiPath Community Global HyperHack 2022

We are officially calling UiPath Community HyperHack 2022 OPEN!!! Are you a problem solver within your team or organization? Do you often come with innovative solutions for any business problems that come across? Do you think you can improve the existing business processes using UiPath? UiPath Community opens the playground to bring together automation enthusiasts, innovators, RPA developers, analysts a…

This post made by @lukasziebold received 2 likes!

How to set execution target for 'Queue' trigger type?

Sorry to be blunt, but wtf?! I was really looking forward to working with Queue Triggers and tested it today. Really disappointing to not have this option I was using on Time Triggers all the time. Is this a cycle of people don’t use it much → no company resources allocated to this issue → people won’t use it more? Can we get some more info on this? @badita @loginerror Thank you and best regards, Lukas

This post made by @sachin.lather received 2 likes!

Monthly Forum rewards - June 2022

Congratulation to all the winners… You are rocking guys… @StefanSchnell @Nithinkrishna @Rahul_Unnikrishnan specially you guys… Keep rocking …

Top 3 Most Liked Solutions

This solution provided by @THIRU_NANI received 1 likes!

Orchestrator Basic version to standard upgrade

Hey! Welcome to community! Read the below docs… Regards, NaNi

This solution provided by @postwick received 1 likes!

Add Data Column does not work but it does not show any error message

Another possible reason is that if you’re writing back to the spreadsheet with Append Range and have an additional column of data in your datatable, it will NOT rewrite the headers at the top of the Excel file.

This solution provided by @ushu received 1 likes!

Filtering Huge Data from Excel

@Mirai That’s right. Excel as a Database helps to manipulate the data using SQL queries without using any variable in prior to store the input data. Below docs for ref

---

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

Top 3 Topics with Most Views

How to delete comma(,) to the last row in C# made by @Vamsikrishna_Talam with 42 views.

Calculate Client Security Hash assignment shows 0/100 made by @choomj with 36 views.

How to delete Duplicate column using uipath made by @sandhyareddy with 33 views.

Top 3 Topics with Most Replies

How to delete comma(,) to the last row in C# made by @Vamsikrishna_Talam with 20 replies.

Search the Latest Previous File in Folder made by @Gagan_Chaudhari with 13 replies.

Type into: Indicate in Excel failed. Cannot attach to document made by @Emmy_O with 12 replies.

Top 3 Users Who Posted The Most

@THIRU_NANI made 49 posts!

@Nithinkrishna made 35 posts!

@Rounak_Kumar1 made 24 posts!

Top 3 Most Liked Posts

This post made by @SantoshSundar received 3 likes!

SAP S4H Upgrade 760 -770 Impact on UiPath BAPI Automation

Thank you both so much @StefanSchnell and @LevKushnir. We are looking at both the options. Today, we are going to upgrade the connector from 3.0.21 to 3.0.24 as suggested on SAP Blogs. If the above hasn’t worked, then there is a mention about an object called EX_FUNCTIONS that is references in the metadata of this BAPI call. Below are couple of images of how we arrived at this. I’ll keep you updated on this thread on which of the above fixes the issue. [MicrosoftTeams-image …

This post made by @Robert_Russell_Monsalud received 2 likes!

Transferring of multiple column values from one excel sheet to another excel sheet

Good Day, Everyone. Aside from the help and guidance of Sir @jack.chan, Sir @Rounak_Kumar1, Sir @Veera_Raj, and Sir @postwick, I also finally came up with a solution. I used the VLOOKUP Formula in Microsoft Excel. Kindly see below attached files for the workflow, picture of the desired output, and the excel file being used. Thank you. [image] Main.xaml (13.0 KB) SampleExcelFile.xlsx (180.6 KB) Best regards, Robert Monsalud

This post made by @barani.chidambaram received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, very nice to meet you all. My name is Baranitharan from Chennai, India. I am RPA enthusiast and planned to specialize in UiPath. Happy here to learn, share and discuss.

Top 3 Most Liked Solutions

This solution provided by @jack.chan received 1 likes!

Transferring of multiple column values from one excel sheet to another excel sheet

vba method: the logic is simple, just fill in vlookup formula in the first row and drag it all the way down, it takes an instant to fill in 3000 rows: [image] Steps copy this code to vba.txt (same folder as your project) Function Macro1() ActiveWorkbook.Sheets("WorkingSheet").Activate Range("C2").Formula = "=VLOOKUP($B2, SourceSheet!$A:$D, 2, FALSE)" Range("D2").Formula = "=VLOOKUP($B2, SourceSheet!$A:$D, 3, FALSE)" Range("E2").Formula = "=VLOOKUP($B2, SourceSheet!$A…

This solution provided by @kumar.varun2 received 1 likes!

Formula is applied in Excel, When the bot put the value but its not reflecting on total. But if manually typing the total is coming. Only when bot writes its not reflecting in total

@Praveen_Vs Try like this [image]

This solution provided by @kumar.varun2 received 1 likes!

GroupBy Datatable using LINQ UiPath

Hi @Dang_Ngoc_Duy_DPS.VN.MSG You can proceed like this [image] The LINQ query used is given below ( From row In dt_Data Group row By k=row("Manager Account").ToString.Trim Into grp=Group Select dt_GroupedData.Rows.Add({k, String.Join(", ",grp.Select(Function(gr) String.Join("-",gr.ItemArray)))}) ).CopyToDataTable Please read the post by @ppr Xaml File for reference GroupByUsingLINQ.xaml (6.6 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 | 14 July 2022

Top 3 Topics with Most Views

Document Understanding - Creating Excel file and Referencing the same in the end of workflow made by @srinivas_pradeep with 40 views.

How to change entire column date format from "dd-MMM-yyyy" to "MM/dd/yyyy" in one go made by @Krithi1 with 37 views.

How to use Assign activity on Excel? made by @Praveen_Vs with 35 views.

Top 3 Topics with Most Replies

Document Understanding - Creating Excel file and Referencing the same in the end of workflow made by @srinivas_pradeep with 27 replies.

Get DOM element - help made by @Anjali_Rani with 14 replies.

How to change entire column date format from "dd-MMM-yyyy" to "MM/dd/yyyy" in one go made by @Krithi1 with 11 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 32 posts!

@Rounak_Kumar1 made 24 posts!

@Rahul_Unnikrishnan made 20 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

XLS - Write Cell - long number

Hi, The following document might help you. Regards,

This post made by @Steven_McKeering received 2 likes!

Need regex code for this

Hello @Rana_Reddy Welcome back to the forums . Take a look at these patterns. Name Amount Due Invoice Number Date of issue To make the best patterns more information is better along with expected outputs. If you want to learn Regex check out my MegaPost. Hopefully this helps Cheers Steve

This post made by @THIRU_NANI received 2 likes!

How to use Assign activity on Excel?

Hey! We can use Add data row to add the rows to particular column… We can use Writecell as well As suggested by the @NIVED_NAMBIAR we can also do in this case CurrentRow("ColumnName").ToString.Trim = Value Regards, NaNi

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

XLS - Write Cell - long number

Hi, The following document might help you. Regards,

This solution provided by @Steven_McKeering received 2 likes!

Need regex code for this

Hello @Rana_Reddy Welcome back to the forums . Take a look at these patterns. Name Amount Due Invoice Number Date of issue To make the best patterns more information is better along with expected outputs. If you want to learn Regex check out my MegaPost. Hopefully this helps Cheers Steve

This solution provided by @Nithinkrishna received 1 likes!

Microsoft Office 365 Scope window

Okay you can directly use O365 activities or download the file locally into the machine & Workbook activities can be used.

---

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

Top 3 Topics with Most Views

I don't have uipath folder made by @sevgi_gundogdu with 44 views.

Williams Lea - Automation Developer - UI Path - chennai - India - Full Time made by @mark.cripps with 43 views.

Download excel file from edge browser and rename directly made by @Nightowl_music with 42 views.

Top 3 Topics with Most Replies

Type activity issue with [[ or other special characters made by @IPIX with 14 replies.

Download excel file from edge browser and rename directly made by @Nightowl_music with 11 replies.

Extract mail address from string using string mehod made by @Sandhya_Gajare with 9 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 31 posts!

@Rounak_Kumar1 made 29 posts!

@THIRU_NANI made 25 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

How to add numbering after sort?

HI, Is your requirement re-assign “No” column in order? If so, the following will work. dt = dt.AsEnumerable.OrderBy(Function(r) r("Branch").ToString).Select(Function(r,i) dt.Clone.LoadDataRow({(i+1).ToString,r("Name").ToString,r("Branch").ToString},False)).CopyToDataTable Regards,

This post made by @April_A_Arnott received 1 likes!

Automation Awareness - The Automation Journey - We want to hear your thoughts!

What automation phase intrigued you the most, was all of it but before getting started I was interested in the mining part. And what UiPath product you cannot wait to put your hands on. I am so new to it all I just would be happy to start and get the hang of assist if possible and create.

This post made by @ushu received 1 likes!

How to use Assign activity on Excel?

Hello @Praveen_Vs You can do this process with single write cell activity. Please try attached workflow Example.zip (10.2 KB)

Top 3 Most Liked Solutions

This solution provided by @ushu received 1 likes!

How to use Assign activity on Excel?

Hello @Praveen_Vs You can do this process with single write cell activity. Please try attached workflow Example.zip (10.2 KB)

This solution provided by @THIRU_NANI received 1 likes!

Compare 2 excel sheets data

Hey! Try like this… Read range->FirstData1->Output As->Dt1 Read range->Data2->Output As->Dt2 Take one assign Activity create int variable like this Counter = 1 Take 2 for each row in data table activities For each row pass the Dt1 inside the First For each row take second for each row pass the dt2 now take one IF Condition and pass the expression like this CurrentRow1("Payment mode").ToString.Trim.Equals(CurrentRow2("Payment mode").ToString.trim) AND CurrentRow1("Payment").ToString.Tri…

This solution provided by @THIRU_NANI received 1 likes!

How to scroll down till find a unmarked box in excel

Hey! You can give the Date which you wants to check Now.ToString("yyyy") This will give you the present year Regards, NaNi

---

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

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

[system]

Daily Forum Report | 16 July 2022

Top 3 Topics with Most Views

How to convert pdf to excel? made by @vinjam_likitha with 35 views.

How to schedule bot randomly made by @Rana_Reddy with 34 views.

Bulk queue item - Reference ID made by @Reni_Sweta with 34 views.

Top 3 Topics with Most Replies

How to read an Excel like below. Also contains merged cells made by @Shanika_Perera with 13 replies.

Orchestrator logs has disapeared made by @minolp with 8 replies.

Send SMTP Error made by @Irfan_Shaik with 8 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 20 posts!

@THIRU_NANI made 15 posts!

@Rounak_Kumar1 made 12 posts!

Top 3 Most Liked Posts

This post made by @Nitya1 received 1 likes!

How to resize Image in UiPath

Hi @THIRU_NANI I will share the type of variables I used in this case.

This post made by @Karthikeyan.gsm received 1 likes!

Automation Awareness - The Automation Journey - We want to hear your thoughts!

I am impressed with all the components of UiPath. Absolutely interesting. Want to start with Studio.

This post made by @StefanSchnell received 1 likes!

Error at ForEachRow Activity from UiPath.System.Actvities 22.7.0-preview

The ForEachRow activity of the 22.7.0 preview requires a value for the argument Values, but there is no input field Values. Am I overlooking something or is it actually missing? [image]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Http request not work, anyone can help me please

Hi, The following might help you. This caused by mismatch RestSharp version. It might be needed to upgrade or downgrade Studio. Regards,

This solution provided by @ccrespo9669 received 1 likes!

Probles to identify files with Gsuite Activities

done!!! It was a problem of configuration of permissions in the API in console.cloud.google.com. Sorry for the disturbances. Thank yoy very much Rahul for your help. I really apreciate it. Thanks. César

---

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

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

[system]

Daily Forum Report | 17 July 2022

Top 3 Topics with Most Views

Uipath orchestrator says job is running but no job is running made by @PirateCaptain with 51 views.

Finally is not executed made by @shraddha_joshi with 39 views.

Can we add more than one key-value pair to dictionary using invoke method made by @mcashwin with 33 views.

Top 3 Topics with Most Replies

String split \n made by @sebastiano_santini with 14 replies.

Sharepoint Metadata updation made by @Giriraj_Vishwas_Hande with 12 replies.

How to generate a random 8 character string with a certain format made by @Archie with 10 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 21 posts!

@jack.chan made 9 posts!

@Yoichi made 9 posts!

Top 3 Most Liked Posts

This post made by @chamati received 1 likes!

Error Send SMTP Mail Message: 534: 5.7.9 Application-specific password required. Learn more at

Thank you, it worked for me.

This post made by @seun_mat received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

My name is Sean Ojay from Nigeria am only trying to explore or i want to explore uipath forum

This post made by @Nitya1 received 1 likes!

How to resize Image in UiPath

Here, are the types of variables used to resize the image. [image]

Top 3 Most Liked Solutions

This solution provided by @jack.chan received 1 likes!

How to avoid overwriting existing rows that already have values?

sorry try this instead, Main (1).xaml (17.7 KB)

This solution provided by @Yoichi received 1 likes!

How to generate a random 8 character string with a certain format

Hi, How about the following? [image] System.Text.RegularExpressions.Regex.Replace(format,"C|N",Function(m) if (m.Value="C",Chr(rnd.Next(65,90)).ToString ,if(m.Value="N",Chr(rnd.Next(48,57)),"-"))) Sequence5.xaml (5.8 KB) Regards ,

This solution provided by @jack.chan received 1 likes!

String split \n

do this first @sebastiano_santini declare variable lineArray ( array of string) [image] then assign lineArray = System.text.regularexpressions.regex.split(Text, environment.Newline) now lineArray(0) will print Jack

---

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.