Forum Widgets
Latest Discussions
Include data from Lookup Field in a Calculated Field in Modern SharePoint
I used to use a SharePoint Designer Workflow to include data from a Lookup Field in a Calculated Field. With Modern SharePoint, what is the method I should use to include data from a Lookup Field in a Calculated Field or is there a completely different method I should use to combine data from a Lookup field with another Text Field in a new Field where I can display them as one data set? I cant find anything that discusses new methods using Modern SharePoint. I can only find the Workflow method from Classic SharePoint but I cant use SP Designer anymore so that wont work.
Document library doesn't appear for users in Excel/word
Hi all, I'm trying to make life easier for everyone in our office by having a SharePoint site to store any shared documents rather than saving them in the users OneDrive. However, it's not quite going according to plan. I created the site with a document library etc and added the required members to the site, but I had different results for each user. Some could see the site after browsing all in quick access, some users could see the site in quick access straight away and others couldn't see the site or browse to it at all. I found that sharing one of the document folders with the users, then enabled them to see the site and all folders in the library. Then I discovered that when sharing files, they only had the option to save them in OneDrive and the site didn't display as an option, the only way round that was to save a copy in the SharePoint library and share it from there, which wasn't very helpful. I'm hoping that I've done something really wrong when setting the site up and someone can point me in the right direction, because as it stands using SharePoint really not working as well as I'd hoped.
Sharepoint/Onedrive 300K Files limit
Hello, We are using Sharepoint/Onedrive for 7 users. They are all searching/Editing within 300k Files (600GB) (15 years worth) Im aware of unofficial file count limit of 300K. They are already experiencing issues, like sync issues, Very slow Searching (even with Always keep on Device) Unfortunately they cant archive/remove any of date because they need constant access to all the files, even old ones. Is there anything that can be done, or is there any other solution outside of Microsoft that would be suitable for this scenario? Regards mike
Cannot get values from Column JSON formatting fields not in view
I have a view that displays only 5 of the fields from a SharePoint record. I am unable to access values from other fields that are not currently selected in the view in my JSON formatting logic. If I include the field in the view, and hide the column, the JSON formatting cannot access it either. Is there a way to get those values from JSON formatting logic? I want to have access to all field values for json formatting (tooltip, etc) without having to show the columns in the list view.
Need help creating a modern wiki
Just to give a breakdown. I am trying to create wiki site where visitors can submit articles via forms and it automatically takes the responses and creates a new article page on the site which visitors can browse and search. So far I created a form for submission of articles and a list to store the submissions. I am having trouble with the power automate flow portion. I have configured the trigger when a new item is created in the list, a compose to format the article, an action to create the site page, an update page content with article html action and an auto publish action. I'm not even sure I am creating the flow properly. I am beginner when it comes to SharePoint and power automate. Any suggestions or directions to a guide to where someone has done something like this would be appreciated. In brief I want when users submit their article via a form to be published automatically as a page that others can view. Thank you for your help in advance.
Restrict Document Library so that only specific folders shared with a user are visible to them
We are migrating from Slack to Teams and need a historical archive of our Slack channel conversations. I have an export of my Slack channels (roughly 4000 public channels and 4000 private channels). Each channel is a separate folder with an .html copy of the conversation history of that channel. I want to create two document libraries on a communication site. One for public channels that will be shared with an org-wide group. I plan to move the 4000 public channel folders into there. This is not ideal because scrolling through the list will be very slow but it is the best solution we can think of for this. We plan to educate on how to search efficiently, or use a CoPilot agent to search. The other document library for private channels we want to also share org-wide. However I want to remove inheritance on each folder. And then assign permissions to the folder based on if you were a member of the equivalent channel in Slack. So for instance, I am a member of 40 Slack channels, so I would be granted access to just those 40 channels in the document library. My goal is that a user can access the main sharepoint page, and access the private channels document library, and only see the specific allotment of folders, rather than all 4000. Is this plan feasible? I know there are issues with list view thresholds and potentially drops in performance. How bad might they be? Am I missing anything that could derail this? And permissions management at the folder level after the fact would normally be a nightmare, however in this instance we plan to make this a locked-in-place historical archive. Users would have read-only permissions, and we will never alter the permissions on the site or libraries or folders ever.
Autofill Columns - Managed Metadata
I have a SharePoint document library that has 4 autofill columns, 1 of which is a Managed Metadata column. When I drop a document, the MMD column doesn't complete the first time even though the status says, Finished. If I manually chose AutoFill again, the MMD column completes. Is anyone else experiencing this? Am I doing something wrong or are the limitations with AutoFill MMD columns?Check in issue with Document Library
I am having an issue with files in a document library remaining checked out to the user who edited it - I have raised with MS support who so far have no resolution for this. The files in the document library are all images - all are edited with the default editing feature in SharePoint. When these are edited, they used to save instantly and be visible to all users. Now, upon saving, the image remains "checked out" and needs to be manually checked back in. This is not ideal for my scenario - it needs to be automatic and instant. I do have JSON formatting on this library which is the only difference I can see between this library that doesn't work well, and another on a different site that does what I expect it to. All advanced/version settings have been checked and all are set to NOT required files to be checked out. Does anyone have any guidance as to why the JSON formatting is affecting this? What can I try?