Forum Engagement Daily Reports

[system]

Daily Forum Report | 08 September 2024

Top 3 Topics with Most Views

API SharePoint made by @AsadPathan2665 with 12 views.

Updating UiPath Studio and Bots in Offline Environment Without License Dislocation or Reinstallation made by @Meraz_Faid with 11 views.

How to convert outlook email body to Data table made by @Raja.G with 10 views.

Top 3 Topics with Most Replies

Date validations from a data table made by @chauhan.rachita30 with 6 replies.

Use application: i am unable to select and open any application/uidemo.exe on desktop, it taking explorar.exe as path instead of uidemo.exe, how to fix it made by @Venu_gopal_B with 5 replies.

How to convert outlook email body to Data table made by @Raja.G with 5 replies.

Top 3 Users Who Posted The Most

@Anil_G made 10 posts!

@ashokkarale made 7 posts!

@Yoichi made 4 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 1 likes!

Date validations from a data table

HI, How about the following sample? [image] arrDr = dt.AsEnumerable.Where(Function(r) not (DateTime.TryParse(System.Text.RegularExpressions.Regex.Match(r("Dates Valid").ToString,".*(?=-)").Value,New DateTime) AndAlso DateTime.TryParse(System.Text.RegularExpressions.Regex.Match(r("Dates Valid").ToString,"(?<=-).*").Value,New DateTime) AndAlso DateTime.Parse(System.Text.RegularExpressions.Regex.Match(r("Dates Valid").ToString,".*(?=-)").Value) < DateTime.Parse(System.Text.RegularExpressions.Re…

This post made by @ashokkarale received 1 likes!

Differences Between AI Unit and ChatGPT API and Concerns Regarding AI Intelligence

For example: Document Understanding model in UiPath is specialised in understanding documents like invoice,bills etc. when we use it for extracting data from invoice it will give more accuracy. Where as Chatgpt will require context grounding about what we need and how we need etc… Thanks, Ashok

This post made by @sukh.johal received 1 likes!

Problems with publishing a Template to Orchestrator

Thanks that helped! I was able to publish successfully

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Date validations from a data table

HI, How about the following sample? [image] arrDr = dt.AsEnumerable.Where(Function(r) not (DateTime.TryParse(System.Text.RegularExpressions.Regex.Match(r("Dates Valid").ToString,".*(?=-)").Value,New DateTime) AndAlso DateTime.TryParse(System.Text.RegularExpressions.Regex.Match(r("Dates Valid").ToString,"(?<=-).*").Value,New DateTime) AndAlso DateTime.Parse(System.Text.RegularExpressions.Regex.Match(r("Dates Valid").ToString,".*(?=-)").Value) < DateTime.Parse(System.Text.RegularExpressions.Re…

This solution provided by @ashokkarale received 1 likes!

Differences Between AI Unit and ChatGPT API and Concerns Regarding AI Intelligence

For example: Document Understanding model in UiPath is specialised in understanding documents like invoice,bills etc. when we use it for extracting data from invoice it will give more accuracy. Where as Chatgpt will require context grounding about what we need and how we need etc… Thanks, Ashok

---

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

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

[system]

Daily Forum Report | 09 September 2024

Top 3 Topics with Most Views

How to verify the button is able to click made by @Evelyn_Lu with 25 views.

Not able to access workflows made by @Mohammad.Fuad with 21 views.

How to create .modify and delete local users in orchestrator using API calls made by @dlmsekhar with 19 views.

Top 3 Topics with Most Replies

READ PDF TEXT OUTPUT CONTROL made by @mina.dilek with 11 replies.

Not able to access workflows made by @Mohammad.Fuad with 11 replies.

How to verify the button is able to click made by @Evelyn_Lu with 9 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 19 posts!

@Anil_G made 9 posts!

@brixt.macharia made 7 posts!

Top 3 Most Liked Posts

This post made by @rafael01.carvalho received 1 likes!

Failed to install package 'Test.helpdesk.Invoices.1.0.4'

Hello guys, i’m trying to run a process on Orchestrator, but i’m getting the following error: Failed to install package ‘Test.helpdesk.Invoices.1.0.4’ RemoteException wrapping System.Exception: Failed to install package ‘Test.helpdesk.Invoices.1.0.4’ —> RemoteException wrapping System.Exception: NU1202: Package Test.helpdesk.Invoices 1.0.4 is not compatible with net6.0-windows7.0 (.NETCoreApp,Version=v6.0). Package Test.helpdesk.Invoices 1.0.4 supports: net8.0-windows7.0 (.NETCoreApp,Version=v…

This post made by @jast1631 received 1 likes!

Run time execution error First studio process

There is activity name delay search and you will get it and in format of Hh:mm:ss Based on the 1/2 sec delay you can give like this 00:00:02

This post made by @ashokkarale received 1 likes!

My own activity shows no categories under properties

@florian.langer, Refer this solution. Thanks, Ashok

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

My own activity shows no categories under properties

@florian.langer, Refer this solution. Thanks, Ashok

This solution provided by @Yoichi received 1 likes!

Sum of data containing dots and commas

Hi, Is there any non-numeric data including empty in the column? If so, the following expression will work. dt.AsEnumerable.Select(Function(r) r("Data").ToString.Replace(",",".")).Where(Function(s) Decimal.TryParse(s,New Decimal)).Sum(Function(s) Decimal.Parse(s)) 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 | 10 September 2024

Top 3 Topics with Most Views

Is there a capability with UiPath where we can pass automation steps through a file? made by @patrick.sameera with 21 views.

Where to place dispatcher xaml in ReFramework made by @Nisha_K21 with 17 views.

Select Menu Item 'ToolbarControl SAP.Too...': The UiElement is not initialized made by @kapaon with 17 views.

Top 3 Topics with Most Replies

シートの存在確認(複数)し、ファイルを分割する made by @once10201029 with 24 replies.

Can't login to Orchestrator on premise after installed first time made by @B_o_D with 16 replies.

Use Browser Edge: Invoice pdf: Could not find the UI element corresponding to this selector: <html app='msedge.exe' title='Invoice-485744.pdf'/> The closest matches found are: [62%] <html app='msedge.exe' title='New tab'/> made by @Dingkun_Yang with 12 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 36 posts!

@Anil_G made 35 posts!

@lrtetala made 13 posts!

Top 3 Most Liked Posts

This post made by @jjes received 2 likes!

Basic XML data extraction

I’ve made a short video for beginners (like myself) that shows you how to do basic data extraction from an XML-file. [UiPath XML Data Extraction Made Easy]

This post made by @lrtetala received 2 likes!

I need to get separate string value with regex

@shaik.muktharvalli1 Try this Input.Split("-"c)(0).Trim Input.Split("-"c)(1).Trim Regards,

This post made by @Nisha_K21 received 2 likes!

Where to place dispatcher xaml in ReFramework

Thanks @ashokkarale and @Anil_G

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

I have done first automation in studio but it doesn't uploaded on orchestrator

@Ejaz_Ab, As name suggests it’s personal feed accessible to you only. That’s your personal feed. You get access to publish delete etc. Tenent feed is common for all users who have access to use it.

This solution provided by @lrtetala received 1 likes!

Urgently! The target element is disabled when using the activity "Click"

@Evelyn_Lu Boolean Regards,

This solution provided by @Gowtham_K115 received 1 likes!

Get values separately with regular expression

Hi @shaik.muktharvalli1 You can try this way, variable type is string System.Text.RegularExpressions.Regex.Match("Inputstring","(\d+)\s(\d+)").Groups(1).Value Output = 530 System.Text.RegularExpressions.Regex.Match("Inputstring","(\d+)\s(\d+)").Groups(2).Value Output = 01 [image] Regards, Gowtham Krishnan

---

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

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

[system]

Daily Forum Report | 11 September 2024

Top 3 Topics with Most Views

How to close the popup in the excel made by @anjani_priya with 23 views.

Get subsequent rows based on excel data made by @Rreddy with 21 views.

Join DataTables to find rows with differences made by @Jon_G with 19 views.

Top 3 Topics with Most Replies

How to close the popup in the excel made by @anjani_priya with 22 replies.

2 string variable from 2 different column to populate a single output column in CSV made by @Irfan_Musa with 12 replies.

Get subsequent rows based on excel data made by @Rreddy with 11 replies.

Top 3 Users Who Posted The Most

@jast1631 made 41 posts!

@ashokkarale made 39 posts!

@Anil_G made 18 posts!

Top 3 Most Liked Posts

This post made by @lrtetala received 4 likes!

Monthly Forum Rewards - August 2024

Congratulations everyone

This post made by @info.surahalwaqiah received 2 likes!

Dive into the innovative world of agentic AI with UiPath – We need your insights!

Exciting times ahead with agentic AI and UiPath! The integration of AI in RPA is truly transforming workflows. I’d love to hear more about how others are leveraging these advancements for efficiency. For me, combining UiPath with AI has streamlined processes and opened up new possibilities. Looking forward to learning from everyone’s experiences and success stories!

This post made by @ashokkarale received 2 likes!

How to close the popup in the excel

@anjani_priya, Here is working sample for your reference. [This image shows a UiPath workflow in a Parallel activity, performing two parallel tasks: running a sub-workflow file ("SubFlow.xaml") and interacting with an Excel application by executing a specific click action on a 'Cancel' button. (Captioned by AI)] SubFlow [An automation workflow is designed to open the Excel file "Book1.xlsx" and log the message "File Opened" at the info level. (Captioned by AI)] ExcelWork.zip (243.6 KB)

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Regex extract aaname from UiElement

(?<=').*?(?=') just to make it ungreedy. But we would recommend for other options e.g. attribute retrieval

This solution provided by @lrtetala received 1 likes!

How to close the popup in the excel

@anjani_priya Use Check app state activity and then use click activity Regards,

This solution provided by @postwick received 1 likes!

User interaction with unattended robot on remote server

What you would do is use an attended automation with UiPath Forms to get the info from the user, and that attended automation would create a queue item. Then the queue item is picked up by the attended automation (queue trigger starts it) and processed. If you’re in cloud, UiPath Apps is also a great way to do this. It’s like forms but it’s better designed for triggering and interacting with jobs, etc. There is also an API in Orchestrator that you could use from a custom web page to create t…

---

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

Top 3 Topics with Most Views

I need help with Regex Replace made by @awnasf with 26 views.

UiPath.Core.Activities.OnUiElementVanish warning made by @Moshin_Ali_Khan with 22 views.

How to convert month text format? made by @domsmgtmeet22 with 22 views.

Top 3 Topics with Most Replies

How to convert month text format? made by @domsmgtmeet22 with 19 replies.

How to apply excel filter made by @chai01 with 13 replies.

Get all columns from two different datatables into one made by @Yasir_Yaqoob with 13 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 44 posts!

@jast1631 made 29 posts!

@Yoichi made 16 posts!

Top 3 Most Liked Posts

This post made by @ashokkarale received 4 likes!

Monthly Forum Rewards - August 2024

Congratulations all the winners

This post made by @pradeep931 received 4 likes!

Monthly Forum Rewards - August 2024

Congratulations to all the Winners

This post made by @jast1631 received 3 likes!

Monthly Forum Rewards - August 2024

Congratulations to all the Winners

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

Unable to locate Invoke Method Activity

@JK_MECH, In recent release of the UiPath.System.Activities Invoke method is missing for no reason. We have a workaround to downgrade 1 or 2 versions of the package and you will have the Invoke Method. Till the time UiPath communicate something on this, you can continue using this. Thanks, Ashok

This solution provided by @lrtetala received 1 likes!

Need help in regex code

Hi @Rreddy Can you try below (?<=FORMAT)([\s\S]*?)(?=DOWNLOAD) [image] System.Text.RegularExpressions.Regex.Match(Input,"(?<=FORMAT)([\s\S]*?)(?=DOWNLOAD)").Value.Trim [The image shows a workflow with three steps: two assign activities for "Input" and "Output" variables, and a message box displaying text that includes multiple lines. (Captioned by AI)] Regards,

This solution provided by @sudster received 1 likes!

I need help with Regex Replace

As @ppr mentioned, this task seems to be a straight up JSON processing; follow his advice to process the data. But if you have been given such a text input and would like to get it to a shape with which you can process the data further, this may help. [image] The output would look like: [The image shows a JSON structure with exchange rate data for USD and EUR against another currency on different dates in July 2024, including the UNIX timestamps for each entry. (Captioned by AI)]

---

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

Top 3 Topics with Most Views

"filter" excel made by @Julie2 with 22 views.

How to assign random robot available? made by @Parth_Belsare with 21 views.

Downloading more than 200 files from a sharepoint folder? made by @Aswin_Sutheesh17 with 20 views.

Top 3 Topics with Most Replies

Downloading more than 200 files from a sharepoint folder? made by @Aswin_Sutheesh17 with 12 replies.

Download File from URL Activity: Response status code does not indicate success: 401 (Unauthorized) made by @donghai with 9 replies.

How to know when was developer consumed License from Orchestrator made by @dlmsekhar with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 31 posts!

@ashokkarale made 13 posts!

@Yoichi made 12 posts!

Top 3 Most Liked Posts

This post made by @Krishna_Raj received 2 likes!

Monthly Forum Rewards - August 2024

Congratulations to all the winners

This post made by @Zeki_Berk_Gokkaya received 1 likes!

Download File from URL Activity: Response status code does not indicate success: 401 (Unauthorized)

The error 401 (Unauthorized) suggests that you are not authenticated when using the Download File from URL activity. Since you can get the correct response using the HTTP Request activity, it indicates that the SharePoint URL requires authentication. To fix this: Authenticate: Ensure you are passing the correct credentials (such as API key, OAuth token, or session cookies) required to access the file from SharePoint. Use HTTP Request: If you can successfully retrieve the file using HTTP Reques…

This post made by @dmendes received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

My name is David Mendes, from Portugal. I am AI PhD with special interest in RPA. Hope to learn a lot from the community. Yours truly DM

Top 3 Most Liked Solutions

This solution provided by @Zeki_Berk_Gokkaya received 1 likes!

"filter" excel

You can handle this issue by using the “Copy/Paste Range” activity in UiPath Studio X to copy the filtered data to another sheet or range, rather than modifying the original data directly. This way, you preserve the original table while working on the filtered data. Here’s how you can do it: Read your Excel Data: Use the “Use Excel File” activity to open your Excel file. Filter Data: Use the “Filter” activity on the data table to get the specific row(s) you want to display in Google Chrome. I…

This solution provided by @Yoichi received 1 likes!

Excel16を使用した画像領域の選択について

そのファイルでしか再現しないのであれば、そうかもしれません。 Excelへの書き込みはセル書き込みアクティビティの方が安定する →セル書き込みとなると、一つのセルの中に全てのデータが収まるようなイメージでしょうか？この後の処理が、Excelに書き込まれたデータの中で、C1、F3のデータを取得するというような作業が含まれるため、セル書き込みは難しいかもしれません。 この部分は処理でどのようにでもできると思いますので、可能であれば、実現したいことを具体的に共有いただければと思います。

This solution provided by @vrdabberu received 1 likes!

Date with AM PM

Hi @marina.dutta Try the below syntax: dateTimeValue = DateTime.ParseExact(str_attached_files_date, "M/d/yyyy h:mm tt", System.Globalization.CultureInfo.InvariantCulture).ToString("M/d/yyyy") Regards

---

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

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

[system]

Daily Forum Report | 14 September 2024

Top 3 Topics with Most Views

BOT is not able to capture 0 in case of formatted text or preceded by an apostrophe made by @sshitol with 22 views.

How to Use UIAutomation Activities in a Custom Activity (C#) made by @sean.deng with 13 views.

If in Activity list made by @Lilja_Gudrun with 13 views.

Top 3 Topics with Most Replies

Date time Comparison made by @marina.dutta with 12 replies.

BOT is not able to capture 0 in case of formatted text or preceded by an apostrophe made by @sshitol with 11 replies.

How to delete previous queue transactions if count is more e.g 400 489 650 etc made by @Shruthika_r with 9 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 12 posts!

@Anil_G made 11 posts!

@jast1631 made 7 posts!

Top 3 Most Liked Posts

This post made by @esongi_park received 1 likes!

Monthly Forum Rewards - August 2024

Congratulations everyone 모두 축하합니다

This post made by @sshitol received 1 likes!

BOT is not able to capture 0 in case of formatted text or preceded by an apostrophe

Hi, BOT is not able to capture 0 in case of formatted text or preceded by an apostrophe [image] test (2).xlsx (26.8 KB)

This post made by @sudster received 1 likes!

3d model comparison

You can compare 2 images using a marketplace app if you use legacy projects. Otherwise you may try using some of the AI platforms through the integration service (connectors). 3D model assemblies have internal parts, which are not visible on external screenshots. So, I don’t know how you are going to compare them accurately. Is it ok to compare the bill of materials from both Solidworks and Revit? Another technical solution is to assign proper densities to all parts of the assembly and their c…

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 | 15 September 2024

Top 3 Topics with Most Views

Screen shots made by @A_Learner with 19 views.

Horizontal column made by @Hemant_Deshmukh with 19 views.

Triggers question made by @A_Learner with 16 views.

Top 3 Topics with Most Replies

GitHub clone issue - remote authentication required but no callback set made by @dineshkumar.rajendran with 10 replies.

Filter data table column not supported made by @Ejaz_Ab with 8 replies.

How to click download button on specific text made by @suraj_gaikwad with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 31 posts!

@jast1631 made 10 posts!

@dineshkumar.rajendran made 9 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

Type of DataTable for Sharepoint Get List Iteams activity

@OGunnarsson Did yoi happen to give any filter? Did you mention any columns names in the columsn field as input? Just to check canyou try with for each liat item activity to check if the connectivity with list is proper Cheers

This post made by @sudster received 1 likes!

3d model comparison

As mentioned previously, this would only work with Windows Legacy projects. Good idea. First you need to work out the steps and then only worry about implementing it in UiPath. A very effective method to compare solid bodies: Export models to a neutral format, e.g. STEP, IGES, Parasolid etc Import the neutral format into Solidworks “Part” environment Give each solid body a distinct colour Set the same Model Coordinate System with matching directions for both bodies Superimpose both bod…

This post made by @Anil_G received 1 likes!

Screen shots

@A_Learner You can use work activities and inside that use add picture as many times as you need the images or use it inside loop and all images would be added tow ork…then use save as pdf and save the word as pdf…all the images would be added Cheers

Top 3 Most Liked Solutions

This solution provided by @jast1631 received 1 likes!

Queue trigger process question

Queue triggers will be mostly use ful for complex implementation. Mostly queue triggers are use full when you want to trigger different process based on the queue items process or process which need to be run in a sequence like that You can have dispatcher and performer combined in one process But I guess for this specific queue trigger is not required you can use get queue items and performer will work , That is there it self in templet. @A_Learner Thanks , Jagravi

This solution provided by @Anil_G received 1 likes!

Facing could not find file .local\db while creating a fresh project

@Badri_Narayanan Take a back up first Go to the project folder and delete the .local folder or all the folders starting with . …when you open again they should be created automatically 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 | 16 September 2024

Top 3 Topics with Most Views

UiPath services down? made by @Parth_Belsare with 26 views.

How to Retrieve Base64 Encoded Screenshot from Storage Bucket in text file as Output Argument in Postman? made by @gayatri.kesalkar with 21 views.

IDictionary'2' does not have public instance method name'ADD' made by @Farooq_Syeda with 21 views.

Top 3 Topics with Most Replies

Click Action in loop made by @a.bhandwalkar with 21 replies.

UiPath services down? made by @Parth_Belsare with 12 replies.

How can i get access from uipath file in excel activity made by @Ejaz_Ab with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 45 posts!

@ashokkarale made 18 posts!

@jast1631 made 17 posts!

Top 3 Most Liked Posts

This post made by @bhuvangates received 4 likes!

Unlock the Future: #1 Challenge from the 20 Use Cases Challenge Learning Sprint

Unlock the Future: 20 Use Cases Challenge Learning Sprint Just wrapped up Day 1/10 of the hands-on learning sprint! Solved two unique use cases utilizing powerful concepts like Dictionaries, Tuples, and RegEx Builder to tackle real-world automation challenges. A fully immersive session delivered by UiPath MVP experts, pushing our skills to the next level with practical, hands-on training. Excited for the next 9 days of th…

This post made by @fanikarthik received 3 likes!

Unlock the Future: #1 Challenge from the 20 Use Cases Challenge Learning Sprint

Unlock the Future: 20 Use Cases Challenge Learning Sprint! Just completed Day 1 of 10 of the hands-on learning sprint! Solved two unique use cases leveraging the concepts such as Dictionaries, Tuples, and Regular Expression Builder Thank you, HyperAutomation-ai, for hosting this “20 Use Cases Challenge Learning Sprint!” Your efforts in organizing and delivering such valuable content are truly appreciated. Excited for the next 9 days sessions and challenges. Shopping …

This post made by @Akash_Javalekar1 received 3 likes!

Unlock the Future: #1 Challenge from the 20 Use Cases Challenge Learning Sprint

Unlock the Future: 20 Use Cases Challenge Learning Sprint! Completed day 1 hands on learning experience thank you so much for giving this opportunity to showcase our knowledge @fanikarthik @AutomationX_by_Kiran @pradeep_ch @pathrudu please find solution for two use case Challenge_1.zip (8.5 KB)

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Meaning of dbo.Jobs.RuntimeType and dbo.Jobs.ProcessType

@Murat hope this helps [The image depicts a code snippet defining properties for "RuntimeType" and "ProcessType" with corresponding enumerations for different types of robot runtimes and process types. (Captioned by AI)] details of models can be obtained from swagger <orchestratorurl>/swagger/index.html#/ cheers

This solution provided by @ashokkarale received 1 likes!

UiPath Cloud Down

@bharat.c, Nothing has been reported on Status page but keep tracking this page.

This solution provided by @Anil_G received 1 likes!

String Array variables resetting to empty string

@private_matter I agree its a bug…I just gave a workaround in the mean time 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 | 17 September 2024

Top 3 Topics with Most Views

🙋‍♀️ 🙋‍♂️ Unlock the Future: #2 Challenge from the 20 Use Cases Challenge Learning Sprint made by @AutomationX_by_Kiran with 64 views.

Time trigger made by @A_Learner with 20 views.

Count number of rows in Excel made by @chai01 with 18 views.

Top 3 Topics with Most Replies

🙋‍♀️ 🙋‍♂️ Unlock the Future: #2 Challenge from the 20 Use Cases Challenge Learning Sprint made by @AutomationX_by_Kiran with 11 replies.

Why does my invoke code always return false? made by @Matias_Clemente.Arg with 8 replies.

Is it possible ? Retry scope without condition made by @Ajith3 with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 18 posts!

@lrtetala made 16 posts!

@Matias_Clemente.Arg made 10 posts!

Top 3 Most Liked Posts

This post made by @Kancharla_Mahija received 5 likes!

Unlock the Future: #2 Challenge from the 20 Use Cases Challenge Learning Sprint

Day 2/10 Just finished another Challenge! Dived into two mind-blowing use cases, getting deep into Semantic Activities and Table Extraction—automation just got a serious upgrade! Usecase3-aiCopyPaste.zip (336.6 KB) Usecase4-metaDataScraping.zip (366.7 KB) Big thanks @AutomationX_by_Kiran @pradeep_ch @pathrudu for taking this forward Excited for what the next days will bring! uipath rpa automation #SemanticActivities #TableExtraction #LearningSprint #Day2 @lore…

This post made by @Kancharla_Mahija received 5 likes!

Unlock the Future: #1 Challenge from the 20 Use Cases Challenge Learning Sprint

Unlock the Future: 20 Use Cases Challenge Learning Sprint! Day 1 done! Solved two cool use cases with Dictionaries, Tuples, and RegEx Builder. Usecase1-Shopping List.zip (48.1 KB) Usecase2-Patient Insurance Records.zip (56.6 KB) Big thanks to HyperAutomation-ai for this amazing sprint! can’t wait for the next 9 days! @AutomationX_by_Kiran @pradeep_ch @pathrudu @loredana_ifrim Huge love to all of you

This post made by @bhuvangates received 5 likes!

Unlock the Future: #2 Challenge from the 20 Use Cases Challenge Learning Sprint

Unlock the Future: 20 Use Cases Challenge Learning Sprint Day 2/10 Another amazing hands-on session completed! Solved two exciting use cases diving deep into Semantic Activities and Table Extraction concepts—taking automation to new levels! Thanks to the UiPath MVP experts, the learning continues to be immersive and practical, equipping us with skills that are ready for real-world application. Looking forward to what the next da…

Top 3 Most Liked Solutions

This solution provided by @naveen.s received 3 likes!

What skill anyone needs to develop who wants to be solution architect?

@Mathkar_kunal , This may helps you! Transitioning from a Senior RPA Developer to a Solution Architect in UiPath or any RPA platform is an admirable goal, and it requires a mix of technical expertise, soft skills, and strategic understanding. Here are some of the qualities, knowledge areas, and certifications you might consider to build your profile for this role: Key Qualities and Skills: Technical Expertise: Deep Knowledge of RPA: Understand RPA architecture, development, and deployment…

This solution provided by @Yoichi received 1 likes!

How to retrieve Excel table range without opening the file?

Nope. ReadRangeWorkbook activity is neither modern nor classic. Can you search it by ReadRange? ReadRangeWorkbook activity can be found. Regards,

This solution provided by @Yoichi received 1 likes!

Why does my invoke code always return false?

Hi, The input string seems 10 digits. However, the regex pattern requires 11 digits at least. So it returns false. If you also need to match the string, can you try to replace {9} with {8,9} in the pattern, for example? 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 | 18 September 2024

Top 3 Topics with Most Views

🙋‍♀️ 🙋‍♂️ Unlock the Future: #3 Challenge from the 20 Use Cases Challenge Learning Sprint made by @AutomationX_by_Kiran with 27 views.

Alternative for Contains Keyword made by @Nisha_K21 with 19 views.

UiPath Unable to communicate with edge made by @karthik_kulkarni1 with 15 views.

Top 3 Topics with Most Replies

Copy cells from dynamic Pivot Table made by @Youri98 with 16 replies.

Unable to Highlight Dropdown Elements in UI Explorer – How to Enable Highlighting? made by @gayatri.kesalkar with 11 replies.

Alternative for Contains Keyword made by @Nisha_K21 with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 41 posts!

@ashokkarale made 34 posts!

@naveen.s made 19 posts!

Top 3 Most Liked Posts

This post made by @rashmisingh2695 received 4 likes!

Unlock the Future: #2 Challenge from the 20 Use Cases Challenge Learning Sprint

Unlock the Future: 20 Use Cases Challenge Learning Sprint - Day 2 Day 2/10 Solved two exciting use cases, taking a deep dive into Semantic Activities and Table Extraction—powerful AI features reshaping the future of automation! A heartfelt thank you to the organizers @AutomationX_by_Kiran @pathrudu @pradeep_ch @loredana_ifrim Eagerly anticipating the upcoming sessions. UseCase3_RPAChallenge.zip (101.7 KB) UseC…

This post made by @jitendra.saroj received 3 likes!

Unlock the Future: #2 Challenge from the 20 Use Cases Challenge Learning Sprint

Day 2/10 finished another Challenge! Attaching the solution for Day 2 Challenge JitendraSaroj_Let AI do the copy paste.zip (27.4 KB) JitendraSaroj_Meta Data Changes in Data Scarping.zip (14.1 KB) Big thanks @AutomationX_by_Kiran @pradeep_ch @pathrudu for taking this forward Excited to see what the next days will bring!

This post made by @madhu_vadala received 3 likes!

Unlock the Future: #2 Challenge from the 20 Use Cases Challenge Learning Sprint

Unlock the Future: 20 Use Cases Challenge Learning Sprint! Just completed Day 2 of 10 of the hands-on learning sprint! Solved two unique use cases leveraging the concepts such Semantic Activities and Table Extraction—powerful AI features reshaping the future of automation! Thank you, @AutomationX_by_Kiran, @pathrudu @pradeep_ch for hosting this “20 Use Cases Challenge Learning Sprint!” Your efforts in organizing and delivering such valuable content are truly appreciated. Excited for the nex…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

HTTP POST response returns additional characters

Hi, I need to be able to remove this “Double Quote” character that is inserting itself in my content response from the HTTP activity. How about the following expression? strVar.Trim(Chr(34)) Regards,

This solution provided by @Anil_G received 1 likes!

"How do I pass a variable value to custom HTML in UiPath Apps

@SURESH_BABU_YADAV_MOODI Welcome to the community Please check this… Cheers

This solution provided by @ashokkarale received 1 likes!

Copy cells from dynamic Pivot Table

@Youri98, Ok here is sample code to refer. I’m assuming you have file like this. [A pivot table in Excel summarizes sales, profit, and revenue data for entities ABC, AFG, and XYZ with their respective totals. (Captioned by AI)] Code like this. [The image depicts a detailed flowchart of an Excel process automation script, which includes steps to read specific cell values and log messages. (Captioned by AI)] Output: [The image shows the output log of a UiPath automation script indicating …

---

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

Top 3 Topics with Most Views

🙋‍♀️ 🙋‍♂️ Unlock the Future: #4 Challenge from the 20 Use Cases Challenge Learning Sprint made by @pradeep_ch with 39 views.

CultureInfo.InvariantCulture is Empty made by @itaim with 20 views.

Same column name in excel made by @Gokul_Murali with 20 views.

Top 3 Topics with Most Replies

Use Application/Browser wait for program to load/open made by @SorenB with 15 replies.

新しく立ち上がったブラウザのタブで作業を継続するには made by @takashi_miyagi with 15 replies.

How to open a zip file, then copy some files, paste it into the desired path? made by @kian.ng with 15 replies.

Top 3 Users Who Posted The Most

@lrtetala made 21 posts!

@Anil_G made 21 posts!

@Yoichi made 15 posts!

Top 3 Most Liked Posts

This post made by @pradeep_ch received 4 likes!

Unlock the Future: #4 Challenge from the 20 Use Cases Challenge Learning Sprint

Dear Community enthusiasts, are you up to Unlock the Future further? Virtual series day 4 happening right now : See Unlock the Future: Join the 20 Use Cases Challenge Learning Sprint - Day 4 at UiPath Visakhapatnam and now it’s time to put your skills to the test. Are you ready for #4 Challenge from the 20 Use Cases Challenge Learning Sprint , crafted together with @AutomationX_by_Kiran ,@pathrudu and with the help of @loredana_ifrim? Let’s level up your UiPath skills! …

This post made by @Akash_Javalekar1 received 3 likes!

Unlock the Future: #4 Challenge from the 20 Use Cases Challenge Learning Sprint

Unlock the Future: 20 Use Cases Challenge Learning Sprint - Day 4! successfully completed two amazing challenges: Automate Movie Information Retrieval and Storage Extract and Validate Driver’s License Data Using UiPath Document Understanding I’ve also implemented a document understanding use case for COVID certification, utilizing the out-of-the-box machine learning package to extract Vaccination details and validate data with high pr…

This post made by @DevendraRPA received 2 likes!

Unlock the Future: #3 Challenge from the 20 Use Cases Challenge Learning Sprint

Unlocking the Future: 20 Use Cases Challenge Learning Sprint Successfully completed Day 3 of our hands-on learning sprint! I tackled two exciting use cases—pushing the boundaries of automation! This immersive session, led by UiPath MVP experts, provided invaluable, hands-on training that’s already taking our skills to the next level. Excited for the next challenge in this incredible journey! Let’s continue to grow and sharpen our …

Top 3 Most Liked Solutions

This solution provided by @mateuszmacheta received 1 likes!

Use Application/Browser wait for program to load/open

To debug this you can log message after 1st Use App/Browser with your OutputUiElement.Selector.Text, copy it to Ui Explorer as see if it validates. Workaround you could try would be to put Get Active Window, use ApplicationWindow from this in Input Element for Highlight and then output element will be your ui element for window. Can’t verify if it’ll fix it as I don’t have this issue. [The image shows a UiPath workflow for highlighting an active window in Google Chrome, with configuration opt…

This solution provided by @Yoichi received 1 likes!

LINQ query error - help

Which activity do you use, ReadCSV or GenerateDataTable with ReadTextFile? If latter, Turning off AutoDetectTypes property of GenerateDataTable may help you. Regards,

This solution provided by @AJ_Ask received 1 likes!

Copy from number in excel to star rating in website

Hi @indah.sari Get the values from Excel using read range then assign it to a variable. In my case i have used Int_Star. Use this variable in your click activity to make it dynamic. Check this selector for 4 stars [image] to make this selectors dynamic we will replace the star value with star no. using varibale then the selector will be like this [image] This will make it dynamic as we have variblies the star that we want to click [The image shows an RPA workflow involving an assignment o…

---

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

Top 3 Topics with Most Views

Compare Datatable values with array using linq made by @yashashwini2322 with 18 views.

Excel Pivoting made by @Gokul_Murali with 17 views.

Extract price details from Flipkart made by @sharu_priya with 17 views.

Top 3 Topics with Most Replies

How to move outlook one folder to another folder based on Attachment name made by @Raja.G with 14 replies.

Need help to filter data table made by @Venu_V with 13 replies.

VLOOKUP USING studioX made by @govindreddy_nagireddy with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 34 posts!

@lrtetala made 16 posts!

@ashokkarale made 16 posts!

Top 3 Most Liked Posts

This post made by @Aditi_Indoriya received 5 likes!

Unlock the Future: #4 Challenge from the 20 Use Cases Challenge Learning Sprint

Unlock the Future: 20 Use Cases Challenge Learning Sprint Day 4/10 Another insightful and hands-on session completed! Tackled two new use cases using Document Understanding and Get Activities, adding a new layer to my automation toolkit. Huge thanks to the UiPath MVP experts for the immersive learning experience—each day expands the possibilities of automation. Excited for the next steps in this amazing journey! uipath rpa document…

This post made by @rashmisingh2695 received 3 likes!

Unlock the Future: #4 Challenge from the 20 Use Cases Challenge Learning Sprint

Unlock the Future: 20 Use Cases Challenge Learning Sprint Day 4/10 Another day, another leap forward in our automation journey! Solved two fascinating use cases with UiPath’s Document Understanding (DU) model and dynamic data extraction from websites using Get Activities. Immense gratitude to the UiPath MVP experts for their exceptional guidance. @pradeep_ch @AutomationX_by_Kiran @pathrudu @loredana_ifrim Each session reveals new horizons in…

This post made by @madhu_vadala received 3 likes!

Unlock the Future: #4 Challenge from the 20 Use Cases Challenge Learning Sprint

Unlock the Future: 20 Use Cases Challenge Learning Sprint! Just completed Day 4 of 10 of the hands-on learning sprint! Solved two new use cases utilizing Document Understanding and Get Activities , Thank you, @AutomationX_by_Kiran, @pathrudu @loredana_ifrim @pradeep_ch for hosting this “20 Use Cases Challenge Learning Sprint!” Your efforts in organizing and delivering such valuable content are truly appreciated. DU_Usecase.zip (606.5 KB) Movie search Use case.zip (401.4 KB)

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

How many types of Machine templates in Orchestrator?

@Sanket_Shinde1, These machine types are used depending on the scale and flexibility of your automation needs: Machine Template: A machine template allows you to define a single machine configuration that can be assigned to multiple robots dynamically. Use Case: It is used when you want to scale robots across different machines or virtual environments without having to manually configure each robot with its own machine. It provides flexibility when your environment involves multiple bots o…

This solution provided by @ashokkarale received 1 likes!

Learning plan of UiPath Certified Professional Automation Developer Associate

@Sachini_Rajapaksha, You are using older version of the learning path. Use this. Thanks, Ashok

---

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

Top 3 Topics with Most Views

Variable Panel Default value Error made by @ajaynnair2 with 13 views.

How to read excel files using multiple files in folder made by @nirmalad123 with 12 views.

Filter DataTable using C# Linq made by @Nikhil_Zambare1 with 12 views.

Top 3 Topics with Most Replies

How to avoid from duplicates uploading into queue? made by @Ayatulla_Middya with 13 replies.

Filter DataTable using C# Linq made by @Nikhil_Zambare1 with 9 replies.

UIPATH Activity Error: Wait for Document Validation Action and Resume made by @madhabhazra0 with 7 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 17 posts!

@Anil_G made 15 posts!

@Yoichi made 7 posts!

Top 3 Most Liked Posts

This post made by @Kancharla_Mahija received 2 likes!

Unlock the Future: #5 Challenge from the 20 Use Cases Challenge Learning Sprint

Dive into the Future: Day 5 of the 20 Use Cases Challenge Learning Sprint! I am thrilled to be part of this exciting Challenge on Day 5, exploring the vast ocean of automation Usecase9-CreateLoanRequest.zip (1.9 MB) Usecase10-Automating User Profile Generation with Random User API.zip (175.4 KB) Huge shoutouts to the incredible team for this amazing opportunity to learn and grow. Can’t wait for more of what’s next in store! Big thanks to @AutomationX_by_Kiran, @loredana_if…

This post made by @Ayatulla_Middya received 2 likes!

How to avoid from duplicates uploading into queue?

@ashokkarale @Anil_G @tushar_srivastava “Thank you very much for your assistance. I truly appreciate your help.”

This post made by @Yusuf_Jasin received 1 likes!

Join AI Associate Developer Series 2024!

hello may i register from session 3 ( Session 3: AI Powered Automation through specialized AI. Spotlight on AI Cente) ? cause in session 1 and 2 have understand ?

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

Filter DataTable using C# Linq

@Nikhil_Zambare1 Also try this.

This solution provided by @ajaynnair2 received 1 likes!

Variable Panel Default value Error

I have used assigned activity to initialize varible and it works perfectly

---

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

Top 3 Topics with Most Views

How to use click activity depending on the current year made by @mr_nobody with 16 views.

Validation of For each file Name and data in the DT made by @raju_alakuntla with 16 views.

How To Make Server For Chrom Extension Cookies receiving? made by @Abrm with 10 views.

Top 3 Topics with Most Replies

Extract PDF Table using form Extractor made by @dutta.marina with 9 replies.

How to use click activity depending on the current year made by @mr_nobody with 8 replies.

While running Could not find the user-interface (UI) element for this action made by @Ejaz_Ab with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 8 posts!

@ashokkarale made 8 posts!

@Ejaz_Ab made 6 posts!

Top 3 Most Liked Posts

This post made by @sayali.p received 2 likes!

Create Folder Activity of Microsoft Office 365 Activities

No worries I got Solution Simply by putting “Nothing” it’s working fine

This post made by @Indhuja.Masilamani received 1 likes!

While running Could not find the user-interface (UI) element for this action

Please make sure the selectors has the aaname field and does not have any idx or parent id features which is point to a number value . If you need more help you can share the screenshot of the selector.

This post made by @lrtetala received 1 likes!

How to use click activity depending on the current year

Hi @mr_nobody Can you try the below Sequence18.xaml (18.2 KB) Regards,

Top 3 Most Liked Solutions

This solution provided by @sayali.p received 2 likes!

Create Folder Activity of Microsoft Office 365 Activities

No worries I got Solution Simply by putting “Nothing” it’s working fine

This solution provided by @lrtetala received 1 likes!

How to use click activity depending on the current year

Hi @mr_nobody Can you try the below Sequence18.xaml (18.2 KB) Regards,

This solution provided by @lrtetala received 1 likes!

Validation of For each file Name and data in the DT

Hi @raju_alakuntla Can you try below [The image depicts a sequence in UiPath automation workflow that reads a range from an Excel workbook, iterates through each row to evaluate a condition, updates the status column based on the condition result, and writes the updated data back to the Excel workbook. (Captioned by AI)] System.IO.Directory.GetFiles("C:\Users\lrtetala\Documents\UiPath\BlankProcess23\Input").Any(Function(file) System.IO.Path.GetFileNameWithoutExtension(file).Equals(CurrentRow…

---

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

Top 3 Topics with Most Views

How to read a excel made by @balanirmalkumar.s with 19 views.

To fetch article title, class and date made by @Iman_Shafeeq with 18 views.

How to attach multiple image in outlook mail body made by @zaid.ahmad with 17 views.

Top 3 Topics with Most Replies

How to attach multiple image in outlook mail body made by @zaid.ahmad with 15 replies.

Error when publish the project made by @Robot_2S with 14 replies.

Email issue made by @Rakesh_Tiwari with 13 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 27 posts!

@lrtetala made 25 posts!

@muktadir made 11 posts!

Top 3 Most Liked Posts

This post made by @pathrudu received 1 likes!

Unlock the Future: #6 Challenge from the 20 Use Cases Challenge Learning Sprint

Dear Community enthusiasts, are you up to Unlock the Future further? Virtual series day 6 happened today : See Unlock the Future: Join the 20 Use Cases Challenge Learning Sprint - Day 6 at UiPath Visakhapatnam and now it’s time to put your skills to the test. Are you ready for #6 Challenge from the 20 Use Cases Challenge Learning Sprint , crafted together with @pradeep_ch , @AutomationX_by_Kiran and with the help of @loredana_ifrim & @Ana_Bulhac ? Let’s level up your UiPath skills! …

This post made by @ashokkarale received 1 likes!

To fetch article title, class and date

@Iman_Shafeeq, Open table extraction wizard Click on add column Highlight the title Again click on add column and highlight class or another field you have. Continue same steps for more columns. After selecting all columns, configure next page selecti at bottom of the wizard. Refer the documentation shared earlier. Let me know if any issue. Thanks, Ashok

This post made by @ashokkarale received 1 likes!

When control comes to Increment retry counter?

@Ayatulla_Middya, If using ReFramework with Queue, max retry count in config file should be 0. Queue # of retries will decide how many retries there should be. Thanks, Ashok

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

To fetch article title, class and date

@Iman_Shafeeq, Open table extraction wizard Click on add column Highlight the title Again click on add column and highlight class or another field you have. Continue same steps for more columns. After selecting all columns, configure next page selecti at bottom of the wizard. Refer the documentation shared earlier. Let me know if any issue. Thanks, Ashok

This solution provided by @mkankatala received 1 likes!

Error when publish the project

It might get effecting to publish the project, change the datatype to Datarow else if you dont have any usage of that xaml then right click on xaml and select the Ignore from publish then it will publish to Orchestrator… @Robot_2S Hope you understand!!

This solution provided by @Anil_G received 1 likes!

Automation Developer issue adding license

@Short It is to be done for the users and not machines… Go to tenant → manage access → edit user to who the license is to be give → give the developer role and next page you would have option to give license appropriately 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 | 24 September 2024

Top 3 Topics with Most Views

How to automate chromium browser (JxBrowser) embedded in a JAVA application? made by @kumar.varun2 with 20 views.

Check if excel has particular value, excel has no columnName in it made by @shilpashree.mohanty with 20 views.

I want to know the row number of Currentrow in for Each Row in Data table made by @sssim4567 with 19 views.

Top 3 Topics with Most Replies

Check if excel has particular value, excel has no columnName in it made by @shilpashree.mohanty with 24 replies.

Could not see screenshots in Test Manager or Assertion from Orchestrator made by @baranidharan.gajendran with 10 replies.

How to read multiple table from one excel made by @balanirmalkumar.s with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 28 posts!

@ashokkarale made 22 posts!

@Yoichi made 15 posts!

Top 3 Most Liked Posts

This post made by @chethan.dinnupati received 4 likes!

Unlock the Future: #6 Challenge from the 20 Use Cases Challenge Learning Sprint

Hi Community, Thanks @loredana_ifrim @pathrudu @pradeep_ch @AutomationX_by_Kiran Thanks for the great initiative sessions. Use Case - 11 Solution RPAChallengeAutomation.xaml (40.6 KB) Use Case - 12 Solution ExtractInvoiceInformation.xaml (23.3 KB) Thanks

This post made by @Kancharla_Mahija received 4 likes!

Unlock the Future: #6 Challenge from the 20 Use Cases Challenge Learning Sprint

Blast Off to the Future: 20 Use Cases Challenge Learning Sprint Day 6/10 Dived into two thrilling use cases with UiPath Studio Web. UseCase11_RPAChallenge.uip (318.4 KB) UseCase12_ExtractInvoiceInformation.zip (19.9 KB) Huge shoutout to the UiPath MVP experts @pathrudu, @pradeep_ch, @AutomationX_by_Kiran, and @loredana_ifrim for their stellar guidance. Can’t wait for the upcoming challenges and the chance to sharpen our skills even more! …

This post made by @rashmisingh2695 received 3 likes!

Unlock the Future: #6 Challenge from the 20 Use Cases Challenge Learning Sprint

Unlock the Future: 20 Use Cases Challenge Learning Sprint Day 6/10 Tackled two fascinating use cases using UiPath Studio Web . Immense gratitude to the UiPath MVP experts @pathrudu @pradeep_ch @AutomationX_by_Kiran @loredana_ifrim for their exceptional guidance. Eagerly looking forward to the upcoming challenges and the opportunity to further refine our skills. UseCase11_RPAChallenge.uip (318.4 KB) UseCase12_ExtractInvoiceInformati…

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

Extract excel data from columns

@Anelisa_Bolosha1, currentRow.Item(“Column Name”).Tostring this will return you string. So datatype of the variable should be string

This solution provided by @Ratish_S received 1 likes!

1) : error BC32043: Too many type arguments to 'Func(Of Out TResult)'. (2) : error BC36625: Lambda expression cannot be converted to 'Expression(Of Func)' because 'Expression(Of Func)' is not a delegate type

I changed the query by splitting it into multiple assign acitivity and passed SQL query as concatenated variables. It is working Fine now. Thanks for the ideas, Anil.

This solution provided by @ashokkarale received 1 likes!

How to convert JSON to Dictionary

@copy_writes, Use this logic. [The image depicts a workflow in UiPath Studio that reads a JSON file, deserializes it, iterates through its properties, logs each property, and handles nested JSON objects recursively. (Captioned by AI)] Variables: [The image shows a table listing three variables (jsonString, dictOutput, jObject) with their corresponding types, scopes, and default values within a JSONDemo context. (Captioned by AI)] Output: [The image displays the debugger output from a cod…

---

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

Top 3 Topics with Most Views

:Raising_hand_woman: 🙋‍♂️ Unlock the Future: #8 Challenge from the 20 Use Cases Challenge Learning Sprint made by @deepak.rai6 with 21 views.

My leraning journey made by @Ernest_Ndifor1 with 21 views.

Interview Usecase Scenario made by @sharu_priya with 19 views.

Top 3 Topics with Most Replies

GenAi Activities made by @rmorgan with 11 replies.

Linq Query to Filter future and past date made by @sharu_priya with 9 replies.

Action is ambiguous,imported from the namespaces or types 'microsoft.office.interop.excel,system made by @Farooq_Syeda with 8 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 23 posts!

@sharu_priya made 9 posts!

@sppal.c made 9 posts!

Top 3 Most Liked Posts

This post made by @deepak.rai6 received 4 likes!

Unlock the Future: #7 Challenge from the 20 Use Cases Challenge Learning Sprint

jira_issues_to_create.xlsx (8.7 KB) Here is the excel.

This post made by @Kancharla_Mahija received 3 likes!

Unlock the Future: #7 Challenge from the 20 Use Cases Challenge Learning Sprint

I’m thrilled to share that I’ve completed two exciting use cases: Jira Issue Creation and API Methods. Usecase13_Jira.zip (39.9 KB) Usecase14-ExtractUpdateDeletePostDataUsingUiPathAPIAutomation.zip (163.9 KB) A huge thank you to the incredible team who made this possible: @loredana_ifrimspace_invader, @pathrudu, @pradeep_ch, @AutomationX_by_Kiran, and @deepak.rai6! Your dedication and hard work are truly appreciated. #Teamwork #Success #Innovation #Gratitude

This post made by @deepak.rai6 received 2 likes!

Unlock the Future: #8 Challenge from the 20 Use Cases Challenge Learning Sprint

Dear Community enthusiasts, are you up to Unlock the Future further? Virtual series day 8 happened today : See Unlock the Future: Join the 20 Use Cases Challenge Learning Sprint - Day 8 at UiPath Visakhapatnam and now it’s time to put your skills to the test. Are you ready for #8 Challenge from the 20 Use Cases Challenge Learning Sprint , crafted together with @pradeep_ch , @AutomationX_by_Kiran @pathrudu and with the help of @loredana_ifrim & @Ana_Bulhac ? Let’s level up your UiPath s…

Top 3 Most Liked Solutions

This solution provided by @Anjani_Kapoor received 1 likes!

Linq Query to Filter future and past date

it should be dataTable. also in “Value to Save” field you only need to write the query and not table reference as dt_pastDates. thus, in “Save to” type in dt_pastDates and in “Value to Save” - DT1.AsEnumerable.Where(function(r) cdate(r(“Date of Completion”)) < DateTime.Today.Date).CopyToDataTable

This solution provided by @sppal.c received 1 likes!

String : Get first 3 characters after the dot

varStr.Substring(0,varStr.IndexOf(".")+4)

This solution provided by @ashokkarale received 1 likes!

Could not load file or assembly 'System.Formats.Asn1'

@Allan_Marcello, Follow this hardcode way to import the namespace.

---

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

Top 3 Topics with Most Views

Excel and re framework made by @RACHEL_PAUL with 27 views.

Move file activity:Showing error made by @vishnu.nair with 20 views.

How can we pass default value to a data type of New Dictionary(Of String, List(Of String))() made by @HappyCoding with 16 views.

Top 3 Topics with Most Replies

Move file activity:Showing error made by @vishnu.nair with 21 replies.

Excel and re framework made by @RACHEL_PAUL with 15 replies.

'delete' Activity가 작동하지 않습니다 made by @user57 with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 41 posts!

@ashokkarale made 14 posts!

@Yoichi made 12 posts!

Top 3 Most Liked Posts

This post made by @Kancharla_Mahija received 4 likes!

Unlock the Future: #8 Challenge from the 20 Use Cases Challenge Learning Sprint

I’ve successfully completed USECASE 15: RPA Challenge Form Filling. Usecase15-UiAutomationRPAChallenge.zip (323.8 KB) USE CASE 16 :Automating Data Entry in CRM Applications Using Excel Usecase16-MyCRM.zip (254.1 KB) A huge thank you to the incredible team who made this possible: @loredana_ifrim, @pathrudu, @pradeep_ch, @AutomationX_by_Kiran, and @deepak.rai6! Your dedication and hard work are truly appreciated. #Teamwork #Success #Innovation #Gratitude

This post made by @Aditi_Indoriya received 3 likes!

Unlock the Future: #8 Challenge from the 20 Use Cases Challenge Learning Sprint

Sample.xlsx (9.9 KB) APP-CRM&AnyTeller.zip (131.0 KB)

This post made by @jitendra.saroj received 3 likes!

Unlock the Future: #8 Challenge from the 20 Use Cases Challenge Learning Sprint

Today, I completed two exciting use cases: Dynamic Form Filling and CRM Automation. A big thank you to the amazing MVP experts for this incredible opportunity to expand my skills and knowledge. Looking forward to more growth and collaboration in the days ahead! #LearningSprint #Day8 uipath rpa automation uiautomation#Desktop Automation web Automation Special thanks to @AutomationX_by_Kiran, @pathrudu, @loredana_ifrim, @deepak.rai6, and @pradeep_ch JitendraSaroj_Data Entry_C…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Want to add one excel file data into another excel file

@Garyy Try this Read first datatable into dt1 read second into dt2 now use write range with dt2 as input and first file as input and range as "B" + (dt1.RowCount-dt2.RowCount+2).ToString cheers

This solution provided by @Yoichi received 1 likes!

複数のワークフローファイルを呼び出しを一括で編集したい

たびたびすみません。 別のアプローチとして、引数を個別に設定するのではなく、Dictionaryとして渡してあげるようにしておけば、（つくりにもよりますが、）変更時の省力化ができるかもしれません。 （利用できるかはSystem.Activities packageのバージョンによると思います。） [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 September 2024

Top 3 Topics with Most Views

Yoichi 5000th Solution Celebration made by @Anil_G with 31 views.

Announcing the Public Preview of our new Workday REST connector in Integration Service made by @Samrat_Dutta with 27 views.

RegEx - Find Matching Patterns made by @Staccato with 21 views.

Top 3 Topics with Most Replies

Yoichi 5000th Solution Celebration made by @Anil_G with 15 replies.

Two Variable save in one excel sheet made by @farzana.mohammed with 12 replies.

Read “dynamic range” from excel file with a “dynamic name” for the first sheet made by @jwetherin with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 17 posts!

@Yoichi made 15 posts!

@ashokkarale made 13 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 8 likes!

Yoichi 5000th Solution Celebration

Lets join to celebrate a big milstone from @Yoichi Great acheivement on giving 5000 solutions. You are an invaluable asset to the community Cheers

This post made by @chethan.dinnupati received 3 likes!

Unlock the Future: #9 Challenge from the 20 Use Cases Challenge Learning Sprint

Hi Community Thanks @AutomationX_by_Kiran @pathrudu @pradeep_ch @loredana_ifrim @Hyperautomation-ai for the insights session Use Case - 17 Solution ExtractAccountNumberFromText.xaml (7.3 KB) Use Case - 18 Solution ShoppingTaxCalculation.xaml (39.2 KB)

This post made by @Kancharla_Mahija received 3 likes!

Unlock the Future: #9 Challenge from the 20 Use Cases Challenge Learning Sprint

Unlock the Future: 20 Use Cases Challenge Learning Sprint Day 9/10 I delved into two fascinating use cases: DataBase and Sending mails through SMTP. Usecase17-Import export data from Database.zip (162.7 KB) [The image shows a spreadsheet on "Sheet1" with columns for ID, Name, Age, Address, and Salary, listing details for four individuals. (Captioned by AI)] [The image is of a spreadsheet with columns for ID, Name, Age, Address, and Salary, containing data…

Top 3 Most Liked Solutions

This solution provided by @dokumentor received 1 likes!

Worth it to learn Python?

Interesting question @Terry_Marr I can give you my perspective as UiPath developer, recently certified as Specialized AI Professional but also Python Developer. Python is a potent language and has provided me with the friendliest coding experience I ever had (leaving visual Low-Code environments apart). It has been my choice for simple to medium complexity background automation (mostly because of costs). In recent years I’ve also had the opportunity to learn and develop API applications using i…

This solution provided by @Pampamparampam received 1 likes!

When RUN FILE, like an application that is just installed for the first time

this problem had solved sir… thank for your support solved with using Additional Desired Capabilites adding noReset and set to True

This solution provided by @Ajith3 received 1 likes!

Read Row: Could not read the row starting with cell A3

Hi @ashokkarale , The robot will had 2 new columns in input file while processing and save the status accordingly. For testing purpose, i took input file which bot has already added two columns, in this scenario i got the error. After deleting the 2 columns in input file, it worked well.

---

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.