AI builder and power automate -- 2
$250-750 AUD
Paid on delivery
Automate processing of emails received which offer jobs. Emails come from 5-6 different sources and are laid out differently. But there are about 8 fields that are common and can be captured by ai builder. (I’ve trained only one source so far, but looking good)
My goal is to extract the necessary fields and present in consolidated excel online or into a sharepoint list. Complication I have is to build flow which extracts data from each email attachment and compares with information already in spreadsheet/list. Then logic to either update what has changed on an entry, delete an entry if needed, or add a new row/item.
Each job coming through in attachments has unique IDs specific to each source.
A few of the sources produce weekly summary tables showing jobs open, and only by a line items absence can you deduce its closure.
Other sources send emails specifically closing previously open positions.
Some sources provide pdf and others excel format. Thus, intend triggering flow from sharepoint file library after manually changing all docs to pdf and saving in library. I’m aware automate desktop RPA might help with pdf’ing so happy to hear ideas.
Thanks
Project ID: #34286160
About the project
6 freelancers are bidding on average $508 for this job
Hello, I hope you are doing well. I am interested to help you with this requirement. I have more than 9 years of working experience with Microsoft SharePoint. Well versed with all its version. I can also help you i More
Hello, I can help you in automating the process of emails by creating workflows. I am a Certified Power Platform developer having 4+ years of experience. List of certifications done MB-200 MB-400 DYNAMICS 365 FUNDAMEN More
Hello, How are you? I have read your project description carefully and I have rich experience in this type of work. Let me tell you about my expertise. I am Microsoft Expert. I have 3+ years of experience in PowerApp More
