Power Automate - Extract Value from Unstructured Text with AI Builder!

[@jibbsautomations]

Need help implementing this flow? Let’s connect! www.jeremybarden.com/automation-consulting Use a custom prompt in a flow (Microsoft documentation): learn.microsoft.com/en-us/ai-builder/use-a-custom-prompt-in-flow

[@josepharthur2520]

Great video. Just what I was looking for.

[@mhjort1]

fantastic video, have been looking for this for a long time. thanks

[@goverdhanjayaram3683]

This was exactly what I needed. Thank you very much !!

[@VishalChandanshive]

This is great! Thank you

[@fragba1tt]

How would you extract more than one field using this method and then populate an excel table?

[@jibbsautomations]

Hi! This should be what you're looking for: kzbin.info/www/bejne/mXKVpYpnrdJ4oLc

[@fragba1tt]

@@jibbsautomations This worked like a charm, thank you !

[@diazjubairy1729]

i try this but the AI always adding some sentence to the desired result i try using this extract a word between 'Pricelist' and 'Has' in this [EmailSubject], don't show this [exclude word] in your response still showing the [exclude word] when i tr to extract text from email subject, but from body it works

[@jibbsautomations]

Hi, thanks for posting. Try your prompts using full sentences, and not separated by commas. It can take a lot of trial and error to get it working.

[@diazjubairy1729]

how to store the result in an excel spreadsheet in sharepoint, and every new email, it will automatically add into a new row of the spreadsheet

[@jibbsautomations]

Hi, that should be possible using an 'add a row into a table' action.

[@Jghost11]

On my Power Automate, there is no option to use an AI Builder.

[@jibbsautomations]

AI Builder is a premium connector so that might be why you don't see it. I would suggest to check with your admin. All the best!

[@OrcaT-j1y]

Is it really $500/month minimum for using 'Create text with GPT using a prompt' action? That's what it seems according to the AI Builder calculator. Shame if true, as it's really neat, just massively overpriced, considering it's based on consumption pricing.

[@jibbsautomations]

Hi thanks for posting. My understanding is the Premium plan, which is relatively inexpensive per user, gives you AI Builder credits. It might be worth looking into that, though likely there are limitations on how many credits you get. Microsoft stuff can get pretty expensive :(

[@OrcaT-j1y]

@@jibbsautomations thanks for the reply. Yes ive seen i can get 5000 credits with a Power Automate Premium licennse, so i'll check if thats enough for what i need to do.