News and Announcements icon

Power Platform CommunityForums Copilot Studio - General Generative AI Formula ...

Copilot Studio - General

Answered

Generative AI Formula for Data Sources

(0) Share

Report

Report

Posted on by lgera2187

11

In a "create generative answers" node, I saw that in the classic data sources there is the option of manually inputting links to Sharepoint or public websites, and there is also the option to use a Power Fx formula. I have been trying to use a Power Fx formula so that I can use a variable to detemine where the data source is pointing, but so far I have not been able to find a formula that works. The formula I was trying is

Table( ["www.myUrl.com"] )

and other things similar. If anyone knows how to do this properly, or even just how to use a variable for my data source, it would be greatly appreciated.

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

lgera2187 11 on at

Like (0)

Report
Re: Generative AI Formula for Data Sources

I've solved it. The issue was the link I was using and not the formula. I was pointing to a Sharepoint site page (aspx) and not the actual sharepoint. The formula I'm using now is
["sharepointwebsite.com/directory/"]
and it seems to work just fine. I imagine adding more sites to the table will work too.
lgera2187 11 on at

Like (0)

Report

Re: Generative AI Formula for Data Sources

The issue is it expects the data source to be in a Table format. If you use a string it gives and Invalid Type error
Umianta 293 on at

Like (0)

Report

Re: Generative AI Formula for Data Sources

Hi @lgera2187
1. Assign the data source name to the variable

2. then assign that variable to the Generative answer in Fx formula

If this was helpful:
⭐Please mark it as a solution
⭐Give me a thumbs-up
⭐Connect on LinkedIn
⭐I consistently upload technical videos. If you're interested, please visit and subscribe to my YouTube Channel
⭐Always glad to help, Umesh Khandelwal!

Helpful resources

News and Announcements

Important Update on New Community Platform

Quick Links

Leaderboard

#1

WarrenBelz 138,287

#2

RandyHayes 76,308

#3

Pstork1 63,172

Leaderboard

Featured topics

Please Read for Updates on Forums & Blogs

Tips & tricks for using the Power Virtual Agents Boost Conversational Coverage Preview

Product updates

Microsoft Power Platform Community release plans