cancel
Showing results for 
Search instead for 
Did you mean: 

Join the discussion

Most Recent
VJR
Multi Super User
Multi Super User

Since there is no direct tutorial that fully goes through each topic of the certification you would have to follow an approach of taking the scope topics and learning each topic and below guide would assist.

 

Here is a document regarding the same that contains:
➡ A direction on how to approach for the preparation
➡ Scope and Topics asked in the exam
➡ Tips and pointers
➡ What type of questions are asked
➡ Reference links to important pages

 

 

VJR
Multi Super User
Multi Super User

𝗨𝘀𝗲 𝗖𝗮𝘀𝗲 𝟱: 𝗣𝗼𝘄𝗲𝗿 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗲 𝗗𝗲𝘀𝗸𝘁𝗼𝗽 + 𝗚𝗣𝗧

𝗧𝗶𝘁𝗹𝗲: Auto-reply based on type of incoming request

 

🔹Use it with the "Create text with GPT" action of Power Automate Desktop

Or

🔹Call GPT OpenAI API from Power Automate Desktop

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Integrating-ChatGPT-with-Power-Automate-...

 

 


🔷 GPT prompt suffix to be added by RPA to the original text is:
[𝘞𝘳𝘪𝘵𝘦 𝘢𝘯 𝘢𝘶𝘵𝘰-𝘳𝘦𝘱𝘭𝘺 𝘧𝘰𝘳 𝘵𝘩𝘦 𝘢𝘣𝘰𝘷𝘦 𝘵𝘦𝘹𝘵]

🔷 Human can validate the auto-reply suggested by ChatGPT, make necessary modifications like add URLs, attach Receipts, catalogues, ticket number, etc. and reply back to the sender.

🔷 Customise the ChatGPT AI model for specific replies and keywords as per your business

🔷 Use it for an incoming email or wherever relevant during RPA automation.


Screenshots of Live outputs after calling the API from Power Automate Desktop.

 

 

VJR_0-1702549361682.png

 

VJR_1-1702549385327.png

 

VJR_2-1702549408278.png

 

 

 

VJR
Multi Super User
Multi Super User

𝗨𝘀𝗲 𝗖𝗮𝘀𝗲 𝟰: 𝗣𝗼𝘄𝗲𝗿 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗲 𝗗𝗲𝘀𝗸𝘁𝗼𝗽 + 𝗚𝗣𝗧

𝗧𝗶𝘁𝗹𝗲: Language Translation services using GPT

 

🔹Use it with the "Create text with GPT" action of Power Automate Desktop

Or

🔹Call GPT OpenAI API from Power Automate Desktop

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Integrating-ChatGPT-with-Power-Automate-...

 

 

 

RPA and ChatGPT can work together using language translation in various ways, such as:

1️⃣ 𝗗𝗮𝘁𝗮 𝗰𝗼𝗹𝗹𝗲𝗰𝘁𝗶𝗼𝗻 𝗮𝗻𝗱 𝗮𝗻𝗮𝗹𝘆𝘀𝗶𝘀: RPA can collect data from various sources, such as websites, emails, desktop applications, PDFs, databases, in multiple languages, and ChatGPT can process and analyze the data to provide insights and recommendations.

2️⃣ 𝗟𝗮𝗻𝗴𝘂𝗮𝗴𝗲 𝗜𝗱𝗲𝗻𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 & 𝗧𝗿𝗮𝗻𝘀𝗹𝗮𝘁𝗶𝗼𝗻: RPA can identify the language of text data and ChatGPT can translate the text into a common language for communication and collaboration.

3️⃣ 𝗧𝗿𝗮𝗻𝘀𝗹𝗮𝘁𝗶𝗼𝗻 𝗶𝗺𝗽𝗿𝗼𝘃𝗲𝗺𝗲𝗻𝘁𝘀: RPA and ChatGPT can provide feedback and suggestions for improving the quality and accuracy of the translation.

4️⃣ 𝗟𝗮𝗻𝗴𝘂𝗮𝗴𝗲 𝗹𝗼𝗰𝗮𝗹𝗶𝘇𝗮𝘁𝗶𝗼𝗻: RPA can help localize content, such as websites, marketing materials, by translating the content into multiple languages, and ChatGPT can provide recommendations for adapting the content to the local culture and context.

5️⃣ 𝗟𝗮𝗻𝗴𝘂𝗮𝗴𝗲 𝘁𝗿𝗮𝗶𝗻𝗶𝗻𝗴: ChatGPT can help train language models and RPA can automate the process of data collection and preparation to improve the efficiency and effectiveness of the training.

...and more.

Overall, RPA and ChatGPT can complement each other in various aspects of 𝗹𝗮𝗻𝗴𝘂𝗮𝗴𝗲 𝘁𝗿𝗮𝗻𝘀𝗹𝗮𝘁𝗶𝗼𝗻 and across 𝘃𝗮𝗿𝗶𝗼𝘂𝘀 𝗱𝗼𝗺𝗮𝗶𝗻𝘀.

🔷 Below screenshots are ChatGPT’s response via API call from Power Automate Desktop.

Just like the other use cases I have shared earlier, a 𝗸𝗲𝘆 𝘁𝗶𝗽 here is to suffix the below text to the original text while calling the API

[“Please translate the above to <Name_Of_Supported_Language>”]

Refer highlighted in screenshots.

🔷 Can be used to translate from any of the 109 supported languages to any other

 

 

VJR_0-1702549101586.png

 

VJR_1-1702549122180.png

 

 

 

 

VJR
Multi Super User
Multi Super User

𝗨𝘀𝗲 𝗖𝗮𝘀𝗲 𝟮: 𝗣𝗼𝘄𝗲𝗿 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗲 𝗗𝗲𝘀𝗸𝘁𝗼𝗽 + 𝗚𝗣𝗧

𝗧𝗶𝘁𝗹𝗲: Extract key value pairs from unstructured data

 

🔹Use it with the "Create text with GPT" action of Power Automate Desktop

Or

🔹Call GPT OpenAI API from Power Automate Desktop

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Integrating-ChatGPT-with-Power-Automate-...

 

 

𝙒𝙤𝙧𝙠𝙛𝙡𝙤𝙬 𝙤𝙛 𝙍𝙋𝘼 𝙗𝙤𝙩:

𝗘𝘅𝗮𝗺𝗽𝗹𝗲 𝟭: 𝗜𝗧 𝗦𝘂𝗽𝗽𝗼𝗿𝘁

𝟭. 𝗥𝗣𝗔 𝗯𝗼𝘁: Power Automate Desktop (PAD) reads the above sources using API or via UI interaction or OCR.

𝟮. 𝗦𝗼𝘂𝗿𝗰𝗲 𝗰𝗼𝗻𝘁𝗮𝗶𝗻𝘀 𝗯𝗲𝗹𝗼𝘄 𝘁𝗲𝘅𝘁:
𝘋𝘦𝘢𝘳 𝘚𝘶𝘱𝘱𝘰𝘳𝘵,
𝘐 𝘢𝘮 𝘩𝘢𝘷𝘪𝘯𝘨 𝘢𝘯 𝘪𝘴𝘴𝘶𝘦 𝘸𝘪𝘵𝘩 𝘮𝘺 𝘤𝘰𝘮𝘱𝘶𝘵𝘦𝘳. 𝘛𝘩𝘦 𝘴𝘤𝘳𝘦𝘦𝘯 𝘬𝘦𝘦𝘱𝘴 𝘧𝘳𝘦𝘦𝘻𝘪𝘯𝘨 𝘢𝘯𝘥 𝘐 𝘤𝘢𝘯'𝘵 𝘴𝘦𝘦𝘮 𝘵𝘰 𝘧𝘪𝘯𝘥 𝘢 𝘴𝘰𝘭𝘶𝘵𝘪𝘰𝘯. 𝘐 𝘩𝘢𝘷𝘦 𝘵𝘳𝘪𝘦𝘥 𝘳𝘦𝘴𝘵𝘢𝘳𝘵𝘪𝘯𝘨 𝘵𝘩𝘦 𝘤𝘰𝘮𝘱𝘶𝘵𝘦𝘳 𝘴𝘦𝘷𝘦𝘳𝘢𝘭 𝘵𝘪𝘮𝘦𝘴 𝘣𝘶𝘵 𝘵𝘩𝘦 𝘱𝘳𝘰𝘣𝘭𝘦𝘮 𝘱𝘦𝘳𝘴𝘪𝘴𝘵𝘴. 𝘔𝘺 𝘤𝘰𝘮𝘱𝘶𝘵𝘦𝘳 𝘮𝘰𝘥𝘦𝘭 𝘪𝘴 𝘋𝘦𝘭𝘭 𝘐𝘯𝘴𝘱𝘪𝘳𝘰𝘯 15 𝘢𝘯𝘥 𝘵𝘩𝘦 𝘰𝘱𝘦𝘳𝘢𝘵𝘪𝘯𝘨 𝘴𝘺𝘴𝘵𝘦𝘮 𝘪𝘴 𝘞𝘪𝘯𝘥𝘰𝘸𝘴 10. 𝘗𝘭𝘦𝘢𝘴𝘦 𝘩𝘦𝘭𝘱 𝘮𝘦 𝘳𝘦𝘴𝘰𝘭𝘷𝘦 𝘵𝘩𝘪𝘴 𝘪𝘴𝘴𝘶𝘦 𝘢𝘴 𝘴𝘰𝘰𝘯 𝘢𝘴 𝘱𝘰𝘴𝘴𝘪𝘣𝘭𝘦.
𝘛𝘩𝘢𝘯𝘬 𝘺𝘰𝘶.
𝘝𝘪𝘫𝘢𝘺

𝟯. 𝗥𝗣𝗔 𝗯𝗼𝘁:
Sends the above text to ChatGPT suffixed as:
[Can you extract the key value pairs of the above text in Json format]

𝟰. 𝗥𝗲𝘀𝗽𝗼𝗻𝘀𝗲 𝗳𝗿𝗼𝗺 𝗖𝗵𝗮𝘁𝗚𝗣𝗧:
The corresponding key value pair of the above text in JSON.

𝟱. 𝗥𝗣𝗔 𝗯𝗼𝘁:
🔹"Convert JSON to Custom Object" - This is an action in Power Automate Desktop.
🔹RPA bot creates a ticket based on the key value pairs using API or UI interaction.

𝟲. 𝗙𝗶𝗻𝗮𝗹 𝗢𝘂𝘁𝗽𝘂𝘁 𝗮𝘀 𝗸𝗲𝘆 𝘃𝗮𝗹𝘂𝗲 𝗽𝗮𝗶𝗿𝘀:

VJR_0-1702548766962.png

 




𝗘𝘅𝗮𝗺𝗽𝗹𝗲 𝟮: 𝗥𝗲𝗰𝗲𝗶𝗽𝘁 𝗽𝗿𝗼𝗰𝗲𝘀𝘀𝗶𝗻𝗴
𝗜𝗻𝗽𝘂𝘁 𝘀𝗲𝗻𝘁 𝗯𝘆 𝗥𝗣𝗔:
"ABC Supermarket
1234 Main Street
Anytown, USA 12345

Date: 01/20/2023
Time: 11:45 AM
Receipt No.: 123456789

Item Quantity Price
Product A 1 $10.00
Product B 2 $5.00 each
Product C 3 $3.00 each

Subtotal: $32.00
Tax: $2.56
Total: $34.56

Payment Method: Visa
Card Number: **** **** **** 1234
Authorization Code: 123456

Thank you for shopping at ABC Supermarket!

Visit us again soon."
[Can you extract the key value pairs of the above text in Json format]

𝗙𝗶𝗻𝗮𝗹 𝗢𝘂𝘁𝗽𝘂𝘁 𝗮𝘀 𝗸𝗲𝘆 𝘃𝗮𝗹𝘂𝗲 𝗽𝗮𝗶𝗿𝘀:

VJR_1-1702548804196.png

 



𝗘𝘅𝗮𝗺𝗽𝗹𝗲 𝟯: 𝗦𝗮𝗹𝗲𝘀/𝗢𝗿𝗱𝗲𝗿 𝗣𝗿𝗼𝗰𝗲𝘀𝘀𝗶𝗻𝗴
𝗜𝗻𝗽𝘂𝘁 𝘀𝗲𝗻𝘁 𝗯𝘆 𝗥𝗣𝗔:
𝘋𝘦𝘢𝘳 𝘚𝘢𝘭𝘦𝘴,
𝘐 𝘸𝘰𝘶𝘭𝘥 𝘭𝘪𝘬𝘦 𝘵𝘰 𝘱𝘭𝘢𝘤𝘦 𝘢𝘯 𝘰𝘳𝘥𝘦𝘳 𝘧𝘰𝘳 𝘵𝘩𝘦 𝘧𝘰𝘭𝘭𝘰𝘸𝘪𝘯𝘨 𝘪𝘵𝘦𝘮𝘴: 10 𝘶𝘯𝘪𝘵𝘴 𝘰𝘧 𝘗𝘳𝘰𝘥𝘶𝘤𝘵 𝘈 (𝘚𝘒𝘜: 𝘈123) 5 𝘶𝘯𝘪𝘵𝘴 𝘰𝘧 𝘗𝘳𝘰𝘥𝘶𝘤𝘵 𝘉 (𝘚𝘒𝘜: 𝘉456) 20 𝘶𝘯𝘪𝘵𝘴 𝘰𝘧 𝘗𝘳𝘰𝘥𝘶𝘤𝘵 𝘊 (𝘚𝘒𝘜: 𝘊789) 𝘗𝘭𝘦𝘢𝘴𝘦 𝘭𝘦𝘵 𝘮𝘦 𝘬𝘯𝘰𝘸 𝘵𝘩𝘦 𝘵𝘰𝘵𝘢𝘭 𝘤𝘰𝘴𝘵 𝘰𝘧 𝘵𝘩𝘦 𝘰𝘳𝘥𝘦𝘳 𝘢𝘯𝘥 𝘵𝘩𝘦 𝘦𝘴𝘵𝘪𝘮𝘢𝘵𝘦𝘥 𝘥𝘦𝘭𝘪𝘷𝘦𝘳𝘺 𝘵𝘪𝘮𝘦.
𝘝𝘪𝘫𝘢𝘺
[Can you extract the key value pairs of the above text in Json format]

𝗙𝗶𝗻𝗮𝗹 𝗢𝘂𝘁𝗽𝘂𝘁:

VJR_2-1702548830240.png

 

 

 

 

VJR
Multi Super User
Multi Super User

𝗨𝘀𝗲 𝗖𝗮𝘀𝗲 𝟯: 𝗣𝗼𝘄𝗲𝗿 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗲 𝗗𝗲𝘀𝗸𝘁𝗼𝗽 + 𝗚𝗣𝗧

𝗧𝗶𝘁𝗹𝗲: Find out the category / department name / routing area of service and expedite input queries.

 

🔹Use it with the "Create text with GPT" action of Power Automate Desktop

Or

🔹Call GPT OpenAI API from Power Automate Desktop

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Integrating-ChatGPT-with-Power-Automate-...



𝗦𝗼𝘂𝗿𝗰𝗲: Incoming email body / Ticket description / Any field on any application that is readable by RPA

𝙒𝙤𝙧𝙠𝙛𝙡𝙤𝙬 𝙤𝙛 𝙍𝙋𝘼 𝙗𝙤𝙩:

𝗘𝘅𝗮𝗺𝗽𝗹𝗲:

𝟭. 𝗥𝗣𝗔 𝗯𝗼𝘁: Power Automate Desktop (PAD) reads the above sources using API or via UI interaction

𝟮. 𝗦𝗼𝘂𝗿𝗰𝗲 𝗰𝗼𝗻𝘁𝗮𝗶𝗻𝘀 𝗯𝗲𝗹𝗼𝘄 𝘁𝗲𝘅𝘁:
"𝘏𝘦𝘭𝘭𝘰, 𝘐 𝘩𝘢𝘷𝘦 𝘳𝘦𝘤𝘦𝘯𝘵𝘭𝘺 𝘳𝘦𝘤𝘦𝘪𝘷𝘦𝘥 𝘮𝘺 𝘮𝘰𝘯𝘵𝘩𝘭𝘺 𝘪𝘯𝘷𝘰𝘪𝘤𝘦 𝘢𝘯𝘥 𝘯𝘰𝘵𝘪𝘤𝘦𝘥 𝘵𝘩𝘢𝘵 𝘵𝘩𝘦 𝘢𝘮𝘰𝘶𝘯𝘵 𝘤𝘩𝘢𝘳𝘨𝘦𝘥 𝘪𝘴 𝘪𝘯𝘤𝘰𝘳𝘳𝘦𝘤𝘵. 𝘐 𝘩𝘢𝘷𝘦 𝘤𝘩𝘦𝘤𝘬𝘦𝘥 𝘮𝘺 𝘶𝘴𝘢𝘨𝘦 𝘢𝘯𝘥 𝘪𝘵 𝘴𝘦𝘦𝘮𝘴 𝘵𝘩𝘢𝘵 𝘐 𝘩𝘢𝘷𝘦 𝘣𝘦𝘦𝘯 𝘤𝘩𝘢𝘳𝘨𝘦𝘥 𝘧𝘰𝘳 𝘴𝘦𝘳𝘷𝘪𝘤𝘦𝘴 𝘵𝘩𝘢𝘵 𝘐 𝘩𝘢𝘷𝘦 𝘯𝘰𝘵 𝘶𝘴𝘦𝘥. 𝘊𝘰𝘶𝘭𝘥 𝘺𝘰𝘶 𝘱𝘭𝘦𝘢𝘴𝘦 𝘵𝘢𝘬𝘦 𝘢 𝘭𝘰𝘰𝘬 𝘢𝘵 𝘮𝘺 𝘢𝘤𝘤𝘰𝘶𝘯𝘵 𝘢𝘯𝘥 𝘳𝘦𝘴𝘰𝘭𝘷𝘦 𝘵𝘩𝘪𝘴 𝘪𝘴𝘴𝘶𝘦? 𝘐 𝘸𝘰𝘶𝘭𝘥 𝘢𝘭𝘴𝘰 𝘭𝘪𝘬𝘦 𝘵𝘰 𝘳𝘦𝘤𝘦𝘪𝘷𝘦 𝘢𝘯 𝘶𝘱𝘥𝘢𝘵𝘦𝘥 𝘪𝘯𝘷𝘰𝘪𝘤𝘦 𝘳𝘦𝘧𝘭𝘦𝘤𝘵𝘪𝘯𝘨 𝘵𝘩𝘦 𝘤𝘰𝘳𝘳𝘦𝘤𝘵 𝘤𝘩𝘢𝘳𝘨𝘦𝘴. 𝘛𝘩𝘢𝘯𝘬 𝘺𝘰𝘶 𝘧𝘰𝘳 𝘺𝘰𝘶𝘳 𝘢𝘴𝘴𝘪𝘴𝘵𝘢𝘯𝘤𝘦."

𝟯. 𝗥𝗣𝗔 𝗯𝗼��:
Sends the above text to ChatGPT suffixed as:
[Give the department name for the above in short]

𝟰. 𝗥𝗲𝘀𝗽𝗼𝗻𝘀𝗲 𝗳𝗿𝗼𝗺 𝗖𝗵𝗮𝘁𝗚𝗣𝗧:
Billing Department (attached screenshot)

𝟱. 𝗥𝗣𝗔 𝗕𝗼𝘁:
Can create a ticket in the ticketing system for the appropriate department
𝗼𝗿 forward the email to the email Id of the respective department
𝗼𝗿 a human can validate this and take the appropriate action
𝗼𝗿 all of the above.


𝗔 𝗸𝗲𝘆 𝗽𝗼𝗶𝗻𝘁:
It is vital to know how to send the text to ChatGPT.
In the suffix text for the above example, it is important to mention the keywords as "in short" else ChatGPT responds with a long text.
[Give the department name for the above 𝗶𝗻 𝘀𝗵𝗼𝗿𝘁]
Notice the same in the other screenshots attached.

🔹Attached are some examples that I sent to the API through Power Automate Desktop
🔹You can also mention "category name" in place of department.
[Give the department / 𝗰𝗮𝘁𝗲𝗴𝗼𝗿𝘆 𝗻𝗮𝗺𝗲 for the above in short]
One Example attached.

 

 

 

 

 

 

VJR_1-1702548059156.png

 

VJR_2-1702548080985.png

 

 

VJR_3-1702548101389.png

 

 

VJR_4-1702548129026.png

 

 

VJR_5-1702548150902.png

 

 

 

 

 

 

 

 

VJR
Multi Super User
Multi Super User

𝐔𝐬𝐞𝐂𝐚𝐬𝐞 𝟏: 𝐏𝐨𝐰𝐞𝐫 𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐞 𝐃𝐞𝐬𝐤𝐭𝐨𝐩 + 𝐆𝐏𝐓

𝗧𝗶𝘁𝗹𝗲: 𝖤𝗆𝗈𝗍𝗂𝗈𝗇 𝖺𝗇𝖽 𝖲𝖾𝗇𝗍𝗂𝗆𝖾𝗇𝗍 𝖠𝗇𝖺𝗅𝗒𝗌𝗂𝗌 𝗎𝗌𝗂𝗇𝗀 𝖦𝖯𝖳

 

VJR_1-1702547513591.png

 

 


🔹Use it with the "Create text with GPT" action of Power Automate Desktop

Or

🔹Call GPT OpenAI API from Power Automate Desktop

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Integrating-ChatGPT-with-Power-Automate-...

 


𝗪𝗼𝗿𝗸𝗳𝗹𝗼𝘄 𝗼𝗳 𝗥𝗣𝗔 𝗯𝗼𝘁: Example 1

𝟭. 𝗦𝗼𝘂𝗿𝗰𝗲: Incoming email body / Ticket description / Any field on any application readable by RPA

𝟮. 𝗥𝗣𝗔 𝗯𝗼𝘁: Power Automate Desktop (PAD) reads the above sources using API or via screen scraping.

𝟯. 𝗠𝗲𝗻𝘁𝗶𝗼𝗻𝗲𝗱 𝗯𝘆 𝗮 𝗵𝘂𝗺𝗮𝗻 𝗶𝗻 𝗮𝗻𝘆 𝗼𝗳 𝘁𝗵𝗲 𝗮𝗯𝗼𝘃𝗲 𝘀𝗼𝘂𝗿𝗰𝗲𝘀:
"𝘛𝘩𝘦 𝘱𝘳𝘰𝘥𝘶𝘤𝘵 𝘐 𝘳𝘦𝘤𝘦𝘪𝘷𝘦𝘥 𝘸𝘢𝘴 𝘥𝘦𝘧𝘦𝘤𝘵𝘪𝘷𝘦 𝘢𝘯𝘥 𝘵𝘩𝘦 𝘤𝘶𝘴𝘵𝘰𝘮𝘦𝘳 𝘴𝘦𝘳𝘷𝘪𝘤𝘦 𝘵𝘦𝘢𝘮 𝘸𝘢𝘴 𝘶𝘯𝘳𝘦𝘴𝘱𝘰𝘯𝘴𝘪𝘷𝘦 𝘢𝘯𝘥 𝘶𝘯𝘩𝘦𝘭𝘱𝘧𝘶𝘭 𝘸𝘩𝘦𝘯 𝘐 𝘳𝘦𝘢𝘤𝘩𝘦𝘥 𝘰𝘶𝘵 𝘧𝘰𝘳 𝘢𝘴𝘴𝘪𝘴𝘵𝘢𝘯𝘤𝘦. 𝘐 𝘢𝘮 𝘦𝘹𝘵𝘳𝘦𝘮𝘦𝘭𝘺 𝘥𝘪𝘴𝘴𝘢𝘵𝘪𝘴𝘧𝘪𝘦𝘥 𝘸𝘪𝘵𝘩 𝘮𝘺 𝘦𝘹𝘱𝘦𝘳𝘪𝘦��𝘤𝘦 𝘢𝘯𝘥 𝘸𝘪𝘭𝘭 𝘯𝘰𝘵 𝘣𝘦 𝘱𝘶𝘳𝘤𝘩𝘢𝘴𝘪𝘯𝘨 𝘧𝘳𝘰𝘮 𝘵𝘩𝘪𝘴 𝘤𝘰𝘮𝘱𝘢𝘯𝘺 𝘢𝘨𝘢𝘪𝘯."

𝟰. 𝗥𝗣𝗔 𝗯𝗼𝘁:
Sends the above text to ChatGPT with a question suffixed as:
[Can you give me the emotion and sentiment analysis of the above text each in one word?]

𝟱. 𝗥𝗲𝘀𝗽𝗼𝗻𝘀𝗲 𝗳𝗿𝗼𝗺 𝗖𝗵𝗮𝘁𝗚𝗣𝗧:
Emotion: Frustration
Sentiment: Negative

𝗛𝘂𝗺𝗮𝗻 𝘁𝗮𝗸𝗲𝘀 𝗽𝗼𝘀𝘀𝗶𝗯𝗹𝗲 𝗙𝗼𝗹𝗹𝗼𝘄-𝘂𝗽 𝗮𝗰𝘁𝗶𝗼𝗻𝘀:
🔹Give a call to the sender
🔹Elevate the customer service
🔹‘Up’ the priority of the ticket (𝗥𝗣𝗔 can do this)
🔹Expedite the resolution of the sender’s issue (𝗥𝗣𝗔 can assist on this)


𝗞𝗲𝘆 𝘁𝗶𝗽:
When you pass this from RPA to ChatGPT, it is 𝘃𝗶𝘁𝗮𝗹 to mention as “𝘦𝘢𝘤𝘩 𝘪𝘯 𝘰𝘯𝘦 𝘸𝘰𝘳𝘥”, else it returns a long answer.
[Can you give me the emotion and sentiment analysis of the above text 𝗲𝗮𝗰𝗵 𝗶𝗻 𝗼𝗻𝗲 𝘄𝗼𝗿𝗱?]


Example 2:
𝗜𝗻𝗽𝘂𝘁 𝘀𝗲𝗻𝘁 𝗯𝘆 𝗥𝗣𝗔:
"𝘐 𝘢𝘮 𝘦𝘹𝘵𝘳𝘦𝘮𝘦𝘭𝘺 𝘴𝘢𝘵𝘪𝘴𝘧𝘪𝘦𝘥 𝘸𝘪𝘵𝘩 𝘵𝘩𝘦 𝘴𝘦𝘳𝘷𝘪𝘤𝘦 𝘐 𝘳𝘦𝘤𝘦𝘪𝘷𝘦𝘥. 𝘛𝘩𝘦 𝘤𝘶𝘴𝘵𝘰𝘮𝘦𝘳 𝘴𝘦𝘳𝘷𝘪𝘤𝘦 𝘳𝘦𝘱𝘳𝘦𝘴𝘦𝘯𝘵𝘢𝘵𝘪��𝘦 𝘸𝘢𝘴 𝘷𝘦𝘳𝘺 𝘩𝘦𝘭𝘱𝘧𝘶𝘭 𝘢𝘯𝘥 𝘳𝘦𝘴𝘰𝘭𝘷𝘦𝘥 𝘮𝘺 𝘪𝘴𝘴𝘶𝘦 𝘦𝘧𝘧𝘪𝘤𝘪𝘦𝘯𝘵𝘭𝘺. 𝘐 𝘸𝘪𝘭𝘭 𝘥𝘦𝘧𝘪𝘯𝘪𝘵𝘦𝘭𝘺 𝘣𝘦 𝘳𝘦𝘵𝘶𝘳𝘯𝘪𝘯𝘨 𝘢𝘴 𝘢 𝘤𝘶𝘴𝘵𝘰𝘮𝘦𝘳."

𝗢𝘂𝘁𝗽𝘂𝘁 𝗳𝗿𝗼𝗺 𝗖𝗵𝗮𝘁𝗚𝗣𝗧:
Emotion: Pleased
Sentiment: Positive


Example 3:
𝗜𝗻𝗽𝘂𝘁 𝘀𝗲𝗻𝘁 𝗯𝘆 𝗥𝗣𝗔:
"𝘛𝘩𝘦 𝘱𝘳𝘰𝘥𝘶𝘤𝘵 𝘮𝘦𝘵 𝘮𝘺 𝘦𝘹𝘱𝘦𝘤𝘵𝘢𝘵𝘪𝘰𝘯𝘴 𝘢𝘯𝘥 𝘵𝘩𝘦 𝘤𝘶𝘴𝘵𝘰𝘮𝘦𝘳 𝘴𝘦𝘳𝘷𝘪𝘤𝘦 𝘵𝘦𝘢𝘮 𝘸𝘢𝘴 𝘳𝘦𝘴𝘱𝘰𝘯𝘴𝘪𝘷𝘦 𝘸𝘩𝘦𝘯 𝘐 𝘳𝘦𝘢𝘤𝘩𝘦𝘥 𝘰𝘶𝘵 𝘧𝘰𝘳 𝘢𝘴𝘴𝘪𝘴𝘵𝘢𝘯𝘤𝘦. 𝘐 𝘢𝘮 𝘺𝘦𝘵 𝘵𝘰 𝘥𝘦𝘵𝘦𝘳𝘮𝘪𝘯𝘦 𝘢𝘯𝘥 𝘯𝘰𝘵 𝘺𝘦𝘵 𝘴𝘶𝘳𝘦 𝘢𝘣𝘰𝘶𝘵 𝘮𝘺 𝘦𝘹𝘱𝘦𝘳𝘪𝘦𝘯𝘤𝘦"

𝗢𝘂𝘁𝗽𝘂𝘁 𝗳𝗿𝗼𝗺 𝗖𝗵𝗮𝘁𝗚𝗣𝗧:
Emotion: Indifferent
Sentiment: Neutral


Final Words:

🔹These are just examples but the real idea is to use it in any industry where you pass a text to evaluate the emotions and sentiments behind it and take the necessary course of action.

Helpful resources

About the Author
  • Experienced Consultant with a demonstrated history of working in the information technology and services industry. Skilled in Office 365, Azure, SharePoint Online, PowerShell, Nintex, K2, SharePoint Designer workflow automation, PowerApps, Microsoft Flow, PowerShell, Active Directory, Operating Systems, Networking, and JavaScript. Strong consulting professional with a Bachelor of Engineering (B.E.) focused in Information Technology from Mumbai University.
  • I am a Microsoft Business Applications MVP and a Senior Manager at EY. I am a technology enthusiast and problem solver. I work/speak/blog/Vlog on Microsoft technology, including Office 365, Power Apps, Power Automate, SharePoint, and Teams Etc. I am helping global clients on Power Platform adoption and empowering them with Power Platform possibilities, capabilities, and easiness. I am a leader of the Houston Power Platform User Group and Power Automate community superuser. I love traveling , exploring new places, and meeting people from different cultures.
  • Read more about me and my achievements at: https://ganeshsanapblogs.wordpress.com/about MCT | SharePoint, Microsoft 365 and Power Platform Consultant | Contributor on SharePoint StackExchange, MSFT Techcommunity
  • Encodian Owner / Founder - Ex Microsoft Consulting Services - Architect / Developer - 20 years in SharePoint - PowerPlatform Fan
  • Founder of SKILLFUL SARDINE, a company focused on productivity and the Power Platform. You can find me on LinkedIn: https://linkedin.com/in/manueltgomes and twitter http://twitter.com/manueltgomes. I also write at https://www.manueltgomes.com, so if you want some Power Automate, SharePoint or Power Apps content I'm your guy 🙂
  • I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 15 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.
  • Big fan of Power Platform technologies and implemented many solutions.
  • Passionate #Programmer #SharePoint #SPFx #M365 #Power Platform| Microsoft MVP | SharePoint StackOverflow, Github, PnP contributor
  • Web site – https://kamdaryash.wordpress.com Youtube channel - https://www.youtube.com/channel/UCM149rFkLNgerSvgDVeYTZQ/
Join Blog
Interested in blogging for the community? Let us know.