I have an AI builder prompt that uses a Dataverse column for knowledge/content. For reference, the column happens to be a formula (single line of text) that creates JSON text consolidating values in other columns in the table. The prompt also returns a JSON string.
The prompt works fine and has done so for many weeks. Yesterday I created a new column that creates almost exactly the same JSON text, basically just a new version of the knowledge format. I updated the prompt to reference the new column, and testing the prompt returned the message "The query is outside the scope of the data." I am publishing the table each time. Neither Bing nor Google return any results when searching for the exact error message.
I have tried the following
- in the new column, use the exact formula from the column that works, testing the prompt still gives error
- change the prompt to use another column that was created weeks ago, but has a different formula (an older version of the JSON format), the prompt works fine
- created another-another column with different and/or same versions of the formula, still gives error
- created a brand-new prompt, using the exact same prompt text. I get all the same results as above
It appears this error is only occurring when I point the prompt to a newly created column. It coincides with the update to the AI Builder Prompt UI.
Any help would be greatly appreciated.