Retrieve the Tesla stock price and add it to an Excel (.xlsx) file on SharePoint.

(0) Share

Report

Posted on by CU22080715-1

Hi Everyone,

I am trying to build a simple flow just to test how the Copilot Studio agent works. I created an Excel file with three columns: Ticker, Price, and Date. I want the flow to run every day at 9 AM, retrieve the stock price, and add it to the Excel file I created.

In order to test this flow, I should click on the Test button next to my trigger, right? For some reason, it fails. I want to understand why. Could it be that it doesn’t recognize the rows and that I need to configure the Row field in the Add row into a table connector? If yes, what exactly do I need to do there?

I have the same question (0)

All responses (1)

Answers (0)

Michael E. Gernaey 50,275 Super User 2025 Season 2 on at

Like (0)

Report

Retrieve the Tesla stock price and add it to an Excel (.xlsx) file on SharePoint.

HI @CU22080715-1

So to initially test, you actually have to trigger the flow outside of the Agent, so that it creates an existing instance (run) that you can test with. If you click Test and do not see one to test with it won't work.

If you are able to click Test, then what we need to do is go to the Flow itself by clicking the ... and say Edit in Power Automate.

Once it opens, if you click the back arrow it will go to the Flow Details Page. We need to take a look there so we can see why its failing

Also, when you say it fails, we need more information.

Another way to get to your flow (which appears to be a scheduled flow?) is to go to powerautomate.com, log in, select the environment that your agent and flow are in, click on the three ... on the line of your flow and pick View Details in new tab.

We want to open one of the runs in the 28th day history, and share what is happening there, the flow itself, any errors etc so we can help you out.

Cheers

-Michael

Was this reply helpful? Yes No