Is it possible to restrict what values a user sees in a lookup column in a Document Library
Hi Guys, Need inputs on a particular requirement that I am struggling with in SharePoint Online Document Library. Here is a Document library, where I have a column named "document department". This is a lookup column to a separate list called "Department" The list "Departments" is below. It has various departments (like Finance, Human Resources, Project Delivery etc). It has department name, department shortcode, etc. REQUIREMENT : --------------------- The requirement is that when a document is uploaded to the document library, the users would select the department from the list of departments. At present, if the user belongs to HR department, they can still see and select other departments in this column. This should NOT be the case. The user should only see the department in that dropdown list, which the user belongs to (Example, HR user should only see the HR in the dropdown, and other options should either be grayed out or not visible). How do I achieve this?
Problems with Group Header Formatting in Sharepoint List
I'm having an couple of issues with formatting the grouped headers of a sharepoint list where the JSON formatting seems to be having an odd effect. The first thing, is when I apply any JSON formatting at all, I lose the ability to click on the headers to filter by that group. This is despite having the default click custom row action included. The second issue is when I change the "hideSelection" field to true, the group heading jumps from it's normal position to half way down the width of the list. If tried setting different padding and position fields, but it always applies from this new position in the middle of the screen. Any advise would be appreciated! { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json", "hideSelection": true, "groupProps": { "headerFormatter": { "elmType": "div", "style": { "padding-left": "12px", "font-size": "16px", "font-weight": "400", "cursor": "pointer", "outline": "0px", "white-space": "nowrap", "text-overflow": "ellipsis" }, "customRowAction": { "action": "defaultClick" }, "children": [ { "elmType": "div", "children": [ { "elmType": "span", "style": { "padding": "5px 5px 5px 5px" }, "txtContent": "@group.fieldData.displayValue" } ] }, { "elmType": "div", "children": [ { "elmType": "div", "style": { "display": "flex", "flex-direction": "row", "justify-content": "center" }, "children": [ { "elmType": "div", "txtContent": "=' (' + @group.count + ')'" } ] } ] } ] } } }'Created by' vs 'App Created by' columns - Sharepoint Lists
Hi All, Can someone please explain the difference between these two columns in sharepoint lists? I have a list of almost 2000 items; the 'Created by' are all people's names, as I would expect, while the majority of 'App Created by' columns are blank. The other values here are Microsoft Power Platform (5 items), and OneDrive SyncEngine (30 items). I have not been able to discover any MS documentation about how/when this is populated. I am assuming that Microsoft Power Platform means it was created via a Power App or Power Automate Flow - any way of discovering which, and if a flow, which flow? OneDrive SyncEngine I have no idea at all and would appreciate knowing for my own interest. Discovery of this has come about by realising we had 5 blank rows in the List - causing Power BI report refresh to fail - as these appeared to be 'duplicates' with no values in the Title column. These 5 rows were all 'App Created by' Microsoft Power Platform or OneDrive Sync Engine. Sharepoint version is 'Sharepoint in Microsoft 365' formerly known as Sharepoint Online Thanks in advance for any help!
Nested Dynamic Filtering on web parts does not work
I created a Sharepoint page and added an MS list web part, which I use as a "filter" selection. Then, I added a second MS list to display the main list of content items, configured with Dynamic filtering based on selecting the "filter" list. Then, I added a Document library web part, which is again configured with Dynamic Filtering based on the selection of the second content item list. Unfortunately, when you select an item from the "filter" list and then select an item from the second "content" list, the document library does not update based on the selection. HOWEVER.. If I select an item from the second "content" list without selecting an item from the "filter" list, the document library updates and shows the filtered content correctly. Any idea why it would not work and how to fix this? Seems like it should workSharePoint List "Lookup" columns not available in Get Items in Flow
I have seen this discussion before (see here) but suggested solutions have not resolved my issue. So, I am looking for some more guidance or suggestions. I have a SharePoint list with a Look-up column. Using Get Items in a cloud flow this field does not display. Setup SharePoint List called "ARB Meetings" SharePoint List called "Decision Register", this has a lookup column to the ARB Meetings list. Get Item Note, I have tried using Limit columns by View and created a new view including the required lookup column, without success. In the Decision Register SharePoint List, there are some items where the ARB Meetings column is blank, I don't know if this could cause an issue? Co-Pilot Help I have asked Co-Pilot for help, which gave me plently of good options I have tried the following without success: If your lookup column is not showing in the Get items action in Power Automate, here are a few steps you can try to resolve the issue: Check List Views: Ensure that the lookup column is included in the default view of your SharePoint list. Sometimes, columns not included in the view might not appear in Power Automate[1]. Refresh the Flow: After adding the lookup column to your list, refresh your Power Automate flow. You might need to close and reopen the flow designer to see the updated columns[2]. Limit Columns by View: In the Get items action, use the Limit columns by view option to select a view that includes the lookup column. This can help ensure that the column is retrieved[2]. Check Column Settings: Verify that the lookup column is properly configured in SharePoint. Ensure it is not hidden or restricted in any way[1]. Pagination Settings: If your list has a large number of items, enable pagination in the Get items action settings. This can help retrieve all items, including those with lookup columns[3]. If these steps don't resolve the issue, you might want to try creating a new flow from scratch to see if the lookup column appears. Sometimes, starting fresh can help Power Automate recognize new or updated columns. Let me know if you need further assistance or if there's anything else I can help with! References [1] Solved: Get items not showing lookup column - Power Platform Community [2] Solved: Missing Columns from SharePoint List in Flow - Power Platform ... [3] In-depth analysis into 'Get items' and 'Get files' SharePoint actions ... Thank-you, IreneSharePoint Online List views not appearing in the List Web part
Hi I'm hoping someone could help me with a problem I have just hit within SharePoint Online relating to List views (this includes custom list views) no appearing in the List webpart drop down for selecting the web parts source. This was working fine but I created a new communication site which I was intending to make a site template out of, I populated the Document list with some test files then created a custom view saving it as Template List : I then create a page within the site to house the template list via the webpart list view. I add the List web part but then when I select it to do the configuration the List drop down is empty : I have created creating a second document library and adding some test files to it then creating a custom view in that document library on the same site but this wont appear either. At first I thought it might of just been a badly created communication site but a site I made months ago also has this same issue. Any guidance or setting to check to resolves this would be greatly appreciated. Cheers; NeilHow to use the new Microsoft Lists features [New Feature 2024]
:loudspeaker: New Features in Microsoft Lists :megaphone: Exciting news for Microsoft SharePoint users! The latest update brings enhancements to Lists, boosting overall performance and introducing new features. Now, you can easily add ratings to any list, seamlessly drag or paste images directly into a list, collaborate in real-time with visibility on who is working alongside you, switch views effortlessly by clicking tabs, and enjoy more functionalities. Keep your Lists organized and efficient with these new capabilities! #MicrosoftLists #Lists #SharePoint #Teams #Microsoft365SharePoint List - Count People Column
I'm wondering if it's possible to have one column display a running count of the number of people in a people column? Use-case: I'm creating a Professional Development SharePoint site and a List to track what trainings are available. I have a column called Maximum Attendees, and I need a column to count from the Registered Attendees so I can make another column to count how many seats are left. I've tried a Calculated Value, but People columns aren't available to use.
Add button to Sharepoint list to generate an email draft with selected users' emails in bcc
I'm currently trying to replicate in Sharepoint 365, via power automate, a functionality that I had developed in a JS snippet in the old sharepoint 2013 on a Email ditribution list page. My snippet code was this: <input onclick="SendMailToSelcted();" type="button" value="Send E-Mail"> <br> <script language="javascript" type="text/javascript"> function SendMailToSelcted() { var items = SP.ListOperation.Selection.getSelectedItems(); var ctx = SP.ClientContext.get_current(); var web = ctx.get_web(); var currentListGUID = SP.ListOperation.Selection.getSelectedList(); var list = web.get_lists().getById(currentListGUID); var rows = new Array(); for(var i = 0; i < items.length; i++) { var row = list.getItemById(items[i].id); ctx.load(row); rows.push(row); } ctx.executeQueryAsync(function () { var ids = ''; for (var i = 0; i < rows.length; i++) { var r = rows[i]; ids += r.get_item('cs6w') + ';' ; } document.location='mailto:' + '?bcc=' + ids ; }, function(sender, args) { alert('Request failed. \nError: ' + args.get_message() + '\nStackTrace: ' + args.get_stackTrace()); }); } </script> This snippet is no more allowed in my actual SP365. The functionality was: once selected different users out of the sharepoint list (with email address availble on their records), when a button at the top of the list is clicked(snippet), an outlook email draft should be created with all selected users' emails filled in "bcc" field. The user has to edit each time that generated email draft with subject and text and send it. I'm now not aware how to replicate it in Sharepoint 365 List through power automate and its flows. Any suggestion is really appriciated! Thanks Max
