Forum Engagement Daily Reports

[system]

Daily Forum Report | 05 October 2021

Top 3 Topics with Most Views

How can I combine two datatables without using a for each or filter? made by @Enzo with 49 views.

How to convert one data format to another data format made by @BNK with 40 views.

If column contains a specific value then made by @Nyx_Green with 35 views.

Top 3 Topics with Most Replies

How to convert one data format to another data format made by @BNK with 21 replies.

Text file dynamic creation made by @martina.cavalieri with 18 replies.

Double.parse error made by @Soudios with 16 replies.

Top 3 Users Who Posted The Most

@rahulsharma made 24 posts!

@postwick made 23 posts!

@ppr made 21 posts!

Top 3 Most Liked Posts

This post made by @rahulsharma received 3 likes!

UiPath Apps - check date is not in the past

Hey @Sriram6000 Will those VB expression work in UiPath Apps too? Have you implemented that? I think @VanjaV needs to add a small process for getting the today’s date inside the app and then compare. Validating date can be a good inbuilt and optional feature to be added in UiPath Apps, may be in upcoming version.

This post made by @Yoichi received 3 likes!

Exception occurring in middle of workflow

Hi, Although it might not be very good way, how about using Parallel activity as the following? [img20211005-2] It can be handled at any time it pops up. Isolate option of Invoke Workflow might be better to turn on. Regards,

This post made by @Yoichi received 2 likes!

Fiscal year Calculation in weeks

Hi, Can you try the following sample? [img20211006-2] Enumerable.Range(1, Cint(Math.floor((targetDate-startDateOfFY).TotalDays))).Select(Function(i) startDateOfFY.AddDays(i)).Where(Function(d) d.DayOfWeek = DayOfWeek.Sunday).Count+1 Main.xaml (6.2 KB) Regards,

Top 3 Most Liked Solutions

This solution provided by @rahulsharma received 3 likes!

UiPath Apps - check date is not in the past

Hey @Sriram6000 Will those VB expression work in UiPath Apps too? Have you implemented that? I think @VanjaV needs to add a small process for getting the today’s date inside the app and then compare. Validating date can be a good inbuilt and optional feature to be added in UiPath Apps, may be in upcoming version.

This solution provided by @Yoichi received 2 likes!

Fiscal year Calculation in weeks

Hi, Can you try the following sample? [img20211006-2] Enumerable.Range(1, Cint(Math.floor((targetDate-startDateOfFY).TotalDays))).Select(Function(i) startDateOfFY.AddDays(i)).Where(Function(d) d.DayOfWeek = DayOfWeek.Sunday).Count+1 Main.xaml (6.2 KB) Regards,

This solution provided by @StefanSchnell received 2 likes!

How to test interactions with SAP

@Airun Hello Airun, you can download a trial version of the SAP NetWeaver AS ABAP Developer Edition here. How to install it, is described here. You can run it in a VM environment. Last but not least you need the SAP GUI for Windows for your testing. On this way you can create your own test environment. Best regards Stefan

---

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.