Sharepoint List Column Lookup based on other columns
Hi I have 3 Sharepoint Lists 1- System Names 2 - System Access Rights 3 - System Access List 1 has just one Column called Title and has a list of system names that we use as a business. these Values are all unique. For example System 1, System 2, System 3 etc List 2 has 2 columns. System Name - which is a lookup of the above list and Access right name which is a test field. This List lists out all the access types relevant for each System, eg System 1; Payment Inputter System 1; Payment Releaser System 1; System Administrator System 2; Read Only List 3 has 3 columns. Person Name - Person field, System Name - lookup from List 1, Access Rights - which is where I have my question I would like the Access Rights column to be a lookup but only show filtered items relevant to the system selected in the System name column. For Example: John Smith; System 1; This I want to just display Access rights relevant to System 1, using example above Payment Inputter; Payment Releaser; System Administrator and allow user to select relevant right or rights relevant to that person from the lookup list. Hope this makes sense, is this possible?
How to disable/remove the Export to Excel/Power Apps/Flow buttons from a Sharepoint online list
I'm looking for a way to disable/remove the Export to Excel/Power Apps/Flow buttons from a Sharepoint online list, this is so users with read only permissions are not able to access those features. Even removing the Ribbon altogether for read only users would be a solution, switching to the Classic view removes the PowerApps and Flow buttons but users are still able to Export to Excel, any help would be appreciated.
Set tiles layout as default
Hi All, I've probably over looked a simple check box, but how do you set "Tiles" to be the default layout for a view? I've created a new view, set it to Tiles, and applied some very basic formatting to only show the Title center/middle aligned, and selected "save view as" to create a new view, yet whenever the view is opened, it's in list format rather than tile. The end goal is to use this tile view embedded as buttons on a page to filter a document library. Cheers, RobConnection SharePoint List/DocLib to (Azure) SQL data
I'm not a SharePoint dev, but have some experience with SharePoint lists and also SQL. However not in combination. While researching this, I notice "Business Connectivity Services" seems to be the answer. However it seems BCS isn't really actively worked on? Is using this future proof? Lets take this simple example: In a Azure SQL database we have a list of clients. In a SharePoint list I want a choicefield with a dropdownlist populated with the names of these clients.
SPFx Field Customizer - Display totals for calculated columns?
Hello, since I found no way to employ custom column formatting with JSON, I wanted to ask if the following is possible with field customizers before I dove deeper into this. Can a solution be created that displays the sum of a column like this? Example I've not found any solution or code that would work in modern libraries, only in the old UX. Reference 1 Reference 2 Thanks for your answers.Retrieving list data from multiple sub-sites using same site content type with JavaScript
Dear all, I'm running a SharePoint site for projects where every project is created as a sub-site with a number of lists. Each sub-site has a list with one list item including the most important project data. This list is using a Site Content Type. I'd like to pull the data from all those lists and write it to one list on the parent site, e.g. by a weekly run of a workflow or manually. Can this task be done by using JavaScript, Rest API, etc.? Has anybody done something similar? Thanks for your tips.
SharePoint Drop Down List Other Option
Hi We have a Sharepoint List and have a field set to "Choice" In option we have the 3 drop down options with the last one being "other" We have Allow 'Fill-in' choices tick to YES We basically want people to be able to being a list of the top 3 most common options but if they need they can type in a answer. This works, however during testing we noticed that when we put in a manual entry for the "other" it saves it and then next time we add another new list the previously added "other" option is added to the drop down this. eg original drop down option 1 2 3 other Create a new item in the list and during the creation of the entry on the drop down list manually add a entry of 4 When you create another new item you dropdown will now give the following option 1 2 3 4 ** other So 4 was added because there is a item in the list with the number 4 in Is there a way to stop this happening, so the drop down list is always kept to 1 2 3 other But also allow us to manually add a entry?Set-PnPListItem - Multiple User Field
Hey Folks, Trying to update a List item via PowerShell, the column is a multiple user field. The updated users are currently in an array of Email Addresses which is causing an error. Wondering if anyone knows how I could easily convert this to a string or if there's a workaround? Thanks!
