Skip to main content

Notifications

Community site session details

Community site session details

Session Id : XZi2yvW6x/j+Sw/SOM/wch
Power Automate - AI Builder
Unanswered

Custom prompt no longer finding rows in Dataverse

Like (1) ShareShare
ReportReport
Posted on 15 Nov 2024 05:11:50 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 09 Jan 2025 at 01:06:07
    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 18 Dec 2024 at 17:12:19
    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

Understanding Microsoft Agents - Introductory Session

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

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - AI Builder

#1
VictorIvanidze Profile Picture

VictorIvanidze 4

#1
BK-01100935-0 Profile Picture

BK-01100935-0 4

#3
frontrowna Profile Picture

frontrowna 2

Overall leaderboard
Loading started