Forum Engagement Daily Reports

[system]

Daily Forum Report | 14 May 2022

Top 3 Topics with Most Views

Option to resize the component JSON window in form designer made by @jeevith with 59 views.

Get Data before special character made by @Abang_Jamuri_Abang_Shoker with 34 views.

Send Exchange Mail Message: Value cannot be null. Parameter name: fileName made by @Sathish_Kumar_S with 33 views.

Top 3 Topics with Most Replies

How to know if queue items are present using studio made by @ydash999 with 10 replies.

HELP PLEASE. Facing a problem with Column “qty” does not belong to table datatable made by @Kai_Xin_Kho with 9 replies.

Run query: ORA-00936: missing expression made by @sushantchanakhekar2299 with 8 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 16 posts!

@Rahul_Unnikrishnan made 15 posts!

@Yoichi made 7 posts!

Top 3 Most Liked Posts

This post made by @Smars received 3 likes!

How to know if queue items are present using studio

“Get Queue Item” is a suitable activity, see the following link for more information:

This post made by @jack.chan received 2 likes!

Send Exchange Mail Message: Value cannot be null. Parameter name: fileName

@Sathish_Kumar_S Main.xaml (8.8 KB) define attachmentList variable [image] [image] if not string.IsNullOrEmpty(in_Attachment) then assign attachmentList = in_Attachment.Split(","c).ToList [image] pass attachment list to send outlook mail message attachmentsCollection property [image]

This post made by @Rahul_Unnikrishnan received 2 likes!

HELP PLEASE. Facing a problem with Column “qty” does not belong to table datatable

Hello @Kai_Xin_Kho If your column name is not working you can use the column index to read the data from that particular column Like Currentrow(0).Tostring will read data from the first column. Also it would be better if you can share the screenshot of the excel which you are reading. If you are using column name, then inside the Read Range activity you have to enable “Add Headers” in the property panel. Also make sure “Qty” is a valid column name in that excel.

Top 3 Most Liked Solutions

This solution provided by @jack.chan received 2 likes!

Send Exchange Mail Message: Value cannot be null. Parameter name: fileName

@Sathish_Kumar_S Main.xaml (8.8 KB) define attachmentList variable [image] [image] if not string.IsNullOrEmpty(in_Attachment) then assign attachmentList = in_Attachment.Split(","c).ToList [image] pass attachment list to send outlook mail message attachmentsCollection property [image]

This solution provided by @Yoichi received 1 likes!

Get Data before special character

Hi, FYI, another solution [image] Sample20220514-1.zip (2.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.