User Profile
DylanBrown
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Searching 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?190Views0likes3CommentsRe: 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.4KViews0likes1CommentRe: 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.3KViews0likes0CommentsAuto-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.1KViews0likes6CommentsRe: 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.4KViews0likes7CommentsSetting 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. Thanks1.9KViews0likes12CommentsMoving 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.730Views0likes3CommentsRe: SharePoint (Syntex/Automate) Processing Failed
Thanks for replying so soon Mario, yes it's really odd, it has been working fine and we have been monitoring it over the past few days and today anything that gets upload where the syntex model is applied just doesn't process. I have tried re-training the model, remove the model from the library and re-apply but still having the same issue.1.3KViews0likes3CommentsSharePoint (Syntex/Automate) Processing Failed
We have a system setup where the user uploads a certificate to a library, it then uses power automate to move this to the relevant folder which works fine. Then Syntex works on extracting info from the certificate and populates the columns. For some reason, from today a new column is showing that says "Processing" and anything uploaded is showing as failed. The power automate process works fine but as soon as Syntex tries to extract info it says failed. Any suggestions on how this can be fixed? Thanks1.4KViews0likes5CommentsRe: Sharepoint Search Functionality
Hi Lalit, Thanks for helping with this, I managed to figure out the backend myself and got it working in time which is great. Our 3rd party IT company couldnt assist so thought I'd ask on here. I've made a note of the things you mentioned to further refine what I have set up, thanks for jumping on this.1.7KViews0likes1Comment
Recent Blog Articles
No content to show