Forum Engagement Daily Reports

[system]

Daily Forum Report | 07 September 2023

Top 3 Topics with Most Views

Unable to resolve Object reference error at startup made by @theEmailRobot with 52 views.

[Solved] UiPath to show timestamp in message box made by @Sathish_Ashokan with 45 views.

UiPath Action Center help needed made by @Ritaman_Baral with 43 views.

Top 3 Topics with Most Replies

Unable to resolve Object reference error at startup made by @theEmailRobot with 26 replies.

Renaming file with current date and time made by @E.T.S with 18 replies.

Can i paste value in variable? made by @Samraat_Maharjan1 with 16 replies.

Top 3 Users Who Posted The Most

@postwick made 40 posts!

@Palaniyappan made 37 posts!

@ppr made 27 posts!

Top 3 Most Liked Posts

This post made by @ppr received 1 likes!

Convert HTTP Response with nested JSON to DataTable

For some dynamics we can have a look at this longer oneliner: [grafik] And can break the idea down to smaller parts and/or decompose it to essential activities myRowJOs | List(Of JObjects) = myJObject("d")("results").Cast(of JObject).Select(Function (x) new JObject(x.Properties.Where(Function (p) Not p.Name.Equals("__metadata")))) we constructed new JObjcets where we removed the __metadata property (could be extended by a block list approach as well) then we convert it to a DataTable: d…

This post made by @Yoichi received 1 likes!

[Solved] UiPath to show timestamp in message box

HI, What format do you need? The simplest is just Now as the following. [image] Regards,

This post made by @vinitha_yachamaneni received 1 likes!

Unattended Robot doesn't work in a different location

Hi @Carla_Munoz If your Unattended Robot is not running when your laptop is outside your home location, it’s likely because the Orchestrator is unable to connect to your laptop due to network or firewall restrictions Also Ensure that your laptop has a consistent way to be reached from Orchestrator, even when it’s outside your home network. This can be done by setting up a static IP address or configuring dynamic DNS (DDNS) if your laptop’s IP address changes when you move

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Convert HTTP Response with nested JSON to DataTable

For some dynamics we can have a look at this longer oneliner: [grafik] And can break the idea down to smaller parts and/or decompose it to essential activities myRowJOs | List(Of JObjects) = myJObject("d")("results").Cast(of JObject).Select(Function (x) new JObject(x.Properties.Where(Function (p) Not p.Name.Equals("__metadata")))) we constructed new JObjcets where we removed the __metadata property (could be extended by a block list approach as well) then we convert it to a DataTable: d…

This solution provided by @Yoichi received 1 likes!

変数に1000を掛けたい

こんにちは 変数の型をそろえる必要があるかと思います。基本的には以下の様になります。 [image] 変数A(Int型)で取得した値12.000 整数型は小数点以下を扱えませんので、代入は12になるかと思います。 エラー内容：Option Strict On で ‘String’ から ‘Double’ への暗黙の型変換はできません 型があっていないと思います。変数BがString型ではないでしょうか？ その場合、(変数A*1000).ToString の様にする必要があります。

This solution provided by @Yoichi received 1 likes!

Need to extract data from textfile

HI, How about the following expression? This extract numeric characters which exists at the end of the next line of “PO NUMBER” (Because I guess it’s PO NUMBER) [image] System.Text.RegularExpressions.Regex.Match(strData,"(?<=PO NUMBER[\s\S]+?)\d+(?=\r?\n|$)").Value Sample20230907-3L.zip (14.4 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.