Forum Engagement Daily Reports

[system]

Daily Forum Report | 11 June 2022

Top 3 Topics with Most Views

Please help for data scrapping made by @taruna.mehra with 35 views.

How to read header and subleaders dynamically made by @Dev2 with 30 views.

UI path click activity made by @Kavitha_Saro with 30 views.

Top 3 Topics with Most Replies

Notifying the same place by e-mail for the wrong incoming e-mail made by @ertan_ay1 with 16 replies.

Performer Assignment problem with assign activity! made by @kjaiswal with 15 replies.

How to use the downloaded excel file from web in excel application scope path made by @sharu_priya with 11 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 37 posts!

@Nithinkrishna made 19 posts!

@muhammedyuzuak made 14 posts!

Top 3 Most Liked Posts

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

This post made by @Latoya_mbatha received 1 likes!

How do i get uipath to send text to the last table in word doc template using

thankyou so much

This post made by @Nithinkrishna received 1 likes!

How do i get uipath to send text to the last table in word doc template using

Hey @Latoya_mbatha Kindly try the below, finalReportTables.Last().Cell(2,1).Range.Text = in_TextToInsert; Hope this helps. Thanks #nK

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

How do i get uipath to send text to the last table in word doc template using

Hey @Latoya_mbatha Kindly try the below, finalReportTables.Last().Cell(2,1).Range.Text = in_TextToInsert; Hope this helps. Thanks #nK

This solution provided by @muhammedyuzuak received 1 likes!

Notifying the same place by e-mail for the wrong incoming e-mail

Great then read the mail first and check the format. You can parse this text with regex or split actions. You can check the values ​​as a result of the algorithm you use while doing this. If it does not come true or is empty, you can return to the same mail by using the reply mail directly. If it happens, you will go to the service with these values ​​and draw dry.

This solution provided by @kjaiswal received 1 likes!

Unresolved Error !Help required

I got the solution the problem was performer I ran yesterday and today i am doing dispatcher so the work items used to get update daily and it was not able to find the same WIID so I ran today and now its working fine…

---

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

Top 3 Topics with Most Views

Web Scraping Issue - Shipping Details made by @WSONG71 with 42 views.

Checkbox Error made by @d.ulutas with 37 views.

Cannot install my C# nuget Package made by @bo_jin with 37 views.

Top 3 Topics with Most Replies

Checkbox Error made by @d.ulutas with 19 replies.

Generate yearly report-Remaining value in queue is 0 made by @Parul_Yadav with 13 replies.

Web Scraping Issue - Shipping Details made by @WSONG71 with 11 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 28 posts!

@Rahul_Unnikrishnan made 18 posts!

@Latoya_mbatha made 15 posts!

Top 3 Most Liked Posts

This post made by @coder received 1 likes!

Multiply column in excel with 50 using LINQ query

Hello, I am trying to multiply column “A” with 50 and write the result in “Result” Column. With the total of the Result . [image] can any one help me how i can do that with LINQ Query Thank you

This post made by @AshwinS2 received 1 likes!

Multiply column in excel with 50 using LINQ query

Hi @coder Try this [HowTo] - First Start with LINQ (VB.Net) Thanks Ashwin.S

This post made by @Nithinkrishna received 1 likes!

Multiply column in excel with 50 using LINQ query

Hey @coder Please find the demo below, nmnithinkrishna_AddInUpdateXLCol.zip (9.7 KB) Hope that helps. Thanks #nK

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Multiply column in excel with 50 using LINQ query

Hey @coder Please find the demo below, nmnithinkrishna_AddInUpdateXLCol.zip (9.7 KB) Hope that helps. Thanks #nK

This solution provided by @Nithinkrishna received 1 likes!

HTTP Request Body in JSon - Help

Hey @Anjali_Rani Please try using, vbLf also in replace ! vbLf also stands for new line in VB Thanks #nK

This solution provided by @Yoichi received 1 likes!

8桁の文字列を日付かを確認する方法

こんにちは 以下でいかがでしょうか？ DateTime.TryParseExact("20220606","yyyyMMdd",System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None,New DateTime)

---

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 2022

Top 3 Topics with Most Views

Download all files from the google drive folder made by @Sandhya_Mora with 47 views.

How to Mark email as Read which matches specific subject from exchange mail server made by @Marian_B with 46 views.

How to get the selector based on mouse cursor position made by @BNK with 44 views.

Top 3 Topics with Most Replies

Data Scrapping from web made by @taruna.mehra with 15 replies.

How to remove hyperlinks in Excel made by @Ishan_Shelke1 with 14 replies.

How to Mark email as Read which matches specific subject from exchange mail server made by @Marian_B with 14 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 43 posts!

@Nithinkrishna made 36 posts!

@muhammedyuzuak made 21 posts!

Top 3 Most Liked Posts

This post made by @Leonardo_Andrade received 2 likes!

Can't Invoke Process - Attended Automation Features in Studio

Thank you Rahul and Nithin, I already found the error. It was just the scope of the variables that I was using.

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

How to write Grade from given percentage in excel?

refer to this Excel.xaml (17.5 KB) result [image]

This post made by @David_Poling received 1 likes!

Feedback wanted -> Attended Framework

I found the attended framework very helpful. I really like the form that is included and the ability to update it as the process executes to give the user insights on what the bot was doing. I had a use case where the attended framework was using queue items. The bot gathers data from SAP (dispatcher) and enters it into a website where the login required a mobile app code for MFA. I did not see an option to use a queue with the attended framework so I had to add those pieces myself. If this co…

Top 3 Most Liked Solutions

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

How to write Grade from given percentage in excel?

refer to this Excel.xaml (17.5 KB) result [image]

This solution provided by @Yoichi received 1 likes!

Matches Activity Returns Blank

Hi, Can you try the following pattern? (?<=TIN:\s)\d* Regards,

This solution provided by @Veera_Raj received 1 likes!

How to update the existing records in salesforce?

update record activity you can use for update existing record step 1 : send id as a reference in input step2 : after that please use that activity inside composite request [Salesforce Automation with UiPath | Part1] please follow the above video

---

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 2022

Top 3 Topics with Most Views

How to create a dynamic delay? made by @educadoinstitute with 52 views.

文字の置換方法について made by @moom with 43 views.

Data extraction process of the central bank according to the date and currency type received with the mail body made by @ertan_ay1 with 40 views.

Top 3 Topics with Most Replies

Data extraction process of the central bank according to the date and currency type received with the mail body made by @ertan_ay1 with 30 replies.

How to use the condition in web automation? made by @HeartCatcher with 18 replies.

Data scrapping handling made by @taruna.mehra with 15 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 44 posts!

@Nithinkrishna made 28 posts!

@ertan_ay1 made 24 posts!

Top 3 Most Liked Posts

This post made by @lavmang received 2 likes!

Event Data Filters for Integration Service released!

Great. Now integration service is finally useful! Would be great if there would be a possibility to “queue” the triggered process, in our use case we would like to start it only after work hours so that the production license is available for work-hour scheduled processes.

This post made by @ankit.jain2 received 2 likes!

Email Headers Issue

Hello All, i am facing issue in mail.headers attribute , when i am separately running the process its working fine . In the watch panel Mail.headers showing 9 properties but when i am invoking the same workflow its showing only 2 attribute i.e.’ uid , message id. Dependency and uipath reinstalled already

This post made by @muhammedyuzuak received 2 likes!

Data extraction process of the central bank according to the date and currency type received with the mail body

Hi @ertan_ay1, Can you try going directly to the date range instead of selecting a date on this page? Then you can pull this table with datascraping and filter the rows you want. I am sharing an example, use the format in this example. https://www.tcmb.gov.tr/kurlar/[year][month]/[day][month][year].xml https://www.tcmb.gov.tr/kurlar/202206/14062022.xml Additionally, you can use the API. I am sharing the link so you can follow it. https://evds2.tcmb.gov.tr/help/videos/EVDS_Web_Servis_Kull…

Top 3 Most Liked Solutions

This solution provided by @Rahul_Unnikrishnan received 1 likes!

Orchestrator keeps signing me out of Unattended robot

Hello @hurmet.noka So whenever you are trying to Run the process are you getting this error or only during debug? Please make sure you have properly allocated the unattended license. [UiPath - How to connect UiPath to Orchestrator|Run Process,Jobs & Triggers|UiPath Licensing]

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

How to set red colour to complete row text when column "Results" contains failed?

yes but its troublesome, if you want to highlight whole row, do this instead add below code to vba.txt Function highlightCellRedWholeRow(rowNumber As Integer, sheetName As String) ActiveWorkbook.Sheets(sheetName).Activate Rows(CStr(rowNumber) & ":" & CStr(rowNumber)).Select With Selection.Font .Color = vbRed End With ActiveWorkbook.Save End Function use invoke VBA in excel application scope, set function name = highlightCellRedWholeRow, entryMethodParameters = {…

This solution provided by @Veera_Raj received 1 likes!

How to extract "specific data rows" from excel

table= table.select(“‘columnname’=‘LT’”).copytodatatable() or use filter table activity and configure your column name and value [filtertable]

---

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

Top 3 Topics with Most Views

How to select the radio button? made by @HeartCatcher with 47 views.

How to remove rows from data table made by @Rhys18 with 38 views.

Im getting one number from excel then putting into search box then it will show similar matches but it has to click on the number that i have given..so i tried to pass the variable in selector but the error message shows like this made by @sathish_Kumar6 with 35 views.

Top 3 Topics with Most Replies

Im getting one number from excel then putting into search box then it will show similar matches but it has to click on the number that i have given..so i tried to pass the variable in selector but the error message shows like this made by @sathish_Kumar6 with 32 replies.

How to fix Length cannot be less than zero made by @Bot_Submission with 21 replies.

How to select the radio button? made by @HeartCatcher with 17 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 27 posts!

@Nithinkrishna made 22 posts!

@nikhil.girish made 22 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 2 likes!

Learnings from EuroSTAR 2022 Copenhagen - Feature request

Firstly, it was great discussing test suite capabilities with @Gernot_Brandl @ThomasStocker @Horea_Soanca and Balwant. Thank you for your efforts. This feedback post is based on one particular observation I made at the Leapwork expo booth at the EuroSTAR conference. After getting an indepth demo from Leapwork, one particular feature which stood out was the ease of debugging in their platform. I do strongly believe that such a feature can benifit both the UiPath Test Suite and UiPath Studio / O…

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

Download version of my code from orchestrator

Hi @Ajay_Chaudhari To download the Older Version of the package Please Navigate to Package under tenants and click on view Versions and the download the required versions. [Screenshot_20220615-075725~2] Thanks

This post made by @RajKumarDuraiFAS received 2 likes!

Data extraction process of the central bank according to the date and currency type received with the mail body

Hi @muhammedyuzuak , this is working for current month only, not working for pervious month like below mentioned https://www.tcmb.gov.tr/kurlar/202205/03052022.xml Thanks, RajKumar

Top 3 Most Liked Solutions

This solution provided by @suraj.setty received 2 likes!

Download version of my code from orchestrator

Hi @Ajay_Chaudhari To download the Older Version of the package Please Navigate to Package under tenants and click on view Versions and the download the required versions. [Screenshot_20220615-075725~2] Thanks

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

Issue // error

Hi @Narendra_N Welcome to community Kindly use kill process activity and mention in properties process name as “EXCEL” and set continue on error as true Hope this helps

This solution provided by @supermanPunch received 1 likes!

How to get pdf's from particular folder

Hi @Muralikrishna_Surve , It seems that there are two namespaces which has the same Method Directory, for your case, you may need to include the System.IO along with the Directory.GetFiles like below : System.IO.Directory.GetFiles("E:\GoogleSheet\GoogleSheet")

---

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

Top 3 Topics with Most Views

Business rule exceptions made by @HeartCatcher with 52 views.

How to extract values from excel? made by @anjasing with 40 views.

Appending Column To Another Sheet made by @Rishik_Chowdary with 38 views.

Top 3 Topics with Most Replies

Business rule exceptions made by @HeartCatcher with 25 replies.

Studio does not start "No robots configured..." made by @Roman_Bradac with 18 replies.

Getting Data From Json made by @Rishik_Chowdary with 15 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 32 posts!

@Veera_Raj made 24 posts!

@suraj.setty made 19 posts!

Top 3 Most Liked Posts

This post made by @postwick received 3 likes!

Couldn't find Database Execute Non Query activity in Uipath studio even after installing uipath.database.activites

Telling people to downgrade is bad advice.

This post made by @Veera_Raj received 3 likes!

Couldn't find Database Execute Non Query activity in Uipath studio even after installing uipath.database.activites

the activity name is changed for insert,update,delete activity name is - run command - execute non query run query is execute query activity

This post made by @postwick received 2 likes!

Couldn't find Database Execute Non Query activity in Uipath studio even after installing uipath.database.activites

I’ve noticed that the searches tend to find the new activity too. In other words if you search for “execute non” it pulls up Run Command because that’s the replacement for Execute Non Query. They did quite a good job on all this, but a lot of people seem unaware of how it works. [image]

Top 3 Most Liked Solutions

This solution provided by @Lak_Ui received 2 likes!

Cron expression invalid syntax

0 0 11 ? * MON-FRI * try this

This solution provided by @Veera_Raj received 1 likes!

Whenever i add new record in salesforce unable to get id or reference for further process?

for see response and id please use it inside composite request activity output will be datatable

This solution provided by @Steven_McKeering received 1 likes!

Cron Expression Query

Hey @gokul1904 Another Cron Expression incase you still need it: 0 0 8,10,12,14,16,18 ? * MON,TUE,WED,THU,FRI * Description: At 08am, 10am, 12pm, 2pm, 4pm and 6pm, on every Monday, Tuesday, Wednesday, Thursday and Friday, every month If you want to do a final run at 7pm (note the last two runs will only be 1 hour apart) then see the below expression: 0 0 8,10,12,14,16,18,19 ? * MON,TUE,WED,THU,FRI * Description: At 08am, 10am, 12pm, 2pm, 4pm, 6pm and 7pm, on every Monday, Tuesday, Wednes…

---

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

Top 3 Topics with Most Views

RPA Developer Kickstarter - It's a Wrap made by @rahulsharma with 65 views.

Use of a RAM Disk with Security Aspects made by @StefanSchnell with 45 views.

Trouble creating new folders automatically made by @Nathan_Betters1 with 41 views.

Top 3 Topics with Most Replies

Write Text File - One or more errors occured made by @Mohammed_Nawazuddin with 14 replies.

Updating values from Excel in Web Application made by @Abc_Xyz1 with 11 replies.

Bussiness log file made by @prathik_8679 with 11 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 34 posts!

@Nithinkrishna made 31 posts!

@muhammedyuzuak made 21 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 6 likes!

Use of a RAM Disk with Security Aspects

Why RAM Disk? A RAM disk is a representation of a hard disk in Random Access Memory (RAM). Normally it is used, because it has a much better performance compared to a hard disk drive (HDD). But there are other aspects why it can be use - security. When we persist files on an HDD we must also ensure that they are securely deleted again, especially if they contain personal or secret data. It is necessary that they cannot be recovered or reconstructed. In the case of an HDD we have to overwrite th…

This post made by @rahulsharma received 5 likes!

RPA Developer Kickstarter - It's a Wrap

RPA Developer Kickstarter was a great intiative by the UiPath Community that helped students/professionals to get started with RPA in the best way possible, event was hosted and organised by @Rohit_Radhakrishnan & @Vibhor.Shrivastava This event was power packed with 15 total sessions across different topics with live demo and explanation by experienced RPA professional along with this 2 “Ask Me Anything” sessions with RPA Mentors. Glad to be a part of this event by being the speaker in the ses…

This post made by @RAKESH_KUMAR_BEHERA received 2 likes!

UIPATH - EXCEL AUTOMATION - DYNAMIC | ADD DATA COLUMN AND VALUES EVERY HOUR

Visit this link to watch about dynamic Excel automation created from the ground up. [UIPATH - EXCEL AUTOMATION - DYNAMIC | ADD DATA COLUMN AND VALUES EVERY HOUR]

Top 3 Most Liked Solutions

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

Can you give me a scenario- why do we need to use rethrow?

because you might have common error handling logic e.g. send email Simple example: main calls process1 & process2 if we rethrow errors from process1&2 to main, then we only need to handle the errors in main.xaml if we dont rethrow, we need logic to send email in process1 & process2. Meaning code will be repeated [image]

This solution provided by @suraj.setty received 2 likes!

Not finding 'Activity Element Exists' in the library state

Hi @sumouse Please enable Show Classic from the project filter. [Screenshot_20220617-074523~2] Thanks

This solution provided by @ppr received 2 likes!

Check if keywords stored in array exists in array without for each

[grafik]

---

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

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

[system]

Daily Forum Report | 18 June 2022

Top 3 Topics with Most Views

Regex finding six digits made by @Thunder with 40 views.

How can I determine if text is selected in a Java Table? made by @grosner with 34 views.

Order the list of files made by @Shyam_Pragash with 33 views.

Top 3 Topics with Most Replies

Hotkey is working, but taking long time made by @Rhys18 with 15 replies.

Previous amount of month is double value made by @Rhys18 with 14 replies.

Get text and Filter from excel if matches in one go made by @sayali_rokade with 11 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 27 posts!

@muhammedyuzuak made 25 posts!

@Rhys18 made 19 posts!

Top 3 Most Liked Posts

This post made by @Nitya1 received 2 likes!
https://forum.uipath.com/t/449312/1

This post made by @Nitya1 received 2 likes!
https://forum.uipath.com/t/449310/1

This post made by @RAKESH_KUMAR_BEHERA received 1 likes!

UiPath Web Automation | Automate Web Data Extraction to Excel - UiPath Studio | UiPath Tutorials

[UiPath Web Automation | Automate Web Data Extraction to Excel - UiPath Studio | UiPath Tutorials]

Top 3 Most Liked Solutions

This solution provided by @muhammedyuzuak received 1 likes!

How to insert sheet using Insert Sheet activity

Hi @Sanket_Makwana, Welcome to community. You can follow the image below. Here you should first use the use excel file activity. This will give you the workbook. If you want to define a new workbook, you can use step 3. The other field is already sheet name. I hope that has been revealing. [image] Regards, MY

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

Get text and Filter from excel if matches in one go

@sayali_rokade see this example TEST.xaml (8.6 KB) [image] result NOT FOUND ======================== [image] result FOUND

This solution provided by @Yoichi received 1 likes!

Hotkey is working, but taking long time

Hi, For now, to isolate causes, can you try to set HardwareEvent at InputMethod property in Click activity for save button? 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 | 19 June 2022

Top 3 Topics with Most Views

Queue triggers do not work some times made by @shraddha_joshi with 35 views.

Using RE framework with Multiple Queues made by @shradha.joshi with 33 views.

Sorting Xml file based on an element made by @ahmed.alakhal-benltaifa with 29 views.

Top 3 Topics with Most Replies

Queue triggers do not work some times made by @shraddha_joshi with 25 replies.

Find last row with condition made by @anh.nguyen with 10 replies.

How to delete a transposed header? made by @Rhys18 with 8 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 38 posts!

@shradha.joshi made 13 posts!

@jon4378 made 10 posts!

Top 3 Most Liked Posts

This post made by @Nitya1 received 2 likes!

Happy Anniversary UiPath Learner, Virtual Party!

UiPath academy has made a great impact on my learning journey. Lot of free content available and can easily be accessible. Someone who would be new to UiPath could easily access the courses from the UiPath Academy and get certified.I always keep an eye on the new releases of UiPath courses and new features added to it. I congratulate UiPath Academy for completing 5 years.

This post made by @Umer_Shahid received 2 likes!

Happy Anniversary UiPath Learner, Virtual Party!

UiPath Academy is so so perfect that it prepares you to land your first RPA job so so easily. I completed my training on UiPath and it made the path for me to explore more RPA tools but when it comes to the base then all the credits go to UiPath Academy for developing such an amazing course. I keep on exploring new releases by UiPath and go for their new courses that are there and I am also planning to complete the certification too.

This post made by @jeevith received 2 likes!

Is it possible to integrate Git with UIPath Studio with Community License?

Hi @Lokesh_Chandra, Tldr: In short, UiPath Git integration covers the most used git commands which is a good starting point and if needed you can utilise additional commands from git bash or git gui. Git works on any folder with a .git folder after git is initialised in that folder. UiPath Studio has inbuilt integration with git for local repositories and GitHub for remote repositories. If you see limitations, you can always use either git GUI or git bash to do perform other operations which…

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

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

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

[system]

Daily Forum Report | 20 June 2022

Top 3 Topics with Most Views

Forms Activity New Package release - v2.0.0-preview made by @Venkata_Rajendran with 89 views.

How to run a project without ui studio? plz help. am a fresher made by @Nandhini_Vishnu with 39 views.

How to pass dynamic values to connection string made by @Suresh_Ghadai with 39 views.

Top 3 Topics with Most Replies

Scrapping last 4 week data dynamically made by @Jiban_Kumar_Das with 26 replies.

How to pass dynamic values to connection string made by @Suresh_Ghadai with 23 replies.

Excel taking time for Preserve format made by @Sharanabasava1 with 19 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 38 posts!

@Nithinkrishna made 24 posts!

@ppr made 22 posts!

Top 3 Most Liked Posts

This post made by @Venkata_Rajendran received 14 likes!

Forms Activity New Package release - v2.0.0-preview

We have launched a new version of the Form activity package (2.0.0-preview). With this release, we have significantly improved the performance and memory utilization of Forms. The form performance has improved by 10% when compared to previous versions while memory utilization has improved by 30%. We were able to achieve this improvement by making some key changes to how forms render as well as changing from CefSharp to the Webview2 framework. We have also split the Callout activities from the f…

This post made by @StefanSchnell received 7 likes!

Happy Anniversary UiPath Learner, Virtual Party!

Hello UiPath Academy, great, since five years you have been successfully on the road, congratulations.    The UiPath Academy with its courses was a crucial key for me to access RPA in general and UiPath in particular. I started with the entry-level courses and then specialized more and more - except when I was curious and particularly interested in something. For me achievements in this context means gaining knowledge, which I had with every course. As I became more professiona…

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

Happy Anniversary UiPath Learner, Virtual Party!

First of all Happy anniversary !! UiPath academy (More to GO) UiPath academy is so simplified , right on point with perfect courses and tutorials where it helps to prepare an individual to start his RPA Career. This was a starting/ Stepping stone for me to explore and learn about UIPATH. I have learned a lot from the academy which helped me to create simple/complex automations to Client and also has helped me to contribute some of my learning to the FORUM community. Thank you UiPath …

Top 3 Most Liked Solutions

This solution provided by @LevKushnir received 2 likes!

SAP same selector identified different in different environments

HI @jack.chan I would say, the solution is here: Please double check Best regards, Lev

This solution provided by @irahmat received 2 likes!

Getting “Invalid credentials (#MTI_7)” error, post changing the Admin password for a Tenant

Hi Manesha, the issue had solved by raising a ticket. and solution refer to this link https://forum.uipath.com/t/orchestrator-something-went-wrong-while-getting-discovery-document

This solution provided by @BenjenB received 2 likes!

Error since the reinstallation of studio

Well it work by following this :

---

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 2022

Top 3 Topics with Most Views

Automation Cloud Not Responding made by @vaishnavi_velayutham with 55 views.

Download email attachments from outlook, create folders in local directory made by @zyzz with 44 views.

Extract and convert strings made by @Hey_hi with 37 views.

Top 3 Topics with Most Replies

Write Line - Object reference not set to an instance of an object made by @amenoufy with 25 replies.

Download email attachments from outlook, create folders in local directory made by @zyzz with 21 replies.

Can Unattended license run in Edge's IE mode? (This is because the selector is unable to click) made by @poppadom with 18 replies.

Top 3 Users Who Posted The Most

@THIRU_NANI made 34 posts!

@Nithinkrishna made 32 posts!

@ppr made 30 posts!

Top 3 Most Liked Posts

This post made by @THIRU_NANI received 5 likes!

Happy Anniversary UiPath Learner, Virtual Party!

Hello Team, Congratulations to all of us… Happy Anniversary One of the best source to achieve the biggest dream… Thanks a lot for this amazing journey! I started my career as RPA developer in june-2021. The place where I started my journey as a Developer. Once again Thanks for the amazing Courses, Content, Certifications, Problems and Solutions Regards, NaNi

This post made by @YUGAN_NITHISH_KUMAR received 4 likes!

Happy Anniversary UiPath Learner, Virtual Party!

Uipath academy has made my career and shaped my life path. Uipath academy the best one no words to describe how useful it was to me!! Happyth Anniversary!!

This post made by @fernando_zuluaga received 4 likes!

Happy Anniversary UiPath Learner, Virtual Party!

Hi happy aniversary uipath! Uipath academy is my best uipath platform, it helped my at the beginning of everything in uipath and RPA, this also helps a lot my team mates to reach their projects with the best practices and techniques. Regards!

Top 3 Most Liked Solutions

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

Does an 'activity that creates a queue' exist?

Hi @sumouse You can’t create queue via studio or any third-party It should be created via orchestrator itself Hope this helps you

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

Add queue when pushing items throwing error

So let’s say if u want to push duplicate values again Disable unique reference Or if you need unique values only Handle this add queue item with try catch So it won’t prompt any error

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

Robot Logs Orch API Swagger

You may use a Request URL like this one: https://cloud.uipath.com/ORG_NAME/TENANT_NAME/orchestrator_/odata/RobotLogs?$filter=TimeStamp gt 2022-06-21T00:00:00.00Z More details can be found here: Building API Requests

---

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 2022

Top 3 Topics with Most Views

How to replace particular row items from same excel? made by @Muralikrishna_Surve with 36 views.

Write range into excel don't write all the data made by @nora_ziani with 33 views.

The Process cannot access the file because its being used by another process "pdf" file made by @Sairam_RPA with 33 views.

Top 3 Topics with Most Replies

How do I make sure that the convert to pdf don't have a. Docx made by @charlotte_charlotte with 17 replies.

For each row create file made by @mateo.drouillard with 16 replies.

Scraping PDF footer Page Number made by @anand.t with 13 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 33 posts!

@THIRU_NANI made 26 posts!

@Nithinkrishna made 23 posts!

Top 3 Most Liked Posts

This post made by @Maneesha_de_silva received 7 likes!

Happy Anniversary UiPath Learner, Virtual Party!

:smiling_face_with_three_hearts:Happy Anniversary celebrate **5 years of UiPath Academy! Instead of 5 years I have very happy and proud to be with 4 years continually with UiPath academy. I was started with Zero and when i look back my achievement its almost the academy that help me to become on this position. UiPath Academy helps you to become form ZERO to HERO THE PERSON WHO HAVE THIRST WITH KNOWLEDGE AND LERNING , I recommended that this is the heaven for …

This post made by @AndyMenon received 3 likes!

Happy Anniversary UiPath Learner, Virtual Party!

FUN-FIVE-YEAR-TASTIC! Congratulations to one and all! The creators, the organizers, the moderators, the visitors, the MVPs, the Company, and countless more visible and invisible that have made this community so successful and vibrant! The Academy drove us to learn and be RPA Practitioners, post questions, solutions, bugs, suggestions and feedbacks. As with everyone here, brings back…

This post made by @ushu received 2 likes!

Index Was Outside of the bounds of the string Array

@Nandhini_Vishnu 10 represents the count which defines maximum number of sub strings to return. That means when it is returning the value it is trying to store these 10 sub strings in different array index (Ex: Arr[0] = FirstSubString, Arr[1] = Second Substring etc). But you were trying to assign all these in an array of index 0. That could cause the issue. try the below one and share the results Remove intLoop then exp should be strArrayName=Split(strName, " ")(10) See if it giving the same …

Top 3 Most Liked Solutions

This solution provided by @ushu received 2 likes!

Index Was Outside of the bounds of the string Array

@Nandhini_Vishnu 10 represents the count which defines maximum number of sub strings to return. That means when it is returning the value it is trying to store these 10 sub strings in different array index (Ex: Arr[0] = FirstSubString, Arr[1] = Second Substring etc). But you were trying to assign all these in an array of index 0. That could cause the issue. try the below one and share the results Remove intLoop then exp should be strArrayName=Split(strName, " ")(10) See if it giving the same …

This solution provided by @Yoichi received 2 likes!

Write condition for the multiple variables

Hi, Hope the following sample helps you. [image] This returns true if all status is either of Yes , Okay or Completed. Regards,

This solution provided by @sarathi125 received 1 likes!

Check if string date is outside time window

@b.forbes , Instead of using the Month number alone you can use the whole date value to compare it against the date to be checked. Create a variable as “dteFileDate” As DateTime DataType Create a variable as “dteCompareDate” As DateTime DataType Then use first assign activity with this dteFileDate = DateTime.Parse(“1/5/2012 8:12:14 PM”) Then use second assign activity with this dteCompareDate = System.DateTime.Now.Date.AddMonths(-3) Then use a IF activity to check whether it is smaller or …

---

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 2022

Top 3 Topics with Most Views

Merging of 2 data table made by @manipreethi410 with 40 views.

処理フローの動きについて made by @yokosawa with 38 views.

https://forum.uipath.com/t/450727 made by @Nitya1 with 37 views.

Top 3 Topics with Most Replies

How to automation get dynamic range in Excel made by @Hi_p_H_a_Hoang with 18 replies.

Is it possible to use an image click selector to run in unattended mode? made by @divyanancyit with 13 replies.

For the same selector , bot is working fine in development machine and failing in UAT machine made by @singhshivangi2895 with 12 replies.

Top 3 Users Who Posted The Most

@THIRU_NANI made 34 posts!

@Rahul_Unnikrishnan made 21 posts!

@Nithinkrishna made 21 posts!

Top 3 Most Liked Posts

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

This post made by @SnehajitDas received 2 likes!

Happy Anniversary UiPath Learner, Virtual Party!

I was with RPA since 2 years before UiPath Academy was launched and had to train myself in UiPath as it slowly growing at that time making its space in the top 3 board. UiPath Academy lessons and modules helped a quickly get up to speed there as till then I was primarily working with other RPA tools. I have finished some really good courses in the UiPath Academy platform and hope to grow more with the new features and capabilities those are introduced daily in UiPath.

This post made by @Dr.Sumitra_V received 2 likes!

Happy Anniversary UiPath Learner, Virtual Party!

Happy Anniversary Uipath wish to continue to learn more .and to have more successful together

Top 3 Most Liked Solutions

This solution provided by @THIRU_NANI received 2 likes!

Change format email

Hi! Take one Assign Activity create one string variable (Output) in value field try this Output = System.Text.RegularExpressions.regex.match(InputVariable,".*(?=@)").ToString In message box do like this output.Split(".")(1)+" "+output.Split(".")(0) Reference: [Output] If you want those two characters in proper case do like this: Navigate to import panel in UiPath studio search for this Namespaces System.Globalization Do like this: CultureInfo.CurrentCulture.TextInfo.ToTitleCase(Outpu…

This solution provided by @Veera_Raj received 1 likes!

variable:System.Double

Holds signed IEEE 64-bit (8-byte) double-precision floating-point numbers that range in value from -1.79769313486231570E+308 through -4.94065645841246544E-324 for negative values and from 4.94065645841246544E-324 through 1.79769313486231570E+308 for positive values. Double-precision numbers store an approximation of a real number. Thanks & regards Veeraraj S

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

How do I Remove the Digit And hyphen from the Excel Datatable?

@kishan.savaliya testt.xaml (7.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 | 24 June 2022

Top 3 Topics with Most Views

Match and Remove made by @ravindar.singh with 38 views.

How to create Custom Dashboard? made by @Mamata_Shee with 37 views.

Group and sort the datatable using Linq made by @kavya.s16 with 35 views.

Top 3 Topics with Most Replies

How to write a split function for items joined using the join function made by @Kakooza-Allan-Klaus with 19 replies.

While loop for 4 hours made by @Sirisha_Siri with 15 replies.

Job had completed in VM , but still job status is running in orchestrator. how to resolve this? made by @MitheshBolla with 12 replies.

Top 3 Users Who Posted The Most

@THIRU_NANI made 30 posts!

@Nithinkrishna made 23 posts!

@Rahul_Unnikrishnan made 22 posts!

Top 3 Most Liked Posts

This post made by @Ratish_Dharmarajan received 4 likes!

Happy Anniversary UiPath Learner, Virtual Party!

Hi Team, Many Many wishes on the 5 year completion. I came across UIPath when in 2018 my manager asked me to mentor a team of developers on this tool. The journey started from there and i came to know how beautifully and smoothly UIPath works. The Automation capability is limitless with this tool and it helps one to increase its knowledge base pretty well. Kudos and lets continue to grow more.

This post made by @Ganesh_Dongre received 3 likes!

Happy Anniversary UiPath Learner, Virtual Party!

Congratulations to all of us…Happy 5th Anniversary. I Started my Career as a Trainee and Join the MNC in August 2021. Now i am becoming the Professional RPA Developer by learning from the Uipath Acadamy. Thanks for all the Contents and Good people to help me in the UiPath Forum. Its Pleasure to be here. Thanks, Ganesh Dongre

This post made by @nrok received 2 likes!

Happy Anniversary UiPath Learner, Virtual Party!

Happy Anniversary!!! Congratulations for all! The best online academy journey! I met RPA in March 2019 and the Academy was the best assistant in order to improve my knowledge! Thanks for the amazing courses! Keep it up! Cheers, Nikos

Top 3 Most Liked Solutions

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

Orch Automation cloud not opening

Hi @Narendra_N kindly refer the below link of same issue hope this helps normally try doing that and let us know

This solution provided by @Sudharsan_Ka received 1 likes!

Assign - String was not recognized as a valid DateTime

Hi @Nelson.R You have missed yy in the expression MonthName(Convert.ToInt32(Date.ParseExact(CurrentRow(“Due Date”).ToString,“MM/dd/yyyy”,CultureInfo.InvariantCulture).ToString(“MM”))).ToString Try this Regards Sudharsan

This solution provided by @Jack_Moran received 1 likes!

The specified combination of selector, filter and scope is not supported

With some help from my awesome coworker Athena, I managed to figure it out! As it turns out, the issue at the heart of all this was actually the use of Open Browser. The Practice’s step-by-step solution instructs you to use Open Browser, and because the difference between this and Attach Browser is negligible, I thought nothing of it. But when I switched to Attach Browser as Athena suggested, the correct fields were finally selected. To those of you looking at this in the future, the rest of th…

---

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 2022

Top 3 Topics with Most Views

How to Lean c sharp library which is use for uipath made by @Aleem_Khan with 35 views.

How to get specific value for an excel sheet which I have read into a data-table? made by @Chaaza with 32 views.

How can I add README.md to my UiPath project? made by @AndrewGuo with 29 views.

Top 3 Topics with Most Replies

How to get specific value for an excel sheet which I have read into a data-table? made by @Chaaza with 9 replies.

UiPath Coding Framework now on github - Contributors needed! made by @Steve_Krozer with 8 replies.

PDF READ ERROR made by @d.ulutas with 7 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 22 posts!

@ushu made 14 posts!

@THIRU_NANI made 10 posts!

Top 3 Most Liked Posts

This post made by @Nithinkrishna received 1 likes!

How to create Activity in Invoke Code with Output argument?

Hey @Steve_Krozer It’s amazing to see this ! But just thinking of dev friendly and less TAT in dev. I feel activities may be easy for everyone. Thanks #nK

This post made by @ppr received 1 likes!

String Error

[grafik] yourStringVar.Trim(" TL".ToCharArray)

This post made by @Steve_Krozer received 1 likes!

UiPath Coding Framework now on github - Contributors needed!

In the “How to use” part of the readme I explain this, look below: For example you’d want to get the text of an element, you’d do it like this: var getValue = new Job_GetValue().Run ( WaitForReady.COMPLETE, "<wnd app='notepad.exe' cls='Notepad' title='*Library.txt - Notepad' /><wnd aaname='Horizontal' cls='Edit' /><ctrl name='Text Editor' role='editable text'/>" ); The getValue variable will contain a dictionary with a key and a value, the key i…

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

String Error

[grafik] yourStringVar.Trim(" TL".ToCharArray)

This solution provided by @THIRU_NANI received 1 likes!

Error from "Get From Clipboard"

Hey! Why can’t we try with get text? Is it mandatory to use get text from clipboard? We can get the text by using get text or get Full text activity! Regards, NaNi

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

PDF Extract Text

try this Sequence2.xaml (7.5 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 | 26 June 2022

Top 3 Topics with Most Views

How to set default values for array of boolean variables made by @viktorova.ta47 with 35 views.

Which Bot run Which process? made by @fatima.ahmed with 32 views.

How to change Excel's cell format to Custom? made by @Rahul_J with 30 views.

Top 3 Topics with Most Replies

How get specific value from an excel sheet (part 3) included my working example, pls advise made by @Chaaza with 7 replies.

How do we check datatable column value is equal using C# using studio in the custumized break point made by @jamuna_Eakambaram with 7 replies.

Can Orchestrator be used as a versioning and repository system just like TFS or any other versioning and repository system for developers working together on the same application? made by @mail4bobbysam with 7 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 17 posts!

@muhammedyuzuak made 4 posts!

@mail4bobbysam made 4 posts!

Top 3 Most Liked Posts

This post made by @meghanathan received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello people, I am Meghanathan, Automation is been my passion forever, luckily I have identified this in my twenties. I am trying to make a career here. Thank you, Meghanathan

This post made by @takyysh received 1 likes!

Action Center Mobile

@Maneesha_de_silva i think this will stop Action center also, your interest much appreciated bro.

This post made by @Sc100 received 1 likes!

Dynamic UI element table - Please Help

Muhammed, Rahul, and Loveleet, Thank you so much for your replies. I will attempt this, and will post screenshots/code of what I did come up with. Many thanks again. Talk to you all soon. Sean

Top 3 Most Liked Solutions

This solution provided by @Anjali_Rani received 1 likes!

HTTP Request Form-data --- Help

Hi Guyzz, Thank you for your response. The solution that worked for me:- I added the variables like this on Parameter section and it worked [image] Happy automation!!

This solution provided by @Nithinkrishna received 1 likes!

How to store Dataset value as variable instead of storing in excel which is extracted and export using DU

Hey @tkiran You can just create a variable of that type and store the same. Thanks #nK

---

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 2022

Top 3 Topics with Most Views

Logs not visible in cloud orchestrator jobs in community version made by @Achintya with 56 views.

Not able to stop while loop made by @Sirisha_Siri with 49 views.

Job is running but not printing any logs in Orchestrator made by @satyam.baviskar with 46 views.

Top 3 Topics with Most Replies

Not able to stop while loop made by @Sirisha_Siri with 16 replies.

"Unable to retrieve a license" Cloud Orchestrator (enterprise and community) made by @rikyz90 with 15 replies.

Logs not visible in cloud orchestrator jobs in community version made by @Achintya with 13 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 32 posts!

@ppr made 20 posts!

@nikhil.girish made 13 posts!

Top 3 Most Liked Posts

This post made by @StefanPrajica received 3 likes!

Happy Anniversary UiPath Learner, Virtual Party!

Happy anniversary UiPath Academy! I started using the Academy platform around three years ago during onboarding as an UiPath newjoiner. Since then both the product and the Academy have gone a long way! Keep up the good work!

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

Linq to compare dates

Hi @ShekharRPA try out this (From r In DT Where DateTime.Parse(r("StartDate").toString).Date.tostring("dd-MM-yyyy")<=Today.Date.tostring("dd-MM-yyyy") And DateTime.Parse(r("End Date").toString).Date.tostring("dd-MM-yyyy") >Today.Date.tostring("dd-MM-yyyy") Select r).CopyToDataTable condition 2 (From r In DT Where DateTime.Parse(r("End Date").toString).Date.tostring("dd-MM-yyyy")<Today.Date.tostring("dd-MM-yyyy") Select r).CopyToDataTable hope this helps

This post made by @satyam.baviskar received 2 likes!

Job is running but not printing any logs in Orchestrator

Thank you so much to all of you for showing interest in this issue, & would like to inform that it has started working as normal, I don’t have an idea what was happened to it, as all processes were running but no logs visible in orchestrator but now all are visible, Thanks Team.

Top 3 Most Liked Solutions

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

Linq to compare dates

Hi @ShekharRPA try out this (From r In DT Where DateTime.Parse(r("StartDate").toString).Date.tostring("dd-MM-yyyy")<=Today.Date.tostring("dd-MM-yyyy") And DateTime.Parse(r("End Date").toString).Date.tostring("dd-MM-yyyy") >Today.Date.tostring("dd-MM-yyyy") Select r).CopyToDataTable condition 2 (From r In DT Where DateTime.Parse(r("End Date").toString).Date.tostring("dd-MM-yyyy")<Today.Date.tostring("dd-MM-yyyy") Select r).CopyToDataTable hope this helps

This solution provided by @poonni.palani received 1 likes!

SAP is stuck with transferring message in status bar while exporting Data

Uipath Support team helps to resolve the issue. The Solution from them is given below : The problem appears to be with the “UiPath.Core.Activities.SAP.ReadStatusbar” activity. This activity appears to start far too rapidly, and the SAP status is not updated in time, resulting in the SAP programme becoming stuck. This issue was rectified by adding a 5-second delay before monitoring the status indicator.

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

Any hands-on reference for reframework

Hi @Pushpanagraj_Nag Welcome to community Kindly go through UiPath academy courses where reframework is explained in detail Apart from that Check this out [UiPath REFramework - Full Tutorial - Example from Start to Finish] Hope this helps you

---

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 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.