
Announcements
Hello, I'm looking to build a workflow using Power Automate.
#Desired Output: Automatically extract data from an attachment (Excel file) in an order email sent to me. Then, automatically populate the necessary data into a database (also an Excel file).
#Difficulty: Currently, I find it quite challenging to extract data from the Excel file because it's not formatted as a table, and the data is spread across different regions. This makes mapping very difficult. What should I do?
I've tested this in n8n, by creating a webhook (URL - POST). Then, I input the order image and the webhook URL to an AI model and had it process the data, convert it to JSON, and send the data back to my workflow via the webhook. Can I use a similar approach in Power Automate?
(Please check the image attachment as example below)
Thank you, everyone!