Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 95Ih29mbcNk6vlPmDcjIXb
Power Automate - AI Builder
Unanswered

How to store what you extracted with your AI model

Like (0) ShareShare
ReportReport
Posted on 21 Jul 2022 17:50:02 by 10

So I trained a model to read some pdf job reports.  There are 5-6 fields and 4 tables with headers that vary in size but always have the same category of information.  Now that I have that complete what I am confused about is how is this information stored after it extracts the information?

 

Do I have to write it to a file, list or database in the flow to capture it?  Is there a connection that allows JSON formating?

Categories:
  • JoeF-MSFT Profile Picture
    on 28 Jul 2022 at 22:41:00
    Re: How to store what you extracted with your AI model

    Hi @Jon75, you can indeed customize the flow template, or create a new brand-new flow, where you use the Extract information from forms action to extract the data from a document using the AI Builder model you trained, and then add the Add a new row action from the Dataverse connector to save the extracted data in a Dataverse table. 


    Here is an example:

    JoeFMSFT_0-1659047955892.png

     

  • Jon75 Profile Picture
    10 on 28 Jul 2022 at 12:00:25
    Re: How to store what you extracted with your AI model

    I do get that page.  Ok so I went through and created a flow from an example.  The problem is all the examples just email me what was extracted.  I don't see any examples using dataverse unless i create an app instead of a flow.  Do I have to create an app just to have a flow input data into the database?

     

    I see add row as an option for dataverse.  My model extracts 5 fields and 3 tables of data.  Do you have to iterate through each table and add each tagged item individually?  Is there a way to map a model to a table so it can just be added once its extracted?

  • JoeF-MSFT Profile Picture
    on 27 Jul 2022 at 21:45:54
    Re: How to store what you extracted with your AI model

    Hi @Jon75 . Thanks for sharing this.

     

    If you try to select the AI Builder on the left navigation menu, you don't see a page like the one from the screenshot below? Do you get a warning or error message instead? 

     

    JoeFMSFT_0-1658958209118.png

     

  • Jon75 Profile Picture
    10 on 27 Jul 2022 at 11:54:27
    Re: How to store what you extracted with your AI model

    Thank you for the information. I am using the community plan environment and it says "This feature is disable in developer environment". Is there no where to use AI Trial to test it out without paying for it?

  • JoeF-MSFT Profile Picture
    on 26 Jul 2022 at 21:07:03
    Re: How to store what you extracted with your AI model

    Hi @Jon75 - thanks for your patience waiting for an answer.

     

    Congratulations for training your very own custom AI model! 🙂 One you have trained it, you need to:

     

    1. Publish it. This will make the model available for you to use in a flow in Power Automate or app in Power Apps.

     

    JoeFMSFT_0-1658869493485.png

     

    2. Then select Use model.

     

    JoeFMSFT_1-1658869503631.png

     

    3. Select Build intelligent automations --> and then pick one of the out of the box templates. When choosing a template, you will see how you can use your AI model in an end-to-end automation. Once you see how it works, you can then customize the Power Automate flow to store the extracted data in the destination of your choice. 

     

    JoeFMSFT_2-1658869517930.png

     

    I hope this helps! Let us know if something is not clear as you build your automation with your AI Builder model.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,670 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,013 Most Valuable Professional

Leaderboard
Loading started