u/Syren6

API calls in the new experience

REST API was in the old experience. I can't find it anywhere in the new experience. Is this a feature that is coming back?

reddit.com
u/Syren6 — 1 day ago

Excel files

Why is Copilot Studio so inconsistent (/terrible) with reading Excel files? My agent extracts data from spreadsheets users load by drag and drop. These are not complicated files - no formulae, just a few tables of hard coded numbers. The agent is needed because different suppliers have their own formats and different naming contentions. An LLM agent is a good way of dealing with this kind of inconsistent data to pull out the data we actually need.

But it's just so inconsistent. The new experience is better than the old studio but still. Sometimes it will just work perfectly. But maybe a third of files Copilot says it only has access to the metadata not the file contents. And in the same chat it will work on some files but not others. And it's not the files themselves - all the files have been read at some point successfully, just not always.

It's so annoying. Every other AI will just work and read the files. Even normal copilot can read them fine. Just Studio fails for some reason. I just don't understand how Microsoft can't read files from their own products.

Anyone had this and know of a fix?

reddit.com
u/Syren6 — 1 month ago