Sharepoint Lists adding item level permissions trouble
Hi All, I have what seems to be a simple ask but can't figure out a solution. Existing current access level settings: The above settings allow the user (lets call him User A) to create and edit only items created by them. 2 questions: 1) Is it possible for User A to grant permissions to User B to edit one or more of his items? 2) Is it possible for an admin and/or list owner to prepopulate items on behalf of User A and User B and allowing then to view and edit them - keeping in mind above settings, users can only see and edit items they created Thanks
Combine different list items (from the same list) into single item
Good Afternoon!, I have a list in SharePoint which has multiple items, and I need the three newest items to be combined into a new item and then to delete those three. None of the columns have info that overlaps, so it should be relatively straightforward considering I don't need to combine text values. Any assistance would be greatly appreciated.
JSON Header Formatting Issue
Hello, I am having trouble with the code below. This code is adjusted from https://github.com/rdorrani/SharePoint/blob/master/TravelRequest/headerformatting.json header formatting. Here are the issues I am having: Manager Approval-->Not Approved: I would like for this to be red. The entire circle disappears when I try to adjust the "Not Approved" code Ethics Approval: This code works just fine. I would like to know how to delete the HR approval codes without jeopardizing the ethics approver code. For example, when I remove everything that has to do with HR Approval, the entire circle disappears (Fig 1) SNL Approval: This circle stays green even if their is nothing in the column. If someone's name is entered in the column "SNL Approver Name", then it should be green, like Ethics Approval. I tried using the same code as the Ethics Approval but it does not work. (The approver name column for this one is "Person Group' while Ethics is "Single Line Text") I would also like to get rid of the unnecessary HR approval codes (circle disappears when adjusting it) Fig. 1 { "elmType": "div", "attributes": { "iconName": "=if([$Ethics_Approver_Name] != '' ,'CompletedSolid' ,'CircleShapeSolid'))", "class": "=if([$Ethics_Approver_Name] != '' ,'ms-fontSize-42 ms-fontColor-green',if([$Ethics_Approver_Name] == '' ,'ms-fontSize-42 ms-fontColor-yellow','ms-fontSize-42 ms-fontColor-neutralTertiary'))" } { "elmType": "div", "style": { "margin": "5px", "width": "100%", "height": "160px", "border": "2px dashed", "padding": "10px", "display": "flex", "flex-direction": "column", "align-items": "center" }, "children": [ { "elmType": "div", "txtContent": "Project Initiation (PI)", "attributes": { "class": "ms-fontSize-28 ms-fontWeight-bold" } }, { "elmType": "div", "style": { "display": "flex", "justify-content": "center", "width": "100%" }, "children": [ { "elmType": "div", "style": { "display": "flex", "flex-direction": "row" }, "children": [ { "elmType": "div", "style": { "width": "140px", "display": "flex", "flex-direction": "column", "align-items": "center", "margin": "20px" }, "children": [ { "elmType": "div", "txtContent": "Manager Approval", "style": { "margin-bottom": "5px" }, "attributes": { "class": "ms-fontSize-15" } }, { "elmType": "div", "attributes": { "iconName": "=if([$Manager_Approval] == 'Approved' ,'CompletedSolid', if([$AD_Approval] == 'Not Approved' ,'CompletedSolid' , 'CircleShapeSolid'))", "class": "=if([$Manager_Approval] == 'Approved' ,'ms-fontSize-42 ms-fontColor-green', if([$AD_Approval] == 'Approved' ,'ms-fontSize-42 ms-fontColor-green',if([$AD_Approval] == 'Pending AD Approval' ,'ms-fontSize-42 ms-fontColor-yellow',if([$AD_Approval] == 'Not Approved' ,'ms-fontSize-42 ms-fontColor-yellow',if([$Manager_Approval] == 'Pending Manager Approval' , 'ms-fontSize-42 ms-fontColor-yellow' ,if([$Manager_Approval] == 'Not Approved' , 'ms-fontSize-42 ms-fontColor-red' , 'ms-fontSize-42 ms-fontColor-neutralTertiary'))))))" } } ] }, { "elmType": "div", "style": { "width": "80px", "display": "flex", "flex-direction": "column", "align-items": "center", "margin-top": "50px" }, "txtContent": "---------->", "attributes": { "class": "ms-fontSize-16" } }, { "elmType": "div", "style": { "width": "120px", "display": "flex", "flex-direction": "column", "align-items": "center", "margin": "20px" }, "children": [ { "elmType": "div", "txtContent": "🧐AD Approval", "style": { "margin-bottom": "5px" }, "attributes": { "class": "ms-fontSize-15" } }, { "elmType": "div", "attributes": { "iconName": "=if([$AD_Approval] == 'Approved' ,'CompletedSolid' , 'CircleShapeSolid')", "class": "=if([$AD_Approval] == 'Approved' ,'ms-fontSize-42 ms-fontColor-green',if([$AD_Approval] == 'Pending AD Approval' , 'ms-fontSize-42 ms-fontColor-yellow' ,if([$AD_Approval] == 'Not Approved' , 'ms-fontSize-42 ms-fontColor-red' , 'ms-fontSize-42 ms-fontColor-neutralTertiary'))" } } ] }, { "elmType": "div", "style": { "width": "80px", "display": "flex", "flex-direction": "column", "align-items": "center", "margin-top": "50px" }, "txtContent": "---------->", "attributes": { "class": "ms-fontSize-16" } }, { "elmType": "div", "style": { "width": "140px", "display": "flex", "flex-direction": "column", "align-items": "center", "margin": "20px" }, "children": [ { "elmType": "div", "txtContent": "Ethics Approval", "style": { "margin-bottom": "5px" }, "attributes": { "class": "ms-fontSize-15" } }, { "elmType": "div", "attributes": { "iconName": "=if([$Ethics_Approver_Name] != '' ,'CompletedSolid' ,if([$ApprovalStatus] == 'Rejected by HR' ,'CompletedSolid' , if([$ApprovalStatus] == 'Pending HR Approval' ,'CompletedSolid' ,'CircleShapeSolid')))", "class": "=if([$Ethics_Approver_Name] != '' ,'ms-fontSize-42 ms-fontColor-green', if([$Ethics_Approver_Name] == '' ,'ms-fontSize-42 ms-fontColor-yellow', if([$ApprovalStatus] == 'Pending HR Approval' ,'ms-fontSize-42 ms-fontColor-green',if([$ApprovalStatus] == 'Rejected by HR' ,'ms-fontSize-42 ms-fontColor-green',if([$ApprovalStatus] == 'Pending Manager Approval' , 'ms-fontSize-42 ms-fontColor-yellow' ,if([$ApprovalStatus] == 'Rejected by Manager' , 'ms-fontSize-42 ms-fontColor-red' , 'ms-fontSize-42 ms-fontColor-neutralTertiary')))))" } } ] }, { "elmType": "div", "style": { "width": "80px", "display": "=if([$Are_x0020_you_x0020_using_x0020_] =='CSI','block', 'none')", "flex-direction": "column", "align-items": "center", "margin-top": "50px" }, "txtContent": "---------->", "attributes": { "class": "ms-fontSize-16" } }, { "elmType": "div", "style": { "width": "120px", "display": "=if([$Are_x0020_you_x0020_using_x0020_] =='CSI','block', 'none')", "flex-direction": "column", "align-items": "center", "margin": "20px" }, "children": [ { "elmType": "div", "txtContent": "SNL Approval", "style": { "display": "=if([$Are_x0020_you_x0020_using_x0020_] =='CSI','block', 'none')", "margin-bottom": "5px" }, "attributes": { "class": "ms-fontSize-15" } }, { "elmType": "div", "attributes": { "iconName": "=if([$SNL_Approver_Name] != '' ,'CompletedSolid' , 'CircleShapeSolid')", "class": "=if([$SNL_Approver_Name] != '' ,'ms-fontSize-42 ms-fontColor-green',if([$ApprovalStatus] == 'Pending HR Approval' , 'ms-fontSize-42 ms-fontColor-yellow' ,if([$ApprovalStatus] == 'Rejected by HR' , 'ms-fontSize-42 ms-fontColor-red' , 'ms-fontSize-42 ms-fontColor-neutralTertiary'))" } } ] } ] } ] } ] }Pulling Data from SharePoint List into Excel
Hi, I have successfully pulled data from SharePoint List into excel using "Get Data from Online Sources" for further analytics. One issue I am running into is in regards to certain data types. It appears when certain columns of data where multiple choices can be returned for data in the column, it appears in excel as [List] instead of showing what might have actually been returned in the SharePoint List. Is there a way to correct this?Someone has deleted Sharepoint list entries - Who?
Hi Everyone I am using a sharepoint site my IT have set up for me, and created a list. I have special access to allow all to see the list, but only the line item creator and approver to view the contents of that list line item. Someone has deleted 3 items - which makes me think it is the line item creator. But i have no way of reviewing it. There is no way to get up version control on a deleted item, there is nothing in recycle bin, no record of it on activity tracker etc. Surely there must be something front or back on the system that records this kind of thing? Any help much appreciated."Customize with PowerApps" loads App from another SharePoint site
Hello, I hope someone may be able to make sense of my title of this post; this is something I have never come across before so if anyone can help that would be fantastic. Project Introduction I am currently working on a project where my client requires individual SharePoint sites for each of their customers (companies) to host a quality management system, each site accessible by multiple people within that company. Each QMS site is customised to the end customer depending on their equipment, methods, etc. and making each one was becoming a tedious copy & paste festival. I managed to make a base site and through LOTS of research was able to create a template site (.wsp file) I could upload and save myself a lot of time only having to make small adjustments and uploading previous QMS related files. Now, here's the problem: Three of the lists within each QMS were customised with PowerApps to aid with things like validation, calculation and user-friendliness (I know there are other ways to do this in SP out of the box, but my client liked the aesthetics of the PowerApps). The issue is now that when I go to a list and choose "Customize with PowerApps", PowerApps loads the version from the original site where the template was made and is the same for all other sites created using this .wsp file. Self-Diagnosis Being no stranger to computers I did some self-diagnosing to see if I could find the issue. Firstly I looked in the list settings / form settings to determine if any links where visible. No trace of the app and unable to choose the middle option at all. (yes, the link there does the same) Secondly I looked in the site settings to see if there is anything that would indicate links; I couldn't find anything, I may be blind. Thirdly, I looked at the .wsp file in Notepad++ to see if any traces of the apps where transferred over and sure enough, there they were, IDs matched the PowerApps' IDs. Naturally I looked in the Site Contents, Site Settings and copied the URL but to no avail. Finally, I used SharePoint Designer 2013 (SP1) to gain access to the site, and found them: So I did what any normal person would do and deleted the whole folder to see if this would manually clear the cache and allow PowerApps to generate a whole new application. And would you believe it...it didn't work! I tried refreshing the site, clearing my browser's cache, waiting several hours/days but PowerApps still loads the app from the original template site. I've done a site wide search within SP Designer using the PowerApp IDs but with no luck. The Plea If anyone could help, provide a solution or shed some light as to what it is doing; it would be greatly appreciated. I've been at this for days with no luck, and at this point I'm wondering if its not possible. Thank you kindly, Jodie.
SharePoint list filter pane - numerical range
Hi, The modern list filter pane displays a range control for dates as can be seen in the Microsoft documentation here: https://support.microsoft.com/en-us/office/what-is-the-list-and-library-filters-pane-293561ed-fb2e-4fb2-9a9f-8a21e299e323 My question is we have a number column with many different numerical values, instead of all of the different individual values displayed as checkboxes is it possible to configure this to be displayed as a similar range control? Thanks
