SharePoint 2019 On Premise: Cascading Drop Down + Lookup Field
Hi there, I tried this feature. I have a list with two "LOOKUP" fields. Let's say one is a "project code" and the other is a task. When users create a new project in the list, they can select a "Project Code" and a "Task." If you select "Project Code" in this part, it will be judged whether the project code contains "BM". If so, then "Task Id" will get "Task Id" starting with "A". If the project code contains "S", get the "Task Id" starting with "S". I added JavaScript to newform.aspx to achieve this. JavaScript looks like this. Now, I ran into a problem which is when I changed the "Project Code", the JavaScript ($(projectCodeDropdownId).change(function() ... ) cannot be triggered. So I ask the expert to help me share some idea/ thoughts/ solutions on this. Thanks. $(document).ready(function() { // Replace with the actual ID of your Project Code dropdown var projectCodeDropdownId = 'Project_x0020_Code_576bd655-c475-412d-bd61-8164571f6726_$LookupField'; var tasksCodeDropdownId = 'Tasks_09d67b50-12ae-4d0c-b3e0-b83d615baa8a_$LookupField'; $(projectCodeDropdownId).change(function() { var selectedProjectCode = $(this).val(); var taskPrefix = ''; // Determine the task prefix based on the project code prefix if (selectedProjectCode.startsWith('BM')) { taskPrefix = 'A'; } else if (selectedProjectCode.startsWith('S')) { taskPrefix = 'S'; } // Filter tasks based on the determined prefix $.ajax({ url: '/_vti_bin/listdata.svc/Tasks?$filter=startswith(Code, \'' + taskPrefix + '\')', method: 'GET', headers: { 'Accept': 'application/json;odata=verbose' }, success: function(data) { var tasksDropdown = $(tasksCodeDropdownId); tasksDropdown.empty(); $.each(data.d.results, function(index, task) { tasksDropdown.append('<option value="' + task.Id + '">' + task.Title + '</option>'); }); } }); }); });
Sharepoint conditional formatting not applying to item view
Hello, I require some help with a sharepoint list that I have setup to track issues. I have a column that has a priority label: Low, Medium or High based on a number value. I have setup a conditional formatting see below in list view: However, this conditional formatting does not show in the item view see below: Is anyone able to tell me why and how do i correct this? Many thanks
Sharepoint Online error when editing a listitem e.split is not a function
Hello, am having a issue with a list that is used on a daily basis by a team of people. We discovered the other day we can no longer make edits (I am the admin of the site and others with edit rights have the same issue). When we double click on the list item for editing it gives the error below. I have researched online and found advice to try the edit in private or incognito mode and indeed this works. But its not a longer term fix. I also tried to save a new view copy, but it had the same editing error. Can you advise on how to fix this error? Could it be browser update related?
Default value in people column
Hello, I would like to ask for advice. How can I set up a SharePoint list so that when a new item is created through a form, two specific employees are automatically added to a specific "people" column? I already have a fairly complex Power Automate flow working with the "when a new item is created" event, and I would prefer not to modify it. Ideally, I am looking for a way to populate these employees into the SharePoint list directly when filling out the form, without using Power Automate. Is it possible? Best Regards, JanNested 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 work
Swapping a root site, but maintaining a list
Hi all, We are swapping our dated root site for a modern site. Our current root site was created back in 2016, and uses SharePoint classic. We plan to swap for a modern site and launch with a fresh look for our organization's intranet. I understand when swapping a root site, the initial root site's site collection is archived. Including lists. We have an expansive IT Intake list on our current root site, which includes workflows that send email approvals, as well as Jira integrations. We still use this IT Intake list. Is there any way to preserve the IT Intake list and/or migrate it, its workflows, and content onto the new root site without losing any data or duplicating our efforts? I have seen that you can extract the list and import it to a new list, but this is not ideal. As a note: we cannot use third-party migration tools at this time. Thanks!Regarding the "App Catalog" in SharePoint 2019
Hi there, When the customization (ListView Command Set extension: Microsoft Sample: Build your first ListView Command Set extension | Microsoft Learn) was done, and it was uploaded to the App Catalog (http://win-xxxxx:19065/sites/apps), everything was well. And I also can "Add an App" in the "Site Content" But I cannot find any changes in my list in "http://win-xxxxx:19065/", I try to create a new list, and the custom function went well in App Catalog (http://win-xxxxx:19065/sites/apps). Even I want to "Add an App" in "http://win-xxxxx:19065/", I also cannot find the new App in "App you can add". Is there any idea on this? or which steps was ignored? Thanks
How to connect SharePoint with third party ERP system(eMagic)
Hi All, I want to know if there is any way to connect SharePoint with third party ERP system example (eMagic), as if user add items in SharePoint it should be reflect in ERP system and if some data add in ERP then it should be reflect in SharePoint. If someone have answer for this question please provide me a solution. Thank you...
