Forum Engagement Daily Reports

[system]

Daily Forum Report | 28 November 2023

Top 3 Topics with Most Views

Excelファイル(マスタ)のA列を全角→半角にしたい made by @once10201029 with 46 views.

Vlookup Save to(?) how? made by @Thanakorn_Kanjiropas with 42 views.

How to split a long string into two line item made by @roysupriya21 with 40 views.

Top 3 Topics with Most Replies

Getting action object variable (DocumentValidationActionData) using Get Task Data Activity made by @Asanka with 30 replies.

Excelファイル(マスタ)のA列を全角→半角にしたい made by @once10201029 with 20 replies.

Gmailに画像を貼り付けて送信したい made by @FSP with 16 replies.

Top 3 Users Who Posted The Most

@Yoichi made 31 posts!

@rikulsilva made 29 posts!

@ppr made 26 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

実行する曜日で条件分岐したい

以下になります。 [image] （Invoke Workflowにしていますが、そのまま処理を記述してもOKです） 以下Sequence.xaml参照ください Sample20231128-1 (2).zip (10.1 KB)

This post made by @Geoffroy_Pantegnies received 1 likes!

Assistant: no such host is known

Hello everyone, I’m getting this error message when I try to connect to Orchestrator via Assistant: [image] The licence is attached to the machine, the URL is good so I don’t understand the problem. I tried closing Studio, log off etc but still got this message. Ps: this is a non production licence. Any help is welcome ! Have a nice day,

This post made by @Gokul_Jayakumar received 1 likes!

Excel copy-paste issue help

Hello @22222222asas Could you be more Specific? Do you need to Autofit your columns? Refer to the below thread you may get some idea [#AutofitColumn How can we autofit Excel sheet column using VBA in UiPath #RPA #UiPath] If Modern Excel, try Autofit Range activity in Excel scope. [image]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

実行する曜日で条件分岐したい

こんにちは 他のアプローチとして以下のようにすると条件分岐無しで、動的に異なる処理を呼び出せます。 dict = New Dictionary(Of String,String)From{{"Sunday","A.xaml"},{"Saturday","B.xaml"},{"Tuesday","C.xaml"},{"Wednesday","C.xaml"}} としておいて dict(DateTime.Now.DayOfWeek.ToString) をワークフロー呼び出しアクティビティで呼び出します。 [20231128-3-2] [20231128-4] なお23.4までのWindowsプロジェクトではうまく動作しませんのでご注意ください。

This solution provided by @Parvathy received 1 likes!

Change the month to a different language

Hi @sullivanne Try this: yourPolishDateString = DateTime.Now.ToString( "dd-MMMMM-yyyy", New System.Globalization.CultureInfo("pl-PL")) Hope it helps!!

This solution provided by @Shiva_Nikhil received 1 likes!

LinQ Query to Update Specific column value for Specific row

@avinash_ghanwat1 use this in assign activity datatablevar.rows(0).item("Address")="India" or datatablevar.rows(0).item(1)="India"

---

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.