I recently purchased Microsoft Power Automate Premium to access its full automation and AI capabilities. My end goal is to create a fully automated system that allows my company to store contacts automatically in a database when an email is received. I want to create a flow that triggers when an email is received to specific user inboxes, extracts key contact details like full name, company, email address, phone number, and street address. I then want to store this information in a database without adding duplicates (easiest way seems to compare the email addresses and only add a record if the email address does not exist), and make it easily accessible to users in my Microsoft domain through the use of SharePoint or similar resource. I'm looking for the best approach and tools within Power Automate to accomplish this. I am using Power Apps Dataverse for my tables. I have created a flow that did work but it was with the GPT model, so it required approvals but I want this to be completly autonomous without any human intervention. I created a custom AI model and trained it with various email signatures to best train this model to detect the parameters that I want but I cannot seem to find a way to filter for the specific parameters and add them to their respective columns within my Dataverse table. Any recommendations or guidance would be greatly appreciated!
