Copilot Studio : Use Generative Answers on SharePoint List

Videos shows 3 design patterns that you can use to reason over your data within sharepoint list. These design patterns can also be used with any custom data source that you want to connect with your copilot

[@DanielChristian19]

This is a great demo leveraging multiple features in M365 Copilot Studio.

[@ParagDessai]

Thanks Daniel!

[@AudrieGordon]

This is awesome Parag! Thank you!

[@neilokelly9208]

Dude, this is amazing !! Thanks so much

[@user-gi6me5sg2h]

Great video, thank you

[@Juntami]

Great demo on the power of generative answers! Just wondering if there’s a link to a detailed breakdown of the parsing/data manipulation to the required table format in Power Automate?

[@siddh5151]

hey @Parag - one of finest video around this usecases.... !! Can you please share somewhere screenshots of expanded action how are you formatting the custom data json object which you are passing to Generative answer as custom data source in first use case ? so in your example leave request would have 4/5 fields but custom data has to be in format of content, title and location...so what pattern are you using to convert that?

[@siddh5151]

hi @parag - did you get chance to check above comment?

[@joefording4197]

Hello Parag! Great video but we could use some clarification. I am trying to follow along with the first section but I don't know what to do with the variables and how to call them. Could you do a step by step video on how you created the copilot for returning records from the list?

[@fpoire]

Does it work for sharepoint pages ? Thanks for that !

[@manoplaeli4027]

This is very interesting to pass data from power automate. I see you have custom data source with table. Is it passed from power automate? I can only string.

[@ParagDessai]

You can convert your resulting array as string and pass it as JSON to Copilot studio. Here is the example where finalResponse variable is an array of objects returned by API or Sharepoint list : json(string(variables('finalResponse')))

[@user-qh2kc8xw2g]

Great video! How to transfer chat to Microsoft team with information of chat herem

[@jujubalismel]

WOW that's a fantastic video. I've tried to use the solution but I got an error: ‘RecordDataType’, expected type ‘StringDataType. Are you able to share all the steps please? S"

[@ParagDessai]

On power automate side you need to do something like : json(string(variables('finalResponse')))

[@jujubalismel]

@@ParagDessai thank you. I found that my issue it is in hitsContainers, for some reason I can see the correct text in the Parse Json action but I receive null when I tried to utilize the items in hitsContainers. Not sure if is a permission issue. Do you know? Thank you so much!

[@BremenLee]

How do you connect your SharePoint list from CoPilot Studio? CoPilot Studio does not allow more than 2 level deep of the URL or include query string.

[@darespusta]

Copilot Plugins can be used to create a connection to any data source already available in the power platform