:Raising_hand_woman: 🙋‍♂️ Unlock the Future: #9 Challenge from the 20 Use Cases Challenge Learning Sprint

:rocket: Dear Community enthusiasts, are you up to Unlock the Future further?

Virtual series day 9 happened today : See Unlock the Future: Join the 20 Use Cases Challenge Learning Sprint - Day 8 at UiPath Visakhapatnam and now it’s time to put your skills to the test.

Are you ready for #8 Challenge from the 20 Use Cases Challenge Learning Sprint , crafted together with @pradeep_ch @pathrudu and with the help of @loredana_ifrim & @Ana_Bulhac ? Let’s level up your UiPath skills! :rocket:

:point_down: Here is the Challenge #9 we have in store for you :confetti_ball::

  • USE CASE 17

Importing & exporting data from Database : Usage of Database Activities

Objective:

Create a workflow that interacts with a database to manage a list of products.

The workflow should perform the following actions using database activities
(e.g., Execute Query, Insert, Update, Delete, Bulk Insert) while storing all values in a single variable (e.g., a Data Table )minate data entry errors, and improve overall efficiency in the data submission process.

  • USE CASE 18

Sending Tabular data in emails

Usage of Smtp Protocols to send email with below format with offer letter attached from use case of Day-03
Sample Input :-
Dear {{Firstname}} {{LastName}},
Greetings of the Day!!
I hope this message finds you well. We are thrilled to formally offer you the position of {{Role}} at {{Company}}.After careful consideration of your experience and skills, we believe you will be an invaluable addition to our team.
Please find the attached offer letter, which outlines the terms and conditions of your employment, including your compensation, benefits, and the start date. We encourage you to review the document thoroughly.
Here are some key details:

Start Date: {{offerdate}}
We kindly request you to sign and return the offer letter by {{Deadlinedate}} to confirm your acceptance of this offer. If you have any questions or need further clarification, feel free to reach out to us at
We are looking forward to welcoming you to our team and embarking on this exciting journey together.
Best Regards
HyperAutomation-ai

:date: Event Date: Today onwards!

:timer_clock: Deadline : Quiz submissions must be submitted no later than the 2024-09-27T20:59:00Z, your time-zone!

Scoring System

  • All submissions earn one star :star2: for participation, regardless of correctness.
  • Correct solutions/Quiz answers receive 5 stars :star2:.
  • The most creative/best practice solution earns an additional maximum 5 stars :star2:.

Feel free to dive into our Beginners Learning Challenge #1 above :point_up_2: and begin sharing your creative submissions.

Thank you and good luck,

UiPath Community

3 Likes

Hi Community

Thanks @AutomationX_by_Kiran @pathrudu @pradeep_ch @loredana_ifrim @Hyperautomation-ai for the insights session

Use Case - 17 Solution
ExtractAccountNumberFromText.xaml (7.3 KB)

Use Case - 18 Solution
ShoppingTaxCalculation.xaml (39.2 KB)

5 Likes

:rocket: Unlock the Future: 20 Use Cases Challenge Learning Sprint :rocket:

Day 9/10 :white_check_mark:

Completed two exciting use cases: Database Command and Send SMTP using HTML Content.

I’m truly grateful to the incredible MVP experts for providing this chance to expand my skills and knowledge.:rocket:

Excited for continued growth and collaboration ahead!

uipath rpa automation database send-smtp #Day9

Thank you @AutomationX_by_Kiran @pathrudu @loredana_ifrimspace_invader @deepak.rai6 @pradeep_ch :dizzy:

Import export data from Database_Usecase17.zip (14.1 KB)

OfferLetterAttachment_Usecase18.zip (96.0 KB)

Test Email :

4 Likes

:rocket: Unlock the Future: 20 Use Cases Challenge Learning Sprint :rocket:

Day 9/10 :white_check_mark:

I delved into two fascinating use cases: DataBase and Sending mails through SMTP.
Usecase17-Import export data from Database.zip (162.7 KB)
The image shows a spreadsheet on "Sheet1" with columns for ID, Name, Age, Address, and Salary, listing details for four individuals. (Captioned by AI)


Usecase18-SendTableinMailUsingSMTP.zip (62.3 KB)

I’m immensely thankful to the outstanding MVP experts for offering me this invaluable opportunity to expand my skills and knowledge :rocket:
Eagerly anticipating more growth and collaboration ahead!
UiPath rpa automation #SemanticActivities #TableExtraction #LearningSprint #Day3
Thank you @AutomationX_by_Kiran @pathrudu @loredana_ifrim @pradeep_ch

5 Likes

:rocket: Unlock the Future: 20 Use Cases Challenge Learning Sprint :rocket:

Day 9/10 :white_check_mark:

UseCase-17Importing & exporting data from Database
JitendraSaroj_Usecase 17_Import&export Database.zip (14.1 KB)

UseCase-18Sending Tabular data in emails
JitendraSaroj_Usecase 18_Sending Tabular data in emails.zip (13.2 KB)

Excited for continued growth and collaboration ahead!

uipath rpa automation database send-smtp #Day9

Thank you @AutomationX_by_Kiran @pathrudu @loredana_ifrimspace_invader @Ana_Bulhac @deepak.rai6 @pradeep_ch :dizzy:

4 Likes

:rocket: Unlocking the Future: 20 Use Cases Challenge Learning Sprint :rocket:

:sparkles: Successfully completed Day 9 of our hands-on learning sprint! :fire:

:white_check_mark: I tackled two exciting use cases—pushing the boundaries of automation!

This immersive session, led by UiPath MVP experts, provided invaluable, hands-on training that’s already taking our skills to the next level. :bulb:

Excited for the next challenge in this incredible journey! Let’s continue to grow and sharpen our automation expertise! :muscle:

UseCase17_Importing Exporting Data from Database.zip (179.9 KB)
UseCase18_Sending Tabular data in Email with Offer Letter.zip (717.2 KB)

Thank you @AutomationX_by_Kiran @pathrudu @loredana_ifrim @pradeep_ch @deepak.rai6

3 Likes

:tada: Completed Two Exciting Challenges on Day 9 of the 20 Use Cases Challenge! :tada:

  1. Database Operations: Explored importing and exporting data using Insert, Update, Run Query, and Run Command activities in UiPath.
  2. Sending Tabular Data via Email Automated the process of sending formatted tabular data in emails using the Create HTML Content activity.
    Each challenge pushed my limits and expanded my automation skills! :rocket:

Thank You @AutomationX_by_Kiran @pradeep_ch @loredana_ifrim @pathrudu

Database_useCase17.zip (175.8 KB)
Sending Tabular data in emails_UseCase18.zip (558.4 KB)

4 Likes

Hi All,

Successfully Completed the Day-9 Uses_Cases :white_check_mark:
Use_Case-17:
Import_Export data from_Database.zip (54.0 KB)

Use_Case-18:
SendingTabular_data_in_emails.zip (862.4 KB)

@Hyperautomation-ai , @AutomationX_by_Kiran @pathrudu @loredana_ifrim @pradeep_ch

Thanks,
:smiley:

4 Likes

:rocket: Unlock the Future: 20 Use Cases Challenge Learning Sprint :rocket:

Day 9/10 :white_check_mark:

:memo: Solve two exciting use cases: Database Operations and Sending Email via SMTP.

A huge shoutout to the UiPath MVP experts for their exceptional guidance.
@pathrudu @pradeep_ch @AutomationX_by_Kiran @loredana_ifrim

UseCase17_ImportExportDataBase.zip (165.9 KB)

UseCase18_SendTabularDataEmail.zip (417.5 KB)

2 Likes

:rocket: Unlocking the Future: 20 Use Cases Challenge Learning Sprint :rocket:

Day 9 of 10: Hands-on Learning Sprint Complete! :slightly_smiling_face:

Successfully attempted USE CASE 18: SendTabularDataEmail

Thank you @Hyperautomation-ai @pradeep_ch @AutomationX_by_Kiran , @pathrudu , @deepak.rai6 and @loredana_ifrimspace_invader for this opportunity.

UseCase18 SendTabularDataEmail.zip (204.8 KB)

2 Likes

:rocket: Unlock the Future: 20 Use Cases Challenge Learning Sprint :rocket:

Day 9/10 :white_check_mark: Another enriching hands-on session complete!

:bar_chart: Today, I worked through two use cases that focused on Database Activities and Emails, adding new dimensions to my automation toolkit.

:raised_hands: Huge shoutout to the UiPath MVP experts for their continued guidance and practical approach. It’s been a rewarding journey so far!

Can’t wait for the final session! :muscle:

uipath rpa #DatabaseAutomation emailautomation #LearningSprint #Day9

@AutomationX_by_Kiran @pathrudu @pradeep_ch @Hyperautomation-ai
Database.zip (167.6 KB)
Emails.zip (38.6 KB)

1 Like