Copilot Studio

How to convert whole record to string?

(2) Share

Report

Posted on by PC-16121332-0

Generative answers require the input to be a string and my data is a record. How do I solve this?

Thanks!

Categories:

General topics

I have the same question (4)

All responses (5)

Answers (0)

fchopo 8,003 Moderator on at

Like (0)

Report

Hi,

As you're working with a record, I guess it contains many fields. Which field do you want to read? or Do you want to get all fields concatenated into a single value? Can you share the structure of the record?

Thanks in advance!

Ferran

Was this reply helpful? Yes No
PC-16121332-0 16 on at

Like (0)

Report

Hi @fchopo,

I want to get all the fields concatenated as a single (JSON) string. My record has 30-40 fields and I rather not set them as individual variables.

Was this reply helpful? Yes No
bscarlavai33 752 Super User 2025 Season 2 on at

Like (1)

Report

For the input to the Generative answers action, try using a Formula and pass in your record to the JSON function - "JSON(record)"

Was this reply helpful? Yes No
PC-16121332-0 16 on at

Like (0)

Report

That's not possible unfortunately:

The JSON function cannot serialize objects of type 'Record'.

Text() and ParseJSON() doesn't work either.

Was this reply helpful? Yes No
Suggested answer

Vinoth Selvam 1,590 Super User 2025 Season 2 on at

Like (1)

Report

Hi PC-16121332-0 ,

Yes Generative Answers need input in string only. Passing the Json types will not work.

You will need to build the whole string using Power automate flow and then pass on through the Generative Answers node.

But logically why do we have to pass the whole record as input to Generative answers?

If your requirement is to pass the whole record information, then we need to go for different approach using Custom Actions (or) Custom Prompt (or) even Power automate.

Have you tried using Custom Actions using AI builder to summarize the record . This can give you the result in string format. You can use this summarized data into your generative answers if required.

Ref:

https://msdcentral.site/co-pilot-studio-how-to-use-ai-builder-integrate-with-dataverse-in-co-pilot/

Thanks,

Was this reply helpful? Yes No