Answered

Custon Generative Answers no response

(0) Share

Report

Posted on by Revl0ck97

I have a topic that uses a custom generative answers node from a JSON table passed from Power Automate flow but so far there is no response/output at all when running the node there is no error just blank response.

I referenced my formula for custom table from here but maybe I'm missing something:

Solved: Custom Data Source(JsonData) in Generative Answers - Power Platform Community (microsoft.com)

Custom Data:

ForAll(Topic.varEventsTable,
{
 Content: Concatenate(body,"-",start),
 ContentLocation: Blank(),
 Title: subject
}
)

The appended JSON (portion since its has many items) passed from flow:

"[{\"subject\":\"Sample subject\",\"start\":\"2024-02-19T06:00:00.0000000\",\"end\":\"2024-02-19T07:00:00.0000000\",\"startWithTimeZone\":\"2024-02-19T06:00:00+00:00\",\"endWithTimeZone\":\"2024-02-19T07:00:00+00:00\"}]"

then used a parse value node to convert it back to table to be used in custom data.

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (1)

ManikandanS 246 on at

Like (0)

Report

Hello @Revl0ck97 ,

Please check your variable varEventsTable has value before you apply to ForALL formula, also please make sure all nodes are proper as per the YAML code posted in other post.

Thanks.

Was this reply helpful? Yes No
Revl0ck97 44 on at

Like (0)

Report
Hi @ManikandanS , yes the variable contains value.

However, I'm guessing it has something to do with the JSON itself. I'm having a hard time wrapping my head around maybe it's because the value of the varEventsTable after parsing it back to table has all of the operators converted into \u002 and others.

Portion of appended JSON passed from flow:
"body\":\"<html>\\r\\n<head>\\r\\n<meta http-equiv=\\\"Content-Type\\\"
After parsing from string to table node:
“body”:“\u003Chtml\u003E\r\n\u003Chead\u003E\r\n\u003Cmeta http-equiv=\u0022Content-Type\

Was this reply helpful? Yes No
ManikandanS 246 on at

Like (0)

Report

Hello @Revl0ck97 ,

Usually JSON shouldn't contain html tags. Yes, you are correct it has to do something with JSON you are getting from flow, please make sure your flow is returning the response in correct and proper JSON format.

Thanks.

Was this reply helpful? Yes No
Revl0ck97 44 on at

Like (0)

Report
@ManikandanS thanks again,
Since I thought the tags were causing the problem I tried only mapping the subject and start time for now for the custom data to be passed but there is still no response at all from the Generative answers node.

varEventsTable data:
Custom Data:
ForAll(Topic.varEventsTable, { Content: Concatenate(Subject," - ",Start), ContentLocation: Blank() } )

Was this reply helpful? Yes No
ManikandanS 246 on at

Like (1)

Report

Hello @Revl0ck97 ,

I believe you are still missing couple of steps. Please check below steps are present and are correct.

1. Get JSON from flow
2. Create table variable using parse node
3. Fill contents for your table using ForAll formula.
4. Pass the final table content as custom data and generative input as your question

Please update your outcomes.

Was this reply helpful? Yes No
adilei on at

Like (0)

Report

What sort of questions are you hoping the copilot would respond to? Your content seems structured, but Gen Answers works mostly for unstructured content. Can you share some examples for questions and expected answers?

Was this reply helpful? Yes No
Verified answer

Revl0ck97 44 on at

Like (0)

Report
@ManikandanS I was finally able to get it to work. It had nothing to do with the steps as far as I have tested it since all my steps were sufficient.

The issue was with the input. Did some more research and found that the input context is vital (Activity.Text was not applicable for my situation). I tested multiple inputs as well as adding more descriptions in the Content column and now it works.
ForAll(Topic.varEventsTable, { Content: Concatenate("Calendar event subject: ",Subject," - with start datetime of event: ",Start), ContentLocation: Blank() } )

I'm still testing with more combinations of Inputs and Content manipulations to better polish the generative answer output though. Thanks a lot for your help! 😄

Was this reply helpful? Yes No
Revl0ck97 44 on at

Like (0)

Report

Hi @adilei ,

I need the copilot to respond to prompt on viewing their calendar events. Specifically showing them a list of events after specifying number of days from now with which they wish to view. For example: "View calendar updates for this week" and copilot gives a list of all events preferably in ascending start date order.

Yes, the data I'm working with is mostly structured sourcing from Get Calendar Updates (V3) from flows. I've tried working with plugins but they always throw SystemErrors

Was this reply helpful? Yes No
adilei on at

Like (1)

Report

I'm not sure Gen Answers would be the best pattern here, as it assumes you running a search query against an index in the backend and retrieving the top results.

I'll see if I can share a pattern for structured use cases later this week.

Was this reply helpful? Yes No