Forum Engagement Daily Reports

[system]

Daily Forum Report | 12 March 2024

Top 3 Topics with Most Views

Href not returning any value made by @marina.dutta with 50 views.

How We can kill the Microsoft word application? made by @annet_mdamugade with 49 views.

Check value 2 file made by @fairymemay with 49 views.

Top 3 Topics with Most Replies

Href not returning any value made by @marina.dutta with 13 replies.

Assign problem! made by @Happydayyy with 13 replies.

Check value 2 file made by @fairymemay with 11 replies.

Top 3 Users Who Posted The Most

@mkankatala made 45 posts!

@Jayesh_678 made 40 posts!

@ashokkarale made 26 posts!

Top 3 Most Liked Posts

This post made by @RAKESH_KUMAR_BEHERA received 3 likes!

Creating Synthetic Test Data in UiPath: A Guide to Automated Test Data Generation

[Creating Synthetic Test Data in UiPath: A Guide to Automated Test Data Generation]

This post made by @shivagowdavarad received 2 likes!

The Rename Sheet activity does not raise an error even when the specified sheet to rename does not exist

Hi @vrdabberu , I’m not seeking for a solution, Instead, I’ve identified a behavior in the activity that deviates from the expected behavior, and I’ve highlighted it as a bug. This way, if others also find this behavior unexpected, they can submit their votes, and the activity might be updated in the upcoming updates.

This post made by @annet_mdamugade received 2 likes!

How We can kill the Microsoft word application?

-How We can kill the Microsoft word application? in Ui path . -I have use the kill process activity but it is getting failed. -In kill process activity i have give the input as “Microsoft Word” in Process name field.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

I have to get each network nodes global title number range in for each loop using regex

Hi, Can you try the following sample? [image] Sample Sample20240312-3.zip (13.6 KB) Regards,

This solution provided by @Sridhar_Aswin received 1 likes!

Please help me with a RegEx to extract only the numbers from a string variable

Hi @JeevaSadha , can you try this? \d+ Add a “Matches” action. Set the input text to “Text123”. Set the regex pattern to \d+. In the properties panel, set the “Result” field to a variable (e.g., extractedDigits). This should extract the digits alone. Thanks, Aswin Sridhar

This solution provided by @vrdabberu received 1 likes!

How to get random entire row in Linq from datatable

Hi @neelimaintern [image] Code: Dim rand As New Random() Dim randomIndices = Enumerable.Range(0, Dt.Rows.Count).OrderBy(Function(i) rand.Next()).Take(Dt.Rows.Count) resultTable = ( From index In randomIndices.Take(3) Select Dt.Rows(index) ).CopyToDataTable() Invoke Arguments: [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 | 13 March 2024

Top 3 Topics with Most Views

Box activities in Studio desktop not working made by @Juan_Felipe_Carvajal with 57 views.

Cloud Uipath issue made by @Manojsahoo with 54 views.

Best way to check if a data exists in a data table made by @shaik.muktharvalli1 with 51 views.

Top 3 Topics with Most Replies

How to get the sheetnames are write that in a column made by @anjani_priya with 25 replies.

Best way to check if a data exists in a data table made by @shaik.muktharvalli1 with 17 replies.

I need to pass the dynamic selector in the click activity but here the problem my variable is string array is it possible to pass dynamic like this arr(0) made by @venkatsai_bonam with 16 replies.

Top 3 Users Who Posted The Most

@mkankatala made 32 posts!

@ppr made 30 posts!

@Jayesh_678 made 28 posts!

Top 3 Most Liked Posts

This post made by @Diana_Sacacian received 2 likes!

Make ML Skills and Datasets public via URL + API Key - Preview

Hello there, Managed to make this work for me. After training the OOB image classifier from AI Center and making it public, I called the engine from Postman using the base64 image as payload. I simply converted the image using this online tool and added it in Postman like this: [Untitled] Content-Type header is set to “application/json”. Make sure to add the encoded string, not the image source (the one with data:image/img extension;base64) as the API call responds with “Prediction Failed…

This post made by @PVSneha_Nair received 2 likes!

Where vs Select

Hi , where : This clause is used for filtering elements based on a specified condition. It’s similar to the WHERE clause in SQL. When you want to select elements that satisfy certain criteria, you use where . select : This clause is used for projecting data into a new form. It’s similar to the SELECT clause in SQL. When you want to transform the elements in some way (like selecting specific properties, performing calculations, or projecting them into a different data structure), you use sele…

This post made by @mkankatala received 2 likes!

I need to pass the dynamic selector in the click activity but here the problem my variable is string array is it possible to pass dynamic like this arr(0)

No You can’t directly pass the Array(0) to the selectors, you have to follow a other way… @venkatsai_bonam Hope you understand!!

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Cant change workspace to Orch folder

Hi @Steven_McKeering Have sent you a PM

This solution provided by @lrtetala received 1 likes!

Write cell error (formular)

@fairymemay FYI, There is another approach [image] So, it writes total rows in C Column without using for each

This solution provided by @110_Sowjanya_Sreenivasan received 1 likes!

Not able to launch SAP Application

Hi @ashokkarale /@Jayesh_678, Thanks for your support. Since the config file was not present, it showed error and now it is solved. Regards, Sowjanya.S

---

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 March 2024

Top 3 Topics with Most Views

How to split string using regex made by @Lalitha_Selvaraj with 49 views.

Get Queue Items > Fault made by @Mesut_Can with 48 views.

Anchor Based is not working to extract information for the variable made by @rahul.kumar3 with 45 views.

Top 3 Topics with Most Replies

Get Queue Items > Fault made by @Mesut_Can with 18 replies.

Filter Email - Outlook made by @abivanth.r with 16 replies.

Processing multiple files one by one made by @pabaleloh with 15 replies.

Top 3 Users Who Posted The Most

@mkankatala made 47 posts!

@ppr made 27 posts!

@Jayesh_678 made 26 posts!

Top 3 Most Liked Posts

This post made by @abivanth.r received 2 likes!

Filter Email - Outlook

yes it is. Thanks for the help bro. In save attachment there is a filter option and i provider the string “.pdf” It worked. Thanks for your time

This post made by @mkankatala received 2 likes!

LinQ to Add Array in Another Array

Hi @Fabio_Villamil Try the below linQ expression, - Assign -> inputArray = {"1,2,3,4","5,6,7,8"} - Assign -> outputArray = inputArray.Select(Function(str) str.Split({","c}).ToArray()).ToArray() Check the below workflow for better understanding, [image] Hope it helps!!

This post made by @ppr received 2 likes!

How to write data from sheet 1 to sheet 2

there are several options to do it. We can use sheet1 data and create for us a lookup data dictionary: [grafik] then we can use for sheet2 a dtData2.NewRow for getting an empty row within the Sheet2 Schema which we can populate with the help of the lookup data dictionary

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 2 likes!

LinQ to Add Array in Another Array

Hi @Fabio_Villamil Try the below linQ expression, - Assign -> inputArray = {"1,2,3,4","5,6,7,8"} - Assign -> outputArray = inputArray.Select(Function(str) str.Split({","c}).ToArray()).ToArray() Check the below workflow for better understanding, [image] Hope it helps!!

This solution provided by @Yoichi received 2 likes!

Check with data 2 file

I modified workflow like without If inside if. Can you check the following sample? actual file report have data 1000 record if take time to run. I don’t think it takes so long time in run mode if there are around 1000 records in Excel. However it may be better to use DataTable instaed of ForEachExcelRow to improve throughput. Sample Sample20240314-2 (2).zip (721.7 KB) Regards,

This solution provided by @ptrobot received 1 likes!

Linq to .trim all values in datatable’s all rows & all columns?

With two Assign statements: trimmedDataTable = originalDataTable.Clone trimmedDataTable = originalDataTable.AsEnumerable.Select(Function(row) row.ItemArray.Select(Function(cell) cell.ToString().Trim()).ToArray()).Select(Function(cells) trimmedDataTable.Rows.Add(cells)).CopyToDataTable

---

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

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

[system]

Daily Forum Report | 15 March 2024

Top 3 Topics with Most Views

Excel To Outlook mail filtering made by @abivanth.r with 59 views.

Linq sum from the excel made by @Temuulen_Buyangerel with 48 views.

SURVEY - CODED AUTOMATION made by @ThomasStocker with 46 views.

Top 3 Topics with Most Replies

Excel To Outlook mail filtering made by @abivanth.r with 32 replies.

Want to Retry putting the code 2nd time Using If condition Login - for efficiency made by @samantha_shah with 12 replies.

Saving Outlook Attachment in loop made by @abivanth.r with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 47 posts!

@abivanth.r made 23 posts!

@Jayesh_678 made 21 posts!

Top 3 Most Liked Posts

This post made by @Adrian_Tamas received 2 likes!

Get Queue items - Items shown "null" specific content in the activity. But have specific content in Orchestrator Queue

hi Julian, all, I’ll start with saying that I’m sorry for the inconveniences. To give you a bit of a background, this is a change we announced back in December (here), delayed the roll-out a bit (announced here and in the deprecation page here), encountered a few issues and with a bit of a delay rolled out into Community and Canary tenants earlier this week, on Wednesday (you probably missed this as well, unfortunately). We’ve covered this particular topic in our docs here explaining why, what…

This post made by @ThomasStocker received 2 likes!

SURVEY - CODED AUTOMATION

[coded_automation_banner] Hello esteemed colleagues! Feedback is fuel for our Product and Engineering and we heavily rely on your input to build great products. This is why we kindly ask you for 5 minutes of your busy schedule, to answer our survey about Coded Automation. We want to know if you are aware of it or not, if you like it or not, and what you would suggest to improve. Here is the link to the survey: Survey Many thanks in advance for your help! BR Thomas

This post made by @uio received 2 likes!

Excel Autofit macro settings

I have the script to achieve the task. My question is about the settings I need to change.

Top 3 Most Liked Solutions

This solution provided by @Adrian_Tamas received 2 likes!

Get Queue items - Items shown "null" specific content in the activity. But have specific content in Orchestrator Queue

It’s not in the currentQueueItem anymore, you will need to use the key of the currentQueueItem and to do a GET/odata/QueueItems({key}) to then access the SpecificContent and/or Output. Hope this helps. Adrian

This solution provided by @kali received 1 likes!

How to optimize this simple code?

Enumerable.Range(0,x) is fine, u dont need “.ToArray()” Also work with dt in background and write one time would be quicker.

This solution provided by @Vinit_Mhatre received 1 likes!

Excel To Outlook mail filtering

Hi @abivanth.r , Entire workflow: [image] Get Outlook mail property: [image] Regards, Vinit Mhatre

---

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 March 2024

Top 3 Topics with Most Views

Remove data from column made by @0bb4628e217fd43ac86ac9294 with 45 views.

How to change the color of a String var in UIpath made by @Yomi_Oluwadara with 43 views.

DU vs AI Fabric made by @devasaiprasad_K with 40 views.

Top 3 Topics with Most Replies

How to change the color of a String var in UIpath made by @Yomi_Oluwadara with 10 replies.

Remove data from column made by @0bb4628e217fd43ac86ac9294 with 9 replies.

How to extract uncertian length field with substring? made by @yangyq10 with 8 replies.

Top 3 Users Who Posted The Most

@Yoichi made 10 posts!

@Jayesh_678 made 10 posts!

@Anil_G made 9 posts!

Top 3 Most Liked Posts

This post made by @fairymemay received 2 likes!

Vlookup data?

I want vlookup data as below (read by row data file input). column S_Catagory (file input) with column Category (file master Sheet1) column S_Sub Catagory (file input) with column Sub Catagory(file master Sheet1) [image] If match message box value in column feedback_Recommendation else not match check next sheet i want tot check as below. column S_Catagory (file input) with column Category (file master Sheet2) column S_Sub Catagory (file input) with column Sub Catagory(file master Sheet2…

This post made by @Anil_G received 2 likes!

Using Document Understanding I want to extract amount from pdf

@BHUSHAN_NAGAONKAR1 You need to use ml classifier if the format is not constant Storage bucket is no where in picture… Ai center training is not a workflow but you have to do it on your dataset Cheers

This post made by @Anil_G received 2 likes!

DU vs AI Fabric

@devasaiprasad_K Document understanding works only for different documents…but ai frabric or ai center is much more than it…it has features like text classification,language analysis,sentimental analysis etc…which are not document models Cheers

Top 3 Most Liked Solutions

This solution provided by @Jayesh_678 received 1 likes!

Vlookup data?

Hi @fairymemay Output:- [image] [image] Xaml file:- lookup data forum.zip (19.1 KB) If this works for you, please mark it as a solution, so others can refer the same… Thanks

This solution provided by @Parvathy received 1 likes!

RegEx Letter number pattern question

Hi @Pavan_kumar15 Try this (?<=my id is\s)[A-Za-z0-9]+ [Screenshot_2024_0316_080558] Regards

This solution provided by @Jayesh_678 received 1 likes!

Map data?

Check this, I have provided xaml file:- 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 | 17 March 2024

Top 3 Topics with Most Views

Read something from Chart made by @starterui with 42 views.

Orchestrator queue items limit made by @A_Learner with 38 views.

Connect Token > invalid_request made by @Mesut_Can with 37 views.

Top 3 Topics with Most Replies

How to extract the data in Excel using linq query made by @Baby123 with 15 replies.

Hello, i need support for excell automation with Oracle made by @mohamed.saty2012 with 12 replies.

Connect Token > invalid_request made by @Mesut_Can with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 21 posts!

@ashokkarale made 11 posts!

@vrdabberu made 11 posts!

Top 3 Most Liked Posts

This post made by @devasaiprasad_K received 2 likes!

SAP Integration with UiPath

what are the options that needs to be enabled in SAP if we want to start automating SAP scrapping… one of the answer i knew is enable GUI settings in Options Tab in SAP, so that SAP allows scripting from any external application… but this answer did not satisfied interviewers… is there any other options we need to enable in SAP or any packages that needs to be download for the SAP automtion?

This post made by @ashokkarale received 2 likes!

Connect Token > invalid_request

@Mesut_Can, you need two API calls. First API call to endpoint - /odata/QueueItems. This will return you all the queue Items int the Tennent. We need two things from this API response. 1. OrganizationUnitId 2. Id [image] So we have two inputs required for our second API call to endpoint - /odata/QueueItems({key}) Configure API request as below. key = Id X-UIPATH-OrganizationUnitId = `OrganizationUnitId` [image] That’s it. Click execute. Result: [image] Thanks, Ashok …

This post made by @Yoichi received 2 likes!

Number Formats - Range of Numbers

Hi, Can you try the following sample? [image] intStart = CInt(system.Text.RegularExpressions.Regex.Match(yourString,"(?<=\()\d+").Value) intNumber = CInt(system.Text.RegularExpressions.Regex.Match(yourString,"\d+(?=\))").Value)-intStart+1 Then arrStr = Enumerable.Range(intStart,intNumber).Select(Function(i) System.Text.RegularExpressions.Regex.Match(yourString,"[^(]+").Value+"("+i.ToString+")").ToArray() Sample Sample20240316-3a.zip (2.6 KB) Regards,

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 2 likes!

Connect Token > invalid_request

@Mesut_Can, you need two API calls. First API call to endpoint - /odata/QueueItems. This will return you all the queue Items int the Tennent. We need two things from this API response. 1. OrganizationUnitId 2. Id [image] So we have two inputs required for our second API call to endpoint - /odata/QueueItems({key}) Configure API request as below. key = Id X-UIPATH-OrganizationUnitId = `OrganizationUnitId` [image] That’s it. Click execute. Result: [image] Thanks, Ashok …

This solution provided by @ashokkarale received 2 likes!

Number Formats - Range of Numbers

@manikandan.murugan, Try this one. [image] Code: NumberFormat.xaml (10.5 KB) Output: [image] Thanks, Ashok

This solution provided by @Gautham_Pattabiraman received 1 likes!

Orchestrator queue items limit

Hello there, In UiPath, there is no maximum limit for the number of items that can be loaded into the queue. As to answer your second question we can use swagger for, adding items, getting items, updating items, and deleting items Note : we have activities which we can make use of for the above listed functionalities as well. Thanks, Gautham.

---

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 March 2024

Top 3 Topics with Most Views

UIAutomation Semantic Fill Form Activity made by @Bogdan_Sultana with 100 views.

When trying two file using same robot, why one is ok but another has bug made by @Happydayyy with 52 views.

Linq Compare 2 Data Table and Update Column Result made by @Rpa12343 with 49 views.

Top 3 Topics with Most Replies

How to creating Folder for outlook Attachments and saving them in seperate folder made by @abivanth.r with 19 replies.

Multiple files made by @pabaleloh with 18 replies.

When trying two file using same robot, why one is ok but another has bug made by @Happydayyy with 17 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 51 posts!

@mkankatala made 31 posts!

@Happydayyy made 24 posts!

Top 3 Most Liked Posts

This post made by @Bogdan_Sultana received 12 likes!

UIAutomation Semantic Fill Form Activity

Introducing Fill Form, the first addition to our Semantic Activities lineup in the 23.12 Preview release! Fill Form is our first dive into Semantic Activities, where AI meets automation magic to streamline your workflow like never before. Say goodbye to endless Type Into activities and hello to effortless form filling! [image] [image] With Fill Form, simply indicate your Data Source, and watch the magic happen: the activity automatically detects the destination form from the UIA Sc…

This post made by @efelantti received 2 likes!

Type into not working in "Save As" tab!

Good point. That applies always with paths in Windows, I think, so it might make sense to check path length in an If clause beforehand (not limited to this case).

This post made by @A_Learner received 1 likes!

Q Item new status

Hi, Can you help me understand how a queue item gets to new status with the 3 following conditions? " the item was postponed, or a deadline was added to it, or the item was added after an attempt and failure of a previous queue item with auto-retry enabled." Thank you,

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 1 likes!

Get a specific value after using extract pdf text

Hi @BHUSHAN_NAGAONKAR1 Input = "14,567.00" Output = Input.Replace(",","").Replace("/","").TrimEnd("0"c).TrimEnd("."c) Check the below image for better understanding @BHUSHAN_NAGAONKAR1 : [image] Hope it helps!!

This solution provided by @mkankatala received 1 likes!

Time Setting In Word

Hi @CHAN_Hiu_Fung_Victor_Stud Could you try the below one, Cdate(ApplistDT.rows(IndexDT).Item("Date of received")).tostring("dd-MM-yyyy") In the above expression you are converting the datetime system format (MM/dd/yyyy hh:mm:ss) to the required string format with the specified time format (dd-MM-yyyy). You can check the below image the above expression working fine, [image] Hope it helps!!

This solution provided by @vrdabberu received 1 likes!

Get value from output string

Hi @BHUSHAN_NAGAONKAR1 Hi @BHUSHAN_NAGAONKAR1 Please try below Input = "m m m m m m m $14,308 00" Output = System.Text.RegularExpressions.Regex.Match(input,"\d+[.,]?\d*[.,]\d+").Value.Replace(".","").Replace(",","").Trim

---

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 March 2024

Top 3 Topics with Most Views

Removing sep=; from CSV File made by @Pogboom with 46 views.

How can I create a a list of all application windows? made by @grosner with 45 views.

UiPath Studioの起動画面のインタフェースを変更したい made by @gorby with 44 views.

Top 3 Topics with Most Replies

Removing sep=; from CSV File made by @Pogboom with 15 replies.

I need to check E214 and E212 columns from text file made by @shaik.muktharvalli1 with 15 replies.

Merge 2 data table side by side made by @SunnyJha with 15 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 48 posts!

@Yoichi made 31 posts!

@Anil_G made 25 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

Difference between RowCount and Rows.Count?

RowCount is an extension which was introduced at a later stage by UiPath [grafik] UPD1: [grafik] DataTable.Rows.Count is a Property: Both will give the same value, but RowCount is maybe not available (depending on package versions)

This post made by @Iulia_Istrate received 2 likes!

Cloud.uipath.com/portal_/existingaccount doesn't let you choose

Reassigning this to @danielbuca as he owns Identity and he can explore further optimizations. It is by design that an authentication token shall not be automatically used for all organizations that the user is part of, because it requires to recheck the authorization the users has in each organization. But I will let Daniel design for better experience.

This post made by @Yoichi received 2 likes!

How to check if there are any files in a folder uipath

Hi, Can you try the following? Directory.GetFiles("C:\Users\login\Desktop\Folder\Folder\Folder", "*", SearchOption.AllDirectories).Count > 0 Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to check if there are any files in a folder uipath

Hi, Can you try the following? Directory.GetFiles("C:\Users\login\Desktop\Folder\Folder\Folder", "*", SearchOption.AllDirectories).Count > 0 Regards,

This solution provided by @Yoichi received 2 likes!

Merge every second line of string to previous one

HI, How about the following expression? System.Text.RegularExpressions.Regex.Replace(yourString,"([^\r\n]*)\r?\n([^\r\n]*(?:\r?\n|$))","$1$2") [image] Regards,

This solution provided by @Yoichi received 1 likes!

How can I create a a list of all application windows?

Hi, Can you try the following sample? [image] w = new UiPath.Core.Window(currentItem.MainWindowHandle) Sample Sample20240319-1.zip (3.2 KB) Regards,

---

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

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

[system]

Daily Forum Report | 20 March 2024

Top 3 Topics with Most Views

How to append the column values afetr the last column dynamically made by @anjani_priya with 49 views.

Throw activuty is not working well and it throws an execution error made by @Chand with 43 views.

Invoke Code Activity errors made by @Temuulen_Buyangerel with 39 views.

Top 3 Topics with Most Replies

How to append the column values afetr the last column dynamically made by @anjani_priya with 17 replies.

I need to copy from one excel & paste in another excel full of hyperlinks - Hyperlinks need to be there made by @Raks_K with 16 replies.

Extract proper pdf value made by @nidhi.kowalli1 with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 55 posts!

@ashokkarale made 34 posts!

@ppr made 26 posts!

Top 3 Most Liked Posts

This post made by @Kevin_Westerman_Tacstone received 1 likes!

OAuth1 not working with HTTP Request Activity

OAuth1 authentication doesn’t work very well in HTTP Request activity. It does not generate a signature I have found a way around this that is quite easy to implement into your code. I wrote a short tutorial below about how to do this without using something like python or writing your own signature generator: Go to Package manager and search for OAuth.DotNetCore [image] (Make sure that nuget.org is enabled under the settings, if not you won’t see the nuget.org option) [image] define a n…

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

Error Initializing Python Engine

For Windows projects that use Python activities package versions lower than 1.8.0, the Python Scope activity requires you to install the .NET Desktop Runtime 5.0.17 .

This post made by @Kevin_Westerman_Tacstone received 1 likes!

OAuth1.0 connectivity issue

Hi This issue is still not fixed, for a good alternative to generate the signature yourself check my post: OAuth1 not working with HTTP Request Activity - Help / Activities - UiPath Community Forum

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Add data to Array inside of a nested JObject

Assign Activity: YourJArrayVar(0)("Solutions") = yourNewJArray Or you will use the ADD Method within an Invoke Method / Invoke Code UPD1 - Visualizations: [grafik] And Also: [grafik] [grafik] [grafik]

This solution provided by @mkankatala received 1 likes!

Help: Need Linq Query to Filter on column

Hi @Vinit_Mhatre You can use the below linq query for first scenario, - Assign -> dt_Output = dt_Input.asenumearble().where(Function(X) X("Do no.").toString.equals("10923")).Copytodatatable() use the below linq for second scenario, - Assign -> LIst_Country = (From row in dt_Input where row("Do no.").equals("10923") Select row("Country") ).Tolist() Hope it helps!!

This solution provided by @lrtetala received 1 likes!

Remove "slashes" from file path

Hi @Ellen Path.GetFileName(filePath) Cheers!!

---

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

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

[system]

Daily Forum Report | 21 March 2024

Top 3 Topics with Most Views

🙋‍♀️ 🙋‍♂️ Beginners Learning Challenge #1 in the UiPath Forum Community! made by @pradeep_ch with 170 views.

If statement in data table made by @RACHEL_PAUL with 66 views.

URGENT! PLEASE HELP, EXCEL TEMPLATE AND CSV made by @Kia1 with 48 views.

Top 3 Topics with Most Replies

Taxonomy Manager is not Launching made by @Aksha_Mansuri with 16 replies.

Is fles exist? made by @Hemant_Deshmukh with 15 replies.

Using regex find specific value of string irrespective of Caps made by @BHUSHAN_NAGAONKAR1 with 15 replies.

Top 3 Users Who Posted The Most

@mkankatala made 30 posts!

@Yoichi made 27 posts!

@ashokkarale made 18 posts!

Top 3 Most Liked Posts

This post made by @pradeep_ch received 13 likes!

Beginners Learning Challenge #1 in the UiPath Forum Community!

Dear Community enthusiasts, are you up for Challenge #1 in our UiPath Forum Beginner’s Learning Challenge Series? Now, It’s time to put your skills to the test. Take a step towards mastery by participating in today’s quiz. Event Date: Today onwards! Deadline : Quiz submissions must be submitted no later than the 2024-03-24T21:59:00Z (UTC), your time-zone! If you answer all Quiz questions correctly, you will receive a rating of 5 stars . …

This post made by @kumar_Varma received 5 likes!

Beginners Learning Challenge #1 in the UiPath Forum Community!

Indeed a great Experience in checking our knowledge . Thanks for the free sessions @pradeep_ch , @pathrudu , @AutomationX_by_Kiran One Observation - Last Question optionA, OptionB is same

This post made by @deshavath.karth received 4 likes!

Beginners Learning Challenge #1 in the UiPath Forum Community!

They are not only contributing UiPath sessions , they are giving their valuable time and putting so much of efforts to train the students and making as Developer with in short period… Thank you @pradeep_ch @pathrudu @AutomationX_by_Kiran and @Hyperautomation-ai 3 MVPS Thank u so much

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 2 likes!

Get the Values from web page

Hi @Amol_Golhar Can you try the below System.Text.RegularExpressions.Regex.Replace(Input, "(?<=[a-z])(?=[A-Z])", ", ").TrimStart(","c).TrimStart() [image] Cheers!!

This solution provided by @Yoichi received 1 likes!

Help! How can I transfer the negative symbol of each value in columns

Hi, Can you try the following sample? [image] CurrentRow(col) = Double.Parse(System.Text.RegularExpressions.Regex.Match(CurrentRow(col).ToString,"^[\d.,]+").Value,System.Globalization.NumberStyles.Any)*(CDbl(System.Text.RegularExpressions.Regex.IsMatch(CurrentRow(col).ToString,"-"))*2+1) Sample Sample20240321-5 (3).zip (11.5 KB) Regards,

This solution provided by @vrdabberu received 1 likes!

Extract proper pdf value

Hi @nidhi.kowalli1 Please update the UiPath.PDF.Activities to the latest version and keep the run time rule as lowest applicable version and then try to create the flow as shown above and it works!! 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 | 22 March 2024

Top 3 Topics with Most Views

Hi, i am facin this isue, i am using extracting data table made by @Venky_Mama with 59 views.

HOW TO RUN A FLOWCHART WITH TWO SEQUENCE made by @Kia1 with 55 views.

Not able to extract values from http request output variab;e made by @shameenapatel74 with 44 views.

Top 3 Topics with Most Replies

Hi, i am facin this isue, i am using extracting data table made by @Venky_Mama with 16 replies.

Not able to extract values from http request output variab;e made by @shameenapatel74 with 13 replies.

How to create pivot table at the end of the sheet made by @anjani_priya with 13 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 37 posts!

@ppr made 13 posts!

@Yoichi made 10 posts!

Top 3 Most Liked Posts

This post made by @AJ_Ask received 5 likes!

Beginners Learning Challenge #1 in the UiPath Forum Community!

This quiz brings back memories of the UiPath Advanced Certificate exam. Some of the questions are little tricky.

This post made by @Gabriatto92 received 3 likes!

Beginners Learning Challenge #1 in the UiPath Forum Community!

Hello @pradeep_ch , thanks for the test, there really are some questions that are a bit difficult to analyze quite a bit. I hope I can help… Regards

This post made by @Terry_Marr received 2 likes!

Open file if exists in notepad, else create new file

I’m new to UiPath so bear with me. I’m trying to create a workflow that: gets a filename from user sees if that file exists already, if so open it if not, create the new file and open it do stuff within that file. I’m using notepad. The problem I’m having is that the filename is dynamic, so I’m not sure how to open the file using Use Application/Browser activity. Plus, the activities in the Do scope need to point to that file but it’s not known at development time.

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Convert negative number saved as text

[grafik]

This solution provided by @atomic received 1 likes!

From current date datas to oldest one

Hi, Try this Linq query and see if it is what you need. dt_Datas = dt_Datas.AsEnumerable().Where(Function(row) DateTime.Parse(row("RegDate").ToString()) <= DateTime.Now).CopyToDataTable()

This solution provided by @Yoichi received 1 likes!

Data table group by total count and row value

Hi, How about the following? [image] new Object(){dt.Rows.Count,dt.AsEnumerable.Count(Function(r) r(1).toString="Failed"),dt.AsEnumerable.Count(Function(r) r(1).toString="Success")} Sample Sample20240322-2.zip (8.8 KB) Regards,

---

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

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

[system]

Daily Forum Report | 23 March 2024

Top 3 Topics with Most Views

String Operations - split made by @Venkatesh_K2 with 38 views.

Check app state activity problem made by @Hemant_Deshmukh with 37 views.

Data table filter _Date made by @manikandan.murugan with 30 views.

Top 3 Topics with Most Replies

Unable to select notepad popup made by @Terry_Marr with 10 replies.

How to configure filter pivot table made by @Rakesh_Tiwari with 5 replies.

Unable to extract values from the JSON body made by @jishnu.pnair with 4 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 13 posts!

@Terry_Marr made 7 posts!

@Yoichi made 7 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Error while creating Pipeline in AI center

@Dinesh_Babu_S Thats wrong .Under training folder there should be a folder with name images…under images there should be cat and dog folders and in those folders the image files should be present And indicate training as the dataset folder Cheers

This post made by @Dinesh_Babu_S received 2 likes!

Error while creating Pipeline in AI center

Thank you. Let me change it and try.

This post made by @Narender_Kalal received 2 likes!

Beginners Learning Challenge #1 in the UiPath Forum Community!

Hi @pradeep_ch @pathrudu @AutomationX_by_Kiran quiz is awesome but Question No 12 and 23 options are duplicated Please check. Thanks @ Regards Narender K

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Not able to pass File full name in Document classifier

Hi, Can you try the following expression? LocalResource.FromPath(File.FullName) [image] Regards,

This solution provided by @Terry_Marr received 1 likes!

Open file if exists in notepad, else create new file

Thanks for all those who responded to my question. In this case, I was having trouble using Studio with the nested activities because the filename isn’t known until runtime. The solution, which was hinted at by Anil_G, was to forego opening notepad entirely, and simply write what I wanted to write to a text file directly using the “Write Text File” activitiy. It is much faster, and overwrites what’s there, which is what I wanted. I’m not sure this solution would work with other applications,…

---

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 March 2024

Top 3 Topics with Most Views

How to fetch more than 5000 row data from dataverse made by @MitheshBolla with 42 views.

extracatDataTable how to converted to String.? made by @Venky_Mama with 39 views.

🙋‍♀️ 🙋‍♂️ Beginners Learning Challenge #2 in the UiPath Forum Community! made by @pradeep_ch with 38 views.

Top 3 Topics with Most Replies

🙋‍♀️ 🙋‍♂️ Beginners Learning Challenge #2 in the UiPath Forum Community! made by @pradeep_ch with 12 replies.

How to fetch more than 5000 row data from dataverse made by @MitheshBolla with 9 replies.

Parallelize more than robot to proceed an execution made by @Deep_HML with 6 replies.

Top 3 Users Who Posted The Most

@mukesh.singh made 20 posts!

@Jayesh_678 made 5 posts!

@samantha_shah made 4 posts!

Top 3 Most Liked Posts

This post made by @pradeep_ch received 4 likes!

Beginners Learning Challenge #2 in the UiPath Forum Community!

Dear Community enthusiasts, are you ready for Challenge #2 crafted together with @pathrudu , @AutomationX_by_Kiran and supported by @loredana_ifrim ? Let’s level up your UiPath skills! Here is the Challenge #2 we have in store for you find the multiplication of three numbers using three different methods: Assign Activity Variable Input Input Dialog Box Event Date: Today onwards! Deadline : Quiz s…

This post made by @Irfan_Shaik received 2 likes!

Beginners Learning Challenge #1 in the UiPath Forum Community!

Completed the quiz and it’s indeed to check our knowledge. Thanks for the sessions @pradeep_ch @pathrudu @Hyperautomation-ai . Happy Learning

This post made by @starterui received 2 likes!

Send E-Mail with last downloads

Hi @mkankatala, I’ve only got this error left Main.xaml: Cannot assign from type ‘System.IO.FileInfo’ to ‘System.String’ Thanks

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

Send E-Mail with last downloads

Hi @starterui You can use the below one, (From file In New System.IO.DirectoryInfo("path_to_your_folder").GetFiles() _ Order By file.LastWriteTime Descending _ Take 3).ToArray() Hope it helps!!

This solution provided by @Anil_G received 1 likes!

Error while creating Pipeline in AI center

@Dinesh_Babu_S Please try with images with i small And can you show in pipeline which dataset you selected Cheers

This solution provided by @vrdabberu received 1 likes!

For write range workbook activity is it necessary that excel file should be already created

Hi @Tech When you use Write Range Workbook activity if the Excel file is not present, it will create a new Excel file with the given name at run time. Check the below docs for more information 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 | 25 March 2024

Top 3 Topics with Most Views

URGENT! PLEASE HELP HOW TO RESIZE IMAGE IN UIPATH made by @Kia1 with 50 views.

HELP！my “open browser”is lost! made by @pxx_xd with 42 views.

How to keep moving if details in Excel is empty? made by @yangyq10 with 42 views.

Top 3 Topics with Most Replies

Iterate excel range for every 100 data upload made by @Mohamed_Ameer1 with 24 replies.

Which activity should I use to end the whole process made by @yangyq10 with 15 replies.

Dataset to Datatable(need to upload data in excel) made by @abivanth.r with 11 replies.

Top 3 Users Who Posted The Most

@ppr made 26 posts!

@mkankatala made 17 posts!

@vrdabberu made 14 posts!

Top 3 Most Liked Posts

This post made by @Gabriatto92 received 4 likes!

Beginners Learning Challenge #2 in the UiPath Forum Community!

Hello guys @pradeep_ch @loredana_ifrim @pathrudu @AutomationX_by_Kiran , I share with you the work I have done. It has been an excellent challenge to practice Regards Input Dialog Box [dialogo.1] [dialogo.2] Variable Input [input.1] [input.2] Assign Activity [assign] resumen.zip (222.2 KB)

This post made by @rlgandu received 3 likes!

Beginners Learning Challenge #2 in the UiPath Forum Community!

@pradeep_ch Multiplication Of Three Numbers.zip (72.9 KB)

This post made by @lrtetala received 3 likes!

Beginners Learning Challenge #2 in the UiPath Forum Community!

Hello @pradeep_ch , @pathrudu , @AutomationX_by_Kiran and @loredana_ifrim Thanks for the challenge. Please find the below zip file for the solution. Beginners Learning Challenge #2.zip (81.7 KB) Cheers!!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

HELP！my “open browser”is lost!

Hi, If you are using ModernDesign mode, can you try to turn on Classic at Filter of Activities panel? [image] Or turn off ModernDesignExpresience in project settings if you uses Studio 23.10 or lower. Regards,

This solution provided by @vrdabberu received 2 likes!

Unable to print value in sent email

Hi @Satanand_Hazra Please Place the Create HTML Content activity before Send SMTP Mail Message and run your flow as you are creating the entire Body content in Create HTML Content activity and passing that output variable variable in Send SMTP Mail Message in Body. So place it before Send SMTP Mail Message and run your flow. Make sure to tick IsBodyHTML in Send SMTP Mail Message. Regards

This solution provided by @Yoichi received 1 likes!

URGENT! PLEASE HELP HOW TO RESIZE IMAGE IN UIPATH

Hi, Can you try the following sample? [image] Sample Sample20240325-1 (2).zip (4.7 KB) Regards,

---

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

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

[system]

Daily Forum Report | 26 March 2024

Top 3 Topics with Most Views

Copy Column data from Column J to column A made by @vignesh.maruthappan with 54 views.

Calendar Date Web Browser made by @Jackson_Hew with 48 views.

Read data by use header (column A) made by @Stef_99 with 45 views.

Top 3 Topics with Most Replies

String convertTo DateTime made by @Hari_Krishnan2 with 20 replies.

How to extract group of data in payer column based on company code of duplicate values made by @Jyothi1 with 16 replies.

HELP！I can't find Uipath.pdf.activities package made by @pxx_xd with 13 replies.

Top 3 Users Who Posted The Most

@vrdabberu made 26 posts!

@Anil_G made 20 posts!

@Yoichi made 18 posts!

Top 3 Most Liked Posts

This post made by @aks_test received 3 likes!

Beginners Learning Challenge #2 in the UiPath Forum Community!

Dear Team, Thank you for presenting Challenge #2! Below are three different methods to find the multiplication of three numbers: Find the project file and documentation in the attached zip. HypAuto_Challenge2_Mul3Num.zip (8.4 KB)

This post made by @gangagiridatta received 3 likes!

Beginners Learning Challenge #2 in the UiPath Forum Community!

Dear @pradeep_ch , @pathrudu , @AutomationX_by_Kiran, and @loredana_ifrim, Thank you for the challenge. Attached is the zip file containing the solution. Challenge2_Multiply_ThreeNumbers.zip (8.6 KB)

This post made by @shwetu131 received 3 likes!

Beginners Learning Challenge #2 in the UiPath Forum Community!

Hello @AutomationX_by_Kiran , @pradeep_ch Challenge2_Multiplication_Of_Three_Numbers.zip (8.2 KB) Thank you for Challenge #2! Please find the Multiplication Of Three Numbers project zip folder file.

Top 3 Most Liked Solutions

This solution provided by @vrdabberu received 1 likes!

How to extract group of data in payer column based on company code of duplicate values

Hi @Jyothi1 => Read Range Workbook [image] Output → dt => Use below syntax in Assign: resultDt = (From row In dt.AsEnumerable() Group row By CompanyCode = row.Field(Of Double)("Company") Into Group Select result = New Object() {CompanyCode, String.Join(",", Group.Select(Function(r) r.Field(Of String)("Payer")))}) _ .Select(Function(x) dt.Clone().Rows.Add(x)).CopyToDataTable() => Write Range Workbook resultDt. [image] [image] data.xlsx (10…

This solution provided by @mkankatala received 1 likes!

Filter the Dates from Column

Hi @dheerandra.vishwakarma → Use the Read range workbook activity to read the excel and store in a datatable called dt_Input. → Then take an assign activity, and you can use LINQ Expression, - Assign -> dt_Output = (From row In dt_Input.AsEnumerable() Where System.Text.RegularExpressions.Regex.IsMatch(row("Date").ToString(), "\d+/\d+/\d+") Select row).CopyToDataTable() → Then use the Write range workbook activity to write the dt_Output to …

This solution provided by @noufalahammed received 1 likes!

Help with RegEx on text extracted from a PDF

RegEx.xaml (9.2 KB) Please refer the attached workflow Below is the result of the workflow [image]

---

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

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

[system]

Daily Forum Report | 27 March 2024

Top 3 Topics with Most Views

How can I merge two PDFs with uipath & in loop made by @Raks_K with 53 views.

Switch From Community to Free without losing projects made by @TaecoW with 51 views.

Looping all line's amount until the sum of all lines amount matches to Total Amount made by @raygandhit with 47 views.

Top 3 Topics with Most Replies

Get name error made by @Stef_99 with 30 replies.

Switch From Community to Free without losing projects made by @TaecoW with 16 replies.

URGENT ! PLEASE HELP HOW DO ROBOTS CONTINUE THE SEQUENCE PROCESS made by @Kia1 with 15 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 38 posts!

@mkankatala made 22 posts!

@vrdabberu made 22 posts!

Top 3 Most Liked Posts

This post made by @Suraj_Tupe received 3 likes!

Beginners Learning Challenge #2 in the UiPath Forum Community!

Hi @pradeep_ch , @pathrudu and @AutomationX_by_Kiran Thanks for the challenge. Please find the below zip file for the solution. Hyperautomation-ai_UiPath_Multiplication_Challenge2.zip (72.8 KB)

This post made by @Leena_Reddy1 received 3 likes!

Beginners Learning Challenge #2 in the UiPath Forum Community!

Hi @pradeep_ch , @pathrudu, @AutomationX_by_Kiran , and @loredana_ifrim Thank you for the challenge_2. Please find the Attached Zip File. Thank you. Leena V Mulitiplication of 3 numbers.zip (6.6 KB)

This post made by @Parvathy received 2 likes!

Monthly Forum Rewards - February 2024

Congratulations everyone Well done guys

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

Replace "char" from string by ""

You can check the below workflow for better understanding… @BHUSHAN_NAGAONKAR1 [image] Hope you understand!!

This solution provided by @Shiva_Nikhil received 1 likes!

Complicated string split to more conditional array

strinput.Split(";"c).ToArray.select(Function(a) a.split("-"c).first).toarray strinput.Split(";"c).ToArray.select(Function(a) a.split("-"c).last).toarray

This solution provided by @vrdabberu received 1 likes!

Matches Between...For each

Hi @mbercianop Check this out: Regex Pattern: (?<=Start\s)[\s\S]*?(?=\sEnd) [Screenshot_2024_0328_013820] Let me know if you have any queries Regards

---

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

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

[system]

Daily Forum Report | 28 March 2024

Top 3 Topics with Most Views

🙋‍♀️ 🙋‍♂️ Beginners Learning Challenge #3 in the UiPath Forum Community! made by @pradeep_ch with 127 views.

How do I compare two cells and add remark? made by @uio with 52 views.

Get name sub process that error made by @Stef_99 with 48 views.

Top 3 Topics with Most Replies

Get name sub process that error made by @Stef_99 with 13 replies.

データテーブルの集計で条件を付けたい made by @117 with 13 replies.

When job is failed im not getting exception screenshot message instead im getting some error message in orchestrator made by @Sathish_Kumar5 with 13 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 29 posts!

@Yoichi made 25 posts!

@hrishikesh.k made 16 posts!

Top 3 Most Liked Posts

This post made by @Gabriatto92 received 11 likes!

Monthly Forum Rewards - February 2024

Hello community… I am very glad to see so many winners who have provided excellent solutions, but what I am most glad is that they bring the knowledge so valuable in the forum, thx guys …, Kind regards @loredana_ifrim @Anil_G @Yoichi @vrdabberu @mkankatala @rlgandu @Parvathy @ppr @YAZEED_ABU_IRTEMEH @lrtetala @pikorpa @ashokkarale @postwick @Nawazish_Ahmad @supriya117 @srinivasmarneni @jose.ordonez1 @rikulsilva @efelantti @Vinit_Mhatre @pr…

This post made by @pradeep_ch received 8 likes!

Beginners Learning Challenge #3 in the UiPath Forum Community!

Dear Community , Are you prepared for Beginners Learning Challenge #3: PDF automation? Let’s enhance your UiPath skills further ! Here is the Challenge #3 we have in store for you Challenge3.pdf (66.7 KB) Using UiPath, create a sequence to split a pdf into multiple pdfs, based on a string in a pdf. In case is a pdf of 10 pages, an a word “dummy” occurs, 3 times respectively on 2nd page, 5th page and 8th page, then we need output as 4 different…

This post made by @mkankatala received 3 likes!

Beginners Learning Challenge #3 in the UiPath Forum Community!

Hello @pradeep_ch Thank you @pradeep_ch for presenting the Challenge #3 which is fantastic and helps to grab more knowledge on Pdf Automation. I have made the workflow, please check the below file. Beginners Learning Challenge 3.zip (399.0 KB) Regards, Mahesh Kankatala.

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Linq to Extract a required value

in general it is a filter task which we can do with essential or with the LINQ Where operator Assign Activity: myRow | DataRow = dtData.AsEnumerable.Where(Function (x) x("Type").toString.Trim.Equals("O")).FirstOrDefault() if myRow is not null (as it was found) we use myRow(“Created”).toString eg. to get the value UPD1 - maybe the extraction into a dict will better serve later for the access and would be possible when it can happen that the data does have more O rows, then we would adapt …

This solution provided by @Biswajeet_kumar received 1 likes!

How to stamp multiple case refrence in same report one by one?

Thanks for the confirmation Here is how you can certainly achieve that: Create a global dt variable with headers in Initialization scope for further use. In the process transaction scope you can use a switch statement for all the progress status. Based on the condition you can switch into that specific condition and stamp the status column as per the condition of your switch. Example: if the condition matches with completed status you will stamp completed, if matched with in progress it wil…

This solution provided by @mukesh.pratap.singh received 1 likes!

Get Outlook Mail Messages: The specified folder does not exist,

@MitheshBolla can you please try with single backward slash in the MailFolder property and let me know? If you still face the issue, then please share the workflow with me. 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 | 29 March 2024

Top 3 Topics with Most Views

データテーブルの集計 made by @nyanchi0308 with 53 views.

Extract String between two Special Characters made by @Dummy with 49 views.

How do I find the next number in the series? made by @uio with 47 views.

Top 3 Topics with Most Replies

Get string from recently downloaded in chrome made by @BHUSHAN_NAGAONKAR1 with 20 replies.

Extract String between two Special Characters made by @Dummy with 15 replies.

The Text line is coming in the 2nd line,i need all the text in the same line made by @rakeshcm456 with 11 replies.

Top 3 Users Who Posted The Most

@BHUSHAN_NAGAONKAR1 made 14 posts!

@vrdabberu made 13 posts!

@hrishikesh.k made 13 posts!

Top 3 Most Liked Posts

This post made by @kishan.savaliya received 4 likes!

How do i get the previous week date Interval (Sunday to Saturday)?

Thank You So Much @lrtetala @vrdabberu @Rama_Krishna_Dokina @hrishikesh.k

This post made by @sainath-s received 2 likes!

Beginners Learning Challenge #3 in the UiPath Forum Community!

Please find the solution challenge3_PDFSplitter.zip (237.0 KB)

This post made by @Vishal_Yadav2 received 2 likes!

Beginners Learning Challenge #3 in the UiPath Forum Community!

PFB attached file Beginners Challenge3.zip (236.8 KB)

Top 3 Most Liked Solutions

This solution provided by @Shiva_Nikhil received 2 likes!

Reframework_Datatable

@Pavan_kumar15 delete the activity and take the same activity Due some catche the error is showing when you change the datatype , you need to delete and take the same activity again

This solution provided by @lrtetala received 2 likes!

How do i get the previous week date Interval (Sunday to Saturday)?

Hi @kishan.savaliya Try this startOfWeek=Now.AddDays(-CInt(Now.DayOfWeek) - 7).ToString("dd/MM/yyyy") [image] EndOfWeek=Now.AddDays(-CInt(Now.DayOfWeek) - 1).ToString("dd/MM/yyyy") [image] Cheers!!

This solution provided by @Parvathy received 1 likes!

I want select drop down value

Hi @MD_Farhan1 Below workflow will make you understand entire process. [image] If possible share your google form and excel dat if it doesn’t has confidential information. I will help you with flow. 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 | 30 March 2024

Top 3 Topics with Most Views

How to write Queue data into Excel? made by @Anonymouss with 42 views.

aiParameter.sh|cut -d "=" -f 2` made by @rakeshcm456 with 36 views.

Date Format, Number Format, Data Table made by @manikandan.murugan with 34 views.

Top 3 Topics with Most Replies

aiParameter.sh|cut -d "=" -f 2` made by @rakeshcm456 with 22 replies.

How to write Queue data into Excel? made by @Anonymouss with 10 replies.

Write cell workbook is not working while using formula made by @Sathish_Kumar5 with 10 replies.

Top 3 Users Who Posted The Most

@Gautham_Pattabiraman made 15 posts!

@AJ_Ask made 6 posts!

@ashokkarale made 6 posts!

Top 3 Most Liked Posts

This post made by @Parvathy received 2 likes!

Date Format, Number Format, Data Table

Hi @manikandan.murugan I have a workflow for this: => Use below syntax in Assign activity: Assign (DataType = System.String) -> "12/08/2023" Assign (DataType = System.String) -> "1-3" Assign (DataType = System.Int32) -> CInt(rowRange.Split("-"c)(0)) Assign (DataType = System.Int32) -> CInt(rowRange.Split("-"c)(1)) => Use below code in Invoke Code: dt = New DataTable() dt.Columns.Add("SingleDate", GetType(String)) dt.Columns.Add("SingleDataRow", GetType(String)) ' Generate rows using LIN…

This post made by @Manisai received 2 likes!

Beginners Learning Challenge #3 in the UiPath Forum Community!

Thank you @pradeep_ch @AutomationX_by_Kiran @loredana_ifrim for your efforts, and thanks for the challange which helps me a lot to get better understanding on pdf automation. Beginners_Challange_3.zip (59.1 KB)

This post made by @manikandan.murugan received 1 likes!

Date Format, Number Format, Data Table

Hi @Parvathy Really thank you so much and it’s working Regards, Mani

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 2 likes!

Date Format, Number Format, Data Table

Hi @manikandan.murugan I have a workflow for this: => Use below syntax in Assign activity: Assign (DataType = System.String) -> "12/08/2023" Assign (DataType = System.String) -> "1-3" Assign (DataType = System.Int32) -> CInt(rowRange.Split("-"c)(0)) Assign (DataType = System.Int32) -> CInt(rowRange.Split("-"c)(1)) => Use below code in Invoke Code: dt = New DataTable() dt.Columns.Add("SingleDate", GetType(String)) dt.Columns.Add("SingleDataRow", GetType(String)) ' Generate rows using LIN…

---

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 | 31 March 2024

Top 3 Topics with Most Views

What is the best approach for creating Regex for getting theword before matching pattern? made by @Hari with 47 views.

Hello need support for type into excel made by @mohamed.saty2012 with 41 views.

UiPath LINQ Tutorials | Full Course on UiPath LINQ Tutorials made by @RAKESH_KUMAR_BEHERA with 37 views.

Top 3 Topics with Most Replies

アカデミー上級 セキュアハッシュ算出処理の結果 made by @Hatti with 11 replies.

Hello need support for type into excel made by @mohamed.saty2012 with 10 replies.

Write Cell Workbook - cell does not exist made by @Cristiane_DSC with 5 replies.

Top 3 Users Who Posted The Most

@mukesh.singh made 12 posts!

@rakeshcm456 made 10 posts!

@Julian_Muhlbauer made 9 posts!

Top 3 Most Liked Posts

This post made by @RAKESH_KUMAR_BEHERA received 3 likes!

UiPath LINQ Tutorials | Full Course on UiPath LINQ Tutorials

[UiPath LINQ Tutorials | Full Course on UiPath LINQ Tutorials]

This post made by @Nessundorma received 2 likes!

I am facing this issue - Cannot create unknown type '{http://schemas.microsoft.com/netfx/2009/xaml/activities}Variable({http://schemas.uipath.com/workflow/activities}GenericValue)'

Error “The request cannot be completed. You do not have permission for this action.” usually indicates that you don’t have the rights or permissions to perform a particular action (im a cap yeah). In your case, you are trying to switch your bot to a service account, and perhaps the service account does not have the appropriate permissions to run the bot.

This post made by @rohit.kumar.barik received 1 likes!

Beginners Learning Challenge #3 in the UiPath Forum Community!

@pradeep_ch Assignment3.zip (60.9 KB)

Top 3 Most Liked Solutions

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

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

@Yoichi received 53 likes for their solutions!

@ashokkarale received 47 likes for their solutions!

@mkankatala received 35 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.