Forum Engagement Daily Reports

[system]

Daily Forum Report | 10 April 2023

Top 3 Topics with Most Views

Compare one by one cell value from 2 sheet made by @anh.nguyen with 47 views.

Remove duplicates from two columns made by @Jnanesh_Ballal with 39 views.

PDF made by @vidhya_s1 with 39 views.

Top 3 Topics with Most Replies

How to make orchestrator API calls? made by @Ana_Patricia with 18 replies.

How to open CMD with administration rights? made by @Muhammad_Anas_Baloch with 14 replies.

Remove the all the text after second (-) character from a string made by @smrutismita.samal with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 64 posts!

@arjunshenoy made 30 posts!

@Harshith_Adyanthaya made 29 posts!

Top 3 Most Liked Posts

This post made by @AndyMenon received 3 likes!

UiPath Tutorial: OpenAI Integration Service Connector - Getting Started

Hello Community! Here’s a new video that takes a quick swing at the Preview version of the UiPath OpenAI Integration Service connector. I’ve also shared some of work in the downloads that’s linked in the video description below including the use of core OpenAI APIs and the tiktoken APIs using Python. The video track covers the following: 00:00 - Intro 00:17 - PROLOGUE 03:52 - Connector Setup in Integration Service 05:09 - Using the OpenAI Connector in UiPath Studio 13:06 - Reading the GPT-3…

This post made by @Saahil08 received 2 likes!

Send exception mail once 3 retry from queue has been exhausted

I was searching for this solution but could not find it on forum so I have solved it and putting the solution. So we have use the transactionitem.retyno or we can assign transactionitem.retryno to retry number variable In process workflow in catch exception block we can use if condition and put like transactionitem.retryno>=3 in case if you have put max retry as 3 in queue this will solve the problem and once condition is satisfied you can send the exception mails to client

This post made by @andrei.lazar received 2 likes!

I want my Dark/Light themes back!

Hey everyone, Background We have recently switched over to using the Cloud Orchestrator and where we previously had two separate servers, one for DEV and one for PROD, we now have on Organization and the DEV/PROD split is done at Tenant level. I used to have a system, to instantly tell what instance of Orchestrator I am on, namely, the dark/white themes. I used one for DEV, and one for PROD. Life was beautiful! Now that we switched over, we have 12(I think) col…

Top 3 Most Liked Solutions

This solution provided by @Harshith_Adyanthaya received 2 likes!

Data table columns

Hi @A_Learner , Try this. dt1.columns(0).ColumnName = dt1.columns(0).ColumnName,Replace(" “,”") where 0 is a first column index. If you want to do for all then, Pull a for each and perform the following. [image] Hope it helps.

This solution provided by @Yoichi received 2 likes!

Need help to split list of dates into array based on character length

FYI, another expression: arrDateStr = Enumerable.Range(0,strData.Length \ 16).Select(Function(i) String.Join("",strData.Skip(i*16).Take(16))).ToArray() Regards,

This solution provided by @Harshith_Adyanthaya received 2 likes!

How to read multiple excel sheets

Hi @singh_sumit , Use Get workbook sheets activity. It will return all the Sheet names in List of String. You can then use for each to loop and read each sheet. [image] Try this. Hope it helps.

---

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.