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

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

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

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

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

  • USE CASE 5

Get ready to be blown away by the AI feature!

Exercise Title :

Use Case 5 : Simple exercise of copy paste with AI. Later see where you can use this in your day to day work.

Problem Statement

Copy paste the entire excel file with records to a web application with its relevant fields.
Human doesn’t need to tell which value for which field, AI by itself will identify the fields and map the corresponding value from excel, that too in few seconds.

Proposed Solution :

  1. Open this URL in any browser - Clipboard AI - Copy Paste Automation | UiPath

  2. Fill the form and download the Clipboard AI.msi file

  3. Install it as per the guidance document attached along in this project folder

  4. Once after installation, you can see a small floating window like this

  5. Open this URL in any browser - Rpa Challenge

  6. Open INPUT FORM tab in that web page

  7. Open the input excel file attached along in this project folder

  8. Copy the entire record like this from first cell to last cell or press CTRL + A

  9. Then in that floating window click COPY CELLS button

  10. Now go to the opened browser with RPACHALLENGE website

  11. With floating window click on PASTE TEXT. If you get any pop up with PASTE DATA button then press that button.

  12. Clipboard AI will start to paste the records from excel to relevant fields automatically

  13. As we have some n number of records, Clipboard AI will show a popup window once after pasting each row from excel in web page like this

  14. Click PASTE DATA button
    That’s it, the entire data will get pasted in few seconds
    About Clipboard AI:
    For more details - Clipboard AI - Copy Paste Automation | UiPath

For your info, this clipboard ai came into market by 2023 and was awarded the BEST INVENTION for that year by TIMES

UiPath Clipboard AI Named One of TIME’s Best Inventions of 2023 | UiPath

Steps to download Clipboard AI.docx (86.1 KB)

InputFile.xlsx (12.5 KB)

  • USE CASE 6

Generate offer letters reading excel as input and replace the keywords from the offer letter template attached in word and convert to pdf.

Input sample:

1
This image is an offer letter for a Software Engineer position at a company, detailing the candidate's start date, salary, and additional compensation benefits. (Captioned by AI)

Expected output : generate Pdf with replacing text.

Offer Letter.docx (16.8 KB)

InputFile.xlsx (12.5 KB)

:date: Event Date: Today onwards!

:timer_clock: Deadline : Quiz submissions must be submitted no later than the 2024-09-19T20: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

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

Day 3 Tackled two exciting use cases, 𝗖𝗹𝗶𝗽𝗯𝗼𝗮𝗿𝗱 𝗔𝗜 and 𝗚𝗲𝗻𝗲𝗿𝗮𝘁𝗶𝗻𝗴 𝗢𝗳𝗳𝗲𝗿 𝗟𝗲𝘁𝘁𝗲𝗿𝘀
incredible MVP experts for giving me the opportunity to learn and grow through this journey.
Looking forward to more learning and collaboration! :rocket:
Big Thanks to @AutomationX_by_Kiran @loredana_ifrim @pradeep_ch @pathrudu
Generate offer letters.zip (659.2 KB)

3 Likes

Dive into the Future: Day 3 of the 20 Use Cases Challenge Learning Sprint! :rocket:

I am thrilled to be part of this exciting Challenge on Day 3, exploring the vast ocean of automation—a huge shoutout to the incredible Team for this amazing opportunity to learn and grow.


As part of Usecase5, I took on the challenge of copying data from a resume and extracting the fields into an Excel sheet.

usecase6-generateOfferletterwithWordActivities.zip (792.6 KB)
Can’t wait for more for what’s next in store! :star2:
Big thanks to @AutomationX_by_Kiran, @loredana_ifrim, @Corina_Gheonea, @pradeep_ch, and @pathrudu! :rocket:
excel Clipboard AI wordautomation

4 Likes

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

Day 3/10 :white_check_mark:

Delved into two fascinating use cases: Clipboard AI and Offer Letter Generation.

I’m immensely thankful to the outstanding MVP experts for offering me this invaluable opportunity to expand my skills and knowledge :rocket:

OfferLetter_Usecase6.zip (693.4 KB)

Eagerly anticipating more growth and collaboration ahead!

UiPath rpa automation #SemanticActivities #TableExtraction #LearningSprint #Day3

Thank you @AutomationX_by_Kiran @pathrudu @loredana_ifrim @pradeep_ch



3 Likes

:rocket: Unlock the Future: 20 Use Cases Challenge Learning Sprint - Day 3 :rocket:

Day 3/10 :white_check_mark:

Solved two exciting use cases, taking a deep dive into the Clipboard AI tool and Offer Letter Generation by leveraging AutoPilot feature in Studio :robot::sparkles:

As part of Usecase5, tried extracting the fields from Excel sheet and Receipt

A heartfelt thank you to the organizers: @AutomationX_by_Kiran, @pathrudu, @pradeep_ch, and @loredana_ifrim :pray:

Eagerly awaiting the next session to continue learning and growing. :rocket::sparkles:

UseCase6_GenerateOfferLetters.zip (877.3 KB)




.**

3 Likes

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

:sparkles: Successfully completed Day 3 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:

UseCase6_Generate Offer Letters.zip (876.9 KB)

Thank you @AutomationX_by_Kiran @pathrudu @loredana_ifrim @pradeep_ch




3 Likes

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

Day 3/10 :white_check_mark:

Two fascinating use cases: Clipboard AI and Offer Letter Generation.

JitendraSaroj_Generate Offer Letters.zip (696.0 KB)

UiPath rpa automation #SemanticActivities #TableExtraction #LearningSprint #Day3

Thank you @AutomationX_by_Kiran @pathrudu @loredana_ifrim @pradeep_ch

3 Likes

:rocket: Unlock the Future: 20 Use Cases Challenge Learning Sprint - Day 3 :rocket:

Day 3/10 :white_check_mark:

Solved two exciting use cases, taking a deep dive into the Clipboard AI tool and Offer Letter Generation by leveraging AutoPilot feature in Studio :robot::sparkles:

**As part of Usecase5, tried extracting the India Map Image for states and capitals. Pasted the data in the Excel Sheet.



generate Offer Letters.zip (692.4 KB)

Eagerly awaiting the next session to continue learning and growing. :rocket::sparkles:

3 Likes

Hi All,

Successfully Completed the Uses Cases of Day-3 :white_check_mark:

UseCase-3:


UseCase-4:
OfferLetter_Generation.zip (866.3 KB)

@Hyperautomation-ai @AutomationX_by_Kiran, @loredana_ifrim , @Corina_Gheonea, @pradeep_ch, and @pathrudu!
excel Clipboard AI
:smiley:

3 Likes

Day 3/10 :white_check_mark: Another productive session in the books!

:clipboard: Solved two new use cases focusing on Clipboard AI and Word Activities—expanding the horizon of automation possibilities!

:bulb: The hands-on approach by the UiPath MVP experts continues to bring real-world automation skills to life. Feeling more confident with every session!

Can’t wait to dive into the next challenges! :muscle:

uipath rpa #ClipboardAI #WordActivities automation #LearningSprint #Day3
Offer Letter Generation.zip (838.1 KB)

2 Likes

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

Successfully attempted 02 use cases.

Use Case 5 : Simple exercise of copy paste with AI.

Another Sample tested with handwritten Invoice…results are amazing.


USE CASE 6:Generate Offer Letters

UseCase6 Generate Offer Letters.zip (313.4 KB)

Thank You @AutomationX_by_Kiran , @pathrudu , @pradeep_ch , @loredana_ifrimspace_invader for sharing this opportunity.

2 Likes

Solved two new use cases focusing on Clipboard AI and Word Activities—expanding the horizon of automation possibilities!

:bulb: The hands-on approach by the UiPath MVP experts continues to bring real-world automation skills to life. Feeling more confident with every session!

Big Thanks to @AutomationX_by_Kiran @loredana_ifrim @pradeep_ch @pathrudu and @loredana_ifrim for hosting such a useful event.

Generate Offer letter Use_case.zip (178.3 KB)

1 Like

Hi Community,

Thanks @loredana_ifrim @AutomationX_by_Kiran @pradeep_ch @pathrudu

Its a great session on the topic.

Use Case - 5 and Use Case - 6 Solution

OfferLetterGenerationProcess.zip (864.5 KB)