𝐔𝐬𝐞𝐂𝐚𝐬𝐞 2: PAD + GPT: 𝗧𝗶𝘁𝗹𝗲: Extract key value pairs from unstructured data

[VJR]

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

𝗧𝗶𝘁𝗹𝗲: 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.

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

𝗘𝘅𝗮𝗺𝗽𝗹𝗲 𝟮: 𝗥𝗲𝗰𝗲𝗶𝗽𝘁 𝗽𝗿𝗼𝗰𝗲𝘀𝘀𝗶𝗻𝗴
𝗜𝗻𝗽𝘂𝘁 𝘀𝗲𝗻𝘁 𝗯𝘆 𝗥𝗣𝗔:
"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]

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

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

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