User Profile
DylanBrown
Brass Contributor
Joined Nov 14, 2022
User Widgets
Recent Discussions
Re: CoPilot Agents - Word Tables
Thanks for replying SharmaNeeraj, my question/aim is: Find out how to make my agent produce a response similar to using the researcher agent, i.e more in depth, better searching and a more well thought out answer. Why can my custom agent not read tables within Word but Researcher can. I have put some time into writing the description and instruction and am certain that can't be affecting the outcome, it seems to be the actual way the agent is bringing back the data. I.e on Researcher it will read the project docs and give me the top 10 risks it can spot based on the documents, whereas the agent doesn't do this, yet I'm giving it the same prompt, word for word. Thanks94Views0likes0CommentsCoPilot Agents - Word Tables
Hi, We have been trying to create a CoPilot agent within the business that can read data in a referenced folder within SharePoint and output a summary. Now the prompt I'm using works perfectly when using the "Researcher" agent within CoPilot, but when I use it in the agent the output is very different. For added context. I have made a SharePoint site which has a folder for each project and then all the docs relating to that project within. The user says to the agent, "give me a project overview for QXXXX", what should happen is, the agent finds that folder, which it's seemingly doing and it provides all the info in the layout I've mentioned in the prompt. So it can find the right folder, and it gives a good overview of the project. But any information that's within a table in word, it doesn't retrieve, I've even told it what document has the content in the table it should be bringing back and it says it can't read tables in Word. When I've researched this it seems to be the way CoPilot interprets the data is different depending whether you upload the file or just reference it like my agent is doing. Then in Researcher alternatively, I copy and paste the prompt into the text box, attach cloud files and select the project folder and the output is perfect. It retrieves all the content, dates etc and it's exactly what we need. My aim was to make an agent that can do the same but doesn't require the user to attach the folder, they can just give it the project number and it does it's thing. I'm still pretty new to agents, and appreciate it's still slightly new, but it doesn't feel like it should be doing that. Would anyone with some expertise in agents be able to assist in me fixing this? And if possible, be available via email for me to ask some further questions? Happy to provide any further information if needed. ThanksRe: Making CoPilot Work for our Organisation
Appreciate you commenting on here Peter, really useful comments, understand points 1-3. Just a few follow up questions based on what you have said for point 4: Regarding point 4, so I did actually work on making a dedicated bid assistant bot which was accessible via a Teams chat. The one stumbling block I have, is the way it's accessing the information. I'm not 100% certain on CoPilot's brain, in how it actually finds the information based off what you ask it. Is it just looking at the first 20 docs it thinks are relevant or does it already know what is relevant/not relevant and searches everything. Also, in terms of producing documents in branded formats with the right font, colours etc. I've done some research on this and I can't find any examples of this actually working and giving you back a document just based off a prompt.112Views0likes1CommentMaking CoPilot Work for our Organisation
We're currently exploring how Microsoft Copilot can be used to support our bid writing process, and I’d really appreciate some insights or examples from others who’ve tried anything similar or just have a good understanding of CoPilot. What We’re Trying to Do We’d like Copilot to help us write and draft bid responses by referencing information already stored across our SharePoint libraries — including past bids, case studies, and company information — and then generate new content in our tone, structure, and style. In essence, we want Copilot to act like an “internal bid writer” that knows our history and can draw on it intelligently when producing answers. What We’re Trying to Understand I’m trying to get clarity on a few key things: What does GPT-5.0 actually bring to Copilot — is it just better reasoning and writing, or does it enable deeper integration with our Microsoft 365 data? What do we need to do (technically or in terms of setup) to let Copilot “see” our environment — e.g., access our SharePoint libraries and use that content effectively? I've saw some things around Microsoft Graph being enabled. What’s the practical difference between using Copilot and using ChatGPT for this type of work? We’ve also tried getting Copilot to fill in Excel sheets using data from SharePoint, but it doesn’t seem to behave as we expected. Is this something Copilot can’t currently do, or are we just approaching it the wrong way? What We’d Love to Learn What are the best practices for helping Copilot understand and use your SharePoint content effectively? Has anyone successfully used Copilot for bids, PQQs, tenders, or document generation? Any examples or use cases you can share of how you’ve made Copilot genuinely useful in a business context would be hugely appreciated. Thanks in advance — it’d be great to hear how others are making the most of Copilot in real-world scenarios.SolvedSearching on SharePoint via Tags
Hi All, I have recently set up some tags through the term store and have started to apply them to documents within my SharePoint Document Library. When searching for them, I have been using the filter, selecting "Tags" and then listing all the tags I'm looking for. The issue is, it returns any document that contains any of the tags I list when I want it to only list documents that have all of those tags attached. I did some research and it seems as though it isn't something you can amend, so the work around was to set up a custom search page and add a filter that allows the user to click what tags they want to search for. I added a custom PnP Modern Search Web Part which I think may give me what I need but when I add it I get the below error message? Any ideas?346Views0likes3CommentsRe: Auto-scroll an Excel workbook
Ah nevermind, I didn't put it in a new module, that seems to be working now, thank you. Is there any risk of excel crashing if this is set to this permanent? Also, we have this document in a shared library, so people will be adding data to it, if this is opened whilst people make amendments will it update live or will I need to add some VBA to update the doc every minute for example? Thanks1.7KViews0likes1CommentRe: Auto-scroll an Excel workbook
I have done a little VBA a while ago but not for anything like this. Would I need some sort of trigger to start the scrolling? I'm planning on having this always on on the TV so it doesn't turn off but just in case it does I don't want it to be a nightmare to start the code again. I'm just reading through this one that you shared now - https://www.automateexcel.com/vba/scroll/ Little confused where to start.1.4KViews0likes0CommentsAuto-scroll an Excel workbook
Hi Guys, Looking for some assistance, I am hooking up a mini PC to a Samsung Smart TV to display an Excel spreadsheet, bascially highlights what projects we have on and some info in a table. The issue is, it won't all fit on one page, is there anyway of the workbook auto scrolling to the bottom of the table and then starting from the top again? I'm presuming you can through VBA but not used it too much so if someone has a guide or a method of doing this so it looks professional in the office please let me know. Just incase this matters too, this document will be stored on a sharepoint site and opened live, not sure if the VBA carries over but users will be updating this table via their own machines and hopefully the one on the TV will update automatically. ThanksSolved2.7KViews0likes6CommentsRe: Setting up set lock screen for all IOS Tablets
Ah ok, yes so we purchased 16 through our supplier who set them up on ABM, these were then brought across into Intune so not sure why this wouldn't be classified as supervised? The middle link you sent is actually the one I followed when setting them up. Very strange1.1KViews0likes3CommentsRe: Setting up set lock screen for all IOS Tablets
I managed to find this and set the group up, but when I check the enrolled devices they still show as Non-Applicable on whether the lock screen policy is applied or not. I changed the Lock Screen policy to enable for the group I have set up and that group says it contains this device. Any ideas?1.6KViews0likes7CommentsSetting up set lock screen for all IOS Tablets
I'm relatively new to Intune and have managed to set up all 16 of our tablets on Intune. Is there a way to set a default lock screen to these devices? I have tried this through the policies but can't find a way to do it. Any help would be appreciated. Thanks2.3KViews0likes12CommentsMoving Text Based on Cell Sum
Morning, I'm trying to figure out how I can move text based off a number. As you can see there are 5 points on the left hand side, next to each is a column for S (Severity) and L (Likelihood), the final column = R(Risk) SXL = R. This gives me a number in the final column, if the number is between 1-3 then its Low, 4-6 is medium and 7-9 is high. From this point I want it to highlight the relevant cell underneath to show on average what the figures are, for example, if 3 of the numbers are in the high bracket then highlight the "High" box below red etc. From here, there is "Additional Control Measures" underneath, for any of the points above that are in the high category I want this to copy the text form here and copy into the first cell in additional control measures. No idea how to do this. Any help would be greatly appreciated. Below is an example.827Views0likes3Comments
Recent Blog Articles
No content to show