Forum Engagement Daily Reports

[system]

Daily Forum Report | 10 June 2021

Top 3 Topics with Most Views

Dictionary型の操作サンプル made by @Yoshi_Akiyama with 33 views.

UipathからのGASの実行方法に関して made by @1111047 with 27 views.

Move File with Unique Name made by @NAJAA_BAZILAH with 25 views.

Top 3 Topics with Most Replies

Click many times made by @Soudios with 16 replies.

Getting an error in Matches made by @Puneet_Singh1 with 14 replies.

Move File with Unique Name made by @NAJAA_BAZILAH with 12 replies.

Top 3 Users Who Posted The Most

@postwick made 28 posts!

@ppr made 20 posts!

@Yoichi made 14 posts!

Top 3 Most Liked Posts

This post made by @Yoshi_Akiyama received 4 likes!

Dictionary型の操作サンプル

API系アクティビティを使っていると、帰ってくるデータがDictionary型の場合があって、 dictionaryの中身の調べ方は少し難しいのでサンプルを作りました。 よければ使って見てください。 使って見た人の不明点に回答するために解消するためにしばらく（２営業日ぐらい？）オープンにしときます。 DictionaryEnumerationTest.zip (3.1 KB)

This post made by @NIVED_NAMBIAR received 3 likes!

Lookup using two columns

Hi @MANISHA_V_ARORA after a long testing got this code dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“c_comp_prop_cd”)= If(dt2.AsEnumerable().Where(Function(r) r(“c_rev_center_cd”).ToString.Trim.Equals(row(“c_comp_prop_cd”).ToString.Trim) And r(“c_prop_cd”).ToString.Trim.Equals(row(“c_prop_cd”).ToString.Trim)).Count<>0,dt2.AsEnumerable().Where(Function(r) r(“c_rev_center_cd”).ToString.Trim.Equals(row(“c_comp_prop_cd”).ToString.Trim) And r(“c_prop_cd”).ToString.Trim.Equals(row(“c_prop_cd”).…

This post made by @StefanSchnell received 2 likes!

How to Read SAP Tables with a Generic ABAP Approach from UiPath

A longer time ago I published here a solution how to use the remote enabled function module RFC_READ_TABLE with the Invoke Code activity in the SAP back-end. Here now a solution to the same with an ABAP report, which works directly in the context of the UiPath automation workflow. The first question that can be asked here is, why should I go into this trouble when I have a remote enabled function module available? Well, this approach offers a few advantages: The output size is 1024 character…

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 3 likes!

Lookup using two columns

Hi @MANISHA_V_ARORA after a long testing got this code dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“c_comp_prop_cd”)= If(dt2.AsEnumerable().Where(Function(r) r(“c_rev_center_cd”).ToString.Trim.Equals(row(“c_comp_prop_cd”).ToString.Trim) And r(“c_prop_cd”).ToString.Trim.Equals(row(“c_prop_cd”).ToString.Trim)).Count<>0,dt2.AsEnumerable().Where(Function(r) r(“c_rev_center_cd”).ToString.Trim.Equals(row(“c_comp_prop_cd”).ToString.Trim) And r(“c_prop_cd”).ToString.Trim.Equals(row(“c_prop_cd”).…

This solution provided by @Yoichi received 2 likes!

Calculate all invoice amounts on a particular day/ss

Hi, Can you try the following? [img20210610-5] Sample20210610-3.zip (8.6 KB) Regards,

This solution provided by @ppr received 1 likes!

Need an example to loop Get Queue items activity after reaching 100 and should check all the items in Queue

Sorry for the reduced screenshot: ListQueueItems = new List(Of QueueItem) - Init it before usage ListQueueItems = ListQueueItems.Concat(tmpQueueItems).toList (within correct spell form)

---

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.