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

Поділитися
Вставка
  • Опубліковано 24 січ 2025

КОМЕНТАРІ • 17

  • @jibbsautomations
    @jibbsautomations  11 місяців тому +1

    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
    @josepharthur2520 10 місяців тому +2

    Great video. Just what I was looking for.

  • @mhjort1
    @mhjort1 4 місяці тому +1

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

  • @goverdhanjayaram3683
    @goverdhanjayaram3683 7 місяців тому +1

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

  • @VishalChandanshive
    @VishalChandanshive 9 місяців тому +1

    This is great! Thank you

  • @fragba1tt
    @fragba1tt 4 місяці тому +1

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

    • @jibbsautomations
      @jibbsautomations  4 місяці тому +2

      Hi! This should be what you're looking for: ua-cam.com/video/cA2tW1xmEjU/v-deo.html

    • @fragba1tt
      @fragba1tt 4 місяці тому +1

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

  • @diazjubairy1729
    @diazjubairy1729 8 місяців тому +1

    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
      @jibbsautomations  8 місяців тому +1

      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
    @diazjubairy1729 8 місяців тому +1

    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
      @jibbsautomations  8 місяців тому +1

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

  • @Jghost11
    @Jghost11 3 місяці тому +1

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

    • @jibbsautomations
      @jibbsautomations  2 місяці тому +1

      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
    @OrcaT-j1y 10 місяців тому +1

    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
      @jibbsautomations  10 місяців тому +3

      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
      @OrcaT-j1y 10 місяців тому +1

      @@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.