Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - AI Builder
Unanswered

Custom prompt no longer finding rows in Dataverse

(1) ShareShare
ReportReport
Posted on by 77
I had a prompt that could return details from a Dataverse table that was working extremely well until recently. The prompt essentially searches a table for a user id then returns details about them.. Or it used to.
 
Unfortunately not any more. I'm fairly confident the reason is that its only looking at a small subset of rows in the table now (even though there's only a few hundred rows in total) - Setting a hard coded value in the filter attribute also proves this, but that isn't an option as part of the goodness of the prompt was extracting the user ID from the input text.
 
Its almost like I need to chain 2 AI Builder prompts together (The first to get the user id) but that seems a waste, especially being it previously worked. I'm hoping someone may have better ideas? In case it helps here's the prompt I'm using:

Given the conversation text, identify the three-character  User ID (e.g., REDACTED). Search for this User ID in the <users> Dataverse  table . Once found, respond to the user's question, ensuring you repeat the  user ID they asked about the state the journal poster's <full name>  and <email>. Ensure the full name is in **bold** and format the email as a clickable link. If you couldn't find the journal poster, thats fine, just let them know.

If you successfully found the journal poster respond in a friendly tone. If you couldn't find the journal poster, stick with a polite and professional tone and ask them to double check they entered the Sun user ID correctly.

-----

Here is the conversation text:

Categories:
  • SPCloudguy Profile Picture
    77 on at
    Custom prompt no longer finding rows in Dataverse
    Now that AI builder prompts have the "Record retrival" option, everythings working again - My table had 300 rows, so I could set the record retrieval amount to that.
  • CE-18121711-0 Profile Picture
    3 on at
    Custom prompt no longer finding rows in Dataverse
    Same issue for me, Gives me really bad responses even thought the data is in the table. Should be an easy find. 

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1