Skip to main content

Notifications

Power Apps - AI Builder
Answered

Using AI Builder with Power Automate to loop through many records

(0) ShareShare
ReportReport
Posted on by 5

Hi,

 

I am hoping to get some guidance please,

 

I have developed a text classification model using the AI Builder from Power Apps.

 

Challenge

I need to be able to run the AI model against many records (around 1M or so) on a monthly basis

 

What is the most stable way to run the AI model against my table? It is currently stored in a dataverse table

 

Is the best method to use the database sync option available from the AI builder or is it to use Power Automate to loop through each record and apply the AI to the record?

 

Currently I have developed a Power Automate solution to loop through each record which generates AI columns for each record in an output dataverse table

 

Is there any guidance or documentation on how to use the database sync feature from Power Apps to achieve this? As I think this may be an easier option but I am not sure how to use it 

 

Thanks,

Anthony

Categories:
  • Verified answer
    CedrickB Profile Picture
    CedrickB on at
    Re: Using AI Builder with Power Automate to loop through many records

    The approach to list records in Power Automate and use below task to iterate through records is the best way

    CedrickB_0-1667911760649.png

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard